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_LGCY_LVL_INT

Object Details

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

Contains the Unit Level Advanced Standing information to be imported into the IGS_AV_ADV_STANDING_ALL, IGS_AV_STND_UNIT_LVL_ALL and IGS_AV_STD_ULVLBASIS_ALL tables by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Legacy Level Advanced Standing
Category: BUSINESS_ENTITY IGS_ADV_STAND

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AV_LGCY_LVL_INT_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	LEGACY_LVL_INT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LEGACY_LVL_INT_ID	NUMBER	(15)	Yes	Uniquely identify each record in the interface table.
BATCH_ID	NUMBER	(15)	Yes	Foreign Key to Batch Interface Table
PERSON_NUMBER	VARCHAR2	(30)	Yes	The person number of the advanced standing.
PROGRAM_CD	VARCHAR2	(6)	Yes	Program against which the advanced standing is to be approved or granted.
TOTAL_EXMPTN_APPROVED	NUMBER	(6)	Yes	Total credit points approved as advanced standing.
TOTAL_EXMPTN_GRANTED	NUMBER	(6)	Yes	Total credit points granted as advanced standing.
TOTAL_EXMPTN_PERC_GRNTD	NUMBER	(5)	Yes	Percentage of program requirements granted as advanced standing.
EXEMPTION_INSTITUTION_CD	VARCHAR2	(30)	Yes	Institution where the majority of the exemption was obtained.
UNIT_LEVEL	VARCHAR2	(4)	Yes	Level for which the advanced standing is being given.
PROG_GROUP_IND	VARCHAR2	(1)		Unit level credit is to be regarded as program-grouped if this indicator is checked.
LOAD_CAL_ALT_CODE	VARCHAR2	(10)		Calendar Alternate code.
INSTITUTION_CD	VARCHAR2	(30)		Institution Code.
S_ADV_STND_GRANTING_STATUS	VARCHAR2	(30)	Yes	Granting status of the advanced standing unit level record.
CREDIT_POINTS	NUMBER	(6)	Yes	Number of credit points that have been awarded as advanced standing at a particular unit level to a student.
APPROVED_DT	DATE		Yes	Date when the unit level was approved for advanced standing purposes.
AUTHORISING_PERSON_NUMBER	VARCHAR2	(30)	Yes	Person number of the officer who authorized the advanced standing.
GRANTED_DT	DATE			Date when the granting status of the unit level advanced standing was set to GRANTED.
EXPIRY_DT	DATE			Date when the approval for the advanced standing unit level expired.
CANCELLED_DT	DATE			Date when the granting status of the unit level record was changed to CANCELLED.
REVOKED_DT	DATE			Date when the granting status of the unit level advanced standing was set to REVOKED.
COMMENTS	VARCHAR2	(2000)		Comments about the advanced standing unit level record.
QUAL_EXAM_LEVEL	VARCHAR2	(20)		Qualification details table exam level part of the qualification details key.
QUAL_SUBJECT_CODE	VARCHAR2	(20)		Qualification details table subject code part of the qualification details key.
QUAL_YEAR	NUMBER	(4)		Qualification details table year part of the qualification details key.
QUAL_SITTING	VARCHAR2	(1)		qualification details table sitting part of the qualification details key.
QUAL_AWARDING_BODY	VARCHAR2	(30)		Qualification details table award body part of the qualification details key.
APPROVED_RESULT	VARCHAR2	(5)		Approved result, part of the qualification details key.
PREV_UNIT_CD	VARCHAR2	(10)		Previous unit part of the previous unit details key
PREV_TERM	VARCHAR2	(30)		Previous term details key
START_DATE	DATE			Start date of the term
END_DATE	DATE			End Date of the term
TST_ADMISSION_TEST_TYPE	VARCHAR2	(30)		Test segment Admission Test Type
TST_TEST_DATE	DATE			Test segment test date
TEST_SEGMENT_NAME	VARCHAR2	(30)		Test segment name
BASIS_PROGRAM_TYPE	VARCHAR2	(10)		Program type of the program that forms the basis of the unit level advanced standing.
BASIS_YEAR	NUMBER	(4)		The year, a person was last enrolled in a program that forms the basis of the unit level advanced standing.
BASIS_COMPLETION_IND	VARCHAR2	(1)		Completion indicator, indicating whether the person completed the program that forms the basis of the unit level advanced standing.
IMPORT_STATUS	VARCHAR2	(1)		Records Import status, allowable values are U - Unprocessed (Default) R - Ready for Reprocessing : E - Error , W - Warning ,I - Imported
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
REQUEST_ID	NUMBER	(15)		Standard concurrent program who column
PROGRAM_ID	NUMBER	(15)		Standard concurrent program who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard concurrent program who column
PROGRAM_UPDATE_DATE	DATE			Standard concurrent program who column
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 LEGACY_LVL_INT_ID
,      BATCH_ID
,      PERSON_NUMBER
,      PROGRAM_CD
,      TOTAL_EXMPTN_APPROVED
,      TOTAL_EXMPTN_GRANTED
,      TOTAL_EXMPTN_PERC_GRNTD
,      EXEMPTION_INSTITUTION_CD
,      UNIT_LEVEL
,      PROG_GROUP_IND
,      LOAD_CAL_ALT_CODE
,      INSTITUTION_CD
,      S_ADV_STND_GRANTING_STATUS
,      CREDIT_POINTS
,      APPROVED_DT
,      AUTHORISING_PERSON_NUMBER
,      GRANTED_DT
,      EXPIRY_DT
,      CANCELLED_DT
,      REVOKED_DT
,      COMMENTS
,      QUAL_EXAM_LEVEL
,      QUAL_SUBJECT_CODE
,      QUAL_YEAR
,      QUAL_SITTING
,      QUAL_AWARDING_BODY
,      APPROVED_RESULT
,      PREV_UNIT_CD
,      PREV_TERM
,      START_DATE
,      END_DATE
,      TST_ADMISSION_TEST_TYPE
,      TST_TEST_DATE
,      TEST_SEGMENT_NAME
,      BASIS_PROGRAM_TYPE
,      BASIS_YEAR
,      BASIS_COMPLETION_IND
,      IMPORT_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      UNIT_LEVEL_MARK
FROM IGS.IGS_AV_LGCY_LVL_INT;

Dependencies

[top of page]

IGS.IGS_AV_LGCY_LVL_INT does not reference any database object

IGS.IGS_AV_LGCY_LVL_INT is referenced by following:

APPS: IGS_AV_LGCY_LVL_INT