SFA_SSAWDDSB_VW(SQL View) |
Index Back |
---|---|
Student Award Disbursement |
SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.ITEM_TYPE ,A.ACAD_CAREER ,C.AWARD_PERIOD ,B.STRM ,A.DISBURSEMENT_ID ,D.FIN_AID_TYPE ,A.OFFER_BALANCE ,A.ACCEPT_BALANCE ,A.AUTHORIZED_BALANCE ,A.DISBURSED_BALANCE ,A.NET_DISB_BALANCE ,A.OFFER_BAL_LN_FEE ,A.ACCEPT_BAL_LN_FEE ,A.OFFER_BAL_REBATE ,A.ACCEPT_BAL_REBATE ,B.DISBURSEMENT_DATE ,C.DESCR FROM PS_STDNT_AWRD_DISB A , PS_DISB_ID_TBL B , PS_AID_YR_CAR_TERM C , PS_STDNT_AWARDS D , PS_ITEM_TYPE_FA E WHERE B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.ACAD_CAREER = A.ACAD_CAREER AND B.DISBURSEMENT_ID = A.DISBURSEMENT_ID AND B.DISBURSEMENT_PLAN = D.DISBURSEMENT_PLAN AND D.EMPLID = A.EMPLID AND D.INSTITUTION = A.INSTITUTION AND D.AID_YEAR = A.AID_YEAR AND D.ITEM_TYPE = A.ITEM_TYPE AND D.ACAD_CAREER = A.ACAD_CAREER AND C.INSTITUTION = B.INSTITUTION AND C.AID_YEAR = B.AID_YEAR AND C.ACAD_CAREER = B.ACAD_CAREER AND C.STRM = B.STRM AND D.SETID = E.SETID AND D.AID_YEAR = E.AID_YEAR AND D.ITEM_TYPE = E.ITEM_TYPE AND E.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITEM_TYPE_FA E1 WHERE E1.SETID = E.SETID AND E1.AID_YEAR = E.AID_YEAR AND E1.ITEM_TYPE = E.ITEM_TYPE AND E1.EFF_STATUS = 'A' AND E1.EFFDT <= %CurrentDateIn ) AND E.PRINT_LTR_OPTION = 'P' GROUP BY A.EMPLID, A.INSTITUTION, A.AID_YEAR, A.ITEM_TYPE, A.ACAD_CAREER, C.AWARD_PERIOD, B.STRM, A.DISBURSEMENT_ID, D.FIN_AID_TYPE, A.OFFER_BALANCE ,A.ACCEPT_BALANCE ,A.AUTHORIZED_BALANCE ,A.DISBURSED_BALANCE ,A.NET_DISB_BALANCE ,A.OFFER_BAL_LN_FEE ,A.ACCEPT_BAL_LN_FEE ,A.OFFER_BAL_REBATE ,A.ACCEPT_BAL_REBATE ,B.DISBURSEMENT_DATE ,C.DESCR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
2 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
3 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
4 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Item Type |
5 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
6 | AWARD_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Award Period
A=Academic N=Non Standard Default Value: AID_YR_CAR_TERM.AWARD_PERIOD |
7 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: AY_CAR_TRM_VW |
8 | DISBURSEMENT_ID | Character(2) | VARCHAR2(2) NOT NULL | Disbursement ID |
9 | FIN_AID_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Fin Aid Type
A=Athletic B=Bursary F=Fellowship G=Grant L=Loan S=Scholarship V=Waiver W=Work/Study |
10 | OFFER_BALANCE | Number(12,2) | DECIMAL(11,2) NOT NULL | Offer Balance |
11 | ACCEPT_BALANCE | Number(12,2) | DECIMAL(11,2) NOT NULL | Accept Balance |
12 | AUTHORIZED_BALANCE | Number(12,2) | DECIMAL(11,2) NOT NULL | Authorized Balance |
13 | DISBURSED_BALANCE | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Disbursed Balance |
14 | NET_DISB_BALANCE | Number(12,2) | DECIMAL(11,2) NOT NULL | Net Disb Balance |
15 | OFFER_BAL_LN_FEE | Number(7,2) | DECIMAL(6,2) NOT NULL | Offer Balance Loan Fee |
16 | ACCEPT_BAL_LN_FEE | Number(7,2) | DECIMAL(6,2) NOT NULL | Accept Balance Loan Fee |
17 | OFFER_BAL_REBATE | Number(7,2) | DECIMAL(6,2) NOT NULL | Offer Balance Rebate |
18 | ACCEPT_BAL_REBATE | Number(7,2) | DECIMAL(6,2) NOT NULL | Accept Balance Rebate |
19 | DISBURSEMENT_DATE | Date(10) | DATE | Disbursement Date |
20 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |