Definition
Yet to be defined
Data source details
Provenance records
Generated distributions
-
Housing: pra_receipts
Statuses: UnregisteredA1.2:Details of private rental assistance recipients
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 | Person: Case Identifier, X(10) |
A system-generated identifier for a case associated with a person in receipt of services. |
CHARACTERSTRING | X(14) |
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) |
HOUSING_OPTION_REF | Household: Advice Case Option Reference, Identifier N(7) |
A system-generated identifier for the housing option type associated with a household who has applied for housing assistance, as represented by a numeric string. |
NUMBERSTRING | N(7) |
HOUSING_OPTION | Household: Housing Option Type, Business Key Code X(10) |
A system-generated identifier for the housing option type associated with a household who has applied for housing assistance, as represented by a code. |
ALPHASTRING | ALPHASTRING |
HOUSING_OPTION_CREATED_DATE | Household: Housing Option Type, Date YYYY-MM-DD |
The date of the creation of the housing option associated with a household who has applied for housing assistance. |
DATETIME | YYYY-MM-DD(T00:00:00) |
HOUSING_OPTION_STATUS | Household: Housing Option Status, Code X(10) |
The status of a housing option associated with a household who has applied for housing assistance, as represented by a code. |
ALPHASTRING | ALPHASTRING |
HOUSING_OPTION_STATUS_DATE | Household: Housing Option Status, Date YYYY-MM-DD |
The date of the status of a housing option associated with a household who has applied for housing assistance. |
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) |