SCC_SFP_DISB_VW

(SQL View)
 Index Back

SFP Disbursement Report View

SFP Disbursement Reporting Data View

SELECT P.EMPLID , P.INSTITUTION , P.SCC_VOC_MSG_SEQ , P.SCC_SFP_PROG_CODE , D.ITEM_TYPE , D.STRM , C.SCC_SFP_FUND_CODE , SUM( B.SCC_SFP_DISB_AMT) , SUM( B.SCC_SFP_DISBNETAMT) FROM PS_SCC_SFP_R_PROG P , PS_SCC_SFP_R_DISB A , PS_SCC_SFP_R_DPAY B , PS_SCC_SFP_R_DFUND C , PS_SCC_SFP_R_DLPP D WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.SCC_VOC_MSG_SEQ = B.SCC_VOC_MSG_SEQ AND A.SCC_SFP_FUND_SEQ = B.SCC_SFP_FUND_SEQ AND A.SCC_SFP_YEAR_SEQ = B.SCC_SFP_YEAR_SEQ AND A.SCC_SFP_PERIOD_SEQ = B.SCC_SFP_PERIOD_SEQ AND A.SCC_SFP_PAY_P_SEQ = B.SCC_SFP_PAY_P_SEQ AND A.SCC_SFP_DISB_SEQ = B.SCC_SFP_DISB_SEQ AND B.SCC_SFP_DISB_STAT IN ('Disbursed','Disbursement Returned') AND A.EMPLID = C.EMPLID AND A.INSTITUTION = C.INSTITUTION AND A.SCC_VOC_MSG_SEQ = C.SCC_VOC_MSG_SEQ AND A.SCC_SFP_FUND_SEQ = C.SCC_SFP_FUND_SEQ AND A.EMPLID = D.EMPLID AND A.INSTITUTION = D.INSTITUTION AND A.SCC_VOC_MSG_SEQ = D.SCC_VOC_MSG_SEQ AND A.SCC_SFP_FUND_SEQ = D.SCC_SFP_FUND_SEQ AND A.SCC_SFP_YEAR_SEQ = D.SCC_SFP_YEAR_SEQ AND A.SCC_SFP_PERIOD_SEQ = D.SCC_SFP_PERIOD_SEQ AND A.SCC_SFP_PAY_P_SEQ = D.SCC_SFP_PAY_P_SEQ AND A.EMPLID = P.EMPLID AND A.SCC_VOC_MSG_SEQ = P.SCC_VOC_MSG_SEQ AND A.INSTITUTION = P.INSTITUTION AND A.SCC_VOC_MSG_SEQ = ( SELECT MAX(P1.SCC_VOC_MSG_SEQ) FROM PS_SCC_SFP_R_PROG P1 , PS_SCC_SFA_MSG_MAP M WHERE P.EMPLID = P1.EMPLID AND P.SCC_SFP_PROG_CODE = P1.SCC_SFP_PROG_CODE AND M.EMPLID = P.EMPLID AND M.SCC_VOC_MSG_SEQ = P.SCC_VOC_MSG_SEQ AND M.SCC_VFA_MESSAGE_CL = 'DSB2') GROUP BY P.EMPLID, P.SCC_VOC_MSG_SEQ, P.SCC_SFP_PROG_CODE , P.INSTITUTION, D.STRM, C.SCC_SFP_FUND_CODE, D.ITEM_TYPE

# 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
3 SCC_VOC_MSG_SEQ Number(15,0) DECIMAL(15) NOT NULL Vocado message sequence number
4 SCC_SFP_PROG_CODE Character(4) VARCHAR2(4) NOT NULL SFP program code
5 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
6 STRM Character(4) VARCHAR2(4) NOT NULL Term
7 SCC_SFP_FUND_CODE Character(10) VARCHAR2(10) NOT NULL Fund Name
8 SCC_SFP_DISB_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Disbursed Amount
9 SCC_SFP_DIBSNETAMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Net Disbursement Amount