[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_FLD_STDY_HIST_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_FLD_STDY_HIST_ALL |
Subobject Name: | |
Status: | VALID |
IGS_PS_FLD_STDY_HIST_ALL describes the history of changes for a field of study.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_FLD_STDY_HIST_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FIELD_OF_STUDY
HIST_START_DT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FIELD_OF_STUDY | VARCHAR2 | (10) | Yes | Describes the fields of study offered by the university. For example, 02 Architecture, 0204 Urban, and Regional Planning. |
HIST_START_DT | DATE | Yes | Effective start date and time of the history record. | |
HIST_END_DT | DATE | Yes | Effective end date and time of the history record. | |
HIST_WHO | NUMBER | (15) | Yes | Updated by person at the time of the history. |
DESCRIPTION | VARCHAR2 | (60) | 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) | 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
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, 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_STDY_HIST_ALL;
IGS.IGS_PS_FLD_STDY_HIST_ALL does not reference any database object
IGS.IGS_PS_FLD_STDY_HIST_ALL is referenced by following:
|
|
|