ALLOWED_AVGS_TABLE
This table gives users the ability to visualize the statistical shape of allowed amounts for procedure-specific claims across the US.
Queries that source from ALLOWED_AVGS_TABLE table
What is in the ALLOWED_AVGS_TABLE table?
Results are returned as a json, pySpark DataFrame, or pandas DataFrame (default).Helper Function within the CareQuery API to help understand the underlying ALLOWED_AVGS_TABLE dataset.
| feature | description | example |
|---|---|---|
| proc_code | CPT/HCPCS procedural code - used as a grouper for all corresponding statistics. | 27625 |
| proc_subcategory | Sub-categorical description of the procedure code - used as a grouper for all corresponding statistics. | 'Surgery - Musculoskeletal System' |
| state | US State where the procedure was performed - used as a grouper for all corresponding statistics. | 'KY' |
| payor_channel | Payor channel-of-business, line-of-business, or plan type - used as a grouper for all corresponding statistics. | 'Managed Medicaid' |
| visit_type | Description of the setting of care - used as a grouper for all corresponding statistics. | 'Outpatient Visit' |
| total_encounters | Total number of encounters corresponding to the groupers within the period and utilized in the allowed amount statistics. | 28 |
| trimmed_mean_allowed_amount | The mean allowed amount with outliers trimmed from consideration. | $ 366.46 |
| mean_allowed_amount | The mean allowed amount with all corresponding encounters considered. | $ 1,128.77 |
| min_allowed_amount | The minimum encounter allowed amount seen within the groupers/period. | $ 156.15 |
| percentile_10 | The 10th percentile of all allowed amount values seen within the corresponding groupers/period. | $ 247.86 |
| percentile_20 | The 20th percentile of all allowed amount values seen within the corresponding groupers/period. | $ 452.79 |
| percentile_50 | The 50th percentile of all allowed amount values seen within the corresponding groupers/period. | $ 632.16 |
| percentile_80 | The 80th percentile of all allowed amount values seen within the corresponding groupers/period. | $ 2,213.00 |
| percentile_90 | The 90th percentile of all allowed amount values seen within the corresponding groupers/period. | $ 2,788.31 |
| max_allowed_amount | The maximum encounter allowed amount seen within the groupers/period. | $ 3,111.53 |
| lookback_period | All values are computed within an year-long lookback period on a quarterly basis. This value represents the most recent quarter-year in which a lookback has occurred. | 'Q3-2023' |
| current | Binary indicator as to whether the listed period is the most current. | True |
# import package
from care_query.care_query import CareQuery
# instantiate and connect
cq = CareQuery(email = "your-email",
token = "your-api-token")
# return details
print(cq.glossary.table_detail('ALLOWED_AVGS_TABLE'))
Updated about 1 year ago