Runs

Preliminary: Jul 7, 2023

Run 1: Jul 10, 2023

https://sequoias.atlassian.net/browse/AP-517

Certified: Jul 14, 2023

Baseline Reports

SVAAPIZ (Academic Year Annualizer) - Irrelevant for Annual

Populate Academic Year

District: Do it for 561

Reporting Period:

P1 - 2

P2 - 1

SVRCALX

Runtime ~5 minutes

04 – Include Exceptions - "Y"

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

Where SSTS code <> A it is safe to ignore. Where SSTS code = A, it might be nice to inform Scheduling Coordinator (or related schedulers) if they want to Cancel/Inactive/etc. or delete prior to term roll.

W/IW (Weekly/Independent Weekly) is only allowed for full, primary term sections.

Exception CRNs not reported: Actual CRN with no reportable student attendance hours.
202310 First Primary GEOL 151 17092 0 A COS P Geology of the Mojave Desert

Inputted after submission. Local reporting will show it but it was not counted on the Annual 320 submission for apportionment.

202310 First Primary IA 047AD 16813 0 A COS P Strategies of Sport
202310 First Primary IA 049AD 16815 0 A COS P Performance of Sport
202310 First Primary PTA 400 16232 0 A COS P PTA Skills Lab
202310 First Primary PTA 400 16233 0 A COS P PTA Skills Lab
202310 First Primary PTA 400 16234 0 A COS P PTA Skills Lab

Emailed instructors, cc’d deans in January. Reminded deans February.

New as of Annual file:

202320 Second Primary ENGL 002 28327 D08 A TUL P Logic and Composition

202320 Second Primary ESL 440 27062 0 A COS E Advanced Writing/Grammar 5
202320 Second Primary ESL 442 27066 0 A COS E Adv Listening/Speaking 5

@Kristin Robinson was informing Dean’s at an Academic Dean’s meeting. She additionally emailed them Jul 10, 2023.

https://sequoias.atlassian.net/browse/AP-512

SVRCALD (Student Details and Non)

SEND "*WARNING* Total CH is not equal to (Length Mult * Std CH)" to Vanessa Escobar/Jenae Prator it's about Attendance Method

SVRCALP

No Warnings

(Hard to compare given pandemic shifts.)

Chancellor’s Office: CCFS-320 Reporting Portal

Form 320 Login (cccco.edu)

COLLEGE REPORTS

ATTENDANCE FTES* OF STATE RESIDENTS(and Non-Residents Attending Noncredit courses)

1. PROD has all zeros (California Student 8.X Installation Information Release 8.15.2)

2. TEST has data w/ most up to date PROD clone (California Student 8.X Installation Information Release 8.17) (Cloned Apr 18, 2023)

Used this instance of Banner for this reporting.

3. DEVL has data w/ older PROD clone date (California Student 8.X Installation Information Release 8.16) (Cloned Mar 3, 2023) works.

DISTRICT REPORTS

Manual Edits

Ignored this cycle w/ blessing of Dean of Enrollment Mgmt.

TERM	CRN	SUBJ_CODE	CRSE_NUMB	ACCT_CODE	ENRL	PTRM_END_DATE	In 22-23, 320 P2?
202220	25484	PS	200M1	P	44 (43 Res)	2022-07-20	No, missing 35.285238095 FTES

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

By Accounting Method

Contact Hours - Daily
Campus/District	Resident	Resident Ext Hours	Non-Resident	Totals
Hanford	6,561.90		181.70	6,743.60
Tulare	5,409.60		52.90	5,462.50
District (includes HAC,TCC)	30,521.50	6,610.20	439.30	37,571.00

Contact Hours - Independent Daily
Campus/District	Resident	Resident Ext Hours	Non-Resident	Totals
Hanford	2,835.00	6,930.00	52.50	9,817.50
Tulare	92,785.00		822.50	93,607.50
District (includes HAC,TCC)	114,887.50	6,930.00	875.00	122,692.50

--NonResident TSCH are showing up for D/ID for a given term
SELECT          SSBSECT.SSBSECT_TERM_CODE
                ,SSBSECT.SSBSECT_CRN
                ,SSBSECT.SSBSECT_PTRM_END_DATE
                ,SSBSECT.SSBSECT_CAMP_CODE
                ,COUNT(SFRSTCR.SFRSTCR_PIDM)
FROM            COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_SFRSTCR AS SFRSTCR
LEFT JOIN       DEV_DB.JOSHUAME.FV_DEMO_GET_RESIDENCY RESIDENT
    ON SFRSTCR.SFRSTCR_PIDM = RESIDENT.PIDM
           AND SFRSTCR.SFRSTCR_TERM_CODE = RESIDENT.TERM_CODE
LEFT JOIN       COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_STVRESD AS STVRESD
    ON RESIDENT.SGBSTDN_RESD_CODE = STVRESD_CODE
INNER JOIN      COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_SSBSECT AS SSBSECT
    ON SFRSTCR_TERM_CODE = SSBSECT.SSBSECT_TERM_CODE
            AND SFRSTCR_CRN = SSBSECT_CRN
WHERE           SFRSTCR.SFRSTCR_TERM_CODE = :term_code
AND             SSBSECT_PTRM_END_DATE > CONCAT(:YYYYMMDD) --Follow this format 'YYYY-MM-DD' and include the ' '
AND             STVRESD.STVRESD_IN_STATE_IND <> 'I'
AND             SSBSECT.SSBSECT_ACCT_CODE IN ('D','ID')
AND             SSBSECT_CAMP_CODE <> 'COS'
AND             SFRSTCR.INVOKE_DATA_DATE = DATEADD(DAY, -1, CURRENT_DATE)
AND             STVRESD.INVOKE_DATA_DATE = DATEADD(DAY, -1, CURRENT_DATE)
AND             SSBSECT.INVOKE_DATA_DATE = DATEADD(DAY, -1, CURRENT_DATE)
GROUP BY        SSBSECT_TERM_CODE, SSBSECT_CRN, SSBSECT_CAMP_CODE,SSBSECT_PTRM_END_DATE;

Wasn’t true so I went looking for defects and found one:

Defect didn’t persist in SVRCALD w/ Student Details so that was used to find those allowable Carry Forward sections and TSCH amounts.

Functional

Workspace 2022-23, Annual