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 |