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
2. 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
Expand
title
SFAALST Positive Attendance, With Passing Grades, Without Hours Entered
Code Block
language
sql
SELECT SSBSECT_TERM_CODE
,SSBSECT_CRN
,SSBSECT_SUBJ_CODE
,SSBSECT_CRSE_NUMB
,SSBSECT_ACCT_CODE
,SFRSTCR_GRDE_CODE
,SSBSECT_PTRM_END_DATE
,F_GETSPRIDENID(SIRASGN_PIDM) AS "BANNER ID"
,F_FORMAT_NAME(SIRASGN_PIDM, 'FL')
FROM SSBSECT
LEFT JOIN SFRSTCR ON SSBSECT_TERM_CODE = SFRSTCR_TERM_CODE AND SSBSECT_CRN = SFRSTCR_CRN
LEFT JOIN SIRASGN ON SSBSECT_TERM_CODE = SIRASGN_TERM_CODE AND SSBSECT_CRN = SIRASGN_CRN
WHERE SSBSECT_SSTS_CODE = 'A'
--AND SSBSECT_TERM_CODE IN ('202130','202210','202220')
AND SSBSECT_ACCT_CODE IN ('P','E')
AND SFRSTCR_ATTEND_HR IS NULL
AND (SFRSTCR_GRDE_CODE IS NOT NULL AND SFRSTCR_GRDE_CODE NOT IN ('W','NP','I','NC','EW','F','NG'))
AND SIRASGN_PRIMARY_IND = 'Y'
ORDER BY SSBSECT_TERM_CODE DESC
...
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
Expand
title
Census Date or End Date is > 7/1
Info
Sorry for the delay on this. I’m inclined to say these Alternative Attendance Accounting Procedure-Daily Census courses also have the summer shift reporting option. Title 5 section 58010(a) states “Full-time equivalent student for courses using census procedure may be reported in either the fiscal year in which the census day procedure is completed or in which the course ends.” I know that this provision does not apply to positive attendance courses (those must be reported in the period in which the course ends), however, I do not see any reason that it would not apply to courses on the alternative attendance accounting procedure- daily census.
As is the case with regular daily census courses, you would want to make sure that appropriate records are maintained to show that FTES were claimed appropriately and not claimed in both fiscal years.