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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。