GVT_PD_PUSH_VW

(SQL View)
 Index Back

EE Personal Data

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 , %subrec(NAMEGBL_NPC_SBR,A) , %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 , %subrec(PERS_DTUSA_SBR,A) , A.LANG_CD , A.YEARS_OF_EXP , %subrec(PERS_DTFED_SBR,A) , A.ALTER_EMPLID , A.ADDRESS1_AC , A.ADDRESS2_AC , A.ADDRESS3_AC , A.CITY_AC FROM PS_GVT_PERS_DATA A , PS_GVT_JOB B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EMPL_RCD = 0 AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND B.GVT_STATUS_TYPE IN ('COR', 'COM') AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_GVT_JOB D WHERE D.EMPLID = B.EMPLID AND D.EMPL_RCD = B.EMPL_RCD AND D.EFFDT <= %CurrentDateIn AND D.GVT_STATUS_TYPE IN ('COR', 'COM')) AND B.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_GVT_JOB C WHERE C.EMPLID = B.EMPLID AND C.EMPL_RCD = B.EMPL_RCD AND C.EFFDT = B.EFFDT AND C.GVT_STATUS_TYPE IN ('COM', 'COR'))

  • 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 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types

    Prompt Table: NAME_FORMAT_TBL

    3 NAME Character(50) VARCHAR2(50) NOT NULL Name
    4 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
    5 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: NAME_PREFIX_TBL

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

    Prompt Table: NAME_SUFFIX_TBL

    7 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix

    Prompt Table: NM_ROYPREF_GBL

    8 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix

    Prompt Table: NM_ROYSUFF_GBL

    9 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title

    Prompt Table: TITLE_TBL

    10 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    11 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    12 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    13 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    14 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    15 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    16 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
    17 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    18 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    19 PARTNER_LAST_NAME Character(30) VARCHAR2(30) NOT NULL The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
    20 PARTNER_ROY_PREFIX Character(15) VARCHAR2(15) NOT NULL The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.

    Prompt Table: NM_ROYPREF_GBL

    21 LAST_NAME_PREF_NLD Character(1) VARCHAR2(1) NOT NULL The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
    1=Own Name
    2=Name Partner
    3=Name Partner + Own Name
    4=Own Name + Name Partner

    Default Value: 1

    22 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    23 NAME_FORMAL Character(60) VARCHAR2(60) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    24 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    25 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    26 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    27 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    28 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    29 CITY Character(30) VARCHAR2(30) NOT NULL City
    30 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    31 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    32 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    33 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    34 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    35 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    36 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    37 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    38 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    39 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    40 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

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

    Prompt Table: COUNTRY_TBL

    42 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
    43 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
    44 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
    45 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
    46 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
    47 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    48 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: STATE_OTH

    49 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
    50 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    51 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    52 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    53 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
    54 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
    55 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
    56 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other

    Y/N Table Edit

    57 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    58 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
    59 ORIG_HIRE_DT Date(10) DATE Original Start Date
    60 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    61 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

    Default Value: S

    62 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. */
    63 BIRTHDATE Date(10) DATE Date of Birth
    64 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    65 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: BIRTHSTATE_VW

    67 DT_OF_DEATH Date(10) DATE Date of Death
    68 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level

    Default Value: A

    69 FT_STUDENT Character(1) VARCHAR2(1) NOT NULL Full-Time Student

    Y/N Table Edit

    Default Value: N

    70 US_WORK_ELIGIBILTY Character(1) VARCHAR2(1) NOT NULL Eligible to Work in U.S.

    Y/N Table Edit

    Default Value: Y

    71 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status / Military Status
    1=Not indicated
    2=No Military Service
    3=Veteran of the Vietnam Era
    4=Active Duty/Campaign Badge Vet
    4=Other Protected Veteran
    5=Active Reserve
    6=Inactive Reserve
    7=Retired Military
    8=Veteran (VA Ineligible)
    9=Vietnam & Active Duty Vet
    9=Vietnam & Other Protected Vet
    A=Armed Forces Service Medal Vet
    B=Pre-Vietnam-Era Veteran
    C=Separated/Srvc Medal/Active
    C=Separated/Srvc Medal/Other Vet
    D=Protected, Not Classified
    N=Not a Vietnam-Era Veteran
    O=Service Medal & Active Duty
    O=Service Medal & Other Vet
    P=Post-Vietnam-Era Veteran
    R=Recently Separated Veteran
    S=Separated & Service Medal Vet
    T=Separated & Active Duty Vet
    T=Separated & Other Vet
    V=Vietnam-Era Veteran
    X=Not a Veteran
    X=Not a Veteran
    Z=Not a Protected Veteran

    Default Value: 1

    72 CITIZEN_PROOF1 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 1)
    73 CITIZEN_PROOF2 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 2)
    74 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

    75 MEDICARE_ENTLD_DT Date(10) DATE Date Entitled to Medicare
    76 SMOKER_DT Date(10) DATE Smoker Date
    77 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    CFR=Canadian French
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    GRK=Greek
    INE=International English
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    POR=Portuguese
    SVE=Swedish
    THA=Thai
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    78 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience
    79 GVT_CRED_MIL_SVCE Character(4) VARCHAR2(4) NOT NULL Creditable Military Service
    80 GVT_MILITARY_COMP Character(1) VARCHAR2(1) NOT NULL Uniformed Service
    A=Air Force
    C=Coast Guard
    M=Marines
    N=Navy
    R=Army
    81 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
    82 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
    83 GVT_MIL_SEP_RET Character(1) VARCHAR2(1) NOT NULL Military Separation Status
    R=Retired
    S=Separated
    Z=Not Applicable
    84 GVT_MIL_SVCE_END Date(10) DATE Military Service End Date
    85 GVT_MIL_SVCE_START Date(10) DATE Military Service Start Date
    86 GVT_MIL_VERIFY Character(1) VARCHAR2(1) NOT NULL Military Service Verified

    Y/N Table Edit

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

    Y/N Table Edit

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

    Default Value: 1

    Prompt Table: GVT_VETPREF_TBL

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

    Y/N Table Edit

    Default Value: N

    91 GVT_CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Change Flag
    92 GVT_DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
    N=Not Yet Registered
    R=Registered
    X=Not Applicable
    93 GVT_YR_ATTAINED Date(10) DATE Year Attained
    94 DISABLED_VET Character(1) VARCHAR2(1) NOT NULL Disabled Veteran
    95 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

    96 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 Specified
    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

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

    Default Value: 05

    Prompt Table: GVT_HANDICP_TBL

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

    Prompt Table: %SAL_GRD_PRMPT1

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

    Default Value: 0000

    Prompt Table: SAL_PLAN_TBL

    100 GVT_CURR_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Current Agency Employee

    Y/N Table Edit

    Default Value: N

    101 GVT_CURR_FED_EMPL Character(1) VARCHAR2(1) NOT NULL Current Federal Employee

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: GVT_PAY_PLAN

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

    Prompt Table: %SAL_GRD_PRMPT3

    104 GVT_PREV_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Agency Employee

    Y/N Table Edit

    Default Value: N

    105 GVT_PREV_FED_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Federal Employee

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: GVT_PAY_PLAN

    110 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2
    111 ALTER_EMPLID Character(11) VARCHAR2(11) NOT NULL Alternate Employee ID
    112 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 1
    113 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 2
    114 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3
    115 CITY_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character City