© 2018 Capita Business Services Ltd. All rights reserved.

Capita Education Software Solutions is a trading name of Capita Business Services Ltd. Our Registered office is 30 Berners Street, London, W1T 3LR and our registered number is 02299747. Further information about Capita plc can be found in our legal statement.

SIMS 8 - New Attendance Codes to support COVID-19 Reporting

New Attendance Codes in SIMS 8(These codes have also been added to SIMS 7)

In response to government requirements for the recording of the impact of COVID-19 in schools we are adding 3 new attendance codes to support their needs.  This is optional for schools and in some edge cases schools who already had codes 7,8 or 9 in use  are currently unable to take advantage of the change.

These codes map back in to either illness or exceptional closure depending on the code.

The existing SIMS 8 API calls will allow:

  1. The same call to be made to return attendance codes which may now include the additional 3.
  2. The same calls to be made to get attendance records which will return the new codes if selected.
  3. The same post calls to attendance record to be made to enable theses codes to update SIMS 8.

AttendanceCodeCategory is also accessible via the APIs, see below.  Attendance code category maps the mark given back to the DfE set.

In V2 Endpoints:

https://pmapis.azure-api.net/sp-api-pre-prod/V2/Lookup/Attendance/SchoolAttendanceCodes?$expand=AttendanceCodeCategory

Will return:


 {
            "IsDeleted": false,
            "ExternalID": "a60c2587-90a1-ea11-8110-000d3a39b768",
            "Code": "7",
            "Description": "Illness due to Covid 19",
            "DisplayOrder": 31,
            "IsVisible": true,
            "AttendanceCodeCategory": {
                "IsDeleted": false,
                "ExternalID": "4e245da6-fd6d-4c07-9c1e-96698501600b",
                "Code": "I",
                "Description": "Illness (not medical/dental appt)",
                "IsActive": true,
                "ValidForStatutoryAttendance": true,
                "ForAdminUse": true,
                "ForTeacherUse": true,
                "IsUnexplainedAbsence": false,
                "IsPresent": false,
                "IsLate": false,
                "IsExceptionalClosure": false,
                "IsHoliday": false,
                "IsInsetDay": false,
                "IsNoMarkRecorded": false,
                "IsNotOnRoll": false,
                "IsPartTime": false,
                "OrderOfPrecedence": null,
                "DisplayOrder": 9,
                "IsExcluded": false
            }
        },
        {
            "IsDeleted": false,
            "ExternalID": "a70c2587-90a1-ea11-8110-000d3a39b768",
            "Code": "8",
            "Description": "Self-isolating due to Covid 19",
            "DisplayOrder": 32,
            "IsVisible": true,
            "AttendanceCodeCategory": {
                "IsDeleted": false,
                "ExternalID": "b6897f18-90a1-ea11-8110-000d3a39b768",
                "Code": "CY",
                "Description": "Exceptional closure",
                "IsActive": true,
                "ValidForStatutoryAttendance": true,
                "ForAdminUse": true,
                "ForTeacherUse": true,
                "IsUnexplainedAbsence": false,
                "IsPresent": false,
                "IsLate": false,
                "IsExceptionalClosure": true,
                "IsHoliday": false,
                "IsInsetDay": false,
                "IsNoMarkRecorded": false,
                "IsNotOnRoll": false,
                "IsPartTime": false,
                "OrderOfPrecedence": null,
                "DisplayOrder": 27,
                "IsExcluded": false
            }
        },
        {
            "IsDeleted": false,
            "ExternalID": "a80c2587-90a1-ea11-8110-000d3a39b768",
            "Code": "9",
            "Description": "Shielding due to Covid 19",
            "DisplayOrder": 33,
            "IsVisible": true,
            "AttendanceCodeCategory": {
                "IsDeleted": false,
                "ExternalID": "b6897f18-90a1-ea11-8110-000d3a39b768",
                "Code": "CY",
                "Description": "Exceptional closure",
                "IsActive": true,
                "ValidForStatutoryAttendance": true,
                "ForAdminUse": true,
                "ForTeacherUse": true,
                "IsUnexplainedAbsence": false,
                "IsPresent": false,
                "IsLate": false,
                "IsExceptionalClosure": true,
                "IsHoliday": false,
                "IsInsetDay": false,
                "IsNoMarkRecorded": false,
                "IsNotOnRoll": false,
                "IsPartTime": false,
                "OrderOfPrecedence": null,
                "DisplayOrder": 27,
                "IsExcluded": false
            }
        }

Or via in V3 endpoints

https://seli00apm01.azure-api.net/ssli01/Attendance/V3/AttendanceLookups
              

The format is a little different and there is no need for the expand because categories are also contained within the lookups call.

    {
      "@odata.type": "#SIMS.SchoolAttendanceCode",
      "ExternalID": "a60c2587-90a1-ea11-8110-000d3a39b768",
      "LookupType": "SchoolAttendanceCode",
      "Code": "7",
      "Description": "Illness due to Covid 19",
      "DisplayOrder": 31,
      "IsVisible": true,
      "AttendanceCodeCategory": "4e245da6-fd6d-4c07-9c1e-96698501600b",
      "ResourceProvider": null
    },

...

    {
      "@odata.type": "#SIMS.AttendanceCodeCategory",
      "ExternalID": "f53c960e-8cbe-4b8e-98df-2ee67c23b644",
      "LookupType": "AttendanceCodeCategory",
      "Code": "Y",
      "Description": "Exceptional circumstances",
      "DisplayOrder": 23,
      "IsVisible": true,
      "IsNotOnRoll": false,
      "IsPresent": false,
      "IsUnexplainedAbsence": false,
      "ForTeacherUse": false,
      "IsLate": false,
      "StatisticalCategory": "4f5a2e3b-a61a-4c50-96d2-c16a906b7db9",
      "School": null,
      "ResourceProvider": {
        "ExternalID": "3614d44d-ea84-486f-a0a5-a45fdac9da38",
        "Type": "StatutoryBody.Details"
      }