Name: ActivityTable

Display Field: sysno

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

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• activitydate (type: esriFieldTypeDate, alias: Activity Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• activitytype (type: esriFieldTypeString, alias: Activity Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CUL_INSP: General Inspection], [CUL_VID: Video Inspection Only], [CUL_SUPP: Support (QC)], ... 4 more ...)
• assettype (type: esriFieldTypeSmallInteger, alias: Asset Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Culvert], [2: Ditch], [3: Slotted Drain], ... 1 more ...)
• sysno (type: esriFieldTypeString, alias: System Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• etno (type: esriFieldTypeString, alias: End Treatment Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• inetno (type: esriFieldTypeString, alias: Inlet End Treatment Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• outetno (type: esriFieldTypeString, alias: Outlet End Treatment Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• district (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [01: District 1], [02: District 2], [03: District 3], ... 10 more ...)
• county (type: esriFieldTypeString, alias: County (CO), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [01: Del Norte (DN)], [02: Siskiyou (SIS)], [03: Modoc (MOD)], ... 55 more ...)
• route (type: esriFieldTypeString, alias: Route (RTE), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [001: 001], [002: 002], [003: 003], ... 245 more ...)
• prefixcode (type: esriFieldTypeString, alias: Prefix Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [00: 00 - Left - __ - No Prefix], [01: 01 - Left - R - Realignment], [02: 02 - Left - * - Signalized Intersection], ... 77 more ...)
• postmile (type: esriFieldTypeDouble, alias: System Postmile Begin (PM), SQL Type: sqlTypeOther, nullable: true, editable: true)
• activityid (type: esriFieldTypeString, alias: Activity ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: ActivityTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• View Overall Culvert System (3) -- Related To: Culvert System (0)
• View Associated End Treatment (4) -- Related To: End Treatments (1)
• View Associated Culvert (Line) (6) -- Related To: Culvert Line (3)
• View Associated Culvert (5) -- Related To: Culvert (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/29/2023 6:43:58 PM

Schema Last Edit Date: 9/29/2023 6:42:42 PM

Data Last Edit Date: 9/29/2023 6:43:58 PM

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