| TENANCY_REF |
Tenancy: Tenancy Reference Number, Identifier N(10) |
- |
- |
- |
- |
- |
| TENANCY_START_DATE |
Dwelling: Rent Start Date, YYYY-MM-DD |
- |
- |
- |
- |
- |
| TENANCY_END_DATE |
Tenancy: Tenancy End Date, YYYY-MM-DD |
- |
- |
- |
- |
- |
| CLIENT_REF |
Person: Client Reference, Number N(7) |
- |
- |
- |
- |
- |
| TENANT_EFF_FROM_DATE |
Person: Tenancy Start Date, YYYY-MM-DD |
- |
- |
- |
- |
- |
| TENANT_EFF_TO_DATE |
Person: Tenancy End Date, YYYY-MM-DD |
- |
- |
- |
- |
- |
| HOUSEHOLD_RELATION_TYPE_BK |
Person: Relationship Type, DCJ-H Code A(10) |
- |
- |
- |
- |
- |
| HOUSEHOLD_RELATION_TYPE_NAME |
Person: Relationship Type, DCJ-H Code A(10) |
- |
- |
- |
- |
- |
| FORENAME |
Person: Given Name, Text X(50) |
- |
- |
- |
- |
- |
| SURNAME |
Person: Family Name, Text X(50) |
- |
- |
- |
- |
- |
| PROPERTY_REF |
Dwelling: Property reference number, Identifier X(15) |
- |
- |
- |
- |
- |
| INGESTTIME |
Record: DateTime Stamp, YYYY-MM-DD |
- |
- |
- |
- |
- |
| INGESTTYPE |
Record: Ingest Type, Label A(6) |
- |
- |
- |
- |
- |
| FILENAME |
Record: Filename, Text X(200) |
- |
- |
- |
- |
- |
| BATCHID |
Record: Batch Id, Text X(200) |
- |
- |
- |
- |
- |
| EXTRACT_ID |
Record: Identifier, N(8) |
- |
- |
- |
- |
- |
| EXTRACT_DATE |
Record: Report Extraction Date, YYYY-MM-DD |
- |
- |
- |
- |
- |