GVT_CURR_PERS_V

(SQL View)
 Index Back

GVT CURRENT Personal Data Vw

PERSONAL_DATA is one of the core records in the database. Use it to record personal and demographic data about an employee or applicant including name, address, birthdate, and ethnic group. You can create only one PERSONAL_DATA record per person.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , NM.NAME , A.NAME_PREFIX , A.NAME_SUFFIX , A.LAST_NAME_SRCH , A.FIRST_NAME_SRCH , %subrec(ADDRESS_SBR, A) , %subrec(ADDR_OTR_SBR, A) , A.PER_ORG , A.ORIG_HIRE_DT , A.SEX , A.MAR_STATUS , A.MAR_STATUS_DT , A.BIRTHDATE , A.BIRTHPLACE , A.BIRTHCOUNTRY , A.BIRTHSTATE , A.DT_OF_DEATH , A.HIGHEST_EDUC_LVL , A.FT_STUDENT , C.CITIZENSHIP_STATUS , %subrec(PERS_DTUSA_SBR,A) , %subrec(PERS_DTFED_SBR,A) FROM PS_GVT_PERS_DATA A , PS_GVT_NM_DT_VW NM , PS_GVT_JOB B , PS_GVT_CITIZENSHIP C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND A.EMPLID = C.EMPLID AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GVT_JOB WHERE EMPLID = B.EMPLID AND EMPL_RCD = B.EMPL_RCD AND EFFDT <= %CurrentDateIn AND GVT_STATUS_TYPE IN ('COM', 'COR')) AND B.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_GVT_JOB WHERE EMPLID = B.EMPLID AND EMPL_RCD = B.EMPL_RCD AND EFFDT = B.EFFDT AND GVT_STATUS_TYPE IN ('COM', 'COR')) AND A.EMPLID = NM.EMPLID AND A.EMPL_RCD = NM.EMPL_RCD AND A.EFFDT = NM.EFFDT AND A.EFFSEQ = NM.EFFSEQ AND C.EFFDT = B.EFFDT AND C.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_GVT_CITIZENSHIP WHERE EMPLID = C.EMPLID AND EMPL_RCD = C.EMPL_RCD AND EFFDT = C.EFFDT)

  • Related Language Record: GVT_CURV_LNG_VW

  • Audit Record: AUDIT_PERSONAL

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

    Default Value: NEW

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 NAME Character(50) VARCHAR2(50) NOT NULL Name
    6 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: NAME_PREFIX_TBL

    7 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

    Prompt Table: NAME_SUFFIX_TBL

    8 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    9 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    11 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    12 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    13 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    14 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    15 CITY Character(30) VARCHAR2(30) NOT NULL City
    16 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    17 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    18 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    19 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    20 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    21 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    22 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    23 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    24 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    25 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    26 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    27 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

    Prompt Table: COUNTRY_TBL

    28 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
    29 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
    30 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
    31 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
    32 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
    33 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    34 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: STATE_OTH

    35 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
    36 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    37 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    38 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    39 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
    40 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
    41 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
    42 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other

    Y/N Table Edit

    43 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    44 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
    CWR=Contingent Worker
    EMP=Employee
    POI=Person of Interest
    45 ORIG_HIRE_DT Date(10) DATE Original Start Date
    46 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown

    Default Value: F

    47 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    L=DissDeclLost Civil Partner
    M=Married
    P=Civil Partnership
    S=Single
    T=Surviving Civil Partner
    U=Unknown
    V=Dissolved Civil Partnership
    W=Widowed
    48 MAR_STATUS_DT Date(10) DATE This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
    49 BIRTHDATE Date(10) DATE Date of Birth
    50 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    51 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

    Default Value: USA

    Prompt Table: COUNTRY_TBL

    52 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State

    Prompt Table: BIRTHSTATE_VW

    53 DT_OF_DEATH Date(10) DATE Date of Death
    54 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level
    55 FT_STUDENT Character(1) VARCHAR2(1) NOT NULL Full-Time Student

    Y/N Table Edit

    Default Value: N

    56 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Default Value: 1

    Prompt Table: CITIZENSHIP

    57 US_WORK_ELIGIBILTY Character(1) VARCHAR2(1) NOT NULL Eligible to Work in U.S.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    58 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status / Military Status

    Default Value: 1

    59 CITIZEN_PROOF1 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 1)
    60 CITIZEN_PROOF2 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 2)
    61 SMOKER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) an employee or dependent is a smoker.
    N=Non Smoker
    Y=Smoker

    Y/N Table Edit

    Default Value: N

    62 MEDICARE_ENTLD_DT Date(10) DATE Date Entitled to Medicare
    63 SMOKER_DT Date(10) DATE Smoker Status Date
    64 GVT_CRED_MIL_SVCE Character(6) VARCHAR2(6) NOT NULL Creditable Military Service
    65 GVT_MILITARY_COMP Character(1) VARCHAR2(1) NOT NULL GVT_MILITARY_COMP
    A=Air Force
    C=Coast Guard
    M=Marines
    N=Navy
    R=Army
    66 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
    67 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
    68 GVT_MIL_SEP_RET Character(1) VARCHAR2(1) NOT NULL Military Separation Status
    R=Retired
    S=Separated
    Z=Not Applicable
    69 GVT_MIL_SVCE_END Date(10) DATE Military Service End Date
    70 GVT_MIL_SVCE_START Date(10) DATE Military Service Start Date
    71 GVT_MIL_VERIFY Character(1) VARCHAR2(1) NOT NULL Military Service Verified

    Y/N Table Edit

    72 GVT_PAR_NBR_LAST Number(6,0) INTEGER NOT NULL Last Personnel Action Reqst #
    73 GVT_UNIF_SVC_CTR Character(1) VARCHAR2(1) NOT NULL Notify Military Pay Center

    Y/N Table Edit

    74 GVT_VET_PREF_APPT Character(1) VARCHAR2(1) NOT NULL Veterans Preference

    Default Value: 1

    Prompt Table: GVT_VETPREF_TBL

    75 GVT_VET_PREF_RIF Character(1) VARCHAR2(1) NOT NULL Veterans Preference RIF

    Y/N Table Edit

    Default Value: N

    76 GVT_CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Change Flag
    77 GVT_DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
    N=Not Yet Registered
    R=Registered
    X=Not Applicable
    78 GVT_YR_ATTAINED Date(10) DATE Year Attained
    79 DISABLED_VET Character(1) VARCHAR2(1) NOT NULL Disabled Veteran
    80 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

    Prompt Table: GVT_HANDICP_TBL

    81 ETHNIC_GROUP Character(1) VARCHAR2(1) NOT NULL Ethnic Group
    1=White
    2=Black/African American
    3=Hispanic/Latino
    4=Asian
    5=American Indian/Alaska Native
    6=Not Applicable
    7=Native Hawaiian/Oth Pac Island
    A=American Indian/Alaskan Native
    B=Asian or Pacific Islander
    C=Black, not of Hispanic origin
    D=Hispanic
    E=White, not of Hispanic origin
    F=Asian Indian
    G=Chinese
    H=Filipino
    J=Guamanian
    K=Hawaiian
    L=Japanese
    M=Korean
    N=Samoan
    P=Vietnamese
    Q=All Other Asian o Pacific Is
    Y=Not Hispanic in Puerto Rico

    Prompt Table: ETHNIC_GRP_TBL

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

    Default Value: 05

    Prompt Table: GVT_HANDICP_TBL

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

    Prompt Table: %SAL_GRD_PRMPT1

    84 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Default Value: 0000

    Prompt Table: SAL_PLAN_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    87 GVT_HIGH_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Highest Pay Plan

    Prompt Table: GVT_PAY_PLAN

    88 GVT_HIGH_GRADE Character(3) VARCHAR2(3) NOT NULL Highest Grade

    Prompt Table: %SAL_GRD_PRMPT3

    89 GVT_PREV_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Agency Employee
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    91 GVT_SEP_INCENTIVE Character(1) VARCHAR2(1) NOT NULL Separation Incentive
    B=Buyout/VSIP
    E=Early Retirement
    O=Other Incentive
    92 GVT_SEP_INCENT_DT Date(10) DATE Separation Incentive Date
    93 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
    0=None
    1=Permanent
    2=Conditional
    3=Indefinite
    94 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan

    Prompt Table: GVT_PAY_PLAN

    95 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2