Table 22. AIF_PS_JOBCODE_TBL_STG Table
| Column Name | Column Description |
|---|---|
| COMP_FREQUENCY | Compensation Frequency |
| DESCR | Description |
| EFFDT | Effective Date |
| EFF_STATUS | Status |
| STD_HOURS | Standard Hours |
Table 23. AIF_PS_JOB_STG Table
| Column Name | Column Description |
|---|---|
| ABSENCE_SYSTEM_CD | Absence System |
| ACCDNT_CD_FRA | Work Accident Code |
| ACCT_CD | Account Code |
| ADDS_TO_FTE_ACTUAL | Adds to FTE Actual Count |
| ANNL_BENEF_BASE_RT | Annual Benefit Base Rate |
| APPT_TYPE | Appointment Type |
| ASGN_END_DT | Assignment End Date |
| ASGN_START_DT | Assignment Start Date |
| AUTO_END_FLG | Auto End Job |
| BARG_UNIT | Bargaining Unit |
| BAS_ACTION | Benefits Administration Action |
| BAS_GROUP_ID | Benefits Administration Group ID |
| BENEFIT_SYSTEM | Benefits System |
| BORDER_WALKER | Cross Border Worker |
| CHANGE_AMT | Change Amount |
| CHANGE_PCT | Change Percent |
| CLASS_INDC | Classified/Unclassified Indicator |
| COBRA_ACTION | COBRA Action |
| COMPANY | Company |
| COMPRATE | Compensation Rate |
| COMP_FREQUENCY | Compensation Frequency |
| CONTRACT_NUM | Contract Number |
| CTG_RATE | Category Rate |
| CURRENCY_CD1 | Currency Code 1 |
| CUR_RT_TYPE | Currency Rate type |
| DAILY_RT | Daily Rate |
| DEPT_ENTRY_DT | Department Entry Date |
| DIRECTLY_TIPPED | Directly Tipped |
| EARNS_DIST_TYPE | Earnings Distribution Type |
| EEO_CLASS | EEO Class |
| ELIG_CONFIG1 | Eligibility Configuration Field 1 |
| ELIG_CONFIG2 | Eligibility Configuration Field 2 |
| ELIG_CONFIG3 | Eligibility Configuration Field 3 |
| ELIG_CONFIG4 | Eligibility Configuration Field 4 |
| ELIG_CONFIG5 | Eligibility Configuration Field 5 |
| ELIG_CONFIG6 | Eligibility Configuration Field 6 |
| ELIG_CONFIG7 | Eligibility Configuration Field 7 |
| ELIG_CONFIG8 | Eligibility Configuration Field 8 |
| ELIG_CONFIG9 | Eligibility Configuration Field 9 |
| EMPL_CTG | Employee Category |
| EMPL_CTG_L1 | Employee Subcategory |
| EMPL_CTG_L2 | Employee Subcategory 2 |
| ENCUMB_OVERRIDE | Encumbrance Override |
| ENTRY_DATE | Entry Date |
| ESTABID | Establishment ID |
| EXEMPT_HOURS_MONTH | Exempted Hours Month |
| EXEMPT_JOB_LBR | Exempted |
| EXPECTED_END_DATE | Expected Job End Date |
| EXPECTED_RETURN_DT | Expected Return Date |
| FLSA_STATUS | FLSA Status |
| FORCE_PUBLISH | Force Publish |
| FUNCTION_CD | Function Code |
| GL_PAY_TYPE | GL Pay type |
| GP_ASOF_DT_EXG_RT | Use Rate As Of |
| GP_DFLT_CURRTTYP | Use Pay Group Rate Type |
| GP_DFLT_ELIG_GRP | Use Pay Group Eligibility |
| GP_DFLT_EXRTDT | Use Pay Group As Of Date |
| GP_ELIG_GRP | Eligibility Group |
| GP_PAYGROUP | Pay Group |
| GRADE_ENTRY_DT | Salary Grade Entry Date |
| HIRE_DT | Hire Date |
| HOLIDAY_SCHEDULE | Holiday Schedule |
| HOURLY_RT | Hourly Rate |
| HOURLY_RT_FRA | Hourly Rate France |
| HR_STATUS | HR Status |
| INTERCTR_WRKS_CNCL | Works Council Role Role that the worker has in the union group |
| JOB_DATA_SRC_CD | Job Source Code |
| JOB_ENTRY_DT | Job Entry Date |
| JOB_INDICATOR | Job Indicator |
| LABOR_AGREEMENT | Labor Agreement |
| LABOR_FACILITY_ID | Labor Facility ID |
| LABOR_TYPE_GER | Labor Type Germany |
| LASTUPDDTTM | Last Update Date/Time |
| LASTUPDOPRID | Last Update User ID |
| LAST_DATE_WORKED | Last Date Worked |
| LAST_HIRE_DT | Last Hire Date |
| LAYOFF_EXEMPT_FLAG | Layoff Exempt Flag |
| LAYOFF_EXEMPT_RSN | Layoff Exempt Reason |
| LBR_FAC_ENTRY_DT | Labor Facility Entry Date |
| LDW_OVR | Override Last Date Worked |
| LST_ASGN_START_DT | Last Assignment Start Date |
| LUMP_SUM_PAY | Lump Sum Pay |
| MAIN_APPT_NUM_JPN | Main Appointment Number |
| MATRICULA_NBR | Matricula Number |
| MONTHLY_RT | Monthly Rate |
| OFFICER_CD | Officer Code |
| PAID_FTE | Paid FTE |
| PAID_HOURS | Paid Hours |
| PAID_HRS_FREQUENCY | Paid Hours Frequency |
| PAYGROUP | Pay Group |
| PAY_SYSTEM_FLG | Pay System Flag |
| PAY_UNION_FEE | Pay Union Fee |
| PERFORM_GROUP_GER | Perform Group Germany |
| PER_ORG | Organizational Relationship |
| POI_TYPE | Person of Interest Type |
| POSITION_ENTRY_DT | Position Entry Date |
| POSITION_OVERRIDE | Position Override |
| POSN_CHANGE_RECORD | Position Change Record |
| PRORATE_CNT_AMT | Prorate Contract Change Amount |
| REG_REGION | Regulatory Region |
| REPORTS_TO | Reports To |
| SETID_DEPT | SetID Department |
| SETID_JOBCODE | SetID Job Code |
| SETID_LBR_AGRMNT | SetID Labor Agreement |
| SETID_LOCATION | SetID Location |
| SETID_SALARY | SetID Salary |
| SETID_SUPV_LVL | SetID Supervisor Level |
| SHIFT | Shift |
| SHIFT_FACTOR | Shift Factor |
| SHIFT_RT | Shift Rate |
| SOC_SEC_RISK_CODE | Social Security Risk Code |
| SPK_COMM_ID_GER | Spokesman Committee ID |
| STD_HRS_FREQUENCY | Standard Hours Frequency |
| STEP_ENTRY_DT | Step Entry Date |
| SUPERVISOR_ID | Supervisor ID |
| SUPV_LVL_ID | Supervisor Level ID |
| TARIFF_AREA_GER | Tariff Area Germany |
| TARIFF_GER | Tariff Germany |
| TAX_LOCATION_CD | Tax Location Code |
| TERMINATION_DT | Termination Date |
| UNION_FEE_AMOUNT | Union Fee Amount |
| UNION_FEE_END_DT | Union Fee End Date |
| UNION_FEE_START_DT | Union Fee Start Date |
| UNION_FULL_PART | Union Participation |
| UNION_POS | Union Position |
| UNION_SENIORITY_DT | Union Seniority Date |
| VALUE_1_FRA | Value 1 |
| VALUE_2_FRA | Value 2 |
| VALUE_3_FRA | Value 3 |
| VALUE_4_FRA | Value 4 |
| VALUE_5_FRA | Value 5 |
| WORK_DAY_HOURS | Work Day Hours |
| WPP_STOP_FLAG | Stop Wage Progression |
| WRKS_CNCL_FUNCTION | Work Council Function |
| WRKS_CNCL_ROLE_CHE | Work Council Role |
Table 24. AIF_PS_POSITION_DATA_STG Table
| Column Name | Column Description |
|---|---|
| ADDS_TO_FTE_ACTUAL | Adds to FTE Actual Count |
| BARG_UNIT | Bargaining Unit |
| CLASS_INDC | Classified/Unclassified Indicator |
| COMPANY | Company |
| CONFIDENTIAL_POSN | Confidential Position |
| COUNTRY_CODE | Country Code |
| DESCRSHORT | Position Short Description |
| EG_ACADEMIC_RANK | Academic Rank |
| EG_GROUP | Service Calculation Group |
| ENCUMBER_INDC | Encumbrance Indicator |
| ENCUMB_SAL_AMT | Encumbrance Salary Amount |
| ENCUMB_SAL_OPTN | Encumbrance Salary Option |
| FLSA_STATUS | FLSA Status |
| FRI_HRS | Friday Hours |
| GRADE_FROM | Grade From |
| GRADE_TO | Grade To |
| GVT_AUDITED_BY_ID | Position Audited By |
| GVT_COMP_AREA | Competitive Area |
| GVT_COMP_LEVEL | Competitive Level |
| GVT_DRUG_TEST_REQ | Drug Test (Applicable) |
| GVT_DT_POSN_ESTAB | Date Position Established |
| GVT_EXEC_FIN_DISCL | Executive Financial Disclosure |
| GVT_FUND_SOURCE | Fund Source |
| GVT_INTEL_POSN | Intelligence Position |
| GVT_LAST_AUDIT_DT | Position Audit Date |
| GVT_LEO_POSITION | LEO/Fire Position |
| GVT_MAINT_REVIEWCD | Maintenance Review |
| GVT_MANTREV_RESULT | Maintenance Review Results |
| GVT_MOB_POSN_IND | Mobility Position |
| GVT_NFC_FUNCTN_CD | NFC Function Code (NFC - National Finance Center) |
| GVT_NFC_PI_IND_OVR | Override NFC Indicator |
| GVT_NTE_DATE | Not to Exceed Date |
| GVT_OBLIGATED_TO | Obligated To ID |
| GVT_OBLIG_EXPIR_DT | Obligation Expiration |
| GVT_OCC_SERIES | Occupational Series |
| GVT_ORG_NUMCD1 | Numeric Code 1 |
| GVT_ORG_NUMCD2 | Numeric Code 2 |
| GVT_ORG_NUMCD3 | Numeric Code 3 |
| GVT_ORG_NUMCD4 | Numeric Code 4 |
| GVT_ORG_NUMCD5 | Numeric Code 5 |
| GVT_ORG_NUMCD6 | Numeric Code 6 |
| GVT_ORG_NUMCD7 | Numeric Code 7 |
| GVT_ORG_SUBAGENCY | Organizational Structure |
| GVT_ORG_TTL_CD | Organization Position Title Code |
| GVT_ORG_TTL_DESCR | Organization Position Title |
| GVT_PAREN_TITLE | Parenthetical Title |
| GVT_PAR_NBR | Personnel Action Request Number |
| GVT_PAY_PLAN | Pay Plan |
| GVT_PERF_PLAN | Performance Plan |
| GVT_PI_UPD_IND | PI Update Indicator |
| GVT_POI | Personnel Office ID |
| GVT_POSN_LOC | Position Location |
| GVT_POSN_OCCUPIED | Position Occupied |
| GVT_POSN_SENS_CD | Sensitivity Code |
| GVT_PRESIDENT_APPT | Presidential Appt Position |
| GVT_PROC_INTEG_PSN | Procurement Integration Position |
| GVT_STAFF_LINE | Staff/Line Position |
| GVT_STATUS_TYPE | Status Type |
| GVT_SUB_AGENCY | Sub-Agency |
| GVT_TARGET_GRADE | Target Grade |
| GVT_VACY_REVW_CD | Vacancy Review Code |
| GVT_WIP_STATUS | Work-In-Progress Status |
| GVT_WORK_SCHED | Work Schedule |
| HEALTH_CERTIFICATE | Health Certificate |
| INCLUDE_SALPLN_FLG | Include Salary Plan Flag |
| JOB_SHARE | Job Share |
| KEY_POSITION | Key Position |
| LANGUAGE_SKILL | Language Skill |
| LASTUPDDTTM | Last Update Date/Time |
| LASTUPDOPRID | Last Update User ID |
| LOCATION | Location |
| MAIL_DROP | Mail Drop |
| MANAGER_LEVEL | Manager Level |
| MILITARY_SERVICE | Military Service |
| MIL_RANK | Military Rank |
| MIL_SVC_COMP_CD | Military Service Component |
| MON_HRS | Monday Hours |
| ORGCODE | Organization Hierarchy Code |
| ORGCODE_FLAG | Organization Hierarchy Flag |
| PHONE | Phone |
| PKG_RULE_ID | Package Rule ID |
| PKG_TEMPLATE_ID | Package Template ID |
| POSITION_POOL_ID | Position Pool ID |
| REG_REGION | Regulatory Region |
| REPORTS_TO | Reports To |
| REPORT_DOTTED_LINE | Report Dotted Line |
| SAT_HRS | Saturday Hours |
| SEASONAL | Seasonal |
| SEC_CLEARANCE_TYPE | Security Clearance Type |
| SHIFT | Shift |
| SIGN_AUTHORITY | Signing Authority |
| STATUS_DT | Status Date |
| STD_HRS_FREQUENCY | Standard Hours Frequency |
| STEP_FROM | Step From |
| STEP_TO | Step To |
| SUN_HRS | Sunday Hours |
| SUPV_LVL_ID | Supervisory Level ID |
| THURS_HRS | Thursday Hours |
| TRN_PROGRAM | Training Program |
| TUES_HRS | Tuesday Hours |
| UPDATE_INCUMBENTS | Update Incumbents |
| WED_HRS | Wednesday Hours |
Table 25. AIF_PS_SAL_GRADE_TBL_STG Table
| Column Name | Column Description |
|---|---|
| DESCR | Grade Description |
| DESCRSHORT | Grade Description Short |
| EFFDT | Effective Date |
| EFF_STATUS | Effective Status |
| ELIGIBILITY_POINTS | Eligibility Points |
| EMPL_CTG | Employee Category |
| EMPL_CTG_L1 | Employee Subcategory |
| EMPL_CTG_L2 | Employee Subcategory 2 |
| GRADE | Grade |
| GRADE_TITLE_JPN | Grade Title Japan |
| GVT_MAX_RT_BIWK | Maximum Pay Rate - Bi-weekly |
| GVT_MID_RT_BIWK | Midpoint Pay Rate - Bi-weekly |
| GVT_MIN_RT_BIWK | Minimum Pay Rate - Bi-weekly |
| LABOR_AGREEMENT | Labor Agreement |
| MAX_YRS_GRADE | Max Years Grade |
| MIN_GRD_AGE | Minimum Grade Age |
| MIN_YRS_GRADE | Minimum Years Grade |
| REG_REGION | Regulatory Region |
| REVIEW_COUNT | Review Count |
| SALARY_MATRIX_CD | Salary Matrix Code |
| SAL_ADMIN_PLAN | Salary Administration Plan |
| SETID | SetID |
| STEP_INCREM_ACCUM | Step Increment Accumulated |
| STEP_INCREM_TYPE | Step Increment Type |
Table 26. AIF_PS_SAL_STEP_TBL_STG Table
| Column Name | Column Description |
|---|---|
| APS_MAX_CLS_AUS | Maximum Classification |
| APS_MIN_CLS_AUS | Minimum Classification |
| CLASSN_CURRENT_AUS | Job Classification |
| DAILY_RT | Daily Rate |
| EFFDT | Effective Date |
| GRADE | Grade |
| GVT_BIWEEKLY_RT | Bi-weekly Rate |
| GVT_INCREM_DAYS | Days to Next Step Increment |
| GVT_INCREM_WEEKS | Weeks to Next Step Increment |
| GVT_STEP | US Federal Step |
| GVT_WGI_ADJ | Within Grade Increase (WGI) Adjustment |
| INCREM_HOURS | Increment Hours |
| INCREM_MONTHS | Increment Months |
| SAL_ADMIN_PLAN | Salary Administration Plan |
| SETID | SetID |
| STEP_DESCR | Step Description |
Table 27. AIF_PS_BP_JOB_STG Table
| Column Name | Column Description |
|---|---|
| ACCDNT_CD_FRA | Account Code France |
| ACCT_CD | Account Code |
| ACTION | Action |
| ACTION_DT | Action Date |
| ACTION_REASON | Action Reason |
| ADDS_TO_FTE_ACTUAL | Adds to FTE Actual Count |
| ANNL_BENEF_BASE_RT | Annual Benefit Base Rate |
| ANNL_BEN_BASE_OVRD | Annual Benefit Base Overhead |
| ANNUAL_RT | Annual Rate |
| APPT_TYPE | Appointment Type |
| BARG_UNIT | Bargaining Unit |
| BAS_ACTION | Benefits Administration Action |
| BAS_GROUP_ID | Benefits Administration Group ID |
| BENEFIT_PROGRAM | Benefit Program |
| BENEFIT_SYSTEM | Benefit System |
| BEN_STATUS | Benefit Status |
| BORDER_WALKER | Cross Border Worker |
| BUSINESS_UNIT | Business Unit |
| CHANGE_AMT | Change Amount |
| CHANGE_PCT | Change Percent |
| CLASS_INDC | Classified/Unclassified Indicator |
| COBRA_ACTION | COBRA Action |
| COMPANY | Company |
| COMPRATE | Compensation Rate |
| COMP_FREQUENCY | Compensation Frequency |
| CONTRACT_NUM | Contract Number |
| CTG_RATE | Category Rate |
| CURRENCY_CD | Currency Code |
| CURRENCY_CD1 | Currency Code 1 |
| CUR_RT_TYPE | Currency Rate type |
| DAILY_RT | Daily Rate |
| DEPTID | Department |
| DEPT_ENTRY_DT | Department Entry Date |
| DIRECTLY_TIPPED | Directly Tipped |
| EARNS_DIST_TYPE | Earnings Distribution Type |
| EEO_CLASS | EEO_Class |
| EFFDT | Effective Date |
| EFFSEQ | Effective Sequence |
| ELIG_CONFIG1 | Eligibility Configuration Field 1 |
| ELIG_CONFIG2 | Eligibility Configuration Field 2 |
| ELIG_CONFIG3 | Eligibility Configuration Field 3 |
| ELIG_CONFIG4 | Eligibility Configuration Field 4 |
| ELIG_CONFIG5 | Eligibility Configuration Field 5 |
| ELIG_CONFIG6 | Eligibility Configuration Field 6 |
| ELIG_CONFIG7 | Eligibility Configuration Field 7 |
| ELIG_CONFIG8 | Eligibility Configuration Field 8 |
| ELIG_CONFIG9 | Eligibility Configuration Field 9 |
| EMPLID | Employee ID |
| EMPL_CLASS | Employee Classification |
| EMPL_CTG | Employee Category |
| EMPL_CTG_L1 | Employee Subcategory |
| EMPL_CTG_L2 | Employee Subcategory 2 |
| EMPL_RCD | Employee Record Number |
| EMPL_STATUS | Employee Status |
| EMPL_TYPE | Employee Type |
| ENCUMB_OVERRIDE | Encumbrance Override |
| ENTRY_DATE | Entry Date |
| ESTABID | Establishment ID |
| EXEMPT_HOURS_MONTH | Exempted Hours Month |
| EXEMPT_JOB_LBR | Exempted |
| FICA_STATUS_EE | FICA Status |
| FLSA_STATUS | FLSA Status |
| FORCE_PUBLISH FTE | Force Publish FTE |
| FULL_PART_TIME | Full or Part-Time |
| FUNCTION_CD | Function Code |
| GL_PAY_TYPE | GL Pay type |
| GP_ASOF_DT_EXG_RT | Use Rate As Of |
| GP_DFLT_CURRTTYP | Use Pay Group Rate Type |
| GP_DFLT_ELIG_GRP | Use Pay Group Eligibility |
| GP_DFLT_EXRTDT | Use Pay Group As Of Date |
| GP_ELIG_GRP | Eligibility Group |
| GP_PAYGROUP | Pay Group |
| GRADE | Grade |
| GRADE_ENTRY_DT | Grade Entry Date |
| GVT_ANNL_RT_NO_LOC | Annuity Rate |
| GVT_ANNUITY_OFFSET | Annuity Offset |
| GVT_ANNUIT_COM_DT | Annuity Date |
| GVT_ANN_IND | Annuity |
| GVT_BASIC_LIFE_RED | Basic Life Red |
| GVT_BIWEEKLY_RT | Biweekly Rate |
| GVT_BW_RT_NO_LOC | Biweekly Rate No Location |
| GVT_CHANGE_FLAG | Change Flag |
| GVT_COMPRATE | Compensate Rate |
| GVT_CONT_EMPLID | Contract Employee ID |
| GVT_CSRS_FROZN_SVC | CSRS Frozen Service |
| GVT_DAILY_RT | Daily Rate |
| GVT_DED_PRORT_DT | DED Prorate Date |
| GVT_DETL_POSN_NBR | Position Number |
| GVT_DLY_RT_NO_LOC | Daily Rate No Location |
| GVT_EFFDT | Effective Date |
| GVT_EFFDT_PROPOSED | Effective Date Proposed |
| GVT_ELIG_FEHB | Eligibility FEHB |
| GVT_FEGLI | FEGLI Code |
| GVT_FEGLI_BASC_PCT | FEGLI Basic Percent |
| GVT_FEGLI_LIVING | FEGLI Living Benefits |
| GVT_FEGLI_OPT_PCT | FEGLI Opted Percent |
| GVT_FEHB_DT | FEHB Date |
| GVT_FEHB_PCT | FEHB Percent |
| GVT_FERS_COVERAGE | FERS Coverage |
| GVT_HRLY_RT_NO_LOC | Hourly Rate No Location |
| GVT_LEG_AUTH_1 | Legal Authority 1 |
| GVT_LEG_AUTH_2 | Legal Authority 2 |
| GVT_LEO_POSITION | LEO/Fire Position (LEO - Law enforcement officer) |
| GVT_LIVING_AMT | Living Amount |
| GVT_LOCALITY_ADJ | Locality Adjustment |
| GVT_MNLY_RT_NO_LOC | Monthly Rate No Location |
| GVT_NID_CHANGE | NID Change |
| GVT_NOA_CODE | NOA Code |
| GVT_OTH_PAY_CHG | Other Pay Change |
| GVT_PAR_AUTH_D1 | Authority 1 Description - Part 1 |
| GVT_PAR_AUTH_D1_2 | Authority 1 Description - Part 2 |
| GVT_PAR_AUTH_D2 | Authority 2 Description - Part 1 |
| GVT_PAR_AUTH_D2_2 | Authority 2 Description - Part 1 |
| GVT_PAR_NTE_DATE | NTE Date |
| GVT_PAY_BASIS | Pay Basis |
| GVT_PAY_FLAG | Pay Flag |
| GVT_PAY_PLAN | Pay Plan |
| GVT_PAY_RATE_DETER | Pay Rate Determinant |
| GVT_PI_UPD_IND | PI Update Indicator |
| GVT_POI | Personnel Office ID |
| GVT_POSN_OCCUPIED | Position Occupied |
| GVT_PREV_RET_COVRG | Previous Retirement Coverage |
| GVT_RETIRE_PLAN | Retire Plan |
| GVT_RETRO_BSE_FLAG | Retrospective Base Flag |
| GVT_RETRO_DED_FLAG | Retrospective Deduction Flag |
| GVT_RETRO_FLAG | Retrospective Flag |
| GVT_RETRO_JOB_FLAG | Retrospective Job Flag |
| GVT_ROUTE_NEXT | Route to Next |
| GVT_RTND_GRADE | Retained Grade |
| GVT_RTND_GVT_STEP | Retained Government Step |
| GVT_RTND_PAY_PLAN | Retained Pay Plan |
| GVT_RTND_SAL_PLAN | Retained Salary Plan |
| GVT_RTND_STEP | Retained Step |
| GVT_S113G_CEILING | S113G Ceiling |
| GVT_SF52_NBR | SF52 Number |
| GVT_STATUS_TYPE | Status Type |
| GVT_STEP | Step |
| GVT_SUB_AGENCY | Sub Agency |
| GVT_TRANS_NBR | Transaction Number |
| GVT_TRANS_NBR_SEQ | Transaction Number Sequence |
| GVT_TSP_UPD_IND | TSP Status |
| GVT_TYPE_OF_APPT | Type of Appointment |
| GVT_WIP_STATUS | WIP Status |
| GVT_WORK_SCHED | Work Schedule |
| GVT_XFER_FROM_AGCY | Transfer From Agency |
| GVT_XFER_TO_AGCY | Transfer To Agency |
| HOLIDAY_SCHEDULE | Holiday Schedule |
| HOURLY_RT | Hourly Rate |
| HOURLY_RT_FRA | Hourly Rate France |
| INTERCTR_WRKS_CNCL | Works Council Role |
| JOBCODE | Job Code |
| JOB_DATA_SRC_CD | Job Source Code |
| JOB_ENTRY_DT | Job Entry Date |
| JOB_INDICATOR | Job Indicator |
| LABOR_AGREEMENT | Labor Agreement |
| LABOR_FACILITY_ID | Labor Facility ID |
| LABOR_TYPE_GER | Labor Type Germany |
| LAYOFF_EXEMPT_FLAG | Layoff Exempt Flag |
| LAYOFF_EXEMPT_RSN | Layoff Exempt Reason |
| LBR_FAC_ENTRY_DT | Labor Facility Entry Date |
| LOCATION | Location |
| LUMP_SUM_PAY | Lump Sum Pay |
| MAIN_APPT_NUM_JPN | Main Appointment Number |
| MATRICULA_NBR | Matricula Number |
| MONTHLY_RT | Monthly Rate |
| OFFICER_CD | Officer Code |
| PAID_FTE | Paid FTE |
| PAID_HOURS | Paid Hours |
| PAID_HRS_FREQUENCY | Paid Hours Frequency |
| PAYGROUP | Pay Group |
| PAY_SYSTEM_FLG | Pay System Flag |
| PAY_UNION_FEE | Pay Union Fee |
| PERFORM_GROUP_GER | Perform Group Germany |
| POSITION_ENTRY_DT | Position Entry Date |
| POSITION_NBR | Position Number |
| POSITION_OVERRIDE | Position Override |
| POSN_CHANGE_RECORD | Position Change Record |
| PRORATE_CNT_AMT | Prorate Contract Change Amount |
| REG_REGION | Regulatory Region |
| REG_TEMP | Regular or Temporary |
| REPORTS_TO | Reports To |
| SAL_ADMIN_PLAN | Salary Administration Plan |
| SETID_DEPT | SetID Department |
| SETID_JOBCODE | SetID Job Code |
| SETID_LBR_AGRMNT | SetID Labor Agreement |
| SETID_LOCATION | SetID Location |
| SETID_SALARY | SetID Salary |
| SHIFT | Shift |
| SHIFT_FACTOR | Shift Factor |
| SHIFT_RT | Shift Rate |
| SOC_SEC_RISK_CODE | Social Security Risk Code |
| SPK_COMM_ID_GER | Spokesman Committee ID |
| STD_HOURS | Standard Hours |
| STD_HRS_FREQUENCY | Standard Hours |
| STEP | Frequency Step |
| STEP_ENTRY_DT | Step Entry Date |
| SUPERVISOR_ID | Supervisor ID |
| TARIFF_AREA_GER | Tariff Area Germany |
| TARIFF_GER | Tariff Germany |
| TAX_LOCATION_CD | Tax Location Code |
| UNION_CD | Union Code |
| UNION_FEE_AMOUNT | Union Fee Amount |
| UNION_FEE_END_DT | Union Fee End Date |
| UNION_FEE_START_DT | Union Fee Start Date |
| UNION_FULL_PART | Union Participation |
| UNION_POS | Union Position |
| UNION_SENIORITY_DT | Union Seniority Date |
| UPDATE_PAYROLL | Update Payroll |
| VALUE_1_FRA | Value 1 |
| VALUE_2_FRA | Value 2 |
| VALUE_3_FRA | Value 3 |
| VALUE_4_FRA | Value 4 |
| VALUE_5_FRA | Value 5 |
| WORK_DAY_HOURS | Work Day Hours |
| WPP_STOP_FLAG | Stop Wage Progression |
| WRKS_CNCL_FUNCTION | Work Council Function |
| WRKS_CNCL_ROLE_CHE | Work Council Role |