CompanyPersonDetails
Retrieves personal details scoped to a specific company. Requires CompanyId as context. Use PersonDetails for cross-company queries.
Columns
| Name | Type | References | |
| PersonId [KEY] | String | ||
| CompanyId | String |
CompanyDetails.CompanyId | |
| EmployeeId | String | ||
| DateTimeChanged | Datetime | ||
| DateTimeCreated | Datetime | ||
| AddressCity | String | ||
| AddressCountry | String | ||
| AddressLine1 | String | ||
| AddressLine2 | String | ||
| AddressState | String | ||
| AddressZipCode | String | ||
| DateOfBirth | Datetime | ||
| EmailAddress | String | ||
| EmailAddressAlternate | String | ||
| EthnicDescription | String | ||
| EthnicIDCode | String | ||
| FirstName | String | ||
| FormerName | String | ||
| Gender | String | ||
| HomePhone | String | ||
| LastName | String | ||
| MaritalStatusCode | String | ||
| MiddleName | String | ||
| NamePrefixCode | String | ||
| NameSuffixCode | String | ||
| PreferredName | String | ||
| UserName | String | ||
| AdditionalName1 | String | ||
| AdditionalName2 | String | ||
| NameFormer | String | ||
| AddressCounty | String | ||
| AddressId | String | ||
| IsAddressOnTaxBoundary | Boolean | ||
| AddressLatitude | Double | ||
| AddressLine3 | String | ||
| AddressLine4 | String | ||
| AddressLongitude | Double | ||
| AddressSms | String | ||
| HomePhoneCountry | String | ||
| IsHomePhonePrivate | Boolean | ||
| CobraExport | String | ||
| IsCobraActive | Boolean | ||
| CobraNotes | String | ||
| CobraReason | String | ||
| CobraStatus | String | ||
| CobraStatusDate | Datetime | ||
| DateOfCobraEvent | Datetime | ||
| DateOfCobraExport | Datetime | ||
| DateOfCobraLetter | Datetime | ||
| HealthBloodType | String | ||
| HealthEyes | String | ||
| HealthHair | String | ||
| HealthHeightFeet | String | ||
| HealthHeightInches | String | ||
| HealthLastDonateDate | Datetime | ||
| HealthWeight | Double | ||
| DateOfI9Expiration | Datetime | ||
| I9AlienNumber | String | ||
| I9DocA | String | ||
| I9DocB | String | ||
| I9DocC | String | ||
| IsI9Verified | Boolean | ||
| I9VisaExpirationDate | Datetime | ||
| I9VisaType | String | ||
| I9WorkAuth | String | ||
| MilitaryBranchServed | String | ||
| MilitaryEra | String | ||
| MilitaryIsActiveWartimeVet | String | ||
| MilitaryIsDisabledVet | String | ||
| MilitaryIsMedalVet | String | ||
| MilitaryIsOthEligVet | String | ||
| MilitaryIsOthEligVetBasis | String | ||
| MilitarySeparationDate | Datetime | ||
| HasMilitaryService | Boolean | ||
| NationalId | String | ||
| NationalIdCountry | String | ||
| Nationality1 | String | ||
| Nationality2 | String | ||
| Nationality3 | String | ||
| OriginCountry | String | ||
| OriginLocation | String | ||
| PreviousSSN | String | ||
| Ssn | String | ||
| IsSsnSuppressed | Boolean | ||
| ChkCashingInstCode | String | ||
| CommunityBroadcastSmsCode | String | ||
| HasConsentElectronicW2 | Boolean | ||
| HasConsentElectronicW2Pr | Boolean | ||
| DateDeceased | Datetime | ||
| DisabilityType | String | ||
| IntegrationUserKey | String | ||
| IsDisabled | Boolean | ||
| IsMultiPayGroup | Boolean | ||
| IsSmoker | Boolean | ||
| LastNameNotSameAsSSCard | String | ||
| HasSmsApprovals | Boolean | ||
| HasSmsPayNotification | Boolean | ||
| IsW2Deceased | Boolean |