Runs

Preliminary: Dec 19, 2024

Run 1: Dec 20, 2024

Certified:

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

Setup

Evaluate Banner Setup for Known Defects

PD0016062 - CALB 320 SVRCALD Resident and Non Resident Contact Hours for Actual Part IV do not match to SVRCALS Contact Hours.

WORKAROUND: Use SVRCALS numbers for reporting to Chancellor's Office.

Becomes an issue if we need to do any deeper analysis.

PD0017242 - SVRCALU CCFS 320 Supplemental Report Centers Section needs additional sorting to facilitate entry into the Chancellor's Office Reporting Site.

P1 doesn’t need Center information, so we have dodged this.

PD0017246 - SVRCALU 320 Supplemental Report Centers Sections includes sections not in a Center when Disp entries with zero values is Y.

P1 doesn’t need Center information, so we have dodged this.

GUAABOT vs. Customer Center

Baseline Reports

Populate Academic Year

District: 561

Reporting Period:

P1 - 2 (Historically)

P2 - 1 (Historically)

BOTH the 320 report out of Banner AND the CO website use the annualizers to multiply the FTES portions of the report. They do this independently but follow the same logic for Positive/Actual Attendance.

The annualizers do not multiply against the Contact Hours which is what was throwing me for a loop.

Decide on an annualizer for each of these:

Weekly Census:
Daily Census:
Actual Noncredit:
Actual Credit:
Independent Study Weekly Census:
Independent Study Daily Census:
Independent Study Noncredit:
Noncredit Enhanced Funding:

Then process it all the same way and both systems do the Contact Hours to FTES calculations for you.

04 – Include Exceptions - "Y"

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.

202510 1 DANC 070 16700 0 COS W 07 12-AUG-2024 26-AUG-2024 13-DEC-2024 17.50 2.000 35.000 N Y Y N E
202510 1 PEAC 021 14264 01 COS W 07 12-AUG-2024 26-AUG-2024 13-DEC-2024 17.50 2.000 35.000 N Y Y N E
202510 1 PEAC 021 14824 03 COS W 07 12-AUG-2024 26-AUG-2024 13-DEC-2024 17.50 2.000 35.000 Y Y Y N E
202510 1 PEAC 052 16833 0 COS W 07 12-AUG-2024 26-AUG-2024 13-DEC-2024 17.50 2.000 35.000 N Y Y N E
202510 1 PEAC 064 17076 0 COS W 07 12-AUG-2024 26-AUG-2024 13-DEC-2024 17.50 2.000 35.000 N Y Y N E

202510 1 PEAC 070 16683 0 COS W 07 12-AUG-2024 26-AUG-2024 13-DEC-2024 17.50 2.000 35.000 N Y Y N E
202510 1 PEAC 074 14385 09 COS W 07 12-AUG-2024 26-AUG-2024 13-DEC-2024 17.50 2.000 35.000 N Y Y N E
202510 1 PEAC 075 17469 0 COS W 07 12-AUG-2024 26-AUG-2024 13-DEC-2024 17.50 2.000 35.000 N Y Y N E
202510 1 PEAC 075 17470 0 COS W 07 12-AUG-2024 26-AUG-2024 13-DEC-2024 17.50 2.000 35.000 N Y Y N E

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)

DISTRICT REPORTS

Manual Edits

Jira ticket to load the same into Banner after 320 deadline.https://sequoias.atlassian.net/browse/AP-986

Past example:

TERM	CRN	SUBJ_CODE	CRSE_NUMB	ACCT_CODE	RESIDENT Total Contact	Non Resident Total Contact	In 2023-24 Annual?
202420	25484	PS	200M1	P	20,644.75	1286.25	N

Functional

Workspace 2024-25, P1