Created by Corina C Larsen, last modified by Miki Yanagi on Sep 19, 2022
This table contains all job data for employees.
Additional pay data, such as stipend, is not included.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| ABSENCE_SYSTEM_CD - Absence System | Char3 | N | Absence System | |
| ACCDNT_CD_FRA - Work Accident Type Code | Char1 | Wrk Accid. | ||
| ACCT_CD - Combination Code | Char25 | Combo Code | ||
| ACTION - Action | Char3 | Action | ||
| ACTION_DT - Action Date | Date | Action Date | ||
| ACTION_REASON - Reason Code | Char3 | Reason | ||
| ADDS_TO_FTE_ACTUAL - Adds to FTE Actual Count | Char1 | Add to FTE | ||
| ANNL_BENEF_BASE_RT - Annual Benefits Base Rate | Num16.3 | Ann Ben Rt | ||
| ANNUAL_RT - Annual Rate | Num16.3 | Annual Rt | ||
| APPT_TYPE - Appointment Type | Char1 | N | Appt Type | |
| ASGN_END_DT - Assignment End Date | Date | End Date | ||
| ASGN_START_DT - First Assignment Start | Date | First Start | ||
| AUTO_END_FLG - End Job Automatically | Char1 | Auto End Job | ||
| BARG_UNIT - Bargaining Unit | Char4 | Barg Unit | ||
| BAS_ACTION - Benefits Administration Action | Char3 | BAS Action | ||
| BAS_GROUP_ID - BAS Group ID | Char3 | BAS Group | ||
| BENEFIT_SYSTEM - Benefits System | Char2 | N | Benefits System | |
| BEN_STATUS - Benefits Employee Status | Char4 | N | Ben Status | |
| BORDER_WALKER - Cross Border Worker | Char1 | Cross Border W. | ||
| BUSINESS_UNIT - Business Unit | Char5 | Unit | ||
| CHANGE_AMT - Change Amount | SNm14.6 | Chng Amt | ||
| CHANGE_PCT - Change Percent | SNm5.3 | Pct | ||
| CLASS_INDC - Classified/Unclassified Ind | Char1 | N | Class/Uncl | |
| COBRA_ACTION - COBRA Action | Char3 | CBR Action | ||
| COMPANY - Company | Char3 | Co | ||
| COMPRATE - Compensation Rate | Num13.6 | Comp Rate | ||
| COMP_FREQUENCY - Compensation Frequency | Char5 | Comp Freq | ||
| CONTRACT_NUM - Contract Number | Char25 | Contract Nbr | ||
| CTG_RATE - Category Rate | Num3.0 | Rate | ||
| CURRENCY_CD - Currency Code | Char3 | Currency | ||
| CURRENCY_CD1 - Currency Code | Char3 | Currency | ||
| CUR_RT_TYPE - Exchange Rate Type | Char5 | Rate Type | ||
| DAILY_RT - Daily Rate | Num16.3 | Daily Rt | ||
| DEPTID - Department | Char10 | Dept ID | ||
| DEPT_ENTRY_DT - Department Entry Date | Date | Dept Date | ||
| DIRECTLY_TIPPED - Tipped | Char1 | N | Tipped | |
| EARNS_DIST_TYPE - Earnings Distribution Type | Char1 | N | Dist type | |
| EEO_CLASS - EEO Classification | Char1 | N | EEO Class | |
| → | EFFDT - Effective Date | Date | Eff Date | |
| → | EFFSEQ - Effective Sequence | Num3.0 | Sequence | |
| ELIG_CONFIG1 - Eligibility Config Field 1 | Char10 | Elig Fld 1 | ||
| ELIG_CONFIG2 - Eligibility Config Field 2 | Char10 | Elig Fld 2 | ||
| ELIG_CONFIG3 - Eligibility Config Field 3 | Char10 | Elig Fld 3 | ||
| ELIG_CONFIG4 - Eligibility Config Field 4 | Char10 | Elig Fld 4 | ||
| ELIG_CONFIG5 - Eligibility Config Field 5 | Char10 | Elig Fld 5 | ||
| ELIG_CONFIG6 - Eligibility Config Field 6 | Char10 | Elig Fld 6 | ||
| ELIG_CONFIG7 - Eligibility Config Field 7 | Char10 | Elig Fld 7 | ||
| ELIG_CONFIG8 - Eligibility Config Field 8 | Char10 | Elig Fld 8 | ||
| ELIG_CONFIG9 - Eligibility Config Field 9 | Char10 | Elig Fld 9 | ||
| → | EMPLID - Empl ID | Char11 | ID | |
| EMPL_CLASS - Employee Classification | Char3 | Empl Class | ||
| EMPL_CTG - Employee Category | Char6 | Category | ||
| EMPL_CTG_L1 - Employee Subcategory | Char6 | Subcategory | ||
| EMPL_CTG_L2 - Employee Subcategory 2 | Char6 | Subcategory 2 | ||
| → | EMPL_RCD - Empl Record | Num3.0 | Empl Record | |
| EMPL_STATUS - Payroll Status | Char1 | N | Pay Status | |
| EMPL_TYPE - Employee Type | Char1 | Type | ||
| ENCUMB_OVERRIDE - Encumbrance Override | Char1 | Enc Overrd | ||
| ENTRY_DATE - Date Entered | Date | Entered | ||
| ESTABID - Establishment ID | Char12 | Estab ID | ||
| EXEMPT_HOURS_MONTH - Exempted Hours per Month | Num3.0 | Exempt.Hours | ||
| EXEMPT_JOB_LBR - Exempted | Char1 | Exempted | ||
| EXPECTED_END_DATE - Expected Job End Date | Date | Planned Exit | ||
| EXPECTED_RETURN_DT - Expected Return Date | Date | Return Dt | ||
| FICA_STATUS_EE - FICA Status-Employee | Char1 | N | FICA EE | |
| FLSA_STATUS - FLSA Status | Char1 | N | FLSA Stat | |
| FORCE_PUBLISH - Force Publish | Date | Force Publis | ||
| FTE - FTE | Num2.6 | FTE | ||
| FULL_PART_TIME - Full/Part Time | Char1 | N | Full/Part | |
| FUNCTION_CD - Function Code | Char2 | Functn Cd | ||
| GL_PAY_TYPE - General Ledger Pay Type | Char6 | GL Pay Type | ||
| GP_ASOF_DT_EXG_RT - Use Rate As Of | Char1 | N | Rate As Of | |
| GP_DFLT_CURRTTYP - Use Pay Group Rate Type | Char1 | Rate Type | ||
| GP_DFLT_ELIG_GRP - Use Pay Group Eligibility | Char1 | Eligibility | ||
| GP_DFLT_EXRTDT - Use Pay Group As Of Date | Char1 | Date | ||
| GP_ELIG_GRP - Eligibility Group | Char10 | Elig Grp | ||
| GP_PAYGROUP - Pay Group | Char10 | Pay Group | ||
| GRADE - Salary Grade | Char3 | Grade | ||
| GRADE_ENTRY_DT - Grade Entry Date | Date | Grade Date | ||
| HIRE_DT - First Start Date | Date | Start Date | ||
| HOLIDAY_SCHEDULE - Holiday Schedule | Char6 | Hol Sched | ||
| HOURLY_RT - Hourly Rate | Num13.6 | Hrly Rate | ||
| HOURLY_RT_FRA - Hours Type | Char3 | Hours Type | ||
| HR_STATUS - HR Status | Char1 | N | HR Status | |
| INTERCTR_WRKS_CNCL - InterCtr.Works Cnil Function | Char1 | N | InterCtr.Wrks.F | |
| JOBCODE - Job Code | Char6 | Job Code | ||
| JOB_DATA_SRC_CD - Job Source Code | Char3 | N | Job Source | |
| JOB_ENTRY_DT - Job Entry Date | Date | Entry Date | ||
| JOB_INDICATOR - Job Indicator | Char1 | N | Indicator | |
| LABOR_AGREEMENT - Labor Agreement | Char6 | Labor Agreement | ||
| LABOR_FACILITY_ID - Labor Facility ID | Char10 | Labor Facility | ||
| LABOR_TYPE_GER - Labor Type | Char1 | N | Labor Type | |
| LASTUPDDTTM - Last Update Date/Time | DateTm | Last Upd DtTm | ||
| LASTUPDOPRID - by | Char30 | by | ||
| LAST_DATE_WORKED - Last Date Worked | Date | Last Date | ||
| LAST_HIRE_DT - Last Start Date | Date | Last Start | ||
| LAYOFF_EXEMPT_FLAG - Exempt from Layoff | Char1 | Exempt Layoff | ||
| LAYOFF_EXEMPT_RSN - Layoff Exemption Reason | Char11 | Reason | ||
| LBR_FAC_ENTRY_DT - Labor Facility Entry Date | Date | Entry Date | ||
| LDW_OVR - Override Last Date Worked | Char1 | Override | ||
| LOCATION - Location Code | Char10 | Location | ||
| LST_ASGN_START_DT - Last Assignment Start Date | Date | Last Asgn Start | ||
| LUMP_SUM_PAY - Lump Sum Retro Payment | Char1 | LumpSum Pay | ||
| MAIN_APPT_NUM_JPN - Main Appointment Number | Num3.0 | Main Appt Num | ||
| MATRICULA_NBR - Matricula Number | Num5.0 | Matricula Nbr. | ||
| MONTHLY_RT - Monthly Rate | Num16.3 | Monthly Rt | ||
| OFFICER_CD - Officer Code | Char1 | N | Officer Cd | |
| PAID_FTE - Paid FTE | Num2.6 | Paid FTE | ||
| PAID_HOURS - Paid Hours | Num5.2 | Paid Hrs | ||
| PAID_HRS_FREQUENCY - Paid Work Period | Char5 | Work Period | ||
| PAYGROUP - Pay Group | Char3 | Group | ||
| PAY_SYSTEM_FLG - Payroll System | Char2 | N | Payroll System | |
| PAY_UNION_FEE - Pay Union Fee | Char1 | Pay Union Fee | ||
| PERFORM_GROUP_GER - Performance Group | Char2 | N | Performance Grp | |
| PER_ORG - Organizational Relationship | Char3 | N | Org Relation | |
| POI_TYPE - Person of Interest Type | Char5 | POI Type | ||
| POSITION_ENTRY_DT - Position Entry Date | Date | Posn Dt | ||
| POSITION_NBR - Position Number | Char8 | Position | ||
| POSITION_OVERRIDE - Override Position Data | Char1 | Posn Ovrd | ||
| POSN_CHANGE_RECORD - Position Management Record | Char1 | Posn Rcd | ||
| PRORATE_CNT_AMT - Prorate Contract Change Amount | Char1 | N | Prorate Change | |
| REG_REGION - Regulatory Region | Char5 | Reg Region | ||
| REG_TEMP - Regular/Temporary | Char1 | N | Reg/Temp | |
| REPORTS_TO - Reports To Position Number | Char8 | Reports To | ||
| SAL_ADMIN_PLAN - Salary Administration Plan | Char4 | Sal Plan | ||
| SETID_DEPT - Department Set ID | Char5 | Dept Set ID | ||
| SETID_EMPL_CLASS - EMPL_CLASS Set ID | Char5 | EMPL_CLASSSetID | ||
| SETID_JOBCODE - Job Code Set ID | Char5 | Jobcode Set ID | ||
| SETID_LBR_AGRMNT - Labor Agreement Set ID | Char5 | Lab.Agmt SetI D | ||
| SETID_LOCATION - Location Set ID | Char5 | Location Set ID | ||
| SETID_SALARY - Salary Set ID | Char5 | Salary Set ID | ||
| SETID_SUPV_LVL - Supervisor Level Setid | Char5 | Sup Lvl Setid | ||
| SHIFT - Regular Shift | Char1 | N | Shift | |
| SHIFT_FACTOR - Shift Differential Factor | Num2.3 | Shift Fctr | ||
| SHIFT_RT - Shift Differential Rate | Num13.6 | Shift Rate | ||
| SOC_SEC_RISK_CODE - Occupation Code | Char3 | Occupation | ||
| SPK_COMM_ID_GER - Spokesmen Committee ID | Char9 | Spokesmen Comm. | ||
| STD_HOURS - Standard Hours | Num5.2 | Stnd Hrs/Wk | ||
| STD_HRS_FREQUENCY - Standard Work Period | Char5 | Work Period | ||
| STEP - Step | Num2.0 | Step | ||
| STEP_ENTRY_DT - Step Entry Date | Date | Step Date | ||
| SUPERVISOR_ID - Supervisor ID | Char11 | Supv ID | ||
| SUPV_LVL_ID - Supervisor Level | Char8 | Supervisor Lvl | ||
| TARIFF_AREA_GER - Tariff Area | Char3 | Tariff Area | ||
| TARIFF_GER - Tariff | Char2 | N | Tariff | |
| TAX_LOCATION_CD - Tax Location Code | Char10 | Tax Loc | ||
| TERMINATION_DT - Termination Date | Date | Term Date | ||
| UNION_CD - Union Code | Char3 | Union Code | ||
| UNION_FEE_AMOUNT - Union Fee Amount | Num7.2 | Union Fee Amt. | ||
| UNION_FEE_END_DT - Union Fee End Date | Date | Fee End Date | ||
| UNION_FEE_START_DT - Union Fee Start Date | Date | Fee St.Date | ||
| UNION_FULL_PART - Union Participation | Char1 | N | Participation | |
| UNION_POS - Union Position | Char1 | N | Union Position | |
| UNION_SENIORITY_DT - Union Seniority Date | Date | Union Date | ||
| VALUE_1_FRA - Value 1 | Char5 | Value 1 | ||
| VALUE_2_FRA - Value 2 | Char5 | Value 2 | ||
| VALUE_3_FRA - Value 3 | Char5 | Value 3 | ||
| VALUE_4_FRA - Value 4 | Char5 | Value 4 | ||
| VALUE_5_FRA - Value 5 | Char5 | Value 5 | ||
| WORK_DAY_HOURS - Number of Hours in a Work Day | Num5.2 | Work Day Hours | ||
| WPP_STOP_FLAG - Stop Wage Progression | Char1 | Stop WPP | ||
| WRKS_CNCL_FUNCTION - Works Council Function | Char1 | N | Wrks.Cncl.Funct | |
| WRKS_CNCL_ROLE_CHE - Work Council Role | Char30 | Work Council Ro |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.