[Home] [Help] [Dependency Information]
Object Name: | IGS_AV_STND_CONF_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AV_STND_CONF_ALL |
Subobject Name: | |
Status: | VALID |
IGS_AV_STND_CONF_ALL describes values used as the basis for default values for advanced standing tables.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AV_STND_CONF_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | S_CONTROL_NUM |
IGS_AV_STND_CONF_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ADV_STND_CUTOFF_DT_ALIAS |
IGS_AV_STND_CONF_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ADV_STND_BASIS_INST |
IGS_AV_STND_CONF_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ADV_STND_MAJOR_EXEMPT_INST |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
S_CONTROL_NUM | NUMBER | (1) | Yes | Uniquely identifies the advanced standing configurationrecord. |
EXPIRY_DT_INCREMENT | NUMBER | (2) | Yes | Describes the increment in months added to the current date, that is used as the default expiry date when creating unit or unit level advanced standing records. |
ADV_STND_CUTOFF_DT_ALIAS | VARCHAR2 | (10) | OBSOLETE. | |
ADV_STND_EXPIRY_DT_ALIAS | VARCHAR2 | (10) | Describes the expiry date alias for advanced standing.If approved advanced standing is not granted prior to this date,then the advanced standing is expired. | |
ADV_STND_BASIS_INST | VARCHAR2 | (30) | Describes the institution that is to be used as the default exemption institution when creating unit or unit level advanced standing records. | |
ADV_STND_MAJOR_EXEMPT_INST | VARCHAR2 | (30) | Describes the institution that is used as the default exemption institution when creating advanced standing records. - Obsolete | |
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 | Standard who column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ORG_ID | NUMBER | (15) | Operating unit identifier |
Cut, paste (and edit) the following text to query this object:
SELECT S_CONTROL_NUM
, EXPIRY_DT_INCREMENT
, ADV_STND_CUTOFF_DT_ALIAS
, ADV_STND_EXPIRY_DT_ALIAS
, ADV_STND_BASIS_INST
, ADV_STND_MAJOR_EXEMPT_INST
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_AV_STND_CONF_ALL;
IGS.IGS_AV_STND_CONF_ALL does not reference any database object
IGS.IGS_AV_STND_CONF_ALL is referenced by following:
|
|
|