Name: CISData

Display Field: PRD_MPU_ELECTRIC.DBO.CISData.firstname

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• PRD_MPU_ELECTRIC.DBO.CISData.OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• PRD_MPU_ELECTRIC.DBO.CISData.parcel ( type: esriFieldTypeString , alias: parcel , length: 25 )
• PRD_MPU_ELECTRIC.DBO.CISData.customer ( type: esriFieldTypeString , alias: customer , length: 15 )
• PRD_MPU_ELECTRIC.DBO.CISData.account ( type: esriFieldTypeString , alias: account , length: 15 )
• PRD_MPU_ELECTRIC.DBO.CISData.service ( type: esriFieldTypeString , alias: service , length: 2 )
• PRD_MPU_ELECTRIC.DBO.CISData.readtype ( type: esriFieldTypeString , alias: readtype , length: 2 )
• PRD_MPU_ELECTRIC.DBO.CISData.meter ( type: esriFieldTypeString , alias: meter , length: 10 )
• PRD_MPU_ELECTRIC.DBO.CISData.date_installed ( type: esriFieldTypeDate , alias: date_installed , length: 8 )
• PRD_MPU_ELECTRIC.DBO.CISData.firstname ( type: esriFieldTypeString , alias: firstname , length: 20 )
• PRD_MPU_ELECTRIC.DBO.CISData.midlename ( type: esriFieldTypeString , alias: midlename , length: 20 )
• PRD_MPU_ELECTRIC.DBO.CISData.lastname ( type: esriFieldTypeString , alias: lastname , length: 60 )
• PRD_MPU_ELECTRIC.DBO.CISData.street_address ( type: esriFieldTypeString , alias: street_address , length: 51 )
• PRD_MPU_ELECTRIC.DBO.CISData.owner_tenant ( type: esriFieldTypeString , alias: owner_tenant , length: 1 )
• PRD_MPU_ELECTRIC.DBO.CISData.phone ( type: esriFieldTypeString , alias: phone , length: 50 )
• PRD_MPU_ELECTRIC.DBO.CISData.demand ( type: esriFieldTypeDouble , alias: demand )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.OBJECTID ( type: esriFieldTypeInteger , alias: OBJECTID )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.AncillaryRole ( type: esriFieldTypeSmallInteger , alias: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.Enabled ( type: esriFieldTypeSmallInteger , alias: Enabled , Coded Values: [0: Open] , [1: Closed] )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.CreationUser ( type: esriFieldTypeString , alias: CreationUser , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.DateCreated ( type: esriFieldTypeDate , alias: DateCreated , length: 8 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.LastUser ( type: esriFieldTypeString , alias: LastUser , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.DateModified ( type: esriFieldTypeDate , alias: DateModified , length: 8 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.Comments ( type: esriFieldTypeString , alias: Comments , length: 100 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.LifecycleStatus ( type: esriFieldTypeString , alias: LifecycleStatus , length: 20 , Coded Values: [Construction: Construction] , [As-Built: As-Built] , [Abandoned: Abandoned] )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.InstallDate ( type: esriFieldTypeDate , alias: InstallDate , length: 8 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.FeederID ( type: esriFieldTypeString , alias: FeederID , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.FeederID2 ( type: esriFieldTypeString , alias: FeederID2 , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.JobTicket ( type: esriFieldTypeString , alias: JobTicket , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.Mfg ( type: esriFieldTypeString , alias: Mfg , length: 30 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.MfgDate ( type: esriFieldTypeDate , alias: MfgDate , length: 8 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.TraceWeight ( type: esriFieldTypeInteger , alias: TraceWeight )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.WorkOrder ( type: esriFieldTypeString , alias: WorkOrder , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.StationNo ( type: esriFieldTypeString , alias: StationNo , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.SymbolRotation ( type: esriFieldTypeDouble , alias: SymbolRotation )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.GlobalID ( type: esriFieldTypeGUID , alias: GlobalID , length: 38 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.SubtypeCode ( type: esriFieldTypeInteger , alias: Subtype )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.FeederInfo ( type: esriFieldTypeInteger , alias: Feeder Information )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.ServiceNo ( type: esriFieldTypeString , alias: Service Number , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.TransformerID ( type: esriFieldTypeInteger , alias: Transformer ID )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.AccountNumber ( type: esriFieldTypeInteger , alias: AccountNumber )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.DBID ( type: esriFieldTypeString , alias: DBID , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.BkAccount ( type: esriFieldTypeString , alias: BkAccount , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.Telephone ( type: esriFieldTypeString , alias: Telephone , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.MeterNumber ( type: esriFieldTypeString , alias: MeterNumber , length: 50 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.Address ( type: esriFieldTypeString , alias: Address , length: 50 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.Unit ( type: esriFieldTypeString , alias: Unit , length: 50 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.Cycle ( type: esriFieldTypeInteger , alias: Cycle )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.Route ( type: esriFieldTypeInteger , alias: Route )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.DeviceID ( type: esriFieldTypeString , alias: DeviceID , length: 50 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.RecorderID ( type: esriFieldTypeString , alias: RecorderID , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.RegisterID ( type: esriFieldTypeString , alias: RegisterID , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.MeterType ( type: esriFieldTypeString , alias: MeterType , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.Multiplier ( type: esriFieldTypeDouble , alias: Multiplier )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.Latitude ( type: esriFieldTypeDouble , alias: Longitude )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.Longitude ( type: esriFieldTypeDouble , alias: Latitude )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.LocationSource ( type: esriFieldTypeString , alias: LocationSource , length: 10 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.InstallationDate ( type: esriFieldTypeDate , alias: InstallationDate , length: 8 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.Phase ( type: esriFieldTypeInteger , alias: Phase , Coded Values: [4: A] , [2: B] , [1: C] , ...4 more... )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.ServAddrID ( type: esriFieldTypeInteger , alias: ServAddrID )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.OHUG ( type: esriFieldTypeString , alias: OHUG , length: 50 , Coded Values: [OH: OH] , [UG: UG] , [Unknown: Unknown] )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.PhasingCode ( type: esriFieldTypeInteger , alias: PhasingCode , Coded Values: [4: A] , [2: B] , [1: C] , ...4 more... )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.StakeoutStationGUID ( type: esriFieldTypeGUID , alias: StakeoutStationGUID , length: 38 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.TaxParcelID ( type: esriFieldTypeString , alias: TaxParcelID , length: 20 )
• PRD_MPU_ELECTRIC.DBO.ServiceLocation.FacilityID ( type: esriFieldTypeString , alias: Facility ID , length: 50 )

Supported Operations:   Query   Generate Renderer   Return Updates