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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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 |