Job Data
Job data is information about an employee's job—for example, hiring, promotion, change of position, salary increase, and so forth. Each employee will have one or more changes occurring to his or her Job Data record.
The Job Data folder is a subfolder of the Individuals folder when building selection criteria for an audience.
Field Label Name |
Field Name |
Use Type |
---|---|---|
Employee ID |
EMPLID |
Map Field Choice to Prompt |
Employee Record Number |
RA_EMPL_RCD |
Text |
Effective Date |
EFFDT |
Date |
Effective Sequence |
RA_EFFSEQ |
Text |
Department ID |
DEPTID |
Map Field Choice to Prompt |
Job Code |
JOBCODE |
Map Field Choice to Prompt |
Position Number |
POSITION_NBR |
Text |
Employee Status |
EMPL_STATUS |
Map Field Choice to Prompt |
Action |
ACTION |
Map Field Choice to Prompt |
Action Date |
ACTION_DT |
Date |
Action Reason |
ACTION_REASON |
Text |
Location |
LOCATION |
Map Field Choice to Prompt |
Tax Location Code |
TAX_LOCATION_CD |
Text |
Job Entry Date |
JOB_ENTRY_DT |
Date |
Department Entry Date |
DEPT_ENTRY_DT |
Date |
Position Entry Date |
POSITION_ENTRY_DT |
Date |
Shift |
SHIFT |
Map Field Choice to Prompt |
Regular or Temp |
REG_TEMP |
Map Field Choice to Prompt |
Full or Part Time |
FULL_PART_TIME |
Map Field Choice to Prompt |
Company |
COMPANY |
Text |
Pay Group |
PAYGROUP |
Text |
BAS Group ID |
BAS_GROUP_ID |
Text |
Benefits Employee Status |
BEN_STATUS |
Text |
Benefits Administration Action |
BAS_ACTION |
Text |
COBRA Action |
COBRA_ACTION |
Text |
Employee Type |
EMPL_TYPE |
Text |
Holiday Schedule |
HOLIDAY_SCHEDULE |
Text |
Standard Hours Frequency |
STD_HRS_FREQUENCY |
Text |
Officer Code |
OFFICER_CD |
Map Field Choice to Prompt |
Employee Class |
EMPL_CLASS |
Map Field Choice to Prompt |
Salary Administration Plan |
SAL_ADMIN_PLAN |
Text |
Salary Grade |
GRADE |
Text |
Grade Entry Date |
GRADE_ENTRY_DT |
Date |
Step Entry Date |
STEP_ENTRY_DT |
Date |
Salary Matrix Code |
SALARY_MATRIX_CD |
Text |
Rating Scale |
RATING_SCALE |
Text |
Review Rating |
REVIEW_RATING |
Text |
Review Date |
REVIEW_DT |
Date |
Compensation Rating |
COMP_FREQUENCY |
Map Field Choice to Prompt |
Currency Code |
CURRENCY_CD |
Map Field Choice to Prompt |
Business Unit |
BUSINESS_UNIT |
Text |
Department SetID |
SETID_DEPT |
Map Field Choice to Prompt |
Job Code SetID |
SETID_JOBCODE |
Map Field Choice to Prompt |
Location SetID |
SETID_LOCATION |
Map Field Choice to Prompt |
Salary SetID |
SETID_SALARY |
Text |
Regulatory Region |
REG_REGION |
Text |
Tipped |
DIRECTLY_TIPPED |
Map Field Choice to Prompt |
FLSA Status |
FLSA_STATUS |
Map Field Choice to Prompt |
EEO Classification |
EEO_CLASS |
Map Field Choice to Prompt |
Function Code |
FUNCTION_CD |
Text |
Establishment ID |
ESTABID |
Text |
Paid Work Period |
PAID_HRS_FREQUENCY |
Text |
Benefit Program |
BENEFIT_PROGRAM |
Text |
Union Full or Part Time |
UNION_FULL_PART |
Text |
Union Position |
UNION_POS |
Text |
Productive Unit |
UNITA_PROD_CD |
Text |
Union Code |
UNION_CD |
Text |
Bargaining Unit |
BARG_UNIT |
Text |
Union Seniority Date |
UNION_SENIORITY_DT |
Date |
Date Entered |
ENTRY_DT |
Date |
Labor Agreement |
LABOR_AGREEMENT |
Text |
Employee Category |
EMPL_CTG |
Text |
Employee Subcategory |
EMPL_CTG_L1 |
Text |
Employee Subcategory 2 |
EMPL_CTG_L2 |
Text |
FICA Status - Employee |
FICA_STATUS_EE |
Map Field Choice to Prompt |
Supervisor ID |
SUPERVISOR_ID |
Map Field Choice to Prompt |
Reports To |
REPORTS_TO |
Text |
HR Status |
HR_STATUS |
Map Field Choice to Prompt |
Organization Relationship |
PER_ORG |
Map Field Choice to Prompt |
POI Type |
POI_TYPE |
Text |
Hire Date |
HIRE_DT |
Date |
Termination Date |
TERMINATION_DT |
Date |
Assignment Start |
ASGN_START_DT |
Date |
Assignment End |
ASGN_END_DT |
Date |
Last Date Worked |
LAST_DATE_WORKED |
Date |
Compensation Rate |
COMPRATE |
Decimal |
Change Amount |
CHANGE_AMT |
Decimal |
Annual Rate |
ANNUAL_RT |
Decimal |
Monthly Rate |
MONTHLY_RT |
Decimal |
Daily Rate |
DAILY_RT |
Decimal |
Hourly Rate |
HOURLY_RT |
Decimal |
Annual Benefits Base Rate |
ANNL_BENEF_BASE_RT |
Decimal |
Shift Differential Rate |
SHIFT_RT |
Decimal |
Standard Hours |
RA_STD_HOURS |
Text |
Step |
RA_STEP |
Text |
Change Percent |
RA_CHANGE_PCT |
Text |
Shift Factor |
RA_SHIFT_FACTOR |
Text |
Category Rate |
RA_CTG_RATE |
Text |
Paid Hours |
RA_PAID_HOURS |
Text |
Paid FTE |
RA_PAID_FTE |
Text |
FTE |
RA_FTE |
Text |
Work Day Hours |
RA_WORK_DAY_HOURS |
Text |