[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_TER_ED_LVL_QF |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_TER_ED_LVL_QF |
Subobject Name: | |
Status: | VALID |
IGS_AD_TER_ED_LVL_QF describes user-defined level of qualification achieved by applicant's previous tertiary education.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_TER_ED_LVL_QF_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TERTIARY_EDU_LVL_QUAL |
IGS_AD_TER_ED_LVL_QF_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TAC_LEVEL_OF_QUAL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TERTIARY_EDU_LVL_QUAL | VARCHAR2 | (10) | Yes | Contains the institution-defined code that identifies the tertiary education level of qualification assigned to an applicant on the basis of their current qualifications. These may be optionally mapped onto a tertiary admission center level of qualification code. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the tertiary education level of qualification code |
TAC_LEVEL_OF_QUAL | VARCHAR2 | (10) | Contains a code recognized by the relevant tertiary admission center to define the level of qualification assigned to an applicant on the basis of their current qualifications | |
CLOSED_IND | VARCHAR2 | (1) | Yes | Specifies if the tertiary education level of qualification code is open or closed. Selecting the checkbox to 'closed' prevents use of the tertiary education level of qualification code in new or modified records. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT TERTIARY_EDU_LVL_QUAL
, DESCRIPTION
, TAC_LEVEL_OF_QUAL
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_TER_ED_LVL_QF;
IGS.IGS_AD_TER_ED_LVL_QF does not reference any database object
IGS.IGS_AD_TER_ED_LVL_QF is referenced by following:
|
|
|