Name: Post Install Audit Checklist

Display Field: pi_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 137e8c31f9f94ad6a0de76812c70a964

Copyright Text: null

Default Visibility: false

MaxRecordCount: 5000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: false
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: true
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: null

Fields:

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

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata