HcmContactsphones

Columns


Name	Type	Description
HcmContactsPersonId [KEY]	Long	HcmContactsPersonId of HcmContactsphones
PhoneId [KEY]	Long	PhoneId of HcmContactsphones
PhoneType	String	Type of phone such as Work, Home, and so on. Valid values are defined in the commonLookupsLOV.
PhoneTypeMeaning	String	PhoneTypeMeaning of HcmContactsphones
LegislationCode	String	Legislation code of the contact's phone.
LegislationName	String	LegislationName of HcmContactsphones
CountryCodeNumber	String	Country code of the contact's phone number. Valid values are defined in the hcmCountriesLov.
AreaCode	String	Area code of the contact's phone number.
PhoneNumber	String	Contact's phone number for various phone types such as Work, Home, and so on.
Extension	String	Extension number for the contact's phone.
FromDate	Date	Date from when the contact's phone number is valid.
ToDate	Date	Date until when the contact's phone number is valid.
Validity	String	Validity of HcmContactsphones
ValidityMeaning	String	ValidityMeaning of HcmContactsphones
CreatedBy	String	CreatedBy of HcmContactsphones
CreationDate	Datetime	CreationDate of HcmContactsphones
LastUpdatedBy	String	LastUpdatedBy of HcmContactsphones
LastUpdateDate	Datetime	LastUpdateDate of HcmContactsphones
PrimaryFlag	Bool	Indicates whether the phone number is the primary phone of the contact.
ContactType	String	ContactType of HcmContactsphones
EmergencyContactFlag	String	EmergencyContactFlag of HcmContactsphones
Finder	String	Finder of HcmContactsphones
PersonId	Long	PersonId of HcmContactsphones
RelatedPersonId	Long	RelatedPersonId of HcmContactsphones
RelatedPersonNumber	String	RelatedPersonNumber of HcmContactsphones
SysEffectiveDate	String	SysEffectiveDate of HcmContactsphones

SSIS Components for Oracle Fusion Cloud HCM

HcmContactsphones

Columns