01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
POD_SUPV_PROVIDER→REFERRING_PROVIDERS.REF_PROV_CODEACCOUNT→PATIENTS.ACCOUNT
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ACCOUNT PK | string | varchar(12) | no | |
| 2 | POD_DATE_REND_VISIT | datetime | datetime | yes | |
| 3 | NAIL_DEFORMITY | string | char(1) | yes | |
| 4 | FUNGAL_INFECTION_NECESSITY | string | char(1) | yes | |
| 5 | FUNGAL_DIAGNOSIS | string | char(1) | yes | |
| 6 | PODIATRIC_SERVICE_TYPE | string | char(1) | yes | |
| 7 | MYCOTIC_NAIL_ORGANISM | string | varchar(3) | yes | |
| 8 | MYCOTIC_NAIL_FUNGICIDE | string | varchar(3) | yes | |
| 9 | PODIATRY_SERVICE_CONDITION | string | varchar(3) | yes | |
| 10 | PODIATRY_THERAPY_TYPE | string | char(1) | yes | |
| 11 | POD_SUPV_PROVIDER | string | varchar(20) | yes |