Open in new tab: (print)

Release Notes: Item 2312-01

Campus Based Aid (COD Reporting - CY: 2022) - New

This release introduces the ability to generate COD reporting for Campus Based (CB) Aid, generating XML data for students loaded from an institutionally supplied .CSV file. This release allows for reporting by Calendar year for 2022. The plan is for schools to export CB records 1 time each year, following the same timeline as FISAP reporting.

The first calling program, WFCBWEXB, will invoke a (Calendar) year specific program to read an input .CSV file supplied from institutional data. It will edit the data and load work files for input into a second program (WFCBEXPB) which will create XML records and post an event for each student reported in the XML export. FINANCIER events have been set up to display Aid Year in them. Therefore, these events will display the Aid Year of last payment in the reported Calendar year, as well as a reference to the calendar year being reported in the event description. Also, please note that events will only be created during update runs and sample runs - not during a trial run.

In addition to the standard XML tags that include school, name, address,etc., the <FWS> portion of the XML will include the following:

• <FWS>
• <CalendarYear> - For this first time, the Calendar year is 2022
• <CPSTransactionNumber> - This will always be the most recent CPS transaction number
• <TotalFWSEarnings> - A total of this student's FWS earnings for calendar year 2022

Program specifics:

• WFCBWEXB:
  • work files:
    • Work file 1: Input .CSV file
    • Work file 2: Output Student detail file
    • Work file 3: Output Summary data file
    • Work file 4: Output sort file
  • report files:
    • Report file (CMPRINT): Natural run log file
    • Report file 1 (CMPRT01): Run Summary report
    • Report file 2 (CMPRT02): Run Student edit error report
  • input parameters (follows traditional FINANCIER format):
    • Calendar Year (validates against Cal year in CSV file), Term, FAO, Runmode
    2022,F,UG,TRIAL
• WFCBEXPB:
  • work files:
    • Work file 1: Input Summary data file
    • Work file 2: Input Student detail file
    • Work file 3: Output XML file
  • report files:
    • Report file (CMPRINT): Natural run log file
    • Report file 1 (CMPRT01): Run Summary report

The format of the institutional data should look like the below. The EXPORTED payment amount is required to be a whole dollar amount. We will sum all of the individual payments for one student and round to a whole dollar amount at the end. It is strongly encouraged that actual payemts are fed in the .CSV file. (Header row not required, but allowed):

Calendar Year,SID,FWS Payment,FWS Payment Date (in YYYYMMDD format) 2022,999999999,400.XX,20220131

Implementation Notes

This item is required at all client sites that which to report to COD via FINANCIER.

Load the updated modules from the SYSOBJH input file (sy231201.txt) in the attached zip file.

Compile the delivered data area:

• WFCBE22D

Compile the delivered programs:

• WFCBE22B
• WFCBEXPB
• WFCBW22B
• WFCBWEXB

Execute WFCBWEXB to read the input .CSV file and build files for input to the XML create routine.

Execute WFCBEXPB to read the data files built by WFCBWEXB to create the XML file to be sent to COD and post an event for each student.

Any changes or confirmation of acceptance of export will need to be managed at COD.