I have a requirement to fetch request/PRD history from user application database which can be used for reporting and I was just browsing DB schema for the same. Can you please let me know where can I see request current status e.g. approved/denied etc.

Though, I see "<IDM_COMPLETED_APPROVAL_STATUS>" in METAXML (table AFDOCUMENT) but value of it, is approved however request is pending for approval when I see in UI. Can you please help on this.

Also, I don't have see any document for user application database schema. Can you please help in getting those documents too.