Filetype Excel XLSX | Posted on 27 Jun 2022 | 3 years ago
Authentication
digital resources
236x Filetype XLSX File size 0.04 MB Source: www.orangatamariki.govt.nz
Sheet 1: Data Requirements Overview
| NOTE: This template is to be used for manual data collection for Care Partners without an existing case management platform, or a platform lacking the ability to record a majority of the required data. Please note that Care Partners who are already collecting most data via their case management platform will not need to manually collect data. | ||||
| Data Fields | Description | Data Type | Social Sector Data Sharing Standard (SSDSS) | Purpose or legislative rationale |
| Information about the care response (Event table) | ||||
| Record Identifier | A unique identifier of the record shared. This is automatically generated by the provider source system. | Format - varchar (150) Mandatory |
Record Identifier | Database record |
| Record Version | Version of the record specification. This is automatically generated by the receiver source system. | Format - varchar (150) Mandatory |
Record Version | Database record |
| Provider Number | The unique identifer of the care partner generated by Oranga Tamariki. This is found in the Outcome Agreement document. | Format - varchar (150) Mandatory |
Delivery Provider Client ID | Reconciliation |
| Contract Number | The unique identifer of the care partner contract generated by Organa Tamariki. This is found in the Outcome Agreement document. | Format - varchar (150) Mandatory |
Delivery Contract ID | Reconciliation |
| Contract Service Code | The code for the contracted service to be delivered. This relates to the unique funding item used for bed night reconciliation. This can be found in the outcome agreement i.e., A, B, C, AA, BB | Format - varchar (150) Mandatory |
Event Type Level 3 | Reconciliation |
| Event Type 1 | To identify whether tamaiti is in the care of a caregiver or being cared for by care staff. | Format - varchar (150) Mandatory Values: • Caregiver • Care staff |
Event Type Level 1 | Reconciliation |
| Event Type 2 | To identify whether tamaiti is with their primary carer or on an agreed short-break i.e., 1. Primary care option (Tamaiti is with primary caregiver/s or in primary staffed care arrangement) 2. Away on short-break (Data field assigned to primary caregiver/community home when tamaiti is away from their care on an agreed short-break) 3. Short-break care (Data field used when tamaiti is with an agreed short-break caregiver/care staff arrangement/whanau) | Format - varchar (150) Mandatory Values: • Primary Care • Away on Short break • Short break care |
Event Type Level 2 | Reconciliation |
| Event start date | The start date of the care service. | Format - varchar (150) Mandatory Values: (yyyy-mm-ddThh:mm:ss.ffffff) |
Event Start Date Time | Reconciliation. National Care Standards Regulation 81(2)(c) |
| Event end date | The end date of the care service. | Format - varchar (150) Optional - NULL or empty string is used Values: (yyyy-mm-ddThh:mm:ss.ffffff) |
Event End Date Time | Reconciliation. National Care Standards Regulation 81(2)(c) |
| Caregiver 1 ID | A unique ID for the Caregiver generated by the partner’s system. This ID will serve as the primary field to join on details about the caregiver from the caregiver table. | Format - varchar (150) Optional - NULL or empty string if not used |
Delivery Provider Client ID | Reconciliation National Care Standards Part III |
| Caregiver 2 ID | A unique ID for the second Caregiver generated by the partner’s system. This is when a child is being cared for by multiple caregivers i.e., Couple | Format - varchar (150) Optional - NULL or empty string if not used |
Delivery Provider Client ID | Reconciliation National Care Standards Part III |
| CYRAS ID | A unique identifier of the tamariki in care that will be provided by Oranga Tamariki | Format - varchar (150) Mandatory |
Referrer Referral ID | Oranga Tamariki (1989) Act s7(2)(e) The care partner will always be the first point of contact for Oranga Tamariki in relation to the care of tamaiti. Information about where tamaiti is living ensures that Oranga Tamariki maintains accurate information to support the care of tamariki, for example following a local emergency. The collection of this information will be discussed individually with each partner to understand how this is managed locally. |
| Child address | Street address where the child is living | Format - varchar (150) Optional - NULL or empty string is used |
Person Address | |
| Child suburb | Suburb of the residential address | Format - varchar (150) Optional - NULL or empty string is used |
Person Suburb | |
| Child city | City of the residential address | Format - varchar (150) Optional - NULL or empty string is used |
Person Town City | |
| Child postcode | Postcode of the residential address | Format - varchar (150) Optional - NULL or empty string is used |
Person Postcode | |
| Information about Caregiver(s) (Caregiver table) | ||||
| Caregiver ID | The unique ID of the Caregiver generated by the partner’s system. This ID will be used to join on details about the care provided from the care response table. | Format - varchar (150) Mandatory |
Delivery Provider Client ID | Reconciliation. National Care Standards Part III |
| Caregiver ethnicity | The ethnicity of the caregiver. Can carry up to six values. | Format - varchar (150), pipe delimited Mandatory |
Person Ethnicity Ethnicity New Zealand Standard Classification 2005 V2.1.0 | Oranga Tamariki Act 1989 - section 7AA |
| Date the assessment of prospective caregiver and their household completed | The date the assessment of the prospective caregiver and their household is completed. (Note: Not applicable for Group homes). ISO 8601 standard | Format - varchar (150) Optional - NULL or empty field if not used Values: (yyyy-mm-ddThh:mm:ss.ffffff) |
Event End Date Time | National Care Standards Regulation 45 |
| Date of caregiver provisional approval | The date the caregiver is granted provisional approval to care for a child or young person (if applicable). ISO 8601 standard. | Format - varchar (150) Optional - NULL or empty field if not used Values: (yyyy-mm-ddThh:mm:ss.ffffff) |
Event Start Date Time | National Care Standards Regulation 51 |
| Date of caregiver full approval | The date the caregiver is granted full approval. ISO 8601 standard. | Format - varchar (150) Optional - NULL or empty field if not used Values: (yyyy-mm-ddThh:mm:ss.ffffff) |
Event Start Date Time | National Care Standards Regulation 49 |
| Most recent date of review of caregiver approval status | The date when the caregiver’s approval was last reviewed. ISO 8601 standard. | Format - varchar (150) Optional - NULL or empty field if not used Values: (yyyy-mm-ddThh:mm:ss.ffffff) |
Event Start Date Time | National Care Standards Regulation 50 |
| Date caregiver support plan developed | The date when the caregiver support plan is developed. ISO 8601 standard. | Format - varchar (150) Optional - NULL or empty field if not used Values: (yyyy-mm-ddThh:mm:ss.ffffff) |
Event Start Date Time | National Care Standards Regulation 58-59 |
| Date of most recent review of caregiver support plan | The date when the caregiver support plan was last reviewed. ISO 8601 standard. | Format - varchar (150) Optional - NULL or empty field if not used Values: (yyyy-mm-ddThh:mm:ss.ffffff) |
Event Start Date Time | National Care Standards Part III |
| Reason for review of the support plan | One of the 3 defined reasons why a support plan might require to be reviewed. These are: 1. As part of a regular review to ensure the caregiver is able to meet the needs of the child. 2. It is identified that the caregiver’s needs have changed. 3. As a result of an allegation that a child in the caregiver’s care has suffered abuse of neglect. | Format - varchar (150) Optional - NULL or empty field if not used Values: 1. As part of a regular review to ensure the caregiver is able to meet the needs of the child. 2. It is identified that the caregiver’s needs have changed. 3. As a result of an allegation that a child in the caregiver’s care has suffered abuse of neglect. |
Event Measure Type | National Care Standards Part III. Regulation 61, 69(2)(d) |
| Most recent date of visit to caregiver | The date the caregiver is visited by their support person or the equivalent of a caregiver social worker. ISO 8601 standard | Format - varchar (150) Optional - NULL or empty field if not used Values: (yyyy-mm-ddThh:mm:ss.ffffff) |
Event Start Date Time | National Care Standards Regulation 50, 60(3) |
| Information on Tamariki (Only when tamariki in care cannot be identified i.e. CYRAS ID unavailable) (Child table) | ||||
| Child first name | First name of the Tamariki in care | Format - varchar (150) Mandatory |
Person Given Name | Data matching |
| Child last name | Family name of the Tamariki in care | Format - varchar (150) Mandatory |
Person Family Name | Data matching |
| Child date of birth | The birth date of the Tamariki in care. ISO 8601 standard | Format - varchar (150) Mandatory Values - (yyyy-mm-ddThh:mm:ss.ffffff) |
Person Date of Birth | Data matching |
| Note: | |||||||||||||||
| Click on the cell under Caregiver Type column and Placement Type column to choose a suitable value. | |||||||||||||||
| Note: The 'record identifier' and 'record version' columns will be system generated upon automatic transfer when Data Exchange is implemented - manual data entry not needed. | |||||||||||||||
| Provider Number | CYRAS ID | Event type 1 | Event type 2 | Event start date | Event end date | Contract Number | Contract Service Code | Caregiver 1 ID | Caregiver 2 ID | Child address | Child suburb | Child city | Child postcode | Record Identifier | Record Version |
| Note: | |||||||||||||
| Click on the cell under Caregiver Type column, Caregiver ethnicity column and Reason for review of the support plan column to choose a suitable value. | |||||||||||||
| Note: The 'record identifier' and 'record version' columns will be system generated upon automatic transfer when Data Exchange is implemented - manual data entry not needed. | |||||||||||||
| Partner ID | Caregiver ID | Event type 1 | Caregiver ethnicity | Date the assessment of prospective caregiver and their household completed | Date of caregiver provisional approval (if applicable) | Date of caregiver full approval | Most recent date of review of caregiver approval status | Date caregiver support plan developed | Date of most recent review/update of caregiver support plan | Reason for review of the support plan | Most recent date of visit to caregiver and caregiver’s home | Record Identifer | Record Version |
no reviews yet
Please Login to review.
