FPAD_BEN_NID_VW

(SQL View)
Index Back

Nat Identif of Benef Dependent


SELECT A.EMPLID , B.EMPLID , B.COUNTRY , B.NATIONAL_ID_TYPE , B.NATIONAL_ID , B.SSN_KEY_FRA , B.PRIMARY_NID FROM PS_PERSONAL_DT_FST A , PS_PERS_NID B WHERE A.EMPLID <> B.EMPLID

  • Parent record: DEPENDENT_BENEF
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 FP_DEPEND_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID of the Dependent
    3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: NID_TYPE_VW

    4 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

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

    Y/N Table Edit

    Default Value: N