HcmContacts

Columns


Name	Type	Description
PersonId [KEY]	Long	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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。