Definition
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| ATTENDANCEID | Data Exchange: Attendance identifier, X(19) |
A number that represents a system-generated identifier for a unique attendance record in the Data Exchange.
Specific Information:
The DEX application only generates attendance IDs for individual clients (either attending as a client or support person - Participation Type in ('CLIENT','SUPPORT')). We add unidentified client attendances to the attendance table and set AttendanceId to the negative of SessionId, and Participation Type to 'GROUP'. Further, because unidentified client attendances are not linked to individual client records, ClientId and CaseClientId are coded as 0. Unidentified client numbers captured at the case level estimate the total number of unidentified clients who are anticipated to attend services. In contrast, the unidentified client attendance numbers captured at the session level records how many unidentified clients actually attended that instance of service. This prevents double counting. For example, if the unidentified client total at the case level is 100, and there are two sessions each with 100 unidentified clients; the total specified at the case level indicates that there may be up to 100 unique unidentified clients for each session, and not 200 in total. A client attending a session without a client record. Attendance is recorded as an "unidentified client" in the Data Exchange. No demographic data is recorded against this client. |
CHARACTERSTRING | X(18) |
| SESSIONID | Data Exchange: Session identifier, X(19) |
A number that represents a system-generated identifier for a unique session record in the Data Exchange.
Specific Information:
Organisation’s Session Id. This is unique for a particular case within the organisation. SessionId and CaseId compound must be unique within the upload file. A client’s name, part of a client’s name, or other identifiable information should not be used as a Session Id under any circumstances. |
CHARACTERSTRING | X(18) |
| CLIENTID | Data Exchange: Client identifier, X(19) |
A number that represents a system-generated identifier for a unique client record in the Data Exchange. |
CHARACTERSTRING | X(18) |
| CASECLIENTID | Data Exchange: Case Client identifier, identifier X(19) |
A number that represents a system-generated identifier for a unique Client Case record in the Data Exchange. |
CHARACTERSTRING | X(18) |
| 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) |
| OUTLETID | Data Exchange: Outlet identifier, X(19) |
A number that represents a system-generated identifier for a unique outlet record in the Data Exchange.
Specific Information:
The location from where a service is primarily being delivered. Each outlet is assigned the program activities which it will deliver. |
CHARACTERSTRING | X(18) |
| LEADORGID | Data Exchange: Lead Organisation identifier, X(19) |
A number that represents a system-generated identifier for a unique service provider record in the Data Exchange of an organisation that has charge over the services provided.
Specific Information:
Organisations that directly receive funding from grants. These organisations may also deliver the service, or allocate the funding to other Delivery Organisations. |
CHARACTERSTRING | X(18) |
| DELIVERYORGID | Data Exchange: Delivery Organisation identifier, X(19) |
A number that represents a system-generated identifier for a unique service provider record in the Data Exchange of an organisation that has been directed to provide services.
Specific Information:
Organisations delivering services directly to clients. These organisations may receive funding directly or through a Funding Recipient (Lead Organisation) |
CHARACTERSTRING | X(18) |
| ACTIVITYID | Data Exchange: Program activity identifier, Code NNN |
A number that represents an identifier for a unique program activity record in the Data Exchange. |
NUMBERSTRING | NNN |
| SERVICETYPEID | Session: Service Activity Type, Code N(4) |
The main focus of service delivery at a given session, as represented by a numeric code.
Specific Information:
Describes the main focus of a session being delivered and the main way an outcome was achieved. |
NUMBERSTRING | N(4) |
| PARTICIPATIONTYPE | Person: Participation type, Label A(10) |
The code that represents the role of a given person at a session.
Specific Information:
CLIENT, SUPPORT or GROUP |
ALPHASTRING | A(10) |
| ATTENDANCECOUNT | Session: Attendance count, Number NNN |
The total (count) of attendees at a session.
Specific Information:
1 for client/support person attendances, 1 or more for unidentified client (group) attendances. |
INTEGERNUMBER | NNN |
| CONDUCTEDDATE | Session: Conducted Date, YYYYMMDD |
The date represented as year, month, day on which a given session took place. |
DATE | YYYYMMDD |
| AGEATSESSION | Person: Age, Total Years NNN |
The age of the person in (completed) years at a specific point in time. |
NUMBERSTRING | NNN |
| ASSISTANCENEEDEDKEY | Person: Assistance Needed Key, Binary Identifier N(4) |
A binary representation of the Earlier Intervention service/s required by a person.
Specific Information:
These categories describe why the client sought to attend the service. The categories are standardised to reflect the SCORE outcome domains and cover the full range of funded activities. |
NUMBERSTRING | N(4) |
| PRIMARYASSISTANCENEEDEDKEY | Person: Primary assistance needed, Binary Identifier N(4) |
A binary representation of the Targeted Earlier Intervention service/s of chief importance that is required by a person.
Specific Information:
These categories describe why the client sought to attend the service. The categories are standardised to reflect the SCORE outcome domains and cover the full range of funded activities. |
NUMBERSTRING | N(4) |
| REFERRALFROMSOURCE | Service Event: Referral Source, DEX label A(15) |
The person or organisation from which a person or group of people is referred for Targeted Earlier Intervention or Family Connect & Support services, as represented by a label.
Specific Information:
The source of referral is important in mapping client pathways and access points. This optional field helps organisations to identify the main avenues their clients come through to reach their services. This information is used to help target networking and communication strategies to increase client engagement with a particular funded activity if desired. |
ALPHASTRING | X(15) |
| REFERRALTOEXTERNALKEY | Session: Referral To External Key, Binary Identifier N(5) |
A binary representation of the type of service/s selected for referral to providers external to the organisation. |
NUMBERSTRING | N(5) |
| REFERRALTOEXTERNALDATE | Session: Referral Date, YYYYMMDD |
A date represented as year, month, day of a referral for the receipt of an instance of service. |
DATE | YYYYMMDD |
| REFERRALTOINTERNALKEY | Session: Referral To Internal Key, Binary Identifier N(5) |
A binary representation of the type of service/s selected for referral to providers internal to the organisation. |
NUMBERSTRING | N(5) |
| REFERRALTOINTERNALDATE | Session: Referral Date, YYYYMMDD |
A date represented as year, month, day of a referral for the receipt of an instance of service. |
DATE | YYYYMMDD |
| EXITREASONCODE | Service episode: Service cessation reason, TEI Exit Code X(16) |
The reason a client exited or is no longer receiving a service, as represented by a label.
Specific Information:
Indicates the circumstances surrounding the ending of a client’s relationship with a case. FCS uses the same categories as TEI. |
ALPHANUMERICSTRING | X(16) |
| 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) |