How to use Value Sets like JobFamilyPVO in content types on the profile
Summary
We need help creating and using a value set, similar to how the delivered Career Preferences Content Type use JobFamilyPVO.Content
We are setting up Career Development, and one of the asks is that a user can identify specific jobs of interests based on a list of all active job codes in the system. I notice that The "Career Preferences" content Item makes use already of a few different value sets. For example, JobFamilyPVO gives a list of the job families.
I'm trying to replicate that by either creating my own custom value set that does a sql lookup against the PER_JOBS view or PER_JOBS_F table but I'm failing. (I was suprised to find that All Jobs isn't an existing lookup, but I could be wrong as the search UI is really hard to use as it won't let me start my search with a wildcard)