SCC_AFLLVSVW_LN

(SQL View)
 Index Back

Lowest level Afl Cd's Lng Rcd

Lowest level Affiliation Codes Language record

SELECT A.INSTITUTION ,A.SCC_AFL_CODE ,B.LANGUAGE_CD ,B.SCC_AFL_DESCRSHORT FROM PS_SCC_AFL_TBL A ,PS_SCC_AFL_TBL_LNG B WHERE A.INSTITUTION =B.INSTITUTION AND A.SCC_AFL_CODE =B.SCC_AFL_CODE AND A.SCC_AFL_CHLDRN = 'N' AND A.EFF_STATUS='A'

  • Related Language Record for SCC_AFL_BTCH_VW SCC_AFL_CLR_VW SCC_AFL_LVS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 SCC_AFL_CODE Character(10) VARCHAR2(10) NOT NULL Affiliations Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SCC_AFL_DESCRSHORT Character(50) VARCHAR2(50) NOT NULL Affiliations Short Description