Job Data – Federal
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 |