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

Service Episode: Episode Start Date, DateTime YYYY-MM-DD

Definition

The date expressed as YYYYMMDD on which a service episode/support period commenced.

Components

Data Element (this item)
Service Episode: Episode Start Date, DateTime YYYY-MM-DD

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 metadata item is used in calculation of measures of periods of support and duration of assistance.

Origin

Australian Institute of Health and Welfare (AIHW) 2013. Child Protection National Minimum Data Set, data collection manual 2012-13. Canberra: AIHW.

Related content

Relation Count
Input in Derivations 0
Output in Derivations 0
Inclusion in Data Set Specifications 0
Inclusion in Data Distributions 12
As a numerator in an Indicator 27
As a denominator in an Indicator 3
As a disaggregation in an Indicator 1