Name: Table layer

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• ServiceCenter (type: esriFieldTypeString, alias: ServiceCenter, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ReportDate (type: esriFieldTypeDate, alias: ReportDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ReportType (type: esriFieldTypeString, alias: ReportType, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• RoutesExpected (type: esriFieldTypeDouble, alias: RoutesExpected, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RoutesCompleted (type: esriFieldTypeDouble, alias: RoutesCompleted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExpectedFinishTime (type: esriFieldTypeDate, alias: ExpectedFinishTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CompletedFinishTime (type: esriFieldTypeDate, alias: CompletedFinishTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RecycleRoutesExpected (type: esriFieldTypeDouble, alias: RecycleRoutesExpected, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YardWasteRoutesExpected (type: esriFieldTypeDouble, alias: YardWasteRoutesExpected, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HeavyTrashRoutesExpected (type: esriFieldTypeDouble, alias: HeavyTrashRoutesExpected, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RecycleRoutesCompleted (type: esriFieldTypeDouble, alias: RecycleRoutesCompleted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YardWasteRoutesCompleted (type: esriFieldTypeDouble, alias: YardWasteRoutesCompleted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HeavyTrashRoutesCompleted (type: esriFieldTypeDouble, alias: HeavyTrashRoutesCompleted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RecycleExpectedFinishTime (type: esriFieldTypeDate, alias: RecycleExpectedFinishTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• YardWasteExpectedFinishTime (type: esriFieldTypeDate, alias: YardWasteExpectedFinishTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HeavyTrashExpectedFinishTime (type: esriFieldTypeDate, alias: HeavyTrashExpectedFinishTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RecycleCompletedFinishTime (type: esriFieldTypeDate, alias: RecycleCompletedFinishTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• YardWasteCompletedFinishTime (type: esriFieldTypeDate, alias: YardWasteCompletedFinishTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HeavyTrashCompletedFinishTime (type: esriFieldTypeDate, alias: HeavyTrashCompletedFinishTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• RecycleWeek (type: esriFieldTypeString, alias: RecycleWeek, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [A: A], [B: B])
• CarryOverTrashRoutes (type: esriFieldTypeString, alias: CarryOverTrashRoutes, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CarryOverRecycleRoutes (type: esriFieldTypeString, alias: CarryOverRecycleRoutes, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ReportDay (type: esriFieldTypeString, alias: ReportDay, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• TotalAutoRoutes (type: esriFieldTypeInteger, alias: TotalAutoRoutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalRecyRoutes (type: esriFieldTypeInteger, alias: TotalRecyRoutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalYWRoutes (type: esriFieldTypeInteger, alias: TotalYWRoutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalHTRoutes (type: esriFieldTypeInteger, alias: TotalHTRoutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HT_Week (type: esriFieldTypeString, alias: HT_Week, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• NumCarryOverTrash (type: esriFieldTypeDouble, alias: NumCarryOverTrash, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumCarryOverRecy (type: esriFieldTypeDouble, alias: NumCarryOverRecy, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumCarryOverYW (type: esriFieldTypeInteger, alias: NumCarryOverYW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumCarryOverHT (type: esriFieldTypeInteger, alias: NumCarryOverHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CarryOverHTWeek (type: esriFieldTypeString, alias: CarryOverHTWeek, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CarryOverHTDay (type: esriFieldTypeString, alias: CarryOverHTDay, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CarryOverYWRoutes (type: esriFieldTypeString, alias: CarryOverYWRoutes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CarryOverHTRoutes (type: esriFieldTypeString, alias: CarryOverHTRoutes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• MidDayTime (type: esriFieldTypeDate, alias: MidDayTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TrashComments (type: esriFieldTypeString, alias: TrashComments, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• RecycleComments (type: esriFieldTypeString, alias: RecycleComments, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• YWComments (type: esriFieldTypeString, alias: YWComments, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• HTComments (type: esriFieldTypeString, alias: HTComments, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• TrashRoutesRemaining (type: esriFieldTypeInteger, alias: TrashRoutesRemaining, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RecycleRoutesRemaining (type: esriFieldTypeInteger, alias: RecycleRoutesRemaining, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YWRoutesRemaining (type: esriFieldTypeInteger, alias: YWRoutesRemaining, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HTRoutesRemaining (type: esriFieldTypeInteger, alias: HTRoutesRemaining, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrashMidDayFinish (type: esriFieldTypeDate, alias: TrashMidDayFinish, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RecycleMidDayFinish (type: esriFieldTypeDate, alias: RecycleMidDayFinish, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• YWMidDayFinish (type: esriFieldTypeDate, alias: YWMidDayFinish, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HTMidDayFinish (type: esriFieldTypeDate, alias: HTMidDayFinish, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/31/2025 8:03:07 PM

Schema Last Edit Date: 5/31/2025 8:03:07 PM

Data Last Edit Date: 5/31/2025 8:03:07 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat