Certification Status¶

The Certification Status page displays when an authorized user selects the Certification Status link in navigation. This page lists all defined CALPADS Submissions in submission order. Submission names are shown as hyperlinks, and total error counts (fatals and warnings) display as links when the count is not zero. Users may select a Submission link to view its details or select the Errors count link to review system-identified validation errors.

The Certification Status reflects whether a submission is CERTIFIED or UNCERTIFIED. Each Submission has up to four possible Revisions of data available for review or approval. A Submission Status is CERTIFIED when ONE of those revisions is approved by all required levels.

SELPA Approval Requirements

All submissions require revision approval by the LEA.
Fall 1 and EOY 1 submissions additionally require approval by all SELPAs associated with the LEA.

The Certification interface provides the following features:

View a complete list of Submissions with Certification status, latest reviewer and review date, record count, error count, and (for Fall 1 only) anomaly percent.
Filterable list of Submissions.
View Certification details of a specific Submission.
View the Certification errors of a Submission.
Ability to Approve Submissions.
Ability to Enable/Disable/Override Submissions (State Level Only).

Certification Process Overview¶

The diagram below represents the main components in the Revision process and the surrounding steps that result in Certification.

flowchart LR
    A["LEA Submits<br>Data"] --> B["CALPADS<br>ODS"]
    B --> C["Data<br>Extractor"]
    C --> D["Create<br>Revision"]
    D --> E["Generate<br>Reports"]
    D --> F["Run<br>CVR"]
    E --> G["LEA Reviews<br>Reports & Errors"]
    F --> G
    G --> H{"Fatal<br>Errors?"}
    H -- Yes --> I["Update Data<br>in ODS"]
    I --> B
    H -- No --> J["Review Aggregate<br>Reports"]
    J --> K{"Data<br>Accurate?"}
    K -- No --> I
    K -- Yes --> L["Approve<br>Revision"]
    L --> M{"SELPA<br>Approval<br>Required?"}
    M -- No --> N["Submission<br>Certified"]
    M -- Yes --> O["SELPA<br>Reviews"]
    O --> P{"All SELPAs<br>Approve?"}
    P -- No --> Q["Remain<br>Uncertified"]
    Q --> O
    P -- Yes --> N
    N --> R["Frozen for<br>State Reporting"]

LEAs continually submit data to CALPADS ODS.
The Data Extractor extracts and flags data from the CALPADS ODS into the CALPADS Reporting Database at a prescribed, configurable interval throughout the day, and also runs nightly for processes requiring substantial processing resources.
Reports are generated and provided to LEAs for review. Warnings and fatal certification errors are identified. Fatal errors must be resolved before an LEA can certify their revision.
LEAs must review aggregate reports and supporting data to determine data accuracy. LEAs may update ODS data if needed and repeat steps 1–4. Revised data will be incorporated into a newer version known as a Revision.
LEAs are expected to certify the data is accurate, and if necessary, decertify data that has already been certified to allow for updates, as long as the Data Collection Window remains open for that specific submission.

CALPADS Data Extractor¶

The CALPADS Data Extractor extracts and flags data from the CALPADS ODS into the CALPADS Reporting Database.

Data Extractor Trigger

The Data Extractor is triggered for an LEA throughout the day when all files for that LEA have posted and 15 minutes have passed with no additional file upload or post activity.

The Data Extractor is also triggered by nightly processes (Anomalies, Online or Batch files posted, ODS Reporting, Foster, ESI Changes, Direct Certification, Assessment Suspense Resolution) that represent changes to the ODS, which also trigger the Data Extractor to create new Revisions for affected LEAs.

The new version of data extracted for an LEA is referred to as a Revision. A snapshot identifies the data stored within CALPADS for a specific submission certification cycle; a revision is a version of that data within the snapshot with a specific date and timestamp within that certification cycle.

Revision Characteristics¶

Revisions capture information for an open collection window (Fall 1, Fall 2, etc.). Revisions are no longer generated when the amendment window ends for a submission.
Revisions represent data for a specific date and time available for an LEA within an Academic Year.
Revisions are generated continuously based upon changes within the ODS database within the defined Snapshot Collection window.
Certification reports are created based upon information available within a revision.
The data within revisions meets specific criteria (LEA, Academic Year, etc.).

Report Generation and CVR Process¶

