SCC_AFLCHDVW_LN

(SQL View)
 Index Back

Afl Child Codes Lng Record

Affiliation Child 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_IS_ROOT <> 'Y'

  • Related Language Record for SCC_AFL_CHD_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SCC_AFL_DESCRSHORT Character(50) VARCHAR2(50) NOT NULL Affiliations Short Description