Versions Compared

Version Old Version 14 New Version 15
Changes made by

Jordan Lamb

Jordan Lamb

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  •  Evaluate Banner Setup for Known Defects
    •  GUAABOT vs. Customer Center

...

...

SVRCALD CCFS-320 Detail Report and SVRCALS CCFS-320 Summary Reports Contact Hours totals do not match for the reporting period for all sections except ACTUAL, Part IV.

WORKAROUND: The Contact Hours value on SVRCALD are correct for Resident and Non-Resident and can be used for reporting.

PD0007703 - Resolved in 8.18

CALBSTU CCFS-320 Detail Report SVRCALD Part VII Contacts Hours Calc is incorrect and CCFS-320 Summary Reports SVRCALS Part VII Contact Hours and FTE Calculations are incorrect. The Total Contact Hours for Part VII of SVRCALD are not being calculated properly. The current Contact Hours value should be multiplied by 17.5 to obtain the correct Total CH for Part VII.

WORKAROUND: Multiply the Contact Hours by 17.5 for EDP No. 62 to 82 and enter this value for Contact Hours in the Chancellor's site.

...

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

Info

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

3119331207

ETHNENGL

001002

4322

S3

ID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

Unreported

202330

3118231195

ETHNART

003001

4045

S3

ID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

Unreported

202330

3117931193

ETHN

003001

2843

S3

DID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

Unreported

202330

3115531182

ETHN

001003

4140

S3

ID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

Unreported

202330

3115431179

ETHN

001003

4328

S3

IDD

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

Unreported

202330

3115131155

ETHN

003001

3941

S3

ID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

Unreported

202330

3114731154

IAETHN

049AD001

7943

S3

DID

7/5/2023

7/31/2023

7/10/2023

2023

2024

Unreported

Unreported

202330

3104731151

NURSETHN

121003

1039

OS3

DID

7/105/2023

107/831/2023

7/2310/2023

2023

2024

ReportedUnreported

Unreported

202330

3104631147

NURSIA

121049AD

1079

OS3

D

7/105/2023

107/831/2023

7/2310/2023

2023

2024

ReportedUnreported

Unreported

202330

3066531047

LIBRNURS

101121

3810

O

IDD

67/510/20237

10/98/2023

67/1023/2023

2024

2023

Reported2024

Reported

👟 Runs

Run 1:

Run 2:

Jira Legacy
serverSystem Jira
serverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4
keyAP-517

  •  Certified:
  •  Uploaded to Auditor Site (Suralink):

Auditor Portal not open for 2023-24 as of

Baseline Reports

  •  SVAAPIZ (Academic Year Annualizer) - Irrelevant for Annual
Expand
titleℹ️ How To

Populate Academic Year

District: Do it for 561

Reporting Period:

P1 - 2

P2 - 1

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

  •  SVRCALX
Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime ~5 minutes

Expand
titleℹ️ How To

Printer: DATABASE (case sensitive)

01 - Academic Year (same as SVAAPIZ)

02 - District ID: 561

04 – Include Exceptions: Y

Info

File gets put into PROD_LOGS

  •  Sort through the list and resolve errors prior to next step.
  •  Errors Resolved
Expand
titleException CRNs not valid: No Meetings.

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.

Expand
titleException CRNs not reported: Actual CRN with no reportable student attendance hours.

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.

Expand
titleException CRNs not valid: Weekly CRN in an Intersession Term.

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

Expand
titleException CRNs not valid: Census CRN with a null Last Date to Record Academic History, which is required for evaluating drops.
https://sequoias.atlassian.net/browse/AP-768
Expand
titleException students not reported: Students in Positive Attendance CRNs with reportable hours that are missing grades.

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

Info

SFAALST is a helpful screen.

https://sequoias.atlassian.net/browse/AP-513
Expand
titleException students not reported: Students in Positive Attendance CRNs with zero reportable hours.
Info

SFAALST is a helpful screen.

Tip

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

  •  SVRCALD (Student Details and Non)
Expand
titleℹ️ How To

Parameter 04 (Include Student Details) - Y

Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime ~1 minutes

Parameter 04 (Include Student Details) - N

Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime ~6 minutes

I wonder why no Student Details takes longer? (blue star)

Info

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

05 (Standard or Apprenticeship Rpt) - S

