Workspace 2021-22, Annual

By Jordan Lamb
3 min

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

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

Runtime ~5 minutes

04 – Include Exceptions - "Y"

SVRCALD

Runtime ~1 minute

SEND "*WARNING* Total CH is not equal to (Length Mult * Std CH)" To Vanessa Escobar it's about Attendance Method
11 sections. Emailed Scheduling Coordinator 6 sections that I viewed as incorrect. -Jul 5, 2022
Scheduling Coordinator fixed 4 sections. Leaving BIOL 040 stacked CRNs 30498/30090 up to VP Academic Services. That CRN, as is, accounts for 8.86 Resident FTES (4650.8 Contact Hours/525) and .2 NonResident FTES (105.7/525) - Jul 8, 2022
Academic Services has decided to change that CRN to Positive Attendance. Recommend submit RECAL when/if hours are submitted into Banner. - Jul 15, 2022
SVRCALP

Runtime <1 minute

SEND TO REGINA FOR FIXES - none returned

(PE, Concurrent)

04 – Exceptions Only - "Y"

05 – Page break – just formatting

SVRCALU

Runtime >3 minutes

SVRCALS

Runtime >5 minutes

SVRCAL9

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

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 IX

Pull from SVRCAL9

NON CREDIT, NON RESIDENT
Part IV
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

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

 Contact Hours - Daily 

 

 

 Campus/District 

 Resident 

 Resident Ext Hours 

 Non Resident 

 Totals 

 Hanford 

                        5,368.20

  •  

                      181.70

         5,549.90

 Tulare 

                        5,409.60

  •  

                        52.90

         5,462.50

 District (includes HAC,TCC) 

                      29,479.60

                             6,716.00

                      515.20

       36,710.80

 Contact Hours - Independent Daily 

 

 

 Campus/District 

 Resident 

 Resident Ext Hours 

 Non Resident 

 Totals 

 Hanford 

                        2,835.00

                             1,837.50

                        52.50

         4,725.00

 Tulare 

                      88,077.50

  •  

                      962.50

       89,040.00

 District (includes HAC,TCC) 

                   112,035.00

                             1,837.50

                   1,102.50

     114,975.00

FTES Total

 

 

 

 

FTES Total

 

 

 

 

 Campus/District 

 Resident 

 Resident Ext Hours 

 Non Resident 

 Totals 

 Hanford 

           15.63

                                  3.50

                        0.45

        19.57

 Tulare 

           178.07

 

                        1.93

      180.00

 District (includes HAC,TCC) 

           269.55

                                16.29

                        3.08

      288.93

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.

-Natalie Wagner 7/15/2021

 

Related content