[Home] [Help] [Dependency Information]
Object Name: | IGS_RE_GV_FLD_OF_SDY |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_RE_GV_FLD_OF_SDY |
Subobject Name: | |
Status: | VALID |
IGS_RE_GV_FLD_OF_SDY describes the government set of fields of study.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_RE_GV_FLD_OF_SDY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | GOVT_FIELD_OF_STUDY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GOVT_FIELD_OF_STUDY | VARCHAR2 | (10) | Yes | The unique identifier for the Government defined field of study. A field of study is a classification of programs based on similarity in terms of the vocational field of specialization or the principal subject matter of the program. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Describes the Government field of study |
RES_FCD_CLASS_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if it is a government classification code |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if the Government field of study is open or closed. Selecting the check box to 'closed' prevents use of the Government field of study in new or modified field of study 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 GOVT_FIELD_OF_STUDY
, DESCRIPTION
, RES_FCD_CLASS_IND
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_RE_GV_FLD_OF_SDY;
IGS.IGS_RE_GV_FLD_OF_SDY does not reference any database object
IGS.IGS_RE_GV_FLD_OF_SDY is referenced by following:
|
|
|