SS_FA_COADTL_VW

(SQL View)
 Index Back

stdnt_budget_it + awd_period

SS_FA_COADTL_VW is a view of max-effective dated budget categories and budget item amounts. It is used to display the details of COA on a self-service page.

SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , B.AWARD_PERIOD , B.STRM , A.BGT_ITEM_CATEGORY , D.DESCR , C.DESCR , A.BUDGET_ITEM_CD , C.BUDGET_ITEM_TYPE , A.BUDGET_ITEM_AMOUNT FROM PS_STDNT_BUDGET_IT A , PS_STDNT_CR_TERM B , PS_BUDGET_CATG_TBL C , PS_TERM_TBL 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: SSFACOADTLVWLNG

  • 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 DESCR_TERM Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCR_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category Description
    9 BUDGET_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Budget Item Code
    10 BUDGET_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Item Classification
    F=Federal
    I=Institutional
    11 BUDGET_ITEM_AMOUNT Number(8,2) DECIMAL(7,2) NOT NULL Budget Item Amount