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

Service Episode: End Date, YYYY-MM-DD

Definition

The date on which a service episode/support period was completed, expressed as YYYYMMDD.

Components

Data Element (this item)
Service Episode: End Date, 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 may be used in the calculation of measures of periods of support and duration of assistance.

Related content

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