Name: Asset_Tracking.DBO.Mainline_Work_Activity_Report

Display Field: Project_Number

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Supports ValidateSQL: true

Supports Calculate: false

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: [940: SC940] , [941: SC941] , [1021: SC1021] , ...5 more... )
• Inspected_By ( type: esriFieldTypeString, alias: Inspected By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspected_By , Coded Values: [Chris Peake: Chris Peake] , [Indranil Goswami: Indranil Goswami] , [Mike Griffith: Mike Griffith] , ...22 more... )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
• Orig_Scope_Work_Activity ( type: esriFieldTypeString, alias: Original Scoped Work Activity, editable: true, nullable: true, length: 35, defaultValue: null, modelName: Orig_Scope_Rehab , Coded Values: [Clean / Inspect: Clean / Inspect] , [Inspect/CCTV Only: Inspect/CCTV Only] , [CIPP Lining: CIPP Lining] , ...9 more... )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Material , Coded Values: [BCO: Brick and Concrete] , [BRK: Brick] , [BST: Brick and Stone] , ...21 more... )
• Pipe_Size ( type: esriFieldTypeSmallInteger, alias: Pipe Size, editable: true, nullable: true, defaultValue: null, modelName: Pipe_Size )
• Final_Work_Activity_Same ( type: esriFieldTypeString, alias: Final work activity same as design scope?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Final_Rehab_Same , Coded Values: [Yes: Yes] , [No: No] )
• Pipe_Work_Activity ( type: esriFieldTypeString, alias: Final Work Activity (As Constructed), editable: true, nullable: true, length: 30, defaultValue: null, modelName: Pipe_Rehab , Coded Values: [Clean / Inspect: Clean / Inspect] , [Inspect/CCTV Only: Inspect/CCTV Only] , [CIPP Lining: CIPP Lining] , ...9 more... )
• Material_Same ( type: esriFieldTypeString, alias: Pipe Material Same?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Material_Same , Coded Values: [Yes: Yes] , [No: No] )
• Pipe_Material ( type: esriFieldTypeString, alias: Final Pipe Material, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Pipe_Material , Coded Values: [BCO: Brick and Concrete] , [BRK: Brick] , [BST: Brick and Stone] , ...21 more... )
• Final_Pipe_Size ( type: esriFieldTypeSmallInteger, alias: Final Pipe Size (in), editable: true, nullable: true, defaultValue: null, modelName: Final_Pipe_Size )
• Pipe_Length_Same ( type: esriFieldTypeString, alias: Pipe Length Same?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Pipe_Length_Same , Coded Values: [Yes: Yes] , [No: No] )
• Final_Pipe_Length_FT ( type: esriFieldTypeInteger, alias: Final Pipe Length (ft), editable: true, nullable: true, defaultValue: null, modelName: Final_Pipe_Length_FT )
• Discrepancies ( type: esriFieldTypeString, alias: Discrepancy?, 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: [Alignment: Alignment] , [Slope: Slope] , [Invert Elevation: Invert Elevation] , ...2 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 256, defaultValue: null, modelName: Comments )
• RelObjectID ( type: esriFieldTypeInteger, alias: RelObjectID, editable: true, nullable: true, defaultValue: null, modelName: RelObjectID )
• Work_Activity_Status ( type: esriFieldTypeString, alias: Current Work Activity Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Rehab_Status , Coded Values: [Not Complete: Not Complete/Removed from Scope] , [In Progress: In Progress] , [Current Complete: Current Work Activity Complete] , ...2 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] )
• In_Service ( type: esriFieldTypeString, alias: Is Asset in Service?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Service , Coded Values: [Yes: Yes] , [No: No] )
• Full_Scope_Complete ( type: esriFieldTypeString, alias: Is all work activity complete?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Full_Scope_Complete , Coded Values: [Yes: Yes] , [No: No] )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, editable: true, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Editor )
• Contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Contractor , Coded Values: [Northeast Remsco Const., Inc: Northeast Remsco Const., Inc] , [Anchor Const., Corp.: Anchor Const., Corp.] , [REI: REI] , ...2 more... )
• In_Progress_Comment ( type: esriFieldTypeString, alias: Progress Comment, editable: true, nullable: true, length: 256, defaultValue: null, modelName: In_Progress_Comment )
• SEWER_ID ( type: esriFieldTypeString, alias: SEWER_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SEWER_ID )
• Guid_Core ( type: esriFieldTypeGUID, alias: Guid_Core, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid_Core )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )

Templates:

• Name: Asset_Tracking.DBO.Mainline_Work_Activity_Report
  Description:
  Prototype:
  Guid_Core: null
  SEWER_ID: null
  Project_Number: null
  Inspected_By: null
  Inspection_Date: null
  Orig_Scope_Work_Activity: null
  Material: null
  Pipe_Size: null
  Final_Work_Activity_Same: null
  Pipe_Work_Activity: null
  Material_Same: null
  Pipe_Material: null
  Final_Pipe_Size: null
  Pipe_Length_Same: null
  Final_Pipe_Length_FT: null
  Discrepancies: null
  Discrepancy_type: null
  Comments: null
  RelObjectID: null
  Work_Activity_Status: null
  Pipe_Size_Same: null
  In_Service: null
  Full_Scope_Complete: null
  Guid: null
  GlobalID: {00000000-0000-0000-0000-000000000000}
  CreationDate: null
  Creator: null
  EditDate: null
  Editor: null
  Contractor: null
  In_Progress_Comment: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• WW_Sewer (2) -- Related To: WW_Sewer (1)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

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   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata