[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
IGS.IGS_AD_PRD_AD_PRC_CA does not reference any database object
IGS.IGS_AD_PRD_AD_PRC_CA is referenced by following:
|
|
|