-
Notifications
You must be signed in to change notification settings - Fork 7
Optional Inspections Dataset Requirements
Mark Headd edited this page Jul 17, 2015
·
3 revisions
Inspections data overall is optional. If Inspections data exists, then the following provides which fields should be required, recommended and optional to make the dataset useful, which can be linked back to the core permits dataset by the PermitNum field.
| Field | DataType | Description |
|---|---|---|
| PermitNum | TEXT | Provides data link back to core permits information by permit number |
| InspType | TEXT | Raw values indicating type of inspection in abbreviated/shorthand |
| InspTypeMapped 1 | TEXT | InspType mapped to standardized values. |
| Result | TEXT | Raw values indicating result of inspection |
| ResultMapped | TEXT | Result mapped to standardized values:
|
| ScheduledDate 2 | TEXT (YYYY-MM-DD) | Date scheduled for inspection |
| InspectedDate | TEXT (YYYY-MM-DD) | Actual date inspected |
| Field | DataType | Description |
|---|---|---|
| InspectionNotes | TEXT | Notes from the inspector. 3 |
| Field | DataType | Description |
|---|---|---|
| Description | TEXT | Longer description of inspection |
| Final | TEXT | Indicator as to whether or not the inspection is a final inspection (Yes or No) |
| RequestDate | TEXT (YYYY-MM-DD) | Date on which the inspection was requested |
| RequestTime | TEXT | Time at which the inspection was requested |
| DesiredDate | TEXT (YYYY-MM-DD) | Date desired for inspection |
| DesiredTime | TEXT | Time desired for inspection |
| ScheduledTime | TEXT | Time scheduled for inspection |
| InspectedTime | TEXT | Actual time inspected |
| ReInspection | TEXT | Indicator as to whether a reinspection is needed (Yes or No) |
| Inspector | TEXT | Name and/or identifier of inspector |
| ExtraFields | JSON | Source fields that could not logically map to one of the above fields. |
- See Appendix A
- Note that only one of the dates for ScheduledDate or InspectedDate is required. However, if both dates are available, both should be submitted.
- If populated after a failed inspection, usually consists of an explanation of why the inspection failed.