JDBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

HcmContactsaddresses

HcmContactsaddresses

Columns

Name Type Description
HcmContactsPersonId [KEY] Long HcmContactsPersonId of HcmContactsaddresses
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 HcmContactsaddresses
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 HcmContactsaddresses
CreationDate Datetime CreationDate of HcmContactsaddresses
LastUpdatedBy String LastUpdatedBy of HcmContactsaddresses
LastUpdateDate Datetime LastUpdateDate of HcmContactsaddresses
PersonAddrUsageId [KEY] Long PersonAddrUsageId of HcmContactsaddresses
AddressType String Type of address. Valid values are defined in the commonLookupsLOV.
AddressTypeMeaning String AddressTypeMeaning of HcmContactsaddresses
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.
ContactType String ContactType of HcmContactsaddresses
EmergencyContactFlag String EmergencyContactFlag of HcmContactsaddresses
Finder String Finder of HcmContactsaddresses
PersonId Long PersonId of HcmContactsaddresses
RelatedPersonId Long RelatedPersonId of HcmContactsaddresses
RelatedPersonNumber String RelatedPersonNumber of HcmContactsaddresses
SysEffectiveDate String SysEffectiveDate of HcmContactsaddresses

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062