how to populate right external apply flow code column in jobrequisition template

Hi ,

I need to create a new HDL template to load new job requisitions. i am facing issue in populating a valid external apply flow code column in jobrequisition.dat template.

Please suggest how i can find and populate an eligible value. I already tried using the following query to fetch the right value but that's not helping:

"SELECT * FROM IRC_APPLY_FLOWS_B" I randomly tried with the column values for AF_CODE, AF_TYPE_CODE, AF_STATUS_CODE, but to no avail

Quick help is appreciated.

Thanks,

Subhadeep Gupta