CHRS Knowledge Base

Dataset Specification_AdHoc_dl_employment

Updated on

Dataset: Adhoc_dl_employment
Datalake Tables: CHRS.DL_ADDRESSES
CHRS.DL_EMPLOYMENT
CHRS.DL_EMAIL_ADDR
CHRS.DL_ORGANIZATION_HIERARCHY_MAXEFFDT
PS Tables: PS_ADDRESSES
PS_JOB
PS_CSU_JOB
PS_JOB_JR
PS_SAL_GRADE_TBL
PS_CSU_SAL_GRADE
PS_JOB_FAMILY_TBL
PS_JOBFUNCTION_TBL
PS_JOBCODE_TBL
PS_CSU_POSN_DATA
PS_POSITION_DATA
PS_UNION_TBL
PS_PERSONAL_DATA
PS_DEPT_TBL
PS_PER_ORG_INST
PS_PER_ORG_ASGN
PS_CSU_JOBCD_GRP_A
PS_CSU_BU_OHD
PS_CSU_BU_T_START
PS_CSU_JOBCD_GRP
PS_NAMES
PS_EMPL_CLASS_TBL
PS_EMAIL_ADDRESSES
PSTREENODE
PSTREELEAF
PSTREEDEFN
PS_DEPT_TBL
PS_TREE_NO
PS_CSU_BEN_RPT_TBL
Dataset Data Elements: Employee ID
Employee RCD
Effective Date
Workgroup
Taskgroup
Task Profile ID
Time Reporting Status
PCH TR Template ID
Time Reporter Indicator
Job Emplid
Job Empl RCD
Employee Name
Dept ID
CSU Unit
Job Code
Employee Status
Employee Class
Employee Type
HR Status
Union Code
Job Effective Date
Job Effective Seq
Expected End Date
Paygroup
Paygroup Descr
Paygroup Fdescr
Company
Action Date
Reports To
Standard Hours
TL Group ID
Group Type Ind
TL Group Descr
TL Group Fdescr
Row Sec Class
Opr Class
Duration
TRC
TL Quantity
Seq Number
Exception ID
Comments
Exception Source
Message Data 1
Message Data 2
Message Data 4
Exception Status
Run Control ID
Exception Descr
Exception Fdescr
Severity
Tree Name
Set ID (Dept)
business_unit
Business Unit
Department (Dept)
Dept ID (Dept)
deptid
Dept Descr (Dept)
Effective Date (Dept)
Tree Effective Date
Dept Level1
Dept Level2
Dept Level3
Dept Level4
Dept Level5
Dept Level6
Dept Level7
Level1
Level1 Descr
Level2
Level2 Descr
Level3
Level3 Descr
Level4
Level4 Descr
Level5
Level5 Descr
Level6
Level6 Descr
Level7
Level7 Descr

End of Article

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article (job aid) Dataset Specification_AdHoc_DependentHealthBenefit
Next Article (job aid) Dataset Specification_AdHoc_Employee
Do you need an article? Contact Us