...

Certified: 14 Jul 2023

Baseline Reports

•  SVAAPIZ (Academic Year Annualizer) - Irrelevant for Annual

...

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

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

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

...

•  SEND "*WARNING* Total CH is not equal to (Length Mult * Std CH)" to Vanessa Escobar/Jenae Prator it's about Attendance Method
•  Jenae assessed 07 Jul 2023.
•  Jordan Lamb to ask Dean of Enrollment Management about Accounting Method for TBA/Clinical CRNs
•  Vanessa assessed 10 Jul 2023.
•  SVRCALP

...

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

•  SVRCALS feeds Flex-Time Activities | F Factor has all 0’s in both PROD and TEST

DISTRICT REPORTS

•  Part IX

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

Manual Edits

•  Add IA 202310 - 16813, 16815 if @Vanessa Escobar agrees that they should have been “D” - Daily Accounting Method.

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

•  Add PS 200M1

...

TERM

...

CRN

...

SUBJ_CODE

...

CRSE_NUMB

...

ACCT_CODE

...

ENRL

...

PTRM_END_DATE

...

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 18 Apr 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 03 Mar 2023) works.

DISTRICT REPORTS

•  Part IX

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

Manual Edits

•  Add IA 202310 - 16813, 16815 if @Vanessa Escobar agrees that they should have been “D” - Daily Accounting Method.

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

•  Add PS 200M1

...

•  Remove CARRY FORWARD
•  No NonResident TSCH are showing up for D/ID on Term 202330. Write query to find if true.

•  Remove CARRY FORWARD
•  No Non-Resident TSCH are showing up for D/ID on Term 202330. Wrote query to find if true.

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