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_AD_PRC_CA

Object Details

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

IGS_AD_PRD_AD_PRC_CA describes the relationship among admission periods,
admission process types, and admission categories.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_PRD_AD_PRC_CA_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADM_CAL_TYPE ADM_CI_SEQUENCE_NUMBER ADMISSION_CAT S_ADMISSION_PROCESS_TYPE
IGS_AD_PRD_AD_PRC_CA_N1	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 applies to this admission period.
S_ADMISSION_PROCESS_TYPE	VARCHAR2	(30)	Yes	Describes the system admission process type that applies to this admission period.
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
CLOSED_IND	VARCHAR2	(1)	Yes	Closed Indicator
SINGLE_RESPONSE_FLAG	VARCHAR2	(1)		Single Offer Response Flag
INCLUDE_SR_IN_ROLLOVER_FLAG	VARCHAR2	(1)		Flag to indicate whether single response flag is to be included in the rollover process or not

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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CLOSED_IND
,      SINGLE_RESPONSE_FLAG
,      INCLUDE_SR_IN_ROLLOVER_FLAG
FROM IGS.IGS_AD_PRD_AD_PRC_CA;

Dependencies

[top of page]

IGS.IGS_AD_PRD_AD_PRC_CA does not reference any database object

IGS.IGS_AD_PRD_AD_PRC_CA is referenced by following:

APPS: IGS_AD_PRD_AD_PRC_CA