Workspace 2023-24, P2
- Jordan Lamb
Setup
No known defects after our Banner update went to 8.19 for California Student.
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 | Unreported |
202330 | 31207 | ENGL | 002 | 22 | S3 | ID | 7/5/2023 | 7/31/2023 | 7/10/2023 | 2023 | 2024 | Unreported | Unreported |
202330 | 31195 | ART | 001 | 45 | S3 | ID | 7/5/2023 | 7/31/2023 | 7/10/2023 | 2023 | 2024 | Unreported | Unreported |
202330 | 31193 | ETHN | 001 | 43 | S3 | ID | 7/5/2023 | 7/31/2023 | 7/10/2023 | 2023 | 2024 | Unreported | Unreported |
202330 | 31182 | ETHN | 003 | 40 | S3 | ID | 7/5/2023 | 7/31/2023 | 7/10/2023 | 2023 | 2024 | Unreported | Unreported |
202330 | 31179 | ETHN | 003 | 28 | S3 | D | 7/5/2023 | 7/31/2023 | 7/10/2023 | 2023 | 2024 | Unreported | Unreported |
202330 | 31155 | ETHN | 001 | 41 | S3 | ID | 7/5/2023 | 7/31/2023 | 7/10/2023 | 2023 | 2024 | Unreported | Unreported |
202330 | 31154 | ETHN | 001 | 43 | S3 | ID | 7/5/2023 | 7/31/2023 | 7/10/2023 | 2023 | 2024 | Unreported | Unreported |
202330 | 31151 | ETHN | 003 | 39 | S3 | ID | 7/5/2023 | 7/31/2023 | 7/10/2023 | 2023 | 2024 | Unreported | Unreported |
202330 | 31147 | IA | 049AD | 79 | S3 | D | 7/5/2023 | 7/31/2023 | 7/10/2023 | 2023 | 2024 | Unreported | 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 | Reported |
Runs
Run 1: Mar 22, 2024
Run 2: Apr 4, 2024
https://sequoias.atlassian.net/browse/AP-517
Auditor Portal not open for 2023-24 as of Apr 10, 2024
Baseline Reports
Runtime ~5 minutes
No Warnings
(Hard to compare given pandemic shifts.)
Chancellor’s Office: CCFS-320 Reporting Portal
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.
COLLEGE REPORTS
ATTENDANCE FTES* OF STATE RESIDENTS(and Non-Residents Attending Noncredit courses)
DISTRICT REPORTS
Manual Edits
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) |
|
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 |