Layer: _811_complaint_TEST

View In: Map Viewer

Name: _811_complaint_TEST_Form

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"OPUC - OUNC 811 Complaint/RAA form","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
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:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
complaint_note (type: esriFieldTypeString, alias: Following the requirements of Oregon's Utility Notification, Locating, Marking and Excavation rules is vital for reliability of utility service and public safety. Reinforcement of the rules and investigations of alleged violations can be initiated through a complaint process administered by Oregon Public Utility Commission (OPUC).Once you complete this Complaint Survey, OPUC Staff will contact you or your company's designated contact with follow-up information. Please be sure to include a preferred contact email address or phone number.The next few pages will ask for the following:Your contact informationContact information for who the complaint is againstLocation or Address where the event occurredRoot Issue for the investigation and supporting informationIf you have more information that could not be added to the Complaint Survey, please share it with us when we contact you. If you have any questions or would rather submit your complaint to OPUC Consumer Services Division Staff, please contact us at 503-378-6600, 800-522-2404 or email puc.consumer@puc.oregon.govTo continue, please "click" or "tap" the arrow button at the bottom of this page. Thank you., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
stakeholder_id (type: esriFieldTypeString, alias: Please select a stakeholder group that fits your description., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [contractor1: Contractor], [county1: County], [developer1: Developer], ... 6 more ...)
complainant_first_name (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_last_name (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_org (type: esriFieldTypeString, alias: Organization/Company, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
alternative_contact_yes_no (type: esriFieldTypeString, alias: Does your organization have a designated contact person or group for OPUC information requests?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
alternative_contact (type: esriFieldTypeString, alias: Designated Contact(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
alt_contact_muni (type: esriFieldTypeString, alias: Does your organization have a designated contact person or group for OPUC information requests?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
alternative_contact1 (type: esriFieldTypeString, alias: Designated Contact(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Stakeholder_Defendant_Offender (type: esriFieldTypeString, alias: Select the Stakeholder group or entity that your complaint is against., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [contractor1: Contractor], [county1: County], [developer1: Developer], ... 6 more ...)
defendant_first_name (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_last_name (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_organization_company (type: esriFieldTypeString, alias: Organization/Company, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
stakeholder_lic_number (type: esriFieldTypeString, alias: Does the company or individual have a CCB, LCB or other professional license number?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
lic_type (type: esriFieldTypeString, alias: Select license type., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
stakeholder_lic_text (type: esriFieldTypeString, alias: Please provide license number., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
stakeholder_lic_digit (type: esriFieldTypeString, alias: If other license number is available, please enter it here., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
multi_skakeholder (type: esriFieldTypeString, alias: If there is more than one underground facility operator involved, please list them below and any contact information you may have. Thank you., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
general_sub (type: esriFieldTypeString, alias: Was a general contractor onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
sub_verification (type: esriFieldTypeString, alias: Is your complaint against a subcontractor?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
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)
start_date (type: esriFieldTypeDate, alias: start_date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
end_date (type: esriFieldTypeDate, alias: end_date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Relationships:

_811_complaint_TEST_Form_Issues (1) -- Related To: Issues (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/11/2022 10:05:26 PM

Schema Last Edit Date: 12/11/2022 10:05:26 PM

Data Last Edit Date: 12/11/2022 10:05:26 PM

Supported Operations: Add Features Apply Edits Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: _811_complaint_TEST_Form (ID:0)