Preparing Chintaro Data to run the DCJ Report

Modified on Mon, 31 Jul 2023 at 11:49 AM

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.


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 HeadingDescriptionScreenshot in ChintaroData entry required?
Dwelling IdentifierProperty IDNo - each Property that is added to Chintaro will assume a new auto generated ID.
Unit NoN/AYes - 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 NoN/AYes - Property Screen > Address field.

Chintaro will populate the number of the Property.
Street NameN/AYes - Property Screen > Address field.

Chintaro will populate the name of the address and the street suffix.
Dwelling SuburbN/AYes - Property Screen > City field.
Dwelling PostcodeN/AYes - Property Screen > Postcode field.
LGALocal Government Area
Each Property address has a City. The LGA is entered for each City in System Maintenance> Reference Tables> City> LGA
Number of BedroomsTotal number of bedrooms in PropertyYes - Property Screen > Num Bedrooms field.
Acquisition DateThe date your organisation acquired the Property.Yes - Property Screen > Reporting > Date Acquired field.
Disposal DateThe date your organisation disposed of or handed the Property back.Yes - Property Screen > Returned Date field.
Assistance TypeEither: Affordable Housing, Crisis Accommodation, General Housing, Non-FaCS, Other FaCS, Other Housing NSW, Transitional HousingN/AEach Property is allocated a Program, and is allocated an Assistance Type from the System Maintenance > Reference Tables > Program > Allocation Type table.
Property SourceEither: Capital, FFS, Leasehold, Owned.Yes - Property Screen > Property Source field.
TargetedYes/NoN/ANo - If Target Group field is populated in Property Screen > Target Group, then report will be populated 'Yes'. Else, 'No'. 
Target GroupSector of the community the Property is targeted to.Yes - Property Screen > Target Group field.
Has Nomination RightsYes/No - If a person or organisation has the final say in who is Tenanted in the Property.N/ANo - If 'Nomination Rights' field is populated in Property Screen > Nomination Rights, then report will be populated 'Yes'. Else, 'No'.
Nomination Rights - NameThe 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 - ABNThe Australian Business Number of the person or organisation has the final say in who is Tenanted in the Property.N/AEach 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 NameNot populated from ChintaroN/AN/A
Sublet to ABNNot populated from ChintaroN/AN/A
Sublet DateNot populated from ChintaroN/AN/A
Disability ModificationsAny disability modifications made to the PropertyYes - 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 TypeN/AYes - Property Screen > Property Type field.
Condition SurveyedNot populated from ChintaroN/AN/A
Met StandardsNot populated from ChintaroN/AN/A
Availability StatusNumber of times the room was Vacant Untenantable during the periodN/ANo - auto-calculated by the system.
FaCS ProgramFamily and Community Services ProgramYes - Property screen > Program field.
NRAS FundedNRAS ProgramIf the first 4 letters of the Property Screen > Program is NRAS, then it's Yes, otherwise No
MarketRentTotal amount of Market Rent for the PropertyYes - 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 ReportYes - each NRAS Property screen must have the Market Rent Method entered in the Reporting tab > Market Rent Method field.
Boarding unit or roomRoom Number, if in Boarding HouseYes, Property screen > Rooms section. Only enter if in Boarding House type of property with number on door.
Number of Tenancies at full capacityThe number of Tenantable units in the PropertyNo - Property screen > Rooms section. Chintaro will calculate the total number of Rooms/Tenantable Units.

EG Screenshot shows 2 Rooms at capacity.
Number Rooms UntenantableNumber of Untenantable units in the PropertyNo - 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 HeadingDescriptionScreenshot in ChintaroData Entry Required?
HouseholdIDPrimary Tenant's Client IDNo - each Client that is added to Chintaro will assume a new auto generated ID.
GreatestNeedWas 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 AllocationCurrent Housing Situation Yes - Client Screen > Housing History> Current Housing Situation 
Main Source of IncomeMain income of Primary TenantYes - Client Screen > Income section, and report will take the main source of income of the Primary Tenant.
Main Income at SigningNot populated by ChintaroN/AN/A
Non English SpeakingN/AYes - Client Screen > Demographics section.

If the Primary Tenant's Main Language is not English, it will revert to No.
Main LanguageN/AYes - Client Screen > Demographics section.

Select the Primary Tenant's Main Language from the drop down box.
GrossHHIncomeExclCraTotal weekly income for household excluding Commonwealth Rent Assistance, including non-assessable incomes. N/AYes - 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/AYes - 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.
TotalCRAThe total weekly figure of Commonwealth Rent Assistance the household is allocatedN/A
Income eligibility limitNot populated from ChintaroN/AN/A
HASI CodeHousing and Accommodation Support Initiative Code (for mental illness tenants). Either High, Medium, LowYes - Tenancy Screen > Reporting Tab > CaPMH HASI. Select from drop down list. 
Supported (Y or N)Support Agreement in placeYes - Tenancy Screen > Reporting Tab > CaPMH Support Agreement. Tick this box if this is appropriate.



Residents Worksheet


Column HeadingDescriptionScreenshot in ChintaroData Entry Required?
ResidentIDEither Primary Tenant then Client ID (EG T-12)
or
Related Tenant then Client ID (EG H-110)
N/ANo - auto generated ID.
HouseholdIDPrimary Tenant's Client IDNo - each Client that is added to Chintaro will assume a new auto generated ID.
SLKAn algorithm based on Client's name and date of birth is like a unique codeN/ANo - auto generated ID.
Principal TenantEither Primary Tenant = Yes, or Related Tenant = NoYes - on Client Screen > Primary Tenant = Yes or No tick boxes.
Relationship to PrincipalRelationship to Primary TenantIf Primary Tenant = No, the Relationship to Tenant field must be entered on the Related Tenant's Client screen > General Section.
DOBDate of BirthYes - in the Client Screen > General section > DOB field.
GenderN/AYes - in the Client Screen > General section > Gender drop down box.
IndigenousAboriginal or Torres Strait IslanderYes - Client Screen > Demographics section > Aboriginal or Torres Strait Islander tick box. 
DisabilityStatusN/AYes - Client Screen > General section > Disability drop down list.
Non English BackgroundN/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 LanguageN/AYes - Client Screen > Demographics section > Main Language drop down list.
New member approval dateNot populated by ChintaroN/AN/A
Left HouseholdNot populated by ChintaroN/AN/A
Main Income sourceMain source of income of the Primary TenantYes - Client Screen > Income section. Enter the incomes of the Primary Tenant and the report will populate with the main income. 
Income at signingNot populated by ChintaroN/AN/A
Gross Income LWeekTotal 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 LWeekTotal Income for last week for the household, excluding Non-Accessible incomesNo - auto calculated total after incomes have been entered. 
CRA at signingNot populated by ChintaroN/AN/A
CRACommonwealth Rent Assistance at End Date of reportYes - Client screen > CRA field.




Tenancies Worksheet


Column HeadingDescriptionScreenshot in ChintaroData Entry Required?
TenancyUnitIdTenancy IDNo - each Tenancy that is created in Chintaro will assume a new auto generated ID.
HouseholdIdPrimary Tenant's IDNo - each Primary Tenant that is added to Chintaro will assume a new auto generated ID.
DwellingIdProperty IDNo - each Property that is added to Chintaro will assume a new auto generated ID.
Internal TransferIf the Tenant transferred from 1 Property/Room to another within your organisationYes - Tenancy Screen > Reporting tab > CaPMH Internal Transfer. 

NOTE: Do not tick this box for boarding house moves.
Tenancy TransferIf 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 DateN/AYes - Tenancy Start Date is allocated when Tenancy is created.
Tenancy End DateN/AYes - Vacated Date is entered when a Tenancy is Vacated.
Termination ReasonReason for LeavingYes - Leaving Reason is entered when vacating a Tenancy.

This can be changed in the Tenancy Screen > General Section > Leaving Reason drop down list.
Where NextExit PointYes - 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 CRARent charged for the Room, excluding Commonwealth Rent AssistanceN/AYes - 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 ArrearsRent onlyN/ANo - auto calculated figure.
Non-Rent ArrearsRent arrears of non-rent arrears are ignored. There are only needed for SAFH organisationsN/AN/A
Number Of BedroomsThe number of bedrooms on the property divided by the number of tenanciesNo - auto calculated from Property Screen > Rooms section.
Room NoIf a Rooming House Tenant, this will populate the number the Client was Tenanted in toYes - Rooms screen > Number field must be entered. 
Rent SettingEither Discounted Market Rent, Other, Income BasedN/AThis is determined by the CaPMH Rent Setting on in the System Maintenance > Reference Tables > Program > CaPMH Rent Setting column.



Vacancies Worksheet


Column HeadingDescriptionScreenshot in ChintaroData Entry Required?
Vacancy IdentifierAuto Generated number consisting of Property ID - Date VacatedN/ANo - auto generated ID by report.
Dwelling IdentifierProperty IDNo - each Property that is added to Chintaro will assume a new auto generated ID.
Date vacatedN/AYes - Tenancy Screen > Vacated Date
Date tenantableDate the Room became Vacant Tenantable after last Tenant VacatedN/AN/A
Date 1st offeredNot populated by Chintaro
N/A
N/A
Date tenantedNot populated by ChintaroN/AN/A
Exemption Reason
Not populated by Chintaro
N/AN/A
Exemption agreedNot populated by ChintaroN/AN/A
FaCS Agreement NoNot populated by ChintaroN/AN/A





Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article