Definition
Data source details
Path name | Data Element | Definition | Data Type | Format |
---|---|---|---|---|
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 an instance of service delivery 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) |
CASEID | Person: Case Identifier, X(10) |
A system-generated identifier for a case associated with a person in receipt of services.
Specific Information:
|
CHARACTERSTRING | X(14) |
CASEENDDATE | Person: Case Identifier End Date, YYYYMMDD |
The date represented as year, month, day associated with the end of a person's case identifier. |
DATE | YYYYMMDD |
ATTENDANCEPROFILECODE | Session: Attendance profile, Code A(11) |
A code that represents the type of instance of services someone has been present for.
Specific Information:
Attendance profile is reported to better understand the relationship between clients within a case. This should be based on the relationships self-reported by the client and other attendees. |
ALPHASTRING | A(11) |
UNIDENTIFIEDCLIENTATTENDANCE | Session: Attendance count, Number NNN |
The total (count) of attendees at a session.
Specific Information:
The total (count) of unidentified attendees at a session. |
INTEGERNUMBER | NNN |
UNIDENTIFIEDCLIENTCASEMAX | Session: Attendance Capacity, Number NNN |
The number that indicates an event is as full as it can be or has reached capacity for an instance of service delivery within a reporting period. |
INTEGERNUMBER | NNN |
TOPICCODE | Session: Topic, code A(18) |
A code that represents the main focus of service delivery at a given session. |
ALPHASTRING | A(18) |
MONEYWORKSHOPCODE | Session: Money management course, code X(5) |
A code that represents the type of money workshop delivered at a given session.
Specific Information:
Required for the Commonwealth Financial Counselling and Financial Capability, and Money Support Hubs program activities where it is part of the case creation process. When the service type 'Education and Skills Training' is selected the field becomes mandatory |
ALPHANUMERICSTRING | X(5) |
SERVICESETTINGCODE | Session: Service setting, code X(15) |
A code that represents the category of physical location or delivery method for a given session. |
ALPHASTRING | X(15) |
PARENTINGAGREEMENTCODE | Session: Parenting agreement, Code A(10) |
A code that represents a parenting agreement for a given session. |
ALPHASTRING | A(10) |
PARENTINGAGREEMENTDATE | Session: Parenting Agreement, Date YYYYMMDD |
Parenting agreement date, represented as year, month, day for a given session. |
DATE | YYYYMMDD |
PARENTINGAGREEMENTLEGALHELP | Session: Parenting agreement legal help, Text XXX |
Parenting agreement legal help indicator - legacy system |
ALPHANUMERICSTRING | XXX |
PROPERTYAGREEMENTCODE | Session: Property Agreement, Code A(10) |
A code that represents a property agreement for a given session. |
ALPHASTRING | A(10) |
PROPERTYAGREEMENTDATE | Session: Property Agreement, Date YYYYMMDD |
Property agreement date, represented as year, month, day for a given session. |
DATE | YYYYMMDD |
PROPERTYAGREEMENTLEGALHELP | Session: Property agreement legal help, Text XXX |
Property agreement legal help indicator - legacy system |
ALPHANUMERICSTRING | XXX |
CERTIFICATETYPECODE | Session: Certificate, type code A(12) |
A code that represents the type of certificate for a given session. |
ALPHASTRING | A(12) |
CERTIFICATEISSUEDDATE | Session: Certificate, Date YYYYMMDD |
The issue date represented as year, month, day of certificate for a given session. |
DATE | YYYYMMDD |
INTERPRETERPRESENT | Session: Interpreter Present, code N |
A code that represents whether an Interpreter was present during a session. |
NUMBERSTRING | N |
FEECHARGEDAMOUNT | Session: Fee Charged, Total Australian currency N(8) |
Fee Charged for a Session (TEI - legacy system)
Specific Information:
Allows organisations to report whether the participants of the session were charged a fee to attend the service and reflects the program activity policy regarding fee collection. Only populated for applicable (Commonwealth Home Support Programme & Family Law) activities, and Only reported for the following service types: Brokerage |
INTEGERNUMBER | N(8) |
ASSISTANCECOSTAMOUNT | Session: Assistance Cost, Total Australian currency N(8) |
Assistance Cost for a Session (TEI - legacy system) |
INTEGERNUMBER | N(8) |
ASSISTANCEMINUTES | Session: Assistance Minutes, Text X(180) |
Assistance Minutes for a Session (TEI - legacy system) |
CHARACTERSTRING | X(180) |
ASSISTANCEQUANTITY | Session: Assistance Quantity, Text X(50) |
Assistance Quantity for a Session (TEI - legacy system)
Specific Information:
Recorded if the service is delivering something countable for example number of meals, number of trips provided., or total time spent in session, including administrative and travel time.
|
ALPHANUMERICSTRING | X(50) |
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) |
AgBusinessTypeCode | Person: Business type, Text X(50) |
The type of business which is the primary source of income for an individual, as represented by a label.
Specific Information:
This item is only required for the Rural Financial Counselling Service (RFCS) program activities where it is part of the case and session creation process. Agriculture Business Type: allows organisations to record the business type indicated by the client, which has generated more than 50% of the client’s income over the last three years. |
ALPHANUMERICSTRING | X(50) |
HardshipTypeCode | Person: Hardship type, Text X(50) |
The cause of difficulty or concern affecting an individual or their business, as represented by a label.
Specific Information:
This item is only required for the Rural Financial Counselling Service (RFCS) program activities where it is part of the case and session creation process. Hardship is a mandatory field which must be recorded for all sessions where an intake service type (when either Case managed – Intake, Transactional – Intake, or Service Transition) is selected. |
ALPHANUMERICSTRING | X(50) |
ExternalReferralDestinationCode | Person: External referral, Text X(50) |
A referral from one service to an external provider, for an individual, as represented by a label.
Specific Information:
This item is only required for the Rural Financial Counselling Service (RFCS) program activities where it is part of the case and session creation process. External Referral Destination: is used to describe a client’s referral to another service from the Rural Financial Counselling Service. |
ALPHANUMERICSTRING | X(50) |
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) |
INGESTYPE | 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) |