[Home] [Help] [Dependency Information]
Object Name: | IGS_ST_GOVT_SEMESTER |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_ST_GOVT_SEMESTER |
Subobject Name: | |
Status: | VALID |
IGS_ST_GOVT_SEMESTER describes the semester against the load is to be assigned. For example, 1, 2, or 3.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_ST_GOVT_SEMESTER_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SUBMISSION_YR
SUBMISSION_NUMBER GOVT_SEMESTER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUBMISSION_YR | NUMBER | (4) | Yes | Reference year of the higher education student data collection submission |
SUBMISSION_NUMBER | NUMBER | (1) | Yes | Higher education student data collection submission number that is in 1, 2 or 3 of the enrollment statistics snapshot. |
GOVT_SEMESTER | NUMBER | (1) | Yes | Identifies the government semester that the student unit attempts captured in the context enrollment statistics snapshot will be reported in. See Element 353 of the higher education student data collection for the definition of the five government semesters. |
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 SUBMISSION_YR
, SUBMISSION_NUMBER
, GOVT_SEMESTER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_ST_GOVT_SEMESTER;
IGS.IGS_ST_GOVT_SEMESTER does not reference any database object
IGS.IGS_ST_GOVT_SEMESTER is referenced by following:
|
|
|