Jump to Content
Home
Guides
Recipes
Changelog
v1.0
v1.1
Log In
Guides
Log In
Moon (Dark Mode)
Sun (Light Mode)
v1.1
Home
Guides
Recipes
Changelog
queryStatus
Search
Get Started
What is CareQuery?
Why CareQuery?
Quickstart
Medical queries
Longitudinal
careEncounter
careVisit
careEpisode
careJourney
Aggregate
Provider
providerDiagAggs
providerProcAggs
providerPayorAggs
providerPayorDiagAggs
providerPayorProcAggs
Organization
orgDiagAggs
orgProcAggs
orgPayorAggs
orgPayorDiagAggs
orgPayorProcAggs
Payor
payorDiagAggs
payorProcAggs
Geography
geoProcAggs
geoSpecProcAggs
Supplemental queries
Affiliation
affiliationActivity
updateAffiliation
Detail
diagDetail
drgDetail
geoDetail
mipsDetail
nppesDetail
procDetail
specialtyDetail
Financial
procAllowedAvgs
Outreach
execOutreach
providerOutreach
PRescription Queries
Longitudinal
scriptEncounter
scriptJourney
scriptDetail
Query Guides
Glossary
Parameters
department
diag_code
diag_category
diag_subcategory
division
drg_category
drg_code
exec_level
hospital
marketing_category
metro
payor
payor_channel
pharm_class
place_of_service
proc_code
proc_subcategory
proc_category
revenue_center_code
specialty
specialty_category
subspecialty
state
region
substance
system
visit_type
Tables
AFFILIATION_TABLE
ALLOWED_AVGS_TABLE
DIAG_TABLE
DRG_TABLE
EXEC_OUTREACH_TABLE
GEO_TABLE
JOURNEY_TABLE
MIPS_TABLE
NPPES_TABLE
PROC_TABLE
PROV_OUTREACH_TABLE
SCRIPT_TABLE
SCRIPT_DETAIL_TABLE
SPECIALTY_TABLE
PROV_DIAG_TABLE
PROV_PROC_TABLE
PROV_PAYOR_TABLE
PROV_PAYOR_PROC_TABLE
PROV_PAYOR_DIAG_TABLE
ORG_DIAG_TABLE
ORG_PROC_TABLE
ORG_PAYOR_TABLE
ORG_PAYOR_DIAG_TABLE
ORG_PAYOR_PROC_TABLE
PAYOR_DIAG_TABLE
PAYOR_PROC_TABLE
GEO_PROC_TABLE
GEO_SPEC_PROC_TABLE
EDGE_TABLE
EDGE_PROC_TABLE
EDGE_DIAG_TABLE
EDGE_PAYOR_TABLE
SFTP
queryStatus
sftpToPandas
Cyberduck
Data Model
Data Lineage
Entity Relationship Diagram
Advanced Query Logic
User Feedback
Use Cases
Impact
Powered by
queryStatus
Suggest Edits
Updated 10 months ago
