[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_TEST_TYPE |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_TEST_TYPE |
Subobject Name: | |
Status: | VALID |
IGS_AD_TEST_TYPE describes valid admission test types.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_TEST_TYPE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ADMISSION_TEST_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADMISSION_TEST_TYPE | VARCHAR2 | (30) | Yes | Describes the types of admission test against that results may be recorded for an applicant |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the admission test type |
SCORE_TYPE | VARCHAR2 | (30) | Test Score Source | |
STEP_CODE | VARCHAR2 | (30) | Step Catalog Code | |
CLOSED_IND | VARCHAR2 | (1) | Yes | Specifies whether the admission test type is open or closed. Selecting the checkbox to 'closed' prevents use of the test type in new or modified admission program application test result 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_TEST_TYPE
, DESCRIPTION
, SCORE_TYPE
, STEP_CODE
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_TEST_TYPE;
IGS.IGS_AD_TEST_TYPE does not reference any database object
IGS.IGS_AD_TEST_TYPE is referenced by following:
|
|
|