WorkerJourneyscontacts
WorkerJourneyscontacts
Columns
Name | Type | Description |
WorkerJourneysWorkerJourneyId [KEY] | Long | Unique identifier of the journey. |
WorkerJourneyContactId [KEY] | Long | Unique identifier of the journey contact. |
Type | String | Type of contact. Valid values are from the ORA_PER_ONB_CONTACT_TYPE lookup. For example, Line Manager, Area of Responsibility. |
TypeMeaning | String | Meaning of the contact type. |
ContactEmail | String | Work email of the contact. |
ContactPersonId | Long | Internal identifier for the contact. |
ContactPersonNumber | String | Person number of the contact. |
ContactName | String | Person name of the contact. |
Title | String | Title of the contact. Values are from the ORA_PER_ONB_CONTACT_TITLE lookup. For example, ONBOARDING_SPONSOR |
TitleMeaning | String | Meaning of the contact title. For example, Onboarding Sponsor. |
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 |
AllocatedAfterDate | Date | AllocatedAfterDate |
AssignmentId | Long | AssignmentId |
CategoryFilter | String | CategoryFilter |
CodeFilter | String | CodeFilter |
Context | String | Context |
ContextualAction | String | ContextualAction |
Facets | String | Facets |
JourneyId | Long | JourneyId |
Overdue | String | Overdue |
PersonId | Long | PersonId |
SearchTerms | String | SearchTerms |
StatusCategory | String | StatusCategory |
StatusFilter | String | StatusFilter |
SubCategoryFilter | String | SubCategoryFilter |
WorkerJourneyId | Long | WorkerJourneyId |
Finder | String | finder |