Once the Data Extractor creates a new Revision, two components run concurrently: the Report Generator and the CVR Processor. Both run in the background and listen for a new Revision every 10 minutes. Both processes must complete against a Revision before it is made available for LEA review.

Report Generator steps:

Begins when a new revision is created from the Data Extractor.
Looks for specific types of data for a submission at the School and LEA levels. Expected Schools and Excluded Schools business logic are applied during this process.
New aggregate reports are generated for each unique revision stored within the CALPADS Reporting database.

CVR Processor steps (runs concurrently with Report Generation):

Also begins with a new revision created from the Data Extractor.
CVR validation procedures identified for the particular submission are applied to the data in the current revision. CVR validations (Fatals & Warnings) are logged and stored within the CALPADS Reporting database.
Once CVR Processing is completed, the new revision is given an initial Revision Status of "Revised Uncertified" and stored within the CALPADS Reporting database with a specific date/time stamp. The Revision is now available for review and certification.

LEA–SELPA Relationships

Due to possible many-to-many relationships between LEAs and SELPAs:

One LEA may need more than one SELPA to approve a revision to be considered CERTIFIED.
One SELPA may need to approve more than one LEA.
A SELPA may only approve an LEA's revision that has first been approved by the LEA.
Certification Reports are only aggregated at the LEA level, not the school level.
ESI Relationships between the SELPA and the LEA drive the list of associated SELPAs or LEAs and the SELPA/LEA dropdown filter on a Report.
The actual SELPA Code submitted at the student-level record is used to filter data for the logged-in SELPA user.

Revision Status vs. Submission Status vs. SELPA Approval Status¶

Term	Definition
Submission Status	Overall status of CERTIFIED or UNCERTIFIED based on ONE of the associated Revisions.
Revision Status	Workflow status of the LEA's revision, including the sum of all SELPA approvals.
SELPA Approval Status	Workflow status of the individual SELPA per Submission > LEA > Revision.

A Submission (e.g., Fall 1) can have multiple associated Revisions.

Certification Processes by Submission Type¶

There are two certification processes depending on the submission type.

Fall 1 and EOY 1 (SELPA Approval Required)Fall 2 and EOY 2 (SELPA Approval NOT Required)

This is a brief illustration of the certification process that LEAs and SELPAs will follow for Fall 1 and EOY 1 submissions.

%%{init: {
  "theme": "base",
  "themeVariables": { "fontSize": "12px" },
  "flowchart": { "curve": "linear", "htmlLabels": true }
}}%%
flowchart TD
    Start((Start))
    A["Data Collection<br>Certifier logs into<br>CALPADS"]
    B["Review<br>Certification<br>Reports"]
    M["LEA & SpEd Staff<br>collaboration to determine<br>accuracy of reports"]
    C["All Submission Certification<br>Reports Reviewed"]
    D{"Reports<br>correct?"}
    E["LEA Approval:<br>'Data Collection Approver'<br>clicks Approve"]
    F["CALPADS posts notification<br>to SELPA of LEA-level approval"]
    G{"SELPA<br>Approves or<br>Rejects?"}
    H["SELPA Approval<br>SELPA clicks Certification Button"]
    I(["Submission Certified"])
    J["Mark Submission<br>As Rejected"]
    K["CALPADS posts notification<br>to SELPA and LEA<br>of Rejection"]
    L["Submission<br>Process"]
    Start --> A --> B --> C --> D
    B -.-> M
    D -- No --> L
    D -- Yes --> E --> F --> G
    G -- Approves --> H --> I
    G -- Rejects --> J --> K --> L
    classDef decision fill:#dfe8f5,stroke:#5b7bb2,color:#000
    classDef process fill:#ffffff,stroke:#d97b2b,color:#000
    classDef notify fill:#e7f1dd,stroke:#6a9f3a,color:#000
    classDef terminal fill:#d9ead3,stroke:#6a9f3a,color:#000
    classDef submission fill:#a4b7d9,stroke:#5b7bb2,color:#000
    class D,G decision
    class A,B,C,E,H,J,M process
    class F,K notify
    class Start,I terminal
    class L submission

Certification Status, Revision Status, and SELPA Approval Status¶

Actions	Revision Status changes to	Certification Status changes to	Send Email?
Revision is first created	Revised Uncertified	Uncertified
LEA Manually checks In Review checkbox	In Review Uncertified	Uncertified
LEA Reviews all required Certification Reports	Revised Uncertified or In Review Uncertified	Uncertified
LEA Approves Revision	LEA Approved	Uncertified	Send email
LEA Disapproves Revision	LEA Disapproved	Uncertified	Send email
Any one SELPA Approves Revision, but not all yet	LEA Approved	Uncertified	Send email
All associated SELPAs Approve Revision	SELPA Approved	Certified	Send email
Any one SELPA Disapproves Revision	SELPA Disapproved	Uncertified	Send email

Multiple SELPAs

If there are MULTIPLE ASSOCIATED SELPAs, ALL must approve the revision before the Revision Status and Submission Status change. It only takes ONE SELPA or the LEA to Disapprove a Revision to affect the Submission Status.

Example: If LAUSD has 5 SELPAs, every SELPA must approve LAUSD's "LEA Approved" revision before the Revision Status is set to SELPA Approved.

Fall 2 and EOY 2 submissions do not involve SELPA approval. SELPA users will not see these submissions in their filter options.

%%{init: {
  "theme": "base",
  "themeVariables": { "fontSize": "12px" },
  "flowchart": { "curve": "linear", "htmlLabels": true }
}}%%
flowchart TD
    A((Start))
    B["Data Collection<br>Certifier role<br>logs into CALPADS"]
    C{"Certification<br>Errors?"}
    D["Review<br>Certification<br>Reports"]
    E["All Submission Certification<br>Reports Reviewed"]
    F{"Reports<br>correct?"}
    G["LEA Approval:<br>'Data Collection Approver'<br>clicks Approve button"]
    H(["Submission<br>Certified"])
    I["Submission<br>Process"]
    A --> B --> C
    C -- No --> D --> E --> F
    C -- Yes --> I
    F -- Yes --> G --> H
    F -- No --> I
    I -.-> A
    classDef decision fill:#e6e6e6,stroke:#666,color:#000
    classDef process fill:#f6c992,stroke:#666,color:#000
    classDef submission fill:#cfe2f3,stroke:#666,color:#000
    classDef certified fill:#c4df87,stroke:#666,color:#000
    class C,F decision
    class B,D,E,G process
    class I submission
    class H certified

Certification Status and Revision Status¶

Actions	Revision Status changes to	Certification Status changes to	Send Email?
Revision is first created	Revised Uncertified	Uncertified
LEA Manually checks In Review checkbox	In Review Uncertified	Uncertified
LEA Reviews all required Certification Reports	Revised Uncertified or In Review Uncertified	Uncertified
LEA Approves Revision	LEA Approved	Certified	Send email
LEA Disapproves Revision	LEA Disapproved	Uncertified	Send email

Note

A Revision starts with LEA Revision Status as Revised Uncertified and remains that way until the LEA either manually marks the In Review checkbox OR approves the revision.

Submission Availability by Academic Year

For academic years prior to 2025–2026, EOY submissions 1 through 4 (the legacy structure) remain available for historical purposes. Beginning with AY 2025–2026, EOY 1 and EOY 2 replace the previous four EOY submissions.

How to Decertify¶

Below is the recommended workflow for users needing to decertify in order to update their certified reports.

%%{init: {
  "theme": "base",
  "themeVariables": { "fontSize": "13px" },
  "flowchart": { "curve": "linear", "htmlLabels": true }
}}%%
flowchart LR
    A{"LEA or SELPA<br>need to<br>Decertify"}
    B["Click Disapprove"]
    C["CALPADS posts notification<br>to SELPA and LEA<br>of decertification"]
    D["Submission<br>Process"]
    A --> B --> C --> D
    classDef decision fill:#dfe8f5,stroke:#5b7bb2,color:#000
    classDef process fill:#ffffff,stroke:#d97b2b,color:#000
    classDef notify fill:#e7f1dd,stroke:#6a9f3a,color:#000
    classDef submission fill:#a4b7d9,stroke:#5b7bb2,color:#000
    class A decision
    class B process
    class C notify
    class D submission

Step 1. When LEAs need to amend their certified reports, it is highly recommended that they do not click the Disapprove button before making corrections in the ODS. LEAs should take advantage of new revisions.

Step 2. Once the LEA approves a revision, all reports and statuses associated with that revision will be frozen. However, newer revisions will continue to be available to the LEA in parallel to the frozen LEA Approved version whenever changes in the ODS are made.

Step 3. The LEA should first make the corrections in the ODS and wait for a new Revised Uncertified version. By default, the system will show the Certified version. Switch the Revision Status dropdown to Revised Uncertified to reveal that version.

Step 4. If there are no fatal errors (or if fatal errors are corrected and a new revision is generated), the LEA proceeds to review the aggregate reports.

Step 5. If the aggregate reports from the Revised Uncertified version are all reviewed and considered accurate, the LEA must switch the Revision Status back to the LEA Approved version and click the Disapprove button.

Step 6. Once the Disapprove button is clicked, switch the Revision Status to Revised Uncertified — the LEA Approval button should now be clickable.

Step 7. Once the LEA Approve button is clicked, Revision Status is updated to LEA Approved. For Fall 1 and EOY 1 submissions, LEAs are required to seek SELPA Approval before the certification is finalized.

How to Set In Review Status¶

LEAs have the ability to freeze a snapshot version of the data without certifying. This is useful when:

Users are waiting for other departments to review and sign off on the reports relevant to their department (e.g., CTE, Special Ed, Discipline).
Users have accurate reports but are not ready to certify yet and want to avoid problems caused by future CALPADS defects.

By clicking the In Review checkbox, LEAs can preserve this snapshot version.

Tip

Only one revision can be set to "In Review Uncertified" at a time. If you select a different revision to mark as In Review, the system will prompt you to confirm that the previous In Review revision will no longer be preserved.

Certification Status – LEA Approval¶

Required User Roles¶

Users need to have an LEA level org type and the following roles to access this section of CALPADS.

Data Collection Certifier (only required to certify)
EOY1 Reports
EOY2 Reports
Fall1 Reports
Fall2 Reports

Screen Label	Validation / Business Rule
Reporting LEA	Only orgs associated with the user's account are available. Only State-level users may change the value.
Academic Year	Reverse chronological order starting with the current academic year. Since EOY submissions span two AYs, defaults to the active EOY AY (e.g., 2024–2025 if submission ends after July 1, 2025).
Submission	Lists all Submission Periods for the academic year. Leaving it blank reveals all available submissions as of the filter date. Note: Prior to AY 2025–2026, EOY 1–4 are available for historical purposes.
Search Button	Executes search based on selected filter options.

Certification Status Results¶

Screen Label	Validation / Business Rule
Submission	Hyperlink to the Certification Summary & Details page. A submission is not created or made available when every school in an LEA is assigned an "N" data type in the Expected School table.
Reporting LEA	Only orgs associated with the user's account are available.
Submission Code	4-letter code for the submission. Ordered by descending Submission sequence within the Academic Year (e.g., Fall 1 before Fall 2 before EOY 1).
Revision Status	Highest-level revision based on Revision Availability business rules.
Create Date	Creation date of the revision.
Certification Status	Certification status of the overall submission. See Appendix A for complete rubric.
Last Reviewer	Email of the user who last reviewed the revision.
Last Review Date/Time	Last review date and time of the revision.
Total Errors / Warnings	Total number of errors and warnings for the revision. Displays as a hyperlink when count is not zero.
Fatal Errors	Count of fatal errors for the revision.
Warnings	Count of warnings for the revision.
Anomalies Percent	Percentage of anomalies for the revision. Column displays for any submission but only populates for Fall 1. Formula: `(MID Anomalies / MID Enrollment) × 0.5 + (CCE Anomalies / CCE Enrollment) × 0.5`. Does not include DD Anomalies.
Enable/Disable Submission	Toggles between Enable and Disable. Visible to authorized State users only. Active only during the Amendment Window Start/End Dates.

Anomaly Percent Refresh

The Anomaly Percent is calculated overnight and does not update in real time. The percentage will change for all revision statuses after the nightly process completes.

Certification Details – LEA¶

When a user selects the Submission or Total Errors/Warnings hyperlink on the Certification Status page, the system displays the Certification Details page. This page has multiple sections:

Revision Summary
Error Filters & Filtered Results
Required SELPA Approvals (Fall 1 and EOY 1 only)
Certification Reports
Approval Functionality
Revision History

Revision Summary¶

The Revision Summary reflects relevant information pertinent to the most recent snapshot or revision status selected. The Revision Status dropdown enables the user to select a specific version based on the available snapshot revisions.

Element	Description
(A) Revision Status	Allows the user to toggle between available Revisions. An LEA can have a maximum of 4 different revision statuses at one time (e.g., Revised Uncertified, In Review Uncertified, LEA Approved, and/or SELPA Approved).
(B) In Review Checkbox	Checking this box allows the LEA to keep the current certification revision frozen. Additional changes to CALPADS will not alter the reports under this version. Only one revision may be set to In Review at a time.
(C) View Certification Error Report	Clicking this link generates the Certification Error Report for the selected submission. Also links to the Certification Error Extract request screen.

Required SELPA Approvals¶

Visible for Fall 1 and EOY 1 only

For Fall 1 and EOY 1 submissions, this read-only table shows each SELPA required to approve the submission and each SELPA's individual current approval status for the selected Revision. This table is hidden for all other submissions.

Column	Description
SELPA Code	Read-only. Filterable and sortable.
SELPA Name	Read-only. Filterable and sortable.
SELPA Approval Status	Approval status of the individual SELPA for the selected Revision. Values: Not Approved, Approved, Disapproved.

Certification Validations (Errors & Warnings)¶

Filter options allow the user to select and resolve smaller subsets of errors. The filters section is followed by Filtered Results, divided into Fatal and Warning categories.

Field	Description
School CDS Code	Filter Option. Single-select dropdown.
Severity Code	Filter Option. Defaults to All.
Message ID	Filter Option. Sorted by ID in ascending order.
Message ID (result)	Certification error number. Listed in numeric sequence by error severity.
Message	Short description associated with the error.
Count	Number of times the error occurred within the selected revision's data.
Show (Action)	Displays filtered result detail records associated with the error.
Error Category	Describes the type of error: Missing Data, Invalid Data, Cert Anomalies, Cert Other.
Severity	Fatal or Warning.

Fatal Errors

All Fatal Errors must be resolved before the LEA Approve button becomes active.

Certification Reports and Approval¶

Below the Certification Errors section, the system displays the Certification Reports box containing mandatory reports the LEA must view before the Submission may be approved, as well as additional supporting reports.

Element	Description
(A) Aggregate Reports	Mandatory CALPADS Certification Reports for the specified Revision. Each report must be viewed. Once viewed, the system displays a ✔ (Completed icon) next to the report.
(B) Certification Acknowledgement	Checkbox stating: "By reviewing these reports and certifying, you are stipulating that the information contained therein is accurate, correct and complete to the best of your knowledge." Must be checked before the Approve button is enabled (beginning AY 2017–2018).
(C) LEA Approve Button	Active only when all fatal errors are resolved, all required Certification Reports have been reviewed, and (if applicable) the Anomaly Percent is below the threshold.
Disapprove Button	Enabled only when the current revision is in a Certified state. Reports remain marked as reviewed after disapproval.

LEA Approve Button – State Based on Collection Windows¶

	Outside Certification Window	Within Certification Window (Default)	Current Revision is Certified	Another Revision is Certified
Approve Submission	Disabled	Enabled	Disabled	Disabled
Disapprove	Disabled	Disabled	Enabled	Disabled

LEA Available Action Button – During Collection Window¶

The following table explains what action an LEA may take on an available Revision during an active Collection Window, assuming all reports have been reviewed and there are no Fatal Certification Errors.

If Revision Status is…	And no other available Revisions exist for…	Then Available Action Button is…
Revised Uncertified	LEA Approved, SELPA Approved	Enabled — "LEA Approve"
In Review Uncertified	LEA Approved, SELPA Approved	Enabled — "LEA Approve"
LEA Approved		Enabled — "LEA Disapprove"
LEA Disapproved		Enabled — "LEA Approve"
SELPA Approved		Enabled — "LEA Disapprove"
SELPA Disapproved	SELPA Disapproved	Disabled

Warning

An LEA cannot have multiple "LEA Approved" or "SELPA Approved" revisions at the same time.

Revision History¶

The Revision History section (at the bottom of the screen) provides an event log of activities against revisions within the selected Submission during the Submission Collection window. Activity is only visible from the Collection Window Start Date to the Amendment Window End Date.

Column	Description
Activity Date	Date/timestamp the action (revision status change) was initiated.
Revision Create Date	Date/timestamp the revision was created. Sortable ascending/descending.
Revision ID	Unique revision identification number.
SELPA Action	Blank unless a SELPA takes action. Displays SELPA Name–Code Approved or Disapproved.
Revision Status	Current workflow status of the revision.
Certification Status	Overall submission certification status.
User	User ID of the person who initiated the action.
Total Records	Total enrollment records (open and exited) for the revision.
Total Errors	Total errors and warnings for the revision.

