Name: C_Inspection

Display Field: INSPECTOR_FIRSTNAME

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• PARENTGLOBALID (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• POSTCHECKNEEDED (type: esriFieldTypeString, alias: Post Check Needed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• INSPECTION_TYPE (type: esriFieldTypeString, alias: Inspection Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [PreCheck: Pre-Check Site Inspection (prior to the burn)], [PostCheck: Post-Check Site Inspection (after the burn)])
• REVIEW_UNIT (type: esriFieldTypeString, alias: Review Unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AEU: AEU - Amador - El Dorado Unit], [BDU: BDU - San Bernardino Unit], [BEU: BEU - San Benito - Monterey Unit], ... 28 more ...)
• REVIEW_COUNTY (type: esriFieldTypeString, alias: Review County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ALA: Alameda], [ALP: Alpine], [AMA: Amador], ... 54 more ...)
• REVIEW_DATE (type: esriFieldTypeDate, alias: Review Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REVIEW_STATUS (type: esriFieldTypeString, alias: Review Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Pass: Pass], [Fail: Fail], [Pending: Pending])
• REVIEW_FOLLOWUPDATE (type: esriFieldTypeDate, alias: Review Followup Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REVIEW_FOLLOWUPDATETEXT (type: esriFieldTypeString, alias: Review Followup Date Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_FOLLOWUPTIMESLOT (type: esriFieldTypeString, alias: Review Followup Time Slot, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_TOTALACRES (type: esriFieldTypeDouble, alias: Review Total Acres, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REVIEW_TOTALTONS (type: esriFieldTypeDouble, alias: Review Total Tons, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSPECTION_BURNAREA (type: esriFieldTypeDouble, alias: Inspection Burn Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSPECTION_COUNT (type: esriFieldTypeString, alias: Inspection Count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INSPECTOR_FIRSTNAME (type: esriFieldTypeString, alias: Inspector First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INSPECTOR_LASTNAME (type: esriFieldTypeString, alias: Inspector Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INSPECTOR_TITLE (type: esriFieldTypeString, alias: Inspector Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Captain: Captain], [FAE: FAE], [Forester: Forester], ... 2 more ...)
• INSPECTOR_EMAIL (type: esriFieldTypeString, alias: Inspector Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_APPLICATIONTYPE (type: esriFieldTypeString, alias: Review Application Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ResidentialBurning: Residential Burning], [BroadcastBurning: Broadcast Burning], [AgencyBurning: Agency/Ag Burning])
• REVIEW_PROJECTTYPE (type: esriFieldTypeString, alias: Review Project Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [General: General Project], [Prevention: Prevention Project])
• REVIEW_ACTIVITYDESCRIPTION (type: esriFieldTypeString, alias: Review Activity Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_PERMIT_ISSUEDDATE (type: esriFieldTypeDate, alias: Review Permit Issued Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REVIEW_PERMIT_ISSUED (type: esriFieldTypeString, alias: Review Permit Issued, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_PERMIT_STATUS (type: esriFieldTypeString, alias: Review Permit Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_HQUNITPHONE (type: esriFieldTypeString, alias: Review HQ Unit Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_AIRDISTRICTPHONE (type: esriFieldTypeString, alias: Review Air District Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_FIRESTATIONPHONE (type: esriFieldTypeString, alias: Review Fire Station Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_STARTDATE (type: esriFieldTypeDate, alias: Review Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REVIEW_ENDDATE (type: esriFieldTypeDate, alias: Review End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REVIEW_STARTHRS (type: esriFieldTypeString, alias: Review Start Hrs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_ENDHRS (type: esriFieldTypeString, alias: Review End Hrs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_COMMENTS (type: esriFieldTypeString, alias: Review Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• REVIEW_STATEFUNDEDWORK (type: esriFieldTypeString, alias: Review State Funded Work, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• REVIEW_STATEAGENCY (type: esriFieldTypeString, alias: Review State Agency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Fish and Game: Fish and Game], [Forestry and Fire Protection: Forestry and Fire Protection], [Parks and Recreation: Parks and Recreation], ... 1 more ...)
• REVIEW_STATEAGENCYOTHER (type: esriFieldTypeString, alias: Review State Agency Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_BURNPLAN (type: esriFieldTypeString, alias: Review Burn Plan, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• REVIEW_BURNPLANCOMPLETE (type: esriFieldTypeString, alias: Review Burn Plan Complete, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Incomplete: Incomplete])
• REVIEW_BURNPLANELEMENTS (type: esriFieldTypeString, alias: Review Burn Plan Elements, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• REVIEW_ELEMENTSEXPLANATION (type: esriFieldTypeString, alias: Review Elements Explanation, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• REVIEW_CONTINGENCYPLAN (type: esriFieldTypeString, alias: Review Contingency Plan, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes (Required document is complete)], [No: No (Required document not created)], [Incomplete: Incomplete (Required document is not complete)], ... 1 more ...)
• REVIEW_WINDSPEEDTO (type: esriFieldTypeInteger, alias: Review Wind Speed To, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REVIEW_TEMPERATURETO (type: esriFieldTypeInteger, alias: Review Temperature To, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REVIEW_HUMIDITYFROM (type: esriFieldTypeInteger, alias: Review Humidity From, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REVIEW_WINDDIRECTION (type: esriFieldTypeString, alias: Review Wind Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_METRICSMATCHPLAN (type: esriFieldTypeString, alias: Review Metrics Match Plan, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• REVIEW_METRICSCOMMENTS (type: esriFieldTypeString, alias: Review Metrics Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• REVIEW_UNITDENIALREASON (type: esriFieldTypeString, alias: Review Unit Denial Reason, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• REVIEW_UNITDENIALREASONOTHER (type: esriFieldTypeString, alias: Review Unit Denial Reason Other, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• REVIEW_UNITDECISION (type: esriFieldTypeString, alias: Review Unit Decision, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Approved: Approved], [Denied: Denied], [Cancelled: Cancelled])
• UNIT_DENIALREASON (type: esriFieldTypeString, alias: Unit Denial Reason, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• UNIT_DENIALREASONOTHER (type: esriFieldTypeString, alias: Unit Denial Reason Other, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• UNIT_DECISION (type: esriFieldTypeString, alias: Unit Decision, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Approved: Approve Application], [Denied: Deny Application], [Cancelled: Cancel Application (e.g., per applicant's request)])
• REVIEW_REGION (type: esriFieldTypeString, alias: Review Region, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Headquarters: Headquarters], [Northern: Northern Region], [Southern: Southern Region])
• REVIEW_BATTALION (type: esriFieldTypeString, alias: Review Battalion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_PRINTFLAG (type: esriFieldTypeSmallInteger, alias: Review Print Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REVIEW_WEBHOOKSENTEMAIL (type: esriFieldTypeString, alias: Review_WebHookSentEmail, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• REVIEW_DELETERECORD (type: esriFieldTypeString, alias: Review Delete Record, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes])
• REVIEW_TEXTFIELD1 (type: esriFieldTypeString, alias: Review Text Field 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_TEXTFIELD2 (type: esriFieldTypeString, alias: Review Text Field 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_TEXTFIELD3 (type: esriFieldTypeString, alias: Review Text Field 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_TEXTFIELD4 (type: esriFieldTypeString, alias: Review Text Field 4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REVIEW_TEXTFIELD5 (type: esriFieldTypeString, alias: Review Text Field 5, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Okay: Okay])
• REVIEW_TEXTFIELD6 (type: esriFieldTypeString, alias: Review Text Field 6, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Okay2: Okay2])
• REVIEW_NUMBERFIELD1 (type: esriFieldTypeDouble, alias: Review Number Field 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REVIEW_NUMBERFIELD2 (type: esriFieldTypeDouble, alias: Review Number Field 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REVIEW_NUMBERFIELD3 (type: esriFieldTypeDouble, alias: Review Number Field 3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REVIEW_NUMBERFIELD4 (type: esriFieldTypeDouble, alias: Review Number Field 4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CREATIONDATE (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• CREATOR (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EDITDATE (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• EDITOR (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: C_Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• PFIS.C_Application (1) -- Related To: C_Application (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/12/2024 6:34:46 PM

Schema Last Edit Date: 3/11/2024 12:56:21 AM

Data Last Edit Date: 3/12/2024 6:34:46 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat