01Relates to the patient
ENCOUNTER + ENCOUNTER_LINE + CODING_METHOD matches ENCOUNTER_PROCS.ENCOUNTER + ENCOUNTER_PROCS.ENCOUNTER_LINE + ENCOUNTER_PROCS.CODING_METHOD on a row of ENCOUNTER_PROCS that relates to the patient
Single-patient export: the patient's rows.
02References
DIAG_CODE→DIAGNOSIS_CODES.DIAG_CODEENCOUNTER,ENCOUNTER_LINE,CODING_METHOD→ENCOUNTER_PROCS.ENCOUNTER,ENCOUNTER_LINE,CODING_METHOD
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ENCOUNTER PK | integer | int | no | |
| 2 | ENCOUNTER_LINE PK | integer | int | no | |
| 3 | CODING_METHOD PK | string | varchar(5) | no | |
| 4 | DIAG_CODE_NUMBER PK | integer | int | no | |
| 5 | DIAG_CODE | string | varchar(8) | no |