Name: AssetTrackers_DevelopmentDB.ASSET_TRACKER.Main_Work_Report

Display Field: Project_Number

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 )
• 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... )
• 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] )
• 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 )
• Main_Work_Activity ( type: esriFieldTypeString, alias: Main_Work_Activity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Main_Work_Activity , Coded Values: [CIPP Lining: CIPP Lining] , [Internal Joint Seal Repairs: Internal Joint Seal Repairs] , [Sliplining: Sliplining] , ...10 more... )
• Pipe_Size_Same ( type: esriFieldTypeString, alias: Pipe_Size_Same, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Pipe_Size_Same , Coded Values: [Yes: Yes] , [No: No] )
• New_Pipe_Size ( type: esriFieldTypeDouble, alias: New_Pipe_Size, editable: true, nullable: true, defaultValue: null, modelName: New_Pipe_Size , Coded Values: [0.75: 0.75"] , [1: 1"] , [1.5: 1.5"] , ...40 more... )
• Material_Same ( type: esriFieldTypeString, alias: Material_Same, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material_Same , Coded Values: [Yes: Yes] , [No: No] )
• New_Material ( type: esriFieldTypeString, alias: New_Material, editable: true, nullable: true, length: 3, defaultValue: null, modelName: New_Material , Coded Values: [ASC: Asbestos Concrete Main] , [CI: Cast Iron Main] , [CON: Concrete Main] , ...14 more... )
• Length_Same ( type: esriFieldTypeString, alias: Length_Same, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Length_Same , Coded Values: [Yes: Yes] , [No: No] )
• New_Length ( type: esriFieldTypeDouble, alias: New_Length, editable: true, nullable: true, defaultValue: null, modelName: New_Length )
• 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] )
• Main_Work_Activity1 ( type: esriFieldTypeString, alias: Main_Work_Activity1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Main_Work_Activity1 , Coded Values: [CIPP Lining: CIPP Lining] , [Internal Joint Seal Repairs: Internal Joint Seal Repairs] , [Sliplining: Sliplining] , ...10 more... )
• 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: RelGlobalID, editable: true, nullable: true, defaultValue: null, modelName: RelObjectID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• Main_ID ( type: esriFieldTypeString, alias: Main_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Main_ID )
• In_Scope ( type: esriFieldTypeString, alias: In_Scope, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Scope , Coded Values: [Yes: Yes] , [No: No] )
• Work_Activity_Date ( type: esriFieldTypeDate, alias: Work_Activity_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Work_Activity_Date )

Templates:

• Name: AssetTrackers_DevelopmentDB.ASSET_TRACKER.Main_Work_Report
  Description:
  Prototype:
  In_Scope: null
  Work_Activity_Date: null
  Project_Number: null
  Contractor: null
  Inspected_By: null
  Inspection_Date: null
  Main_Work_Activity: null
  Pipe_Size_Same: null
  New_Pipe_Size: null
  Material_Same: null
  New_Material: null
  Length_Same: null
  New_Length: null
  Additional_Work_Activity: null
  Main_Work_Activity1: 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
  Guid: null
  Main_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• (4) -- Related To: WA_Main (4)

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