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.

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