Additional Person Info Supports Parameters in Value Set Table Definition in Redwood

The Redwood Additional Person Info page now supports an EFF segment with a display type of list of values and uses a value set defined as a table validation with the person ID or effective start date as a parameter. The person ID is that of the worker whose Additional Person Info record you’re acting upon. The effective start date is that of the Additional Person Info record you’re acting upon. This functionally allows for the LOV to be filtered based on the parameters used. 

The table-based value sets for Person EFF can be configured from the Manage Extensible Flexfields setup UI. Here’s an example of how the person ID is used.


Sample Table-Based Value Set Definition with Person ID Parameter

Sample Table-Based Value Set Definition with Person ID Parameter

You can pass the parameters in these formats:

Person ID

  • :{PARAMETER.PERSON_ID}
  • Sample usage: person_id = :{PARAMETER.PERSON_ID}

Effective Start Date

  • :{PARAMETER.EFFECTIVE_START_DATE}
  • Sample usage: :{PARAMETER.EFFECTIVE_START_DATE} between effective_start_date and effective_end_date

You can now filter the LOV used in a Person EFF segment.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

  • If the value set isn’t returning any values, your segment LOV won’t display anything.
  • For example, if you configure a LOV with the value set as the countries for which the worker has a citizenship record, and the worker you’re acting upon doesn’t have any citizenship records, then the LOV won’t display any values. In these cases, it’s essential to keep in mind not to mark that particular segment as required.