EmployeeAddress
Name: Employee Address
Type: Application
Modules: OPS-Dispatch, OPS-Employee Profile
Description: Contains employee address information.
| Field | Documentation |
|---|---|
| EmployeeId | Employee identifier from Employees.EmployeeId. References the associated employee. |
| FromDate | Start date when the address is valid. |
| ToDate | End date when the address is valid. |
| SiteName | Name of the site. |
| StreetNum | Street number of the address (used interchangeably with StreetNo). |
| StreetNo | Street number of the address (used interchangeably with StreetNum). |
| OnStreet | Street name of the address. |
| AtStreet | Street of the nearest intersection. |
| Unit | Apartment unit, if applicable. |
| City | City of residence. |
| State | State or province of residence. |
| ZipCode | Zip or postal code of residence. |
| AddressSummary | Short description of the address. |
| ZoneCode | Zone code. |
| MapPage | Page in map book (e.g., Perly Maps) referencing the residence. |
| Phone | Home phone number of the employee. |
| Lon | Longitude coordinate of the employee's address. |
| Lat | Latitude coordinate of the employee's address. |
| GeoStatus | Geocode value of the employee's address. |
| CellArea | Deprecated. |
| PolyId | ID number of the polygon the address is in from Polygons table. |
| InAda | Flag set to indicate if the address is in the designated ADA polygon type. |
| JurisPolyId | ID number of the polygon that has jurisdiction of this address |
| DefaultAddr | If true, this address is the employee's default address. |
| MailingAddr | If true, this address is also the employee's mailing address. |
| MailingName | Name of mail recipient. |
| FAX | Fax number of the employee. |
| Comments | Comments about the record. |
| SpaceType | Deprecated. |
| LoadTime | Deprecated. |
| UnloadTime | Deprecated. |
| MobAids | Deprecated. |
| recordStatus | Deprecated. |
| AccessibilityInfo | Deprecated. |
| Location | Short description of the location. |
| AddrName | Name of the address. |