HcmContactscontactRelationshipscontactRelationshipsDDF
HcmContactscontactRelationshipscontactRelationshipsDDF
Columns
Name | Type | Description |
HcmContactsPersonId [KEY] | Long | HcmContactsPersonId of HcmContactscontactRelationshipscontactRelationshipsDDF |
ContactrelationshipsContactRelationshipId [KEY] | Long | ContactrelationshipsContactRelationshipId of HcmContactscontactRelationshipscontactRelationshipsDDF |
ContactrelationshipsEffectiveEndDate [KEY] | Date | ContactrelationshipsEffectiveEndDate of HcmContactscontactRelationshipscontactRelationshipsDDF |
ContactrelationshipsEffectiveStartDate [KEY] | Date | ContactrelationshipsEffectiveStartDate of HcmContactscontactRelationshipscontactRelationshipsDDF |
ContactRelationshipId [KEY] | Long | ContactRelationshipId of HcmContactscontactRelationshipscontactRelationshipsDDF |
EffectiveStartDate [KEY] | Date | EffectiveStartDate of HcmContactscontactRelationshipscontactRelationshipsDDF |
EffectiveEndDate [KEY] | Date | EffectiveEndDate of HcmContactscontactRelationshipscontactRelationshipsDDF |
_FLEX_Context | String | __FLEX_Context of HcmContactscontactRelationshipscontactRelationshipsDDF |
_FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue of HcmContactscontactRelationshipscontactRelationshipsDDF |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
ContactType | String | ContactType |
EmergencyContactFlag | String | EmergencyContactFlag |
PersonId | Long | PersonId |
RelatedPersonId | Long | RelatedPersonId |
RelatedPersonNumber | String | RelatedPersonNumber |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |