Deadline of
Reason for Recalculation Submission
Carry Forward (CF) for Hanford, Tulare and the District is understated.
Three CRNs were miscalculated only on the CF and only partially backed out of the total FTES filed. Specifically, I messed up on a flat file to Excel column creation anytime there were greater than 99 students (3-character length) enrolled at census.
Term 202230 (Summer 2022); CRNs 30620 (10 FTES more for Hanford CF), 31038 (10 FTES more for Tulare CF), and 30369 (10 FTES more for Tulare CF).
Term 202230, CRN 30524 (2.6 FTES more for Hanford CF) was found to not have been generated in the last Banner 320 report. It generated on a test rerun that I did today. This has CF implications.
Term 202230, CRNs 30498/30090 now have positive attendance data entered. This has no CF implications and was documented in the Annual Workspace Document.
Summary
Total Difference from Annual to Recal
Annual | Recal | Difference | |
---|---|---|---|
District | 8,955.10 | 8,977.76 | 22.66 |
Carry Forward Difference from Annual to Recal
Annual | Recal | Difference | |
---|---|---|---|
Hanford | 20.37 | 31.54 | 11.17 |
Tulare | 180.00 | 188.70 | 8.7 |
District (includes HAC,TCC) | 289.73 | 305.26 | 15.53 |
👟 Run 1
Baseline
- SVAAPIZ
- SVRCALX
- Sort through the list and resolve errors prior to the next step
Runtime ~5 minutes
- SVRCALD - Include Student Details
- SVRCALD - Do Not Include Student Details
Runtime ~1 minute
- SEND "*WARNING* Total CH is not equal to (Length Mult * Std CH)" To Vanessa Escobar it's about Attendance Method
No true warnings existed.
- SVRCALP
Runtime <1 minute
- SEND TO REGINA FOR FIXES - none returned
- SVRCALU
Runtime >3 minutes
- SVRCALS
Runtime >5 minutes
- SVRCAL9
Runtime >5 minutes
Regarding drops. Sometimes Argos doesn't show dropped students but Banner does. Work with Velia but usually Banner is king.
- Compare summary to previous Annual
Hard to compare given pandemic shifts.
Manual Entry/Edits
Documented in Backup Spreadsheet but tracked here.
- SVRCALU feeds "Supplemental"
ATTENDANCE FTES* OF STATE RESIDENTS(and Nonresidents Attending Noncredit courses)
- Part IV
For noncredit FTES (including CDCP noncredit) the attendance of both residents and nonresidents is reported in the Residents column of Part IV and in the CDCP section of the report. - Natalie Wagner
- Part IX
Pull from SVRCAL9
- CDCP section
SVRCALU populates this.
For noncredit FTES (including CDCP noncredit) the attendance of both residents and nonresidents is reported in the Residents column of Part IV and in the CDCP section of the report. - Natalie Wagner
- ADD CARRY FORWARD
Campus/District | Resident | Resident Ext Hours | Non Resident | Totals |
---|---|---|---|---|
CONTACT HOURS |
|
|
|
|
Hanford | 49,209.50 | n/a | 472.50 | 49,682.00 |
Tulare | 20,440.00 | 1,470.00 | 105.00 | 22,015.00 |
District (includes HAC,TCC) | 164,778.00 | 2,730.00 | 1,312.50 | 168,820.50 |
FTES |
|
|
|
|
Campus/District | Resident | Resident Ext Hours | Non Resident | Totals |
Hanford | 93.73 | n/a | 0.90 | 94.63 |
Tulare | 38.93 | 2.80 | 0.20 | 41.93 |
District (includes HAC,TCC) | 313.86 | 5.20 | 2.50 | 321.56 |
- REMOVE CARRY FORWARD
FTES Total | ||||
---|---|---|---|---|
Campus/District | Resident | Resident Ext Hours | Non-Resident | Totals |
Hanford | 17.90 | 13.20 | 0.45 | 31.54 |
Tulare | 187.04 | 1.67 | 188.70 | |
District (includes HAC,TCC) | 276.97 | 25.79 | 2.50 | 305.26 |
- CCFS-317 Explain Recal Reasoning
Add Comment