Definition
The APPLICANT WAITLIST table to contain the following data elements.
Data source details
| Path name | Data Element | Definition | Data Type | Physical Data Type | Format |
|---|---|---|---|---|---|
| APPLICATION_REFERENCE_NUMBER | Household: Social Housing Application Reference Number, Identifier N(8) |
A unique (system generated) number allocated to a Social Housing applicant household. |
CHARACTERSTRING | - | X(8) |
| REGISTER | Household: Application Register, Code XX |
A code that represents the type of application register the household is placed on the Social Housing Waitlist used by DCJ Housing. |
CODE | - | XX |
| CATEGORY | Household: Application Category, Code X(8) |
A code that represents the reason the applicant is admitted to the Social Housing Register when the household applied for housing assistance used by DCJ Housing. |
CODE | - | X(8) |
| STATUS | Application: Housing application List Status, Code X(8) |
The current status of an application for a household admitted on the Social Housing Waitlist, as represented by a code. |
CODE | - | X(8) |
| STATUS_DATE | Application: Status, DateTime YYYY-MM-DD |
The current status of an application, on a specified date recorded as the day of a particular month and year.
Specific Information:
A date that represents the current status of an application for a household admitted on the Social Housing Waitlist. |
DATETIME | - | YYYY-MM-DD(T00:00:00) |
| APPLICATION_RECEIVED_DATE | Household: Application Received, Date YYYY-MM-DD |
The date on which an applicant household lodges an application to be assessed for the Social Housing waitlist, expressed as DDMMYYYY. |
DATETIME | - | YYYY-MM-DD(T00:00:00) |
| 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) |
| APPLICANT_EFFECTIVE_FROM_DATE | Application: Effective From Date, DateTime YYYY-MM-DD |
The date on which an application is considered effective or valid from.
Specific Information:
The date on which a household member commenced for the social housing waitlist |
DATETIME | - | YYYY-MM-DD(T00:00:00) |
| APPLICANT_EFFECTIVE_TO_DATE | Application: Effective To Date, YYYY-MM-DD |
The date on which an application is considered effective or valid to.
Specific Information:
The date on which a household member ends for the social housing waitlist |
DATETIME | - | YYYY-MM-DD(T00:00:00) |
| HOUSEHOLD_RELATIONSHIP_TYPE | 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) |
| 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) |