SCC_PERSON_AFLT

(SQL View)
 Index Back

Affiliation Filtered Person

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 P.EMPLID ,' ' ,P.BIRTHDATE ,P.BIRTHPLACE ,P.BIRTHCOUNTRY ,P.BIRTHSTATE ,P.DT_OF_DEATH FROM PS_HCR_PERSON_I P WHERE EXISTS ( SELECT 'X' FROM PS_SCC_AFL_PERSON AF , PS_SCC_AFL_ROUTING R WHERE AF.EMPLID = P.EMPLID AND R.INSTITUTION = AF.INSTITUTION AND R.SCC_AFL_CODE = AF.SCC_AFL_CODE )

  • Parent Record Of SCC_ADRTYP_AFLT SCC_NAMTYP_AFLT SCC_PERAFL_AFLT SCC_PEREML_AFLT SCC_PERNID_AFLT SCC_PERPDE_AFLT SCC_PERPHN_AFLT SCC_PER_SA_AFLT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 SCC_UID Character(100) VARCHAR2(100) NOT NULL Universal Hub ID
    3 BIRTHDATE Date(10) DATE Date of Birth
    4 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    5 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

    Prompt Table: COUNTRY_TBL

    6 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State

    Prompt Table: BIRTHSTATE_VW

    7 DT_OF_DEATH Date(10) DATE Date of Death