Name: GASDTE.TESTWIRE

Display Field: NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: be4fbda93ea64d4783e065273a537850

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:

N/A

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: SUBTYPECD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CREATIONUSER ( type: esriFieldTypeString, alias: Creation User, length: 20 )
• DATECREATED ( type: esriFieldTypeDate, alias: Date Created, length: 8 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: Date Modified, length: 8 )
• LASTUSER ( type: esriFieldTypeString, alias: Last User, length: 20 )
• SEQUENCE ( type: esriFieldTypeDouble, alias: SEQUENCE )
• SEQUENCEX ( type: esriFieldTypeDouble, alias: SEQUENCEX )
• TESTWIRETYPE ( type: esriFieldTypeString, alias: Test Wire Type, length: 5 , Coded Values: [DOT: Dot] , [REG: Reg] )
• TARGET1 ( type: esriFieldTypeString, alias: Target Location 1, length: 30 )
• TARGET2 ( type: esriFieldTypeString, alias: Target Location 2, length: 30 )
• TARGET3 ( type: esriFieldTypeString, alias: Target Location 3, length: 30 )
• TARGET4 ( type: esriFieldTypeString, alias: Target Location 4, length: 30 )
• PSREADING ( type: esriFieldTypeDouble, alias: PSREADING )
• REMOTEREADING ( type: esriFieldTypeDouble, alias: REMOTEREADING )
• PROTSTATUS ( type: esriFieldTypeString, alias: Protection Status, length: 4 )
• ACTIVE ( type: esriFieldTypeString, alias: Active, length: 3 , Coded Values: [NO: No] , [YES: Yes] , [UN: Unknown] )
• LETTER ( type: esriFieldTypeString, alias: LETTER, length: 1 )
• REGION ( type: esriFieldTypeString, alias: REGION, length: 15 )
• YEARDIGIT ( type: esriFieldTypeSmallInteger, alias: Last Digit of Read Year )
• DIRECTION ( type: esriFieldTypeString, alias: DIRECTION, length: 2 )
• READBY ( type: esriFieldTypeString, alias: READBY, length: 15 )
• READDATE ( type: esriFieldTypeDate, alias: Last Read Date, length: 8 )
• CANTEXCEEDDATE ( type: esriFieldTypeDate, alias: CANTEXCEEDDATE, length: 8 )
• NEXTTESTDATE ( type: esriFieldTypeDate, alias: Next Read Date, length: 8 )
• CPSYSTEMOBJECTID ( type: esriFieldTypeInteger, alias: CP System ObjectID )
• CPTESTPOINTOBJECTID ( type: esriFieldTypeInteger, alias: CP Test Point ObjectID )
• COMMENTS ( type: esriFieldTypeString, alias: Remarks, length: 15 )
• DISTRIBUTIONMAINOBJECTID ( type: esriFieldTypeInteger, alias: DISTRIBUTIONMAINOBJECTID )
• SERVICESECTIONOBJECTID ( type: esriFieldTypeInteger, alias: SERVICESECTIONOBJECTID )
• SUBTRANSMAINOBJECTID ( type: esriFieldTypeInteger, alias: SUBTRANSMAINOBJECTID )
• TRANSMAINOBJECTID ( type: esriFieldTypeInteger, alias: TRANSMAINOBJECTID )
• WORKREQUESTID ( type: esriFieldTypeString, alias: Work Request ID, length: 20 )
• DESIGNID ( type: esriFieldTypeString, alias: Design ID, length: 20 )
• WORKLOCATIONID ( type: esriFieldTypeString, alias: Work Location ID, length: 20 )
• WORKFLOWSTATUS ( type: esriFieldTypeInteger, alias: Work Flow Status , Coded Values: [0: None] , [1: In Design] , [5: Built] , ...6 more... )
• WORKFUNCTION ( type: esriFieldTypeInteger, alias: Work Function , Coded Values: [0: None] , [1: Install] , [2: Remove] , ...5 more... )
• NAME ( type: esriFieldTypeString, alias: NAME, length: 35 )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: SUBTYPECD )
• TARGET ( type: esriFieldTypeString, alias: TARGET LOCATION, length: 180 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )

Types:

ID: 1
Name: TestWire
Domains:
• TESTWIRETYPE:
  Inherited
• ACTIVE:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited

---

Relationships:

• ServiceSection (10) -- Related To: Service Section (10)
• TransmissionMain (56) -- Related To: Transmission Main (33)
• SubtransmissionMain (15) -- Related To: Sub-Transmission Main (14)
• CPTestPoint (58) -- Related To: Test Point (76)
• DistributionMain (13) -- Related To: Distribution Main (12)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata