Name: plwc_gis.dbo.OutageLog
Display Field: DispatchName
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OutageID
(
type: esriFieldTypeOID, alias: OutageID
)
-
Acct
(
type: esriFieldTypeInteger, alias: Acct
)
-
Seq
(
type: esriFieldTypeInteger, alias: Seq
)
-
Account
(
type: esriFieldTypeString, alias: Account, length: 15
)
-
ServiceLocationNum
(
type: esriFieldTypeInteger, alias: ServiceLocationNum
)
-
ServiceAddress
(
type: esriFieldTypeString, alias: ServiceAddress, length: 75
)
-
OutageType
(
type: esriFieldTypeString, alias: OutageType, length: 75
)
-
department
(
type: esriFieldTypeString, alias: department, length: 25
)
-
DateTaken
(
type: esriFieldTypeDate, alias: DateTaken, length: 8
)
-
TakenBy
(
type: esriFieldTypeString, alias: TakenBy, length: 50
)
-
Cleared
(
type: esriFieldTypeSmallInteger, alias: Cleared
)
-
Status
(
type: esriFieldTypeString, alias: Status, length: 20
)
-
ClearDate
(
type: esriFieldTypeDate, alias: ClearDate, length: 8
)
-
AddrNum
(
type: esriFieldTypeString, alias: AddrNum, length: 20
)
-
Street
(
type: esriFieldTypeString, alias: Street, length: 50
)
-
DispatchedTo
(
type: esriFieldTypeInteger, alias: DispatchedTo
)
-
svcloc
(
type: esriFieldTypeString, alias: svcloc, length: 20
)
-
lastTimeCalled
(
type: esriFieldTypeDate, alias: lastTimeCalled, length: 8
)
-
CallCount
(
type: esriFieldTypeInteger, alias: CallCount
)
-
CauseOfOutage
(
type: esriFieldTypeString, alias: CauseOfOutage, length: 100
)
-
Comments
(
type: esriFieldTypeString, alias: Comments, length: 1000
)
-
ClearComment
(
type: esriFieldTypeString, alias: ClearComment, length: 1000
)
-
OnSite
(
type: esriFieldTypeSmallInteger, alias: OnSite
)
-
OnSiteDate
(
type: esriFieldTypeDate, alias: OnSiteDate, length: 8
)
-
LineFusePole
(
type: esriFieldTypeInteger, alias: LineFusePole
)
-
TransFusePole
(
type: esriFieldTypeInteger, alias: TransFusePole
)
-
Phone
(
type: esriFieldTypeString, alias: Phone, length: 25
)
-
Feeder
(
type: esriFieldTypeInteger, alias: Feeder
)
-
SpecialEquipment
(
type: esriFieldTypeString, alias: SpecialEquipment, length: 5000
)
-
PoleID
(
type: esriFieldTypeInteger, alias: PoleID
)
-
Located
(
type: esriFieldTypeString, alias: Located, length: 20
)
-
InfoSource
(
type: esriFieldTypeString, alias: InfoSource, length: 50
)
-
ConductorType
(
type: esriFieldTypeString, alias: ConductorType, length: 25
)
-
MajorOutage
(
type: esriFieldTypeSmallInteger, alias: MajorOutage
)
-
DispatchName
(
type: esriFieldTypeString, alias: DispatchName, length: 100
)
-
DispatchTime
(
type: esriFieldTypeDate, alias: DispatchTime, length: 8
)
-
LastUpdatedBy
(
type: esriFieldTypeString, alias: LastUpdatedBy, length: 50
)
-
LastUpdateTime
(
type: esriFieldTypeDate, alias: LastUpdateTime, length: 8
)
-
ObjectID
(
type: esriFieldTypeInteger, alias: OBJECTID
)
-
customer_id
(
type: esriFieldTypeInteger, alias: customer_id
)
-
customer_sequence
(
type: esriFieldTypeInteger, alias: customer_sequence
)
-
location_id
(
type: esriFieldTypeString, alias: location_id, length: 20
)
-
address
(
type: esriFieldTypeString, alias: address, length: 50
)
-
outage_type
(
type: esriFieldTypeString, alias: outage_type, length: 50
)
-
note
(
type: esriFieldTypeString, alias: note, length: 500
)
-
dispatch_id
(
type: esriFieldTypeInteger, alias: dispatch_id
)
-
dispatched_at
(
type: esriFieldTypeDate, alias: dispatched_at, length: 8
)
-
cleared_at
(
type: esriFieldTypeDate, alias: cleared_at, length: 8
)
-
created_at
(
type: esriFieldTypeDate, alias: created_at, length: 8
)
-
updated_at
(
type: esriFieldTypeDate, alias: updated_at, length: 8
)
-
deleted_at
(
type: esriFieldTypeDate, alias: deleted_at, length: 8
)
-
created_by
(
type: esriFieldTypeString, alias: created_by, length: 50
)
-
updated_by
(
type: esriFieldTypeString, alias: updated_by, length: 50
)
-
deleted_by
(
type: esriFieldTypeString, alias: deleted_by, length: 50
)
-
text_phone
(
type: esriFieldTypeDouble, alias: text_phone
)
-
caller
(
type: esriFieldTypeString, alias: caller, length: 50
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata