Effective date parameter guided journey

Summary:

Effective date parameter guided journey

Content (please ensure you mask any confidential information):

I have configured a guided journey on the redwood Employment info page to return the people group contexts in an easier to read format, its a report based guided journey which makes the current people group field much easier to read

Its a dynamic report so will pull the data automatically based on the person ID

My SQL is below

SELECT DISTINCT PER_PEOPLE_GROUPS.PEOPLE_GROUP_ID
PER_PEOPLE_GROUPS.SEGMENT1
PER_PEOPLE_GROUPS.SEGMENT2
PER_PEOPLE_GROUPS.SEGMENT3
PER_PEOPLE_GROUPS.SEGMENT4
PER_PEOPLE_GROUPS.SEGMENT5