Setup

Evaluate Banner Setup for Known Defects

GUAABOT vs. Customer Center

No known defects after our Banner update went to 8.19 for California Student.

Run SSASECT Incorrect Reporting Year - Argos Web Viewer by Evisions (cos.edu) and resolve any errors for CRNs that aren’t represented correctly. Watch for double reporting.

TERM_CODE

CRN

SUBJECT

COURSE

CENSUS_ENROLLMENT

PART_OF_TERM

ACCOUNTING_METHOD

PART_OF_TERM_START_DATE

PART_OF_TERM_END_DATE

CENSUS_ENROLL_DATE

REPORTING_YEAR

CALCULATED REPORTING YEAR

22-23 Status

23-24 Status

202330

31212

HIST

017

61

S3

ID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

202330

31207

ENGL

002

22

S3

ID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

202330

31195

ART

001

45

S3

ID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

202330

31193

ETHN

001

43

S3

ID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

202330

31182

ETHN

003

40

S3

ID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

202330

31179

ETHN

003

28

S3

D

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

202330

31155

ETHN

001

41

S3

ID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

202330

31154

ETHN

001

43

S3

ID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

202330

31151

ETHN

003

39

S3

ID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

202330

31147

IA

049AD

79

S3

D

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

202330

31047

NURS

121

10

O

D

7/10/2023

10/8/2023

7/23/2023

2023

2024

Reported

Unreported

202330

31046

NURS

121

10

O

D

7/10/2023

10/8/2023

7/23/2023

2023

2024

Reported

Unreported

202330

30665

LIBR

101

38

O

ID

6/5/2023

7/9/2023

6/10/2023

2024

2023

Reported

Runs

Run 1: Mar 22, 2024

Run 2: Apr 4, 2024

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

Certified: Apr 10, 2024

Uploaded to Auditor Site (Suralink):

Auditor Portal not open for 2023-24 as of Apr 10, 2024

Baseline Reports

SVAAPIZ (Academic Year Annualizer) - Irrelevant for Annual

Populate Academic Year

District: Do it for 561

Reporting Period:

P1 - 2

P2 - 1

A (Annual) - Don’t do this page.

SVRCALX

Runtime ~5 minutes

Printer: DATABASE (case sensitive)

01 - Academic Year (same as SVAAPIZ)

02 - District ID: 561

04 – Include Exceptions: Y

File gets put into PROD_LOGS

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

Errors Resolved

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.

Send to Dean of Enrollment Management (Kristin Robinson) and Cc Scheduling Coordinator (Vanessa Escobar) in case faculty should have put in hours or in case the section should have a different status code.

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

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

Students w/ DR registration code do not have grades. Confirmed w/ Velia 1/6/2022.

SFAALST is a helpful screen.

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

SFAALST is a helpful screen.

Fall Tutorial (ESS) FTES was imported in time for this P2 cycle.

SVRCALD (Student Details and Non)

Parameter 04 (Include Student Details) - Y

Runtime ~1 minutes

Parameter 04 (Include Student Details) - N

Runtime ~6 minutes

I wonder why no Student Details takes longer?

Good to have for backup. Not necessary for subsequent Banner reports/extracts.

05 (Standard or Apprenticeship Rpt) - S

As of at least Mar 22, 2024 we do not have Apprenticeship courses.

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

Nursing Scheduler (Jenae Prator) assessed:

Scheduling Coordinator (Vanessa Escobar) assessed:

SVRCALP

Runtime <1 minutes

SEND TO REGINA FOR FIXES

Fixed by Regina

No Warnings

(PE, Concurrent)

04 – Exceptions Only - Y

05 – Page break – just formatting

SVRCALU

04 - Disp entries with zero values “N”

05 - Standard Rpt “S”

Runtime 7-10 minutes

SVRCALS

04 - Standard Rpt “S”

Runtime 7-10 minutes

SVRCAL9 (Resident Codes of A, B, D as of 2023)

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.)

Chancellor’s Office: CCFS-320 Reporting Portal

Form 320 Login (cccco.edu)

Source of Truth Decisions

