SFA_DISBAWDG_VW

(SQL View)
 Index Back

Student Disb Award Group View

Selects rows from STDNT_DISB_AWD for an Institution and Aid Year using ITEM_TYPE_GROUP.

SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , C.ITEM_TYPE_GROUP , A.ITEM_TYPE , A.DISBURSED_AMOUNT , B.CURRENCY_CD FROM PS_STDNT_DISB_AWD A , PS_STDNT_AWRD_DISB B , PS_ITEM_GROUP_TBL C , PS_ITEM_GROUP_DTL D , PSTREEDEFN E , PSTREENODE F , PSTREELEAF G WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.ITEM_TYPE = A.ITEM_TYPE AND B.ACAD_CAREER = A.ACAD_CAREER AND B.DISBURSEMENT_ID = A.DISBURSEMENT_ID AND C.SETID = ( SELECT H.SETID FROM PS_SET_CNTRL_REC H WHERE H.SETCNTRLVALUE = A.INSTITUTION AND H.RECNAME = 'ITEM_GROUP_TBL') AND C.EFFDT = ( SELECT MAX (CC.EFFDT) FROM PS_ITEM_GROUP_TBL CC WHERE CC.SETID = C.SETID AND CC.ITEM_TYPE_GROUP = C.ITEM_TYPE_GROUP AND CC.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A' AND D.SETID = C.SETID AND D.ITEM_TYPE_GROUP = C.ITEM_TYPE_GROUP AND D.EFFDT = C.EFFDT AND E.TREE_NAME = C.TREE_NAME AND E.EFFDT = ( SELECT MAX (EE.EFFDT) FROM PSTREEDEFN EE WHERE EE.SETID = E.SETID AND EE.TREE_NAME = E.TREE_NAME AND EE.EFFDT <= %CurrentDateIn) AND E.VALID_TREE = 'Y' AND F.SETID = E.SETID AND F.TREE_NAME = E.TREE_NAME AND F.EFFDT = E.EFFDT AND G.SETID = E.SETID AND G.TREE_NAME = E.TREE_NAME AND G.EFFDT = E.EFFDT AND E.SETID = C.TREE_NAME_SETID AND F.TREE_NODE = D.TREE_NODE AND G.TREE_NODE_NUM = F.TREE_NODE_NUM AND A.ITEM_TYPE >= G.RANGE_FROM AND A.ITEM_TYPE <= G.RANGE_TO

# 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 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
4 ITEM_TYPE_GROUP Character(10) VARCHAR2(10) NOT NULL Item Type Group
5 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
6 SFA_DISBURSED_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Disbursed Amount
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: INSTALLATION.EXCHNG_TO_CURRENCY