Workspace 2021-2022 Recal

Owned by Jordan Lamb
Last updated: Oct 21, 2022
3 min read

Deadline of Nov 1, 2022

key summary type created updated due assignee reporter priority status resolution
Refresh

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.

Summary

  1. Total Difference from Annual to Recal

 

Annual

Recal

Difference

 

Annual

Recal

Difference

 District

8,955.10

8,977.76

22.66

2. Carry Forward Difference from Annual to Recal

 

Annual

Recal

Difference

 

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

Jul 8, 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

Populate Academic Year

District: Do it for 561, 562, 563

Reporting Period:

P1 - 2

P2 - 1

Not needed for Annual or Recal

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

Runtime ~5 minutes

04 – Include Exceptions - "Y"

SVRCALD - Include Student Details
SVRCALD - Do Not Include Student Details
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

(PE, Concurrent)

04 – Exceptions Only - "Y"

05 – Page break – just formatting

AB 540 Resident Code(s): A, B, D

Hard to compare given pandemic shifts.

Manual Entry/Edits

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

Campus/District

Resident

Resident Ext Hours

Non Resident

Totals

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

 

FTES Total

 

 

 

 

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