Preparing Chintaro Data to run the DCJ Report

Certain housing providers in New South Wales must submit the DCJ report to Housing NSW quarterly. The report is populated by fields in Chintaro and is generated through the Reports and Exports > NSW Reports > DCJ Report screen.

When exported, the report forms 5 Excel CSV files: Dwellings, Households, Residents, Tenancies and Vacancies. 

This solution explains where the information is populated from Chintaro and into the report.

• What information will Chintaro populate?
• Where does the information in the report come from in Chintaro?
• Dwellings Worksheet
• Households Worksheet
• Residents Worksheet
• Tenancies Worksheet
• Vacancies Worksheet

Sections of the DCJ Report

Each of the CSV files that are exported contain headings in Row 1 that is data populated from Chintaro:

What information will Chintaro populate?

Chintaro will populate every column in the reports, provided you have the correct data entered in to the system before running the report. The Tenancies, Household and Vacancies files will be exported without Client Names for confidentiality. 

Where does the information in the report come from in Chintaro?

Dwellings Worksheet

Column Heading	Description	Screenshot in Chintaro	Data entry required?
Dwelling Identifier	Property ID		No - each Property that is added to Chintaro will assume a new auto generated ID.
Unit No	N/A		Yes - Property Screen > Address field. If a Property is a unit, Chintaro will populate the Unit Number field with whatever is before a slash /  and the street number (EG 1)
Street No	N/A		Yes - Property Screen > Address field. Chintaro will populate the number of the Property.
Street Name	N/A		Yes - Property Screen > Address field. Chintaro will populate the name of the address and the street suffix.
Dwelling Suburb	N/A		Yes - Property Screen > City field.
Dwelling Postcode	N/A		Yes - Property Screen > Postcode field.
LGA	Local Government Area		Each Property address has a City. The LGA is entered for each City in System Maintenance> Reference Tables> City> LGA
Number of Bedrooms	Total number of bedrooms in Property		Yes - Property Screen > Num Bedrooms field.
Acquisition Date	The date your organisation acquired the Property.		Yes - Property Screen > Reporting > Date Acquired field.
Disposal Date	The date your organisation disposed of or handed the Property back.		Yes - Property Screen > Returned Date field.
Assistance Type	Either: Affordable Housing, Crisis Accommodation, General Housing, Non-FaCS, Other FaCS, Other Housing NSW, Transitional Housing	N/A	Each Property is allocated a Program, and is allocated an Assistance Type from the System Maintenance > Reference Tables > Program > Allocation Type table.
Property Source	Either: Capital, FFS, Leasehold, Owned.		Yes - Property Screen > Property Source field.
Targeted	Yes/No	N/A	No - If Target Group field is populated in Property Screen > Target Group, then report will be populated 'Yes'. Else, 'No'.
Target Group	Sector of the community the Property is targeted to.		Yes - Property Screen > Target Group field.
Has Nomination Rights	Yes/No - If a person or organisation has the final say in who is Tenanted in the Property.	N/A	No - If 'Nomination Rights' field is populated in Property Screen > Nomination Rights, then report will be populated 'Yes'. Else, 'No'.
Nomination Rights - Name	The name of the person or organisation has the final say in who is Tenanted in the Property.		Yes - Property Screen > Nomination Rights field.
Nomination Rights - ABN	The Australian Business Number of the person or organisation has the final say in who is Tenanted in the Property.	N/A	Each Nomination Rights agency that is allocated a Nomination Rights field in a Property, can have their ABN entered in the System Maintenance > Reference Tables > Nomination Rights > ABN table.
Sublet to Name	Not populated from Chintaro	N/A	N/A
Sublet to ABN	Not populated from Chintaro	N/A	N/A
Sublet Date	Not populated from Chintaro	N/A	N/A
Disability Modifications	Any disability modifications made to the Property		Yes - Property screen > Disability Modifications tags. Must be one of the following: Fully Modified Bathroom Only Visitable Accessible Adaptable Edited in System Maintenance > Reference Tables > Disability Link
Dwelling Type	N/A		Yes - Property Screen > Property Type field.
Condition Surveyed	Not populated from Chintaro	N/A	N/A
Met Standards	Not populated from Chintaro	N/A	N/A
Availability Status	Number of times the room was Vacant Untenantable during the period	N/A	No - auto-calculated by the system.
FaCS Program	Family and Community Services Program		Yes - Property screen > Program field.
NRAS Funded	NRAS Program		If the first 4 letters of the Property Screen > Program is NRAS, then it's Yes, otherwise No
MarketRent	Total amount of Market Rent for the Property		Yes - Each Property will have at least 1 Room (Tenantable Unit) and the Rent Record will have a Market Rent field that needs to be entered.
Method for determining Market Rent(NRAS)	Either NRAS Compliance, Other, Rent & Sales Report		Yes - each NRAS Property screen must have the Market Rent Method entered in the Reporting tab > Market Rent Method field.
Boarding unit or room	Room Number, if in Boarding House		Yes, Property screen > Rooms section. Only enter if in Boarding House type of property with number on door.
Number of Tenancies at full capacity	The number of Tenantable units in the Property		No - Property screen > Rooms section. Chintaro will calculate the total number of Rooms/Tenantable Units. EG Screenshot shows 2 Rooms at capacity.
Number Rooms Untenantable	Number of Untenantable units in the Property		No - Property screen > Rooms section. Chintaro will calculate the number of Rooms/Units that are Untenantable. EG Screenshot shows 1 untenantable Room at time of reporting.

