Penn Computing

University of Pennsylvania
Penn Computing << go backback
DW_LOAD_STATUS Table - Data Element Index   Tables and Data Elements   Infrastructure Home   Data Warehouse Home

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.
DW_LOAD_STATUS Table - Data Element Index   Tables and Data Elements   Infrastructure Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania