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_PECRS_OFOP_DT

Object Details

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

IGS_AD_PECRS_OFOP_DT describes program offering option specified by the admission period program offering option.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_PECRS_OFOP_DT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADM_CAL_TYPE ADM_CI_SEQUENCE_NUMBER ADMISSION_CAT DT_ALIAS DAI_SEQUENCE_NUMBER SEQUENCE_NUMBER
IGS_AD_PECRS_OFOP_DT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COURSE_CD VERSION_NUMBER ACAD_CAL_TYPE
IGS_AD_PECRS_OFOP_DT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DT_ALIAS DAI_SEQUENCE_NUMBER ADM_CAL_TYPE ADM_CI_SEQUENCE_NUMBER
IGS_AD_PECRS_OFOP_DT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_CD
IGS_AD_PECRS_OFOP_DT_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE_MODE
IGS_AD_PECRS_OFOP_DT_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE_TYPE
IGS_AD_PECRS_OFOP_DT_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_CAL_TYPE ADM_CI_SEQUENCE_NUMBER ADMISSION_CAT S_ADMISSION_PROCESS_TYPE
IGS_AD_PECRS_OFOP_DT_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	S_ADMISSION_PROCESS_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ADM_CAL_TYPE	VARCHAR2	(10)	Yes	Describes the calendar type of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ADM_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the calendar sequence number of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ADMISSION_CAT	VARCHAR2	(10)	Yes	Describes the admission category of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
DT_ALIAS	VARCHAR2	(10)	Yes	Describes the admission date alias that requires further process type, admission category, program offering option restrictions.
DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the sequence number that defines the admission date alias instance that requires further process type, admission category, program offering option restrictions.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely defines information in this table.
S_ADMISSION_PROCESS_TYPE	VARCHAR2	(30)		Describes the system admission process type of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
COURSE_CD	VARCHAR2	(6)		Describes the program code of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
VERSION_NUMBER	NUMBER	(3)		Describes the program version number of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ACAD_CAL_TYPE	VARCHAR2	(10)		Describes the program offering calendar type of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
LOCATION_CD	VARCHAR2	(10)		Describes the location code of the admission date alias instance that requires further process type ,admission category, program offering option restrictions.
ATTENDANCE_MODE	VARCHAR2	(2)		Describes the attendance mode of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ATTENDANCE_TYPE	VARCHAR2	(2)		Describes the attendance type of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ROLLOVER_INCLUSION_IND	VARCHAR2	(1)	Yes	Describes whether the admission period override date 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

Query Text

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


SELECT ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      ADMISSION_CAT
,      DT_ALIAS
,      DAI_SEQUENCE_NUMBER
,      SEQUENCE_NUMBER
,      S_ADMISSION_PROCESS_TYPE
,      COURSE_CD
,      VERSION_NUMBER
,      ACAD_CAL_TYPE
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      ROLLOVER_INCLUSION_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_PECRS_OFOP_DT;

Dependencies

[top of page]

IGS.IGS_AD_PECRS_OFOP_DT does not reference any database object

IGS.IGS_AD_PECRS_OFOP_DT is referenced by following:

APPS: IGS_AD_PECRS_OFOP_DT