NAME |
TYPE |
LENGTH |
REQUIRED |
NOTES |
hj_import_int |
INT |
|
Y |
|
client_id |
VARCHAR |
100 |
Y |
Healthjump’s client identifier. |
client_patient_id |
VARCHAR |
40 |
Y |
Client ID acquired from the source system. |
first_name |
VARCHAR |
200 |
Y |
|
middle_name |
VARCHAR |
200 |
|
|
last_name |
VARCHAR |
200 |
|
|
prefix |
VARCHAR |
30 |
|
Mr. / Mrs. / Ms., etc. |
suffix |
VARCHAR |
30 |
|
MD / LNP / Sr. / Jr., etc. |
ssn |
VARCHAR |
9 |
|
|
dob |
VARCHAR |
8 |
|
Format: YYYYMMDD |
other_id |
VARCHAR |
40 |
|
Source System MRN, Medicare #, etc. |
account_id |
VARCHAR |
40 |
|
This field contains the patient account number assigned by accounting to which all charges, payments, etc., are recorded. Same as HL7 PID.18. |
gender |
VARCHAR |
1 |
|
|
race |
VARCHAR |
6 |
|
|
ethnicity |
VARCHAR |
1 |
|
|
primary_language |
VARCHAR |
20 |
|
Spoken, written or understood primary language, HITSPC80 Section 2.2.1.2.9 value set, http://www.ietf.org/rfc/rfc4646.txt |
phone_number |
VARCHAR |
10 |
|
|
phone_ext |
VARCHAR |
10 |
|
|
phone_type |
VARCHAR |
1 |
|
|
second_number |
VARCHAR |
10 |
|
|
second_ext |
VARCHAR |
10 |
|
|
second_type |
VARCHAR |
1 |
|
|
first_email |
VARCHAR |
100 |
|
|
second_email |
VARCHAR |
100 |
|
|
death_indication |
VARCHAR |
1 |
|
|
death_date |
VARCHAR |
8 |
|
|
address_type |
VARCHAR |
100 |
|
|
address_line_1 |
VARCHAR |
200 |
|
|
address_line_2 |
VARCHAR |
200 |
|
|
city |
VARCHAR |
50 |
|
|
state |
VARCHAR |
3 |
|
|
zip |
VARCHAR |
20 |
|
|
pcp_id |
VARCHAR |
20 |
|
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
row_hash |
CHAR |
32 |
|
For internal Healthjump use and reference. |