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