Penn Computing

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

DW_LOAD_STATUS Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
SCRIPT_NAME

Indexed - no
Format - varchar2(20)
May be null? yes
The name of the script that, when run, loads the data for a specific data collection.

For example, the script_name for the Student job is 'dwmsst_scr'.

BEGIN_TIME

Indexed - no
Format - date
May be null? yes
Date and time that the script started, the last time it was run.
END_TIME

Indexed - no
Format - date
May be null? yes
Date and time that the script finished, the last time it was run.
RETURN_CODE

Indexed - no
Format - VARCHAR2(1)
May be null? yes

A code that indicates whether the job has completed, and if so, if it completed successrully without errors. A code of 0 means the job is done and there were no errors.

   NULL = job still in progress
   0 = successful completion
   2 = failure


DW_LOAD_STATUS Table   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