Table 2. List of files with variables (selective).
Files | Variables | Common variables |
---|---|---|
General information | - Beneficiary ID, age, gender, insurance number, type of insurance, date of review, provider ID, indicators for inpatients/outpatients, indicators for types of providers | Billing statement code, date & year of receipts |
- Operation related to primary diagnosis | ||
- Specialty | ||
- Dates of treatment, dates of dispensation | ||
- Primary diagnosis, secondary diagnosis, surgery, area of provider's practice | ||
- No. of days undergoing care, first visit to a physician, dates of encounter, date of admission, date of discharge | ||
- No. of days of supply for prescriptions, quantity of prescriptions, special codes for different out-of-pocket costs | ||
Healthcare services | - Procedures, inpatient prescriptions, diagnostic tests, treatments | |
- Operation, injection, and examination | ||
- Unit price, quantity per day, days of supply, etc | ||
Diagnosis | All diagnoses | |
Outpatient prescription | Quantity per time, quantity per day, days of supply, drug code, unit price, amount, date of prescription | |
Drug master | Drug code, date of starting (and terminating) coverage, drug name, unit, manufacturer, channel of administration, coverage, unit price, etc | |
Providers information | Provider ID, location, zip code, name of providers, types of provider, address, date of open, no. of business, no. of beds, etc |
ID = identification.