SCC_AFLPARNT_LN

(SQL View)
 Index Back

Parent Afl Codes Lng Rcd

Parent Afl Codes Language Record

SELECT A.INSTITUTION ,A.SCC_AFL_CODE , B.LANGUAGE_CD ,A.EFFDT ,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.EFFDT=B.EFFDT AND A.SCC_AFL_IS_ROOT = 'Y'

  • Related Language Record for SCC_AFL_PARENT SSR_ADMN_PARVW

    • # 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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