Database Query - Active Services Tiered Pricing Rates Entity
Last Modified on 09/23/2026 1:22 pm PDT
Pathway: Database > Database Query
The data extracted using the Active Services Tiered Pricing Rates entity contains the details about tiered pricing structures for an active service where the cost per unit changes based on the quantity of items serviced (e.g., "The first 5 boxes are $50 each, but boxes 6-10 are only $40 each"). This is most common in regulated medical waste and document destruction lines of business.
Initiating an Active Services Tiered Pricing Rates Query
To generate an Active Services Tiered Pricing Rates report using the Database Query tool, follow the steps outlined below. Reference the Database Query article for more details on how to use the tool for reporting.
- Go to the Database > Database Query screen.
- Click the New button in the top control bar. This will open the Select Main Entity popup.
- Select Active Services Tiered Pricing Rates.
- After the Display Fields for the Active Services Tiered Pricing Rates entity populate, select the check boxes for the fields you want to include in the report.
- If a specific order is required, select the fields in the order you want them to appear in the query.
- Click Run to execute the query. Results are generated in a new tab with the date and timestamp.
Columns Available for Display
The following data can be pulled in when running an Active Services Teired Pricing Rates report.
| Field Name |
Description |
| Site & Service Region |
| Site Id |
ID for the customer location where services are needed. |
| Site Name |
The name of the customer's physical location where services are needed. |
| Site Service Id |
ID for the specific service at the customer site. |
| Service Region Id |
ID for the geographic service region responsible for the service. |
| Service Region Name |
Name of the geographic service region responsible for the service. |
| Service Definition |
| Service Code Id |
ID for the service being provided. |
| Service Code Name |
Name of the service being offered, such as trash collection, regulated medical waste collection and disposal. |
| Service Frequency |
Frequency or fulfillment method for the service, such as scheduled collection, recurring service, or on-call service. |
| Charge & Pricing Schedule |
| Service Charge Id |
ID for the service charge record that contains the applicable pricing rules. |
| Service Charge Tiered Pricing Id |
ID for an individual tier within the service charge's pricing schedule. |
| Rate |
Charge applied when the service quantity falls within the associated pricing tier. |
| Charge Code Start Date |
Date on which the charge code and associated tiered rate become effective. |
| Charge Code End Date |
Date on which the charge code and associated tiered rate expire. A blank value generally indicates that the rate remains active. |
| Charge Code Name |
Business name of the pricing schedule or charge structure used to calculate the service fee. |
| Charge Code Id |
ID identifying the charge, rate schedule, or billing rule used for the service. |
| Equipment & Material |
| Equipment Type Id |
Identifier for the equipment associated with the charge. |
| Equipment Type Name |
Name of the equipment associated with the charge, such as a reusable 43-gallon medical waste container. |
| Material Type |
Name of the material being collected, processed, transported, or disposed of. |
| Material Type Id |
ID for the material being collected, processed, transported, or disposed of. |
| Tier Quantity Rules |
| From Quantity |
Minimum quantity included in the pricing tier. The tier applies when the service quantity begins at or above this value. |
| To Quantity |
Maximum quantity included in the pricing tier. The tier applies through this quantity unless the pricing type defines a different calculation. |
| Type |
Method used to apply the tiered rate, such as a per-unit charge or a total charge for the quantity range. |
| Regulatory & Operational Description |
| DOT Description |
Department of Transportation or operational description used to identify the regulated material, container, or service category for handling, transportation, and billing purposes. |
Entity Join Options
When running reports against the Active Services Tiered Pricing entity, the option to pull in data from other entities is provided by utilizing the Join feature in the Database Query tool.
Only select entities can join with other select entities. The only option provided for Active Services Tiered Pricing Rates is:
Reference the Database Query article for more details on how to use the Join option for more complex, detailed reporting.
Related Articles
Database Query
Active Services Overview
