Crystal M3PP Fields Dictionary

Crystal M3PP Fields DictionaryVol 3

by Stephen Tribbick © Started 1st November 2007 and getting better every year.

This is the 20/7/13 version. The various pink bits are queries I need to resolve.

I’d love to hear your constructive suggestions – please email me at .

Vol 1 = Property, Worksheets & general stuff

Vol 2 = Food, HSW, ID, Licensing

Vol 3 = Housing, Grants and Empty Homes

Vol 4 = Other Environmental Health

Vol 5 = Monitor / Waste disposal

Vol 6 = Trading standards

This guide has been produced to help fellow users produce their own Crystal Reports. It aims to show some commonly used M3 screens, then lists many of the 10,000 view fields used on it, including aliases, and if applicable, the code set used and any notes that will help. Hopefully you can just use copy & paste to use the field names in your formulae.

This document is just one of the added extras I deliver on my Crystal training courses that make them great (visit for further details)

HEALTH WARNING
This edition has field details for the Oracle version of version 8.18 but some of the screenshots are from earlier versions
None of this has been checked by Northgate experts yet, so it is bound to contain errors and omissions.
Sorry!
Note also that some fields will vary with your own system configuration, and if you run the SQL version
so always check your reports for accuracy against your own data.

VOLUME 3Housing, Grants and Empty Homes

1

Private Sector Housing Worksheet (HG).....

PSH Details......

Source......

Progress......

Fitness......

Costs (1)......

Costs (2)......

Cost summary......

Contractors / Payments......

Grant assistance......

Schedule......

Actions......

User defined......

Grant revisions......

?????????????......

New in 8.11 – awaiting placement

HGI Housing inspections......

Dwelling......

Occupancy......

Hazards......

HGIHAZ......

HGIHAZIMG......

HGI Hazard location......

HGI hazard loclkh......

Decent Homes B......

Decent Homes C and D......

Energy......

Actions......

User defined......

VSHM HMO Inspections......

Inspections......

Activities......

Schedule......

Actions......

HMO Component......

Details......

Other fields available......

Property attributes......

HMO Questions......

Fitness......

General......

Numbers......

Judgements......

HMO Inspection component summary......

Empty Homes......

Case progress......

Property......

Priority......

Finance......

Back into use......

1

Private Sector Housing Worksheet (HG)

These fields on the first tab are generally available in the generic WORKSHEETS table and in the relevant application specific worksheet table eg GRANTS. Other applications will have an identical list of fields for this first tab – just substitute the table name. See Vol 1.

PSH Details

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Assistance type / {PPV_GRANTS.GRTYPE}
{PPV_GRANTS.GRTYPEDESC} / Mirror code associated with TASK
Renewal area / {PPV_GRANTS.RENEWCODE}
{PPV_GRANTS.RENEWCODEDESC}
Premises type / {PPV_GRANTS.PREMTYPE}
{PPV_GRANTS.PREMTYPEDESC}
Year of construction / {PPV_GRANTS.YEAR}
{PPV_PROPERTY.YEAR} / Copied from trader tab for property
Rel person / See SOURCE_1 table below / Link with WORKID
Date of birth / {PPV_GRANTS.DOB}
Age / {PPV_GRANTS.APPAGE}
NI number / {PPV_GRANTS.NINUMBER}
Disabled / {PPV_GRANTS.DISABLED}
Elderly / {PPV_GRANTS.ELDERLY}
Benefit / {PPV_GRANTS.BENEFIT}
Benefit type / {PPV_GRANTS.BENTYPE}
{PPV_GRANTS.BENTYPEDESC}
Status / {PPV_GRANTS.APPSTATUS}
{PPV_GRANTS.APPSTATUSDESC}
Category / {PPV_GRANTS.GRCATEG}
{PPV_GRANTS.GRCATEGDESC}
Priority / {PPV_GRANTS.PRIORITY}
Resident since / {PPV_GRANTS.RESIDENT}
Qualified: construction (10 yrs) / {PPV_GRANTS.QUALTEN}
Residency / {PPV_GRANTS.QUALRES}
Estimated cost of works / {PPV_GRANTS.ECSTWK}
Land charges removed / {PPV_GRANTS.LCREMOVED}

Source

SOURCE_1 = applicant / relevant person source entered on first tab of worksheet

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
{PPV_SOURCEADDR_1.WORKID}
{PPV_SOURCEADDR_1.SUBKEY}
{PPV_SOURCEADDR_1.RECTYPE}
{PPV_SOURCEADDR_1.SRCFULLADDR}
{PPV_SOURCEADDR_1.SRCTRADNAME}
{PPV_SOURCEADDR_1.SRCADDR1}
{PPV_SOURCEADDR_1.SRCADDR2}
{PPV_SOURCEADDR_1.SRCADDR3}
{PPV_SOURCEADDR_1.SRCADDR4}
{PPV_SOURCEADDR_1.SRCADDR5}
{PPV_SOURCEADDR_1.SRCADDR6}
{PPV_SOURCEADDR_1.SRCADDR7}
{PPV_SOURCEADDR_1.SRCADDR8}
{PPV_SOURCEADDR_1.SRCPOSTCD}
{PPV_SOURCEADDR_1.SRCTITLE}
{PPV_SOURCEADDR_1.SRCINITIALS}
{PPV_SOURCEADDR_1.SRCFIRSTNAME}
{PPV_SOURCEADDR_1.SRCFAMILYNAME}
{PPV_SOURCEADDR_1.SRCFULLNAME1} / Title + Family name
{PPV_SOURCEADDR_1.SRCFULLNAME2} / Initials + Family name
{PPV_SOURCEADDR_1.SRCFULLNAME3} / First name + Family name
{PPV_SOURCEADDR_1.SRCJOBTITLE}
{PPV_SOURCEADDR_1.SRCTELH}
{PPV_SOURCEADDR_1.SRCTELW}
{PPV_SOURCEADDR_1.SRCMOBILE}
{PPV_SOURCEADDR_1.SRCFAX}
{PPV_SOURCEADDR_1.SRCEMAIL}
{PPV_SOURCEADDR_1.SRCSTATUS}
{PPV_SOURCEADDR_1.SRCCONTYPE}
{PPV_SOURCEADDR_1.SRCCONTYPEDESC}
{PPV_SOURCEADDR_1.SRCETHNICITY}
{PPV_SOURCEADDR_1.SRCETHNICITYDESC}
{PPV_SOURCEADDR_1.SRCQUESTIONNAIRE}
{PPV_SOURCEADDR_1.SRCDOB}

Progress

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Initial date / {PPV_GRANTS.DTINIT}
Approved / {PPV_GRANTS.DTAPPR}
Approved expiry / {PPV_GRANTS.DTAPPREXP}
Test of resources / {PPV_GRANTS.DTTEST}
Commenced / {PPV_GRANTS.DTCOMM}
Contribution / {PPV_GRANTS.CONTRIB}
Claim / {PPV_GRANTS.DTCLAIM}
Inspection / {PPV_GRANTS.DTINSP}
Completion / {PPV_GRANTS.DTCMPLTD}
Schedule / {PPV_GRANTS.DTSCHD}
Closed / {PPV_GRANTS.DTCLOSED}
Reason / {PPV_GRANTS.CLREASON}
{PPV_GRANTS.CLREASONDESC}
Application Received / {PPV_GRANTS.DTAPLRECD}
Application made / {PPV_GRANTS.DTAPLMADE}
Next review / {PPV_GRANTS.DTNREV}
Application expiry / {PPV_GRANTS.DTAPLEXP}
PSH reference / {PPV_GRANTS.GRANTREF}
Cleared / {PPV_GRANTS.DTCLRD}
Repayment date / {PPV_GRANTS.DTREPAY}
Repayment action / {PPV_GRANTS.ACTREPAY}
{PPV_GRANTS.ACTREPAYDESC}
Repayment value / {PPV_GRANTS.VALREPAY}

Fitness

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
S352
{PPV_GRANTS.S352FIT1}
{PPV_GRANTS.S352FIT2}
{PPV_GRANTS.S352FIT3}
{PPV_GRANTS.S352FIT4}
S604
{PPV_GRANTS.S604FIT1}
{PPV_GRANTS.S604FIT2}
{PPV_GRANTS.S604FIT3}
{PPV_GRANTS.S604FIT4}
{PPV_GRANTS.S604FIT5}
{PPV_GRANTS.S604FIT6}
{PPV_GRANTS.S604FIT7}
{PPV_GRANTS.S604FIT8}
{PPV_GRANTS.S604FIT9}
{PPV_GRANTS.S604FIT10}
{PPV_GRANTS.S604FIT11}
{PPV_GRANTS.S604FIT12}
{PPV_GRANTS.S604FIT13}
{PPV_GRANTS.S604FIT14}
Priority ratings
Rating 1 / {PPV_GRANTS.SCR1} / NB labels will changed by system config
{PPV_GRANTS.SCR2}
{PPV_GRANTS.SCR3}
{PPV_GRANTS.SCR4}
{PPV_GRANTS.SCR5}
{PPV_GRANTS.SCR6}
{PPV_GRANTS.SCR7}
{PPV_GRANTS.SCR8}
{PPV_GRANTS.SCR9}
{PPV_GRANTS.SCR10}
{PPV_GRANTS.SCR11}
{PPV_GRANTS.SCR12}
Total / {PPV_GRANTS.SCRTOT}
Property fit / {PPV_GRANTS.PROPFIT}
S352 fit / {PPV_GRANTS.S352FIT}
S604(1) fit / {PPV_GRANTS.S6041FIT}
S604(2) fit / {PPV_GRANTS.S6042FIT}
Lead pipes / {PPV_GRANTS.LEADPIPES}
Radon present / {PPV_GRANTS.RADON}

Costs (1)

This COSTS (1) tab is only used where the grant is non HRA.

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Revision reason / {PPV_GRANTS.REVISRSN}
{PPV_GRANTS.REVISRSNDESC}
Pay discretionary / {PPV_GRANTS.PAYDISC}
Overestimate / {PPV_GRANTS.OVEREST}
LA Costs – Mandatory A
Cost of works / {PPV_GRANTS.ACSTWK}
Other fees / {PPV_GRANTS.ACSTHD}
Agency fees / {PPV_GRANTS.AFEES}
Sub total / {PPV_GRANTS.ASUB}
VAT (Works) / {PPV_GRANTS.AVATWK}
VAT (Fees) / {PPV_GRANTS.AVATHD}
Total Amount / {PPV_GRANTS.ATOT}
LA Costs – Discretionary B
Cost of works / {PPV_GRANTS.BCSTWK}
Other fees / {PPV_GRANTS.BCSTHD}
Agency fees / {PPV_GRANTS.BFEES}
Sub total / {PPV_GRANTS.BSUB}
VAT (Works) / {PPV_GRANTS.BVATWK}
VAT (Fees) / {PPV_GRANTS.BVATHD}
Total Amount / {PPV_GRANTS.BTOT}
Applicant Costs – Mandatory C
Cost of works / {PPV_GRANTS.CCSTWK}
Other fees / {PPV_GRANTS.CCSTHD}
Agency fees / {PPV_GRANTS.CFEES}
Sub total / {PPV_GRANTS.CSUB}
VAT (Works) / {PPV_GRANTS.CVATWK}
VAT (Fees) / {PPV_GRANTS.CVATHD}
Total Amount / {PPV_GRANTS.CTOT}
Applicant Costs – Discretionary D
Cost of works / {PPV_GRANTS.DCSTWK}
Other fees / {PPV_GRANTS.DCSTHD}
Agency fees / {PPV_GRANTS.DFEES}
Sub total / {PPV_GRANTS.DSUB}
VAT (Works) / {PPV_GRANTS.DVATWK}
VAT (Fees) / {PPV_GRANTS.DVATHD}
Total Amount / {PPV_GRANTS.DTOT}
Applicant Costs – Non-eligible
Cost of works / {PPV_GRANTS.NCSTWK}
Other fees / {PPV_GRANTS.NCSTHD}
Agency fees / {PPV_GRANTS.NFEES}
Sub total / {PPV_GRANTS.NSUB}
VAT (Works) / {PPV_GRANTS.NVATWK}
VAT (Fees) / {PPV_GRANTS.NVATHD}
Total Amount / {PPV_GRANTS.NTOT}
Selected cost
A+B / {PPV_GRANTS.APLUSB}
C+D / {PPV_GRANTS.CPLUSD}
LA/Applicant / {PPV_GRANTS.LAORAP}

Costs (2)

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Eligible expense
Mandatory / {PPV_GRANTS.ELIGEXPM}
Discretion / {PPV_GRANTS.ELIGEXPD}
Total / {PPV_GRANTS.ELIGTOT}
Limits:
Standard / {PPV_GRANTS.LIMITM}
Discretion / {PPV_GRANTS.LIMITD}
Eligible value
Mandatory / {PPV_GRANTS.ELIGVALM}
Discretion / {PPV_GRANTS.ELIGVALD}
Total / {PPV_GRANTS.ELIGVALTOT}
Calculation
Eligible value / {PPV_GRANTS.ELIGVALTOT} / ?? same as previous
Applicant's costs / {PPV_GRANTS.APPCOST}
Less contribution / {PPV_GRANTS.NOTLOAN}
Less grant value
Less non-grant assistance / {PPV_GRANTS.NGASST}
% nga / {PPV_GRANTS.NGASSTPER}
Less assistance
Grant value / {PPV_GRANTS.GRVALUE}
%gv / {PPV_GRANTS.GRPER}
Actual costs / {PPV_GRANTS.ACTCOST}

Cost summary

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Cost of works
Mandatory / {PPV_GRANTS.MANCSTWK}
Discretionary / {PPV_GRANTS.DISCSTWK}
Eligible total / {PPV_GRANTS.ELIGCSTWK}
Non-eligible total
Total / {PPV_GRANTS.TOTCSTWK}
Other fees
Mandatory / {PPV_GRANTS.MANCSTHD}
Discretionary / {PPV_GRANTS.DISCSTHD}
Eligible total / {PPV_GRANTS.ELIGCSTHD}
Non-eligible total
Total / {PPV_GRANTS.TOTCSTHD}
Agency fees
Mandatory / {PPV_GRANTS.MANFEES}
Discretionary / {PPV_GRANTS.DISFEES}
Eligible total / {PPV_GRANTS.ELIGFEES}
Non-eligible total
Total / {PPV_GRANTS.TOTFEES}
Sub total
Mandatory / {PPV_GRANTS.MANSUB}
Discretionary / {PPV_GRANTS.DISSUB}
Eligible total / {PPV_GRANTS.ELIGSUB}
Non-eligible total
Total / {PPV_GRANTS.TOTSUB}
VAT works
Mandatory / {PPV_GRANTS.MANVATWK}
Discretionary / {PPV_GRANTS.DISVATWK}
Eligible total / {PPV_GRANTS.ELIGVATWK}
Non-eligible total
Total / {PPV_GRANTS.TOTVATWK}
VAT fees
Mandatory / {PPV_GRANTS.MANVATHD}
Discretionary / {PPV_GRANTS.DISVATHD}
Eligible total / {PPV_GRANTS.ELIGVATHD}
Non-eligible total
Total / {PPV_GRANTS.TOTVATHD}
Total amount
Mandatory / {PPV_GRANTS.MANTOT}
Discretionary / {PPV_GRANTS.DISTOT}
Eligible total / {PPV_GRANTS.ELIGTOT}
Non-eligible total
Total / {PPV_GRANTS.TOTTOT}
Summary
Applicant costs
Non-eligible costs
Assistance
Contribution / {PPV_GRANTS.NOTLOAN}
Excess: grant limit / {PPV_GRANTS.EXCESSLIMIT}
Authority details
VAT reclaim / {PPV_GRANTS.VATRECLAIM}
Net cost / {PPV_GRANTS.NETCOST}

Contractors / Payments

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
{PPV_GRANT_CONTRACTORS.WORKID}
{PPV_GRANT_CONTRACTORS.SEQNO}
Contractor / {PPV_HGCONTRACTORS_ADDRESS.ADDR1}
{PPV_HGCONTRACTORS_ADDRESS.ADDR2}
{PPV_HGCONTRACTORS_ADDRESS.ADDR3}
{PPV_HGCONTRACTORS_ADDRESS.ADDR4}
{PPV_HGCONTRACTORS_ADDRESS.ADDR5}
{PPV_HGCONTRACTORS_ADDRESS.ADDR6}
{PPV_HGCONTRACTORS_ADDRESS.POSTCODE}
{PPV_HGCONTRACTORS_ADDRESS.RELEMAIL}
{PPV_HGCONTRACTORS_ADDRESS.RELTEL}
{PPV_HGCONTRACTORS_ADDRESS.RELSEARCH} / Link
{PPV_GRANT_CONTRACTORS.ADDRID} to {PPV_HGCONTRACTORS
_ADDRESS.ADDRID}
Type / {PPV_GRANT_CONTRACTORS.RELTYPE}
{PPV_GRANT_CONTRACTORS.RELTYPEDESC}
Sch costs / {PPV_GRANT_CONTRACTORS.SCHEDCOSTS}
N-S costs / {PPV_GRANT_CONTRACTORS.NONSCHEDCOSTS}
Total / {PPV_GRANT_CONTRACTORS.TOTCONTCOSTS}
Approved / {PPV_GRANT_CONTRACTORS.APPROVEDCOSTS}
Paid / {PPV_GRANT_CONTRACTORS.AMTPAID}
O/S / {PPV_GRANT_CONTRACTORS.AMTOS}
Involvement / {PPV_GRANT_CONTRACTORS.INVOLVEMENT}
SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
{PPV_GRANT_PAYMENTS.WORKID}
{PPV_GRANT_PAYMENTS.ACTIONPKEY}
Payee type / {PPV_GRANT_PAYMENTS.PAYEETYPE}
{PPV_GRANT_PAYMENTS.PAYEETYPEDESC}
Total O/S
Contractor O/S
Payee
Payment type / {PPV_GRANT_PAYMENTS.PAYMENTTYPE}
{PPV_GRANT_PAYMENTS.PAYMENTTYPEDESC}
Invoice ref / {PPV_GRANT_PAYMENTS.INVOICEREF}
Value / {PPV_GRANT_PAYMENTS.VALUE}
Invoice date / {PPV_GRANT_PAYMENTS.INVOICEDATE}
Officer / {PPV_GRANT_PAYMENTS.OFFICER}
{PPV_GRANT_PAYMENTS.OFFICERDESC}
Payment date / {PPV_GRANT_PAYMENTS.PAYMENTDATE}
Comment / {PPV_GRANT_PAYMENTS.COMMENTS}
Authorised by / {PPV_GRANT_PAYMENTS.AUTHBY}
{PPV_GRANT_PAYMENTS.AUTHBYDESC}
Authorised date / {PPV_GRANT_PAYMENTS.AUTHDATE}
Time / {PPV_GRANT_PAYMENTS.AUTHTIME}
CONTRELADDRID / {PPV_GRANT_PAYMENTS.CONTRELADDRID} / NUMBER(22)
COUNTER / {PPV_GRANT_PAYMENTS.COUNTER} / NUMBER(22)
GRPYMNT / {PPV_GRANT_PAYMENTS.GRPYMNT} / NUMBER(22)
NONGRACTIONPKEY / {PPV_GRANT_PAYMENTS.NONGRACTIONPKEY} / NUMBER(22)
NONGRPYMNT / {PPV_GRANT_PAYMENTS.NONGRPYMNT} / NUMBER(22)

Grant assistance

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Non-Grant Direct Assistance
WORKID / {PPV_GRANT_ASSISTANCE.WORKID} / Link by WorkID
RECNO / {PPV_GRANT_ASSISTANCE.RECNO}
Provider / {PPV_GRANT_ASSISTANCE.PROVIDER}
{PPV_GRANT_ASSISTANCE.PROVIDERDESC}
{PPV_GRANT_ASSISTANCE.ADDR1}
{PPV_GRANT_ASSISTANCE.ADDR2}
{PPV_GRANT_ASSISTANCE.ADDR3}
{PPV_GRANT_ASSISTANCE.ADDR4}
{PPV_GRANT_ASSISTANCE.ADDR5}
{PPV_GRANT_ASSISTANCE.POSTCODE}
Type / {PPV_GRANT_ASSISTANCE.PROVTYPE}
{PPV_GRANT_ASSISTANCE.PROVTYPEDESC}
Date / {PPV_GRANT_ASSISTANCE.DTPROV}
Amount / {PPV_GRANT_ASSISTANCE.AMOUNT}
Comments / {PPV_GRANT_ASSISTANCE.COMMENTS}
Closed / {PPV_GRANT_ASSISTANCE.DTCLOSED}
Reason / {PPV_GRANT_ASSISTANCE.REASON}
{PPV_GRANT_ASSISTANCE.REASONDESC}

Schedule

See Vol 1. Link with WORKID

Actions

See Vol 1

User defined

See Vol 1

Grant revisions

DTREVIS / {PPV_GRANT_REVISIONS.DTREVIS}
NEWVAL / {PPV_GRANT_REVISIONS.NEWVAL}
RSNREVIS / {PPV_GRANT_REVISIONS.RSNREVIS}
RSNREVISDESC / {PPV_GRANT_REVISIONS.RSNREVISDESC}
VALDIFF / {PPV_GRANT_REVISIONS.VALDIFF}
VALREVIS / {PPV_GRANT_REVISIONS.VALREVIS}
WORKID / {PPV_GRANT_REVISIONS.WORKID}

