...
Preliminary:
Run 1:
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Certified:
Setup
- Evaluate Banner Setup for Known Defects
- GUAABOT vs. Customer Center
...
| Info |
|---|
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
...
COLLEGE REPORTS
- SVRCALU feeds "Supplemental"
ATTENDANCE FTES* OF STATE RESIDENTS(and Non-Residents Attending Noncredit courses)
- SVRCALS feeds Flex-Time Activities | F Factor
...
| Info |
|---|
Documented in Backup Spreadsheet but tracked here. |
- Look for crossover PS and make sure they are included.
...
TERM | CRN | SUBJ_CODE | CRSE_NUMB | ACCT_CODE | ENRL | PTRM_END_DATERESIDENT Total Contact | Non Resident Total Contact | In 22-23, 320 P2Annual? | |
202220202320 | 25484 | PS | 200M1 | P | 44 (43 Res) | 2022-07-20 | No, missing 35.285238095 FTES21,031.50 | 430.5 | N |
| Expand | |||||
|---|---|---|---|---|---|
| |||||
|
- ADD CARRY FORWARD from 2022 RECAL
Added to District Totals & Center Totals
...
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
| Expand | ||
|---|---|---|
| ||
|
- Remove CARRY FORWARD
- No Non-Resident TSCH are showing up for D/ID on Term 202330. Wrote query to find if true.
| Code Block | ||
|---|---|---|
| ||
--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; |
...
- SQL Update statement to change the Reporting Year
SSBSECT_ACYR_CODEthe trailing Summer. - Get list of CRNs from Dean of Enrollment Management
| Expand | ||
|---|---|---|
| ||
|