Name: plwc_gis.dbo.OutageLog

Display Field: DispatchName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OutageID ( type: esriFieldTypeOID, alias: OutageID, editable: false, nullable: false, defaultValue: null, modelName: OutageID )
• Acct ( type: esriFieldTypeInteger, alias: Acct, editable: false, nullable: true, defaultValue: null, modelName: Acct )
• Seq ( type: esriFieldTypeInteger, alias: Seq, editable: false, nullable: true, defaultValue: null, modelName: Seq )
• Account ( type: esriFieldTypeString, alias: Account, editable: false, nullable: true, length: 15, defaultValue: null, modelName: Account )
• ServiceLocationNum ( type: esriFieldTypeInteger, alias: ServiceLocationNum, editable: false, nullable: true, defaultValue: null, modelName: ServiceLocationNum )
• ServiceAddress ( type: esriFieldTypeString, alias: ServiceAddress, editable: false, nullable: true, length: 75, defaultValue: null, modelName: ServiceAddress )
• OutageType ( type: esriFieldTypeString, alias: OutageType, editable: false, nullable: true, length: 75, defaultValue: null, modelName: OutageType )
• department ( type: esriFieldTypeString, alias: department, editable: false, nullable: true, length: 25, defaultValue: null, modelName: department )
• DateTaken ( type: esriFieldTypeDate, alias: DateTaken, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DateTaken )
• TakenBy ( type: esriFieldTypeString, alias: TakenBy, editable: false, nullable: true, length: 50, defaultValue: null, modelName: TakenBy )
• Cleared ( type: esriFieldTypeSmallInteger, alias: Cleared, editable: false, nullable: true, defaultValue: null, modelName: Cleared )
• Status ( type: esriFieldTypeString, alias: Status, editable: false, nullable: true, length: 20, defaultValue: null, modelName: Status )
• ClearDate ( type: esriFieldTypeDate, alias: ClearDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: ClearDate )
• AddrNum ( type: esriFieldTypeString, alias: AddrNum, editable: false, nullable: true, length: 20, defaultValue: null, modelName: AddrNum )
• Street ( type: esriFieldTypeString, alias: Street, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Street )
• DispatchedTo ( type: esriFieldTypeInteger, alias: DispatchedTo, editable: false, nullable: true, defaultValue: null, modelName: DispatchedTo )
• svcloc ( type: esriFieldTypeString, alias: svcloc, editable: false, nullable: true, length: 20, defaultValue: null, modelName: svcloc )
• lastTimeCalled ( type: esriFieldTypeDate, alias: lastTimeCalled, editable: false, nullable: true, length: 8, defaultValue: null, modelName: lastTimeCalled )
• CallCount ( type: esriFieldTypeInteger, alias: CallCount, editable: false, nullable: true, defaultValue: null, modelName: CallCount )
• CauseOfOutage ( type: esriFieldTypeString, alias: CauseOfOutage, editable: false, nullable: true, length: 100, defaultValue: null, modelName: CauseOfOutage )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: false, nullable: true, length: 1000, defaultValue: null, modelName: Comments )
• ClearComment ( type: esriFieldTypeString, alias: ClearComment, editable: false, nullable: true, length: 1000, defaultValue: null, modelName: ClearComment )
• OnSite ( type: esriFieldTypeSmallInteger, alias: OnSite, editable: false, nullable: true, defaultValue: null, modelName: OnSite )
• OnSiteDate ( type: esriFieldTypeDate, alias: OnSiteDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: OnSiteDate )
• LineFusePole ( type: esriFieldTypeInteger, alias: LineFusePole, editable: false, nullable: true, defaultValue: null, modelName: LineFusePole )
• TransFusePole ( type: esriFieldTypeInteger, alias: TransFusePole, editable: false, nullable: true, defaultValue: null, modelName: TransFusePole )
• Phone ( type: esriFieldTypeString, alias: Phone, editable: false, nullable: true, length: 25, defaultValue: null, modelName: Phone )
• Feeder ( type: esriFieldTypeInteger, alias: Feeder, editable: false, nullable: true, defaultValue: null, modelName: Feeder )
• SpecialEquipment ( type: esriFieldTypeString, alias: SpecialEquipment, editable: false, nullable: true, length: 5000, defaultValue: null, modelName: SpecialEquipment )
• PoleID ( type: esriFieldTypeInteger, alias: PoleID, editable: false, nullable: true, defaultValue: null, modelName: PoleID )
• Located ( type: esriFieldTypeString, alias: Located, editable: false, nullable: true, length: 20, defaultValue: null, modelName: Located )
• InfoSource ( type: esriFieldTypeString, alias: InfoSource, editable: false, nullable: true, length: 50, defaultValue: null, modelName: InfoSource )
• ConductorType ( type: esriFieldTypeString, alias: ConductorType, editable: false, nullable: true, length: 25, defaultValue: null, modelName: ConductorType )
• MajorOutage ( type: esriFieldTypeSmallInteger, alias: MajorOutage, editable: false, nullable: true, defaultValue: null, modelName: MajorOutage )
• DispatchName ( type: esriFieldTypeString, alias: DispatchName, editable: false, nullable: true, length: 100, defaultValue: null, modelName: DispatchName )
• DispatchTime ( type: esriFieldTypeDate, alias: DispatchTime, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DispatchTime )
• LastUpdatedBy ( type: esriFieldTypeString, alias: LastUpdatedBy, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastUpdatedBy )
• LastUpdateTime ( type: esriFieldTypeDate, alias: LastUpdateTime, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdateTime )
• ObjectID ( type: esriFieldTypeInteger, alias: OBJECTID, editable: false, nullable: true, defaultValue: null, modelName: ObjectID )
• customer_id ( type: esriFieldTypeInteger, alias: customer_id, editable: false, nullable: true, defaultValue: null, modelName: customer_id )
• customer_sequence ( type: esriFieldTypeInteger, alias: customer_sequence, editable: false, nullable: true, defaultValue: null, modelName: customer_sequence )
• location_id ( type: esriFieldTypeString, alias: location_id, editable: false, nullable: true, length: 20, defaultValue: null, modelName: location_id )
• address ( type: esriFieldTypeString, alias: address, editable: false, nullable: true, length: 50, defaultValue: null, modelName: address )
• outage_type ( type: esriFieldTypeString, alias: outage_type, editable: false, nullable: true, length: 50, defaultValue: null, modelName: outage_type )
• note ( type: esriFieldTypeString, alias: note, editable: false, nullable: true, length: 500, defaultValue: null, modelName: note )
• dispatch_id ( type: esriFieldTypeInteger, alias: dispatch_id, editable: false, nullable: true, defaultValue: null, modelName: dispatch_id )
• dispatched_at ( type: esriFieldTypeDate, alias: dispatched_at, editable: false, nullable: true, length: 8, defaultValue: null, modelName: dispatched_at )
• cleared_at ( type: esriFieldTypeDate, alias: cleared_at, editable: false, nullable: true, length: 8, defaultValue: null, modelName: cleared_at )
• created_at ( type: esriFieldTypeDate, alias: created_at, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_at )
• updated_at ( type: esriFieldTypeDate, alias: updated_at, editable: false, nullable: true, length: 8, defaultValue: null, modelName: updated_at )
• deleted_at ( type: esriFieldTypeDate, alias: deleted_at, editable: false, nullable: true, length: 8, defaultValue: null, modelName: deleted_at )
• created_by ( type: esriFieldTypeString, alias: created_by, editable: false, nullable: true, length: 50, defaultValue: null, modelName: created_by )
• updated_by ( type: esriFieldTypeString, alias: updated_by, editable: false, nullable: true, length: 50, defaultValue: null, modelName: updated_by )
• deleted_by ( type: esriFieldTypeString, alias: deleted_by, editable: false, nullable: true, length: 50, defaultValue: null, modelName: deleted_by )
• text_phone ( type: esriFieldTypeDouble, alias: text_phone, editable: false, nullable: true, defaultValue: null, modelName: text_phone )
• caller ( type: esriFieldTypeString, alias: caller, editable: false, nullable: true, length: 50, defaultValue: null, modelName: caller )

Templates:

• Name: plwc_gis.dbo.OutageLog
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata