Note: This table is not part of our data model, but can be requested. Please speak to your sales representative for more details.
|
TYPE |
LEN |
REQ |
VALUE |
NOTES |
|
PK |
Y |
Location Primary Key |
||
|
VARCHAR |
100 |
Y |
Client ID |
Healthjump’s client identifier. |
|
VARCHAR |
50 |
Y |
Location ID |
Location ID obtained from the source system |
|
VARCHAR |
500 |
Y |
Location Name |
|
|
VARCHAR |
500 |
Address Line 1 |
Location address line 1. |
|
|
VARCHAR |
500 |
Address Line 2 |
Location address line 2. |
|
|
VARCHAR |
100 |
City |
Location city. |
|
|
VARCHAR |
100 |
State |
Location state. |
|
|
VARCHAR |
50 |
Zip |
Location zip. |
|
|
TIMESTAMP |
Y |
Create Timestamp |
Create timestamp acquired from the source system. |
|
|
TIMESTAMP |
Y |
Modify Timestamp |
Modify timestamp acquired from the source system |