[Home] [Help]
[Dependency Information]
Object Name: | IGS_AD_TER_ED_LV_COM |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
IGS_AD_TER_ED_LV_COM describes applicant's previous tertiary education level of completion.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_TER_ED_LV_COM_U1 | NORMAL | UNIQUE |
![]() |
![]() |
IGS_AD_TER_ED_LV_COM_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TERTIARY_EDU_LVL_COMP | VARCHAR2 | (10) | Yes | Contains the institution-defined code that identifies the level of completion of tertiary education studies assigned to an applicant on the basis of their current qualifications. These may be optionally mapped onto a tertiary admission center level of completion code. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the tertiary education level of completion code |
TAC_LEVEL_OF_COMP | VARCHAR2 | (10) | Contains a code recognized by the relevant tertiary admission center to define the level of completion of studies assigned to an applicant on the basis of their current qualifications | |
CLOSED_IND | VARCHAR2 | (1) | Yes | An indicator that specifies if the tertiary education level of completion code is open or closed. Selecting the checkbox to 'closed' prevents use of the tertiary education level of completion 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_COMP
, DESCRIPTION
, TAC_LEVEL_OF_COMP
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_TER_ED_LV_COM;
IGS.IGS_AD_TER_ED_LV_COM does not reference any database object
IGS.IGS_AD_TER_ED_LV_COM is referenced by following:
|
|
|