objid | employee | objid | Support employee internal record number | 3 (UNIQUE) |
loc_objid | site | objid | Site internal record number | |
addr_objid | address | objid | Site address internal record number | |
first_name | employee | first_name | Suport employee first name | 15 |
last_name | employee | last_name | Support employee last name | 14 |
phone_num | employee | phone | Support employee's primary phone number which includes area code, number, and extension | |
p_site | site | name | Support employee site name | |
p_site_id | site | site_id | Support employee site ID | |
country_code | country | code | Country code for site | |
address | address | address | Line 1 of address which includes street number, street name, office, building, or suite number, etc | |
city | address | city | The city for the specified address | |
state | address | state | The state for the specified address | |
country | country | name | Country name for the specified address | |
zipcode | address | zipcode | The zip or other postal code for the specified address | |