| description:
|
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 numberSTATUS_1 - description belowSUB_TYPE - type of complaintTYPE_DESC - description of activity number type (sub-type in permits+)DT_ENT - date complaint was receivedDESCRIPTION - description of complaint receivedINSP_AREA - inspection areasINSP_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 officeNOV - if activity has received a notice of violationADDRESS_FULL - address from permits+ with Struc, Floor and UnitADDRESS_MATCH - address record actually matched toWARD - 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 occurredCOMPLAIN- case is closed as compliantCOURTCMP- closed case where case was heard in court and now is in complianceCOURTNCM- closed case where case was heard in court but owner did not complyINVALID- case was inspected and no violation found. NOVERIFY- case was inspected and no violation foundSUSPENDED- another type of administrative closure of a case that is now seldom usedREFERRED- 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 yetOBSERVE- 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 issuedCOURT- citation was issued and case has now been heard in court |