JDBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

HcmContactscontactRelationships

HcmContactscontactRelationships

Columns

Name Type Description
HcmContactsPersonId [KEY] Long HcmContactsPersonId of HcmContactscontactRelationships
ContactRelationshipId [KEY] Long Surrogate identifier for the contact relationship.
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.
ContactType String Relationship between the worker and the contact.
ContactTypeMeaning String ContactTypeMeaning of HcmContactscontactRelationships
LegislationCode String Legislation code of the contact. Valid values are defined in the hcmCountriesLov.
LegislationName String LegislationName of HcmContactscontactRelationships
EmergencyContactFlag Bool Indicates whether the contact is an emergency contact.
PrimaryContactFlag Bool Indicates whether the contact is the primary contact.
StatutoryDependent String A persons contact is a statutory dependent validated against the lookup type ORA_PER_CONTACT_STATUTORY_DEP used by specific localization.
StatutoryDependentMeaning String StatutoryDependentMeaning of HcmContactscontactRelationships
CreatedBy String CreatedBy of HcmContactscontactRelationships
CreationDate Datetime CreationDate of HcmContactscontactRelationships
LastUpdatedBy String LastUpdatedBy of HcmContactscontactRelationships
LastUpdateDate Datetime LastUpdateDate of HcmContactscontactRelationships
RelatedPersonId Long Unique identifier of the worker to whom the contact is related.
RelatedPersonNumber String Person number of the worker to whom the contact is related.
Finder String Finder of HcmContactscontactRelationships
PersonId Long PersonId of HcmContactscontactRelationships
SysEffectiveDate String SysEffectiveDate of HcmContactscontactRelationships

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