[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_AUSE_ED_AS_TY |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_AUSE_ED_AS_TY |
Subobject Name: | |
Status: | VALID |
IGS_AD_AUSE_ED_AS_T describes user-defined assessment types for
secondary education.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_AUSE_ED_AS_TY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | AUS_SCNDRY_EDU_ASS_TYPE |
IGS_AD_AUSE_ED_AS_TY_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TAC_AUS_SCNDRY_EDU_ASS_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUS_SCNDRY_EDU_ASS_TYPE | VARCHAR2 | (10) | Yes | Describes the system-defined Australian Secondary Education Assessment types, for example, VCE, IB, YR12-ACT. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the Secondary Education Assessment Type |
TAC_AUS_SCNDRY_EDU_ASS_TYPE | VARCHAR2 | (10) | Describes the tertiary admissions center Australian Secondary Education Assessment Type, for example, 'V' - VCE, 'H' - HSC,'I' - IB. | |
STATE_CD | VARCHAR2 | (3) | The State linked to the Secondary Education Assessment Type, for example, VIC, QLD, WA, SA. | |
GOVT_REPORTED_IND | VARCHAR2 | (1) | Yes | Specifies whether the assessment type should be used to derive the government-reportable Tertiary Entrance Score TES value. To enable the reporting of a TES to DETYA, the assessment type must be 'flagged' as government reported. Setting the indicator checked means that this assessment type should be used to derive the government-reportable value. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Specifies whether the Secondary Education Assessment Type is open or closed. Setting the indicator to 'closed' prevents use of the assessment type in new or modified Secondary Education 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 AUS_SCNDRY_EDU_ASS_TYPE
, DESCRIPTION
, TAC_AUS_SCNDRY_EDU_ASS_TYPE
, STATE_CD
, GOVT_REPORTED_IND
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_AUSE_ED_AS_TY;
IGS.IGS_AD_AUSE_ED_AS_TY does not reference any database object
IGS.IGS_AD_AUSE_ED_AS_TY is referenced by following:
|
|
|