HcmContacts
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 |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
ContactType | String | ContactType |
EmergencyContactFlag | String | EmergencyContactFlag |
RelatedPersonId | Long | RelatedPersonId |
RelatedPersonNumber | String | RelatedPersonNumber |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |