View Submission


The View Submission page displays a complete list of all the submitted batch files and the status of each file, which will change as the system processes the file or the authorized user interacts with the file. This page is displayed when the user selects the Upload/View Submission link under the Left Navigation menu. Users are also rerouted to the page after uploading a file.

The interface has the following functionalities and limitations:

  • View the status and details of submitted batch files
  • Filter the results on the page to view specific files
  • Modify the sort order of the files on the page
  • Determine the reason a file failed to upload
  • An authorized user may Archive files in a Posted state
  • An authorized user may Remove a file in either an Upload Failed or an In Queue status to exclude it from the submission and posting processes
  • Authorized user access to submitted files in any state is limited to 60 days from the submission date
  • Return to the File Upload page


View Submission Screen


Account Roles Needed

Users need the one or more of the following roles to access, view passed records and errors in this page. LEA Admins have the option to assign all or a few specific Edit roles.

  • All or selected file type Edit roles (e.g. SENR Edit roles)
  • All or selected file type View roles (to view file type details when troubleshooting an error)
  • Student Search (to be able to search a SSID when troubleshooting an error )


Submission Status

After the file has been uploaded successfully, the system will begin the submission validations and rules processing. If a user clicks the View Submission Status button on the “Upload File Results” page, the system displays a complete list of all the submitted State Reporting batch files and their status on the “Submission Status” page. During the submission process, a submitted file will change states as the system processes the file or the authorized user interacts with the file.

A file may be in one of the following possible states after the upload process or during the batch submission process:


Status Description
Upload Failed a file did not pass the initial upload validations or rules processing
In Queue a file passed the initial upload validations and rules processing and is waiting to be processed (Queue: the process waiting line for files) In Process – a file is currently being processed by the system. Each record in the file is being processed by the Input Validation Rules.
Ready for Review a file has completed the initial submission processing and is ready for an authorized to review the results after submission validations
In Review a file has completed the initial submission processing and an authorized user has reviewed the results, but has not made a selection on one or more sets of records in the file requiring user interaction
Post-Requested the records within the file submitted for posting to the ODS are in a queue waiting to be posted. The file undergoes a third set of validations when post is requested
Posting the records within the file submitted for posting are currently being posted to the ODS.
Partial Post a file with multiple schools that has one or more school(s) posted but not all school(s) are posted.
Posted an entire file of submitted records have been posted to the ODS
Revision in Progress a file has been posted and is now having data extracted, CVRs generated, and/or baseline reports generated
Revision Complete Versioning process is complete and data is available for viewing
Post Failed at least one school in the file contains records that have failed on post validations. Users should review the rejected records to correct the errors, upload the file again after corrections are made, then resubmit the file for posting.
Excluded an entire file of submitted records was removed from the submission process and not posted to the ODS
Cancelled the entire file has been cancelled by CALPADS Support due to intervention for technical reasons or the file has been cancelled upon the user's request


Filter Options

View Submission filter Options screen shot

A user may modify the list of files displayed on the “Submission Status” page by making filter option selections then clicking the Apply Filters button. When the button is clicked, the system will filter the results based on the user’s selected criteria options and will display the identified files in the results list on the “Submission Status” page. If a user clicks the Reset Filters button, the system will clear the values in all the filter criteria fields and reset the fields to the default values.

Order Field Name Comments
A File Type If the Apply Filters button is clicked, this selection will direct the system to only display files that match the chosen value
B File Status If the Apply Filters button is clicked, this selection will direct the system to only display files that match the chosen submission status
C Reporting LEA Displays the Local Education Agency associated to the user's account. If the user has a multi-organizational account, the Reporting LEA filter will display the LEA that is present in the organization Indicator
D Submitter If the Apply Filters button is clicked, this selection will display only files submitted by the selected User. The drop down list displays user names by the alphabetical order
E File List If the Apply Filters button is clicked, this selection will direct the system to only display files that match the chosen value. possible values include All, Current and Archive
F Available In If the Apply Filters button is clicked, this selection will direct the system to only display files that match the chosen value.
G Uploaded From If the Apply Filters button is clicked and this field is null, the system will calculate the current date minus 60 days as the date for the Start Date. This is the start date in a date range for file submissions
H Uploaded Through If the Apply Filters button is clicked and this field is null, the system will use the current date as the End Date. This is the end date for a date range for file submissions
I Job ID First click on the Field Name orders records by the ascending values; second click reorders records by the descending values.
J Include Online Submission If the Apply Filters button is clicked and this radio button is selected, results will include transaction made in online maintenance


Filter Action Buttons

After the filter options have been selected, the filter action button initiate a user driven function


Filter Action Buttons

Order Field Name Comments
A Upload Another File If clicked, the system will return to the File Upload screen with a new (blank) row for additional files to be uploaded
B Clear Fields If clicked, the system will reset all filter options to their default values
C Apply Filter If clicked, the system will base search on selected filter criteria options then either display the filtered list of files. If no files were found based on the filter criteria no files will be displayed.


Submission Results


Submission Results


The Submission Results display a list of submitted batch files and the status of each file. The account level will dictate what files are visible. Lea administrators can view any file submitted by an LEA user. LEA level and school level users can only see the files that they submit.


Order Field Name Comments
A Action View: Selecting this button will display the File Details page for the file with that Job Name
B Job ID The ID’s are automatically assigned to each file in order to keep track of each file
C Submitted/Time If the Apply Filters button is clicked, this selection will direct the system to display files submitted within the specified date range
D CDSCode The County-District-School (CDS) code associated with the account
E Job Name The Job Name was assigned to each file from the previous screen by the user. First click on the Field Name orders records by the ascending values; second click reorders records by the descending values.; Selecting this link will display the File Details page for the file with that Job Name
F File Type First click on the Field Name orders records by the ascending values; second click reorders records by the descending values
G Submitter First click on the Field Name orders records by the ascending values; second click reorders records by the descending values
H File Status First click on the Field Name orders records by the ascending values; second click reorders records by the descending values
I Passed First click on the Field Name orders records by the ascending values; second click reorders records by the descending values. Selecting a file’s count link of Record Results that passed will display the Passed Records page
J Rejected First click on the Field Name orders records by the ascending values; second click reorders records by the descending values. Selecting a file’s count link of Record Results that were rejected will display the Rejected Records page
K Revision Date/Time Populate when file status is Revision Complete. “Complete” means data extracted, reports generated, and CVRs processed
L Available In If file status is Revision Complete, populate field. Only data collections that are impacted by the file type submitted and which are within a current reporting window are listed. For example, a Discipline file submitted during the Fall 1 collection window would not display Available In: Fall 1
M Action Remove: The system will only display this button to authorized users and next to files in either an Upload Failed or an In Queue stated; if clicked the corresponding file will be removed from the submission and posting processes
Archive: The system will only display this button to authorized users and next to files in an All Posted state; if clicked the corresponding file will be archived