HcmContacts

Columns


Name	Type	SupportedFinders	Description
PersonId [KEY]	Long	FindByPersonId, PrimaryKey	Surrogate identifier for the worker to which the contact relationship belongs.
PersonNumber	String		Person number of the worker to whom the contact is related.
CorrespondenceLanguage	String		Preferred language for communication. Valid values are defined in the commonLookupsLOV.
CorrLanguageMeaning	String		CorrLanguageMeaning of HcmContacts
BloodType	String		Blood type of the contact. Valid values are defined in the commonLookupsLOV.
BloodTypeMeaning	String		BloodTypeMeaning of HcmContacts
DateOfBirth	Date		Date of birth of the contact.
DateOfDeath	Date		Date of death of the contact.
CountryOfBirth	String		Country of birth of the contact. Valid values are defined in the hcmCountriesLOV.
CountryOfBirthName	String		CountryOfBirthName of HcmContacts
RegionOfBirth	String		Region of birth of the contact.
TownOfBirth	String		Town of birth of the contact.
CreatedBy	String		CreatedBy of HcmContacts
CreationDate	Datetime		CreationDate of HcmContacts
LastUpdatedBy	String		LastUpdatedBy of HcmContacts
LastUpdateDate	Datetime		LastUpdateDate of HcmContacts
ContactType	String	FindContactsByWorker	ContactType of HcmContacts
EmergencyContactFlag	String	FindContactsByWorker	EmergencyContactFlag of HcmContacts
Finder	String		Finder of HcmContacts
RelatedPersonId	Long	FindContactsByWorker	RelatedPersonId of HcmContacts
RelatedPersonNumber	String	FindContactsByWorker	RelatedPersonNumber of HcmContacts
SysEffectiveDate	String	FindContactsByWorker, findByPersonId	SysEffectiveDate of HcmContacts

Excel Add-In for Oracle Fusion Cloud HCM

HcmContacts

Columns