Tables and Security  

Mass Update Student CCI Data at School Level  

Mass Update Student CCI Data at District Level  

School Options  

How the Processing Queue Works  

Overview 

Navigate to Student Data > Grades > Mass Update Student CCI Data.

The Mass Update Student CCI Data page is available at the school or district level.  The page will allow for the Student CCI Summary Data to be calculated for an individual school or for multiple schools if run at the District level. The Mass Update Student CCI process will include calculating the student's High School Graduation Status, UC/CSU College Entrance Requirements and Student CCI Summary data when processed from the individual school.

The District school has the Mass Update Student CCI Data page available that will calculate the Student CCI Summary information for selected schools. The processes for updating High School Graduation status and UC/CSU College Entrance Requirements will need to be run at the school level either from the Mass Update Student CCI Data page or by using the Graduation/College Readiness Dashboard logged into a school.

Tables and Security  ↑

Mass Update Student CCI Data at School Level  ↑

When processed at the school level, the calculations will include updating the High School Graduation Requirements, College Entrance Requirements and CCI Student Summary data for the logged in school. 

When the Process College Career Preparedness button is selected, re-calculations will begin and a green alert message will appear indicating the process has begun.

• The page button will be disabled to prevent other users from running the process simultaneously. 
• When the page is refreshed or opened while the process is running, a yellow information box will display a message indicating that the process is currently running for your school.
  • This message will also display if the process is running at the district level. The Process College Career Preparedness button will remain disabled until the process completes.
• The High School Graduation Requirements will get updated during this process and a timestamp will display on the College Readiness Dashboard page.
• The College Entrance Requirements will get updated during this process and a timestamp will display on the College Readiness Dashboard page.
• Once the process completes, the user will receive a completion email and the page will display a green message with the date/time of when the CCI process was last started and last completed.

• If either the Graduation Status or College Entrance Requirements process is already running on the Graduation/College Readiness Dashboard, and a user navigates to the Mass Update Student CCI Data page, users will see this message and the button will be disabled.
• 
• In an edge case, where user1 has the Graduation/College Readiness Dashboard open at School A and user2 has the Mass Update Student CCI Data page at open at school A, and user1 selects the button first to start the calculation process, when user2 attempts to select the button, they will be prompted with a yellow message in the corner indicating that a process is running on the Graduation/College Readiness Dashboard and the button will disable.
• 
• If the Mass Update Student CCI Data process is initiated from a school and a user attempts to start the process on the Graduation/College Readiness Dashboard in the same school, a red message will display and the buttons will become disabled.

Mass Update Student CCI Data at District Level  ↑

When processed at the district level, a school selector is available to include Student CCI Data processing for multiple schools at once. A Show Selected button displays the selected school codes to be processed.

When the Process College Career Preparedness button is selected, recalculations will begin for the Student CCI Data Summary for each student in the selected schools.

• The button will be disabled to prevent other users from running the process simultaneously.
• All selected schools will be queued for recalculation as part of a long-running process.
• As each school is processed, its OPT record will be updated with a timestamp.

Each school is processed individually. While a school is being updated, the Process College Career Preparedness button on the Mass Update Student CCI Data page at the school level will be disabled until processing is complete.

• If the page is refreshed or reopened while the process is running, a yellow information banner will indicate that the process is currently in progress.
• Once complete, a confirmation email will be sent and the page will display a green message showing the date and time the process was last started and last completed.

If a school is already processing a school-initiated run when a district-level run is initiated, that school will be automatically skipped to prevent duplicate processing. All other selected schools will continue to process normally.

• The confirmation email will include a list of any school codes that were skipped.
• The school-level page will display the timestamp of the last completed run.
• Only the process originally initiated at the school level will be completed for skipped schools.

School Options  ↑

The School selector is available at the District level only.  To limit the school selection list to include schools with grades 9-12, School Groups can be customized to default the selected schools to process where CCI Student Summary Data is available.

• See School Groups for instructions on using this feature.
• Create a Group for any school that contains grades 9-12.
• Select this group to easily include the schools to be updated in the Mass Update Student CCI Summary feature.

How the Processing Queue Works  ↑

The system uses OPT records to manage this state, which results in the following behaviors: When a Mass Update Student CCI is run at the district level, each selected school is assigned an OPT record that places it in a processing queue. This record is what prevents the school from being run again at the school level until the district-level process finishes.

• When a school is queued via a district-level run, its OPT record is set to: OPT.NM = 'MassUpdateStudentCCIDataDistrict_CurrentlyProcessing', OPT.CD = 'InQueue' — the Run button at the school level will be greyed out.
• Once a school begins actively processing, the value updates to OPT.CD = 'InProgress' — if the same school is included in a district-level run, it will be skipped and only the original school-level process will complete.
• When processing completes, OPT.CD is cleared (set to an empty value) and the school-level Run button becomes active again.
• When a school is skipped during a district-level run, it will be listed in the completion email.

Clearing a Stuck Process

In rare cases, a process may not complete as expected — for example, due to a server interruption — leaving OPT records in an InQueue or InProgress state. This will cause the Run button to remain greyed out even though no process is actively running. The following OPT records can be used to diagnose and resolve a stuck process.

Clearing a stuck district-level process requires all three of the following OPT records to have an empty OPT.CD value for the affected school:

• OPT.NM = 'MassUpdateStudentCCIDataDistrict_CurrentlyProcessing'
• OPT.NM = 'HSG_UpdateAllStudents_CurrentlyProcessing'
• OPT.NM = 'CER_UpdateAllStudents_CurrentlyProcessing'

If any one of these still has OPT.CD = 'InProgress' or OPT.CD = 'InQueue', the school-level Run button will remain disabled. All three must be cleared before the process can be re-initiated.

Who Can Perform the Fix

Clearing a stuck OPT record requires direct access to the database or a privileged administrative interface. This action should only be performed by a system administrator or database administrator with appropriate permissions.

Calculate Graduation Status

When the Calculate Graduation Status button is triggered, refer to the following OPT record for the school where the process was initiated:

OPT.NM = 'HSG_UpdateAllStudents_CurrentlyProcessing',  SC = (school code),  CD = InProgress

• Process is running: When CD = InProgress exists, the process is active and a red status message will display on the page.
• Process has completed: When InProgress no longer exists, the HSG_UpdateAllStudentDate OPT value will be populated with a completion timestamp and a green completion message will display instead.
• Stuck process: If CD = InProgress remains but no process is running, clear the OPT.CD value to an empty string to re-enable the button.

Calculate College Entrance Requirements Status

When the Calculate College Entrance Requirements Status button is triggered, refer to the following OPT record for the school where the process was initiated:

OPT.NM = 'CER_UpdateAllStudents_CurrentlyProcessing',  SC = (school code),  CD = InProgress

• Process is running: When CD = InProgress exists, the process is active and a red status message will display on the page.
• Process has completed: When InProgress no longer exists, the CER_UpdateAllStudentDate OPT value will be populated with a completion timestamp and a green completion message will display instead.
• Stuck process: If CD = InProgress remains but no process is running, clear the OPT.CD value to an empty string to re-enable the button.

OPT Values Reference