Workersaddresses
Workersaddresses
Columns
| Name | Type | Description |
| WorkersPersonId [KEY] | Long | WorkersPersonId of Workersaddresses |
| AddressId [KEY] | Long | Surrogate identifier for the address record. |
| EffectiveStartDate [KEY] | Date | Start date of the date-effective changes to the record. |
| EffectiveEndDate [KEY] | Date | End date of the date-effective changes to the record. |
| AddressLine1 | String | First line of the primary mail address. |
| AddressLine2 | String | Second line of the primary mail address. |
| AddressLine3 | String | Third line of the primary mail address. |
| AddressLine4 | String | Fourth line of the primary mail address. |
| TownOrCity | String | Town or city in which the address is located. |
| Region1 | String | Primary region in which the address is located. |
| Region2 | String | Secondary region within the primary region. |
| Region3 | String | Additional secondary region within the primary region. |
| Country | String | Country in which the address is located. Valid values are defined in the hcmCountriesLov. |
| CountryName | String | CountryName of Workersaddresses |
| PostalCode | String | Postal code of the primary mail address. |
| LongPostalCode | String | Long postal code of the primary mail address. |
| AddlAddressAttribute1 | String | Additional address column used by localizations. |
| AddlAddressAttribute2 | String | Additional address column used by localizations. |
| AddlAddressAttribute3 | String | Additional address column used by localizations. |
| AddlAddressAttribute4 | String | Additional address column used by localizations. |
| AddlAddressAttribute5 | String | Additional address column used by localizations. |
| Building | String | Building information associated with the address. |
| FloorNumber | String | Floor number associated with the building. |
| CreatedBy | String | CreatedBy of Workersaddresses |
| CreationDate | Datetime | CreationDate of Workersaddresses |
| LastUpdatedBy | String | LastUpdatedBy of Workersaddresses |
| LastUpdateDate | Datetime | LastUpdateDate of Workersaddresses |
| PersonAddrUsageId [KEY] | Long | PersonAddrUsageId of Workersaddresses |
| AddressType | String | Type of address. Valid values are defined in the commonLookupsLOV. |
| AddressTypeMeaning | String | AddressTypeMeaning of Workersaddresses |
| ValidationStatusCode | String | Level of accuracy of an address, as determined by an address provider. |
| Provider | String | Company that has validated the address. |
| Longitude | Decimal | Distance between the prime meridian and an address located to its east or west, expressed in degrees and minutes. |
| Latitude | Decimal | Distance between the equator and an address located to its north or south, expressed in degrees and minutes. |
| PrimaryFlag | Bool | Indicates whether the address is the primary mailing address. |
| AssignmentId | Long | AssignmentId of Workersaddresses |
| AssignmentName | String | AssignmentName of Workersaddresses |
| AssignmentNumber | String | AssignmentNumber of Workersaddresses |
| DirectReportsFlag | String | DirectReportsFlag of Workersaddresses |
| Finder | String | Finder of Workersaddresses |
| LineManagerFlag | String | LineManagerFlag of Workersaddresses |
| PersonId | Long | PersonId of Workersaddresses |
| PersonNumber | String | PersonNumber of Workersaddresses |
| PrimaryAssignmentFlag | String | PrimaryAssignmentFlag of Workersaddresses |
| RelationshipType | String | RelationshipType of Workersaddresses |
| SysEffectiveDate | String | SysEffectiveDate of Workersaddresses |
| WorkerType | String | WorkerType of Workersaddresses |
| EffectiveDate | Date | EffectiveDate of Workersaddresses |