eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_AV_STND_UNIT_ALL

Object Details

Object Name:	IGS_AV_STND_UNIT_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_AV_STND_UNIT_ALL
Subobject Name:
Status:	VALID

IGS_AV_STND_UNIT_ALL describes a unit granted as advanced standing.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AV_STND_UNIT_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AV_STND_UNIT_ID
IGS_AV_STND_UNIT_ALL_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID AS_COURSE_CD AS_VERSION_NUMBER S_ADV_STND_TYPE UNIT_CD VERSION_NUMBER EXEMPTION_INSTITUTION_CD UNIT_DETAILS_ID TST_RSLT_DTLS_ID
IGS_AV_STND_UNIT_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_CD VERSION_NUMBER
IGS_AV_STND_UNIT_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AS_COURSE_CD AS_VERSION_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Describes the ID that uniquely identifies a person.
AS_COURSE_CD	VARCHAR2	(6)	Yes	Describes the program against advanced standing that isapproved or granted.
AS_VERSION_NUMBER	NUMBER	(3)	Yes	Describes the version number of the program against advanced standing that is approved or granted.
S_ADV_STND_TYPE	VARCHAR2	(10)	Yes	Describes the type of advanced standing.
UNIT_CD	VARCHAR2	(10)	Yes	Identifies the unit the student is being given in advanced standing.
VERSION_NUMBER	NUMBER	(3)	Yes	Identifies each version of a unit uniquely with version number.
S_ADV_STND_GRANTING_STATUS	VARCHAR2	(30)	Yes	Describes the granting status of the advanced standingunit record. For example, CANCELLED, GRANTED, REVOKED.
APPROVED_DT	DATE		Yes	Describes the date unit was approved for advanced standing purposes.
AUTHORISING_PERSON_ID	NUMBER	(15)	Yes	Describes the Person ID of the officer who authorisedthe advanced standing.
CRS_GROUP_IND	VARCHAR2	(1)	Yes	Describes whether the unit is to be regarded as program-grouped. Setting the indicator to checked means that the unit is program-grouped.
EXEMPTION_INSTITUTION_CD	VARCHAR2	(30)	Yes	Describes the institution student undertook the study that resulted in the unit advanced standing.
GRANTED_DT	DATE			Describes the date the granting status of the unit was changed to GRANTED.
EXPIRY_DT	DATE			Describes the date, the approval for the advanced standing unit level expired.
CANCELLED_DT	DATE			Describes the date the granting status of the unit was changed to CANCELLED.
REVOKED_DT	DATE			Describes the date the granting status of the unit was changed to REVOKED.
COMMENTS	VARCHAR2	(2000)		Provides comments about the advanced standing unit.
CREDIT_PERCENTAGE	NUMBER	(5)		Describes the percentage of credit for the unit that is to be granted as advanced standing. --Obsolete
S_ADV_STND_RECOGNITION_TYPE	VARCHAR2	(30)	Yes	Describes the available types of recognition that apply to the units, unit sets that form the advanced standing.
AV_STND_UNIT_ID	NUMBER	(15)	Yes	System Generated number to store the primary key
CAL_TYPE	VARCHAR2	(10)		This will store the Calender Type
CI_SEQUENCE_NUMBER	NUMBER	(6)		This will store the Sequence Number
INSTITUTION_CD	VARCHAR2	(30)		Institution Code. For many-many relationship.
PREV_UNIT_CD	VARCHAR2	(15)		Previous Unit Code. This is the Key to the many-many relationship. It stores AHV,prev_unit_id. --Oboleted.
TEST_SEGMENT_ID	VARCHAR2	(15)		Test Segment ID. This is the Key to the many-many relationship. --Oboleted.
UNIT_DETAILS_ID	NUMBER	(15)		Prevoius unit identifier
TST_RSLT_DTLS_ID	NUMBER	(15)		Test segment identifier
GRADING_SCHEMA_CD	VARCHAR2	(10)		This will store the Grade Schema Code.
GRD_SCH_VERSION_NUMBER	NUMBER	(3)		This will store the valid Pass Grade belong to the above grading Schema.
GRADE	VARCHAR2	(5)		This will store the Grade details, should be a valid grade.
ACHIEVABLE_CREDIT_POINTS	NUMBER	(6)		This will store the Credit Point Granted details.
DEG_AUD_DETAIL_ID	NUMBER			Degree Audit Details ID
ORG_ID	NUMBER	(15)		Operating unit identifier
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERSON_ID
,      AS_COURSE_CD
,      AS_VERSION_NUMBER
,      S_ADV_STND_TYPE
,      UNIT_CD
,      VERSION_NUMBER
,      S_ADV_STND_GRANTING_STATUS
,      APPROVED_DT
,      AUTHORISING_PERSON_ID
,      CRS_GROUP_IND
,      EXEMPTION_INSTITUTION_CD
,      GRANTED_DT
,      EXPIRY_DT
,      CANCELLED_DT
,      REVOKED_DT
,      COMMENTS
,      CREDIT_PERCENTAGE
,      S_ADV_STND_RECOGNITION_TYPE
,      AV_STND_UNIT_ID
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      INSTITUTION_CD
,      PREV_UNIT_CD
,      TEST_SEGMENT_ID
,      UNIT_DETAILS_ID
,      TST_RSLT_DTLS_ID
,      GRADING_SCHEMA_CD
,      GRD_SCH_VERSION_NUMBER
,      GRADE
,      ACHIEVABLE_CREDIT_POINTS
,      DEG_AUD_DETAIL_ID
,      ORG_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AV_STND_UNIT_ALL;

Dependencies

[top of page]

IGS.IGS_AV_STND_UNIT_ALL does not reference any database object

IGS.IGS_AV_STND_UNIT_ALL is referenced by following:

APPS: IGS_AV_STND_UNIT_ALL