SVRCALD for W, D, IW, ID attendance methods so that the Resident, NonResident split is fully accurate.
SVRCALS for P attendance method because the SVRCALD doesn’t cleanly detail that.

Likely marginal error on the Resident, NonResident split.

COLLEGE REPORTS

SVRCALU feeds "Supplemental"

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

SVRCALS feeds Flex-Time Activities | F Factor

SOACALD/SSAACRL/SSAEXCL Data Entry - Functional - Confluence (atlassian.net) relates to this calculation.

DISTRICT REPORTS

Part IX

Pull from SVRCAL9

NON CREDIT, NON-RESIDENT

Part IV (in college forms) (see SVRCALS to see values prior to combining)

CDCP section (page has a short timeout. save as you go)

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 (CO)

COCI drives the CDCP portion.

Manual Edits

Documented in Backup Spreadsheet but tracked here.

Look for cross term Positive Attendance Sections

Add them if applicable.

--Cross Term Positive Attendance Sections
SELECT DISTINCT
            SSBSECT_TERM_CODE
            ,SSBSECT.SSBSECT_CRN
            ,SSBSECT.SSBSECT_SUBJ_CODE
            ,SSBSECT.SSBSECT_CRSE_NUMB
            ,SSBSECT.SSBSECT_ACCT_CODE
            ,SSBSECT_ENRL
            ,TO_VARCHAR(SSBSECT_PTRM_END_DATE, 'YYYY-MM-DD') AS SSBSECT_PTRM_END_DATE
FROM        COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_SSBSECT AS SSBSECT
JOIN        COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_STVTERM ON SSBSECT_TERM_CODE = STVTERM_CODE
JOIN        COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_STVACCT ON SSBSECT_ACCT_CODE = STVACCT_CODE
WHERE       SSBSECT_PTRM_END_DATE > STVTERM_END_DATE
    AND     STVACCT_ACTUAL_IND = 'Y'
    AND     SSBSECT.INVOKE_DATA_DATE = DATEADD(DAY, -1, CURRENT_DATE)
    AND     SSBSECT_TERM_CODE = :term_code
ORDER BY    SSBSECT_TERM_CODE DESC
;

--Positive Attendance Sections where course ends in Fiscal Year (320 Reporting Cycle) different than STVTERM_END_DATE
SELECT DISTINCT
    SSBSECT.SSBSECT_TERM_CODE,
    SSBSECT.SSBSECT_CRN,
    SSBSECT.SSBSECT_SUBJ_CODE,
    SSBSECT.SSBSECT_CRSE_NUMB,
    SSBSECT.SSBSECT_ENRL,
    SSBSECT_PTRM_CODE,
    SSBSECT_ACCT_CODE,
    TO_VARCHAR(SSBSECT_PTRM_END_DATE, 'YYYY-MM-DD') AS SSBSECT_PTRM_END_DATE,
    STVTERM_ACYR_CODE
FROM COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_SSBSECT AS SSBSECT
JOIN COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_STVTERM
    ON SSBSECT_TERM_CODE = STVTERM_CODE
JOIN COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_STVACCT
    ON SSBSECT_ACCT_CODE = STVACCT_CODE
WHERE SSBSECT_PTRM_END_DATE > (
    SELECT (FTVFSYR_END_DATE)
    FROM COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_FIMSMGR_FTVFSYR
    WHERE FTVFSYR_FSYR_CODE = :fiscal_year
        AND INVOKE_DATA_DATE = DATEADD(DAY, -1, CURRENT_DATE)
)
    AND STVACCT_ACTUAL_IND = 'Y'
    AND SSBSECT.INVOKE_DATA_DATE = DATEADD(DAY, -1, CURRENT_DATE)
--    AND STVTERM_ACYR_CODE < CONCAT('20', :fiscal_year)+'1' --Removes future CRNs based off their future Academic Year
--    AND SSBSECT_TERM_CODE < CONCAT('20', :fiscal_year,'30') --Removes trailing summer that is included in future 320 cycles
--    AND SSBSECT_TERM_CODE = :term_code
ORDER BY SSBSECT_TERM_CODE DESC;
;

