EmployeeAddresses
Return a list of: EmployeeAddresses
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| AddressesExtensionsExtensionAggregate | String | |
| AddressesCity | String | |
| AddressesLine1 | String | |
| AddressesLine2 | String | |
| AddressesLine3 | String | |
| AddressesPostalCode | String | |
| AddressesState | String | |
| AddressesCountryRegion | String | |
| AddressesFaxCountryCode | String | |
| AddressesFaxExtension | String | |
| AddressesFax | String | |
| AddressesPhone1CountryCode | String | |
| AddressesPhone1Extension | String | |
| AddressesPhone1 | String | |
| AddressesPhone2CountryCode | String | |
| AddressesPhone2Extension | String | |
| AddressesPhone2 | String | |
| AddressesPhone3CountryCode | String | |
| AddressesPhone3Extension | String | |
| AddressesPhone3 | String | |
| AddressesCountryRegionCodeId | String | |
| AddressesCounty | String | |
| AddressesDeleteOnUpdate | Bool | |
| AddressesInternetAddressesAdditionalInformation | String | |
| AddressesInternetAddressesEmailBccAddress | String | |
| AddressesInternetAddressesEmailCcAddress | String | |
| AddressesInternetAddressesEmailToAddress | String | |
| AddressesInternetAddressesInternetField1 | String | |
| AddressesInternetAddressesInternetField2 | String | |
| AddressesInternetAddressesInternetField3 | String | |
| AddressesInternetAddressesInternetField4 | String | |
| AddressesInternetAddressesInternetField5 | String | |
| AddressesInternetAddressesInternetField6 | String | |
| AddressesInternetAddressesInternetField7 | String | |
| AddressesInternetAddressesInternetField8 | String | |
| AddressesInternetAddressesMessengerAddress | String | |
| AddressesKeyEmployeeId [KEY] | String | |
| AddressesId [KEY] | String | |
| BenefitExpiration | Datetime | |
| BenefitStartDate | Datetime | |
| BirthDate | Datetime | |
| ClassId | String | |
| CompanyAddressId | String | |
| DayOfBirth | Int | |
| DefaultAddressKeyEmployeeId | String | |
| DefaultAddressId | String | |
| DefaultCashAccountFromType | String | |
| DepartmentId | String | |
| DivisionId | String | |
| DoesCalculateMinimumWageBalance | Bool | |
| EmployeeInactivatedDate | Datetime | |
| EmployeeId | String | |
| EmploymentStartDate | Datetime | |
| EmploymentType | String | |
| Ethnicity | String | |
| FederalClass | String | |
| GLAccountId | String | |
| GLAccountKeyIsEncrypted | Bool | |
| GenderCode | String | |
| HRStatus | String | |
| I9RenewDate | Datetime | |
| IsActive | Bool | |
| IsDisabled | Bool | |
| IsDisabledVeteran | Bool | |
| IsI9Verified | Bool | |
| IsOtherVeteran | Bool | |
| IsSmoker | Bool | |
| IsUnionEmployee | Bool | |
| IsUnitedStatesCitizen | Bool | |
| IsVeteran | Bool | |
| IsVietnamEraVeteran | Bool | |
| LastWorkedDate | Datetime | |
| MaritalStatus | String | |
| MilitaryDischargeDate | Datetime | |
| MinimumNetPayCurrency | String | |
| MinimumNetPay | Decimal | |
| ModifiedBy | String | |
| ModifiedDate | Datetime | |
| MonthOfBirth | String | |
| NameAlternate | String | |
| NameFamily | String | |
| NameGiven | String | |
| NameMiddle | String | |
| NamePreferred | String | |
| NameSuffix | String | |
| PositionId | String | |
| PrimaryPayCodeId | String | |
| RateClass | String | |
| ReasonEmployeeInactivated | String | |
| ReviewLastDate | Datetime | |
| ReviewNextDate | Datetime | |
| SUTAStateId | String | |
| SickTimeAccrualAmount | Decimal | |
| SickTimeAccrualMethod | String | |
| SickTimeDoesAutomaticallyAccrue | Bool | |
| SickTimeHoursAvailable | Decimal | |
| SickTimeHoursPerYear | Int | |
| SickTimeWarnWhenHoursAvailableFallsBelowZero | Bool | |
| SpouseName | String | |
| SpouseTaxIdentifier | String | |
| Status | String | |
| SupervisorId | String | |
| TaxIdentifier | String | |
| UnionId | String | |
| UserDefined1 | String | |
| UserDefined2 | String | |
| VacationAccrualAmount | Decimal | |
| VacationAccrualMethod | String | |
| VacationDoesAutomaticallyAccrue | Bool | |
| VacationHoursAvailable | Decimal | |
| VacationHoursPerYear | Int | |
| VacationWarnWhenHoursAvailableFallsBelowZero | Bool | |
| WorkHoursPerYear | Int | |
| WorkersCompensationId | String |
Pseudo-Columns
Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| PagingColumn | String |