DW_LOAD_STATUS_MAPPING - Data Element Index


			<< go back

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

Data element	Definition
SCRIPT_NAME Indexed - no Format - varchar2(50) 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'.
JOB_NAME Indexed - no Format - varchar2(50) May be null? yes	A "friendlier" name for the script. For example, the job_name for the dwmsst_scr script is 'Student'.
GROUP_NAME Indexed - no Format - varchar2(50) May be null? yes	Provides a way to categorize scripts of the same type. For example, the Student, DTA, and BRS scripts all have the group_name 'Student Data'.
SYSTEM_JOB_NAME Indexed - no Format - varchar2(50) May be null? yes	The name of the job to which the script belongs. For example, the dwmsst_scr script is part of the DWST job.

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