SCC_PERAFL_AFLT

(SQL View)
 Index Back

Person 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 A.EMPLID , A.INSTITUTION , A.SCC_AFL_CODE , A.START_DT , A.SCC_AFL_SPONS_DEPT , A.END_DT , A.LASTUPDOPRID , A.LASTUPDDTTM , A.SCC_AFL_PLCD_MTD , A.SCC_AFL_RLCD_MTD , A.SCC_AFL_STATUS , A.SCC_AFL_STS_DESCR , A.SCC_AFL_RANK FROM PS_SCC_AFL_PERSON A WHERE EXISTS ( SELECT 'X' FROM PS_SCC_AFL_ROUTING R WHERE R.INSTITUTION = A.INSTITUTION AND R.SCC_AFL_CODE = A.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

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution

    Prompt Table: INSTITUTION_TBL

    3 SCC_AFL_CODE Character(10) VARCHAR2(10) NOT NULL Affiliations Code

    Prompt Table: SCC_AFL_LVS_VW

    4 START_DT Date(10) DATE NOT NULL Start Date
    5 SCC_AFL_SPONS_DEPT Character(10) VARCHAR2(10) NOT NULL Affiliation Code's Sponsoring Department

    Prompt Table: SCC_DEPT_TBL_VW

    6 END_DT Date(10) DATE end date
    7 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    9 SCC_AFL_PLCD_MTD Character(1) VARCHAR2(1) NOT NULL Placed Method for Affiliations
    B=Batch
    E=Event
    M=Manual
    S=System
    10 SCC_AFL_RLCD_MTD Character(1) VARCHAR2(1) NOT NULL Released Method for Affiliations
    B=Batch
    E=Event
    M=Manual
    S=System
    11 SCC_AFL_STATUS Character(3) VARCHAR2(3) NOT NULL Affiliation Status
    ACT=Active
    ERR=Created In Error
    INA=Inactive
    12 SCC_AFL_STS_DESCR Character(30) VARCHAR2(30) NOT NULL Affiliation Status Description

    Prompt Table: SCC_AFL_STS_DES

    13 SCC_AFL_RANK Character(5) VARCHAR2(5) NOT NULL Affiliation Ranking per institution