office_visit__encounter_grain
At a glance
| Schema | dax_claims_preprocessing |
| Table | office_visit__encounter_grain |
| Layer | Claims Preprocessing |
| Object type | table |
| Columns | 48 |
| Tags | claims_preprocessing, encounters |
Columns
| Column | Type | Key | Terminology | Constraints | Description |
|---|---|---|---|---|---|
encounter_id | — | — | — | — | |
encounter_start_date | — | — | — | — | |
encounter_end_date | — | — | — | — | |
patient_data_source_id | — | — | — | — | |
encounter_type | — | — | — | — | |
encounter_group | — | — | — | — | |
person_id | — | — | — | — | |
admit_age | — | — | — | — | |
sex | — | Sex | — | — | |
race | — | Race | — | — | |
primary_diagnosis_code_type | — | — | — | — | |
primary_diagnosis_code | — | — | — | — | |
primary_diagnosis_description | — | — | — | — | |
facility_npi | — | — | — | — | |
observation_flag | integer | — | — | — | |
ed_flag | integer | — | — | — | |
lab_flag | integer | — | — | — | |
dme_flag | integer | — | — | — | |
ambulance_flag | integer | — | — | — | |
pharmacy_flag | integer | — | — | — | |
facility_name | — | — | — | — | |
facility_type | — | — | — | — | |
delivery_flag | integer | — | — | — | |
delivery_type | — | — | — | — | |
newborn_flag | integer | — | — | — | |
nicu_flag | integer | — | — | — | |
provider_first_name | — | — | — | — | |
provider_last_name | — | — | — | — | |
drg_code_type | — | — | — | — | |
drg_code | — | — | — | — | |
drg_description | — | — | — | — | |
medical_surgical | — | MS-DRG | — | — | |
admit_source_code | — | Admit source | — | — | |
admit_source_description | — | — | — | — | |
admit_type_code | — | Admit type | — | — | |
admit_type_description | — | — | — | — | |
discharge_disposition_code | — | Discharge disposition | — | — | |
discharge_disposition_description | — | — | — | — | |
total_paid_amount | — | — | — | — | |
total_allowed_amount | — | — | — | — | |
total_charge_amount | — | — | — | — | |
claim_count | — | — | — | — | |
inst_claim_count | — | — | — | — | |
prof_claim_count | — | — | — | — | |
length_of_stay | — | — | — | — | |
mortality_flag | integer | — | — | — | |
data_source | — | — | — | — | |
dax_last_run | — | — | — | — |
Querying
select *
from dax_claims_preprocessing.office_visit__encounter_grain
limit 100;