Households Worksheet

Column Heading	Description	Screenshot in Chintaro	Data Entry Required?
HouseholdID	Primary Tenant's Client ID		No - each Client that is added to Chintaro will assume a new auto generated ID.
GreatestNeed	Was the household in the Greatest Need?		Yes - Tenancy Screen > Reporting Tab. NOTE: This field will default to ticked as it is assumed the household was in the greatest need of housing when allocated.
Housing Status at Allocation	Current Housing Situation		Yes - Client Screen > Housing History> Current Housing Situation
Main Source of Income	Main income of Primary Tenant		Yes - Client Screen > Income section, and report will take the main source of income of the Primary Tenant.
Main Income at Signing	Not populated by Chintaro	N/A	N/A
Non English Speaking	N/A		Yes - Client Screen > Demographics section. If the Primary Tenant's Main Language is not English, it will revert to No.
Main Language	N/A		Yes - Client Screen > Demographics section. Select the Primary Tenant's Main Language from the drop down box.
GrossHHIncomeExclCra	Total weekly income for household excluding Commonwealth Rent Assistance, including non-assessable incomes.	N/A	Yes - All Incomes for each Client must be entered in the Client Screen > Income Section or by using CCeS. This includes non accessible incomes (EG Clean Energy Supplement). Chintaro will calculate the total weekly income excluding CRA.
GrossAssessHHIncome ExclCra	Total weekly income for household excluding Commonwealth Rent Assistance, excluding non-assessable incomes.	N/A	Yes - All Incomes for each Client must be entered in the Client Screen > Income Section or by using CCeS. Each income must have the 'Accessible?' box ticked if it is an accessible income. Chintaro will calculate the total weekly accessible income excluding CRA.
TotalCRA	The total weekly figure of Commonwealth Rent Assistance the household is allocated	N/A
Income eligibility limit	Not populated from Chintaro	N/A	N/A
HASI Code	Housing and Accommodation Support Initiative Code (for mental illness tenants). Either High, Medium, Low		Yes - Tenancy Screen > Reporting Tab > CaPMH HASI. Select from drop down list.
Supported (Y or N)	Support Agreement in place		Yes - Tenancy Screen > Reporting Tab > CaPMH Support Agreement. Tick this box if this is appropriate.

Residents Worksheet

