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