How to Access Approval DB Table

Approval actions are stored in AO_7B9828_TIMESHEET_APPROVAL table. There is an entry for each user_key/period_id/project_id combination. STATUS column can have one of the following values:

  • APPROVED

  • PARTIALL_APPROVED

  • SUBMITTED

  • OPEN

  • REJECTED