Name: dwDischargeEvent

Display Field: DischTo

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)
• DischTo (type: esriFieldTypeString, alias: Discharging To, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Storm Drain: Storm Drain], [Sewer: Sewer], [Percolate to Ground: Percolate to Ground], ... 3 more ...)
• Creek (type: esriFieldTypeString, alias: Creek, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [San Juan Creek: San Juan Creek], [Trabuco Creek: Trabuco Creek], [El Horno Creek: El Horno Creek], ... 2 more ...)
• DateStart (type: esriFieldTypeDate, alias: Date Confirmed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TimeStart (type: esriFieldTypeString, alias: Time Confirmed, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FlowGPM (type: esriFieldTypeSmallInteger, alias: Flow Rate (GPM), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DateStop (type: esriFieldTypeDate, alias: Date Stopped, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TimeStop (type: esriFieldTypeString, alias: TimeStop, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• BMPsEmployed (type: esriFieldTypeString, alias: BMPs Employed, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• StopPriorBMP (type: esriFieldTypeString, alias: Stopped Prior to BMPs, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Device (type: esriFieldTypeString, alias: Device, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Air-Vac: Air-Vac], [Angle Stop: Angle Stop], [Blow Off Valve: Blow Off Valve], ... 8 more ...)
• Cause (type: esriFieldTypeString, alias: Cause, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Break: Break], [Malfunction: Malfunction], [Other: Other], ... 2 more ...)
• CorrectiveAction (type: esriFieldTypeString, alias: Corrective Action, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Break Repaired: Break Repaired], [Device Repaired: Device Repaired], [Isolation: Isolation], ... 2 more ...)
• PhoneNotify (type: esriFieldTypeString, alias: RCWQB Phone Notified, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PhoneNotifyDate (type: esriFieldTypeDate, alias: PhoneNotifyDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 264, nullable: true, editable: true)
• EntryComplete (type: esriFieldTypeString, alias: Form Entry Complete, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreateDate (type: esriFieldTypeDate, alias: Create Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• CreatedBy (type: esriFieldTypeString, alias: CreatedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• EditedDate (type: esriFieldTypeDate, alias: Edited Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• EditedBy (type: esriFieldTypeString, alias: Edited By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• RELATEKEY (type: esriFieldTypeString, alias: Relate Key, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Operator (type: esriFieldTypeString, alias: Operator, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• DischGals (type: esriFieldTypeInteger, alias: Gallons Discharged, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISID (type: esriFieldTypeString, alias: Discharge Id#, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)

Templates:

Name: dwDischargeEvent
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• DischGals: 1001
• DischTo: Storm Drain

Relationships:

• SJCWKGP.DBO.dwSystemValve (8) -- Related To: Potable Water Valves (9)
• dwNetworkStructure (0) -- Related To: Potable Reservoir (1)
• dwNetworkStructure (1) -- Related To: Potable Well (2)
• dwNetworkStructure (2) -- Related To: Potable Pump Station (3)
• dwMain (9) -- Related To: Potable Water Lines (13)
• dwMeter (7) -- Related To: Potable Meters (8)
• dwLateral (10) -- Related To: Potable Service Laterals (14)
• dwControlValve (4) -- Related To: Potable Control Valve (5)
• dwControlValve (5) -- Related To: Backflow Device (6)
• dwControlValve (6) -- Related To: Potable PRV (7)
• dwHydrant (3) -- Related To: Potable Hydrants (4)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/24/2024 10:03:30 PM

Schema Last Edit Date: 9/24/2024 10:03:30 PM

Data Last Edit Date: 9/24/2024 10:03:30 PM

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