Name: Inspections_Table

Display Field: MRCP_Registration_

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: false

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)
• MRCP_Registration_ (type: esriFieldTypeDouble, alias: MRCP Registration#, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspection_ID (type: esriFieldTypeString, alias: Inspection ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InspectionType (type: esriFieldTypeString, alias: InspectionType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lilmo: Lilmo], [PRISM: PRISM], [Therapy: Therapy], ... 8 more ...)
• Triage_Code (type: esriFieldTypeString, alias: Triage Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: QE:No items/remarks], [1: QE:Minor/Suggestions], [2: QE:Significant/Required], ... 9 more ...)
• Lead_Inspectors (type: esriFieldTypeString, alias: Lead Inspectors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Denise Czuba: Denise Czuba], [John Langston: John Langston], [Paul Harden: Paul Harden], ... 1 more ...)
• QE_surveyor (type: esriFieldTypeString, alias: QE-surveyor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Inspection_Closed_ (type: esriFieldTypeString, alias: Inspection Closed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Insptime (type: esriFieldTypeDouble, alias: Insptime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspection_Start_Time (type: esriFieldTypeString, alias: Inspection Start Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Writeuptime (type: esriFieldTypeString, alias: Writeuptime, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Traveltime (type: esriFieldTypeDouble, alias: Traveltime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MQSAmileage (type: esriFieldTypeString, alias: MQSAmileage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Contact_Person (type: esriFieldTypeString, alias: Contact Person, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Other_inspectors (type: esriFieldTypeString, alias: Other inspectors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Inspection_Date (type: esriFieldTypeString, alias: Inspection Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Inspection_Comments__Status (type: esriFieldTypeString, alias: Inspection Comments, Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Child_ID (type: esriFieldTypeGUID, alias: Child ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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: Inspections_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• Deficiencies_Table (3) -- Related To: Deficiencies_Table (3)
• Facility_Registration (0) -- Related To: Facility Registration (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/10/2023 4:40:41 PM

Schema Last Edit Date: 4/10/2023 4:40:41 PM

Data Last Edit Date: 3/29/2023 4:04:53 PM

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