|
TYPE |
LEN |
REQ |
VALUE |
NOTES |
|
PK |
Y |
Demographic ID |
||
|
VARCHAR |
100 |
Y |
Client ID |
Healthjump's client identifier. |
|
VARCHAR |
40 |
Y |
Client Patient ID (Patient ID) |
Client ID acquired from the source system. |
|
VARCHAR |
200 |
Y |
First Name |
Patient’s first name. |
|
VARCHAR |
200 |
Middle Name |
Patient’s middle name. |
|
|
VARCHAR |
200 |
Y |
Last Name |
Patient’s last name. |
|
VARCHAR |
30 |
Name Prefix |
Mr. / Mrs. / Ms., etc. |
|
|
VARCHAR |
30 |
Name Suffix |
MD / LNP / Sr. / Jr., etc. |
|
|
VARCHAR |
9 |
Social Security Number |
||
|
VARCHAR |
8 |
Date of Birth |
Format: YYYYMMDD |
|
|
VARCHAR |
40 |
Patient Other ID |
Source System MRN, Medicare #, etc. |
|
|
VARCHAR |
40 |
Account ID |
Account ID acquired by the source system. |
|
|
VARCHAR |
1 |
Gender |
|
|
|
VARCHAR |
6 |
Race |
|
|
|
VARCHAR |
1 |
Ethnic Group |
|
|
|
VARCHAR |
20 |
Primary Language |
Spoken, written or understood primary language, HITSPC80 Section 2.2.1.2.9 value set, http://www.ietf.org/rfc/rfc4646.txt |
|
|
VARCHAR |
10 |
Primary Phone Number |
Patient’s primary phone number. |
|
|
VARCHAR |
10 |
Primary Phone Ext |
||
|
VARCHAR |
1 |
Primary Phone Type |
|
|
|
VARCHAR |
10 |
Secondary Phone Number |
||
|
VARCHAR |
10 |
Secondary Phone Ext |
||
|
VARCHAR |
1 |
Secondary Phone Type |
||
|
VARCHAR |
100 |
First Email |
||
|
VARCHAR |
100 |
Second Email |
||
|
VARCHAR |
1 |
Death Indication |
||
|
VARCHAR |
8 |
Death Date |
||
|
VARCHAR |
100 |
Address Type |
||
|
VARCHAR |
200 |
Address Line 1 |
||
|
VARCHAR |
200 |
Address Line 2 |
||
|
VARCHAR |
50 | City | ||
|
VARCHAR |
3 | State | ||
|
VARCHAR |
20 | Zip | ||
|
VARCHAR |
20 | PCP ID | ||
|
DATE (Time) |
HJ Create Timestamp | For internal Healthjump use and reference. | ||
|
DATE (Time) |
HJ Modify Timestamp | For internal Healthjump use and reference. | ||
|
CHAR |
32 | Row Hash | For internal Healthjump use and reference. |