PERS_DT_USF_VW

(SQL View)
 Index Back

Current PERS_DATA_USF

Extension of the PERSON object for US Federal specific fields with EFFDT. This record is a child of PERS_DATA_EFFDT in a one to one relationship for Federal employees. The record does not exist for non Federal Persons.

SELECT USF.EMPLID , %subrec(PERS_DTFED3_SBR, USF) FROM PS_PERS_DATA_USF USF WHERE USF.EFFDT = ( SELECT MAX(EFFDT) FROM PS_PERS_DATA_USF B WHERE USF.EMPLID = B.EMPLID AND B.EFFDT <= %CurrentDateIn)

  • Parent record: PERS_DATA_EFFDT

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

    Default Value: PERS_DATA_EFFDT.EMPLID

    Prompt Table: PERSON

    2 GVT_CRED_MIL_SVCE Character(6) VARCHAR2(6) NOT NULL Creditable Military Service
    3 GVT_MILITARY_COMP Character(1) VARCHAR2(1) NOT NULL GVT_MILITARY_COMP
    A=Air Force
    C=Coast Guard
    M=Marines
    N=Navy
    R=Army
    4 GVT_MIL_GRADE Character(3) VARCHAR2(3) NOT NULL Military Grade
    E1=E1
    E2=E2
    E3=E3
    E4=E4
    E5=E5
    E6=E6
    E7=E7
    E8=E8
    E9=E9
    O1=O1
    O10=O10
    O2=O2
    O3=O3
    O4=O4
    O5=O5
    O6=O6
    O7=O7
    O8=O8
    O9=O9
    W1=W1
    W2=W2
    W3=W3
    W4=W4
    5 GVT_MIL_RESRVE_CAT Character(1) VARCHAR2(1) NOT NULL Reserve Category
    A=IMA - Air Force
    B=IMA - Army
    C=IMA - Coast Guard
    D=IMA - Marines
    E=IMA - Navy
    F=Selected Reserve - Air Force
    G=Selected Reserve - Army
    H=Selected Reserve - Coast Guard
    I=Selected Reserve - Marine Corp
    J=Selected Reserves - Navy
    K=Air National Guard
    L=Army National Guard
    M=IRR - Air Force
    N=IRR - Army
    O=IRR - Coast Guard
    P=IRR - Marine Corps
    Q=IRR - Navy
    S=Standby Reserve - Air Force
    T=Standby Reserve - Army
    U=Standby Reserve - Coast Guard
    V=Standby Reserve - Marine Corps
    W=Standby Reserve - Navy
    X=Navy Reserve - Merchant Marine
    Y=Draft Eligible
    Z=Not Applicable
    6 GVT_MIL_SEP_RET Character(1) VARCHAR2(1) NOT NULL Military Separation Status
    R=Retired
    S=Separated
    Z=Not Applicable
    7 GVT_MIL_SVCE_END Date(10) DATE Military Service End Date
    8 GVT_MIL_SVCE_START Date(10) DATE Military Service Start Date
    9 GVT_MIL_VERIFY Character(1) VARCHAR2(1) NOT NULL Military Service Verified
    10 GVT_PAR_NBR_LAST Number(6,0) INTEGER NOT NULL Last Personnel Action Reqst #
    11 GVT_UNIF_SVC_CTR Character(1) VARCHAR2(1) NOT NULL Notify Military Pay Center
    12 GVT_VET_PREF_APPT Character(1) VARCHAR2(1) NOT NULL Veterans Preference
    13 GVT_VET_PREF_RIF Character(1) VARCHAR2(1) NOT NULL Veterans Preference RIF

    Default Value: N

    14 GVT_CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Change Flag
    15 GVT_DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
    N=Not Yet Registered
    R=Registered
    X=Not Applicable
    16 GVT_YR_ATTAINED Date(10) DATE Year Attained
    17 DISABLED_VET Character(1) VARCHAR2(1) NOT NULL Disabled Veteran

    Y/N Table Edit

    18 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.

    Default Value: N

    19 GVT_DISABILITY_CD Character(2) VARCHAR2(2) NOT NULL Disability Code

    Default Value: 05

    20 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    21 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Default Value: 0000

    22 GVT_CURR_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Current Agency Employee
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    23 GVT_CURR_FED_EMPL Character(1) VARCHAR2(1) NOT NULL Current Federal Employee
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    24 GVT_HIGH_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Highest Pay Plan
    25 GVT_HIGH_GRADE Character(3) VARCHAR2(3) NOT NULL Highest Grade
    26 GVT_PREV_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Agency Employee
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    27 GVT_PREV_FED_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Federal Employee
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    28 GVT_SEP_INCENTIVE Character(1) VARCHAR2(1) NOT NULL Separation Incentive
    B=Buyout/VSIP
    E=Early Retirement
    O=Other Incentive
    29 GVT_SEP_INCENT_DT Date(10) DATE Separation Incentive Date
    30 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
    0=None
    1=Permanent
    2=Conditional
    3=Indefinite
    31 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
    32 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2