Name: AssetTrackers_DevelopmentDB.ASSET_TRACKER.Service_Work_Report

Display Field: Project_Number

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: 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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Project_Number ( type: esriFieldTypeString, alias: Project_Number, length: 50 , Coded Values: [1291: WC1291] , [1275: WC1275] , [1287: WC1287] , ...1 more... )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 30 , Coded Values: [J. Fletcher Creamer & Son, Inc: J. Fletcher Creamer & Son, Inc] , [Civil Construction LLC: Civil Construction LLC] )
• Inspected_By ( type: esriFieldTypeString, alias: Inspected_By, length: 50 , Coded Values: [Ashley Galloway: Ashley Galloway] , [Luke Mulry: Luke Mulry] , [Clarence Wayman: Clarence Wayman] , ...11 more... )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection_Date, length: 8 )
• Service_Work_Act ( type: esriFieldTypeString, alias: Service_Work_Act, length: 50 , Coded Values: [Renew Water Service: Renew Water Service] , [New Water Service: New Water Service] , [Replace Existing Water Service: Replace Existing Water Service] , ...2 more... )
• Pipe_Size_Same ( type: esriFieldTypeString, alias: Pipe_Size_Same, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• New_Pipe_Size ( type: esriFieldTypeDouble, alias: New_Pipe_Size , Coded Values: [0.63: .63"] , [0.75: .75"] , [1: 1"] , ...10 more... )
• Material_Same ( type: esriFieldTypeString, alias: Material_Same, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• New_Material ( type: esriFieldTypeString, alias: New_Material, length: 3 , Coded Values: [CI: Cast Iron] , [COP: Copper] , [DI: Ductile Iron] , ...6 more... )
• Length_Same ( type: esriFieldTypeString, alias: Length_Same, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• New_Length ( type: esriFieldTypeDouble, alias: New_Length )
• Additional_Work_Activity ( type: esriFieldTypeString, alias: Additional_Work_Activity, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Service_Work_Act1 ( type: esriFieldTypeString, alias: Service_Work_Act1, length: 50 , Coded Values: [Renew Water Service: Renew Water Service] , [New Water Service: New Water Service] , [Replace Existing Water Service: Replace Existing Water Service] , ...2 more... )
• Discrepancies ( type: esriFieldTypeString, alias: Discrepancies, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Discrepancy_Type ( type: esriFieldTypeString, alias: Discrepancy_Type, length: 20 , Coded Values: [Attribute: Attribute] , [Geometry: Geometry] , [Other: Other (see comments)] )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 150 )
• Work_Activity_Status ( type: esriFieldTypeString, alias: Work_Activity_Status, length: 20 , 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, length: 150 )
• In_Service ( type: esriFieldTypeString, alias: In_Service, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• All_Work_Complete ( type: esriFieldTypeString, alias: All_Work_Complete, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• RelObjectID ( type: esriFieldTypeInteger, alias: RelGlobalID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• In_Scope ( type: esriFieldTypeString, alias: In_Scope, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Work_Activity_Date ( type: esriFieldTypeDate, alias: Work_Activity_Date, length: 8 )

Relationships:

• (3) -- Related To: WA_Service (3)

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

  Iteminfo   Thumbnail   Metadata