​Certify Status - R - Require User Certification, X - No action needed, Y - User Certified The Report.

Filter by the following exceptions: AWOA - IN Approval with no approvers and RWOA - Released without Approval

Filter based on My Group - D - My Department Approval, P - My Proxy , U - My team approval. No need to provide anything and it retrieve the data based on the filter.

Current Status. The values are R - For Released, H - For Draft/On Hold, Z - Closed, J - Rejected, P - In Approval Process, O - for Opened, A - Approved

 ​From Date - Format YYYY-MM-DD

 ​To Date - Format YYYY-MM-DD

 ​Function Code

 ​Employee ID

Location Code - Max size 20 Characters

From Posted Date

Validation Status - X - No validation available, V - Passed with warnings, R Passed and I - Failed

 ​Department Code

Last Modified Date To. Filters to the date provided and defaults time to 23:59 hours - format YYYY-MM-DD (Available Version 7.5 and up)

Not Posted To - it will be based on the batch type. You would need to get the value from admin for which batch type is used. Usually it is DB

Last Name

Process Status -  ​P- Posted , X - Not Posted (Default)

Timesheet Reporting Period ID

File Attached - Y - Yes and N - No file attached

Operation Unit Code - Max size is 20 Characters

WBS Level2 Code - Max size 20 Characters

 ​Additional Fields ID - Such as Employee

First Name

Posted To - it will be based on the batch type. You would need to get the value from admin for which batch type is used. Usually it is DB

 ​Employee Type ID

To Posted Date

WBS Level1 Code - Max size 20 Characters

Previous Status. The values are R - For Released, H - For Draft/On Hold, Z - Closed, J - Rejected, P - In Approval Process, A - Approved

 ​Additional Field Value

Timesheets with Time Attendances Y for Yes and N for No

Approval Queue Status, R - Ready, N - Not Ready, A - Approver

Approver ID

Last Modified Date From. Filters from the date provided and defaults time to 00:00 hours - format YYYY-MM-DD (Available Version 7.5 and up)

Job Title