| Table of Contents |
|---|
Purpose
...
NHS admin download files with fields according to file structure.
File should be in .csv format and is converted to base64 by FE.
The file is saving to database (il.registers) and based on it if the person was matched, declaration will be terminated and this id will have status "matched". If the person wasn't matched the status will be "not_found". In case some errors happened and the row wasn't processed the status will be "processing".
...
File structure
Death registration
- type (il.dictionary: name='DOCUMENT_TYPE')
- number
- file example: person_example.csv
Termination by declaration_id
- declaration_id
- file example:
- declaration_id
...
| Name | Source | Description |
|---|---|---|
| id | $batch_id | id=batch_id from il.registers |
| file_name | $file_name | file_name=file_name from il.registers |
| status | [new, processing, processed ] | new - file was downloaded and not processed processing - when processing entries>0 processed - when processing entries=0 |
| type | $type | type=type from il.dictionaries.name='REGISTER_TYPE' |
| qty | {not_found: number, processing: number, errors: number, total: number} | |
| errors | ["Row has length 4 - expected length 5 on line 5", "Row has length 1 - expected length 5 on line 7"] | |
| inserted_at | user_id | |
| inserted_by | :timestamp | |
| updated_at | user_id | |
| updated_by | :timestamp |
The data from file must be stored to il.register_entries. In case some rows had errors those entries will be shown in filed "errors" and won't be processed.
| Name | Source | Description |
|---|---|---|
| id | ||
| register_id | the unique id for the batch upload | |
| person_type | enum(employee,patient) | |
| type | $type | document_type |
| number | $number | document_number |
| status |
| |
| inserted_at | user_id | from token |
| inserted_by | :timestamp | |
| updated_at | user_id | |
| updated_by | :timestamp |
After the file was processed the field "qty" from table il.registers must be updated.
...
If the person was matched then
- update declarations.status to `terminated`
- update persons.status='INACTIVE'
- change declarations.reason to $"auto_"||type
- update il.registers.status='matched'
...
If declaration_id was matched
- update ops.declarations.status to `terminated`
- update ops.declaration.updated_at = now()
- update ops.declaration.updated_by = $user_id
- change declarations.reason to $"auto_"||type
- update il.registers.status='matched'
- involve Event Manager for changed status
Backward compatibility
is not possible for this kind of termination. In case the wrong declaration was terminated, the patient must sign the new one.
...