[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_TXCPT_INT_ALL_OLD |
---|---|
Object Type: | TABLE |
Owner: | IGS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AP_TXCPT_INT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | INTERFACE_TRANSCRIPT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_TRANSCRIPT_ID | NUMBER | (15) | Yes | |
TRANSCRIPT_STATUS | VARCHAR2 | (30) | Yes | |
TRANSCRIPT_TYPE | VARCHAR2 | (30) | Yes | |
TRANSCRIPT_SOURCE | NUMBER | (15) | Yes | |
INTERFACE_ACADHIS_ID | NUMBER | (15) | Yes | |
STATUS | VARCHAR2 | (1) | Yes | |
ENTERED_GS_ID | NUMBER | (15) | Yes | |
CONV_GS_ID | NUMBER | (15) | Yes | |
TERM_TYPE | VARCHAR2 | (1) | Yes | |
TRANSCRIPT_ID | NUMBER | (15) | ||
DATE_OF_RECEIPT | DATE | |||
ENTERED_GPA | VARCHAR2 | (30) | ||
CONV_GPA | VARCHAR2 | (30) | ||
RANK_IN_CLASS | NUMBER | (5) | ||
CLASS_SIZE | NUMBER | (5) | ||
APPROXIMATE_RANK | VARCHAR2 | (1) | ||
WEIGHTED_RANK | VARCHAR2 | (1) | ||
DECILE_RANK | NUMBER | |||
QUARTILE_RANK | NUMBER | |||
QUINTILE_RANK | NUMBER | |||
PERCENTILE_RANK | NUMBER | |||
MATCH_IND | VARCHAR2 | (2) | ||
ERROR_CODE | VARCHAR2 | (30) | ||
DUP_TRANSCRIPT_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
DATE_OF_ISSUE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_TRANSCRIPT_ID
, TRANSCRIPT_STATUS
, TRANSCRIPT_TYPE
, TRANSCRIPT_SOURCE
, INTERFACE_ACADHIS_ID
, STATUS
, ENTERED_GS_ID
, CONV_GS_ID
, TERM_TYPE
, TRANSCRIPT_ID
, DATE_OF_RECEIPT
, ENTERED_GPA
, CONV_GPA
, RANK_IN_CLASS
, CLASS_SIZE
, APPROXIMATE_RANK
, WEIGHTED_RANK
, DECILE_RANK
, QUARTILE_RANK
, QUINTILE_RANK
, PERCENTILE_RANK
, MATCH_IND
, ERROR_CODE
, DUP_TRANSCRIPT_ID
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DATE_OF_ISSUE
FROM IGS.IGS_AD_TXCPT_INT_ALL_OLD;
IGS.IGS_AD_TXCPT_INT_ALL_OLD does not reference any database object
IGS.IGS_AD_TXCPT_INT_ALL_OLD is referenced by following:
|
|
|