[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_CD |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_CD |
Subobject Name: | |
Status: | VALID |
IGS_AD_CD describes user-defined admission codes used to define matriculation qualifications of program
admission application.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_CD_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ADMISSION_CD |
IGS_AD_CD_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TAC_ADMISSION_CD |
IGS_AD_CD_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BASIS_FOR_ADMISSION_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADMISSION_CD | VARCHAR2 | (10) | Yes | Contains the institution-defined admission code used to describe the matriculation category assigned to an applicant on the basis of their current qualifications. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the admission code matriculation category |
TAC_ADMISSION_CD | VARCHAR2 | (10) | Yes | Contains an admission code recognized by the relevant tertiary admission center to define the matriculation category assigned to an applicant on the basis of their current qualifications. For example, V10 OVERSEAS APPLICANT WITH VCE OR IB, V11 SATISFIEDNORMAL UER. NOTIONAL TER., V22 INTERSTATE APPLICANT WITH CURRENTYEAR 12. |
BASIS_FOR_ADMISSION_TYPE | VARCHAR2 | (10) | Contains the institution-defined code that identifies the main criterion used in granting an applicant admission to a program of study based on their current qualifications or experience. | |
CLOSED_IND | VARCHAR2 | (1) | Yes | Specifies if the admission code is open or closed .Setting the checkbox to 'closed' prevents use of the admission code in new or modified admission application 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 ADMISSION_CD
, DESCRIPTION
, TAC_ADMISSION_CD
, BASIS_FOR_ADMISSION_TYPE
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_CD;
IGS.IGS_AD_CD does not reference any database object
IGS.IGS_AD_CD is referenced by following:
|
|
|