SDTE_EXTRACT_RUN_DETAIL
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SDTE_EXTRACT_RUN_DETAIL_PK |
RUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RUN_ID | NUMBER | 18 | Yes | Primary Key to capture the RunID | |
| EXTRACT_ID | NUMBER | 18 | Yes | Foreign key to extract_details table. | |
| SC_DETAIL_ID | NUMBER | 18 | foreign key to schedule details table. | ||
| EXTRACT_FILTER_ID | NUMBER | 18 | foreign key to filter details table. | ||
| SRC_LASTUPDATETIME | TIMESTAMP | Yes | lastUpdateTime to start the next extraction from.Default filter condition. TBD for AV which field can use. | ||
| JOB_STATUS | VARCHAR2 | 10 | Yes | Status of the extraction execution. | |
| ACTUAL_JOB_STARTTIME | TIMESTAMP | Yes | Approximate Job start times in SBS. | ||
| ACTUAL_JOB_ENDTIME | TIMESTAMP | Yes | Approximate Job end time in SBS. | ||
| SCHEDULE_STARTTIME | TIMESTAMP | Approximate Schedule start time in ESS. | |||
| SCHEDULE_ENDTIME | TIMESTAMP | Approximate Schedule end time in ESS. | |||
| EXTRACT_OUTPUT_ROW_COUNT | NUMBER | 18 | Yes | Number of rows in the output of the extraction request. | |
| EXTRACT_OUTPUT_FILE_COUNT | NUMBER | 18 | Yes | written output files count. | |
| UPLOAD_SUCCESS_FLAG | NUMBER | 1 | Flag to record if the outpput files are successsfully uploaded into OCI object storage. | ||
| NEXT_EXECUTION_TIME | TIMESTAMP | Calculate the next run time. | |||
| JOB_TYPE | VARCHAR2 | 10 | Yes | Scheduled job type and supported enum values are Series or Adhoc or Full. | |
| ADHOC_JOB_START_TIME | TIMESTAMP | If JOB_TYPE is ADHOC, the from start time is captured. | |||
| ADHOC_JOB_END_TIME | TIMESTAMP | If job type is ADHOC, to end time is captured. | |||
| ADD_FD_1 | VARCHAR2 | 4000 | Additional Field. | ||
| ADD_FD_2 | VARCHAR2 | 4000 | Additional Field. | ||
| ADD_FD_3 | NUMBER | 18 | Additional Field | ||
| ADD_FD_4 | NUMBER | 18 | Additional FIeld | ||
| ADD_FD_5 | BLOB | Additional FIeld | |||
| ADD_FD_6 | BLOB | Additional FIeld | |||
| ADD_FD_7 | TIMESTAMP | Additional Field | |||
| ADD_FD_8 | TIMESTAMP | Additional Field | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SDTE_EXTRACT_RUN_DETAIL_U1 | Unique | Default | RUN_ID |