--Registration activity and contact hours w/ CA residency
SELECT          SFRSTCR.*
                ,RESIDENT.*
FROM            COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_SFRSTCR 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
WHERE           SFRSTCR.SFRSTCR_TERM_CODE = :term_code
AND             SFRSTCR.SFRSTCR_CRN = :CRN
AND             SFRSTCR.INVOKE_DATA_DATE = DATEADD(DAY, -1, CURRENT_DATE)
AND             STVRESD.STVRESD_IN_STATE_IND = 'I'
AND             STVRESD.INVOKE_DATA_DATE = DATEADD(DAY, -1, CURRENT_DATE);

--Sum of contact hours divided by 525 for FTES amount
SELECT          SUM(SFRSTCR.SFRSTCR_ATTEND_HR)/525
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
WHERE           SFRSTCR.SFRSTCR_TERM_CODE = :term_code
AND             SFRSTCR.SFRSTCR_CRN = :CRN
AND             SFRSTCR.INVOKE_DATA_DATE = DATEADD(DAY, -1, CURRENT_DATE)
AND             STVRESD.STVRESD_IN_STATE_IND = 'I'
AND             STVRESD.INVOKE_DATA_DATE = DATEADD(DAY, -1, CURRENT_DATE);

--D or ID ACCT_CODE for NC Sections
SELECT DISTINCT
            SSBSECT_TERM_CODE
            ,SSBSECT.SSBSECT_CRN
            ,SSBSECT.SSBSECT_SUBJ_CODE
            ,SSBSECT.SSBSECT_CRSE_NUMB
            ,SSBSECT.SSBSECT_ACCT_CODE
            ,SSBSECT_ENRL
FROM        COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_SSBSECT AS SSBSECT
WHERE       SSBSECT.INVOKE_DATA_DATE = DATEADD(DAY, -1, CURRENT_DATE)
    AND     SSBSECT_TERM_CODE = :term_code
    AND     SSBSECT_ACCT_CODE IN ('D','ID')
    AND     SSBSECT_CRSE_NUMB LIKE '4%'
ORDER BY    SSBSECT_TERM_CODE DESC

SSBSECT\_TERM\_CODE	SSBSECT\_CRN	SSBSECT\_SUBJ\_CODE	SSBSECT\_CRSE\_NUMB	SSBSECT\_ACCT\_CODE	SSBSECT\_ENRL	SSBSECT\_PTRM\_END\_DATE	Resident FTES	NonResident FTES	Notes

SSBSECT\_TERM\_CODE	SSBSECT\_CRN	SSBSECT\_SUBJ\_CODE	SSBSECT\_CRSE\_NUMB	SSBSECT\_ACCT\_CODE	SSBSECT\_ENRL	SSBSECT\_PTRM\_END\_DATE	Resident FTES	NonResident FTES	Notes
202320	25484	PS	200M1	P	51	2023-07-19	40.06 (21031.5 CH)	.82 (430.5 CH)

ADD CARRY FORWARD from 2023 Annual

Added to District Totals

P1 and P2 do not allow CENTER FTES adjustments.

By Accounting Method

Contact Hours - Daily
Campus/District	Resident	Resident Ext Hours	Non-Resident	Totals
Hanford	7,127.70			7,127.70
Tulare	7,208.20			7,208.20
District (includes HAC,TCC)	44,976.50	7,767.20		52,743.70

Contact Hours - Independent Daily
Campus/District	Resident	Resident Ext Hours	Non-Resident	Totals
Hanford	3,272.50	7,350.00		10,622.50
Tulare	106,942.50		175.00	107,117.50
District (includes HAC,TCC)	123,258.90	7,350.00	175.00	130,783.90

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

Remove CARRY FORWARD (Not relevant for P1, P2)

Functional

Workspace 2023-24, P2

Setup

Runs

Baseline Reports

Chancellor’s Office: CCFS-320 Reporting Portal

Source of Truth Decisions

COLLEGE REPORTS

DISTRICT REPORTS

Manual Edits

Related content