ANTC_AID_TERMWB(SQL View) |
Index Back |
---|---|
Anticipated Aid TermThe Anticipated Financial Aid table stores the amount of financial aid per award that is anticipated for a given disbursement period within a term. Once the aid has been disbursed (posted to the student account) the anticipated amount is decreased by the disbursed amount. Rows are added to the table each time activity that impacts the disbursemment amount takes place. |
SELECT A.EMPLID ,A.STRM ,SUM(A.NET_AWARD_AMT) FROM PS_ANTICIPATED_AID A WHERE A.NET_AWARD_AMT > 0 AND (A.DISB_EXPIRE_DT > %CURRENTDATEIN OR A.DISB_EXPIRE_DT IS NULL) AND A.AS_OF_DTTM=(SELECT MAX(AS_OF_DTTM) FROM PS_ANTICIPATED_AID C WHERE A.EMPLID = C.EMPLID AND A.INSTITUTION = C.INSTITUTION AND A.AID_YEAR = C.AID_YEAR AND A.ITEM_TYPE = C.ITEM_TYPE AND A.ACAD_CAREER=C.ACAD_CAREER AND A.DISBURSEMENT_ID=C.DISBURSEMENT_ID) GROUP BY A.EMPLID ,A.STRM |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: STUDENT_AID |
2 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: DISB_ID_TBL |
3 | NET_AWARD_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Net Award Amount |