[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_TUNDT_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_TUNDT_INT |
Subobject Name: | |
Status: | VALID |
Contains Transcript Term Unit details for each person to be imported into the IGS_AD_TERM_UNITDTLS table Transcript Import process.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Academic History Unit Detail
Category: BUSINESS_ENTITY IGS_PREV_EDUCATION
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_TUNDT_INT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_TERM_UNITDTLS_ID |
IGS_AD_TUNDT_INT_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_TERM_DTLS_ID |
IGS_AD_TUNDT_INT_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | STATUS |
IGS_AD_TUNDT_INT_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_TERM_UNITDTLS_ID | NUMBER | (15) | Yes | Unique identifier for the interface record. |
INTERFACE_TERM_DTLS_ID | NUMBER | (15) | Yes | Reference to the term details record |
UNIT | VARCHAR2 | (10) | Yes | Indicates the unit for the term |
UNIT_DIFFICULTY | NUMBER | (15) | Yes | Indicates the unit difficulty |
UNIT_NAME | VARCHAR2 | (80) | Yes | Holds the unit name |
STATUS | VARCHAR2 | (1) | Yes | Status of the interface record after processing.1 - Completed 2 - Pending 3 - Error 4 - Warning |
UNIT_DETAILS_ID | NUMBER | (15) | Holds the unique identifier of the system table which is loaded by the interface table. | |
CP_ATTEMPTED | NUMBER | (7) | Credit points attempted | |
CP_EARNED | NUMBER | (7) | Credit points earned | |
GRADE | VARCHAR2 | (10) | Indicates the grades earned. | |
UNIT_GRADE_POINTS | NUMBER | (7) | Unit grade points | |
MATCH_IND | VARCHAR2 | (2) | Indicates the match between the interface record and record present in the system. | |
ERROR_CODE | VARCHAR2 | (30) | Holds the error code for any error that occurred during processing. | |
DUP_TERM_UNITDTLS_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 program | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column for concurrent program | |
PROGRAM_ID | NUMBER | (15) | Standard who column for concurrent program | |
PROGRAM_UPDATE_DATE | DATE | Standard who column for concurrent program | ||
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 | |
TERM_DETAILS_ID | NUMBER | (15) | Term Details Identifier | |
ERROR_TEXT | VARCHAR2 | (2000) | Error Text |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_TERM_UNITDTLS_ID
, INTERFACE_TERM_DTLS_ID
, UNIT
, UNIT_DIFFICULTY
, UNIT_NAME
, STATUS
, UNIT_DETAILS_ID
, CP_ATTEMPTED
, CP_EARNED
, GRADE
, UNIT_GRADE_POINTS
, MATCH_IND
, ERROR_CODE
, DUP_TERM_UNITDTLS_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
, TERM_DETAILS_ID
, ERROR_TEXT
FROM IGS.IGS_AD_TUNDT_INT;
IGS.IGS_AD_TUNDT_INT does not reference any database object
IGS.IGS_AD_TUNDT_INT is referenced by following:
|
|
|