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
-
Target early intervention: _2018_29_4_ti_organisation
Statuses: UnregisteredA1.5:TEI organisation data
| 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) |