Definition
Tenancy data elements - based on preliminary data (ie not finalised)
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| TENRF_NO | Tenancy: Tenancy Reference Number, Identifier N(10) |
The assigned number assigned that identifies a tenancy household either in Public Housing or Aboriginal housing. |
NUMBERSTRING | N(10) |
| ALLO_ZNE | Address: Allocation Zone, Code XXNN |
A code representing a group of areas or towns where social housing is available. |
ALPHANUMERICSTRING | XXNN |
| BEDROOMS | Dwelling: Number of bedrooms, Total NNN |
The total number of rooms within a dwelling which are used, or intended to be used, primarily for sleeping. |
INTEGERNUMBER | NNN |
| DTE_PROP | Dwelling: Construction Date, YYYY-MM-DD |
Construction date value of the property (indicates age of property) |
DATETIME | YYYY-MM-DD(T00:00:00) |
| FUNDING | Dwelling: Financial Summary, Code X(5) |
A DCJ housing code that represents the financial summary for a property. |
ALPHASTRING | X(6) |
| LGA_BK | Address: Local Government Area, Code N(4) |
A code that describes a geographic area defined by the Departments of Local Government, or their equivalent in each state or territory, excepting the Australian Capital Territory of an address. |
NUMBERSTRING | N(4) |
| PORTFOLIO | Organisation: Portfolio, Identifier X(8) |
The portfolio associated with a team or administrative unit responsible for property, tenancy and applications/allocations management, as represented by a code.
Specific Information:
Portfolio numbers are associated with Client Service Team - DCJ administrative unit responsible for property, tenancy and applications/allocations management within an allocated area. |
CHARACTERSTRING | X(8) |
| POST_CODE | Address: Australian postcode, code (Postcode datafile) NNNN |
The Australian numeric descriptor for a postal delivery area for an address. |
NUMBERSTRING | NNNN |
| PROG_CAT | Dwelling: Program Category, Code X(9) |
A code that represents a characteristic of an activity with a particular long-term aim of a property intended for people to live in. |
ALPHASTRING | X(9) |
| PROG_PUR | Dwelling: Program Purpose, Code X(9) | A code that represents the program purpose for the property. | ALPHASTRING | X(9) |
| PROP_ELE | Dwelling: Letting Elements, Code X(9) |
A code that represents the Letting Elements for the property. |
ALPHASTRING | X(9) |
| PROPREF | Dwelling: Property reference number, Identifier X(15) |
A unique system-generated reference number to identify a property intended for people to live in Social Housing. |
ALPHANUMERICSTRING | X(15) |
| PROP_TYP | Dwelling: Property Type, Code XXX |
Category/type of a property - as represented by a code used by DCJ Housing. |
ALPHASTRING | XXX |
| STREE_NM | Address: Road Name, Text X(46) |
The text that represents the name of the road or thoroughfare applicable to the address site or complex. |
CHARACTERSTRING | X(46) |
| STREE_NO | Address: Road Number, Identifier X(6) |
An alphanumeric identifier for an address or start number in a ranged address in a road or thoroughfare. |
ALPHANUMERICSTRING | X(6) |
| SUBURB | Address: Suburb/Town/Locality Name, Text X(46) |
The name of the locality, suburb or town of the address, as represented by text. |
CHARACTERSTRING | X(46) |
| TEAM | Organisation: Client Service Team, label XNNN |
The Client Service Team within an organisation or department - administrative unit responsible for service delivery and management. |
ALPHANUMERICSTRING | XNNN |
| UNIT_NO | Address: Unit Number, Identifier X(7) |
A numeric identifier used to distinguish an address within a building/sub-complex. |
ALPHANUMERICSTRING | X(7) |
| RNT_PAID | Dwelling: Rent Payable, Total Australian currency N(8) |
The amount of rent paid per week by a household, in dollars and cents |
INTEGERNUMBER | N(8) |
| RNT_FULL | Dwelling: Full Rent, Total Australian currency N(8) |
The full cost of rent for a given property, in Australian dollars ($AUD). |
INTEGERNUMBER | N(8) |
| RNT_MARK | Dwelling: Weekly market rent value, Total Australian currency N(8) |
The value of the weekly rent that would be charged for a dwelling in a private rental market, in dollars and cents. |
INTEGERNUMBER | N(8) |
| AREACODE | Address: DCJ District, Code A(7) |
DCJ administrative unit responsible for property, tenancy and applications/allocations management within an allocated area, as represented by a code. |
ALPHASTRING | A(7) |
| DIVISION | Address: DCJ District, Code A(7) |
DCJ administrative unit responsible for property, tenancy and applications/allocations management within an allocated area, as represented by a code. |
ALPHASTRING | A(7) |
| 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) |