input_layer__encounter
Encounters as reported by clinical source systems, before claims-based encounter grouping. Use dax_core.encounter for analysis; this table is the source contract and the place to check what an EHR actually sent.
At a glance
| Schema | dax_input_layer |
| Table | input_layer__encounter |
| Layer | Input Layer |
| Object type | view |
| Columns | 22 |
| Grain | encounter_id, data_source |
| Tags | input_layer |
Columns
| Column | Type | Key | Constraints | Description |
|---|---|---|---|---|
encounter_id | varchar | PK | — | — |
person_id | varchar | — | — | |
patient_id | varchar | — | — | |
encounter_type | varchar | — | — | |
encounter_start_date | date | — | — | |
encounter_end_date | date | — | — | |
admit_source_code | varchar | — | — | |
admit_type_code | varchar | — | — | |
discharge_disposition_code | varchar | — | — | |
attending_provider_id | varchar | — | — | |
attending_provider_name | varchar | — | — | |
facility_npi | varchar | — | — | |
facility_name | varchar | — | — | |
primary_diagnosis_code_type | varchar | — | — | |
primary_diagnosis_code | varchar | — | — | |
drg_code_type | varchar | — | — | |
drg_code | varchar | — | — | |
paid_amount | number | — | — | |
allowed_amount | number | — | — | |
charge_amount | number | — | — | |
ingest_datetime | timestamp | — | — | |
data_source | varchar | PK | — | — |
Querying
select *
from dax_input_layer.input_layer__encounter
limit 100;