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_AD_PRD_PS_OF_OPT

Object Details

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

IGS_AD_PRD_PS_OF_OPT describes the relationship among admission periods,
admission process types, admission categories, and program offering
options.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_PRD_PS_OF_OPT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADM_CAL_TYPE ADM_CI_SEQUENCE_NUMBER ADMISSION_CAT S_ADMISSION_PROCESS_TYPE COURSE_CD VERSION_NUMBER ACAD_CAL_TYPE SEQUENCE_NUMBER
IGS_AD_PRD_PS_OF_OPT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COURSE_CD VERSION_NUMBER ACAD_CAL_TYPE
IGS_AD_PRD_PS_OF_OPT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_CD
IGS_AD_PRD_PS_OF_OPT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE_MODE
IGS_AD_PRD_PS_OF_OPT_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE_TYPE
IGS_AD_PRD_PS_OF_OPT_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADMISSION_CAT S_ADMISSION_PROCESS_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ADM_CAL_TYPE	VARCHAR2	(10)	Yes	Describes the calendar type relating to the admission period.
ADM_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the sequence number which uniquely identifies the admission period calendar instance.
ADMISSION_CAT	VARCHAR2	(10)	Yes	Describes the admission category that the admission period is restricted to.
S_ADMISSION_PROCESS_TYPE	VARCHAR2	(30)	Yes	Describes the system admission process type that the admission period is restricted to.
COURSE_CD	VARCHAR2	(6)	Yes	Describes the program code that the admission period is restricted to.
VERSION_NUMBER	NUMBER	(3)	Yes	The program version number that the admission period is restricted to
ACAD_CAL_TYPE	VARCHAR2	(10)	Yes	Describes the program offering calendar type to which the admission period is restricted.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Defines the admission process type, admission category and program offering for the admission period. This combination can be repeated for location code, attendance mode and attendance type combinations.
LOCATION_CD	VARCHAR2	(10)		Describes the location code that the admission period is restricted to. If no value is entered, then all locations for available program offering patterns are entry points in this admission period for the specified admission process type, admission category, program offering.
ATTENDANCE_MODE	VARCHAR2	(2)		Describes the attendance mode that the admission period is restricted to.
ATTENDANCE_TYPE	VARCHAR2	(2)		Describes the attendance type that the admission period is restricted to.
ROLLOVER_INCLUSION_IND	VARCHAR2	(1)	Yes	Indicates if the admission period program and components will be included in the admission calendar rollover process.
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
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

Query Text

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


SELECT ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      ADMISSION_CAT
,      S_ADMISSION_PROCESS_TYPE
,      COURSE_CD
,      VERSION_NUMBER
,      ACAD_CAL_TYPE
,      SEQUENCE_NUMBER
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      ROLLOVER_INCLUSION_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_AD_PRD_PS_OF_OPT;

Dependencies

[top of page]

IGS.IGS_AD_PRD_PS_OF_OPT does not reference any database object

IGS.IGS_AD_PRD_PS_OF_OPT is referenced by following:

APPS: IGS_AD_PRD_PS_OF_OPT