MDC

Owned by Mark Holland (Unlicensed)
Jan 12, 2018
3 min read

Description

Use this page to manage Teachers MDC files.

Content

Usage

Creating a Submission

Table Columns

Usage

This page is used to create, download, upload and submit, Teachers MDC files.


Creating a Submission

Selecting the Year and Month and clicking Create will create the new file and show it in the table below. A file can only be created if there is a submitted file for the prior month and no file is already created for the selected period. If these criteria are not met an error will be raised (The only time that this rule can be broken is if this is the first ever file created for the company). Should it be required to recreate a non-submitted file then the original file must first be deleted. 
The file will contain all workers on Teacher's Grades and will automatically include updated rows for any previously submitted lines that have subsequently changed. Please note that all payrolls should be committed for the month prior to the file being created.

Table Columns

  • Year: The Year the MDC Upload applies to.
  • Month: The Month the MDC Upload applies to.
  • Row Count: The number of rows in the file.
  • Filename: The filename with the required naming convention for MDC upload.
  • Created Date: The date of file creation.
  • Submitted Date: The date of file submission.
  • Upload/Download
    • Purple Download: Click to download the data in a format that can be edited and re-uploaded. Rows in this file can be added, amended and deleted. To add a row all non starred fields are required, together with the EmployeeNumber and the MDCHeadID (the MDCHeadID must be identical to the other rows) . To delete a row a Y should be added to the Delete column (this is the only valid value other than blank for this field)
    • Purple Upload: Click to re-upload the edited file. The file will either successfully upload or an error will occur and the user will have the opportunity to re-download the file including error details (see below). The ability to upload a file will only be available while the file is in an non-submitted state
    • Red Download: Click to download the data in a format to upload to the Teachers MDC site. The filename should not be changed or the file edited prior to upload.
    • Delete: Click to delete the file. This option is only available while the file is non-submitted.
  • Submit: Clicking in a non-submitted tick box will submit the file. A maximum of one file at a time can have a non-submitted status. Once ticked there is no undo action without contacting support. It should be noted that the submit action causes no actual change to the file, but will allow further submissions to be created