Employment Category fast formula

Summary

Employment Category fast formula

Content

hi ,
I need to get Employment_Category  DBI clomun for my fast formula.

DEFAULT FOR PER_ASG_EMPLOYEE_CATEGORY IS ' '

But PER_ASG_EMPLOYEE_CATEGORY is no working .
 

Path in HCM for above Set up:

manage common lookups --> EMP_CAT

 Oracle HCM this is seeded look up codes.

 

Please check screenshots and guide me to get above DBI.

 

Also I used value sets like this.
 

per_all_people_f pa,
per_all_assignments_f pf 

pf.EMPLOYMENT_CATEGORY

1=1
and pf.PERSON_ID = pa.PERSON_ID 
and pf.EMPLOYMENT_CATEGORY is not null