SCC_AFL_PARENT

(SQL View)
 Index Back

Parent Afl Codes

Parent Affiliation Codes

SELECT A.INSTITUTION ,A.SCC_AFL_CODE ,A.EFFDT ,A.SCC_AFL_DESCRSHORT FROM PS_SCC_AFL_TBL A WHERE SCC_AFL_IS_ROOT = 'Y' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_SCC_AFL_TBL B WHERE B.INSTITUTION = A.INSTITUTION AND B.SCC_AFL_CODE = A.SCC_AFL_CODE AND B.EFFDT <= %CurrentDateIn ) AND A.EFF_STATUS = 'A'

  • Related Language Record: SCC_AFLPARNT_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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 SCC_AFL_DESCRSHORT Character(50) VARCHAR2(50) NOT NULL Affiliations Short Description