01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
ACCOUNT→PATIENTS.ACCOUNT
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ACCOUNT PK | string | varchar(12) | no | |
| 2 | AMB_TRIP_DATE PK | datetime | datetime | no | |
| 3 | PATIENT_WEIGHT | integer | int | yes | |
| 4 | HOSPITAL_ADMIT | string | char(1) | yes | |
| 5 | TYPE_OF_TRANSPORT | string | char(1) | yes | |
| 6 | BED_CONFINED_BEFORE | string | char(1) | yes | |
| 7 | BED_CONFINED_AFTER | string | char(1) | yes | |
| 8 | MOVED_BY_STRETCHER | string | char(1) | yes | |
| 9 | UNCONSCIOUS_SHOCK | string | char(1) | yes | |
| 10 | EMERGENCY | string | char(1) | yes | |
| 11 | PHYSICAL_RESTRAINTS | string | char(1) | yes | |
| 12 | VISIBLE_HEMORRHAGING | string | char(1) | yes | |
| 13 | TRANSPORT_TO_FOR | string | char(1) | yes | |
| 14 | MEDICALLY_NECESSARY | string | char(1) | yes | |
| 15 | MILES | decimal | decimal(5,1) | yes | |
| 16 | ORIGIN | string | varchar(40) | yes | |
| 17 | DESTINATION | string | varchar(40) | yes | |
| 18 | PURPOSE_ROUND_TRIP | string | varchar(80) | yes | |
| 19 | PURPOSE_STRETCHER | string | varchar(80) | yes | |
| 20 | DISCHARGED | string | char(1) | yes | |
| 21 | ADMITTED | string | char(1) | yes | |
| 22 | SERVICES_AVAILABLE | string | char(1) | yes | |
| 23 | ORIGIN_ADDR1 | string | varchar(55) | yes | |
| 24 | ORIGIN_ADDR2 | string | varchar(55) | yes | |
| 25 | ORIGIN_CITY | string | varchar(30) | yes | |
| 26 | ORIGIN_STATE | string | varchar(2) | yes | |
| 27 | ORIGIN_ZIP | string | varchar(10) | yes | |
| 28 | DEST_ADDR1 | string | varchar(55) | yes | |
| 29 | DEST_ADDR2 | string | varchar(55) | yes | |
| 30 | DEST_CITY | string | varchar(30) | yes | |
| 31 | DEST_STATE | string | varchar(2) | yes | |
| 32 | DEST_ZIP | string | varchar(10) | yes | |
| 33 | IS_DELETED | boolean | bit | yes |