Upload SLA Data

Upload Excel File
Please upload an Excel file (.xlsx or .xls) with SLA data.
Cancel
Danger Zone
Delete All SLA Records

This will permanently delete all SLA records from the database. This action cannot be undone.

Instructions
Expected Excel Format:
  • First row should contain column headers
  • Data should start from the second row
  • Date Format: MM/dd/yyyy hh:mm:ss tt
  • Example: 12/31/2023 11:59:59 PM
  • Columns 30, 34, and 37 (SLA Min values) are ignored during upload
Important Notes:
DocID Uniqueness: Records with duplicate DocID will overwrite existing records in the database.
Required Columns:
  1. DocID
  2. OcrDocID
  3. FileID
  4. ClientID
  5. AdminID
  6. CaseRelationHeaderID
  7. InvoiceNumber
  8. ClientName
  9. AdminName
  10. ContactName
  11. CodingRule
  12. ReceivedDate
  13. FileDocCount
  14. FilePageCount
  15. Source
  16. DocPageCount
  17. IcapCompletedDate
  18. ImportedOn
  19. ManualVerificationTime
  20. OcrOperatorFirst
  21. DocType
  22. ExportCompletedDate
  23. ClientReviewCompletedDate
  24. OfficeStartTime
  25. OfficeEndTime
  26. FileType
  27. FileTypeCombined
  28. DocSubType
  29. ProcessingCompletedMin
  30. ProcessingSLAMin Ignored
  31. OfficeProcessingCompletedMin
  32. OfficeProcessingCompletedSLA
  33. IcapCompletedMin
  34. IcapSLAMin Ignored
  35. OCRType
  36. OCRCompletedMin
  37. OCRSLAMin Ignored
Note: Columns 30, 34, and 37 (ProcessingSLAMin, IcapSLAMin, OCRSLAMin) are automatically ignored during upload.