Administrative data fields for social care assessment and agreement extraction
| Record | Description | Assessment | Agreement |
|---|---|---|---|
| ASM_ID | Assessment Identifier | X | |
| PERID | Person Identifier | X | X |
| DOB | Date of birth | X | X |
| AGREEMENT_START | Start date of the agreement | – | X |
| AGREEMENT_END | End date of the agreement | – | X |
| ASSESSMENT_START | Start date of the assessment | X | – |
| ASSESSMENT_END | End date of the assessment | X | – |
| SERVICE | Alphanumeric coding of the service | – | X |
| SERVICE_DESCRIPTION | Description of the service | – | X |
| ELEMENT | Alphanumeric coding of the element | – | X |
| ELEMENT_DESCRIPTION | Description of the element | – | X |
| QSA_DESCRIPTION | Quality standard assessment process description | X | – |
| QSA_GROUP | Quality standard assessment process group | X | – |
| ASSESSMENT_REASON | Reason of taking assessment | X | – |
| FORM_OUTCOME | Outcome of assessment form | X | – |
| SERVICE_TEAM | Corresponding assessment team | X | – |
| SERVICE/ELEMENT_COST | Cost of service/element where available | – | X |
| POSTCODE | Postcode (unit level) | X | X |
| GENDER | X | X | |
| ETHNICITY | Ethnic classification | X | X |
| CLIENT_GROUP | Disability status | X | X |
| WARD | X | – | |
| CONSTITUENCY | X | – |
| Record | Description | Assessment | Agreement |
|---|---|---|---|
| ASM_ID | Assessment Identifier | X | |
| PERID | Person Identifier | X | X |
| DOB | Date of birth | X | X |
| AGREEMENT_START | Start date of the agreement | – | X |
| AGREEMENT_END | End date of the agreement | – | X |
| ASSESSMENT_START | Start date of the assessment | X | – |
| ASSESSMENT_END | End date of the assessment | X | – |
| SERVICE | Alphanumeric coding of the service | – | X |
| SERVICE_DESCRIPTION | Description of the service | – | X |
| ELEMENT | Alphanumeric coding of the element | – | X |
| ELEMENT_DESCRIPTION | Description of the element | – | X |
| QSA_DESCRIPTION | Quality standard assessment process description | X | – |
| QSA_GROUP | Quality standard assessment process group | X | – |
| ASSESSMENT_REASON | Reason of taking assessment | X | – |
| FORM_OUTCOME | Outcome of assessment form | X | – |
| SERVICE_TEAM | Corresponding assessment team | X | – |
| SERVICE/ELEMENT_COST | Cost of service/element where available | – | X |
| POSTCODE | Postcode (unit level) | X | X |
| GENDER | X | X | |
| ETHNICITY | Ethnic classification | X | X |
| CLIENT_GROUP | Disability status | X | X |
| WARD | X | – | |
| CONSTITUENCY | X | – |