Name: LeakRepair

Display Field: RepairedDate

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, 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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• LeakCause ( type: esriFieldTypeString , alias: Leak Cause , editable: true , nullable: true , length: 30 , Coded Values: [CORR: Corrosion] , [NATFOR: Natural Forces] , [EX: Excavation] , ...5 more... )
• Component ( type: esriFieldTypeString , alias: Component , editable: true , nullable: true , length: 30 , Coded Values: [Pipe: Pipe] , [Valve: Valve] , [Fitting: Fitting] , ...5 more... )
• ConditionOfPipe ( type: esriFieldTypeString , alias: Condition Of Adjoining Pipe , editable: true , nullable: true , length: 30 , Coded Values: [NR: Needs to be Replaced] , [NA: Not Applicable] , [OK: Okay] , ...2 more... )
• PartOfSystem ( type: esriFieldTypeString , alias: Part Of System , editable: true , nullable: true , length: 30 , Coded Values: [MAIN: Main] , [SERV: Service] , [SERVTAP: Service Tap] , ...6 more... )
• PipeSize ( type: esriFieldTypeString , alias: Pipe Size , editable: true , nullable: true , length: 30 , Coded Values: [.62: 5/8"] , [.75: 3/4"] , [1: 1"] , ...11 more... )
• PipeMaterial ( type: esriFieldTypeString , alias: Pipe Material , editable: true , nullable: true , length: 30 , Coded Values: [BARE STEEL: BARE STEEL] , [COATED STEEL: COATED STEEL] , [DUCTILE IRON: DUCTILE IRON] , ...4 more... )
• NumberLeaks ( type: esriFieldTypeInteger , alias: Number of Leaks , editable: true , nullable: true )
• RepairsMade ( type: esriFieldTypeString , alias: Repairs Made , editable: true , nullable: true , length: 255 )
• RepairedBy ( type: esriFieldTypeString , alias: Repaired By , editable: true , nullable: true , length: 50 )
• RepairedDate ( type: esriFieldTypeDate , alias: Repaired Date , editable: true , nullable: true , length: 8 )
• GasOff ( type: esriFieldTypeString , alias: Gas Off , editable: true , nullable: true , length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• Location ( type: esriFieldTypeString , alias: Location , editable: true , nullable: true , length: 255 )
• Comments ( type: esriFieldTypeString , alias: Comments , editable: true , nullable: true , length: 255 )
• WorkOrderNumber ( type: esriFieldTypeString , alias: Work Order Number , editable: true , nullable: true , length: 25 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: Leak Number , editable: false , nullable: false , length: 38 )
• RelatedGuid ( type: esriFieldTypeGUID , alias: RelatedGuid , editable: true , nullable: true , length: 38 )
• AtmoCorrosion ( type: esriFieldTypeString , alias: Atmospheric Corrosion , editable: true , nullable: true , length: 50 , Coded Values: [OTH: Other] , [UNK: Unknown] , [Y: Yes] , ...2 more... )
• created_user ( type: esriFieldTypeString , alias: created_user , editable: false , nullable: true , length: 255 )
• created_date ( type: esriFieldTypeDate , alias: created_date , editable: false , nullable: true , length: 8 )
• last_edited_user ( type: esriFieldTypeString , alias: last_edited_user , editable: false , nullable: true , length: 255 )
• last_edited_date ( type: esriFieldTypeDate , alias: last_edited_date , editable: false , nullable: true , length: 8 )

Templates:

• Name: LeakRepair
  Description:
  Prototype:
  RelatedGuid: null
  WorkOrderNumber: null
  LeakCause: null
  Component: null
  ConditionOfPipe: null
  PartOfSystem: null
  PipeSize: null
  PipeMaterial: null
  NumberLeaks: null
  RepairsMade: null
  RepairedBy: null
  RepairedDate: null
  GasOff: null
  Location: null
  Comments: null
  AtmoCorrosion: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Leak (2) -- Related To: Leak Report (4)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Ownership Based Access Control:

• Allow Others to Update: true
• Allow Others to Delete: false
• Allow Others to Query: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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