?????????????

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Revision reason / {PPV_GRANTS.HRAREVISRSN}
{PPV_GRANTS.HRAREVISRSNDESC}
Cost of materials / {PPV_GRANTS.COSTMAT}
LA Costs
Cost of works / {PPV_GRANTS.LACOSTWK}
Fees / {PPV_GRANTS.LAFEE}
Total costs / {PPV_GRANTS.LATOTC}
VAT / {PPV_GRANTS.LAVAT}
Total amount / {PPV_GRANTS.LATOTAL}
Actual costs
Cost of works / {PPV_GRANTS.ACCOSTWK}
Fees / {PPV_GRANTS.ACFEE}
Total costs / {PPV_GRANTS.ACTOTC}
VAT / {PPV_GRANTS.ACVAT}
Total amount / {PPV_GRANTS.ACTOTAL}
Assistance value / {PPV_GRANTS.ASSVALUE}
Grant calculation
3 year limit / System config
Less previous / {PPV_GRANTS.LESSPREV}
Remainder (a) / {PPV_GRANTS.REMAIND}
Lesser of (a) and single grant limit
=Maximum grant / {PPV_GRANTS.MAXGRANT}
Less cost of materials / {PPV_GRANTS.COSTMAT}
Max available assistance / {PPV_GRANTS.MAXAVAIL}
Assistance value / {PPV_GRANTS.ASSVALUE}
Cost of materials / {PPV_GRANTS.COSTMAT}
Total grant / {PPV_GRANTS.TOTGRANT}

Fields not yet assigned –? right click

{PPV_GRANTS.AMNTPAID}
{PPV_GRANTS.CMPLTDTKN}
{PPV_GRANTS.COMPID}
{PPV_GRANTS.GRANTVALUE}
{PPV_GRANTS.GRPLUSASST}
{PPV_GRANTS.LIMIT1}
{PPV_GRANTS.LIMIT2}
{PPV_GRANTS.OUTSTANDING}
{PPV_GRANTS.PAYBY}
{PPV_GRANTS.PAYCOMMENT}
{PPV_GRANTS.PAYDATE}
{PPV_GRANTS.PAYVALUE}
{PPV_GRANTS.STATUS}

New in 8.11 – awaiting placement

AWAITINGPAYMENT / {PPV_GRANTS.AWAITINGPAYMENT} / VARCHAR2(1)
GRSTAGE / {PPV_GRANTS.GRSTAGE} / NUMBER(22)
GRSTAGEDESC / {PPV_GRANTS.GRSTAGEDESC} / VARCHAR2(30)
NONGROS / {PPV_GRANTS.NONGROS} / NUMBER(22)
NONGRPAID / {PPV_GRANTS.NONGRPAID} / NUMBER(22)
NONGRTOTPYBL / {PPV_GRANTS.NONGRTOTPYBL} / NUMBER(22)
TOTOS / {PPV_GRANTS.TOTOS} / NUMBER(22)
TOTPAID / {PPV_GRANTS.TOTPAID} / NUMBER(22)
TOTPYBL / {PPV_GRANTS.TOTPYBL} / NUMBER(22)

HGI Housing inspections

These fields on the first tab are generally available in the generic WORKSHEETS table and in the relevant application specific worksheet table eg HGI. Other applications will have an identical list of fields for this first tab – just substitute the table name. See Vol 1.

{PPV_HGINSP.ACTAPPLSET}
{PPV_HGINSP.ACTAPPLSETTM}
{PPV_HGINSP.ACTCMPLTD}
{PPV_HGINSP.ACTCMPLTDTM}
{PPV_HGINSP.ADDR1}
{PPV_HGINSP.ADDR2}
{PPV_HGINSP.ADDR3}
{PPV_HGINSP.ADDR4}
{PPV_HGINSP.ADDR5}
{PPV_HGINSP.ADDR6}
{PPV_HGINSP.ADDR7}
{PPV_HGINSP.ADDR8}
{PPV_HGINSP.APPLICATION}
{PPV_HGINSP.APPLICATIONDESC}
{PPV_HGINSP.AREA}
{PPV_HGINSP.AREADESC}
{PPV_HGINSP.COMPID}
{PPV_HGINSP.DEPARTMENT}
{PPV_HGINSP.DEPARTMENTDESC}
{PPV_HGINSP.DETAILS}
{PPV_HGINSP.DTALLOC}
{PPV_HGINSP.DTAMEND}
{PPV_HGINSP.DTCREATE}
{PPV_HGINSP.DTRECD}
{PPV_HGINSP.FULLADDR}
{PPV_HGINSP.MESSAGE}
{PPV_HGINSP.METHOD}
{PPV_HGINSP.METHODDESC}
{PPV_HGINSP.NEXTTASK}
{PPV_HGINSP.NEXTTASKDESC}
{PPV_HGINSP.NEXTTASKDUE}
{PPV_HGINSP.OFFICER}
{PPV_HGINSP.OFFICERDESC}
{PPV_HGINSP.OFFICERDESIG}
{PPV_HGINSP.OFFICEREMAIL}
{PPV_HGINSP.OFFICERREF}
{PPV_HGINSP.OFFICERTEL}
{PPV_HGINSP.OUTCOME}
{PPV_HGINSP.OUTCOMEDESC}
{PPV_HGINSP.PARISH}
{PPV_HGINSP.POSNREF}
{PPV_HGINSP.POSTCD}
{PPV_HGINSP.RECDBY}
{PPV_HGINSP.RECDBYDESC}
{PPV_HGINSP.REMARK}
{PPV_HGINSP.SORTKEY}
{PPV_HGINSP.SOURCE}
{PPV_HGINSP.SOURCEDESC}
{PPV_HGINSP.STATUS}
{PPV_HGINSP.STNAME}
{PPV_HGINSP.STREETID}
{PPV_HGINSP.TARAPPLSET}
{PPV_HGINSP.TARAPPLSETTM}
{PPV_HGINSP.TARCMPLTD}
{PPV_HGINSP.TARCMPLTDTM}
{PPV_HGINSP.TASK}
{PPV_HGINSP.TASKDESC}
{PPV_HGINSP.TASKGROUP}
{PPV_HGINSP.TASKGROUPDESC}
{PPV_HGINSP.TIMETAKEN}
{PPV_HGINSP.TMRECD}
{PPV_HGINSP.TRADNAME}
{PPV_HGINSP.UKEY}
{PPV_HGINSP.USAMEND}
{PPV_HGINSP.USCREATE}
{PPV_HGINSP.WARD}
{PPV_HGINSP.WORKID}

Dwelling

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Inspection date / {PPV_HGINSP.INSPDATE}
About the building
Age of building / {PPV_HGINSP.AGEBAND}
{PPV_HGINSP.AGEBANDDESC}
Building type / {PPV_HGINSP.BLDGTYPE}
{PPV_HGINSP.BLDGTYPEDESC}
No of levels / {PPV_HGINSP.BLDGNOLVLS}
No of dwellings / {PPV_HGINSP.BLDGNODWLNGS}
About the dwelling
Dwelling type / {PPV_HGINSP.DWLTYPE}
{PPV_HGINSP.DWLTYPEDESC}
No of levels / {PPV_HGINSP.DWLNOLVLS}
Entrance level / {PPV_HGINSP.DWLENTLVL}
{PPV_HGINSP.DWLENTLVLDESC}
Shared amenities
Entrance / {PPV_HGINSP.AMENTRANCE}
Refuse storage / {PPV_HGINSP.AMREFUSESTORAGE}
Stairs / {PPV_HGINSP.AMSTAIRS}
Lifts / {PPV_HGINSP.AMLIFTS}
Non self-contained
Kitchen / {PPV_HGINSP.NSCKITCHEN}
Dining room / {PPV_HGINSP.NSCDININGROOM}
Lounge / {PPV_HGINSP.NSCLOUNGE}
Bathroom / {PPV_HGINSP.NSCBATHROOM}
Bathroom / WC / {PPV_HGINSP.NSCNATHROOMWC}
WC / {PPV_HGINSP.NSCWC}
Decent homes
INSPECTIONdate / {PPV_HGINSP.DECHINSP}
A HHSRS
B state of repair
C modern facilities
D Thermal comfort
Overall assessment / {PPV_HGINSP.OALLASS}
{PPV_HGINSP.OALLASSDESC}
AFTERdate / {PPV_HGINSP.DECHINSPAFTER}
A HHSRS
B state of repair
C modern facilities
D Thermal comfort
Overall assessment / {PPV_HGINSP.OALLASSAFTER}
{PPV_HGINSP.OALLASSAFTERDESC}

Occupancy

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
WORKID / {PPV_HGIOCC.WORKID}
Landlord
Occupant summary
Tenure / {PPV_HGINSP.TENURE}
{PPV_HGINSP.TENUREDESC}
Occupancy notes / {PPV_HGINSP.OCCSUMMNOTES}
Age profile
Under 10 / {PPV_HGINSP.AGEPROF10}
10-16 / {PPV_HGINSP.AGEPROF1016}
17-65 / {PPV_HGINSP.AGEPROF1765}
66-75 / {PPV_HGINSP.AGEPROF6675}
Over 75 / {PPV_HGINSP.AGEPROF75}
Occupants
Dwelling / {PPV_HGIOCC.OCCDWLNG}
Name / {PPV_HGIOCC.OCCTITLEDESC}
{PPV_HGIOCC.OCCINITIALS}
{PPV_HGIOCC.OCCFIRSTNAME}
{PPV_HGIOCC.OCCFAMILYNAME}
{PPV_HGIOCC.OCCFULLNAME1}
{PPV_HGIOCC.OCCFULLNAME2}
{PPV_HGIOCC.OCCFULLNAME3}
Age / {PPV_HGIOCC.OCCAGE}
Benefit
Benefit description / {PPV_HGIOCC.BENEFITDESCR}
Notes / {PPV_HGIOCC.OCCNOTES}
{PPV_HGIOCC.OCCSEQNO} / Sequence ordering number
{PPV_HGIOCC.DESCR}

Hazards

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Hazard / {PPV_HGIHAZ.HAZARD}
Hazard description / {PPV_HGIHAZ.HAZARDDESC}
Band / {PPV_HGIHAZ.BAND}
Band after / {PPV_HGIHAZ.BANDA}
Decent homes A
HHSRS / {PPV_HGINSP.HAZDECN}
PPV_HGINSP.HAZDECNDESC}
After / {PPV_HGINSP.HAZDECNAFTER}
{PPV_HGINSP.HAZDECNAFTERDESC}
SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
HHRS
Worksheet ID / {PPV_HGIHAZ.WORKID}
Likelihood 1 in / {PPV_HGIHAZ.HAZLIKELIHOOD}
Outcomes / {PPV_HGIHAZ.OUTCOME1}
{PPV_HGIHAZ.OUTCOME2}
{PPV_HGIHAZ.OUTCOME3}
{PPV_HGIHAZ.OUTCOME4}
Score / {PPV_HGIHAZ.SCORE}
Band / {PPV_HGIHAZ.BAND}
Likelihood justification / {PPV_HGIHAZ.LKHJUST}
Outcome justification / {PPV_HGIHAZ.OUTJUST}
HHRS AFTER
Likelihood 1 in / {PPV_HGIHAZ.HAZLIKELIHOODA}
Outcomes / {PPV_HGIHAZ.OUTCOME1A}
{PPV_HGIHAZ.OUTCOME2A}
{PPV_HGIHAZ.OUTCOME3A}
{PPV_HGIHAZ.OUTCOME4A}
Score / {PPV_HGIHAZ.SCOREA}
Band / {PPV_HGIHAZ.BANDA}
Likelihood justification
After date / {PPV_HGIHAZ.HAZDATEA}
Officer / {PPV_HGIHAZ.HAZOFFICERA}
PPV_HGIHAZ.HAZOFFICERADESC}

HGIHAZ

BACKGROUND / {PPV_HGIHAZ.BACKGROUND}
HAZSEQNO / {PPV_HGIHAZ.HAZSEQNO}
IMPJUST / {PPV_HGIHAZ.IMPJUST}

HGIHAZIMG

HAZSEQNO / {PPV_HGIHAZIMG.HAZSEQNO}
IMGDESC / {PPV_HGIHAZIMG.IMGDESC}
IMGPKEY / {PPV_HGIHAZIMG.IMGPKEY}
IMGSEQNO / {PPV_HGIHAZIMG.IMGSEQNO}
WORKID / {PPV_HGIHAZIMG.WORKID}

HGI Hazard location

HAZSEQNO / {PPV_HGIHAZLOC.HAZSEQNO}
LOCN / {PPV_HGIHAZLOC.LOCN}
LOCNDESC / {PPV_HGIHAZLOC.LOCNDESC}
LOCNNOTES / {PPV_HGIHAZLOC.LOCNNOTES}
LOCSEQNO / {PPV_HGIHAZLOC.LOCSEQNO}
WORKID / {PPV_HGIHAZLOC.WORKID}

HGI hazard loclkh

HAZSEQNO / {PPV_HGIHAZLOCLKH.HAZSEQNO}
LKHDESC / {PPV_HGIHAZLOCLKH.LKHDESC}
LKHSEQNO / {PPV_HGIHAZLOCLKH.LKHSEQNO}
LOCSEQNO / {PPV_HGIHAZLOCLKH.LOCSEQNO}
SEVERITY / {PPV_HGIHAZLOCLKH.SEVERITY}
SEVERITYDESC / {PPV_HGIHAZLOCLKH.SEVERITYDESC}
WORKID / {PPV_HGIHAZLOCLKH.WORKID}

Decent Homes B

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Criterion B State of repair
Area / {PPV_HGIDHC.DHCAREA}
Definition / {PPV_HGIDHC.DHCDEFINITION}
Yes/no / {PPV_HGIDHC.DHCYN}
{PPV_HGIDHC.DHCYNDESC}
WORKID / {PPV_HGIDHC.WORKID}
{PPV_HGIDHC.DHCSEQNO} / Sequence number
{PPV_HGIDHC.DHCCRIT}
B State of repair assessment
Insp / {PPV_HGINSP.DHCBDECN}
{PPV_HGINSP.DHCBDECNDESC}
After / {PPV_HGINSP.DHCBDECNAFTER}
{PPV_HGINSP.DHCBDECNAFTERDESC}
Notes / {PPV_HGINSP.DHCBNOTES}

Decent Homes C and D

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Criterion C Reasonably modern facilities and services
Area / {PPV_HGIDHC.DHCAREA}
Definition / {PPV_HGIDHC.DHCDEFINITION}
Yes/no / {PPV_HGIDHC.DHCYN}
{PPV_HGIDHC.DHCYNDESC}
WORKID / {PPV_HGIDHC.WORKID}
{PPV_HGIDHC.DHCSEQNO} / Sequence number
{PPV_HGIDHC.DHCCRIT}
Assessment : insp / {PPV_HGINSP.DHCCDECN}
{PPV_HGINSP.DHCCDECNDESC}
Assessment after / {PPV_HGINSP.DHCCDECNAFTER}
{PPV_HGINSP.DHCCDECNAFTERDESC}
Criterion D Reasonable degree of thermal comfort
Area / {PPV_HGIDHC.DHCAREA}
Definition / {PPV_HGIDHC.DHCDEFINITION}
Yes/no / {PPV_HGIDHC.DHCYN}
{PPV_HGIDHC.DHCYNDESC}
WORKID / {PPV_HGIDHC.WORKID}
{PPV_HGIDHC.DHCSEQNO} / Sequence number
{PPV_HGIDHC.DHCCRIT}
Assess insp / {PPV_HGINSP.DHCDDECN}
{PPV_HGINSP.DHCDDECNDESC}
Assess after / {PPV_HGINSP.DHCDDECNAFTER}
{PPV_HGINSP.DHCDDECNAFTERDESC}

