Name: Post Install Audit Checklist

Display Field: pi_date

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 6748d587d6ad4ae58a79a837b484affc

Copyright Text:

Default Visibility: false

MaxRecordCount: 5000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• pi_date ( type: esriFieldTypeDate, alias: pi_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: pi_date )
• auditor ( type: esriFieldTypeString, alias: Auditor name:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: auditor )
• auditee ( type: esriFieldTypeString, alias: Contractor Person/Auditee Name:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: auditee )
• other_workers ( type: esriFieldTypeString, alias: If any, name of other Workers:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: other_workers )
• contractor ( type: esriFieldTypeString, alias: Contactor Company Name:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: contractor )
• address ( type: esriFieldTypeString, alias: Location/Site:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: address )
• wo_number ( type: esriFieldTypeString, alias: The Work Order (WO) number:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: wo_number )
• ten_days ( type: esriFieldTypeString, alias: Date of Audit within 10 days of install completion?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ten_days , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• sealed ( type: esriFieldTypeString, alias: Is the Customer Meter sealed incorrectly?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sealed , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• complaints ( type: esriFieldTypeString, alias: Are there any verified customer complaints?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: complaints , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• debris ( type: esriFieldTypeString, alias: Is there meter exchange debris at the work site?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: debris , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• damage_loc ( type: esriFieldTypeString, alias: Is there Customer property damage, such as overspray from painting?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: damage_loc , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• funtion ( type: esriFieldTypeString, alias: Is the Customer Meter functioning properly?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: funtion , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• damage_equip ( type: esriFieldTypeString, alias: Are there any visible cracks, and/or damages on the on equipment?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: damage_equip , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• leaks ( type: esriFieldTypeString, alias: Are there any gas leaks on the meter set?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: leaks , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• square ( type: esriFieldTypeString, alias: Is the meter set square?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: square , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• brackets ( type: esriFieldTypeString, alias: Are meter brackets used appropriately?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: brackets , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• correct_info ( type: esriFieldTypeString, alias: Does the removed meter picture match the information entered in the work order management system?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: correct_info , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• reg_number ( type: esriFieldTypeString, alias: Was the correct regulator number recorded?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: reg_number , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• match_serial ( type: esriFieldTypeString, alias: Does the meter on-site match meter records, badge number and reading?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: match_serial , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ten_day_com ( type: esriFieldTypeString, alias: Within 10 days comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: ten_day_com )
• sealed_com ( type: esriFieldTypeString, alias: Is the Customer Meter sealed incorrectly comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: sealed_com )
• complaints_com ( type: esriFieldTypeString, alias: Verified customer complaints comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: complaints_com )
• debris_com ( type: esriFieldTypeString, alias: Debris at the work site comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: debris_com )
• damage_loc_com ( type: esriFieldTypeString, alias: Customer property damage comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: damage_loc_com )
• function_com ( type: esriFieldTypeString, alias: Meter function comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: function_com )
• damage_equip_com ( type: esriFieldTypeString, alias: Are there any visible cracks, and/or damages on the on equipment comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: damage_equip_com )
• leaks_com ( type: esriFieldTypeString, alias: Gas leaks comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: leaks_com )
• square_com ( type: esriFieldTypeString, alias: Meter set square comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: square_com )
• brackets_com ( type: esriFieldTypeString, alias: Bracket use comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: brackets_com )
• correct_info_com ( type: esriFieldTypeString, alias: Removed meter information in WO management system comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: correct_info_com )
• reg_number_com ( type: esriFieldTypeString, alias: Regulator number recorded comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: reg_number_com )
• match_serial_com ( type: esriFieldTypeString, alias: Matching meter number recorded comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: match_serial_com )
• sealed_com_ca ( type: esriFieldTypeString, alias: Is the Customer Meter sealed incorrectly corrective actions, editable: true, nullable: true, length: 500, defaultValue: null, modelName: sealed_com_ca )
• complaints_ca ( type: esriFieldTypeString, alias: Verified customer complaints corrective actions, editable: true, nullable: true, length: 500, defaultValue: null, modelName: complaints_ca )
• debris_ca ( type: esriFieldTypeString, alias: Debris at the work site corrective actions, editable: true, nullable: true, length: 500, defaultValue: null, modelName: debris_ca )
• damage_loc_ca ( type: esriFieldTypeString, alias: Customer property damage corrective actions, editable: true, nullable: true, length: 500, defaultValue: null, modelName: damage_loc_ca )
• function_ca ( type: esriFieldTypeString, alias: Meter function corrective actions, editable: true, nullable: true, length: 500, defaultValue: null, modelName: function_ca )
• damage_equip_ca ( type: esriFieldTypeString, alias: Are there any visible cracks, and/or damages on the on equipment corrective actions, editable: true, nullable: true, length: 500, defaultValue: null, modelName: damage_equip_ca )
• leaks_ca ( type: esriFieldTypeString, alias: Gas leaks corrective actions, editable: true, nullable: true, length: 500, defaultValue: null, modelName: leaks_ca )
• square_ca ( type: esriFieldTypeString, alias: Meter set square corrective actions, editable: true, nullable: true, length: 500, defaultValue: null, modelName: square_ca )
• brackets_ca ( type: esriFieldTypeString, alias: Bracket use corrective actions, editable: true, nullable: true, length: 500, defaultValue: null, modelName: brackets_ca )
• correct_info_ca ( type: esriFieldTypeString, alias: Removed meter information in WO management system corrective actions, editable: true, nullable: true, length: 500, defaultValue: null, modelName: correct_info_ca )
• reg_number_ca ( type: esriFieldTypeString, alias: Regulator number recorded corrective actions, editable: true, nullable: true, length: 500, defaultValue: null, modelName: reg_number_ca )
• match_serial_ca ( type: esriFieldTypeString, alias: Matching meter number recorded corrective actions, editable: true, nullable: true, length: 500, defaultValue: null, modelName: match_serial_ca )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• visual_check ( type: esriFieldTypeString, alias: Visual check of Riser Corrosion, stressed, bare piping?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: visual_check , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• visual_check_com ( type: esriFieldTypeString, alias: Comments - Visual check of Riser Corrosion, stressed, bare piping?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: visual_check_com )
• jomar_stack ( type: esriFieldTypeString, alias: If the Jomar is stacked, was a valid reason for stacking given?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: jomar_stack , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• jomar_stack_com ( type: esriFieldTypeString, alias: Comments - If the Jomar is stacked, was a valid reason for stacking given?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: jomar_stack_com )
• correct_reg ( type: esriFieldTypeString, alias: Is the correct regulator installed following work order?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: correct_reg , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• correct_reg_com ( type: esriFieldTypeString, alias: Comments - Is the correct regulator installed following work order?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: correct_reg_com )
• clearance_reg ( type: esriFieldTypeString, alias: Do the clearances for the regulators meet code? Should an OPCO or vent extension (check all positions) be installed?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: clearance_reg , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• clearance_reg_com ( type: esriFieldTypeString, alias: Comments - Do the clearances for the regulators meet code? Should an OPCO or vent extension (check all positions) be installed?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: clearance_reg_com )
• commissioned ( type: esriFieldTypeString, alias: Is the meter commissioned as per the workorder?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: commissioned , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• commissioned_com ( type: esriFieldTypeString, alias: Comments - Is the meter commissioned as per the workorder?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: commissioned_com )
• jomar_oriented ( type: esriFieldTypeString, alias: Are the Jomar valves correctly oriented / accessible?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: jomar_oriented , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• jomar_oriented_com ( type: esriFieldTypeString, alias: Comments - Are the Jomar valves correctly oriented / accessible?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: jomar_oriented_com )
• pipe_config ( type: esriFieldTypeString, alias: Were best practices related to piping configurations followed?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pipe_config , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• pipe_config_com ( type: esriFieldTypeString, alias: Comments - Were best practices related to piping configurations followed?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: pipe_config_com )
• pipe_paint ( type: esriFieldTypeString, alias: Was the meter piping painted correctly? Underpainted?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pipe_paint , Coded Values: [Action Required: Action Required] , [Not Applicable: Not Applicable] , [Overall Satisfactory: Overall Satisfactory] , ...1 more... )
• pipe_paint_com ( type: esriFieldTypeString, alias: Comments - Was the meter piping painted correctly? Underpainted?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: pipe_paint_com )
• visual_check_ca ( type: esriFieldTypeString, alias: Corrective Action - Visual check of Riser Corrosion, stressed, bare piping?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: visual_check_ca )
• jomar_stack_ca ( type: esriFieldTypeString, alias: Corrective Action - If the Jomar is stacked, was a valid reason for stacking given?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: jomar_stack_ca )
• correct_reg_ca ( type: esriFieldTypeString, alias: Corrective Action - Is the correct regulator installed following work order?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: correct_reg_ca )
• clearance_reg_ca ( type: esriFieldTypeString, alias: Corrective Action - Do the clearances for the regulators meet code? Should an OPCO or vent extension (check all positions) be installed?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: clearance_reg_ca )
• commissioned_ca ( type: esriFieldTypeString, alias: Corrective Action - Is the meter commissioned as per the workorder?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: commissioned_ca )
• jomar_oriented_ca ( type: esriFieldTypeString, alias: Corrective Action - Are the Jomar valves correctly oriented / accessible?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: jomar_oriented_ca )
• pipe_config_ca ( type: esriFieldTypeString, alias: Corrective Action - Were best practices related to piping configurations followed?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: pipe_config_ca )
• pipe_paint_ca ( type: esriFieldTypeString, alias: Corrective Action - Was the meter piping painted correctly? Underpainted?, editable: true, nullable: true, length: 500, defaultValue: null, modelName: pipe_paint_ca )

Templates:

• Name: Post Install Audit Checklist
  Description:
  Prototype:
  pipe_config_ca: null
  pi_date: null
  auditor: null
  auditee: null
  other_workers: null
  contractor: null
  address: null
  wo_number: null
  ten_days: null
  sealed: null
  complaints: null
  debris: null
  damage_loc: null
  funtion: null
  damage_equip: null
  leaks: null
  square: null
  brackets: null
  correct_info: null
  reg_number: null
  GUID: null
  match_serial: null
  ten_day_com: null
  sealed_com: null
  complaints_com: null
  debris_com: null
  damage_loc_com: null
  function_com: null
  damage_equip_com: null
  leaks_com: null
  square_com: null
  brackets_com: null
  correct_info_com: null
  reg_number_com: null
  match_serial_com: null
  sealed_com_ca: null
  complaints_ca: null
  debris_ca: null
  damage_loc_ca: null
  function_ca: null
  damage_equip_ca: null
  leaks_ca: null
  square_ca: null
  brackets_ca: null
  correct_info_ca: null
  reg_number_ca: null
  match_serial_ca: null
  pipe_paint_ca: null
  jomar_oriented_ca: null
  commissioned_ca: null
  clearance_reg_ca: null
  correct_reg_ca: null
  visual_check: null
  visual_check_com: null
  jomar_stack: null
  jomar_stack_com: null
  correct_reg: null
  correct_reg_com: null
  clearance_reg: null
  clearance_reg_com: null
  commissioned: null
  commissioned_com: null
  jomar_oriented: null
  jomar_oriented_com: null
  pipe_config: null
  pipe_config_com: null
  pipe_paint: null
  pipe_paint_com: null
  visual_check_ca: null
  jomar_stack_ca: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.AMI_METERS (2) -- Related To: AESI METER PROGRAM (0)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

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

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:

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