HCR_SCC_PR_NM_I

(SQL View)
Index Back

Current Primary Name Interf.Vw

Current Primary Name Interface View

SELECT A.EMPLID ,A.EFFDT , A.FIRST_NAME , A.FIRST_NAME_SRCH , A.LAST_NAME , A.LAST_NAME_SRCH ,A.NAME FROM PS_SCC_PRI_NAME_VW A

  • 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    4 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    7 NAME Character(50) VARCHAR2(50) NOT NULL Name