| Dataset: | AdHoc_Employee |
|---|---|
| Datalake Tables: | CHRS.DL_EMAIL_ADDR CHRS.DL_ORGANIZATION_HIERARCHY_MAXEFFDT CHRS.DL_EMPLOYEES CHRS.DL_PER_ORG_ASGN CHRS.DL_PRIMARY_JOBS CHRS.DL_JOB CHRS.DL_CSU_JOB |
| PS Tables: | PS_EMAIL_ADDRESSES PSTREENODE PSTREELEAF PSTREEDEFN PS_DEPT_TBL PS_TREE_NODE_TBL PS_EMPLOYEES PS_PER_ORG_ASGN PS_PRIMARY_JOBS 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_CSU_JOB |
| Dataset Data Elements: | business_unit 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 CSU Mpp Job Family CSU Mpp Job Func CSU Mpp Rpt Cat CSU Mpp Func Descr CSU Job Code Title CSU Job Title Shor CSU Aa Cd Ipedsscode Us Soc Cd E Addr Type Email Addr Pref Email Flag Emplid Empl Rcd Birthdate Birthplace Dt Of Death Country Nm Format Country Name Name Initials Name Prefix Name Suffix Name Royal Prefix Name Royal Suffix Name Title Last Name Srch First Name Srch Last Name First Name Middle Name Second Last Srch Second Last Name Name Ac Pref First Name Last Name Pref Nld Country Country Address1 Address2 Address3 Address4 City City Num1 Num2 House Type Addr Field1 Addr Field2 Addr Field3 County County State State Postal Postcode Geo Code In City Limit City Home Phone National Id Type Sex Mar Status Highest Educ Lvl Ft Student Military Status Us Work Eligibilty Milit Situatn Fra Disabled Disabled Vet Ethnic Group Two Races Ind Usa Citizenship Status Orig Hire Dt Per Org Benefit Rcd Nbr Cmpny Seniority Dt Service Dt Home Host Class Last Increase Dt Own 5percent Co Business Title Probation Dt Effdt (Employees) Effseq (Employees) Hire Dt Expected Return Dt Termination Dt Last Date Worked Reports To Supervisor Id Business Unit Deptid Jobcode Position Nbr Empl Status Action Action Dt Action Reason Location Job Entry Dt Dept Entry Dt Position Entry Dt Shift Reg Temp Full Part Time Flsa Status Officer Cd Company Paygroup Empl Type Holiday Schedule Std Hours Std Hrs Frequency Reg Region State Paid Hours Paid Fte Paid Hrs Frequency Fte Eeo Class Sal Admin Plan Grade Grade Entry Dt Step Step Entry Dt Gl Pay 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 Directly Tipped Pay System Flg Setid Dept Setid Jobcode Setid Location Setid Salary Gp Paygroup Gp Elig Grp Cur Rt Type Gp Asof Dt Exg Rt Job Indicator 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 Value 1 Fra Value 2 Fra Value 3 Fra Value 4 Fra Value 5 Fra Gvt Scd Retire Gvt Mand Ret Dt Gvt Scd Tsp Gvt Scd Sevpay Gvt Dt Lei Gvt Pay Basis Gvt Wgi Status Gvt Wgi Due Date Gvt Intrm Days Wgi Gvt Locality Adj Gvt Work Sched Gvt Sevpay Prv Wks Gvt Biweekly Rt Gvt Step Gvt Rtnd Pay Plan Gvt Rtnd Sal Plan Gvt Rtnd Grade Gvt Rtnd Step Gvt Rtnd Gvt Step Gvt Rtnd Grade Beg Gvt Rtnd Grade Exp Gvt Temp Pro Expir Gvt Temp Psn Expir Gvt Detail Expires Gvt Sabbatic Expir Gvt Type Of Appt Gvt Appt Expir Dt Gvt Career Cnv Due Gvt Supv Prob Dt Gvt Ses Prob Dt Gvt Sec Clr Status Gvt Clrnce Stat Dt Eeo1code Eeo4code Eeo5code Eeo6code Eeo Job Group Job Family Job Knowhow Points Job Accntab Points Job Probslv Points Job Points Total Job Knowhow Pct Job Accntab Pct Job Probslv Pct Ipedsscode (Employees) Gvt Org Ttl Descr Manager Id Eeo4 Function Asofdate Fromdate Jobtitle Jobtitle Abbrv Deptname Deptname Abbrv Rehire Dt Work Phone Nid Country Country Gvt Overtime Rt Gvt Rtnd Pay Basis Sec Clearance Type CSU Prob Cd (Employees) CSU Prob Dt (Employees) CSU Anni Cd (Employees) CSU Anni Month (Employees) CSU Anni Year (Employees) CSU Red Circle Dt (Employees) CSU Ssi Counter (Employees) CSU Payroll Status (Employees) CSU Legal Ref (Employees) CSU Ferp Elig End (Employees) Comprate Used CSU Appt Dur (Employees) CSU Dip Elig Month (Employees) CSU Dip Elig Year (Employees) CSU Sab Elig Month (Employees) CSU Sab Elig Year (Employees) CSU Ret Cd (Employees) CSU Grand Lec Cd (Employees) CSU Ppt Run Dt (Employees) CSU Unit (Employees) CSU Primary Fund (Employees) CSU Sco Agency (Employees) CSU Sco Serial (Employees) CSU Furlough 306 (Employees) CSU Furlough 815 (Employees) CSU Furlough 957 (Employees) CSU Fmi Award (Employees) CSU Ssi Start Dt (Employees) Empl Class Expected End Date Mil Dischrg Dt Usa Disability Sts Usa Effdt Effseq Per Org (Job) Deptid (Job) Jobcode (Job) Position Nbr (Job) Supervisor Id (Job) Hr Status Appt Type Main Appt Num Jpn Position Override Posn Change Record Empl Status (Job) Action (Job) Action Dt (Job) Action Reason (Job) Location (Job) Tax Location Cd Job Entry Dt (Job) Dept Entry Dt (Job) Position Entry Dt (Job) Shift (Job) Reg Temp (Job) Full Part Time (Job) Company (Job) Paygroup (Job) 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 (Job) Holiday Schedule (Job) Std Hours (Job) Std Hrs Frequency (Job) Officer Cd (Job) Empl Class (Job) Sal Admin Plan (Job) Grade (Job) Grade Entry Dt (Job) Step (Job) Step Entry Dt (Job) Gl Pay Type (Job) Acct Cd Earns Dist Type Comp Frequency (Job) Comprate (Job) Change Amt (Job) Change Pct (Job) Annual Rt (Job) Monthly Rt (Job) Daily Rt (Job) Hourly Rt (Job) Annl Benef Base Rt (Job) Shift Rt (Job) Shift Factor (Job) Currency Cd (Job) Business Unit (Job) Setid Dept (Job) Setid Jobcode (Job) Setid Location (Job) Setid Salary (Job) Setid Empl Class Reg Region (Job) State Directly Tipped (Job) Flsa Status (Job) Eeo Class (Job) 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 (Job) Value 2 Fra (Job) Value 3 Fra (Job) Value 4 Fra (Job) Value 5 Fra (Job) Ctg Rate Paid Hours (Job) Paid Fte (Job) Paid Hrs Frequency (Job) 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 (Job) Union Cd (Job) Barg Unit (Job) Union Seniority Dt (Job) Entry Date (Job) Labor Agreement (Job) Empl Ctg (Job) Empl Ctg L1 (Job) Empl Ctg L2 (Job) Setid Lbr Agrmnt (Job) Wpp Stop Flag (Job) Labor Facility Id (Job) Lbr Fac Entry Dt (Job) Layoff Exempt Flag (Job) Layoff Exempt Rsn (Job) Gp Paygroup (Job) Gp Dflt Elig Grp Gp Elig Grp (Job) Gp Dflt Currttyp Cur Rt Type (Job) Gp Dflt Exrtdt Gp Asof Dt Exg Rt (Job) Adds To Fte Actual Class Indc Encumb Override Fica Status Ee Fte (Job) Prorate Cnt Amt Pay System Flg (Job) Border Walker Lump Sum Pay Contract Num Job Indicator (Job) Wrks Cncl Role Che Benefit System Work Day Hours Reports To (Job) Force Publish Job Data Src Cd Estabid Supv Lvl Id Setid Supv Lvl Absence System Cd Poi Type Hire Dt (Job) Last Hire Dt Termination Dt (Job) Asgn Start Dt Lst Asgn Start Dt Asgn End Dt Ldw Ovr Last Date Worked (Job) Expected Return Dt (Job) Expected End Date (Job) Auto End Flg Lastupddttm Lastupdoprid CSU Prob Cd (Job) CSU Prob Dt (Job) CSU Anni Cd (Job) CSU Anni Month (Job) CSU Anni Year (Job) CSU Red Circle Dt (Job) CSU Ssi Counter (Job) CSU Payroll Status (Job) CSU Legal Ref (Job) CSU Ferp Elig End (Job) CSU Appt Dur (Job) CSU Dip Elig Month (Job) CSU Dip Elig Year (Job) CSU Sab Elig Month (Job) CSU Sab Elig Year (Job) CSU Ret Cd (Job) CSU Grand Lec Cd (Job) CSU Ppt Run Dt (Job) CSU Unit (Job) CSU Primary Fund (Job) Pay End Dt (Job) CSU Sco Agency (Job) CSU Sco Serial (Job) Item Type (Job) CSU Fract Num (Job) CSU Fract Denom (Job) Oprid (Job) CSU Item 215 (Job) CSU Furlough 306 (Job) CSU Furlough 815 (Job) CSU Furlough 957 (Job) CSU Fmi Award (Job) CSU Ssi Start Dt (Job) Comments 256 (Job) 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 (Job) Dept Descr Dept Descrshort Dept Company Dept Setid Location Dept Location Jobcode Descr Jobcode Descrshort Job Family (Job) Job Family Descr Job Family Descrshort Job Function Job Function Descr Job Function Descrshort Stdnt Emp Jobcdgrp Indicator Ipedsscode (Job) Us Soc Cd (Job) Position Descr Position Descrshort Position Status CSU Working Title CSU Mpp Func Descr (Job) CSU Job Code Title (Job) CSU Job Title Shor (Job) 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 CSU BU Ohd Empl Rcd CSU BU Ohd Effdt CSU BU Ohd Effseq CSU Bu Ohd CSU Bu Ohd Ovrride CSU Bu T Start CSU Bu Ten Ovrride CSU BU T Start Empl Rcd CSU BU T Start Effdt CSU BU T Start Effseq Ipeds Rpt Criteria Indicator Org Instance Ern Benefit Rcd Nbr (Job) Home Host Class (Job) Cmpny Dt Ovr Cmpny Seniority Dt (Job) Service Dt Ovr Service Dt (Job) Sen Pay Dt Ovr Seniority Pay Dt Prof Experience Dt Last Verificatn Dt Probation Dt (Job) Last Increase Dt (Job) Own 5percent Co (Job) Business Title (Job) Position Phone Last Child Upddtm Orig Hire Dt (Job) Orig Hire Ovr Org Inst Srv Ovr Org Inst Srv Dt Nee Provider Id Export Date Process Date Per Org (Per Org Asgn) Org Instance Ern (Per Org Asgn) Poi Type (Per Org Asgn) Benefit Rcd Nbr (Per Org Asgn) Home Host Class (Per Org Asgn) Cmpny Dt Ovr (Per Org Asgn) Cmpny Seniority Dt (Per Org Asgn) Service Dt Ovr (Per Org Asgn) Service Dt (Per Org Asgn) Sen Pay Dt Ovr (Per Org Asgn) Seniority Pay Dt (Per Org Asgn) Prof Experience Dt (Per Org Asgn) Last Verificatn Dt (Per Org Asgn) Probation Dt (Per Org Asgn) Last Increase Dt (Per Org Asgn) Own 5percent Co (Per Org Asgn) Business Title (Per Org Asgn) Position Phone (Per Org Asgn) Last Child Upddtm (Per Org Asgn) Nee Provider Id (Per Org Asgn) Org Inst Srv Dt (Per Org Asgn) Org Inst Srv Ovr (Per Org Asgn) Orig Hire Dt (Per Org Asgn) Orig Hire Ovr (Per Org Asgn) Lastupddttm (Per Org Asgn) Lastupdoprid (Per Org Asgn) Primary Job App Primary Job Ind Primary Flag1 Primary Flag2 Primary Jobs Src Job Effseq Job Empl Rcd Tree Name Set ID (Dept) 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