| Dataset: | Adhoc_Benefits_Enrollment |
| Datalake Tables: | CHRS.DL_ORGANIZATION_HIERARCHY_MAXEFFDT CHRS.DL_CSU_HEALTH_PERM CHRS.DL_BENEFIT_ENROLL_WHISTORY |
| PS Tables: | PSTREENODE PSTREELEAF PSTREEDEFN PS_DEPT_TBL PS_TREE_NODE_TBL PS_CSU_HEALTH_PERM "PS_BEN_DEFN_PGM PSXLATITEM PS_BEN_DEFN_OPTN PS_BN_RATE_DATA PS_BN_RATE_TBL PS_BEN_DEFN_COST PS_BENEF_PLAN_TBL PS_DEDUCTION_TBL PS_COVRG_CD_TBL PS_BEN_DEFN_PLAN PS_BEN_PROG_PARTIC PS_BENEFIT_PARTIC PS_HEALTH_BENEFIT, PS_FSA_BENEFIT, PS_DISABILITY_BEN, PS_LIFE_ADD_BEN PS_PERSONAL_DATA PS_JOB PS_PRIMARY_JOBS PS_CSU_JOB |
| Dataset Data Elements: | Headcount Business Unit Department Employee ID Latest Job Flag business_unit Employee RCD POI Type Per Org Org Instance Ern Benefit Rcd Nbr Home Host Class Cmpny Dt Ovr Cmpny Seniority Dt Service Dt Ovr Service Dt Sen Pay Dt Ovr Seniority Pay Dt Prof Experience Dt Last Verificatn Dt Probation Dt Last Increase Dt Own 5percent Co Business Title Position Phone Last Child Upddtm Orig Hire Ovr Orig Hire Dt Org Inst Srv Ovr Org Inst Srv Dt Nee Provider Id Effdt Effseq deptid Deptid Jobcode Position Nbr Supervisor Id Hr Status Appt Type Main Appt Num Jpn Position Override Posn Change Record Empl Status Action Action Dt Action Reason Location Tax Location Cd Job Entry Dt Dept Entry Dt Position Entry Dt Shift Reg Temp Full Part Time Company Paygroup Bas Group Id Elig Config1 Elig Config2 Elig Config3 Elig Config4 Elig Config5 Elig Config6 Elig Config7 Elig Config8 Elig Config9 Ben Status Bas Action Cobra Action Empl Type Holiday Schedule Std Hours Std Hrs Frequency Officer Cd Empl Class Sal Admin Plan Grade Grade Entry Dt Step Step Entry Dt Gl Pay Type Acct Cd Earns Dist Type Comp Frequency Comprate Change Amt Change Pct Annual Rt Monthly Rt Daily Rt Hourly Rt Annl Benef Base Rt Shift Rt Shift Factor Currency Cd Setid Dept Setid Jobcode Setid Location Setid Salary Setid Empl Class Reg Region State Directly Tipped Flsa Status Eeo Class Function Cd Tariff Ger Tariff Area Ger Perform Group Ger Labor Type Ger Spk Comm Id Ger Hourly Rt Fra Accdnt Cd Fra Value 1 Fra Value 2 Fra Value 3 Fra Value 4 Fra Value 5 Fra Ctg Rate Paid Hours Paid Fte Paid Hrs Frequency Union Full Part Union Pos Matricula Nbr Soc Sec Risk Code Union Fee Amount Union Fee Start Dt Union Fee End Dt Exempt Job Lbr Exempt Hours Month Wrks Cncl Function Interctr Wrks Cncl Currency Cd1 Pay Union Fee Union Cd Barg Unit Union Seniority Dt Entry Date Labor Agreement Empl Ctg Empl Ctg L1 Empl Ctg L2 Setid Lbr Agrmnt Wpp Stop Flag Labor Facility Id Lbr Fac Entry Dt Layoff Exempt Flag Layoff Exempt Rsn Gp Paygroup Gp Dflt Elig Grp Gp Elig Grp Gp Dflt Currttyp Cur Rt Type Gp Dflt Exrtdt Gp Asof Dt Exg Rt Adds To Fte Actual Class Indc Encumb Override Fica Status Ee Fte Prorate Cnt Amt Pay System Flg Border Walker Lump Sum Pay Contract Num Job Indicator Wrks Cncl Role Che Benefit System Work Day Hours Reports To Force Publish Job Data Src Cd Estabid Supv Lvl Id Setid Supv Lvl Absence System Cd Hire Dt Last Hire Dt Termination Dt Asgn Start Dt Lst Asgn Start Dt Asgn End Dt Ldw Ovr Last Date Worked Expected Return Dt Expected End Date Auto End Flg Csu Prob Cd Csu Prob Dt Csu Anni Cd Csu Anni Month Csu Anni Year Csu Red Circle Dt Csu Ssi Counter Csu Payroll Status Csu Legal Ref Csu Ferp Elig End Csu Appt Dur Csu Dip Elig Month Csu Dip Elig Year Csu Sab Elig Month Csu Sab Elig Year Csu Ret Cd Csu Grand Lec Cd Csu Ppt Run Dt Csu Unit Csu Primary Fund Pay End Dt Csu Sco Agency Csu Sco Serial Item Type Csu Fract Num Csu Fract Denom Oprid Csu Item 215 Csu Furlough 306 Csu Furlough 815 Csu Furlough 957 Csu Fmi Award Csu Ssi Start Dt Comments 256 Taxcode Uk Tax Basis Uk Worker Type Mex Reduced Week Mex Located Cd Mex Salary Type Mex Ims Term Dt Mex Balance Grp Num Fp Action 2 Fp Legalstat Cd Fp Scndmt Cd Fp Scnd Typ Fp Civil Pension Fp Source Org Fp Recep Org Fp Return Cd Fp Pr Legsta Fp Forend Dt Fp End Dt Fp Carefrzpct Fp Hir Dos Sit Fp Pt Pct Det Fp Title Num Fp Duration Pct Fp Rating Prs Flg Fp Budget Nbr Fp Hdcnt Nbr Fp Potent Nbr Fp Rank Cd Fp Step Cd Fp Rk Ent Dt Fp Corps Cd Fp Chg Cor Dt Fp Catg Fp Fp Catg Level Fp Rk Trialpd Fp Step End Dt Fp For Prom Dt Fp Nomination Dt Fp Trainee Fp Trne Posn Fp Rk Pd End Dt Fp Sanction Fp Down Gra Fp Appl Sal Dt Fp Chg Ind Fp Cld Inst Fp Setid Rank Fp Install Dt Fp Equiv Step Fp Step Cd2 Fp Business Cd Fp Appl Dt Fp Chg Sal Fp Pointyp Cd Fp Gross Ind Fp Incs Ind Fp Incs Ind2 Fp Pt Pct Fp Pt End Dt Fp Pt Forend Dt Fp Comprate Fp Inst Stat Fp Retrospect Fp Row End Dt Last Update Date Other Id Jpn Intcp Xfr Flg Intcp Xfr Start Dt Intcp Xfr End Dt Intcp Bus Unit Intcp Deptid Intcp Deptid2 Intcp Setid Dept Intcp Company Intcp Company2 Intcp Supv Lvl Id Intcp Supv Lvl Id2 Start Date Jpn Exp End Date Jpn End Date Jpn Duties Type Assignment Id Target Comprate Cmp Dont Absorb Ssn Employer Unita Prod Cd Action Ita Action Reason Ita Special Hirctg Ita Part Time Type Ita Part Time Perc Ita Parttime Enddt Ita Workdays Nld Cont Sal Type Bra Cbo Cd Bra Sefip Category Bra Union Cd Alt Bra Els Status Latest Job Flg End Effdt Current Flg Name Dept Descr Dept Descrshort Dept Company Dept Setid Location Dept Location Jobcode Descr Jobcode Descrshort Job Family Job Family Descr Job Family Descrshort Job Function Job Function Descr Job Function Descrshort Stdnt Emp Jobcdgrp Indicator Ipedsscode Us Soc Cd Position Descr Position Descrshort Position Status Csu Mpp Job Family Csu Mpp Job Func Csu Mpp Rpt Cat Csu Working Title Csu Mpp Func Descr Csu Job Code Title Csu Job Title Shor Mpp Csu Aa Cd Mpp Ipedsscode Mpp Us Soc Cd Sal Admin Plan Descr Sal Admin Plan Descrshort Grade Title Jpn Union Cd Descr Union Cd Descrshort Ipeds Rpt Criteria Indicator Appointment Sequence CSUBU OHD Empl Rcd CSUBU OHD Effdt CSUBU OHD Effseq CSU BU Campus Hire Date CSU BU OHD Ovrride CSU BU Tenure-Track Hire Date CSU BU Tenure-Track Ovrride CSUBU Tenure-Track Start Empl Rcd CSUBU Tenure-Track Start Effdt CSUBU Tenure-Track Start Effseq Tree Name Set ID (Dept) Department (Dept) Dept ID (Dept) 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