Name: Inspections

Display Field: ActivityID

Type: Table

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ActivityID (type: esriFieldTypeString, alias: ActivityID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ActivityTypeID (type: esriFieldTypeInteger, alias: ActivityTypeID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REMARKS (type: esriFieldTypeString, alias: REMARKS, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• InspectionType (type: esriFieldTypeString, alias: InspectionType, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• INSPECTOR (type: esriFieldTypeString, alias: INSPECTOR, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• SCHEDULED_DATE (type: esriFieldTypeDate, alias: SCHEDULED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SCHEDULED_TIME (type: esriFieldTypeString, alias: SCHEDULED_TIME, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• COMPLETED_DATE (type: esriFieldTypeDate, alias: COMPLETED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMPLETED_TIME (type: esriFieldTypeString, alias: COMPLETED_TIME, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DURATION (type: esriFieldTypeInteger, alias: DURATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESULT (type: esriFieldTypeString, alias: RESULT, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• LOCKID (type: esriFieldTypeString, alias: LOCKID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• RECORDID (type: esriFieldTypeString, alias: RECORDID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• DURATION_EST (type: esriFieldTypeInteger, alias: DURATION_EST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CREATED_DATE (type: esriFieldTypeDate, alias: CREATED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CREATED_TIME (type: esriFieldTypeString, alias: CREATED_TIME, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CREATED_BY (type: esriFieldTypeString, alias: CREATED_BY, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• SEQID (type: esriFieldTypeInteger, alias: SEQID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CAPOVERRIDE (type: esriFieldTypeInteger, alias: CAPOVERRIDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• exID (type: esriFieldTypeString, alias: exID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PathURL (type: esriFieldTypeString, alias: PathURL, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• PathURLDateAdded (type: esriFieldTypeDate, alias: PathURLDateAdded, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BondInspectionRef (type: esriFieldTypeInteger, alias: BondInspectionRef, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOC_RECORDID (type: esriFieldTypeString, alias: LOC_RECORDID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SITE_APN (type: esriFieldTypeString, alias: SITE_APN, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• IS_AUTO_GENERATED (type: esriFieldTypeSmallInteger, alias: IS_AUTO_GENERATED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Unique_Key (type: esriFieldTypeGUID, alias: Unique_Key, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)

Templates:

Name: Inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/5/2022 3:33:39 PM

Schema Last Edit Date: 10/5/2022 3:33:39 PM

Data Last Edit Date: 10/5/2022 3:33:39 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat