CC.016.1 - FA Reconciliation to Reporting (Project Archive)
User Acceptance Test Overview
The information below is intended to provide colleges guidance on performing a User Acceptance Test on this business process. The business process shown in the flow diagrams below may be only part of what is needed to complete an end-to-end test of a full business cycle. Coordination with other colleagues at your college in advance of commencing testing is key to success. In the same way that it doesn't take a single individual to operate the business of running a college, it will require coordination across departments to test a business flow from beginning to end successfully.
Business Process Flow Diagram(s)
Self-Paced Training Materials (Advanced Prep)
To prepare yourself in advance for the richest testing experience below are required Canvas Courses. Successful course completion is a prerequisite to participate in all UAT activities.
- FA105 Processing Return of Title IV Funds
- FA106 Financial Aid Reporting (WCG, URR, FISAP)
- FA107 FA Reconciliation (FA-SF)
To register for these required courses visit thectcLink Training Registration Page.
Instructor-Led Training Materials and Recordings
Instructor-Led Training Materials
Training Session Recordings
Links to Quick Reference Guides - Steps in the Test Process
Note: When the FA Flow Business Processing Guide is loading (steps CC.016.1.1 - CC.016.1.7), please allow time for the document to load beyond the first page, and to the process. You may also opt to download and print the Google Doc.)
- CC.016.1.1 Process Census
-
CC.016.1.2 R2T4 Processing
- Mass Assign F03 Service Indicator
- Run Service List Query (F03 Service Indicator, Active Term 2215 or 2217)
- Create R2T4 Worksheet (using student 3 or more students identified in Service List Query F03 results)
-
CC.016.1.3 Adjust Aid & Undisburse
- Adjust Aid and Un-disburse Single Student (on students for whom R2T4 worksheet was created)
- CC.016.1.4 F05 Service Indicator Assignment
-
CC.016.1.5 Reconciliation Processing
- Running the Fund Roster (review and work 3 to 6 examples in the fund roster). (*Tip, view the video: Troubleshooting Examples Found in the Fund Roster, linked in the Advanced Prep above)
- Fund Roster in Schedule Query
- Run and Review/Work Award Data by Item Type Query
- Review Fiscal Item Types page
- Run in Schedule Query: CTC_FA_SF_DISCREPANCY_LIST Query (review and work 3 to 6 examples)
- Run in Schedule Query: CTC_FA_DISBURSED_BY_DATES_UNITS Query (review and work 3 to 6 examples)
- Run in Schedule Query: CTC_SF_FINAID_SUMMARY Query (review and work 3 to 6 examples)
- Run in Schedule Query: CTC_SF_FINAID_DETAILS Query (review and work 3 to 6 examples)
- CC.016.1.6 SNG Interim Processing
- CC.016.1.7 Unit Record Reporting ***Attn: URR is not able to be tested in UAT due to the fact prior year data wouldn’t exist
-
CC.016.1.8 FISAP
- Attn: FISAP is not able to be tested in UAT due to the inability to replicate federal data file information in the UAT environment.
- For a high-level overview of the FISAP process, please review the QRG Producing the FISAP report
Minimum Test Case (Data) Scenarios:
CC.016.1.1 Process Census
- Users will be running the full Census Process. This is a "one-person" process.
CC.016.1.2 R2T4 Processing
- User will be running the full process. Discovering the student population (one person process) Creating the worksheet - this can be a couple of users depending on how many students are available. Colleges may test terms 2215 & 2217. Coordination is required with Records to withdraw students from classes and SF to calculate tuition after classes have been withdrawn.
CC.016.1.3 Adjust Aid & Undisburse
- Once the R2T4 worksheet is complete and the dollar amount for reduction or cancellation is identified. Users can reduce/cancel aid using the developed QRG.
CC.016.1.4 F05 Service Indicator Assignment
- This can be done by multiple persons. It is usually a student-by-student basis and the identified reason can be attached to the SI.
CC.016.1.5 Reconciliation Processing
- The fund roster is where users will begin. There are reconciliation queries near the end of the document we recommend they run as part of their testing. (One Person task but all can review)
CC.016.1.6 WCG Interim Processing
- Users will follow instructions from the attached document. (One person testing). They will not be sending results to WSAC. They want to ensure the process is running and review the results.
CC.016.1.7 Unit Record Reporting
- ***Attn: URR is not able to be tested in UAT due to the fact prior year data wouldn’t exist
CC.016.1.8 FISAP
- Attn: FISAP is not able to be tested in UAT due to the inability to replicate federal data file information in the UAT environment.
Return to the High Level (Tier 1) UAT Framework:
Links to User Acceptance Test 'How To' Information:
Security Matrix Mapping Information
The information below provides those completing the Security Matrix Mapping templates with the Menus, Pages and Role names needed to execute the User Acceptance Testing relevant to this UAT guide.
CC.016.1.1 Process Census:
MENU: NavBar > Navigator > Set Up SACR > Common Definitions > Equation Engine > Run Equation
ROLENAME: ZC FA Local Configuration
MENU: NavBar > Navigator > Financial Aid > Financial Aid Term > Build FA Term in Batch
ROLENAME: ZZ FA Term Prcs
MENU: NavBar > Navigator > Reporting Tools > Query > Query Viewer
ROLENAME: ZZ_DS_QRY_FINANCIAL_AID and ZZ_DS_QUERY_VIEWER
CC.016.1.2 R2T4 Processing:
MENU: NavBar > Navigator > Campus Community > Service Indicators > Person > Mass Assign
ROLENAME: ZZ CC Service Indicators
MENU: NavBar > Navigator > Reporting Tools > Query > Query Viewer
ROLENAME: ZZ_DS_QRY_FINANCIAL_AID and ZZ_DS_QUERY_VIEWER
MENU: NavBar > Navigator > Financial Aid > Return to Title Iv Funds > Create Worksheet
ROLENAME: ZZ FA R2T4 Prcs or ZZ FA Funds Manager
MENU: NavBar > Navigator > Financial Aid > CTC Custom > Return State Funds > Create Worksheet
ROLENAME: ZZ FA Return State Funds or ZZ FA Funds Manager
CC.016.1.3 Adjust Aid & Undisburse:
MENU: Nav Bar > Navigator > Financial Aid > Awards > Award Processing > Assign Awards to a Student
ROLENAME: ZZ FA Award Processor
MENU: Nav Bar > Navigator > Financial Aid > Disbursement > Disburse Aid
ROLENAME: ZZ FA Disbursements or ZZ FA Funds Manager
CC.016.1.4 F05 Service Indicator Assignment:
MENU: NavBar > Navigator > Campus Community > Service Indicators (Student) > Manage Service Indicators
ROLENAME: ZZ CC Service Indicate Student
MENU: NavBar > Navigator > Campus Community > Service Indicators (Student) > Mass Release
ROLENAME: ZZ CC Service Indicate Student
CC.016.1.5 Reconciliation Processing:
MENU: NavBar > Navigator > Financial Aid > Fund Management > Fund Roster
ROLENAME: ZZ FA Funds Manager
MENU: NavBar > Navigator > Reporting Tools > Query > Query Viewer
ROLENAME: ZZ_DS_QRY_FINANCIAL_AID and ZZ_DS_QUERY_VIEWER
MENU: NavBar > Navigator > Financial Aid > Fund Management > FA801 Award Data by Item Type
ROLENAME: ZZ FA Funds Manager
MENU: NavBar > Navigator > Set Up SACR > Product Related > Financail Aid > Awards > Fiscal Item Types
ROLENAME: ZC FA Local Configuration
CC.016.1.6 SNG Interim Processing:
MENU: NavBar > Navigator > Financial Aid > CTC Custom > CTC Reports > State FA Reporting
ROLENAME: ZZ FA WCG Eligibility
CC.016.1.7 Unit Record Reporting:
MENU: NavBar > Navigator > Financial Aid > CTC Custom > CTC Reports > State FA Reporting
ROLENAME: ZZ FA WCG Eligibility
CC.016.1.8 FISAP:
MENU: NavBar > Navigator > PeopleTools > CTC Custom > Extensions > Upload/Download Files
ROLENAME: ZZ_FA_UPLOAD_DOWNLOAD
MENU: NavBar > Navigator > Financial Aid > Awards > External Awards > Process External Award File
MENU: NavBar > Navigator > Financial Aid > Awards > External Awards > View Data File Staging Results
MENU: NavBar > Navigator > Financial Aid > Awards > External Awards > Load External Awards
MENU: NavBar > Navigator > Financial Aid > Awards > External Awards > External Award Load Summary
MENU: NavBar > Navigator > Financial Aid > Awards > External Awards > Manage Awards by Status
MENU: NavBar > Navigator > Financial Aid > Awards > External Awards > Manage Student External Awards
ROLENAME: ZZ FA External Awards or ZZ FA Award Processor
MENU: NavBar > Navigator > Financial Aid > Fund Management > Generate FISAP Reports
ROLENAME: ZZ FA FISAP Prcs
MENU: NavBar > Navigator > Reporting Tools > Query > Query Viewer
ROLENAME: ZZ_DS_QRY_FINANCIAL_AID and ZZ_DS_QUERY_VIEWER
Other roles that may be needed:
MENU: NavBar > Navigator > Campus Community > Student Services Ctr (Student)
ROLENAME: ZD CC Personal Info Student
MENU: NavBar > Navigator > Records and Enrollment >Enroll Students > Enroll
ROLENAME: ZD SR High Lev Enroll Inquiry
MENU: NavBar > Navigator > Reporting Tools > Query > Query Viewer
ROLENAME: ZD_DS_QRY_FA_SSN_HIGHSENS ***
***This role may be needed for users to view highly sensitive FA data when using Query Viewer
0 Comments
Add your comment