What is the CaPMH Report?

The Community and Private Market Housing (CaPMH) Report is a report that New South Wales housing providers must submit to Housing NSW quarterly. The report is populated by fields in Chintaro and is generated through the Reports and Exports > NSW Reports > CaPMH 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 CaPMH 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

Number of BedroomsTotal number of bedrooms in PropertyYes - Property Screen > Num Bedrooms field.
Acquisition DateThe date your organisation acquired the Property.Yes - Property Screen > Online Date field.

NOTE: This date will default to the same day you enter the Property and must be changed to the date you acquired the Property.
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 Name
Not populated from Chintaro
N/A
N/A
Sublet to ABN
Not populated from Chintaro
N/AN/A
Sublet Date
Not populated from Chintaro
N/AN/A
Disability Modifications
Any 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 Type
N/AYes - Property Screen > Property Type field.
Condition Surveyed
Not populated from Chintaro
N/AN/A
Met Standards
Not populated from Chintaro
N/AN/A
Availability Status
Number of times the room was Vacant Untenantable during the periodN/ANo - auto-calculated by the system.
FaCS Program
Family and Community Services ProgramYes - 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 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 room
Room 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 capacity
The 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 Untenantable
Number 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 Heading
Description
Screenshot in Chintaro
Data 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 Tenant
Yes - Client Screen > Income section, and report will take the main source of income of the Primary Tenant.
Main Income at SigningNot populated by Chintaro
N/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.
GrossHHIncomeExclCra
Total 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.
TotalCRA
The total weekly figure of Commonwealth Rent Assistance the household is allocatedN/A

Income eligibility limit
Not populated from ChintaroN/AN/A
HASI Code
Housing 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 Heading
DescriptionScreenshot 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 ID
No - 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 code
N/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. 
DisabilityStatus
N/AYes - 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/AYes - Client Screen > Demographics section > Main Language drop down list.
New member approval date
Not populated by ChintaroN/AN/A
Left Household
Not populated by ChintaroN/AN/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 ChintaroN/AN/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 ChintaroN/AN/A
CRA
Commonwealth Rent Assistance at End Date of reportYes - Client screen > CRA field.




Tenancies Worksheet


Column Heading
Description
Screenshot in Chintaro
Data Entry Required?
TenancyUnitId
Tenancy IDNo - each Tenancy that is created in Chintaro will assume a new auto generated ID.
HouseholdId
Primary Tenant's IDNo - each Primary Tenant that is added to Chintaro will assume a new auto generated ID.
DwellingId
Property 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 Next
Exit 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 CRA
Rent 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 Arrears
Rent only
N/ANo - auto calculated figure.
Non-Rent Arrears
Rent arrears of non-rent arrears are ignored. There are only needed for SAFH organisations
N/AN/A
Number Of Bedrooms
The number of bedrooms on the property divided by the number of tenanciesNo - auto calculated from Property Screen > Rooms section.
Room No
If a Rooming House Tenant, this will populate the number the Client was Tenanted in toYes - Rooms screen > Number field must be entered. 
Rent Setting
Either 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 Heading
DescriptionScreenshot in ChintaroData Entry Required?
Vacancy Identifier
Auto Generated number consisting of Property ID - Date VacatedN/ANo - 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/AYes - Tenancy Screen > Vacated Date
Date tenantable
Date the Room became Vacant Tenantable after last Tenant VacatedN/AN/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