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

SVRCALP

(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

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

Functional

Workspace 2021-22, Annual

Run 1

Baseline

Manual Entry/Edits