Note

Revisions are created continuously as ODS changes occur regardless of the reporting window, but only activity occurring within the reporting window is displayed in the Revision History table.

Hierarchy of Available Revisions¶

LEAs are presented one or more revision statuses depending on prior actions. A hierarchy of available revisions is employed by CALPADS to determine the default revision displayed. This impacts the Certification Status on the main page, the Revision Status inside the Certification Detail page, and the resulting LEA Status on the SELPA level.

The following business rules identify which revision(s) to display (minimum 1, maximum 4 revisions visible at any time):

SELPA Approved — Always show first if available. There will never be multiple revisions with this status, and never both a "SELPA Approved" and "LEA Approved" revision for the same submission.
LEA Approved — Always show first if available. There will never be multiple revisions with this status, and never both a "SELPA Approved" and "LEA Approved" revision for the same submission.
In Review Uncertified — Always show if available. There will never be multiple revisions with this status. Shown immediately above any Revised Uncertified revisions.
Revised Uncertified — Always show, only the most recent if available. Always the lowest priority in the available views.
LEA Disapproved — Only show if there is neither an "LEA Approved" nor "SELPA Approved" revision available. If multiple exist, only the most recent is shown.
SELPA Disapproved — Only show if there is NOT a "SELPA Approved" revision already available. If multiple exist, only the most recent is shown. Will never appear if an "LEA Disapproved" exists.

Allowable Scenarios¶

	Scenario 1	Scenario 2	Scenario 3	Scenario 4	Scenario 5	Scenario 6	Scenario 7
1^st (highest priority)	Revised Uncertified	In Review Uncertified	In Review Uncertified	In Review Uncertified	In Review Uncertified	In Review Uncertified	In Review Uncertified
2^nd		Revised Uncertified	Revised Uncertified	Revised Uncertified	Revised Uncertified	Revised Uncertified	Revised Uncertified
3^rd			LEA Approved	SELPA Approved	LEA Disapproved	SELPA Disapproved	LEA Disapproved
4^th							SELPA Disapproved

Note

The primary (top) status in the hierarchy for each scenario is the only revision status SELPA Approvers will see on their side of CALPADS certification, regardless of multiple revision versions available from the Revision Status dropdown.

Certification Status – SELPA Approval¶

When a SELPA User selects the "Certification Status" link in left navigation, or a State-level user selects the "SELPA Approval" hyperlink under "Certification Status" navigation, the system displays the "Certification Details – SELPA" page.

This interface has the following functionalities for a selected Submission:

Required Filters for the SELPA, Academic Year, and Submission.
View the status of all associated LEAs per Filter Options with corresponding statuses and total fatal errors.
View the SELPA Aggregate and Supporting Reports related to the Submission.
Approve or Disapprove a Revision once an LEA has approved it.

SELPA Approval Applies to Fall 1 and EOY 1 Only

SELPA approval is required only for Fall 1 and EOY 1 submissions. Fall 2 and EOY 2 submissions do not involve SELPA approval.

Required User Roles¶

Users need to have a SELPA level org type and the following roles to access this section of CALPADS.

Data Collection Certifier (only required to certify)
EOY1 Reports
Fall1 Reports

Certification Status Filter Options¶

Screen Label	Validation / Business Rule
SELPA	Organization associated with the user's SELPA account. Only State-level users may change the value.
Academic Year	Reverse chronological order starting with the current academic year. SELPA users may not select an AY prior to 2019–2020. Defaults to the active EOY AY (e.g., 2024–2025 if submission ends after July 1, 2025).
Submission	Shows only Fall 1 and EOY 1. Leaving it blank reveals all available SELPA submissions as of the filter date.
Search Button	Executes search based on selected filter options.

Certification Details Results¶

When a SELPA user selects the appropriate submission period and clicks Search, the system displays the Certification Details Results section with the list of LEAs under the SELPA's jurisdiction and each LEA's current submission status.

