TDV Adapter for Oracle Fusion Cloud HCM

Build 23.0.8839

HcmContactsaddressesaddressesDFF

HcmContactsaddressesaddressesDFF

Columns

Name Type Description
HcmContactsPersonId [KEY] Long HcmContactsPersonId of HcmContactsaddressesaddressesDFF
AddressesAddressId [KEY] Long AddressesAddressId of HcmContactsaddressesaddressesDFF
AddressesEffectiveEndDate [KEY] Date AddressesEffectiveEndDate of HcmContactsaddressesaddressesDFF
AddressesEffectiveStartDate [KEY] Date AddressesEffectiveStartDate of HcmContactsaddressesaddressesDFF
AddressesPersonAddrUsageId [KEY] Long AddressesPersonAddrUsageId of HcmContactsaddressesaddressesDFF
PersonAddrUsageId [KEY] Long Descriptive flexfield for contact address.
EffectiveStartDate [KEY] Date Descriptive flexfield for contact address.
EffectiveEndDate [KEY] Date Descriptive flexfield for contact address.
_FLEX_Context String Descriptive flexfield for contact address.
_FLEX_Context_DisplayValue String Context Value

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
ContactType String ContactType
EmergencyContactFlag String EmergencyContactFlag
PersonId Long PersonId
RelatedPersonId Long RelatedPersonId
RelatedPersonNumber String RelatedPersonNumber
SysEffectiveDate String SysEffectiveDate
Finder String finder

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