Create Open Requisitions Script using TCC

Summary

Have anyone created a TCC script on bulk open requisition export? How can we extract only the most recent status for all open reqs?

Content

Have anyone created a TCC script on bulk open requisition export?

We are trying to export "open" requisitions containing requisition type, status, and position management number (an UDF for our internal position ID).  

The data extraction shows historical reqs that were once in approved, sourcing, and draft status which we don't want.  How can we extract only the most recent status for all open reqs?

The entities we used are Requisition,JobInformation,Hire Type, Requisition,JobInformation,ResumeState, and Requisition,JobInformation,MDA_5fPMNmber.