RETURN TO DIMENSION TABLE REPORTS LIST
Employee Position Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_JOB

Description Job Dimension table provides information on the current placement of an employee in a position. This information is the job suffix. It uses the cleansing rules in the EDW for the short and long description.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
JOB_KEY Key for the job dimension. This key permits all of the information below to be only for this position and job suffix and not all positions if more than one is held by the employee. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYEE POSITION

JOB_SUFFIX Number or suffix associated with this position assignment. VARCHAR2(63)

EMPLOYEE_POSITION

JOB_SUFFIX

NO

NO

EMPLOYEE POSITION

JOB_SUFFIX_LD Long description assigned during the EDW cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

EMPLOYEE POSITION

JOB_SUFFIX_SD Short description assigned during the EDW cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

EMPLOYEE POSITION

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO

EMPLOYEE POSITION

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO

EMPLOYEE POSITION



Ver: 3.1