SCC_PERNID_AFLT

(SQL View)
 Index Back

National ID Affiliation Filter

Filter persons based on whether their affiliation is in the affiliation routing table. This is to enable content based routing for the full sync.

SELECT A.EMPLID ,%subrec(NID_SBR,A) ,%subrec(PERSNID_SGP_SBR,A) FROM PS_HCR_PER_NID_I A

  • Parent record: SCC_PERSON_AFLT

    • # 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