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

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)