Reason for Recalculation Submission

1. Carry Forward (CF) for Hanford, Tulare and the District is understated.

   1. 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.

      1. 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).

   2. 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.

2. Term 202230, CRNs 30498/30090 now have positive attendance data entered. This has no CF implications and was documented in the Annual Workspace Document.

👟 Run 1

08 Jul 2022

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

Baseline

• SVAAPIZ

• SVRCALX
• Sort through the list and resolve errors prior to the next step

• SVRCALD

• 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

• SEND TO REGINA FOR FIXES - none returned

• SVRCALU

• SVRCALS

• SVRCAL9

• Compare summary to previous Annual

Hard to compare given pandemic shifts.

Manual Entry/Edits

• SVRCALU feeds "Supplemental"

ATTENDANCE FTES* OF STATE RESIDENTS(and Nonresidents Attending Noncredit courses)

• Part IX

• NON CREDIT, NON RESIDENT
• Part IV
• CDCP section

• ADD CARRY FORWARD

• REMOVE CARRY FORWARD