Column Heading	Description	Screenshot in Chintaro	Data Entry Required?
ResidentID	Either Primary Tenant then Client ID (EG T-12) or Related Tenant then Client ID (EG H-110)	N/A	No - auto generated ID.
HouseholdID	Primary Tenant's Client ID		No - each Client that is added to Chintaro will assume a new auto generated ID.
SLK	An algorithm based on Client's name and date of birth is like a unique code	N/A	No - auto generated ID.
Principal Tenant	Either Primary Tenant = Yes, or Related Tenant = No		Yes - on Client Screen > Primary Tenant = Yes or No tick boxes.
Relationship to Principal	Relationship to Primary Tenant		If Primary Tenant = No, the Relationship to Tenant field must be entered on the Related Tenant's Client screen > General Section.
DOB	Date of Birth		Yes - in the Client Screen > General section > DOB field.
Gender	N/A		Yes - in the Client Screen > General section > Gender drop down box.
Indigenous	Aboriginal or Torres Strait Islander		Yes - Client Screen > Demographics section > Aboriginal or Torres Strait Islander tick box.
DisabilityStatus	N/A		Yes - Client Screen > General section > Disability drop down list.
Non English Background	N/A		Yes - Client Screen > Demographics section. If the proficiency Spoken English is not set to 'Good', it is assumed Yes to Non English Speaking Background.
Main Language	N/A		Yes - Client Screen > Demographics section > Main Language drop down list.
New member approval date	Not populated by Chintaro	N/A	N/A
Left Household	Not populated by Chintaro	N/A	N/A
Main Income source	Main source of income of the Primary Tenant		Yes - Client Screen > Income section. Enter the incomes of the Primary Tenant and the report will populate with the main income.
Income at signing	Not populated by Chintaro	N/A	N/A
Gross Income LWeek	Total Income for last week for the household, including Non-Accessible incomes less rent assistance.		No - auto calculated total after incomes have been entered.
Assessable Income LWeek	Total Income for last week for the household, excluding Non-Accessible incomes		No - auto calculated total after incomes have been entered.
CRA at signing	Not populated by Chintaro	N/A	N/A
CRA	Commonwealth Rent Assistance at End Date of report		Yes - Client screen > CRA field.

Tenancies Worksheet

Column Heading	Description	Screenshot in Chintaro	Data Entry Required?
TenancyUnitId	Tenancy ID		No - each Tenancy that is created in Chintaro will assume a new auto generated ID.
HouseholdId	Primary Tenant's ID		No - each Primary Tenant that is added to Chintaro will assume a new auto generated ID.
DwellingId	Property ID		No - each Property that is added to Chintaro will assume a new auto generated ID.
Internal Transfer	If the Tenant transferred from 1 Property/Room to another within your organisation		Yes - Tenancy Screen > Reporting tab > CaPMH Internal Transfer.  NOTE: Do not tick this box for boarding house moves.
Tenancy Transfer	If the Tenant has transferred to your organisation from Public Housing or another Community Housing provider.		Yes - Tenancy Screen > Reporting tab > CaPMH Transfer from Public Housing or another CH Provider drop down list.
Tenancy Start Date	N/A		Yes - Tenancy Start Date is allocated when Tenancy is created.
Tenancy End Date	N/A		Yes - Vacated Date is entered when a Tenancy is Vacated.
Termination Reason	Reason for Leaving		Yes - Leaving Reason is entered when vacating a Tenancy. This can be changed in the Tenancy Screen > General Section > Leaving Reason drop down list.
Where Next	Exit Point		Yes - Exit Point is entered when vacating a Tenancy. This can be changed in the Tenancy Screen > General Section > Exit Point drop down list.
Rent Charged Excl CRA	Rent charged for the Room, excluding Commonwealth Rent Assistance	N/A	Yes - the report gets the rent charged, less the service fee (if that's included). See System Maintenance > Preferences > Finance > Generate Service Fee, and includes MaxCRA if the box is ticked on the form. The MAX CRA is determined by looking at the CRA record on the Client.
Rent Arrears	Rent only	N/A	No - auto calculated figure.
Non-Rent Arrears	Rent arrears of non-rent arrears are ignored. There are only needed for SAFH organisations	N/A	N/A
Number Of Bedrooms	The number of bedrooms on the property divided by the number of tenancies		No - auto calculated from Property Screen > Rooms section.
Room No	If a Rooming House Tenant, this will populate the number the Client was Tenanted in to		Yes - Rooms screen > Number field must be entered.
Rent Setting	Either Discounted Market Rent, Other, Income Based	N/A	This is determined by the CaPMH Rent Setting on in the System Maintenance > Reference Tables > Program > CaPMH Rent Setting column.

Vacancies Worksheet

Column Heading	Description	Screenshot in Chintaro	Data Entry Required?
Vacancy Identifier	Auto Generated number consisting of Property ID - Date Vacated	N/A	No - auto generated ID by report.
Dwelling Identifier	Property ID		No - each Property that is added to Chintaro will assume a new auto generated ID.
Date vacated	N/A		Yes - Tenancy Screen > Vacated Date
Date tenantable	Date the Room became Vacant Tenantable after last Tenant Vacated	N/A	N/A
Date 1st offered	Not populated by Chintaro	N/A	N/A
Date tenanted	Not populated by Chintaro	N/A	N/A
Exemption Reason	Not populated by Chintaro	N/A	N/A
Exemption agreed	Not populated by Chintaro	N/A	N/A
FaCS Agreement No	Not populated by Chintaro	N/A	N/A