Name: AssetTrackers_DevelopmentDB.ASSET_TRACKER.Meter_Work_Report

Display Field: Contractor

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Supports ValidateSQL: true

Supports Calculate: true

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Contractor , Coded Values: [J. Fletcher Creamer & Son, Inc: J. Fletcher Creamer & Son, Inc] , [Civil Construction LLC: Civil Construction LLC] )
• Project_Number ( type: esriFieldTypeString, alias: Project_Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Project_Number , Coded Values: [1291: WC1291] , [1275: WC1275] , [1287: WC1287] , ...1 more... )
• Inspected_By ( type: esriFieldTypeString, alias: Inspected_By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspected_By , Coded Values: [Ashley Galloway: Ashley Galloway] , [Luke Mulry: Luke Mulry] , [Clarence Wayman: Clarence Wayman] , ...11 more... )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
• Meter_Work_Activity ( type: esriFieldTypeString, alias: Meter_Work_Activity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Meter_Work_Activity , Coded Values: [Retrofit / Repair Ex. Water Meter: Retrofit / Repair Ex. Water Meter] , [Replace Setting and Vault: Replace Setting and Vault] , [Replace Existing Water Meter: Replace Existing Water Meter] , ...3 more... )
• MT_Size_Same ( type: esriFieldTypeString, alias: MT_Size_Same, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MT_Size_Same , Coded Values: [Yes: Yes] , [No: No] )
• New_MT_Size ( type: esriFieldTypeDouble, alias: New_MT_Size, editable: true, nullable: true, defaultValue: null, modelName: New_MT_Size )
• Additional_Work_Activity ( type: esriFieldTypeString, alias: Additional_Work_Activity, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Additional_Work_Activity , Coded Values: [Yes: Yes] , [No: No] )
• Meter_Work_Activity1 ( type: esriFieldTypeString, alias: Meter_Work_Activity1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Meter_Work_Activity1 , Coded Values: [Retrofit / Repair Ex. Water Meter: Retrofit / Repair Ex. Water Meter] , [Replace Setting and Vault: Replace Setting and Vault] , [Replace Existing Water Meter: Replace Existing Water Meter] , ...3 more... )
• Work_Activity_Date ( type: esriFieldTypeDate, alias: Work_Activity_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Work_Activity_Date )
• Comment ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 70, defaultValue: null, modelName: Comment )
• Discrepancies ( type: esriFieldTypeString, alias: Discrepancies, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Discrepancies , Coded Values: [Yes: Yes] , [No: No] )
• Discrepancy_Type ( type: esriFieldTypeString, alias: Discrepancy_Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Discrepancy_Type , Coded Values: [Attribute: Attribute] , [Geometry: Geometry] , [Other: Other (see comments)] )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Comments )
• Work_Activity_Status ( type: esriFieldTypeString, alias: Work_Activity_Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Work_Activity_Status , Coded Values: [Not Complete: Not Complete/In Progress] , [Current Complete: Current Work Activity Complete] , [All Complete: All Work Activities Complete] , ...1 more... )
• In_Prog_Comment ( type: esriFieldTypeString, alias: In_Prog_Comment, editable: true, nullable: true, length: 150, defaultValue: null, modelName: In_Prog_Comment )
• In_Service ( type: esriFieldTypeString, alias: In_Service, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Service , Coded Values: [Yes: Yes] , [No: No] )
• All_Work_Complete ( type: esriFieldTypeString, alias: All_Work_Complete, editable: true, nullable: true, length: 3, defaultValue: null, modelName: All_Work_Complete , Coded Values: [Yes: Yes] , [No: No] )
• RelObjectID ( type: esriFieldTypeInteger, alias: RelObjectID, editable: true, nullable: true, defaultValue: null, modelName: RelObjectID )
• Meter_Install_Date ( type: esriFieldTypeDate, alias: Meter_Install_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Meter_Install_Date )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• Meter_No ( type: esriFieldTypeString, alias: Meter_No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Meter_No )
• In_Scope ( type: esriFieldTypeString, alias: In_Scope, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Scope , Coded Values: [Yes: Yes] , [No: No] )

Templates:

• Name: AssetTrackers_DevelopmentDB.ASSET_TRACKER.Meter_Work_Report
  Description:
  Prototype:
  Meter_No: null
  In_Scope: null
  Contractor: null
  Project_Number: null
  Inspected_By: null
  Inspection_Date: null
  Meter_Work_Activity: null
  MT_Size_Same: null
  New_MT_Size: null
  Additional_Work_Activity: null
  Meter_Work_Activity1: null
  Work_Activity_Date: null
  Comment: null
  Discrepancies: null
  Discrepancy_Type: null
  Comments: null
  Work_Activity_Status: null
  In_Prog_Comment: null
  In_Service: null
  All_Work_Complete: null
  RelObjectID: null
  Meter_Install_Date: null
  Guid: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• (0) -- Related To: WA_Meter (1)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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