DW_LOAD_STATUS Table
Explanation
There is one row in the table per script. At the beginning of the update, the master script will post the BEGIN_TIME and set the END_TIME and RETURN_CODE to NULL. At the end of the update, the master script will post the END_TIME and RETURN_CODE for that script. It will do so for both normal and abnormal completion.
If END_TIME and RETURN_CODE are NULL, then the script has started but has not yet completed.
Use the DW_LOAD_STATUS_MAPPING table to find the script name for the desited data collection(s).
Common Uses
Determining whether the load to a particular warehouse data collection is still underway, and if finished, did it finish successfully.
| Primary Key |
Indexed Data Elements |
Related Tables |
NONE
|
NONE
|
DW_LOAD_STATUS_MAPPING
|
Cautions
- The DW_LOAD_STATUS table is stored in the DWADMIN schema in the Data Warehouse. Access is granted automatically to anyone with the Payroll or Student roles in the warehouse and the warehouse technical support team. If you try to access the table and get the message “table or view does not exist”, contact ISC Data Administration.
Questions about this page? Email us at da-staff@isc.upenn.edu
| 
