Name: Waste

Display Field: ReportYearMonth

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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)
• School_ID (type: esriFieldTypeString, alias: School ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Facility_ID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Building_Number (type: esriFieldTypeString, alias: Building Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• RTSRV_SERVICEDATE (type: esriFieldTypeDate, alias: RTSRV SERVICEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ReportWeekdayStart (type: esriFieldTypeDate, alias: Report Weekday Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ReportYear (type: esriFieldTypeSmallInteger, alias: Report Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ReportMonth (type: esriFieldTypeSmallInteger, alias: Report Month, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ReportWeek (type: esriFieldTypeSmallInteger, alias: Report Week, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ServiceDate (type: esriFieldTypeDate, alias: Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ReportYearMonth (type: esriFieldTypeString, alias: Report Year-Month, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Cust_No (type: esriFieldTypeSmallInteger, alias: Cust No, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Site_No (type: esriFieldTypeSmallInteger, alias: Site No, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Service_No (type: esriFieldTypeSmallInteger, alias: Service No, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Waste_Customer_ID (type: esriFieldTypeString, alias: Waste Customer ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Scale_Ticket_No (type: esriFieldTypeString, alias: Scale Ticket No, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Site_Name (type: esriFieldTypeString, alias: Site Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Service_Type (type: esriFieldTypeString, alias: Service Type, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Activity_Desc (type: esriFieldTypeString, alias: Activity Desc, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Cust_Name (type: esriFieldTypeString, alias: Cust Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Site_Address_2 (type: esriFieldTypeString, alias: Site Address 2, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Site_Address_3 (type: esriFieldTypeString, alias: Site Address 3, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Site_Address_4 (type: esriFieldTypeString, alias: Site Address 4, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Site_Address_5 (type: esriFieldTypeString, alias: Site Address 5, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Site_City (type: esriFieldTypeString, alias: Site City, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Site_State (type: esriFieldTypeString, alias: Site State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Site_Postal_ZIP (type: esriFieldTypeString, alias: Site Postal ZIP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Container_Qty (type: esriFieldTypeSmallInteger, alias: Container Qty, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Container_Size (type: esriFieldTypeSmallInteger, alias: Container Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Container_UoM (type: esriFieldTypeString, alias: Container UoM, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Container_Size_UoM (type: esriFieldTypeString, alias: Container Size UoM, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Exception_to_Service (type: esriFieldTypeString, alias: Exception to Service, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Exception_Category (type: esriFieldTypeString, alias: Exception Category, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Exception_Description (type: esriFieldTypeString, alias: Exception Description, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Exception_Memo (type: esriFieldTypeString, alias: Exception Memo, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Counter_Service_All (type: esriFieldTypeSmallInteger, alias: Counter Service All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Counter_Service_Compactor (type: esriFieldTypeString, alias: Counter Service Compactor, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Counter_Service_Excep_All (type: esriFieldTypeSmallInteger, alias: Counter Service Exceptions All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Counter_Service_Excep_Waste (type: esriFieldTypeSmallInteger, alias: Counter Service Exceptions Waste, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Counter_Service_Excep_Recycling (type: esriFieldTypeSmallInteger, alias: Counter Service Exceptions Recycling, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Counter_Recycling (type: esriFieldTypeSmallInteger, alias: Counter Recycling, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Counter_Waste (type: esriFieldTypeSmallInteger, alias: Counter Waste, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RTSRV_PctFull (type: esriFieldTypeSmallInteger, alias: RTSRV PctFull, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RTSRV_PctContaminate (type: esriFieldTypeSmallInteger, alias: RTSRV PctContaminate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RTSRV_PctCardboard (type: esriFieldTypeSmallInteger, alias: RTSRV PctCardboard, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RTSRV_PctGlass (type: esriFieldTypeSmallInteger, alias: RTSRV PctGlass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RTSRV_PctMetal (type: esriFieldTypeSmallInteger, alias: RTSRV PctMetal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RTSRV_PctPlastic (type: esriFieldTypeSmallInteger, alias: RTSRV PctPlastic, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RTSRV_PctPaper (type: esriFieldTypeSmallInteger, alias: RTSRV PctPaper, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RTSRV_PctCommingle (type: esriFieldTypeSmallInteger, alias: RTSRV PctCommingle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RTSRV_LEEDCntVolYDS (type: esriFieldTypeSmallInteger, alias: RTSRV LEEDCntVolYDS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONTAINER_CAPACITY_VOL (type: esriFieldTypeDouble, alias: CONTAINER CAPACITY VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_COLLECTED_VOL (type: esriFieldTypeDouble, alias: RECYCLING COLLECTED VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_CONTAINER_CAPACITY_VO (type: esriFieldTypeDouble, alias: RECYCLING CONTAINER CAPACITY VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_CONTAMINATE_VOL (type: esriFieldTypeDouble, alias: RECYCLING CONTAMINATE VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_CARDBOARD_VOL (type: esriFieldTypeDouble, alias: RECYCLING CARDBOARD VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_GLASS_VOL (type: esriFieldTypeDouble, alias: RECYCLING GLASS VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_METAL_VOL (type: esriFieldTypeDouble, alias: RECYCLING METAL VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_PLASTIC_VOL (type: esriFieldTypeDouble, alias: RECYCLING PLASTIC VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_PAPER_VOL (type: esriFieldTypeDouble, alias: RECYCLING PAPER VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_COMMINGLE_VOL (type: esriFieldTypeDouble, alias: RECYCLING COMMINGLE VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_NET_VOL (type: esriFieldTypeDouble, alias: RECYCLING NET VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WASTE_COLLECTED_VOL (type: esriFieldTypeDouble, alias: WASTE COLLECTED VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WASTE_CONTAINER_CAPACITY_VOL (type: esriFieldTypeDouble, alias: WASTE CONTAINER CAPACITY VOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WASTE_COLLECTED_TONS_Estimated (type: esriFieldTypeDouble, alias: WASTE COLLECTED TONS Estimated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WASTE_COLLECTED_TONS_Actual (type: esriFieldTypeDouble, alias: WASTE COLLECTED TONS Actual, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WASTE_COLLECTED_TONS_ACTorEST (type: esriFieldTypeDouble, alias: WASTE COLLECTED TONS ACTorEST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_COLLECTED_TONS_Est (type: esriFieldTypeDouble, alias: RECYCLING COLLECTED TONS Estimated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_CONTAMINATE_TONS_Est (type: esriFieldTypeDouble, alias: RECYCLING CONTAMINATE TONS Estimated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_NET_TONS_Est (type: esriFieldTypeDouble, alias: RECYCLING NET TONS Estimated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_CARDBOARD_TONS_Est (type: esriFieldTypeDouble, alias: RECYCLING CARDBOARD TONS Estimated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_GLASS_TONS_Est (type: esriFieldTypeDouble, alias: RECYCLING GLASS TONS Estimated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_METAL_TONS_Est (type: esriFieldTypeDouble, alias: RECYCLING METAL TONS Estimated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_PLASTIC_TONS_Est (type: esriFieldTypeDouble, alias: RECYCLING PLASTIC TONS Estimated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_PAPER_TONS_Est (type: esriFieldTypeDouble, alias: RECYCLING PAPER TONS Estimated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLING_COMMINGLE_TONS_Est (type: esriFieldTypeDouble, alias: RECYCLING COMMINGLE TONS Estimated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Compactor_Weight_Actual (type: esriFieldTypeDouble, alias: Compactor Weight Actual, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Site_Name_Address (type: esriFieldTypeString, alias: Site Name & Address, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Service_Description (type: esriFieldTypeString, alias: Service Description, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Waste
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/22/2023 5:32:30 PM

Schema Last Edit Date: 2/22/2023 5:32:30 PM

Data Last Edit Date: 2/22/2023 5:32:30 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat