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 |