Current Report (FSU Fee Remissions Report (OFC v2)) is located on https://its-cog-dev.ucsd.edu (login w/ AD)
Team Content > Graduate Division > Financial Support Unit
Access to the report may be requested via
https://support.ucsd.edu/path?id=sc_cat_item&sys_id=1354cbfadbf01890dbd6f2b6af9619f7 (this link is on bah.ucsd.edu)
We will need to have three versions of this report to support the following:
...
| Tasks | Assigned | Notes |
|---|---|---|
| Implement a data module that will allow for linking of AR , LL Salary, and Student Demographics data | Bhavya Guntupalli Working with Jim Ybarra | After our last meeting with Judy White and BI team we understood that it would be possible to create a data module that would allow for the linking of the various packages needed |
Create a Calculated field -Term Code field based on the date range that LL Pay Period End Date | Bhavya Guntupalli | Terms: 10/1 - 12/31 (FA) 1/1 - 3/31 (WI) 4/1-6/30 (SP) |
| Create a join between AR Data and LL Salary data using the Term Code (mentioned above) and PID | Bhavya Guntupalli | |
| Add the TERM_CODE and APPLY_AMT field to the Report | Bhavya Guntupalli | The APPLY_AMT should be a SUM by Student and Term Code. The Mock data has been updated to show expected results. GMAH and GMAJ filters for code |
Create an additional join to Student Demographics package using the student PID | Bhavya Guntupalli | Graduate Primary Major Department Current |
| Using the Student Demographic data, add the student's Department to the report | Bhavya Guntupalli | |
| Research Changes in Dept per Term | Carlo Del Frate | Per Jonathan Wai, Alfredo has been reporting on changes in Degree. May take some more research to see how to track this. |
Implement Calculated Field - Proportional Split = =ROUND(M11*W11,4) LL Job FTE * GSRTF Rate Factor rounded to four decimals | Bhavya Guntupalli | |
| Implement Calculated Field - IA Rate = =M11/SUM($M$11,$M$13,$M$15)*AF11 LL Job FTE/ Sum of LL Job FTE where the LL Job Code is in (TA Title Codes) for the given Term | Bhavya Guntupalli | |
Implement Calculated Field - IA Remission = =AE11*AG11 APPLY_AMT * IA Rate | Bhavya Guntupalli | |
| Implement Calculated Field - |
...