PERS_NID_VW1

(SQL View)
 Index Back

PERS_NID Record

PERS_NID is the child record of PERSON and hold the NID_SBR which contains information about National ID.

SELECT A.EMPLID , A.COUNTRY , A.NATIONAL_ID_TYPE , A.NATIONAL_ID , A.SSN_KEY_FRA , A.PRIMARY_NID , A.TAX_REF_ID_SGP , B.NID_TYPE_DEFAULT FROM PS_PERS_NID A , PS_NID_TYPE_TBL B WHERE B.COUNTRY = A.COUNTRY AND B.NATIONAL_ID_TYPE = A.NATIONAL_ID_TYPE

  • Parent record: PERSON

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

    Default Value: NEW

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

    Prompt Table: NID_TYPE_VW

    3 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type

    Default Value: NID_TYPE2_VW.NATIONAL_ID_TYPE

    Prompt Table: NID_TYPE1_VW

    4 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    5 SSN_KEY_FRA Character(2) VARCHAR2(2) NOT NULL Social Security # Key
    6 PRIMARY_NID Character(1) VARCHAR2(1) NOT NULL Primary ID

    Y/N Table Edit

    Default Value: N

    7 TAX_REF_ID_SGP Character(1) VARCHAR2(1) NOT NULL Tax Reference Id - Singapore

    Y/N Table Edit

    Default Value: N

    8 NID_TYPE_DEFAULT Character(1) VARCHAR2(1) NOT NULL NID Type Default