Definition
Data source details
Path name | Data Element | Definition | Data Type | Format |
---|---|---|---|---|
BATCHID | Record: Batch Id, Text X(200) |
System generated identification generated when (data) ingested into BigQuery, represented by text. |
ALPHANUMERICSTRING | X(200) |
CLIENTREFNO | 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) |
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) |
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) |
FILENAME | Record: Filename, Text X(200) |
File name (data) ingested into BigQuery, represented by text. |
ALPHANUMERICSTRING | X(200) |
INCOMEENDDATE | Person: Income Effective To Date, YYYY-MM-DD |
The date the client income is effective to. |
DATETIME | YYYY-MM-DD(T00:00:00) |
INCOMEREFERENCE | Person: Income, Identifier N(8) |
An individual's income, as represented by a unique numeric identifier. |
NUMBERSTRING | N(8) |
INCOMESTARTDATE | Person: Income Effective From Date, YYYY-MM-DD |
The date the client income is effective from. |
DATETIME | YYYY-MM-DD(T00:00:00) |
INCOMESTATUS | Person: Income Status, Verified/Unverified Code XXX |
A code that represents whether the income status of a person has been verified. |
ALPHASTRING | XXX |
INCOMETYPE | Person: Source of Income, Code X(10) |
The source of income for an individual., represented by a code. |
CHARACTERSTRING | X(10) |
INCOMETYPEDESCRIPTION | Person: Source of Income, Code X(10) |
The source of income for an individual., represented by a code. |
CHARACTERSTRING | X(10) |
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) |
TOTALWEEKLYINCOME | Person: Gross Income, Total Australian Currency N(8) |
The total value of an individual's income per week from all sources before any deductions such as income tax and superannuation, expressed as dollars and cents. |
INTEGERNUMBER | N(8) |