Skip to content Learn about the access keys available for Metadata.NSW
A NSW Government website
Metadata.NSW (beta)

Definition

The date on which a decision was made about the course of action to take in response to a child protection contact/assessment, expressed as YYYY-MM-DD.

Components

Data Element (this item)

Representation

This representation is based on the value domain for this data element, more information is available at " DateTime YYYY-MM-DD[Thh:mm:ss] ".
Description

A BigQuery datetime value element that is automatically combined with a time of day of midnight based on a 24-hour clock, using local server time - time zone information using UTC offsets is not stored. If no time is specified, the time portion defaults to 00:00:00. If no day or month is specified, the values default to 01.

DateTime YYYY-MM-DD(T00:00:00) Notation Elements, Meanings and Obligations

Element Meaning Obligation
YYYY A four digit year Required
MM A zero-padded month between 01 and 12 Optional
DD A zero-padded day between 01 and 31 Optional
hh A zero-padded hour between 00 and 23 Automatic
mm A zero-padded minute between 00 and 59 Automatic
ss A zero-padded second between 00 and 59 Automatic
Data Type DATETIME
Format YYYY-MM-DD(T00:00:00)
Maximum character length 20

Comments

This is important to measure the length of time between when the decision regarding the level of involvement of the department was made and the commencement of the investigation. It is also used to measure the length of time of the investigation and also the time elapsed from contact to the contact assessment decision.

Origin

Child protection and support services data dictionary. AIHW Version 1.0 Oct 2005.

Related content

Relation Count
Input in Derivations 0
Output in Derivations 0
Inclusion in Data Set Specifications 0
Inclusion in Data Distributions 2
As a numerator in an Indicator 0
As a denominator in an Indicator 0
As a disaggregation in an Indicator 0