CData Python Connector for Oracle Fusion Cloud HCM

Build 26.0.9770

Workersaddresses

Workersaddresses

Columns

Name Type SupportedFinders 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 FindReports AssignmentId of Workersaddresses
AssignmentName String FindReports AssignmentName of Workersaddresses
AssignmentNumber String FindReports AssignmentNumber of Workersaddresses
DirectReportsFlag String FindReports DirectReportsFlag of Workersaddresses
Finder String Finder of Workersaddresses
LineManagerFlag String FindReports LineManagerFlag of Workersaddresses
PersonId Long PrimaryKey, findReports, findByPersonId PersonId of Workersaddresses
PersonNumber String FindReports PersonNumber of Workersaddresses
PrimaryAssignmentFlag String FindReports PrimaryAssignmentFlag of Workersaddresses
RelationshipType String FindReports RelationshipType of Workersaddresses
SysEffectiveDate String FindReports, findByPersonId SysEffectiveDate of Workersaddresses
WorkerType String FindReports WorkerType of Workersaddresses
EffectiveDate Date EffectiveDate of Workersaddresses

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770