Journeyscontacts
Journeyscontacts
Columns
Name | Type | Description |
JourneysJourneyId [KEY] | Long | Finds all journey templates that match the primary key specified. |
JourneyContactId [KEY] | Long | Unique identifier of the journey contact. |
Type | String | Type of contact. Valid values are from the ORA_PER_ONB_CONTACT_TYPE lookup. Example, Line Manager, AOR. |
TypeMeaning | String | Meaning of the contact type. |
ResponsibilityType | String | Responsibility type of the journey contact. |
ResponsibilityTypeMeaning | String | Responsibility type meaning of the journey contact. |
ContactUser | String | User name of the journey contact. |
ContactPersonId | Long | Internal identifier of the journey contact. |
CustomContact | String | Custom contact details |
Title | String | Title of the contact. For example, Onboarding Sponsor. |
TitleMeaning | String | Meaning of the contact type. |
CreatedBy | String | User who created the contact. |
CreationDate | Datetime | Date the contact was created. |
LastUpdatedBy | String | User who last updated the contact. |
LastUpdateDate | Datetime | Date the contact was last updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
CategoryFilter | String | CategoryFilter |
CodeFilter | String | CodeFilter |
Context | String | Context |
ContextualAction | String | ContextualAction |
ExcludePersonal | String | ExcludePersonal |
Facets | String | Facets |
FilterAttributes | String | FilterAttributes |
JourneyId | Long | JourneyId |
LevelFilter | String | LevelFilter |
SearchTerms | String | SearchTerms |
SubCategoryFilter | String | SubCategoryFilter |
SubjectAssignmentId | Long | SubjectAssignmentId |
SubjectPersonId | Long | SubjectPersonId |
Finder | String | finder |