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_UNT_INT

Object Details

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

Contains the Unit Advanced Standing information to be imported into the IGS_AV_ADV_STANDING_ALL, IGS_AV_STND_UNIT_ALL, IGS_AV_STD_UNT_BASIS_ALL, IGS_AV_UNT_REF_CDS and IGS_AV_STND_ALT_UNIT 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 Unit 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_UNT_INT_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	LEGACY_UNT_INT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LEGACY_UNT_INT_ID	NUMBER	(15)	Yes	Unique identifies of a 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 outcome.
PROGRAM_CD	VARCHAR2	(6)	Yes	Program code in which the unit attempt was studied.
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_CD	VARCHAR2	(10)	Yes	The unit code to which the outcome applies.
VERSION_NUMBER	NUMBER	(3)	Yes	Version of the grading schema
INSTITUTION_CD	VARCHAR2	(30)		Institution Code.
APPROVED_DT	DATE		Yes	Date the unit was approved for advanced standing purposes.
AUTHORISING_PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number of the officer who authorized the advanced standing.
PROG_GROUP_IND	VARCHAR2	(1)		Unit is regarded as program-grouped if this indicator is checked
GRANTED_DT	DATE			The date the granting status of the unit was set to Granted.
EXPIRY_DT	DATE			The date the approval for the advanced standing unit level expired.
CANCELLED_DT	DATE			The date the granting status of the unit was set to Cancelled.
REVOKED_DT	DATE			The date the granting status of the unit was set to Revoked.
COMMENTS	VARCHAR2	(2000)		Comments about the advanced standing unit.
CREDIT_PERCENTAGE	NUMBER	(5)		The percentage of credit for the unit that is to be granted as advanced standing. --Obsolete
S_ADV_STND_GRANTING_STATUS	VARCHAR2	(30)	Yes	Advanced standing granting status
S_ADV_STND_RECOGNITION_TYPE	VARCHAR2	(30)	Yes	Type of recognition that applies to the unit.
LOAD_CAL_ALT_CODE	VARCHAR2	(10)		Load Calendar Alternate Code
GRADING_SCHEMA_CD	VARCHAR2	(10)		Grading schema code
GRD_SCH_VERSION_NUMBER	NUMBER	(3)		Grading Schema Version Number.
GRADE	VARCHAR2	(5)		The grade which the student attained for this unit attempt.
ACHIEVABLE_CREDIT_POINTS	NUMBER	(6)		Achievable Credit Points Granted to a student.
PREV_UNIT_CD	VARCHAR2	(10)		Previous unit part of the previous unit details key.
PREV_TERM	VARCHAR2	(30)		Previous unit term part of the previous unit details key
START_DATE	DATE			Start date of the previous term
END_DATE	DATE			End Date of the previous 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
ALT_UNIT_CD	VARCHAR2	(10)		Alternate unit that has been specified in place of a unit that the student has been precluded from studying.
ALT_VERSION_NUMBER	NUMBER	(3)		Version number of the alternate unit that has been specified in place of a precluded unit.
OPTIONAL_IND	VARCHAR2	(1)		Indicator of whether the alternate unit is mandatory or whether a choice is available. Setting the indicator to checked means that the alternate unit is optional.
BASIS_PROGRAM_TYPE	VARCHAR2	(10)		Program type of the program that forms the basis of the unit advanced standing.
BASIS_YEAR	NUMBER	(4)		The year, the person was last enrolled in the program that forms the basis of the unit advanced standing.
BASIS_COMPLETION_IND	VARCHAR2	(1)		Completion Indicator, indicating whether the students completed the program that forms the basis of the unit 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
APPLIED_PROGRAM_CD	VARCHAR2	(6)		The program code under which the reference code is saved.
REFERENCE_CD	VARCHAR2	(30)		The 'other system' reference code for a unit.
REFERENCE_CD_TYPE	VARCHAR2	(10)		The institution-defined reference code type.

Query Text

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


SELECT LEGACY_UNT_INT_ID
,      BATCH_ID
,      PERSON_NUMBER
,      PROGRAM_CD
,      TOTAL_EXMPTN_APPROVED
,      TOTAL_EXMPTN_GRANTED
,      TOTAL_EXMPTN_PERC_GRNTD
,      EXEMPTION_INSTITUTION_CD
,      UNIT_CD
,      VERSION_NUMBER
,      INSTITUTION_CD
,      APPROVED_DT
,      AUTHORISING_PERSON_NUMBER
,      PROG_GROUP_IND
,      GRANTED_DT
,      EXPIRY_DT
,      CANCELLED_DT
,      REVOKED_DT
,      COMMENTS
,      CREDIT_PERCENTAGE
,      S_ADV_STND_GRANTING_STATUS
,      S_ADV_STND_RECOGNITION_TYPE
,      LOAD_CAL_ALT_CODE
,      GRADING_SCHEMA_CD
,      GRD_SCH_VERSION_NUMBER
,      GRADE
,      ACHIEVABLE_CREDIT_POINTS
,      PREV_UNIT_CD
,      PREV_TERM
,      START_DATE
,      END_DATE
,      TST_ADMISSION_TEST_TYPE
,      TST_TEST_DATE
,      TEST_SEGMENT_NAME
,      ALT_UNIT_CD
,      ALT_VERSION_NUMBER
,      OPTIONAL_IND
,      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
,      APPLIED_PROGRAM_CD
,      REFERENCE_CD
,      REFERENCE_CD_TYPE
FROM IGS.IGS_AV_LGCY_UNT_INT;

Dependencies

[top of page]

IGS.IGS_AV_LGCY_UNT_INT does not reference any database object

IGS.IGS_AV_LGCY_UNT_INT is referenced by following:

APPS: IGS_AV_LGCY_UNT_INT