[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_TRMDT_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_TRMDT_INT |
Subobject Name: | |
Status: | VALID |
Contains Transcript Term details for each person to be imported into the IGS_AD_TERM_DETAILS table by the Transcripts Import processes
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Academic History Term Detail
Category: BUSINESS_ENTITY IGS_PREV_EDUCATION
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_TRMDT_INT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_TERM_DTLS_ID |
IGS_AD_TRMDT_INT_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_TRANSCRIPT_ID |
IGS_AD_TRMDT_INT_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | STATUS |
IGS_AD_TRMDT_INT_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_TERM_DTLS_ID | NUMBER | (15) | Yes | Unique identifier for the table |
INTERFACE_TRANSCRIPT_ID | NUMBER | (15) | Yes | Indicates the link between transcript table |
START_DATE | DATE | Yes | Indicates the term start date | |
END_DATE | DATE | Yes | Indicates the term end date | |
TERM | VARCHAR2 | (30) | Yes | Indicates the term |
STATUS | VARCHAR2 | (1) | Yes | Status of the interface record after processing.1 - Completed 2 - Pending 3 - Error 4 - Warning |
TERM_DETAILS_ID | NUMBER | (15) | The unique identifier of the system table which will be populated by the interface table. | |
TOTAL_CP_ATTEMPTED | NUMBER | (7) | Total credit points attempted | |
TOTAL_CP_EARNED | NUMBER | (7) | Total credit points earned | |
TOTAL_UNIT_GP | NUMBER | (7) | Total unit grade points | |
TOTAL_GPA_UNITS | NUMBER | (7) | Total grade point average units | |
GPA | VARCHAR2 | (30) | Grade point average of the student | |
MATCH_IND | VARCHAR2 | (2) | Indicates the match between the interface record and record present in the system. | |
ERROR_CODE | VARCHAR2 | (30) | Indicates the error, if any, that occurred in the import process | |
DUP_TERM_DTLS_ID | NUMBER | (15) | Duplicate Term Details ID | |
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 | |
REQUEST_ID | NUMBER | (15) | Standard who column for concurrent programs | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column for concurrent programs | |
PROGRAM_ID | NUMBER | (15) | Standard who column for concurrent programs | |
PROGRAM_UPDATE_DATE | DATE | Standard who column for concurrent programs | ||
INTERFACE_RUN_ID | NUMBER | Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user | ||
PERSON_ID | NUMBER | (15) | Person Identifier. This column will be populated by the import process. | |
EDUCATION_ID | NUMBER | (15) | Education Identifier. This column will be populated by the import process | |
TRANSCRIPT_ID | NUMBER | (15) | Transcript Identifier. This column will be populated by the import process | |
ERROR_TEXT | VARCHAR2 | (2000) | Error Text |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_TERM_DTLS_ID
, INTERFACE_TRANSCRIPT_ID
, START_DATE
, END_DATE
, TERM
, STATUS
, TERM_DETAILS_ID
, TOTAL_CP_ATTEMPTED
, TOTAL_CP_EARNED
, TOTAL_UNIT_GP
, TOTAL_GPA_UNITS
, GPA
, MATCH_IND
, ERROR_CODE
, DUP_TERM_DTLS_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INTERFACE_RUN_ID
, PERSON_ID
, EDUCATION_ID
, TRANSCRIPT_ID
, ERROR_TEXT
FROM IGS.IGS_AD_TRMDT_INT;
IGS.IGS_AD_TRMDT_INT does not reference any database object
IGS.IGS_AD_TRMDT_INT is referenced by following:
|
|
|