FOEMPLDATA_UPG

(SQL Table)
 Index Back

Employee Data

Basic Personal Data for each Applicant or Employee.

  • Parent Record Of FOEMPEDUCAT_UPG FOEMPLINTVW_UPG FOEMPLSKILL_UPG FOEMPSRVARE_UPG FOTESTRESUL_UPG

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

    Prompt Table: FO_EMPLID_VW

    2 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Format for Country
    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
    1=Mr.
    2=Mrs.
    3=Ms.
    6 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
    7 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
    8 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
    9 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
    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_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
    16 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last 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 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
    E=Employee
    N=Non-Employee

    Default Value: A

    20 APP_DT Date(10) DATE Application Date

    Default Value: %date

    21 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    22 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: OPRDEFTBL_UPG.COUNTRY

    Prompt Table: COUNTRY_TBL

    23 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
    NO=None
    PR=Payroll Identification

    Default Value: OPRDEFTBL_UPG.NATIONAL_ID_TYPE

    Prompt Table: NID_TYPE_PRM_VW

    24 SAME_MAIL_ADDR Character(1) VARCHAR2(1) NOT NULL Use Home Address as Mailing

    Y/N Table Edit

    Default Value: Y

    25 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: %EDIT_STATE

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

    Y/N Table Edit

    42 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 1
    43 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 2
    44 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3
    45 CITY_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character City
    46 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

    Prompt Table: COUNTRY_TBL

    47 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
    48 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
    49 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
    50 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
    51 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
    52 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    53 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: %EDIT_STATE_OTH

    54 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
    55 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    56 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    57 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    58 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
    59 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
    60 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
    61 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other
    62 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    63 CAREER_ASSIGNMENT Character(1) VARCHAR2(1) NOT NULL Career Assignment?
    N=Not-Placed on a Career Order
    P=Placed On a Career Order

    Default Value: N

    64 EMP_ASSGN Character(1) VARCHAR2(1) NOT NULL Assignment

    Default Value: U

    65 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Type
    BUSN=Business
    CAMP=Campus
    DORM=Dorm
    HOME=Home
    OTHR=Other
    66 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    67 URL_TYPE Character(4) VARCHAR2(4) NOT NULL Website Type
    1=Business 1
    2=Home
    3=Business 2
    68 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    69 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
    BUSN=Business Phone
    CAMP=Campus Phone
    CELL=Cellular Phone
    DORM=Dormitory Phone
    FAX=FAX
    HOME=Home Phone
    MAIN=Main
    OTR=Other
    PGR1=Pager 1
    PGR2=Pager 2
    TELX=Telex
    70 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    71 PROSPECT_FLAG Character(1) VARCHAR2(1) NOT NULL Customer/Prospect Flag

    Y/N Table Edit

    Default Value: N

    72 TOTAL_COUNT Number(7,0) INTEGER NOT NULL Total Count
    73 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
    74 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown

    Default Value: U

    75 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    M=Married
    S=Single
    U=Unknown
    W=Widowed

    Default Value: U

    76 BIRTHDATE Date(10) DATE Date of Birth
    77 FO_CITIZEN_PROOF1 Character(20) VARCHAR2(20) NOT NULL Alt Doc ID
    78 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Military Status
    1=Not Indicated
    2=No Military Service
    3=Veteran of the Vietnam Era
    4=Other Protected Veteran
    5=Active Reserve
    6=Inactive Reserve
    7=Retired Military
    8=Veteran (VA Ineligible)
    9=Vietnam & Other Protected Vet
    B=Pre-Vietnam-Era Veteran
    N=Not a Vietnam-Era Veteran
    P=Post-Vietnam-Era Veteran
    V=Vietnam-Era Veteran
    X=Not a Veteran

    Default Value: 1

    79 PER_TYPE Character(1) VARCHAR2(1) NOT NULL Person Type
    A=Applicant
    C=Cobra Participant
    D=GP Dependent/Beneficiary
    E=Leased Worker
    I=Independent Contractor
    L=Time & Labor Contractor
    M=Temporary Worker
    N=Non HR Administered Employee
    O=Other Non-Employee
    P=Pension Payee
    S=Stock Non-Employee
    T=Training Non-Employee
    U=Succession Candidate Non-Emplo
    80 FT_STUDENT Character(1) VARCHAR2(1) NOT NULL Full-Time Student

    Y/N Table Edit

    Default Value: N

    81 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level

    Default Value: A

    82 AGE_STATUS Character(1) VARCHAR2(1) NOT NULL Age 18 or Older

    Y/N Table Edit

    Default Value: Y

    83 HIGHLY_COMP_EMPL_C Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not an employee is considered highly compensated according to U.S. Government regulations in the current year, and is used for managing Section 401savings plans or Section 129 spending accounts. The valid values, as delivered, are Not Eligible (N), Highly Compensated (H), Eligible Non-Officer,Non5% (E), and Eligible Officer (O). This field is system-maintained.
    E=Eligile non-Officer, non 5%
    H=Highly Compensated Employee
    N=Not Eligible for the Plan
    O=Eligible Officer, not HCE

    Default Value: N

    84 HIGHLY_COMP_EMPL_P Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not an employee is considered highly compensated according to U.S. Government regulations in the year prior to the current year, and is used for managing Section 401savings plans or Section 129 spending accounts. The valid values, as delivered, are Not Eligible (N), Highly Compensated (H), Eligible Non-Officer,Non5% (E), and Eligible Officer (O). This field is system-maintained.
    E=Eligible non-Officer, non 5%
    H=Highly Compensated Employee
    N=Not Eligible for the Plan
    O=Eligible Officer, not HCE

    Default Value: N

    85 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

    Default Value: OPRDEFTBL_UPG.COUNTRY

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: BIRTHSTATE_VW