vl_all - all complaints received by address

an activity number could (and often does) have multiple addresses associated with it - there will be a record for each address

(which means duplicate activity numbers)

fields:

ACT_NUM - activity number

STATUS_1 - description below

SUB_TYPE - type of complaint

TYPE_DESC - description of activity number type (sub-type in permits+)

DT_ENT - date complaint was received

DESCRIPTION - description of complaint received

INSP_AREA - inspection areas

INSP_ASSIGN - inspector assigned by location (could differ from actualinspector in vl_nov) - from base screen

RED_FOLDER - if case has been called in by Ward office

NOV - if activity has received a notice of violation

ADDRESS_FULL - address from permits+ with Struc, Floor and Unit

ADDRESS_MATCH - address record actually matched to

WARD - Ward number from geoprocessing, not permits+

TRS - TRS, from geoprocessing, not permits+

statuses (same for both layers):

CLOSED:

CANCEL- case was cancelled administratively - no inspection occurred

COMPLAIN- case is closed as compliant

COURTCMP- closed case where case was heard in court and now is in compliance

COURTNCM- closed case where case was heard in court but owner did not comply

INVALID- case was inspected and no violation found.

NOVERIFY- case was inspected and no violation found

SUSPENDED- another type of administrative closure of a case that is now seldom used

REFERRED- case opened and it is determined that issue is the responsibility of another department so case has been referred to them.

OPEN:

FIELD- newly opened case where inspection has not occurred yet

OBSERVE- typically used for cases where the owner is granted time to comply either though an appeal or other administrative extensions where the inspector is not required to inspect every 30 days.

PENDING- case opened, violation(s) identified and Notice has been mailed out. Waiting for compliance.

PERMIT- Case opened and owner issued Notice to obtain permit for work done that needs one. Permit has then been issued and inspector is waiting for permit inspections by PDSD to be completed.

CITATION- case is open, owner has not responded to Notice therefore a citation has been issued

COURT- citation was issued and case has now been heard in court