PERSON_PRINAME

(SQL View)
 Index Back

Person's Primary Name

This view retrieves the current, the future and pending approval effective names record for primary name.

SELECT A.EMPLID ,A.NAME_TYPE ,%subrec(NAME_SBR,A) ,A.ASOFDATE ,A.NAME_PSFORMAT ,' ' FROM PS_PERSON_NAME_SS A UNION SELECT A.EMPLID ,A.NAME_TYPE ,%subrec(NAME_SBR,A) ,A.ASOFDATE ,A.NAME_PSFORMAT ,' ' FROM PS_PERSON_NAME_SS1 A UNION SELECT A.EMPLID ,A.NAME_TYPE ,%subrec(NAME_SBR,A) ,A.ASOFDATE ,A.NAME_PSFORMAT ,A.SS_STAT_INDICATOR FROM PS_PERS_NAME_WF_SS A

  • Related Language Record: PERSON_PRINMLNG

  • Parent record: PERSON

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

    Prompt Table: PERSON

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

    Prompt Table: NAME_FORMAT_TBL

    4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    6 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    7 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    8 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: NAME_PREFIX_TBL

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

    Prompt Table: NAME_SUFFIX_TBL

    10 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
    11 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Name Title

    Prompt Table: TITLE_TBL

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

    Prompt Table: NM_ROYPREF_GBL

    13 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name - Royal Suffix

    Prompt Table: NM_ROYSUFF_GBL

    14 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

    15 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.
    16 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

    17 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    18 PREF_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred Last Name
    19 PREF_MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Preferred Middle Name
    20 PREF_SEC_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred Second Last Name
    21 PREF_NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Preferred Name Prefix

    Prompt Table: NAME_PREFIX_TBL

    22 PREF_NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Preferred Name Suffix

    Prompt Table: NAME_SUFFIX_TBL

    23 PREF_NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Preferred Name Title

    Prompt Table: TITLE_TBL

    24 NAME Character(50) VARCHAR2(50) NOT NULL Name
    25 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    26 NAME_FORMAL Character(60) VARCHAR2(60) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    27 NAME_FORMAL_PSF Character(60) VARCHAR2(60) NOT NULL Preferred Name (PS FORMAT)
    28 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    29 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    30 MIDDLE_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Middle Name uppercase search field
    31 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    32 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    33 PARTN_LAST_NM_SRCH Character(30) VARCHAR2(30) NOT NULL Uppercase version of partner last name to improve performance on searches.
    34 PREF_FIRST_NM_SRCH Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    35 PREF_LAST_NM_SRCH Character(30) VARCHAR2(30) NOT NULL Uppercase version of preferred last name to improve performance on searches.
    36 PREF_MIDL_NM_SRCH Character(30) VARCHAR2(30) NOT NULL Uppercase version of preferred middle name to improve performance on searches.
    37 PREF_LAST_SEC_SRCH Character(30) VARCHAR2(30) NOT NULL Uppercase version of preferred second last name to improve performance on searches.
    38 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    39 NAME_FORMAL_SRCH Character(60) VARCHAR2(60) NOT NULL Uppercase version of formal name to improve performance on searches.
    40 ASOFDATE Date(10) DATE As of Date
    41 NAME_PSFORMAT Character(50) VARCHAR2(50) NOT NULL A Person's name in the Peoplesoft Format (basically LN,FN MI
    42 SS_STAT_INDICATOR Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    A=Approved
    B=CI failed - Errors & Warnings
    C=Cancelled
    D=Denied
    E=Errors Encountered
    I=In Approval Process
    M=Administrator Action Required
    S=Success
    W=Warnings Encountered