Contacts
Retrieves emergency contacts and beneficiary contacts associated with employees.
Columns
| Name | Type | References | |
| ContactId [KEY] | String | ||
| EmployeeId | String |
PersonDetails.EmployeeId | |
| AddressCity | String | ||
| AddressLine1 | String | ||
| AddressState | String | ||
| AddressZipCode | String | ||
| EmailAddress | String | ||
| FirstName | String | ||
| LastName | String | ||
| MiddleName | String | ||
| FormerName | String | ||
| NameSuffix | String | ||
| Gender | String | ||
| DateOfBirth | Datetime | ||
| Ssn | String | ||
| ImportId | String | ||
| PersonId | String | ||
| AddressLine2 | String | ||
| CountryCode | String | ||
| County | String | ||
| AddressId | String | ||
| IsAddressDifferentFromEmployee | Boolean | ||
| HomePhoneNumber | String | ||
| HomePhoneCountry | String | ||
| HomePhoneId | String | ||
| WorkPhoneNumber | String | ||
| WorkPhoneExtension | String | ||
| WorkPhoneId | String | ||
| OtherPhoneNumber | String | ||
| OtherPhoneType | String | ||
| OtherPhoneCountryCode | String | ||
| OtherPhoneId | String | ||
| PreferredPhoneNumber | String | ||
| RelationshipCode | String | ||
| RelationshipDescription | String | ||
| IsBeneficiary | Boolean | ||
| IsDependent | Boolean | ||
| IsEmergencyContact | Boolean | ||
| IsDisabled | Boolean | ||
| IsSmoker | Boolean | ||
| IsStudent | Boolean | ||
| IsActive | Boolean | ||
| MarriageDate | Datetime | ||
| DeathDate | Datetime | ||
| DivorceDate | Datetime | ||
| StatusAsOfDate | Datetime | ||
| RowLastChanged | Datetime | ||
| Occupation | String | ||
| OtherInsurance | String | ||
| CanCobraExport | Boolean | ||
| IsCobraActive | Boolean | ||
| CobraReason | String | ||
| CobraStatus | String | ||
| CobraStatusDate | Datetime | ||
| DateOfCOBRAEvent | Datetime | ||
| DateOfCOBRALetter | Datetime | ||
| CobraNotes | String | ||
| Notes | String | ||
| HealthCareId | String | ||
| NationalId | String | ||
| NationalIdExpirationDate | Datetime | ||
| UserDefinedField01 | String |