Notes by Day and Project

Clearinghouse-NSLDS Ongoing Support
Date: 2026-01-08
Meeting to go over any issues, concerns and 2026 schedule. Working on a audit report to find any students who are should be on the roster but are missing.
Estimated Award Letter - SQL
Date: 2026-01-08 · Jira: IDTO-1117
Working on the stored proc, taking the changes from the crystal report and putting them into the stored proc. Met with David, confirmed what we need to add to the data set. Removed SSN unless absolutely needed I have updated the test code with most of the formulas. I need to see some of the example EALs to see exactly what data is needed. Some of the fields, such a Institutional fee might be out of date due to business process changes.
Special Schedule data for Exec Research
Date: 2026-01-08 · Jira: IDTO-1121
Pulled the data for Jonathan to review. He confirmed this is the data he needs. Will pull the rest of the data tomorrow.
ACCSC GE Yearly Reporting
Date: 2026-01-07
Meeting with Jonathan and Julia during. Need to audit ACCSC_ProgramCode to confirm concentrations are cobmined. Questions for Juan: Employee Scholarship
Estimated Award Letter - SQL
Date: 2026-01-07 · Jira: IDTO-1117
Meeting to discuss the different options. Consider doing this by SQL to include all the student situations.
FABOAWAR Report Not Populating
Date: 2026-01-07 · Jira: IDTO-1110
Researching the process now. The report (FL Debt Letter Table Population) starts by putting the data into FSDatum.dbo.FABOAWAR_Import. This data then I think needs to be moved over to INTDB01. I think this job was turned off. I will be opening a ticket to have this job turned back on.