???????? how do you distinguish between A B C or D in tables?????

Energy

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
EER Energy Efficiency Rating
Current rating / {PPV_HGINSP.EERCURRTG}
Current band / {PPV_HGINSP.EERCURBAND}
Potential rating / {PPV_HGINSP.EERPOTRTG}
Potential band / {PPV_HGINSP.EERPOTBAND}
EIR Environmental Impact Rating
Current rating / {PPV_HGINSP.EIRCURRTG}
Current band / {PPV_HGINSP.EIRCURBAND}
Potential rating / {PPV_HGINSP.EIRPOTRTG}
Potential band / {PPV_HGINSP.EIRPOTBAND}
DER dwelling carbon dioxide emission rate
Income benefit received in household / {PPV_HGINSP.INCBEN}
{PPV_HGINSP.INCBENDESC}
Emission rate / {PPV_HGINSP.DERDCDERATE}
Energy notes / {PPV_HGINSP.EECNOTES}

Actions

See Vol 1

User defined

See Vol 1

VSHM HMO Inspections

First tab as Vol I

Fields
{PPV_INSPECTIONSEH_VSHM.ACTAPPLSET}
{PPV_INSPECTIONSEH_VSHM.ACTAPPLSETTM}
{PPV_INSPECTIONSEH_VSHM.ACTCMPLTD}
{PPV_INSPECTIONSEH_VSHM.ACTCMPLTDTM}
{PPV_INSPECTIONSEH_VSHM.ADDR1}
{PPV_INSPECTIONSEH_VSHM.ADDR2}
{PPV_INSPECTIONSEH_VSHM.ADDR3}
{PPV_INSPECTIONSEH_VSHM.ADDR4}
{PPV_INSPECTIONSEH_VSHM.ADDR5}
{PPV_INSPECTIONSEH_VSHM.ADDR6}
{PPV_INSPECTIONSEH_VSHM.ADDR7}
{PPV_INSPECTIONSEH_VSHM.ADDR8}
{PPV_INSPECTIONSEH_VSHM.APPLICATION}
{PPV_INSPECTIONSEH_VSHM.APPLICATIONDESC}
{PPV_INSPECTIONSEH_VSHM.APPLSETTKN}
{PPV_INSPECTIONSEH_VSHM.AREA}
{PPV_INSPECTIONSEH_VSHM.AREADESC}
{PPV_INSPECTIONSEH_VSHM.CMPLTDTKN}
{PPV_INSPECTIONSEH_VSHM.COMPID}
{PPV_INSPECTIONSEH_VSHM.DEPARTMENT}
{PPV_INSPECTIONSEH_VSHM.DEPARTMENTDESC}
{PPV_INSPECTIONSEH_VSHM.DETAILS}
{PPV_INSPECTIONSEH_VSHM.DTALLOC}
{PPV_INSPECTIONSEH_VSHM.DTAMEND}
{PPV_INSPECTIONSEH_VSHM.DTCREATE}
{PPV_INSPECTIONSEH_VSHM.DTRECD}
{PPV_INSPECTIONSEH_VSHM.FULLADDR}
{PPV_INSPECTIONSEH_VSHM.MESSAGE}
{PPV_INSPECTIONSEH_VSHM.METHOD}
{PPV_INSPECTIONSEH_VSHM.METHODDESC}
{PPV_INSPECTIONSEH_VSHM.NEXTTASK}
{PPV_INSPECTIONSEH_VSHM.NEXTTASKDESC}
{PPV_INSPECTIONSEH_VSHM.NEXTTASKDUE}
{PPV_INSPECTIONSEH_VSHM.OFFICER}
{PPV_INSPECTIONSEH_VSHM.OFFICERDESC}
{PPV_INSPECTIONSEH_VSHM.OFFICERDESIG}
{PPV_INSPECTIONSEH_VSHM.OFFICEREMAIL}
{PPV_INSPECTIONSEH_VSHM.OFFICERREF}
{PPV_INSPECTIONSEH_VSHM.OFFICERTEL}
{PPV_INSPECTIONSEH_VSHM.OUTCOME}
{PPV_INSPECTIONSEH_VSHM.OUTCOMEDESC}
{PPV_INSPECTIONSEH_VSHM.PARISH}
{PPV_INSPECTIONSEH_VSHM.POSNREF}
{PPV_INSPECTIONSEH_VSHM.POSTCD}
{PPV_INSPECTIONSEH_VSHM.PREVNEXT}
{PPV_INSPECTIONSEH_VSHM.PREVRSK1}
{PPV_INSPECTIONSEH_VSHM.PREVRSK10}
{PPV_INSPECTIONSEH_VSHM.PREVRSK10DESC}
{PPV_INSPECTIONSEH_VSHM.PREVRSK11}
{PPV_INSPECTIONSEH_VSHM.PREVRSK11DESC}
{PPV_INSPECTIONSEH_VSHM.PREVRSK12}
{PPV_INSPECTIONSEH_VSHM.PREVRSK12DESC}
{PPV_INSPECTIONSEH_VSHM.PREVRSK1DESC}
{PPV_INSPECTIONSEH_VSHM.PREVRSK2}
{PPV_INSPECTIONSEH_VSHM.PREVRSK2DESC}
{PPV_INSPECTIONSEH_VSHM.PREVRSK3}
{PPV_INSPECTIONSEH_VSHM.PREVRSK3DESC}
{PPV_INSPECTIONSEH_VSHM.PREVRSK4}
{PPV_INSPECTIONSEH_VSHM.PREVRSK4DESC}
{PPV_INSPECTIONSEH_VSHM.PREVRSK5}
{PPV_INSPECTIONSEH_VSHM.PREVRSK5DESC}
{PPV_INSPECTIONSEH_VSHM.PREVRSK6}
{PPV_INSPECTIONSEH_VSHM.PREVRSK6DESC}
{PPV_INSPECTIONSEH_VSHM.PREVRSK7}
{PPV_INSPECTIONSEH_VSHM.PREVRSK7DESC}
{PPV_INSPECTIONSEH_VSHM.PREVRSK8}
{PPV_INSPECTIONSEH_VSHM.PREVRSK8DESC}
{PPV_INSPECTIONSEH_VSHM.PREVRSK9}
{PPV_INSPECTIONSEH_VSHM.PREVRSK9DESC}
{PPV_INSPECTIONSEH_VSHM.PREVTOT}
{PPV_INSPECTIONSEH_VSHM.RECDBY}
{PPV_INSPECTIONSEH_VSHM.RECDBYDESC}
{PPV_INSPECTIONSEH_VSHM.REMARK}
{PPV_INSPECTIONSEH_VSHM.SORTKEY}
{PPV_INSPECTIONSEH_VSHM.SOURCE}
{PPV_INSPECTIONSEH_VSHM.SOURCEDESC}
{PPV_INSPECTIONSEH_VSHM.STATUS}
{PPV_INSPECTIONSEH_VSHM.STNAME}
{PPV_INSPECTIONSEH_VSHM.STREETID}
{PPV_INSPECTIONSEH_VSHM.TARAPPLSET}
{PPV_INSPECTIONSEH_VSHM.TARAPPLSETTM}
{PPV_INSPECTIONSEH_VSHM.TARCMPLTD}
{PPV_INSPECTIONSEH_VSHM.TARCMPLTDTM}
{PPV_INSPECTIONSEH_VSHM.TASK}
{PPV_INSPECTIONSEH_VSHM.TASKDESC}
{PPV_INSPECTIONSEH_VSHM.TASKGROUP}
{PPV_INSPECTIONSEH_VSHM.TASKGROUPDESC}
{PPV_INSPECTIONSEH_VSHM.TIMETAKEN}
{PPV_INSPECTIONSEH_VSHM.TMRECD}
{PPV_INSPECTIONSEH_VSHM.TRADNAME}
{PPV_INSPECTIONSEH_VSHM.USAMEND}
{PPV_INSPECTIONSEH_VSHM.USCREATE}
{PPV_INSPECTIONSEH_VSHM.WARD}

Inspections

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
{PPV_INSPECTIONSEH_VSHM.UKEY} / PI/###
{PPV_INSPECTIONSEH_VSHM.WORKID} / WK/###
Date rated / {PPV_INSPECTIONSEH_VSHM.DTRATED}
Officer / {PPV_INSPECTIONSEH_VSHM.INSPOFFICER}
{PPV_INSPECTIONSEH_VSHM.INSPOFFICERDESC}
Score / {PPV_INSPECTIONSEH_VSHM.RSKTOT}
Category / {PPV_INSPECTIONSEH_VSHM.NEXTCAT}
Next due / {PPV_INSPECTIONSEH_VSHM.NEXTVISIT}
Frequency / {PPV_INSPECTIONSEH_VSHM.NEXTFREQ}
Revisit details
Date / {PPV_INSPECTIONSEH_VSHM.REVISDATE}
Officer / {PPV_INSPECTIONSEH_VSHM.REVISOFF}
{PPV_INSPECTIONSEH_VSHM.REVISOFFDESC}
Category / {PPV_INSPECTIONSEH_VSHM.REVISCAT}
Worksheet / {PPV_INSPECTIONSEH_VSHM.REVISWORKID}
Area / {PPV_INSPECTIONSEH_VSHM.INSPAREA}
{PPV_INSPECTIONSEH_VSHM.INSPAREADESC}
Previous [date] / {PPV_INSPECTIONSEH_VSHM.PREVDATE}
[previous] Category / {PPV_INSPECTIONSEH_VSHM.PREVCAT}
[Previous frequency] / {PPV_INSPECTIONSEH_VSHM.PREVFREQ}
Risk ratings (Your labels will differ, as set in the system config / code set)
1 / {PPV_INSPECTIONSEH_VSHM.RSK1}
{PPV_INSPECTIONSEH_VSHM.RSK1DESC}
2 / {PPV_INSPECTIONSEH_VSHM.RSK2}
{PPV_INSPECTIONSEH_VSHM.RSK2DESC}
3 / {PPV_INSPECTIONSEH_VSHM.RSK3}
{PPV_INSPECTIONSEH_VSHM.RSK3DESC}
4 / {PPV_INSPECTIONSEH_VSHM.RSK4}
{PPV_INSPECTIONSEH_VSHM.RSK4DESC}
5 / {PPV_INSPECTIONSEH_VSHM.RSK5}
{PPV_INSPECTIONSEH_VSHM.RSK5DESC}
6 / {PPV_INSPECTIONSEH_VSHM.RSK6}
{PPV_INSPECTIONSEH_VSHM.RSK6DESC}
7 / {PPV_INSPECTIONSEH_VSHM.RSK7}
{PPV_INSPECTIONSEH_VSHM.RSK7DESC}
8 / {PPV_INSPECTIONSEH_VSHM.RSK8}
{PPV_INSPECTIONSEH_VSHM.RSK8DESC}
9 / {PPV_INSPECTIONSEH_VSHM.RSK9}
{PPV_INSPECTIONSEH_VSHM.RSK9DESC}
10 / {PPV_INSPECTIONSEH_VSHM.RSK10}
{PPV_INSPECTIONSEH_VSHM.RSK10DESC}
11 / {PPV_INSPECTIONSEH_VSHM.RSK11}
{PPV_INSPECTIONSEH_VSHM.RSK11DESC}
12 / {PPV_INSPECTIONSEH_VSHM.RSK12}
{PPV_INSPECTIONSEH_VSHM.RSK12DESC}

Activities

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Activity
Activity description
Response
Number
Time
Comment

Schedule

See Vol 1

Actions

See Vol 1

HMO Component

Details

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
{PPV_HMODETS.PKEY}
{PPV_HMODETS.UKEY}
Property
Category / {PPV_HMODETS.CATEGORY}
{PPV_HMODETS.CATEGORYDESC}
Statutory size / {PPV_HMODETS.STATSIZE}
Area / {PPV_HMODETS.STATSIZEDESC}
Officer / {PPV_HMODETS.OFFICER}
{PPV_HMODETS.OFFICERDESC}
Floors front / {PPV_HMODETS.FRONTFLR}
Floors rear / {PPV_HMODETS.REARFLR}
Lettings / {PPV_HMODETS.LETTINGS}
Rooms / {PPV_HMODETS.ROOMS}
Persons / {PPV_HMODETS.PERSONS}
Households / {PPV_HMODETS.HOUSEHOLDS}
Access floor / {PPV_HMODETS.ACCESSFLR}
Registration
Ref / {PPV_HMODETS.REGREF}
Type / {PPV_HMODETS.REGTYPE}
{PPV_HMODETS.REGTYPEDESC}
Date / {PPV_HMODETS.REGDATE}
Fee / {PPV_HMODETS.REGFEE}
Paid / {PPV_HMODETS.REGPAID}
Reports
Fire report / {PPV_HMODETS.FIRESTAT}
{PPV_HMODETS.FIRESTATDESC}
{PPV_HMODETS.FIREDATE}
Planning / {PPV_HMODETS.PLANSTAT}
{PPV_HMODETS.PLANSTATDESC}
{PPV_HMODETS.PLANDATE}
Building control / {PPV_HMODETS.BLDGSTAT}
{PPV_HMODETS.BLDGSTATDESC}
{PPV_HMODETS.BLDGDATE}
Water quality / {PPV_HMODETS.USERSTAT1}
{PPV_HMODETS.USERSTAT1DESC}
{PPV_HMODETS.USERDATE1} / These 2 are LA customisable ?
Surveyors report / {PPV_HMODETS.USERSTAT2}
{PPV_HMODETS.USERSTAT2DESC}
{PPV_HMODETS.USERDATE2}
Comments / {PPV_HMODETS.COMMENTS}

Other fields available

{PPV_HMODETS.ADDR1}
{PPV_HMODETS.ADDR2}
{PPV_HMODETS.ADDR3}
{PPV_HMODETS.ADDR4}
{PPV_HMODETS.ADDR5}
{PPV_HMODETS.ADDR6}
{PPV_HMODETS.ADDR7}
{PPV_HMODETS.ADDR8}
{PPV_HMODETS.AREA}
{PPV_HMODETS.AREADESC}
{PPV_HMODETS.DTAMEND}
{PPV_HMODETS.DTCREATE}
{PPV_HMODETS.FULLADDR}
{PPV_HMODETS.PBCONV}
{PPV_HMODETS.PBCONVDESC}
{PPV_HMODETS.POSNREF}
{PPV_HMODETS.POSTCD}
{PPV_HMODETS.REMARK}
{PPV_HMODETS.STNAME}
{PPV_HMODETS.STREETID}
{PPV_HMODETS.TRADNAME}
{PPV_HMODETS.USAMEND}
{PPV_HMODETS.USCREATE}

