NE_PERSONAL_DTA

(SQL Table)
 Index Back

Non-Employee Personal Data

Use NE_PERSONAL_DATA to collect personal and demographic data about non-employees such as contractors or part-time workers you need to track in the Health and Safety module when they are involved in incidents in the workplace.

  • Related Language Record: NE_PERSDATA_LNG

  • Parent Record Of HA_RESP_PHO_BRA HA_RESP_REG_BRA NE_PERS_PHONE PHYSICIAN_BRA PHYS_PHONE_VW

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

    Default Value: 0

    2 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types

    Default Value: OPR_DEF_TBL_HR.COUNTRY_NM_FORMAT

    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 Name 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 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 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 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title
    25 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    26 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

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

    Y/N Table Edit

    43 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_HR

    44 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    45 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

    Prompt Table: PERSON_NAME

    46 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown

    Default Value: U

    47 BIRTHDATE Date(10) DATE Date of Birth
    48 DT_OF_DEATH Date(10) DATE Date of Death
    49 COURSE_ATTENDEE Character(1) VARCHAR2(1) NOT NULL Training Course Attendee

    Y/N Table Edit

    50 INVOLVED_INCIDENT Character(1) VARCHAR2(1) NOT NULL Involved in H&&S Incident

    Y/N Table Edit

    51 SUPERVISOR_NAME Character(50) VARCHAR2(50) NOT NULL Supervisor Name
    52 PHYSICIAN_SW Character(1) VARCHAR2(1) NOT NULL Physician

    Y/N Table Edit

    53 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    54 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION