[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_FLD_OF_STUDY_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_FLD_OF_STUDY_ALL |
Subobject Name: | |
Status: | VALID |
This entity describes the university set of fields of study. This is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_FLD_OF_STUDY_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FIELD_OF_STUDY |
IGS_PS_FLD_OF_STUDY_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GOVT_FIELD_OF_STUDY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FIELD_OF_STUDY | VARCHAR2 | (10) | Yes | Unique identifier for the institution-defined field of study. 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 | (80) | Yes | Description of an institution-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. |
GOVT_FIELD_OF_STUDY | VARCHAR2 | (10) | Unique identifier for the government defined field of study. Each institution-defined field of study is mapped to a government field of study. | |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicator that specifies if the field of study is open or closed. Setting the checkbox to closed prevents use of the 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 | |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
FOS_TYPE_CODE | VARCHAR2 | (30) | Yes | Field of Study Type Code |
Cut, paste (and edit) the following text to query this object:
SELECT FIELD_OF_STUDY
, DESCRIPTION
, GOVT_FIELD_OF_STUDY
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, FOS_TYPE_CODE
FROM IGS.IGS_PS_FLD_OF_STUDY_ALL;
IGS.IGS_PS_FLD_OF_STUDY_ALL does not reference any database object
IGS.IGS_PS_FLD_OF_STUDY_ALL is referenced by following:
|
|
|