Layer: OpenReports (ID:0)

View In: Map Viewer

Name: OpenReports

Display Field: AssetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"WorkflowStage","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0}},"value":"1","label":"Created"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[203,246,217,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0}},"value":"2","label":"Submitted to Maintenance"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[75,195,146,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0}},"value":"3","label":"Submitted to Engineering"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[53,155,115,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0}},"value":"4","label":"In Progress"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[56,103,87,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0}},"value":"5","label":"Completed"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[57,84,76,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0}},"value":"6","label":"Closed"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,248,252,255],"toColor":[184,248,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,252,255],"toColor":[252,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[244,252,179,255],"toColor":[244,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,201,192,255],"toColor":[252,201,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,190,252,255],"toColor":[179,190,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[242,215,252,255],"toColor":[242,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,194,255],"toColor":[179,252,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,240,215,255],"toColor":[252,240,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,222,252,255],"toColor":[197,222,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,252,226,255],"toColor":[215,252,226,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,205,255],"toColor":[252,179,205,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[218,182,252,255],"toColor":[218,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,194,243,255],"toColor":[252,194,243,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: WorkflowStage

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)
AstID (type: esriFieldTypeInteger, alias: ast id, SQL Type: sqlTypeOther, nullable: true, editable: true)
AstGUID (type: esriFieldTypeString, alias: ast guid, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GISID (type: esriFieldTypeString, alias: gis id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TaskType (type: esriFieldTypeString, alias: Task Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Division (type: esriFieldTypeString, alias: Division, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AssetType (type: esriFieldTypeString, alias: Asset Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AssetName (type: esriFieldTypeString, alias: Asset Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ParentAsset (type: esriFieldTypeString, alias: Parent Asset, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
StructureName (type: esriFieldTypeString, alias: Structure Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
WorkflowStageDate (type: esriFieldTypeDate, alias: Workflow Stage Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CreatedBy (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CreatedDate (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
UpdatedBy (type: esriFieldTypeString, alias: Updated By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
UpdatedDate (type: esriFieldTypeDate, alias: Updated Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ObservedBy (type: esriFieldTypeString, alias: Observed By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ObservedDate (type: esriFieldTypeDate, alias: Observed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Deficiency (type: esriFieldTypeString, alias: Deficiency, SQL Type: sqlTypeOther, length: 32765, nullable: true, editable: true)
DeficiencyType (type: esriFieldTypeString, alias: Deficiency Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 32765, nullable: true, editable: true)
MaintenanceRemarks (type: esriFieldTypeString, alias: Maitenance Remarks, SQL Type: sqlTypeOther, length: 32765, nullable: true, editable: true)
EngineeringRemarks (type: esriFieldTypeString, alias: Engineering Remarks, SQL Type: sqlTypeOther, length: 32765, nullable: true, editable: true)
CompletedDate (type: esriFieldTypeDate, alias: Date Completed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DaysToToday (type: esriFieldTypeInteger, alias: Days To Today, SQL Type: sqlTypeOther, nullable: true, editable: true)
DaysAtStage (type: esriFieldTypeInteger, alias: Days At Workflow Stage, SQL Type: sqlTypeOther, nullable: true, editable: true)
GISStatus (type: esriFieldTypeString, alias: GIS Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
CreationDate (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
FieldRemarks (type: esriFieldTypeString, alias: Field Remarks, SQL Type: sqlTypeOther, length: 32765, nullable: true, editable: true)
MaintenanceDistrict2 (type: esriFieldTypeSmallInteger, alias: Maintenance District Abbr, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: GSP 1], [2: GSP 2], [3: GSP 3], ... 14 more ...)
MaintenanceDistrict (type: esriFieldTypeSmallInteger, alias: Maintenance District, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Parkway Maintenance District 1], [2: Parkway Maintenance District 2], [3: Parkway Maintenance District 3], ... 14 more ...)
Supervisor (type: esriFieldTypeString, alias: Supervisor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
WorkflowStage (type: esriFieldTypeSmallInteger, alias: Workflow Stage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Created], [2: Submitted to Maintenance], [3: Submitted to Engineering], ... 3 more ...)
BeyondMaintenance (type: esriFieldTypeSmallInteger, alias: Beyond Maintenance, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
IRContract (type: esriFieldTypeSmallInteger, alias: IR Contrator, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
OutsideAgency (type: esriFieldTypeSmallInteger, alias: Outside Agency, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
FieldRemarksChoice (type: esriFieldTypeString, alias: FieldRemarksChoice, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Supervisor_concat (type: esriFieldTypeString, alias: Supervisor_c, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)

Types:

Field Name: MaintenanceDistrict2
Inherited
Field Name: MaintenanceDistrict
Inherited
Field Name: WorkflowStage
Inherited
Field Name: BeyondMaintenance
Inherited
Field Name: IRContract
Inherited
Field Name: OutsideAgency
Inherited

WorkflowStage: 1

Field Name: MaintenanceDistrict2
Inherited
Field Name: MaintenanceDistrict
Inherited
Field Name: WorkflowStage
Inherited
Field Name: BeyondMaintenance
Inherited
Field Name: IRContract
Inherited
Field Name: OutsideAgency
Inherited

WorkflowStage: 2

Field Name: MaintenanceDistrict2
Inherited
Field Name: MaintenanceDistrict
Inherited
Field Name: WorkflowStage
Inherited
Field Name: BeyondMaintenance
Inherited
Field Name: IRContract
Inherited
Field Name: OutsideAgency
Inherited

WorkflowStage: 3

Field Name: MaintenanceDistrict2
Inherited
Field Name: MaintenanceDistrict
Inherited
Field Name: WorkflowStage
Inherited
Field Name: BeyondMaintenance
Inherited
Field Name: IRContract
Inherited
Field Name: OutsideAgency
Inherited

WorkflowStage: 4

Field Name: MaintenanceDistrict2
Inherited
Field Name: MaintenanceDistrict
Inherited
Field Name: WorkflowStage
Inherited
Field Name: BeyondMaintenance
Inherited
Field Name: IRContract
Inherited
Field Name: OutsideAgency
Inherited

WorkflowStage: 5

Field Name: MaintenanceDistrict2
Inherited
Field Name: MaintenanceDistrict
Inherited
Field Name: WorkflowStage
Inherited
Field Name: BeyondMaintenance
Inherited
Field Name: IRContract
Inherited
Field Name: OutsideAgency
Inherited

WorkflowStage: 6

Relationships:

Script_OpenReport_6_Files (0) -- Related To: OpenReportFiles (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/8/2023 3:48:44 PM

Schema Last Edit Date: 6/8/2023 3:48:44 PM

Data Last Edit Date: 6/8/2023 3:48:44 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