Property attributes

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Type of licence / {PPV_HMODETS.LICETYPE}
{PPV_HMODETS.LICETYPEDESC}
Form of structure / {PPV_HMODETS.STRUCTURE}
{PPV_HMODETS.STRUCTUREDESC}
No of lettings / {PPV_HMODETS.LETTINGS} / Same as previous screen?
Build origin
Year built / {PPV_HMODETS.YEARBUILT}
Documented / {PPV_HMODETS.DOCUMENTED}
Age band / {PPV_HMODETS.AGEBAND}
{PPV_HMODETS.AGEBANDDESC}
Year converted / {PPV_HMODETS.YEARCONV}
Floors in block above ground / {PPV_HMODETS.NOFLRSBLKA}
Below / {PPV_HMODETS.NOFLRSBLKB}
Floors in property from / {PPV_HMODETS.FLRSPROPFROM}
To / {PPV_HMODETS.FLRSPROPTO}
Households Max / {PPV_HMODETS.MXNOHOUSEHOLDS}
Actual / {PPV_HMODETS.ACTNOHOUSEHOLDS}
Date / {PPV_HMODETS.ACTDATE}
Persons max / {PPV_HMODETS.MXNOPERSONS}
Actual / {PPV_HMODETS.ACTNOPERSONS}
Number of
Rooms living / {PPV_HMODETS.NOROOMSLIVING}
Rooms sleeping / {PPV_HMODETS.NOROOMSSLEEP}
Bath & shower / {PPV_HMODETS.NOBATHSHOWER}
{PPV_HMODETS.NOSHBATHSHOWER}
Toilets and wb / {PPV_HMODETS.NOTOILETWHB}
{PPV_HMODETS.NOSHTOILETWHB}
Kitchens / {PPV_HMODETS.NOKITCHENS}
{PPV_HMODETS.NOSHKITCHENS}
Sinks / {PPV_HMODETS.NOSINKS}
{PPV_HMODETS.NOSHSINKS}
Self contained units / {PPV_HMODETS.NOSELFCONTUNITS}
Non self contained units / {PPV_HMODETS.NONONSELFCONTUNITS}

HMO Questions

Fitness

Your configuration will probably show different labels – write them in here:

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Serious disrepair / {PPV_HMODETS.FIT1}
Structural stability / {PPV_HMODETS.FIT2}
Dampness / {PPV_HMODETS.FIT3}
Ventilation / {PPV_HMODETS.FIT4}
Heating / {PPV_HMODETS.FIT5}
Lighting / {PPV_HMODETS.FIT6}
Water supply / {PPV_HMODETS.FIT7}
Prep/cook food / {PPV_HMODETS.FIT8}
Bath shower whb hc wc / {PPV_HMODETS.FIT9}
Drainage foul water waste / {PPV_HMODETS.FIT10}
Storage prep cook food hc / {PPV_HMODETS.FIT11}
Water closets / {PPV_HMODETS.FIT12}
Baths whb showers hc / {PPV_HMODETS.FIT13}
Escape from fire / {PPV_HMODETS.FIT14}
{PPV_HMODETS.FIT15}
{PPV_HMODETS.FIT16}
{PPV_HMODETS.FIT17}
{PPV_HMODETS.FIT18}
{PPV_HMODETS.FIT19}
{PPV_HMODETS.FIT20}
{PPV_HMODETS.FIT21}
{PPV_HMODETS.FIT22}
{PPV_HMODETS.FIT23}
{PPV_HMODETS.FIT24}
{PPV_HMODETS.FIT25}
{PPV_HMODETS.FIT26}
{PPV_HMODETS.FIT27}
{PPV_HMODETS.FIT28}
{PPV_HMODETS.FIT29}
{PPV_HMODETS.FIT30}

General

Your configuration will probably show different labels – write them in here:

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Unfit under s604(1) / {PPV_HMODETS.GEN1}
Unfit under s604(2) / {PPV_HMODETS.GEN2}
Unfit under s352 / {PPV_HMODETS.GEN3}
Automatic fire detection / {PPV_HMODETS.GEN4}
Emergency lighting / {PPV_HMODETS.GEN5}
Fire extinguishers / {PPV_HMODETS.GEN6}
Smoke detectors / {PPV_HMODETS.GEN7}
Solid brick walls / {PPV_HMODETS.GEN8}
Cavity brick walls / {PPV_HMODETS.GEN9}
Timber framed walls / {PPV_HMODETS.GEN10}
Non traditional concrete frame / {PPV_HMODETS.GEN11}
Pvc windows / {PPV_HMODETS.GEN12}
Metal framed windows / {PPV_HMODETS.GEN13}
Double/ secondary glazing / {PPV_HMODETS.GEN14}
Cavity wall insulation / {PPV_HMODETS.GEN15}
Roof insulation / {PPV_HMODETS.GEN16}
Cylinder insulation / {PPV_HMODETS.GEN17}
Draught proofing / {PPV_HMODETS.GEN18}
Gas central heating / {PPV_HMODETS.GEN19}
Storage heaters / {PPV_HMODETS.GEN20}
Open fires / {PPV_HMODETS.GEN21}
Gas fires / {PPV_HMODETS.GEN22}
Heating provided / {PPV_HMODETS.GEN23}
{PPV_HMODETS.GEN24}
{PPV_HMODETS.GEN25}
{PPV_HMODETS.GEN26}
{PPV_HMODETS.GEN27}
{PPV_HMODETS.GEN28}
{PPV_HMODETS.GEN29}
{PPV_HMODETS.GEN30}

Numbers

Your configuration will probably show different labels – write them in here:

SCREEN LABEL / {TABLE.FIELD} / CODES / NOTES
Bedsits / {PPV_HMODETS.NUM1}
Student lettings / {PPV_HMODETS.NUM2}
Self contained flats / {PPV_HMODETS.NUM3}
Lodgings / {PPV_HMODETS.NUM4}
Adults 16+ / {PPV_HMODETS.NUM5}
Children under 10 / {PPV_HMODETS.NUM6}
Children over 10 / {PPV_HMODETS.NUM7}
Children under 1 / {PPV_HMODETS.NUM8}
Living rooms / {PPV_HMODETS.NUM9}
Dining rooms / {PPV_HMODETS.NUM10}
Baths/showers / {PPV_HMODETS.NUM11}
Wcs / {PPV_HMODETS.NUM12}
Communal kitchens / {PPV_HMODETS.NUM13}
Bedsit kitchens / {PPV_HMODETS.NUM14}
{PPV_HMODETS.NUM15}
{PPV_HMODETS.NUM16}
{PPV_HMODETS.NUM17}
{PPV_HMODETS.NUM18}
{PPV_HMODETS.NUM19}
{PPV_HMODETS.NUM20}
{PPV_HMODETS.NUM21}
{PPV_HMODETS.NUM22}
{PPV_HMODETS.NUM23}
{PPV_HMODETS.NUM24}
{PPV_HMODETS.NUM25}
{PPV_HMODETS.NUM26}
{PPV_HMODETS.NUM27}
{PPV_HMODETS.NUM28}
{PPV_HMODETS.NUM29}
{PPV_HMODETS.NUM30}

Judgements