Definition
Information about the people living in a social housing property and the length of their tenancy.
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| TENANCY_REF | 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) |
| TENANCY_START_DATE | Dwelling: Rent Start Date, YYYY-MM-DD |
The date recorded as the day of a particular month and year, on which the rent commenced of a property intended for people to live in. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| TENANCY_END_DATE | Tenancy: Tenancy End Date, YYYY-MM-DD |
The date at which a tenancy agreement between the client and DCJ Housing ends. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| CLIENT_REF | 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) |
| TENANT_EFF_FROM_DATE | Person: Tenancy Start Date, YYYY-MM-DD |
The date at which a tenancy agreement between the client and DCJ Housing commenced.
Specific Information:
The date on which a household member commenced for the tenancy |
DATETIME | YYYY-MM-DD(T00:00:00) |
| TENANT_EFF_TO_DATE | Person: Tenancy End Date, YYYY-MM-DD |
The date on which a tenancy agreement between the client and DCJ Housing ends.
Specific Information:
The date on which a household member ends for the tenancy |
DATETIME | YYYY-MM-DD(T00:00:00) |
| HOUSEHOLD_RELATION_TYPE_BK | Person: Relationship Type, DCJ-H Code A(10) |
A code that represents the relationship of a person in the household unit to the presenting unit head, as used by DCJ Housing. |
ALPHASTRING | A(10) |
| HOUSEHOLD_RELATION_TYPE_NAME | Person: Relationship Type, DCJ-H Code A(10) |
A code that represents the relationship of a person in the household unit to the presenting unit head, as used by DCJ Housing. |
ALPHASTRING | A(10) |
| FORENAME | Person: Given Name, Text X(50) |
The name of a person within the family group or by which the person is socially identified. |
ALPHANUMERICSTRING | X(50) |
| SURNAME | Person: Family Name, Text X(50) |
The text that represents a name by which a person’s family group may be identified. That part of a name a person usually has in common with some other members of his/her family, as distinguished from his/her given names. |
ALPHANUMERICSTRING | X(50) |
| PROPERTY_REF | 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) |
| 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) |