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

Definition

The Organisation table is a lookup table for the name of the Organisation. It contains the Organisation ID that can be linked with other tables.

Apart from Outlet table, the linkage key in other tables may not be Organisation ID. The Organisation ID in the Organisation table can be linked to other tables with:

  • DeliveryOrgID
  • LeadOrgID

ABN number can be found in the Organisation Table which is the ABN of the Organisation

A Current Record flag exist to indicate whether the Organisation is currently delivering TEI services to the clients

The ORGANISATION table to contain the following data elements.

Data source details

Provenance records

Generated distributions

Path name Data Element Definition Data Type Format
ORGANISATIONID Data Exchange: Organisation identifier, X(19)

A system-generated identifier for a unique service provider record in the Data Exchange, represented by a number.

CHARACTERSTRING X(18)
NAME Organisation: Organisation Name, Text X(200)

The full title of an organisation's name by which it trades or is recognised, as represented by text.


Specific Information:

Required for use in internal reporting, and also to match internal list of Aboriginal Controlled Organisations to provided data for external reporting purposes in an aggregated and non-identified way. 

ALPHANUMERICSTRING X(200)
GPSORGANISATIONID Organisation: SystemID, String X(14)

A persistent system generated identifier.

CHARACTERSTRING X(14)
GPSORGANISATIONNAME Organisation: Organisation Name, Text X(200)

The full title of an organisation's name by which it trades or is recognised, as represented by text.

ALPHANUMERICSTRING X(200)
ABN Organisation: Australian Business Number, Identifier N(11)

A unique identifier allocated to an individual, association, or other legal or administrative unit for the purposes of identification in dealings with the Australian Government, or for other Commonwealth purposes, in particular with respect to taxation laws.


Specific Information:

Required to provide the basis for a more robust process to match to an internal list of Aboriginal Controlled Organisations. 

NUMBERSTRING N(11)
SYSSTARTTIME Record: DateTime Stamp, YYYY-MM-DD

A sequence of characters or encoded information identifying when a certain event occurred, on what day, and optionally including what particular time of day.

DATETIME YYYY-MM-DD(T00:00:00)
SYSENDTIME Record: DateTime Stamp, YYYY-MM-DD

A sequence of characters or encoded information identifying when a certain event occurred, on what day, and optionally including what particular time of day.

DATETIME YYYY-MM-DD(T00:00:00)
CURRENTRECORD Record: Current Record Indicator, No/Yes Code N

Whether a record is current or active, recorded as a code set representing 'no' and 'yes'.

NUMBERSTRING N
RECORDSEQNBR Record: Sequence Number, NNN

A system generated sequence of numbers that locates a client's historical record who attended one or more services funded to improve wellbeing. This number ensures a record is unique.

INTEGERNUMBER NNN
BATCHID Record: Batch Id, Text X(200)

System generated identification generated when (data) ingested into BigQuery, represented by text.

ALPHANUMERICSTRING X(200)