SCC_NAMES_L1_H

(SQL View)
 Index Back

Person Names

Campus Solutions hollow view for the core NAMES table. Data is actually sourced from the Service Oriented Architecture.

SELECT ' ' , ' ' , %DateNull , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' ,' ' ,' ' , %DateTimeNull FROM %Table(INSTALLATION_SA)

  • Parent record: HCR_PERSON_I

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

    Default Value: SCC_ADDR_H.EMPLID

    Prompt Table: HCR_PERSON_I

    2 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

    Default Value: INSTALLATION_CC.NAME_TYPE

    Prompt Table: HCR_NM_TYP_I

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 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

    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
    8 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: HCR_NM_PREFIX_I

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

    Prompt Table: HCR_NM_SUFFIX_I

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

    Prompt Table: SCC_NMRYLPRF_VW

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

    Prompt Table: NM_ROYSUFF_GBL

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

    Prompt Table: TITLE_TBL

    13 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    14 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    15 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    16 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    17 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    18 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    19 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
    20 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    21 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    22 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.
    23 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: SCC_NMRYLPRF_VW

    24 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

    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 PREF_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred Last Name
    28 PREF_MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Preferred Middle Name
    29 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    30 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.