HCR_JOB_USF_STG

(SQL Table)
 Index Back

Job Extension for USF

Extension of the JOB record for US Federal specific fields.

  • Parent record: JOB

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

    Default Value: JOB.EMPLID

    Prompt Table: JOB

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Default Value: JOB.EMPL_RCD

    Prompt Table: JOB

    3 EFFDT Date(10) DATE Effective Date

    Default Value: JOB.EFFDT

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

    Default Value: JOB.EFFSEQ

    5 HCR_ACTN_SEQN Number(3,0) SMALLINT NOT NULL Sequence number
    6 GVT_EFFDT Date(10) DATE Effective Date
    7 GVT_EFFDT_PROPOSED Date(10) DATE Proposed Effective Date

    Default Value: %date

    8 GVT_TRANS_NBR Number(1,0) SMALLINT NOT NULL Transaction Nbr
    9 GVT_TRANS_NBR_SEQ Number(1,0) SMALLINT NOT NULL Transaction Nbr / Seq
    10 GVT_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Work-in-Progress Status
    11 GVT_STATUS_TYPE Character(3) VARCHAR2(3) NOT NULL Status Type
    CAN=Cancelled
    COM=Completed
    COR=Corrected
    IRR=IRR Reported
    WIP=Work-in-progress
    12 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code
    13 GVT_LEG_AUTH_1 Character(3) VARCHAR2(3) NOT NULL Legal Authority (1)
    14 GVT_PAR_AUTH_D1 Character(25) VARCHAR2(25) NOT NULL Authority 1 Descr - Part 1
    15 GVT_PAR_AUTH_D1_2 Character(25) VARCHAR2(25) NOT NULL Authority 1 Descr - Part 2
    16 GVT_LEG_AUTH_2 Character(3) VARCHAR2(3) NOT NULL Legal Authority (2)
    17 GVT_PAR_AUTH_D2 Character(25) VARCHAR2(25) NOT NULL Authority 2 Descr - Part 1
    18 GVT_PAR_AUTH_D2_2 Character(25) VARCHAR2(25) NOT NULL Authority 2 Descr - Part 2
    19 GVT_PAR_NTE_DATE Date(10) DATE Not-to-Exceed Date
    20 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
    R=Part-Time Phased Retiree
    S=Part-Time Job Sharer
    T=Part-Time Seasonal Job Sharer

    Default Value: F

    21 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency
    22 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
    23 GVT_FEHB_DT Date(10) DATE FEHB Eligibility Date
    24 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
    M=Continued IGA Pay
    P=Preserved IGA Pay
    R=Retained Pay - SES Removal
    S=Continued SES Basic Pay
    T=Below the Minimum Rate
    U=Rtnd Grade & Pay - Same Posn
    V=Rtnd Grade & Pay - Diff Posn
    Y=NSPS Retained Pay
    Z=Border Equalization Allowance

    Default Value: 0

    25 GVT_STEP Character(2) VARCHAR2(2) NOT NULL US Federal Step
    26 GVT_RTND_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Retained Pay Plan
    27 GVT_RTND_SAL_PLAN Character(4) VARCHAR2(4) NOT NULL Retained Pay Table
    28 GVT_RTND_GRADE Character(3) VARCHAR2(3) NOT NULL Retained Grade
    29 GVT_RTND_STEP Number(2,0) SMALLINT NOT NULL Retained Step
    30 GVT_RTND_GVT_STEP Character(2) VARCHAR2(2) NOT NULL Retained US Federal Step
    31 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

    32 GVT_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate
    33 GVT_LOCALITY_ADJ Number(8,2) DECIMAL(7,2) NOT NULL Locality Adjustment
    34 GVT_BIWEEKLY_RT Number(10,2) DECIMAL(9,2) NOT NULL Biweekly Rate
    35 GVT_DAILY_RT Number(10,2) DECIMAL(9,2) NOT NULL Daily Rate
    36 GVT_HRLY_RT_NO_LOC Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate with out Location
    37 GVT_DLY_RT_NO_LOC Number(10,2) DECIMAL(9,2) NOT NULL Daily Rate No Locality
    38 GVT_BW_RT_NO_LOC Number(10,2) DECIMAL(9,2) NOT NULL No Locality Biweekly Rate
    39 GVT_MNLY_RT_NO_LOC Number(19,3) DECIMAL(18,3) NOT NULL No Locality Monthly Rate
    40 GVT_ANNL_RT_NO_LOC Number(19,3) DECIMAL(18,3) NOT NULL No Locality Annual Rate
    41 GVT_XFER_FROM_AGCY Character(2) VARCHAR2(2) NOT NULL Transferred From Agency
    42 GVT_XFER_TO_AGCY Character(2) VARCHAR2(2) NOT NULL Transferred To Agency
    43 GVT_RETIRE_PLAN Character(2) VARCHAR2(2) NOT NULL Retirement Plan

    Default Value: K

    44 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
    M=Former FERS Phased Retiree
    N=FERS Phased Retiree Officer
    P=Phased Ret/Former Enlisted FE
    W=Phased Retiree/Former CS
    X=CSRS Phased Retiree Officer
    Y=Phased Ret/Former Enlisted CS

    Default Value: 9

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

    Default Value: C0

    46 GVT_FEGLI_LIVING Character(1) VARCHAR2(1) NOT NULL FEGLI Living Benefits

    Y/N Table Edit

    Default Value: N

    47 GVT_LIVING_AMT Number(8,0) INTEGER NOT NULL Living Benefit Coverage Amount
    48 GVT_ANNUITY_OFFSET Number(8,0) INTEGER NOT NULL Annuity Offset Amount
    49 GVT_CSRS_FROZN_SVC Character(4) VARCHAR2(4) NOT NULL CSRS Frozen Service
    50 GVT_PREV_RET_COVRG Character(1) VARCHAR2(1) NOT NULL Previous Retirement Coverage
    N=Never Covered
    P=Previously Covered

    Default Value: N

    51 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

    52 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

    53 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID
    54 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
    1=Competitive
    2=Excepted
    3=SES General
    4=SES Career Reserved
    55 GVT_CONT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact Emplid
    56 GVT_ROUTE_NEXT Character(11) VARCHAR2(11) NOT NULL Route to Next
    57 GVT_CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Change Flag

    Y/N Table Edit

    Default Value: N

    58 GVT_TSP_UPD_IND Character(1) VARCHAR2(1) NOT NULL TSP Status
    N=Not Ready
    P=Processed
    R=Ready

    Default Value: N

    59 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

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

    Y/N Table Edit

    Default Value: Y

    62 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
    63 GVT_ANNUIT_COM_DT Date(10) DATE Annuity Commencement Date
    64 GVT_BASIC_LIFE_RED Character(2) VARCHAR2(2) NOT NULL Federal Field
    0=No Reduction
    50=50% Reduction
    75=75% Reduction
    N=None
    65 GVT_DED_PRORT_DT Date(10) DATE 4 Day Date
    66 GVT_FEGLI_BASC_PCT Number(8,6) DECIMAL(7,6) NOT NULL FEGLI Basic Percent
    67 GVT_FEGLI_OPT_PCT Number(8,6) DECIMAL(7,6) NOT NULL FEGLI Optional Percent
    68 GVT_FEHB_PCT Number(8,6) DECIMAL(7,6) NOT NULL FEHB %
    69 GVT_RETRO_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Pay Flag

    Default Value: N

    70 GVT_RETRO_DED_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Ded Flag

    Default Value: N

    71 GVT_RETRO_JOB_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Job Flag

    Default Value: N

    72 GVT_RETRO_BSE_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Base Flag

    Default Value: N

    73 GVT_OTH_PAY_CHG Character(1) VARCHAR2(1) NOT NULL Other Pay Change Flag

    Default Value: N

    74 GVT_DETL_POSN_NBR Character(8) VARCHAR2(8) NOT NULL Govt Detail Position Number
    75 ANNL_BEN_BASE_OVRD Character(1) VARCHAR2(1) NOT NULL Annual Benefit Base Rate Override

    Y/N Table Edit

    Default Value: N

    76 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
    77 UPDATE_PAYROLL Character(1) VARCHAR2(1) NOT NULL Update Payroll Flags
    78 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
    79 GVT_PAY_FLAG Character(1) VARCHAR2(1) NOT NULL Pay Flag
    80 GVT_NID_CHANGE Character(1) VARCHAR2(1) NOT NULL GVT_NID_CHANGE

    Default Value: Y

    81 GVT_SCD_RETIRE Date(10) DATE Service Comp Date - Retire
    82 GVT_SCD_TSP Date(10) DATE Service Comp Date - TSP
    83 GVT_SCD_LEO Date(10) DATE Service Comp Date - LEO
    84 GVT_SCD_SEVPAY Date(10) DATE Service Comp Date - Sev Pay
    85 GVT_SEVPAY_PRV_WKS Number(2,0) SMALLINT NOT NULL Severance Pay Previous Weeks
    86 GVT_MAND_RET_DT Date(10) DATE Mandatory Retirement Date
    87 GVT_WGI_STATUS Character(1) VARCHAR2(1) NOT NULL Current WGI Status
    A=Approved
    C=WGI Created
    D=Denied
    M=Manual WGI
    N=WGI Not Applicable
    P=Postponed
    W=Waiting WGI Processing

    Default Value: W

    88 GVT_INTRM_DAYS_WGI Number(3,0) SMALLINT NOT NULL Intermittent Days Worked
    89 GVT_NONPAY_NOA Character(3) VARCHAR2(3) NOT NULL NonPay Nature of Action - Last
    90 GVT_NONPAY_HRS_WGI Number(7,2) DECIMAL(6,2) NOT NULL Non-Pay Hours WGI
    91 GVT_NONPAY_HRS_SCD Number(7,2) DECIMAL(6,2) NOT NULL Non-Pay Hours for SCD
    92 GVT_NONPAY_HRS_TNR Number(7,2) DECIMAL(6,2) NOT NULL Career Tenure Hours
    93 GVT_NONPAY_HRS_PRB Number(7,2) DECIMAL(6,2) NOT NULL Non-Pay Hours for Probation
    94 GVT_TEMP_PRO_EXPIR Date(10) DATE Temp Promotion Expires
    95 GVT_TEMP_PSN_EXPIR Date(10) DATE Temporary Posn Change Expires
    96 GVT_DETAIL_EXPIRES Date(10) DATE Date Detail Expires
    97 GVT_SABBATIC_EXPIR Date(10) DATE Date Sabbatical Expires
    98 GVT_RTND_GRADE_BEG Date(10) DATE Retained Grade Begins
    99 GVT_RTND_GRADE_EXP Date(10) DATE Retained Grade Expires
    100 GVT_CURR_APT_AUTH1 Character(3) VARCHAR2(3) NOT NULL Current Appointment Auth Nbr 1
    101 GVT_CURR_APT_AUTH2 Character(3) VARCHAR2(3) NOT NULL Current Appointment Auth Nbr 2
    102 GVT_APPT_EXPIR_DT Date(10) DATE Appointment Expiration Date
    103 GVT_CNV_BEGIN_DATE Date(10) DATE Conv Begin Date
    104 GVT_CAREER_CNV_DUE Date(10) DATE Conversion To Career Due
    105 GVT_CAREER_COND_DT Date(10) DATE Career Cond Conversion Date
    106 GVT_APPT_LIMIT_HRS Number(4,0) SMALLINT NOT NULL Appointment Limit in Hours
    107 GVT_APPT_LIMIT_DYS Number(3,0) SMALLINT NOT NULL Appointment Limit in Days
    108 GVT_APPT_LIMIT_AMT Number(6,0) INTEGER NOT NULL Appointment Limit Amount
    109 GVT_SUPV_PROB_DT Date(10) DATE Supv/Manager Probation Date
    110 GVT_SES_PROB_DT Date(10) DATE SES Probation Date
    111 GVT_SEC_CLR_STATUS Character(1) VARCHAR2(1) NOT NULL Security Clearance Status
    A=Approved
    B=Pending - Investigative Agency
    C=Pending - Employee
    D=Pending - Agency
    N=Not Applicable
    S=Suspended

    Default Value: N

    112 GVT_CLRNCE_STAT_DT Date(10) DATE Security Clearance Status Date

    Default Value: %date

    113 GVT_ERN_PGM_PERM Character(2) VARCHAR2(2) NOT NULL Permanent Pay Plan - RIF
    114 GVT_OCC_SERS_PERM Character(4) VARCHAR2(4) NOT NULL Permanent Occ Series - RIF
    115 GVT_GRADE_PERM Character(3) VARCHAR2(3) NOT NULL Permanent Grade - RIF
    116 GVT_COMP_AREA_PERM Character(2) VARCHAR2(2) NOT NULL Comp/Area Level
    117 GVT_COMP_LVL_PERM Character(3) VARCHAR2(3) NOT NULL Permanent Comp Level - RIF
    118 GVT_SPEP Character(2) VARCHAR2(2) NOT NULL Special Employment Program
    00=Not Applicable
    59=Veteran's Readjustment Program
    69=Presidential Mgt Intern
    80=SES Candidate Development
    99=Other

    Default Value: 00

    119 GVT_WGI_DUE_DATE Date(10) DATE Within-Grade Increase Due Date
    120 GVT_DT_LEI Date(10) DATE Date Last Equivalent Increase
    121 GVT_FIN_DISCLOSURE Character(1) VARCHAR2(1) NOT NULL Financial Disclosure Required

    Y/N Table Edit

    Default Value: N

    122 GVT_FIN_DISCL_DATE Date(10) DATE Financial Disclosure Due Date
    123 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
    0=None
    1=Permanent
    2=Conditional
    3=Indefinite
    124 GVT_DETL_BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Govt Detail Bargaining Unit
    125 GVT_DETL_UNION_CD Character(3) VARCHAR2(3) NOT NULL Govt Detail Union Code
    126 GVT_WELFARE_WK_CD Character(2) VARCHAR2(2) NOT NULL Welfare to Work
    00=Not Applicable
    50=Welfare to Work Program Hire
    50=Welfare to Work Program Hire
    60=Hire not Welfare to Work Prog
    60=Hire not Welfare to Work Prog

    Default Value: 00