Screen Label	Validation / Business Rule
CDS	County District School code of the LEA. Hyperlink to the Certification Summary & Details page.
LEA Name	Name of the associated LEA.
Revision Date	Date of the Revision with the most progress.
Revision ID	Unique ID created by the system to differentiate each revision.
Total Fatal Errors	Count of fatal errors for the selected Revision.
Revision Status	Status of the Revision with the most progress. Displays the highest value per Revision Availability business rules.
SELPA Approval Status	The status of the individual SELPA's approval for the given LEA and Revision. Values: Not Approved, Approved, Disapproved.
Certification Status	Overall certification status of the Submission.
Available Action	Conditionally available button set to Approve or Disapprove based on business rules below.
Select All	Checkbox to multi-select rows where the Approve button is active.
Approve Selected	Commits mass approvals for all selected rows. Requires confirmation message.

Reports Available to SELPAs¶

SELPAs may review the following reports before approving an LEA's submission.

Report Number	Report Name
16.1	Students with Disabilities – Education Plan By Primary Disability Count
16.2	Students with Disabilities – Count by Federal Setting
16.5	Students with Disabilities – Student Services by Primary Disability

SELPA Approval Buttons – Business Rules¶

The following table explains what action a SELPA may take on a Revision, based on the combination of the Revision Status and the individual SELPA's approval status. The SELPA may only Approve or Disapprove a Revision once an LEA has Approved it.

Key Rule

A SELPA may only approve or disapprove a Revision after the LEA has first approved it. If the LEA disapproves, the SELPA's Available Action button is disabled.

SELPA Approval or Disapproval – Available Action Button¶

If….	And If Revision Status is	Then SELPA Approval Status changes to	AND Available Action Button is…
Revision is first created	Revised Uncertified	Not Approved	Disabled
LEA Manually checks In Review checkbox	In Review Uncertified	Not Approved	Disabled
LEA Reviews all required Certification Reports	Revised Uncertified or In Review Uncertified	Not Approved	(No change)
LEA Approves Revision	LEA Approved	Not Approved	Enabled — "Approve"
LEA Disapproves Revision	LEA Disapproved	NO STATUS CHANGE	Disabled
SELPA Approves Revision	LEA Approved	Approved	Enabled — "Disapprove"
All SELPAs Approve Revision	SELPA Approved	NO STATUS CHANGE (Approved)	Enabled — "Disapprove"
SELPA Disapproves Revision	SELPA Disapproved	Disapproved	Enabled — "Approve"
A different SELPA associated with the revision disapproves	SELPA Disapproved	Approved	Enabled — "Disapprove"

Revision Status changes still depend on the complete sum of all SELPAs associated with the LEA.

Multiple SELPAs

If an LEA has multiple associated SELPAs, all must approve the revision before the Revision Status changes to SELPA Approved and the Submission Status changes to Certified. It only takes one SELPA to disapprove to revert the Submission Status to Uncertified.

Additional Resources¶

CALPADS Snapshot and Revision `Video`¶

This video clip covers the details of the CALPADS Snapshot Revision statuses and functionality through a live demo.

CALPADS Certification Process Playlist `Video`¶

This playlist provides an in-depth discussion and demonstration of the CALPADS Submission Certification process.

Certification Status¶

Certification Process Overview¶

CALPADS Data Extractor¶

Revision Characteristics¶

Report Generation and CVR Process¶

Revision Status vs. Submission Status vs. SELPA Approval Status¶

Certification Processes by Submission Type¶

Certification Status, Revision Status, and SELPA Approval Status¶

Certification Status and Revision Status¶

How to Decertify¶

How to Set In Review Status¶

Certification Status – LEA Approval¶

Required User Roles¶

Certification Status Filter Options¶

Certification Status Results¶

Certification Details – LEA¶

Revision Summary¶

Required SELPA Approvals¶

Certification Validations (Errors & Warnings)¶

Certification Reports and Approval¶

LEA Approve Button – State Based on Collection Windows¶

LEA Available Action Button – During Collection Window¶

Revision History¶

Hierarchy of Available Revisions¶

Allowable Scenarios¶

Certification Status – SELPA Approval¶

Required User Roles¶

Certification Status Filter Options¶

Certification Details Results¶

Reports Available to SELPAs¶

SELPA Approval Buttons – Business Rules¶

SELPA Approval or Disapproval – Available Action Button¶

Additional Resources¶

CALPADS Snapshot and Revision Video¶

CALPADS Certification Process Playlist Video¶

CALPADS Snapshot and Revision `Video`¶

CALPADS Certification Process Playlist `Video`¶