SCC_AFL_CHLD_VW

(SQL View)
 Index Back

Afl Child Codes

Affiliation Child Codes

SELECT A.INSTITUTION ,A.SCC_AFL_CODE ,B.SCC_AFL_CHLD_CODE ,A.SCC_AFL_DESCR FROM PS_SCC_AFL_TBL A ,PS_SCC_AFL_CHDRN B WHERE A.SCC_AFL_CODE = B.SCC_AFL_CODE AND A.INSTITUTION = B.INSTITUTION AND A.EFFDT = B.EFFDT AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SCC_AFL_TBL A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.SCC_AFL_CODE = A.SCC_AFL_CODE AND A1.EFFDT <=%CurrentDateIn)

  • Related Language Record: SCC_AFLCHLVW_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 SCC_AFL_CODE Character(10) VARCHAR2(10) NOT NULL Affiliations Code
    3 SCC_AFL_CHLD_CODE Character(10) VARCHAR2(10) NOT NULL Child Affiliation Code

    Prompt Table: SCC_AFL_TBL

    4 SCC_AFL_DESCR Character(254) VARCHAR2(254) NOT NULL Affiliations Long Description