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.gov., 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], [occupant1: Homeowner/Public/Consumer], [developer1: Developer], ... 5 more ...)
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])
multi_stakeholder (type: esriFieldTypeString, alias: If your complaint involves more than one stakeholder, please use the plus "+" button and enter additional information. , 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], [occupant1: Homeowner/Public/Consumer], [developer1: Developer], ... 5 more ...)
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])
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)
general_sub (type: esriFieldTypeString, alias: Is the type of contractor a general or subcontractor?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [general: General Contractor], [subcontractor: Subcontractor], [unknown: Unknown])
sub_verification (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])
multi_issue_note (type: esriFieldTypeString, alias: If your complaint involves more than one root issue for the location, please use the plus "+" button and enter additional information. , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complaint_category (type: esriFieldTypeString, alias: Complaints about damage prevention activities generally fall into one of the following root categories and issues. Please select a root issue that best fits the reason for your complaint. Thank you., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [no_locate_request: No Locate Request], [excavation_practices: Excavation Practices], [invaild_request_use: Invalid Use of Locate Request by Excavator], ... 1 more ...)
no_811_reason (type: esriFieldTypeString, alias: To better understand more about "No Locate Request," was there was an apparent reason why this occurred? Please select the appropriate "known" reason below. If information is not available, please select "unknown/data not collected.", SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [unaware_of_811: Unaware of one-call center/811 notification], [thought_exempt: Thought they were exempt from rules], [thought_only_4_Pro Ex: Thought it only applied to professional excavators], ... 6 more ...)
ex_practices (type: esriFieldTypeString, alias: Excavation practices captures issues where something went wrong in the physical digging process. Please select the appropriate root issue below. If information is not available, please select "unknown/data not collected.", SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ex_clearance: Excavator failed to maintain clearence after verifying marks<], [ex_no_potholing: Excavator dug prior to verifying marks by potholing], [ex_failure_support: Excavator failed to shore/support facilties after exposure], ... 3 more ...)
invalid_811_use (type: esriFieldTypeString, alias: Invalid use of request by excavator is generally a misuse of the notification process or timeliness. Please select the appropriate root issue below. If information is not available, please select "unknown/data not collected.", SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [dug_prior: Excavator dug prior to valid date/start], [dug_after: Excavator dug after valid ticket expired], [dug_outside_area: Excavator dug outside the area described/outlined in the notification], ... 2 more ...)
locate_pract (type: esriFieldTypeString, alias: For locating and marking practices, please select the appropriate root issue below. If information is not available, select "unknown/data not collected.", SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [mark_inaccur: Facility marked inaccurately due to locator error], [marked_inaccur_bad_map: Facility marked inaccurately due to inaccurate facility map/record], [marked_inaccur_tracer_issue: Facility marked innaccurately due to tracerwire issue], ... 8 more ...)
Q_ticket_number (type: esriFieldTypeString, alias: Do you know the ticket number issued by Oregon's 811 one-call center?Visit the Oregon One-Call Center: https://or.itic.occinc.com/ and search for ticket numbers. Registering is not required to search for ticket number., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
ticket_number (type: esriFieldTypeString, alias: Please provide the Oregon One-Call ticket number., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
facility_type (type: esriFieldTypeString, alias: What type of underground facility is involved with your root concern?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [cable: Cable], [electric: Electric], [naturalgas: Natural Gas], ... 6 more ...)
branch_type (type: esriFieldTypeString, alias: Which line type is the underground facility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [main: Main], [primary: Primary], [secondary: Secondary], ... 2 more ...)
facility_size (type: esriFieldTypeString, alias: Is the width of the underground facility greater than 2 inches?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
loc_practice_description (type: esriFieldTypeString, alias: Please describe how or why locating and marking services were inadequate at the location., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
photo_Loc_gen (type: esriFieldTypeString, alias: Photos and documents are useful when investigating inaccurate locating and marking services provided by a Utility. You can attach photos to this complaint that supports your root issue., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Pho_inn_note (type: esriFieldTypeString, alias: Please provide photo(s) showing inaccurate locating and marking for the location. This should illustrate marking distance of from the actual location of underground facility., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Pho_no_note (type: esriFieldTypeString, alias: Please provide photo(s) of facilities without locating and marking. Photo(s) should illustrate the area or specific facilities that were not located and marked., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Loc_activiity_summary (type: esriFieldTypeString, alias: Do you have anything else to share that supports this root issue for the investigation? Thank you., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
excavation_verif_1 (type: esriFieldTypeString, alias: Notification to Oregon's one call/811 center is required for proposed excavations. Are you able to verify whether excavation took place? Additional information is needed for an investigation., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
insuf_ex_practices (type: esriFieldTypeString, alias: Please describe how or why damage prevention practices were inadequate at the location., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Project_Type_of_Work (type: esriFieldTypeString, alias: What type of work was being done when excavation took place?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [agriculture: Agriculture], [building construction: Building Construction], [building demolition: Building Demolition], ... 28 more ...)
excavation_know (type: esriFieldTypeString, alias: When did you discover or have knowledge excavation was taking place?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes_date_time: Yes, I know the date and time], [no: No], [yes_date_not_time: Yes, I know the date but not the time])
excavation_know_yes_date_time (type: esriFieldTypeDate, alias: Please provide date and time., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
excavation_know_yes_date (type: esriFieldTypeDate, alias: Please provide the date., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
excavation_began (type: esriFieldTypeString, alias: Do you know approximately when excavation activity started for the project?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes_date_time: Yes, I know the date and time], [no: No], [yes_date_not_time: Yes, I know the date but not the time])
excavation_yes_date_time (type: esriFieldTypeDate, alias: Please provide date and time., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
excavation_yes_date (type: esriFieldTypeDate, alias: Please provide the date., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ex_overall_image (type: esriFieldTypeString, alias: Do you have photos of the general area where excavation occurred? It would be helpful to see the overall location/site where excavation took place., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Q_mark_aboveground_facility (type: esriFieldTypeString, alias: In the area of excavation, are there any aboveground markers, utility facilities, vault lids, meters, conduits, visible or faint paint markings that would indicate presence of an underground facility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
within_24_inches (type: esriFieldTypeString, alias: Are there any underground facilities within 24 inches of the immediate area of excavation? If so, photos with measurements for reference is helpful. Thank you., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
ex_equipment_tools (type: esriFieldTypeString, alias: What type of equipment was used onsite by the excavating party?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [auger: Auger], [backhoe/track_excavator: Backhoe/Track Excavator], [boring: Boring], ... 12 more ...)
Q_ex_equipment_tools (type: esriFieldTypeString, alias: Do you have photos of the excavation equipment or tools used at the location onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
ex_damage_occur (type: esriFieldTypeString, alias: Did excavation cause damage to an underground facility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
outage_interuption_leak (type: esriFieldTypeString, alias: Did the damage cause an outage, service interruption and/or leak/release of product?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
potholed (type: esriFieldTypeString, alias: Was the location of the facility potholed to determine the exact location of the underground facility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
utility_expose (type: esriFieldTypeString, alias: Was the facility exposed and visible at the time of the damage?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
ex_handtool_damage (type: esriFieldTypeString, alias: Did the damage occur with hand tools?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
Ex_activities_sum (type: esriFieldTypeString, alias: Do you have any thing else to share in support on this root issue for the investigation? Thank you., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
photo_Loc_gen_2 (type: esriFieldTypeString, alias: Photos and documents are useful to demonstrate insufficient locating and marking services provided by a Utility. You can attach photos to this complaint that supports your root issue.Do you have documenation to attach with this complaint?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])