Name: Bench Test

Display Field:

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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)
• AssetGUID (type: esriFieldTypeGUID, alias: AssetGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• TesterName (type: esriFieldTypeString, alias: Name of Tester (Contractor), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• InspectorName (type: esriFieldTypeString, alias: Name of Inspector (MDOT), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bouvy: Bouvy N], [Brown: Brown M], [Davis: Davis D], ... 3 more ...)
• InspectionDateTime (type: esriFieldTypeDate, alias: Enter Inspection Date/Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Enter Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CUModel (type: esriFieldTypeString, alias: Enter Make/Model, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [COB: Cobalt], [M60: m60])
• CUSN (type: esriFieldTypeString, alias: Enter Serial Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• CUVersion (type: esriFieldTypeString, alias: Enter controller software version, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Labels (type: esriFieldTypeString, alias: Is CU labeled with intersection name, CS/Spot, and MDOT project number?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• StatusLED (type: esriFieldTypeString, alias: Is the Status Light green?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• Timing (type: esriFieldTypeString, alias: Does timing data in CU match timing permit?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• TODFlash (type: esriFieldTypeString, alias: Does CU enter and exit TOD flash correctly (if present)?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• PowerFailure (type: esriFieldTypeString, alias: Does CU exit from power failure correctly?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• TimingPlans (type: esriFieldTypeString, alias: Have all timing plans been run and verified as correct?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• PedDetectionMap (type: esriFieldTypeString, alias: Is pedestrian detection properly mapped to the correct phases (if present)? , SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• VehDetectionMap (type: esriFieldTypeString, alias: Is vehicle detection properly mapped to the correct phases (if present)?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• PreemptFunc (type: esriFieldTypeString, alias: Do preempts function properly (if present)?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• DataKey (type: esriFieldTypeString, alias: Is data key installed in CU? Is configuration saved on data key?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• Alarms (type: esriFieldTypeString, alias: Are there any active operator alerts/alarms that cannot be resolved on-site? , SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• AlarmNotes (type: esriFieldTypeString, alias: If acitve alarms were reported, enter details here. , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Network (type: esriFieldTypeString, alias: Do network settings match IP address spreadsheet?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• CUTime (type: esriFieldTypeString, alias: Is time/date correct in controller unit?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• PrintDataReport (type: esriFieldTypeString, alias: Was a printed hardcopy of the CU data report provided?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: N/A])
• InspectionResult (type: esriFieldTypeSmallInteger, alias: What is the result of the LDAT? , SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Pass], [0: Fail])
• Outstanding (type: esriFieldTypeString, alias: If fail, enter outstanding issues., SQL Type: sqlTypeOther, length: 255, 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: Bench Test
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• (1) -- Related To: Phase 1A Signal Deployment (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/15/2022 2:34:24 PM

Schema Last Edit Date: 5/5/2025 7:15:11 PM

Data Last Edit Date: 5/5/2025 7:15:11 PM

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