[Home] [Help] [Dependency Information]
Object Name: | IGS_HE_EXT_RUN_DTLS |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_HE_EXT_RUN_DTLS |
Subobject Name: | |
Status: | VALID |
Contains all the Extract Run Details for each run of the Extract process
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_HE_EXT_RUN_DTLS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EXTRACT_RUN_ID |
IGS_HE_EXT_RUN_DTLS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SUBMISSION_NAME
USER_RETURN_SUBCLASS RETURN_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTRACT_RUN_ID | NUMBER | Yes | Sequence generated column used to uniquely identify the extract run details | |
SUBMISSION_NAME | VARCHAR2 | (50) | Yes | Holds the Submission Name for the Extract process |
USER_RETURN_SUBCLASS | VARCHAR2 | (50) | Yes | User Defined Return Name |
RETURN_NAME | VARCHAR2 | (50) | Yes | Holds the Return Name of the Extract process |
EXTRACT_PHASE | VARCHAR2 | (30) | Yes | Indicates whether the Extract Phase is Internal or External |
STUDENT_EXT_RUN_ID | NUMBER | This contains the Extract run id for the student return. | ||
CONC_REQUEST_ID | NUMBER | Holds Run Concurrent Request Id | ||
CONC_REQUEST_STATUS | VARCHAR2 | (20) | Holds the Run Concurrent Request Status.Could be NEW, UPDATED, RUNNING, ERRORED, COMPLETED | |
EXTRACT_RUN_DATE | DATE | Determines the Extract process execution date | ||
FILE_NAME | VARCHAR2 | (30) | Determines the Data File Name | |
FILE_LOCATION | VARCHAR2 | (240) | Contains the location where data file can be found | |
DATE_FILE_SENT | DATE | Indicates the date on which data file was sent | ||
EXTRACT_OVERRIDE | VARCHAR2 | (3) | Flag to indicate whether the Extract data has been manually overwritten. | |
VALIDATION_KIT_RESULT | VARCHAR2 | (100) | Manually entered field to indicate the Validation Kit Result | |
HESA_VALIDATION_RESULT | VARCHAR2 | (100) | Manually entered field to indicate the HESA Validation Result | |
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 EXTRACT_RUN_ID
, SUBMISSION_NAME
, USER_RETURN_SUBCLASS
, RETURN_NAME
, EXTRACT_PHASE
, STUDENT_EXT_RUN_ID
, CONC_REQUEST_ID
, CONC_REQUEST_STATUS
, EXTRACT_RUN_DATE
, FILE_NAME
, FILE_LOCATION
, DATE_FILE_SENT
, EXTRACT_OVERRIDE
, VALIDATION_KIT_RESULT
, HESA_VALIDATION_RESULT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_HE_EXT_RUN_DTLS;
IGS.IGS_HE_EXT_RUN_DTLS does not reference any database object
IGS.IGS_HE_EXT_RUN_DTLS is referenced by following:
|
|
|