Definition
The Organisation Activity table records the partnership agreement between each service provider and the government.
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| ORGANISATIONACTIVITYID | Data Exchange: Organisation Activity, identifier X(19) |
A number that represents a system-generated identifier for a unique Organisation Activity record in the Data Exchange. |
CHARACTERSTRING | X(18) |
| DELIVERYORGID | Data Exchange: Organisation identifier, X(19) |
A system-generated identifier for a unique service provider record in the Data Exchange, represented by a number.
Specific Information:
The DeliveryOrgID flag is the primary key to link to either DeliveryOrgID or OrganisationID in other tables. |
CHARACTERSTRING | X(18) |
| ACTIVITYID | Data Exchange: Program activity identifier, Code NN |
A number that represents an identifier for a unique program activity record in the Data Exchange. |
NUMBERSTRING | NN |
| LEADORGID | 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) |
| STARTDATE | Organisation: Start Date, YYYYMMDD |
The funding start date in relation to a service provider, recorded as a day of a month of a year, represented as YYYYMMDD. |
DATE | YYYYMMDD |
| ENDDATE | Organisation: End Date, Date YYYYMMDD |
The funding end date in relation to a service provider, recorded as a day of a month of a year, represented as YYYYMMDD. |
DATE | YYYYMMDD |
| EXTENSIONDAYS | Organisation: Extension Days, Number NNN |
The number days for an organisation to submit data to DSS
Specific Information:
For each Organisation and Activity ID, the ExtensionDays field shows the number of days an organisation must submit their data to DEX after the reference period. |
INTEGERNUMBER | NNN |
| PARTNERSHIPENDED | Organisation: Partnership Ended, No/Yes Code N |
An indicator of whether a service providers partnership with DEX has ended, as represented by a code. |
NUMBERSTRING | N |
| INPARTNERSHIP | Organisation: In Partnership, No/Yes Code N |
An indicator of whether a service provider is in partnership arrangement with DEX, as represented by a code.
Specific Information:
The InParternship field is a flag to indicate whether the partnership approach is in place between the organisation and the government. Organisation participating in this approach report an extended dataset, in exchange for access to additional self-service report. |
NUMBERSTRING | N |
| HANDSHAKESTATUSCODE | Organisation: Handshake Status, Code X(20) |
The virtual agreement (handshake) between organisations, as represented by a code. |
ALPHANUMERICSTRING | X(20) |
| 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'.
Specific Information:
The CurrentRecord flag exists to indicate whether the Organisation is currently delivering FCaS services to client. |
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) |