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
| 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. |
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. |
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 |
| CreatedDateTime | 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) |
| INGESTTIME | 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) |
| INGESTTYPE | Record: Ingest Type, Label A(6) |
File (data) ingestion process type, represented by a label. |
ALPHASTRING | A(6) |
| FILENAME | Record: Filename, Text X(200) |
File name (data) ingested into BigQuery, represented by text. |
ALPHANUMERICSTRING | X(200) |
| BATCHID | Record: Batch Id, Text X(200) |
System generated identification generated when (data) ingested into BigQuery, represented by text. |
ALPHANUMERICSTRING | X(200) |