In order to build audiences based on the HR attributes of an employee or person of interest, or to personalize email or survey content with HR data, the HR data must exist in CRM as profiles. The following tables show data elements that do not exist in CRM, but that are brought over using the Workforce Sync EIP. This data is available for the purpose of building audiences and for personalization of email and survey content.
See Also
PeopleSoft Enterprise Customer Relationship Management Business Object Management Preface
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 |
The following table shows the data from the Job Data – Global Table that is available as selection criteria for building audiences. It appears as a subfolder of the Individuals folder.
Field Label Name |
Field Name |
Use Type |
Employee ID |
EMPLID |
Map Field Choice to Prompt |
Employee Record |
RA_EMPL_RCD |
Text |
Effective Date |
EFFDT |
Date |
Effective Sequence |
RA_EFFSEQ |
Text |
Tariff |
TARIFF_GER |
Text |
Tariff Area |
TARIFF_AREA_GER |
Text |
Performance Group |
PERFORM_GROUP_GER |
Text |
Labor Type |
LABOR_TYPE_GER |
Text |
Spokesman Committee ID |
SPK_COMM_ID_GER |
Text |
Works Council Member |
WRKS_CNCL_MEM_GER |
Text |
Hours Type |
HOURLY_RATE_FRA |
Text |
Work Accident Type Code |
ACCDNT_CD_FRA |
Text |
Value 1 |
VALUE_1_FRA |
Text |
Value 2 |
VALUE_2_FRA |
Text |
Value 3 |
VALUE_3_FRA |
Text |
Value 4 |
VALUE_4_FRA |
Text |
Value 5 |
VALUE_5_FRA |
Text |
Turnover Action |
ACTION_ITA |
Text |
Turnover Action Reason |
ACTION_REASON_ITA |
Text |
Works Council Function |
WRKS_CNCL_FUNCTION |
Text |
Intercenter Works Council Function |
INTERCTR_WRKS_CNCL |
Text |
Pay Group |
GP_PAYGROUP |
Text |
Use Pay Group Value |
GP_DFLT_ELIG_GRP |
Text |
Eligibility Group |
GP_ELIG_GRP |
Text |
Use Pay Group Value 2 |
GP_DFLT_CURRTTYP |
Text |
Use Pay Group Value 3 |
GP_DFLT_EXRTDT |
Text |
Use Rate As Of |
GP_ASOF_DT_EXG_RT |
Text |
Cross Border Worker |
BORDER_WALKER |
Text |
Work Council Role |
WRKS_CNCL_ROLE_CHE |
Text |
Works Council ID |
WRKS_CNCL_ID_LCL |
Text |
Matricula Number |
RA_MATRICULA_NBR |
Text |
The following table shows the data from the Job Data – Global Table that is available as selection criteria for building audiences. It appears as a subfolder of the Individuals folder.
Field Label Name |
Field Name |
Use Type |
Employee ID |
EMPLID |
Map Field Choice to Prompt |
Employee Record |
RA_EMPL_RCD |
Text |
Effective Date |
EFFDT |
Date |
Effective Sequence |
RA_EFFSEQ |
Text |
Effective Date - Government |
GVT_EFFDT |
Date |
Proposed Effective Date |
GVT_EFFDT_PROPOSED |
Date |
Work In Progress Status |
GVT_WIP_STATUS |
Text |
Status Type |
GVT_STATUS_TYPE |
Map Field Choice to Prompt |
Nature of Action Code |
GVT_NOA_CODE |
Text |
Legal Authority (1) |
GVT_LEG_AUTH_1 |
Text |
Authority 1 Description - Part 1 |
GVT_PAR_AUTH_D1 |
Text |
Authority 1 Description - Part 2 |
GVT_PAR_AUTH_D1_2 |
Text |
Legal Authority (2) |
GVT_LEG_AUTH_2 |
Text |
Authority 2 Description - Part 1 |
GVT_PAR_AUTH_D2 |
Text |
Authority 2 Description - Part 2 |
GVT_PAR_AUTH_D2_2 |
Text |
Not to Exceed Date |
GVT_PAR_NTE_DATE |
Date |
Work Schedule |
GVT_WORK_SCHED |
Map Field Choice to Prompt |
Sub-Agency |
GVT_SUB_AGENCY |
Text |
Eligible for FEHB |
GVT_ELIG_FEHB |
Text |
FEHB Eligibility Date |
GVT_FEHB_DT |
Date |
Pay Rate Determinant |
GVT_PAY_RATE_DETER |
Text |
US Federal Step |
GVT_STEP |
Text |
Retained Pay Plan |
GVT_RTND_PAY_PLAN |
Text |
Retained Pay Table |
GVT_RTND_SAL_PLAN |
Text |
Retained Grade |
GVT_RTND_GRADE |
Text |
Retained US Federal Step |
GVT_RTND_GVT_STEP |
Text |
Pay Basis |
GVT_PAY_BASIS |
Text |
Transferred from Agency |
GVT_XFER_FROM_AGCY |
Text |
Transferred to Agency |
GVT_XFER_TO_AGCY |
Text |
Retirement Plan |
GVT_RETIRE_PLAN |
Text |
Annuitant Indicator |
GVT_ANN_IND |
Text |
FEGLI Code |
GVT_FEGLI |
Text |
FEGLI Living Benefits |
GVT_FEGLI_LIVING |
Yes/No |
CSRS Frozen Service |
GVT_CSRS_FROZN_SVC |
Text |
Previous Retirement Coverage |
GVT_PREV_RET_COVRG |
Text |
FERS Coverage |
GVT_FERS_COVERAGE |
Map Field Choice to Prompt |
Type of Appointment |
GVT_TYPE_OF_APPT |
Text |
Personnel Office ID |
GVT_POI |
Text |
Position Occupied |
GVT_POSN_OCCUPIED |
Map Field Choice to Prompt |
Contact Emplid |
GVT_CONT_EMPLID |
Map Field Choice to Prompt |
Route to Next |
GVT_ROUTE_NEXT |
|
Change Flag |
GVT_CHANGE_FLAG |
Yes/No |
TSP Status |
GVT_TSP_UPD_IND |
Text |
PI Update Indicator |
GVT_PI_UPD_IND |
Map Field Choice to Prompt |
SF-52 Request Number |
GVT_SF52_NBR |
Text |
SF-113G Ceiling |
GVT_S113G_CEILING |
Yes/No |
LEO / Fire Position |
GVT_LEO_POSITION |
Map Field Choice to Prompt |
Annuity Commencement Date |
GVT_ANNUIT_COM_DT |
Date |
Post 65 Basic Life Reduction |
GVT_BASIC_LIFE_RED |
Text |
4 Day Date |
GVT_DED_PRORT_DT |
Date |
Retroactive Pay Flag |
GVT_RETRO_FLAG |
Text |
Retroactive Deduction Flag |
GVT_RETRO_DED_FLAG |
Text |
Retroactive Job Flag |
GVT_RETRO_JOB_FLAG |
Text |
Retroactive Base Flag |
GVT_RETRO_BSE_FLAG |
Text |
Other Pay Change Flag |
GVT_OTH_PAY_CHG |
Text |
Detail Position Number |
GVT_DETL_POSN_NBR |
Text |
Annual Benefit Base Rate Override |
ANNL_BEN_BASE_OVRD |
Yes/No |
Benefit Program |
BENEFIT_PROGRAM |
Text |
Update Payroll Flags |
UPDATE_PAYROLL |
Text |
Pay Plan |
GVT_PAY_PLAN |
Text |
Pay Flag |
GVT_PAY_FLAG |
Text |
NID Change |
GVT_NID_CHANGE |
Text |
Base Pay |
GVT_COMPRATE |
Decimal |
Hourly Rate with out Location |
GVT_HRLY_RT_NO_LOC |
Decimal |
No Locality - Monthly Rate |
GVT_MNLY_RT_NO_LOC |
Decimal |
No Locality - Annual Rate |
GVT_ANNL_RT_NO_LOC |
Decimal |
Transaction Number |
RA_GVT_TRANS_NBR |
Text |
Sequence Number |
RA_GVTRANS_NBR_SEQ |
Text |
Retained Step |
RA_GVT_RTND_STEP |
Text |
Locality Adjustment |
RA_GVTLOCALITY_ADJ |
Text |
Biweekly Rate |
RA_GVT_BIWEEKLY_RT |
Text |
Daily Rate |
RA_GVT_DAILY_RT |
Text |
Daily Rate no Locality |
RA_GVTDLY_RTNO_LOC |
Text |
No Locality Biweekly Rate |
RA_GVTBW_RT_NO_LOC |
Text |
Living Benefit Coverage Amount |
RA_GVT_LIVING_AMT |
Text |
CSRS Annuity Offset Amount |
RA_GVT_ANNUITY_OFF |
Text |
FEGLI Basic Percent |
RA_GVT_FEGLI_BASC |
Text |
FEGLI Optional Percent |
RA_GVT_FEGLI_OPT_P |
Text |
FEHB Percent |
RA_GVT_FEHB_PCT |
Text |