Curated datasets

Billing-code institutional-vs-professional class

vlada_curated.dim_code_billing_class·live·dim·Billing Code Intelligence

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1For each billing code, the learned billing class (institutional vs professional) from observed counts: n_institutional, n_professional, institutional_frac, learned_class.
2Routes a claim line to the right benchmark (facility vs professional).

Grain

Key	Grain
N/A	1One row per (code_system, billing_code) — learned institutional/professional class.

Columns (7)

Column	Type	Meaning
`code_system`	string
`billing_code`	string
`n_institutional`	bigint
`n_professional`	bigint
`n_stated`	bigint
`institutional_frac`	double
`learned_class`	varchar(13)

Query it

describe_data_source(source_fqn="vlada_curated.dim_code_billing_class")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.dim_code_billing_class WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`billing_code`
Join	`how_to_join(source_fqn="vlada_curated.dim_code_billing_class")`
Raw door	Athena (read-only via query_substrate): vlada_curated.dim_code_billing_class

This page as markdown: /docs-md/data/vlada_curated_dim_code_billing_class.md · every page in one file: /llms-full.txt