[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_BASIS_FOR_AD |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_BASIS_FOR_AD |
Subobject Name: | |
Status: | VALID |
IGS_AD_BASIS_FOR_AD describes user-defined basis for admissions for
application for program admission.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_BASIS_FOR_AD_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BASIS_FOR_ADMISSION_TYPE |
IGS_AD_BASIS_FOR_AD_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GOVT_BASIS_FOR_ADM_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BASIS_FOR_ADMISSION_TYPE | VARCHAR2 | (10) | Yes | 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. These may be optionally mapped onto a Government basis for admission type. For example, NE - Final Year of Secondary Education, EE - Employment Experience, OB - Other basis. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the basis for admission type |
GOVT_BASIS_FOR_ADM_TYPE | VARCHAR2 | (2) | Contains a unique Government defined code that identifies the main criterion used in granting an applicant admission to a program of study. For example, 11 - Completed Higher Education, 14 - Completed Secondary Education at School. | |
CLOSED_IND | VARCHAR2 | (1) | Yes | Specifies if the basis for admission type is open or closed. Setting the checkbox to 'closed' prevents use of the basis for admission type 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 BASIS_FOR_ADMISSION_TYPE
, DESCRIPTION
, GOVT_BASIS_FOR_ADM_TYPE
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_BASIS_FOR_AD;
IGS.IGS_AD_BASIS_FOR_AD does not reference any database object
IGS.IGS_AD_BASIS_FOR_AD is referenced by following:
|
|
|