Info

As of at least 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

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:

Run 2:

Jira Legacy
serverSystem Jira
serverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4
keyAP-517

  •  Certified:
  •  Uploaded to Auditor Site (Suralink):

Auditor Portal not open for 2023-24 as of

Baseline Reports

  •  SVAAPIZ (Academic Year Annualizer) - Irrelevant for Annual
Expand
titleℹ️ How To

Populate Academic Year

District: Do it for 561

Reporting Period:

P1 - 2

P2 - 1

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

  •  SVRCALX
Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime ~5 minutes

Expand
titleℹ️ How To

Printer: DATABASE (case sensitive)

01 - Academic Year (same as SVAAPIZ)

02 - District ID: 561

04 – Include Exceptions: Y

Info

File gets put into PROD_LOGS

  •  Sort through the list and resolve errors prior to next step.
  •  Errors Resolved
Expand
titleException CRNs not valid: No Meetings.

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.

Expand
titleException CRNs not reported: Actual CRN with no reportable student attendance hours.

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.

Expand
titleException CRNs not valid: Weekly CRN in an Intersession Term.

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

Expand
titleException CRNs not valid: Census CRN with a null Last Date to Record Academic History, which is required for evaluating drops.
https://sequoias.atlassian.net/browse/AP-768
Expand
titleException students not reported: Students in Positive Attendance CRNs with reportable hours that are missing grades.

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

Info

SFAALST is a helpful screen.

https://sequoias.atlassian.net/browse/AP-513
Expand
titleException students not reported: Students in Positive Attendance CRNs with zero reportable hours.
Info

SFAALST is a helpful screen.

Tip

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

  •  SVRCALD (Student Details and Non)
Expand
titleℹ️ How To

Parameter 04 (Include Student Details) - Y

Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime

<1 minutes
  •  SEND TO REGINA FOR FIXES
  •  Fixed by Regina

No Warnings

Expand
titleℹ️ How To

(PE, Concurrent)

04 – Exceptions Only - Y

05 – Page break – just formatting

  •  SVRCALU
Expand
titleℹ️ How To

04 - Disp entries with zero values “N”

05 - Standard Rpt “S”

~1 minutes

Parameter 04 (Include Student Details) - N

Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime

7-10 minutes
  •  SVRCALS
Expand
titleℹ️ How To
04 - Standard Rpt “S”

~6 minutes

I wonder why no Student Details takes longer? (blue star)

Info

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

05 (Standard or Apprenticeship Rpt) - S

Info

As of at least 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
Don’t use this cycle! Use SVRCALD Instead: PD0009231
Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime 7-10 <1 minutes

Note
  •  SEND TO REGINA FOR FIXES
  •  Fixed by Regina

No Warnings

ISSUE: SVRCALD CCFS-320 Detail Report and SVRCALS CCFS-320 Summary Reports Contact Hours totals do not match for the reporting period for all sections except ACTUAL, Part IV.

REPLICATION STEPS: 1. Create sections on SSASECT with appropriate Reporting Year and Attendance Method. 2. Populate dates on SSAACCL. 3. Register students in course prior to Census Date. 4. Run SVRCALX, SVRCALD and SVRCALS with the appropriate Academic Year, District ID and Reporting Period.

EXPECTED RESULT: The Contact Hours calculated for SVRCALD and SVRCALS should match for Resident and Non-Resident.

ACTUAL RESULT: The Contact Hours calculated for SVRCALD and SVRCALS do not match for Resident and Non-Resident. The Contact Hours balance in total, but are not the same for the Resident and Non-Resident columns between the reports.

SCREENSHOT: Defect PD0009231 Steps to Replicate SVRCALD SVRCALS CH totals do not match.docx

WORKAROUND: The Contact Hours value on SVRCALD are correct for Resident and Non-Resident and can be used for reporting.
Expand
titlePD0009231
ℹ️ How To

(PE, Concurrent)

04 – Exceptions Only - Y

05 – Page break – just formatting

  •  SVRCALU
Expand
titleℹ️ How To

04 - Disp entries with zero values “N”

05 - Standard Rpt “S”

Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime 7-10 minutes

  •  SVRCALS
Expand
titleℹ️ How To

04 - Standard Rpt “S”

Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime 7-10 minutes

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

...