Name: Asset-Fusion Inspection

Display Field: FITTINGTYPE

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

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)
• FITTINGNUM (type: esriFieldTypeSmallInteger, alias: Sketch Item Number, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 12 more ...)
• FITTINGTYPE (type: esriFieldTypeString, alias: Fitting Type, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true, Coded Values: [Elbow: Elbow], [Tee: Tee], [End Cap: End Cap], ... 5 more ...)
• FITTINGMATERIAL (type: esriFieldTypeString, alias: Fitting Material, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true, Coded Values: [MDPE 2406: MDPE 2406 (Orange)], [HDPE 4710 / 3408: HDPE 4710 / 3408 (Black)], [MDPE 2406 / 2708: MDPE 2406/2708 (Yellow)], ... 2 more ...)
• REDUCERFLAG (type: esriFieldTypeString, alias: Reducer Flag, SQL Type: sqlTypeOther, length: 3, nullable: false, editable: true, Coded Values: [Yes: Yes], [No: No])
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FUSERID_1 (type: esriFieldTypeInteger, alias: Fusion 1- Fuser ID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• INSPECTORID_1 (type: esriFieldTypeInteger, alias: Fusion 1- Inspector ID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• FUSIONTYPE_1 (type: esriFieldTypeString, alias: Fusion 1- Type, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true, Coded Values: [Butt: Butt Fusion], [Electro: Electro Fusion], [Socket: Socket Fusion], ... 1 more ...)
• PIPEMATERIAL_1 (type: esriFieldTypeString, alias: Fusion 1- Pipe Material, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true, Coded Values: [MDPE 2406: MDPE 2406 (Orange)], [HDPE 4710 / 3408: HDPE 4710 / 3408 (Black)], [MDPE 2406 / 2708: MDPE 2406/2708 (Yellow)], ... 2 more ...)
• RESULT_1 (type: esriFieldTypeString, alias: Fusion 1- Inspection Result, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true, Coded Values: [Pass: Pass], [Fail visual: Fail visual], [Fail Pressure: Fail Pressure], ... 1 more ...)
• FUSERID_2 (type: esriFieldTypeInteger, alias: Fusion 2- Fuser ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSPECTORID_2 (type: esriFieldTypeInteger, alias: Fusion 2- Inspector ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUSIONTYPE_2 (type: esriFieldTypeString, alias: Fusion 2- Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Butt: Butt Fusion], [Electro: Electro Fusion], [Socket: Socket Fusion], ... 1 more ...)
• PIPEMATERIAL_2 (type: esriFieldTypeString, alias: Fusion 2- Pipe Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [MDPE 2406: MDPE 2406 (Orange)], [HDPE 4710 / 3408: HDPE 4710 / 3408 (Black)], [MDPE 2406 / 2708: MDPE 2406/2708 (Yellow)], ... 2 more ...)
• RESULT_2 (type: esriFieldTypeString, alias: Fusion 2- Inspection Result, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Pass: Pass], [Fail visual: Fail visual], [Fail Pressure: Fail Pressure], ... 1 more ...)
• FUSERID_3 (type: esriFieldTypeInteger, alias: Fusion 3- Fuser ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSPECTORID_3 (type: esriFieldTypeInteger, alias: Fusion 3- Inspector ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUSIONTYPE_3 (type: esriFieldTypeString, alias: Fusion 3- Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Butt: Butt Fusion], [Electro: Electro Fusion], [Socket: Socket Fusion], ... 1 more ...)
• PIPEMATERIAL_3 (type: esriFieldTypeString, alias: Fusion 3- Pipe Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [MDPE 2406: MDPE 2406 (Orange)], [HDPE 4710 / 3408: HDPE 4710 / 3408 (Black)], [MDPE 2406 / 2708: MDPE 2406/2708 (Yellow)], ... 2 more ...)
• RESULT_3 (type: esriFieldTypeString, alias: Fusion 3- Inspection Result, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Pass: Pass], [Fail visual: Fail visual], [Fail Pressure: Fail Pressure], ... 1 more ...)
• INSPECTIONZONEGUID (type: esriFieldTypeGUID, alias: INSPECTIONZONEGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• ACTIONTAKEN (type: esriFieldTypeString, alias: Repair Action Taken, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true, Coded Values: [None: No Action Needed], [Cut out and Remediated: Cut out and Remediated], [Cut out and Destricuviely tested: Cut out and Destructively tested], ... 1 more ...)
• MESSAGE (type: esriFieldTypeString, alias: Reminder:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Active: Active Asset], [Abandoned: Abandoned], [Retired: Retired])

Templates:

Name: Asset-Fusion Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• MESSAGE: TAKE REQUIRED ASSET PHOTO
• FITTINGNUM: 0
• FITTINGTYPE:
• FITTINGMATERIAL:
• REDUCERFLAG:
• FUSERID_1: 0
• INSPECTORID_1: 0
• FUSIONTYPE_1:
• PIPEMATERIAL_1:
• RESULT_1:
• ACTIONTAKEN:

Relationships:

• INSPECTIONZONE (0) -- Related To: Inspection Zone (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/19/2019 11:14:25 AM

Schema Last Edit Date: 9/19/2019 11:14:25 AM

Data Last Edit Date: 9/19/2019 11:14:25 AM

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