Definition
Definition to be completed
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| CLIENT_REF_NO | Person: Client Reference, Number N(7) |
A system-generated identifier for an individual who is a client of an organisation or service provider, as represented by a number. |
NUMBERSTRING | N(7) |
| ADVICE_CASE_REF | Application: Case identifier, N(7) |
A unique system-generated identifier for a case associated with an application for services or assistance, as represented by a numeric string.
Specific Information:
Reference for a case associated with a household who has applied for housing assistance. |
NUMBERSTRING | N(7) |
| APPROACH_DATE | Service Event: Assistance Request Date, YYYY-MM-DD |
The date on which assistance from an agency is requested, expressed as DDMMYYYY. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| ADVICE_CASE_CREATED_DATE | Application: Created date, DateTime YYYY-MM-DD |
The date recorded as the day of a particular month and year, on which an application for services or assistance was created. |
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) |
| EXTRACT_ID | Record: Identifier, N(8) |
A sequence of characters represented as a numeric string which uniquely identifies a data warehouse record. |
NUMBERSTRING | N(8) |
| EXTRACT_DATE | Record: Report Extraction Date, YYYY-MM-DD |
The date represented as year, month, day on which a report was extracted from a data source. |
DATETIME | YYYY-MM-DD(T00:00:00) |