GVT_CURR_JOB_VW

(SQL View)
 Index Back

EE Current Data 1 View

JOB is one of the core records in the database. Use it to record an employee's job history data such as actions taken, department, job code, location, and salary history. You can create multiple JOB records for an employee. GVT: Added GVT_SUB_AGENCY Added GVT_PAY_BASIS Added ERN_PROGRAM Added GVT_BIWEEKLY_RT Added GVT_WORK_SCHED

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.DEPTID , A.GVT_TRANS_NBR , A.GVT_TRANS_NBR_SEQ , A.JOBCODE , A.POSITION_NBR , A.POSITION_OVERRIDE , A.POSN_CHANGE_RECORD , A.EMPL_STATUS , A.ACTION , A.GVT_NOA_CODE , A.GVT_LEG_AUTH_1 , A.GVT_PAR_AUTH_D1 , A.GVT_PAR_AUTH_D1_2 , A.GVT_LEG_AUTH_2 , A.GVT_PAR_AUTH_D2 , A.GVT_PAR_AUTH_D2_2 , A.GVT_PAR_NTE_DATE , A.ACTION_DT , A.ACTION_REASON , A.LOCATION , A.TAX_LOCATION_CD , A.JOB_ENTRY_DT , A.DEPT_ENTRY_DT , A.POSITION_ENTRY_DT , A.SHIFT , A.REG_TEMP , A.GVT_WORK_SCHED , A.FULL_PART_TIME , A.COMPANY , A.GVT_SUB_AGENCY , A.PAYGROUP , A.BAS_GROUP_ID , A.ELIG_CONFIG1 , A.ELIG_CONFIG2 , A.ELIG_CONFIG3 , A.GVT_ELIG_FEHB , A.GVT_FEHB_DT , A.BEN_STATUS , A.COBRA_ACTION , A.EMPL_TYPE , A.HOLIDAY_SCHEDULE , A.STD_HOURS , A.EMPL_CLASS , A.GVT_PAY_RATE_DETER , A.GVT_PAY_PLAN , A.SAL_ADMIN_PLAN , A.GRADE , A.GRADE_ENTRY_DT , A.STEP , A.STEP_ENTRY_DT , A.GVT_STEP , A.GVT_RTND_PAY_PLAN , A.GVT_RTND_SAL_PLAN , A.GVT_RTND_GRADE , A.GVT_RTND_STEP , A.GVT_RTND_GVT_STEP , A.GL_PAY_TYPE , A.ACCT_CD , A.EARNS_DIST_TYPE , A.GVT_PAY_BASIS , A.COMP_FREQUENCY , A.COMPRATE , A.GVT_COMPRATE , A.GVT_LOCALITY_ADJ , A.CHANGE_AMT , A.CHANGE_PCT , A.ANNUAL_RT , A.MONTHLY_RT , A.GVT_BIWEEKLY_RT , A.GVT_DAILY_RT , A.HOURLY_RT , A.ANNL_BENEF_BASE_RT , A.GVT_HRLY_RT_NO_LOC , A.GVT_DLY_RT_NO_LOC , A.GVT_BW_RT_NO_LOC , A.GVT_MNLY_RT_NO_LOC , A.GVT_ANNL_RT_NO_LOC , A.SHIFT_RT , A.SHIFT_FACTOR , A.CURRENCY_CD , A.REG_REGION , %subrec(JOB_USA_SBR,A) , A.GVT_XFER_FROM_AGCY , A.GVT_XFER_TO_AGCY , A.GVT_RETIRE_PLAN , A.GVT_ANN_IND , A.GVT_FEGLI , A.GVT_ANNUITY_OFFSET , A.GVT_CSRS_FROZN_SVC , A.GVT_PREV_RET_COVRG , A.GVT_FERS_COVERAGE , A.GVT_TYPE_OF_APPT , A.GVT_POI , A.GVT_POSN_OCCUPIED , A.ANNL_BEN_BASE_OVRD , A.GVT_CONT_EMPLID , A.GVT_EFFDT_PROPOSED , A.GVT_WIP_STATUS , A.BENEFIT_PROGRAM , A.UPDATE_PAYROLL , A.GVT_ROUTE_NEXT , A.GVT_CHANGE_FLAG , A.GVT_STATUS_TYPE , A.GVT_TSP_UPD_IND , A.GVT_PI_UPD_IND , A.GVT_SF52_NBR , A.GVT_S113G_CEILING , A.GVT_LEO_POSITION , A.GVT_ANNUIT_COM_DT , A.GVT_BASIC_LIFE_RED , A.GVT_DED_PRORT_DT , A.GVT_EFFDT , A.GVT_FEGLI_BASC_PCT , A.GVT_FEGLI_OPT_PCT , A.GVT_FEHB_PCT , A.GVT_RETRO_FLAG , A.GVT_RETRO_DED_FLAG , A.GVT_RETRO_JOB_FLAG , A.GVT_RETRO_BSE_FLAG , A.GVT_OTH_PAY_CHG FROM PS_GVT_JOB A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GVT_JOB WHERE EMPLID = A.EMPLID AND EMPL_RCD = A.EMPL_RCD AND EFFDT <= %CurrentDateIn AND GVT_STATUS_TYPE IN ('COM', 'COR')) AND A.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_GVT_JOB WHERE EMPLID = A.EMPLID AND EMPL_RCD = A.EMPL_RCD AND EFFDT = A.EFFDT AND GVT_STATUS_TYPE IN ('COM', 'COR'))

  • Parent record: PER_ORG_ASGN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: NEW

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    6 GVT_TRANS_NBR Number(1,0) SMALLINT NOT NULL Transaction #
    7 GVT_TRANS_NBR_SEQ Number(1,0) SMALLINT NOT NULL Sequence
    8 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    9 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    10 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data

    Y/N Table Edit

    Default Value: N

    11 POSN_CHANGE_RECORD Character(1) VARCHAR2(1) NOT NULL Position Management Record

    Y/N Table Edit

    Default Value: N

    12 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Pay
    Q=Retired With Pay
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Pay
    V=Terminated Pension Pay Out
    W=Short Work Break
    X=Retired-Pension Administration

    Default Value: A

    13 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    14 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code

    Prompt Table: GVT_NOAC_TBL

    15 GVT_LEG_AUTH_1 Character(3) VARCHAR2(3) NOT NULL Legal Authority (1)

    Prompt Table: GVT_AUTH_VAL_1

    16 GVT_PAR_AUTH_D1 Character(25) VARCHAR2(25) NOT NULL Authority 1 Descr - Part 1
    17 GVT_PAR_AUTH_D1_2 Character(25) VARCHAR2(25) NOT NULL Authority 1 Descr - Part 2
    18 GVT_LEG_AUTH_2 Character(3) VARCHAR2(3) NOT NULL Legal Authority (2)

    Prompt Table: GVT_LEGAL_AUTH

    19 GVT_PAR_AUTH_D2 Character(25) VARCHAR2(25) NOT NULL Authority 2 Descr - Part 1
    20 GVT_PAR_AUTH_D2_2 Character(25) VARCHAR2(25) NOT NULL Authority 2 Descr - Part 2
    21 GVT_PAR_NTE_DATE Date(10) DATE Not To Exceed Date
    22 ACTION_DT Date(10) DATE Action Date

    Default Value: %date

    23 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    24 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    25 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code

    Prompt Table: TAX_LOCVW_US

    26 JOB_ENTRY_DT Date(10) DATE Job Entry Date
    27 DEPT_ENTRY_DT Date(10) DATE Department Entry Date
    28 POSITION_ENTRY_DT Date(10) DATE Position Entry Date
    29 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=1
    2=2
    3=3
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating

    Default Value: N

    30 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary

    Default Value: R

    31 GVT_WORK_SCHED Character(1) VARCHAR2(1) NOT NULL Work Schedule
    B=Baylor Plan
    F=Full Time
    G=Full Time Seasonal
    I=Intermittent
    J=Intermittent-Seasonal
    P=Part Time
    Q=Part-Time Seasonal
    S=Part-Time Job Sharer
    T=Part-Time Seasonal Job Sharer
    32 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time

    Default Value: F

    33 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    34 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency

    Prompt Table: GVT_SUBAGCY_TBL

    35 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    36 BAS_GROUP_ID Character(3) VARCHAR2(3) NOT NULL Identifies a user-defined Benefits Administration group used to facilitate benefits processing. A group can represent the entire participant population of the enterprise, or a specific group of participants. It enables you to control processing by, for example, setting up separate Open Enrollment schedules for each group. If used, a BAS Group ID is assigned to each participant in a benefit program.

    Prompt Table: BAS_GROUP_TBL

    37 ELIG_CONFIG1 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    38 ELIG_CONFIG2 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    39 ELIG_CONFIG3 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
    40 GVT_ELIG_FEHB Character(3) VARCHAR2(3) NOT NULL Eligible for FEHB
    CC=Continuing Coverage
    NE=Not Eligible
    PER=Permanent
    TAP=Temporary Appointment > 1 yr
    TSV=Temp Appt < 1yr + FedSvc > 1yr
    41 GVT_FEHB_DT Date(10) DATE FEHB Eligibility Date
    42 BEN_STATUS Character(4) VARCHAR2(4) NOT NULL Specifies an employee's status relative to benefits, and is used to determine eligibility for benefits. Some examples of benefit status are Active, Suspended, Leave with Benefits, and Terminated.
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Benefits
    Q=Retired With Benefits
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Benefits
    43 COBRA_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.
    44 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried

    Prompt Table: PAYGRP_EMPLTYPE

    45 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

    Prompt Table: HOLIDAY_TBL

    46 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    47 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification

    Prompt Table: EMPL_CLASS_TBL
    Set Control Field: REG_REGION

    48 GVT_PAY_RATE_DETER Character(1) VARCHAR2(1) NOT NULL Pay Rate Determinant
    0=Regular Rate
    2=Saved Rate - Indefinite
    3=Retained Pay - Spec Rt Adjust
    4=Saved Rate - Other
    5=Special & Superior Quals
    6=Special Rate
    7=Superior Qualifications Rate
    A=Retained Grade - Diff Posn
    B=Retained Grade - Same Posn
    C=Critical Position Pay
    E=Rtnd Grd & Spec Rt - Diff Posn
    F=Rtnd Grd & Spec Rt - Same Posn
    J=Retained Pay - Same Position
    K=Retained Pay - Diff Posn
    M=Continued IGA Pay
    P=Preserved IGA Pay
    R=Retained Pay - SES Removal
    S=Continued SES Basic Pay
    U=Rtnd Grade & Pay - Same Posn
    V=Rtnd Grade & Pay - Diff Posn

    Default Value: 0

    49 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
    50 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: SAL_PLAN_TBL

    51 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: SAL_GRADE_TBL

    52 GRADE_ENTRY_DT Date(10) DATE Grade Entry Date
    53 STEP Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: SAL_STEP_TBL

    54 STEP_ENTRY_DT Date(10) DATE Step Entry Date
    55 GVT_STEP Character(2) VARCHAR2(2) NOT NULL US Federal Step

    Default Value: 00

    56 GVT_RTND_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Retained Pay Plan

    Prompt Table: ERN_PROGRAM_TBL

    57 GVT_RTND_SAL_PLAN Character(4) VARCHAR2(4) NOT NULL Retained Pay Table

    Prompt Table: GVT_RTND_SP_VW

    58 GVT_RTND_GRADE Character(3) VARCHAR2(3) NOT NULL Retained Grade

    Prompt Table: GVT_RTND_SG_VW

    59 GVT_RTND_STEP Number(2,0) SMALLINT NOT NULL Retained Step

    Prompt Table: GVT_RTND_SS_VW

    60 GVT_RTND_GVT_STEP Character(2) VARCHAR2(2) NOT NULL Retained US Federal Step
    61 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
    62 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Prompt Table: ACCT_CD_TBL

    63 EARNS_DIST_TYPE Character(1) VARCHAR2(1) NOT NULL Earnings Distribution Type
    A=By Amount
    H=By Hours
    N=None
    P=By Percent

    Default Value: N

    64 GVT_PAY_BASIS Character(2) VARCHAR2(2) NOT NULL Pay Basis
    BW=Bi-weekly
    FB=Fee Basis
    PA=Per Annum
    PD=Per Diem
    PH=Per Hour
    PM=Per Month
    PW=Piece Work
    SM=Semi-monthly
    SY=School Year
    WC=Without Compensation

    Default Value: PA

    65 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    H=Hourly
    M=Monthly
    S=Semimonthly
    W=Weekly

    Default Value: A

    Prompt Table: COMP_FREQ_VW

    66 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    67 GVT_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Base Pay
    68 GVT_LOCALITY_ADJ Number(8,2) DECIMAL(7,2) NOT NULL Locality Adjustment
    69 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
    70 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
    71 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    72 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
    73 GVT_BIWEEKLY_RT Number(10,2) DECIMAL(9,2) NOT NULL Biweekly Rate
    74 GVT_DAILY_RT Number(10,2) DECIMAL(9,2) NOT NULL Daily Rate
    75 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    76 ANNL_BENEF_BASE_RT Number(19,3) DECIMAL(18,3) NOT NULL Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.
    77 GVT_HRLY_RT_NO_LOC Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate with out Location
    78 GVT_DLY_RT_NO_LOC Number(10,2) DECIMAL(9,2) NOT NULL Daily Rate No Locality
    79 GVT_BW_RT_NO_LOC Number(10,2) DECIMAL(9,2) NOT NULL No Locality Biweekly Rate
    80 GVT_MNLY_RT_NO_LOC Number(19,3) DECIMAL(18,3) NOT NULL No Locality Monthly Rate
    81 GVT_ANNL_RT_NO_LOC Number(19,3) DECIMAL(18,3) NOT NULL No Locality Annual Rate
    82 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate
    83 SHIFT_FACTOR Number(5,3) DECIMAL(4,3) NOT NULL Shift Differential Factor
    84 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    85 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    86 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status field
    A=Administrative
    C=Computer Employee
    E=Executive
    H=Highly Compensated Employees
    M=Management
    N=Nonexempt
    O=Outside Salesperson
    P=Professional
    V=Nonexempt Alt Overtime
    X=No FLSA Required

    Default Value: X

    87 EEO_CLASS Character(1) VARCHAR2(1) NOT NULL EEO Classification
    E=Exclude from Count
    N=None of the Above
    P=Production Trainee
    W=White-Collar Trainee

    Default Value: N

    88 GVT_XFER_FROM_AGCY Character(2) VARCHAR2(2) NOT NULL Transferred From Agency

    Prompt Table: COMPANY_TBL

    89 GVT_XFER_TO_AGCY Character(2) VARCHAR2(2) NOT NULL Transferred To Agency

    Prompt Table: COMPANY_TBL

    90 GVT_RETIRE_PLAN Character(2) VARCHAR2(2) NOT NULL Retirement Plan

    Default Value: K

    91 GVT_ANN_IND Character(1) VARCHAR2(1) NOT NULL Annuitant Indicator
    1=Reempl Ann-CS
    2=Ret Officer
    3=Ret Enlisted
    4=Ret Off/Reempl Ann-CS
    5=Ret Enl/Reempl Ann-CS
    6=CS-No Reduction
    7=Ret Off/CS-No Reduc
    8=Ret Enl/CS-No Reduc
    9=Not Applicable
    A=Reempl Ann-FE
    B=Former Ann-FE
    C=Ret Off/Reempl Ann-FE
    D=Ret Off/Former Ann-FE
    E=Ret Enl/Reempl Ann-FE
    F=Ret Enl/Former Ann-FE
    G=FE - No Reduction
    H=Ret Off/FE-No Reduc
    J=Ret Enl/FE-No Reduc

    Default Value: 9

    92 GVT_FEGLI Character(2) VARCHAR2(2) NOT NULL FEGLI Code

    Default Value: C

    Prompt Table: GVT_FEGLI

    93 GVT_ANNUITY_OFFSET Number(8,0) INTEGER NOT NULL CSRS Annuity Offset Amount
    94 GVT_CSRS_FROZN_SVC Character(4) VARCHAR2(4) NOT NULL CSRS Frozen Service

    Default Value: 0000

    95 GVT_PREV_RET_COVRG Character(1) VARCHAR2(1) NOT NULL Previous Retirement Coverage
    N=Never Covered
    P=Previously Covered

    Default Value: N

    96 GVT_FERS_COVERAGE Character(1) VARCHAR2(1) NOT NULL FERS Coverage
    A=Automatically Covered By FERS
    E=Elected Coverage Under FERS
    N=Not Covered By FERS

    Default Value: A

    97 GVT_TYPE_OF_APPT Character(2) VARCHAR2(2) NOT NULL Type of Appointment
    10=Career (Competitive Svc Perm)
    15=Career-Conditional (Comp Perm)
    20=Nonpermanent (Comp NonPerm)
    30=Schedule A (Except Svc Perm)
    32=Schedule B (Except Svc Perm)
    34=Schedule C (Except Svc Perm)
    36=Executive (Except Svc Perm)
    38=Other (Except Svc Perm)
    40=Schedule A (Except NonPerm)
    42=Schedule B (Except NonPerm)
    44=Schedule C (Except NonPerm)
    46=Executive (Except NonPerm)
    48=Other (Except NonPerm)
    50=Career (Senior Exec Perm)
    55=Noncareer (Senior Exec Perm)
    60=Limited Term (Senior Exec NPrm
    65=Limited Emergency (SES NPerm)

    Default Value: 10

    98 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID

    Prompt Table: GVT_POI_VW

    99 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
    1=Competitive
    2=Excepted
    3=SES General
    4=SES Career Reserved
    100 ANNL_BEN_BASE_OVRD Character(1) VARCHAR2(1) NOT NULL Annl Benefit Base Rt Override

    Y/N Table Edit

    Default Value: N

    101 GVT_CONT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact Emplid
    102 GVT_EFFDT_PROPOSED Date(10) DATE Proposed Effective Date

    Default Value: %date

    103 GVT_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Work-in-Progress Status

    Prompt Table: GVT_WIP_STS_VW

    104 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
    105 UPDATE_PAYROLL Character(1) VARCHAR2(1) NOT NULL Update Payroll Flags
    106 GVT_ROUTE_NEXT Character(11) VARCHAR2(11) NOT NULL Route to Next
    107 GVT_CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Change Flag

    Y/N Table Edit

    Default Value: N

    108 GVT_STATUS_TYPE Character(3) VARCHAR2(3) NOT NULL Status Type
    CAN=Cancelled
    COM=Completed
    COR=Corrected
    IRR=IRR Reported
    WIP=Work-in-progress
    109 GVT_TSP_UPD_IND Character(1) VARCHAR2(1) NOT NULL TSP Status
    N=Not Ready to Process
    P=Processed
    R=Ready to Process

    Default Value: N

    110 GVT_PI_UPD_IND Character(1) VARCHAR2(1) NOT NULL PI upd ind
    A=Applied at NFC
    I=Auto Action Inserted
    N=Not Ready to Process
    P=In Process
    R=Ready To Process
    S=SINQ Error
    Z=Other

    Default Value: N

    111 GVT_SF52_NBR Character(10) VARCHAR2(10) NOT NULL SF-52 Request Number
    112 GVT_S113G_CEILING Character(1) VARCHAR2(1) NOT NULL SF-113G Ceiling

    Y/N Table Edit

    Default Value: Y

    113 GVT_LEO_POSITION Character(1) VARCHAR2(1) NOT NULL LEO/Fire Position
    5=5USC 5305 LEO
    C=D.C. Police Forces
    F=Fire Fighter
    N=Not Applicable
    P=Primary FEPCA
    S=Secondary FEPCA
    114 GVT_ANNUIT_COM_DT Date(10) DATE Annuity Commencement Date
    115 GVT_BASIC_LIFE_RED Character(2) VARCHAR2(2) NOT NULL Federal Field
    0=No Reduction
    50=50% Reduction
    75=75% Reduction
    N=None
    116 GVT_DED_PRORT_DT Date(10) DATE 4 Day Date
    117 GVT_EFFDT Date(10) DATE Effective Date
    118 GVT_FEGLI_BASC_PCT Number(8,6) DECIMAL(7,6) NOT NULL FEGLI Basic Percent
    119 GVT_FEGLI_OPT_PCT Number(8,6) DECIMAL(7,6) NOT NULL FEGLI Optional Percent
    120 GVT_FEHB_PCT Number(8,6) DECIMAL(7,6) NOT NULL FEHB %
    121 GVT_RETRO_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Pay Flag
    122 GVT_RETRO_DED_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Ded Flag
    123 GVT_RETRO_JOB_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Job Flag
    124 GVT_RETRO_BSE_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Base Flag
    125 GVT_OTH_PAY_CHG Character(1) VARCHAR2(1) NOT NULL Other Pay Change Flag

    Default Value: N