DD-HLT-002
Inpatient Efficiency and Billing
Decide whether beds are being used well, which admissions return within a month, and how much of what was billed was actually collected.
- Healthcare
- L2 · CSV
- ~30,000 rows
- 8 tables
- 40 questions
Get the data
v1.0 · 6 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-HLT-002_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-HLT-002_Data_Dictionary.xlsx
- Business Introduction PDF DD-HLT-002_Business_Introduction.pdf
- Relationship Diagram PDF DD-HLT-002_Relationship_Model.pdf
- Raw fact data DD-HLT-002_FactAdmissions.csv
- Dimension / supporting data DD-HLT-002_Dimensions.zip
Questions
Open one to discuss it- Q017 Medium Monthly trend of encounter volume
- Q018 Medium Monthly trend of billed charges
- Q019 Medium Monthly trend of direct costs
- Q020 Medium Monthly trend of contribution before overhead
- Q021 Medium Monthly trend of collections allocated to encounters
- Q022 Medium Monthly trend of outstanding balances
- Q023 Medium Monthly trend of total waiting minutes
- Q024 Medium Monthly trend of completed encounters
- Q025 Medium Monthly trend of completed length-of-stay days
- Q026 Medium Year-on-year change in encounter volume
- Q027 Medium Year-on-year change in billed charges
- Q028 Medium Year-on-year change in direct costs
- Q029 Medium Year-on-year change in contribution before overhead
- Q030 Medium Year-on-year change in collections allocated to encounters
- Q031 Medium Year-on-year change in outstanding balances
- Q032 Medium Year-on-year change in total waiting minutes
- Q033 Medium Year-on-year change in completed encounters
- Q034 Medium Year-on-year change in completed length-of-stay days
- Q035 Medium Collection rate by month
- Q036 Medium Direct cost per encounter by month
General discussion
Anything about this dataset that is not one question — loading the files, which tool, how you set it up.
A free account takes a minute. Your draft is kept while you sign in.