[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_TYPGOV_SCORMP |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AS_TYPGOV_SCORMP |
Subobject Name: | |
Status: | VALID |
IGS_AS_TYPGOV_SCORMP holds the mapping of the score held in the secondary education table to the government reportable score for a specific assessment type.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AS_TYPGOV_SCORMP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SCNDRY_EDU_ASS_TYPE
RESULT_OBTAINED_YR INSTITUTION_SCORE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCNDRY_EDU_ASS_TYPE | VARCHAR2 | (10) | Yes | Describes secondary education assessment types. For example, VCE, IB, YR12-ACT |
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 | |
RESULT_OBTAINED_YR | NUMBER | (4) | Yes | Year the secondary education results were obtained that must be mapped to government reportable values. |
INSTITUTION_SCORE | NUMBER | (6) | Yes | Score recognized by the local institution as the student's tertiary entrance score for this assessment type. Local tertiary entrance score must be mapped to a common index tertiary entrance score for government reporting purposes. |
GOVT_SCORE | NUMBER | (6) | Yes | Score thatis reported to the government as the student's tertiary entrance score DETYA element 369- for this assessment type. The score reported must be from DETYA's common index tertiary entrance scores. |
Cut, paste (and edit) the following text to query this object:
SELECT SCNDRY_EDU_ASS_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, RESULT_OBTAINED_YR
, INSTITUTION_SCORE
, GOVT_SCORE
FROM IGS.IGS_AS_TYPGOV_SCORMP;
IGS.IGS_AS_TYPGOV_SCORMP does not reference any database object
IGS.IGS_AS_TYPGOV_SCORMP is referenced by following:
|
|
|