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_LVL_ALL

Object Details

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

IGS_AV_STND_UNIT_LVL_ALL describes the number of advanced standing credit points granted to a student at a given level.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AV_STND_UNIT_LVL_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AV_STND_UNIT_LVL_ID
IGS_AV_STND_UNIT_LVL_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXEMPTION_INSTITUTION_CD
IGS_AV_STND_UNIT_LVL_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_LEVEL
IGS_AV_STND_UNIT_LVL_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AS_COURSE_CD AS_VERSION_NUMBER
IGS_AV_STND_UNIT_LVL_ALL_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID AS_COURSE_CD AS_VERSION_NUMBER S_ADV_STND_TYPE UNIT_LEVEL CRS_GROUP_IND EXEMPTION_INSTITUTION_CD UNIT_DETAILS_ID TST_RSLT_DTLS_ID QUAL_DETS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
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
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 is approved 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_LEVEL	VARCHAR2	(4)	Yes	Describes the level that advanced standing is being given. For example, first year level within a program, 2 - second year level within a program.
CRS_GROUP_IND	VARCHAR2	(1)	Yes	Describes whether the unit level credit is to be regarded as program-grouped. Setting the indicator to checked means that the unit level advanced standing is program-grouped.
EXEMPTION_INSTITUTION_CD	VARCHAR2	(30)	Yes	Describes the institution that student undertook the study that resulted in the unit level advanced standing.
S_ADV_STND_GRANTING_STATUS	VARCHAR2	(30)	Yes	Describes the granting status of the advanced standingunit level record. For example, CANCELLED, GRANTED, REVOKED.
CREDIT_POINTS	NUMBER	(6)	Yes	Describes the number of credit points that have beenawarded as advanced standing at a particular unit level to astudent.
APPROVED_DT	DATE		Yes	Describes the date the unit level was approved for advanced standing purposes.
AUTHORISING_PERSON_ID	NUMBER	(15)	Yes	Describes the Person ID of the officer who authorisedthe advanced standing.
GRANTED_DT	DATE			Describes the date the granting status of the unit level advanced standing 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 level record was changed to CANCELLED.
REVOKED_DT	DATE			Describes the date the granting status of the unit level advanced standing was changed to REVOKED.
COMMENTS	VARCHAR2	(2000)		Provides comments about the advanced standing unit level record.
AV_STND_UNIT_LVL_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 many-many relationship. It will store AHV.prev_unit_id. --Obsoleted.
TEST_SEGMENT_ID	VARCHAR2	(15)		Test Segment ID. This is the key to many-many relationship. --Obsoleted.
UNIT_DETAILS_ID	NUMBER	(15)		Prevoius unit identifier
TST_RSLT_DTLS_ID	NUMBER	(15)		Test segment 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
DEG_AUD_DETAIL_ID	NUMBER			Degree Audit Details ID
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
ORG_ID	NUMBER	(15)		Operating unit identifier
QUAL_DETS_ID	NUMBER			Qualification details Identifier
UNIT_LEVEL_MARK	NUMBER	(6)		Contains the Unit Level Mark to be included in the Summary Measures of Attainment calculations.

Query Text

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


SELECT CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PERSON_ID
,      AS_COURSE_CD
,      AS_VERSION_NUMBER
,      S_ADV_STND_TYPE
,      UNIT_LEVEL
,      CRS_GROUP_IND
,      EXEMPTION_INSTITUTION_CD
,      S_ADV_STND_GRANTING_STATUS
,      CREDIT_POINTS
,      APPROVED_DT
,      AUTHORISING_PERSON_ID
,      GRANTED_DT
,      EXPIRY_DT
,      CANCELLED_DT
,      REVOKED_DT
,      COMMENTS
,      AV_STND_UNIT_LVL_ID
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      INSTITUTION_CD
,      PREV_UNIT_CD
,      TEST_SEGMENT_ID
,      UNIT_DETAILS_ID
,      TST_RSLT_DTLS_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      DEG_AUD_DETAIL_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      QUAL_DETS_ID
,      UNIT_LEVEL_MARK
FROM IGS.IGS_AV_STND_UNIT_LVL_ALL;

Dependencies

[top of page]

IGS.IGS_AV_STND_UNIT_LVL_ALL does not reference any database object

IGS.IGS_AV_STND_UNIT_LVL_ALL is referenced by following:

APPS: IGS_AV_STND_UNIT_LVL_ALL