Name: surveyPoint

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Survey Point","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: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• 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)
• wksp_date (type: esriFieldTypeDate, alias: Workshop or Meeting Date?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• sub_date (type: esriFieldTypeDate, alias: Date Comments Submitted, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• affiliation (type: esriFieldTypeString, alias: Affiliation, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [aff_telco_ind: Telecommunications Industry], [aff_cons_adovo: Consumer Advocacy], [aff_pub_body: Public Body], ... 3 more ...)
• aff_other (type: esriFieldTypeString, alias: Other - Affiliation, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• role (type: esriFieldTypeString, alias: Role description, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [role_reg_rep: Authorized Regulatory Representative], [role_mgr: Manager], [role_cur_emp: Current Employee], ... 3 more ...)
• role_other (type: esriFieldTypeString, alias: Other - Role description, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• telco_ind_type (type: esriFieldTypeString, alias: Telecommunications Industry, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [titype_wireless: Wireless], [titype_landline: Landline Telephone], [titype_cable_vid_tel: Cable offering video and telephone], ... 7 more ...)
• titype_other (type: esriFieldTypeString, alias: Other - Telecommunications Industry, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• consumer_advocacy (type: esriFieldTypeString, alias: Consumer Advocacy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [conad_oregon_spec: Oregon Specific], [conad_oregon_nat: Oregon and National], [conad_national: National], ... 2 more ...)
• conad_other (type: esriFieldTypeString, alias: Other - Consumer Advocacy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• public_body (type: esriFieldTypeString, alias: Public Body, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [pubbod_ore_st_agency: Oregon State Agency], [pubbod_ore_city_county: Oregon City or County Entity], [pubbod_ore_assn_pubbod: Oregon Association Representing Public Bodies], ... 5 more ...)
• pubbod_other (type: esriFieldTypeString, alias: Other - Public Body, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• landline_telco (type: esriFieldTypeString, alias: Landline Telephone Company, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [lantel_reg_ilec_req_rptg: Regulated ILEC Reporting Required], [lantel_reg_ilec_wav_rptg: Regulated ILEC Reporting Waiver], [lantel_coop: Co-op Exempt by Statute], ... 3 more ...)
• busof_hold_2 (type: esriFieldTypeString, alias: Business office call hold time 2 minutes., SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• busof_hold_5 (type: esriFieldTypeString, alias: Business office call hold time 5 minutes, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• busof_hold_10 (type: esriFieldTypeString, alias: Business office call hold time 10 minutes, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• busof_hold_25 (type: esriFieldTypeString, alias: Business office call hold time 25 minutes, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• busof_hold_1hr (type: esriFieldTypeString, alias: Business office call hold time 1 hour or longer, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• busof_hngup (type: esriFieldTypeString, alias: Business office hangs up after 30 min or longer, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• rprof_hold_2 (type: esriFieldTypeString, alias: Repair office call hold time 2 minutes, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• rprof_hold_5 (type: esriFieldTypeString, alias: Repair office call hold time 5 minutes, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• rprof_hold_10 (type: esriFieldTypeString, alias: Repair office call hold time 10 minutes, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• rprof_hold_25 (type: esriFieldTypeString, alias: Repair office call hold time 25 minutes, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• rprof_hold_1hr (type: esriFieldTypeString, alias: Repair office call hold time 1 hour or longer, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• rprof_hngup (type: esriFieldTypeString, alias: Repair office hang up after 30 min or longer, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• rptsrv_trbl (type: esriFieldTypeString, alias: Repeat service troubles, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• rptout (type: esriFieldTypeString, alias: Repeat outages, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• chginstldte (type: esriFieldTypeString, alias: Changing installation date more than onece, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• technoshow (type: esriFieldTypeString, alias: Technician no show, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• techlate (type: esriFieldTypeString, alias: Technician late, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• oosrpr_24hrs (type: esriFieldTypeString, alias: Out of service repair with in 24 hours, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• oosrpr_48hrs (type: esriFieldTypeString, alias: Out of service repair with in 48 hours, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• oosrpr_72hrs (type: esriFieldTypeString, alias: Out of service repair with in 72 hours, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• oosrpr_96hrs (type: esriFieldTypeString, alias: Out of service repair with in 96 hours, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• oosrpr_7days (type: esriFieldTypeString, alias: Out of service repair over 7days, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• glcble_3days (type: esriFieldTypeString, alias: Ground laid cable (temp repair) 3 days, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• glcble_1wk (type: esriFieldTypeString, alias: Ground laid cable 1 week, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• glcble_3wk (type: esriFieldTypeString, alias: Ground laid cable 3 weeks, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• glcble_1mth (type: esriFieldTypeString, alias: Ground laid cable 1 month or longer, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• static_notuseable (type: esriFieldTypeString, alias: Static making use very difficult or impossible, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• reftomakerpr (type: esriFieldTypeString, alias: Refusal of company to make service work, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• flrtorspndwhnprmse (type: esriFieldTypeString, alias: Failure of company to respond when promised, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• flrtoexpmedneedrpr (type: esriFieldTypeString, alias: Failure to expedite repair for Medical need, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• flrtoexpno911 (type: esriFieldTypeString, alias: Failure to expedite repair for no other access to 9-1-1, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• flrtoissuetrbletckt (type: esriFieldTypeString, alias: Failure to issue trouble ticket during outage, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• flrtoexpbusoosrpr (type: esriFieldTypeString, alias: Failure to expedite business out of service repair, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [cuex_no_con: No problem], [cuex_imp_4satis: Satisfaction is affected], [cuex_complaint: I am complain- ing], ... 1 more ...)
• poorrsq_affects_entire (type: esriFieldTypeString, alias: Poor service quality negatively affects the telecommunications industry as a whole., SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [prsqent_sd: Strongly disagree], [prsqent_d: Disagree], [prsqent_n: Neutral], ... 2 more ...)
• rsq_std_ben_industry (type: esriFieldTypeString, alias: Meaningful service quality standards positively benefit the industry as a whole., SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [rsqsbent_sd: Strongly disagree], [rsqsbent_d: Disagree], [rsqsbent_n: Neutral], ... 2 more ...)
• rsq_stand_protect_mktability (type: esriFieldTypeString, alias: High service quality standards are important to protect the marketability of telecommunications services., SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [rsqsmkt_sd: Strongly disagree], [rsqsmkt_d: Disagree], [rsqsmkt_n: Neutral], ... 2 more ...)
• field_23 (type: esriFieldTypeString, alias: Definition Update - does the definition for "Average Busy Season Busy Hour" continue to have relevence?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No], [choice2: It depends on....])
• field_24 (type: esriFieldTypeString, alias: Average Busy Season Busy Hour - explanation, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_25 (type: esriFieldTypeString, alias: Definition Update - Could the average speed of answer definition better reflect how systems work now?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No], [choice2: How?])
• field_26 (type: esriFieldTypeString, alias: Average Speed of Answer - How explanation., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_28 (type: esriFieldTypeString, alias: Definition Update - Does the definition for "Blocked Call" continue to have relevance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No], [choice2: It depends on...])
• field_27 (type: esriFieldTypeString, alias: Blocked Call - explanation, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_29 (type: esriFieldTypeString, alias: Definition Update - Does the "Final Trunk Group" definition continue to have relevance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No], [choice2: It depends on...])
• field_30 (type: esriFieldTypeString, alias: Final Trunk Group - explanation, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_31 (type: esriFieldTypeString, alias: Definition Update - Should the "Force Majeure" definition be revised?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No], [choice2: How?])
• field_32 (type: esriFieldTypeString, alias: Force Majeure - explanation, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• abh (type: esriFieldTypeString, alias: Definition Update - does the definition for "Average Busy Season Busy Hour" continue to have relevence? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [abh_yes: Yes], [abh_no: No], [abh_depends: It depends on....])
• abh_exp (type: esriFieldTypeString, alias: Average Busy Season Busy Hour - explanation , SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• asa (type: esriFieldTypeString, alias: Definition Update - Could the average speed of answer definition better reflect how systems work now? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [asa_yes: Yes], [asa_no: No], [asa_how: How?])
• asa_exp (type: esriFieldTypeString, alias: Average Speed of Answer - How explanation., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• bc (type: esriFieldTypeString, alias: Definition Update - Does the definition for "Blocked Call" continue to have relevance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [bc_yes: Yes], [bc_no: No], [bc_depends: It depends on...])
• bc_exp (type: esriFieldTypeString, alias: Blocked Call - explanation, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• ftg (type: esriFieldTypeString, alias: Definition Update - Does the "Final Trunk Group" definition continue to have relevance? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ftg_yes: Yes], [ftg_no: No], [ftg_depends: It depends on...])
• ftg_exp (type: esriFieldTypeString, alias: Final Trunk Group - explanation, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• fm (type: esriFieldTypeString, alias: Definition Update - Should the "Force Majeure" definition be revised? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [fm_yes: Yes], [fm_no: No], [fm_how: How?])
• fm_exp (type: esriFieldTypeString, alias: Force Majeure - explanation, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• fm_notification (type: esriFieldTypeString, alias: Do you think requiring a notification when a company utilizes force majeure (FM) is important? And should the personnel allowed to a utilize a FM exemption be limited? For example, prohibiting a service representative from telling a customer that there was a FM so they don't get a service credit or trouble report., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• icd (type: esriFieldTypeString, alias: Definition Update - Should the "Initial Commitment Date" definition be revised? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [icd_yes: Yes], [icd_no: No], [icd_how: How?])
• icd_exp (type: esriFieldTypeString, alias: Initial Commitment Date - explanation , SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• wc (type: esriFieldTypeString, alias: Definition Update - Should the "Wire Center" definition be revised?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [wc_yes: Yes], [wc_no: No], [wc_how: How?])
• wc_exp (type: esriFieldTypeString, alias: Wire Center - explanation, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• tr (type: esriFieldTypeString, alias: Definition Update - Should the "Trouble Report" definition be revised to clarify that an out-of-service condition may apply to phone lines that receive a dial tone but are otherwise unusable?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [tr_yes: Yes], [tr_no: No], [tr_how: How?])
• tr_exp (type: esriFieldTypeString, alias: Trouble Report - explanation, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• od (type: esriFieldTypeString, alias: What other definitions should staff consider revising, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [od_accessline: Access Line], [od_blockcall: Blocked Call], [od_customer: Customer], ... 6 more ...)
• od_other (type: esriFieldTypeString, alias: Other - What other definitions should staff consider revising, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• new_defs (type: esriFieldTypeString, alias: What definitions should staff consider adding?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• rd_reportdue (type: esriFieldTypeString, alias: Rule Update - Should staff include a due date for reports to be submitted? Currently 45 days is observed., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [rd_yes: Yes], [rd_no: No])
• ext6day (type: esriFieldTypeString, alias: Rule Update - Should staff consider extending the 6-day requirement for provisioning services that require design, such as T-1s?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ext6_yes: Yes], [ext6_no: No])
• hoext (type: esriFieldTypeString, alias: Rule Update - Should staff consider adding a 10% allowance to Provisioning and Held Orders?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [hoext_yes: Yes], [hoext_no: No])
• ho2 (type: esriFieldTypeString, alias: Rule Update - Should staff include the following change to Provisioning and Held Orders?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ho2_yes: Yes], [ho2_no: No])
• remove (type: esriFieldTypeString, alias: Rule Update - Should staff consider removing the weekend exception for Repair Clearing added in AR 575?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [remove_yes: Yes], [remove_no: No])
• rc2 (type: esriFieldTypeString, alias: Rule Update - Should staff add the following requirement to Repair Clearing?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [rc2_yes: Yes], [rc2_no: No])
• dts (type: esriFieldTypeString, alias: Rule Update - Should staff consider deleting the Dial Tone Speed requirement?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [dts_yes: Yes], [dts_no: No])
• ip (type: esriFieldTypeString, alias: Rule Update - Should staff include measurements applicable to Internet Protocol provisioned services?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ip_yes: Yes], [ip_no: No], [ip_what: What])
• ip_exp (type: esriFieldTypeString, alias: Applicable IP Service Measurements - explanation., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• increase (type: esriFieldTypeString, alias: Rule Update - Should staff consider increasing the minimum requirement for service quality reporting for Competitive Providers and Small Telecommunications Providers?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [increase_yes: Yes], [increase_no: No])
• increase_what (type: esriFieldTypeString, alias: At what line count level should reporting be required?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• increase_other (type: esriFieldTypeString, alias: Other - At what line count level should reporting be required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• t1allow (type: esriFieldTypeString, alias: Rule Update - Should staff consider an allowance for line counts associated with multi-channel services such as T-1, and DS-1?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [t1allow_yes: Yes], [t1allow_no: No])
• roos (type: esriFieldTypeString, alias: Rule Update - Should staff consider including a requirement to report repeat out-of-service conditions/, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [roos_yes: Yes], [roos_no: No])
• cablecust (type: esriFieldTypeString, alias: Cable Cuts, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repexp_helpful: Helpful and valid], [repexp_valid: Valid], [repexp_notvalid: No longer valid], ... 1 more ...)
• ISPblock (type: esriFieldTypeString, alias: ISP Blockage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repexp_helpful: Helpful and valid], [repexp_valid: Valid], [repexp_notvalid: No longer valid], ... 1 more ...)
• modemspeed (type: esriFieldTypeString, alias: Modem Speed Complaints, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repexp_helpful: Helpful and valid], [repexp_valid: Valid], [repexp_notvalid: No longer valid], ... 1 more ...)
• notrblefnd (type: esriFieldTypeString, alias: No trouble found, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repexp_helpful: Helpful and valid], [repexp_valid: Valid], [repexp_notvalid: No longer valid], ... 1 more ...)
• newfeature (type: esriFieldTypeString, alias: New Feature or Service, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repexp_helpful: Helpful and valid], [repexp_valid: Valid], [repexp_notvalid: No longer valid], ... 1 more ...)
• noaccess (type: esriFieldTypeString, alias: No Access, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repexp_helpful: Helpful and valid], [repexp_valid: Valid], [repexp_notvalid: No longer valid], ... 1 more ...)
• dtwin48 (type: esriFieldTypeString, alias: Duplicate Trouble Tickets with/in 48 hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repexp_helpful: Helpful and valid], [repexp_valid: Valid], [repexp_notvalid: No longer valid], ... 1 more ...)
• nonreg (type: esriFieldTypeString, alias: Non-Regulated or Deregulated Equipment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repexp_helpful: Helpful and valid], [repexp_valid: Valid], [repexp_notvalid: No longer valid], ... 1 more ...)
• lightning (type: esriFieldTypeString, alias: Lightning Strikes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repexp_helpful: Helpful and valid], [repexp_valid: Valid], [repexp_notvalid: No longer valid], ... 1 more ...)
• otherexemptions (type: esriFieldTypeString, alias: Are there other exemptions that should be considered?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• singoutage (type: esriFieldTypeString, alias: Rule Addition - Should staff consider adding a rule that would require specific processes for dealing with single source outages and include when trouble reports would and would not need to be logged?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [singoutage_yes: Yes], [singoutage_no: No])
• nors (type: esriFieldTypeString, alias: Rule Addition - Should staff consider requiring submission of the FCC's NORS outage reports in addition to the current reports?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [nors_yes: Yes], [nors_no: No])
• bundle (type: esriFieldTypeString, alias: Rule Addition - Should staff consider adding new or clarifying existing definitions and rules to ensure that regulated services provided in bundles qualify for trouble report treatment under the rules?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [bundle_yes: Yes], [bundle_no: No])
• internet (type: esriFieldTypeString, alias: Rule Addition - Should staff consider adding definitions and rules to ensure that when a customer calls about internet interruption of service that the service or repair representative also verify if there is regulated telephone service on the account and ask the customer if the outage is affecting that phone service?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [internet_yes: Yes], [internet_no: No])
• batgen (type: esriFieldTypeString, alias: Rule Addition- Should staff consider requiring annual reporting on maintenance of batteries and generators in remote terminals and central offices?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [batgen_yes: Yes], [batgen_no: No])
• new1 (type: esriFieldTypeString, alias: Rule or Definitions Suggestion #1, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• new2 (type: esriFieldTypeString, alias: Rule or Definition Suggestion #2, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• new3 (type: esriFieldTypeString, alias: Rule or Definition Suggestion #3, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/24/2020 7:18:23 PM

Schema Last Edit Date: 2/22/2019 11:25:30 AM

Data Last Edit Date: 2/22/2019 11:25:30 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat