SCC_PER_SA_AFLT

(SQL View)
 Index Back

Person SA Affiliation Filtered

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.VA_BENEFIT , P.CAMPUS_ID , P.DEATH_CERTIF_NBR , P.FERPA , P.PLACE_OF_DEATH FROM PS_PERSON_SA 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: SCC_PERSON_AFLT

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

    Y/N Table Edit

    Default Value: N

    3 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
    4 DEATH_CERTIF_NBR Character(10) VARCHAR2(10) NOT NULL Death Certificate Nbr
    5 FERPA Character(1) VARCHAR2(1) NOT NULL FERPA

    Y/N Table Edit

    Default Value: N

    6 PLACE_OF_DEATH Character(30) VARCHAR2(30) NOT NULL Place of Death