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_AS_SL_INTERFACE

Object Details

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

Assessment Student List Web ADI Interface Table

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_SL_INTERFACE_PK	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	USER_ID BATCH_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
USER_ID	NUMBER	(15)	Yes	User Identifier
BATCH_DATE	DATE		Yes	Batch Date
GROUP_ID	NUMBER	(10)		Group identifier
GROUP_NAME	VARCHAR2	(80)		Group Name
PERSON_ID	NUMBER	(15)	Yes	Person Identifier
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number
COURSE_CD	VARCHAR2	(10)	Yes	Course Code
UNIT_CD	VARCHAR2	(10)	Yes	Unit Code
VERSION_NUMBER	NUMBER	(3)	Yes	Version Number
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar Type
CI_SEQUENCE_NUMBER	VARCHAR2	(6)	Yes	Calendar sequence Number
ALTERNATE_CODE	VARCHAR2	(10)		Alternate Code
CLASS_STANDING	VARCHAR2	(50)	Yes	Class Standing
LOCATION_CD	VARCHAR2	(10)	Yes	Location Code
UNIT_CLASS	VARCHAR2	(10)	Yes	Unit Class
CI_START_DT	VARCHAR2	(240)	Yes	Calendar Start Date
CI_END_DT	VARCHAR2	(240)	Yes	Calendar End Date
UOO_ID	NUMBER	(7)	Yes	Unit offering option identifier
UNIT_ATTEMPT_STATUS	VARCHAR2	(30)	Yes	Unit attempt Status
NOMINATED_COMPL_YEAR	VARCHAR2	(30)		Nominated Completion year
YEAR_OF_PROGRAM	VARCHAR2	(30)		Year of program
WAITLISTED_POSITION	NUMBER	(4)		Waitlisted Position
COMMENTS	VARCHAR2	(240)		Comments
ERROR_CODE	VARCHAR2	(30)		Error Code
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DT	VARCHAR2	(240)	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
LAST_ACTIVITY_DT	DATE			Last Activity Date

Query Text

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


SELECT USER_ID
,      BATCH_DATE
,      GROUP_ID
,      GROUP_NAME
,      PERSON_ID
,      PERSON_NUMBER
,      COURSE_CD
,      UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ALTERNATE_CODE
,      CLASS_STANDING
,      LOCATION_CD
,      UNIT_CLASS
,      CI_START_DT
,      CI_END_DT
,      UOO_ID
,      UNIT_ATTEMPT_STATUS
,      NOMINATED_COMPL_YEAR
,      YEAR_OF_PROGRAM
,      WAITLISTED_POSITION
,      COMMENTS
,      ERROR_CODE
,      CREATED_BY
,      CREATION_DT
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_ACTIVITY_DT
FROM IGS.IGS_AS_SL_INTERFACE;

Dependencies

[top of page]

IGS.IGS_AS_SL_INTERFACE does not reference any database object

IGS.IGS_AS_SL_INTERFACE is referenced by following:

APPS: IGS_AS_SL_INTERFACE