SCC_AFLCHLVW_LN

(SQL View)
 Index Back

Afl Child Codes Lang Rcd

Affiliation Child Codes Language Record

SELECT A.INSTITUTION ,A.SCC_AFL_CODE ,C.SCC_AFL_CHLD_CODE ,B.LANGUAGE_CD ,B.SCC_AFL_DESCR FROM PS_SCC_AFL_TBL A ,PS_SCC_AFL_TBL_LNG B ,PS_SCC_AFL_CHDRN C WHERE A.INSTITUTION=B.INSTITUTION AND A.SCC_AFL_CODE=B.SCC_AFL_CODE AND A.SCC_AFL_CODE = C.SCC_AFL_CODE

  • Related Language Record for SCC_AFL_CHLD_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 SCC_AFL_CHLD_CODE Character(10) VARCHAR2(10) NOT NULL Child Affiliation Code

    Prompt Table: SCC_AFL_TBL

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 SCC_AFL_DESCR Character(254) VARCHAR2(254) NOT NULL Affiliations Long Description