SSFACOADTLVWLNG

(SQL View)
 Index Back

Rel lng stdt_budget_it awd_prd

SSFACOADTLVWLNG is the language record related to SS_FA_COADTL_VW

SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , B.AWARD_PERIOD , B.STRM , A.BGT_ITEM_CATEGORY , D.LANGUAGE_CD , D.DESCR , C.DESCR FROM PS_STDNT_BUDGET_IT A , PS_STDNT_CR_TERM B , PS_BUDGET_CATG_LNG C , PS_TERM_TBL_LANG D WHERE A.EFFDT=( SELECT MAX(A1.EFFDT) FROM PS_STDNT_BUDGET_IT A1 WHERE A1.EMPLID = A.EMPLID AND A1.AID_YEAR = A.AID_YEAR AND A1.INSTITUTION = A.INSTITUTION AND A1.ACAD_CAREER = A.ACAD_CAREER AND A1.STRM = A.STRM AND A1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ=( SELECT MAX(A2.EFFSEQ) FROM PS_STDNT_BUDGET_IT A2 WHERE A2.EMPLID = A.EMPLID AND A2.AID_YEAR = A.AID_YEAR AND A2.INSTITUTION = A.INSTITUTION AND A2.ACAD_CAREER = A.ACAD_CAREER AND A2.STRM = A.STRM AND A2.EFFDT = A.EFFDT) AND A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STRM = B.STRM AND A.INSTITUTION = C.INSTITUTION AND A.AID_YEAR = C.AID_YEAR AND A.BGT_ITEM_CATEGORY = C.BGT_ITEM_CATEGORY AND A.INSTITUTION = D.INSTITUTION AND A.ACAD_CAREER = D.ACAD_CAREER AND A.STRM = D.STRM

  • Related Language Record for SS_FA_COADTL_VW

  • Parent record: SS_FA_COA_VW

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

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    4 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard
    5 STRM Character(4) VARCHAR2(4) NOT NULL Term
    6 BGT_ITEM_CATEGORY Character(4) VARCHAR2(4) NOT NULL Budget Item Category
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR_TERM Character(30) VARCHAR2(30) NOT NULL Description
    9 DESCR_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category Description