location of table in change request

[nath0507]

hi all

I need to locate the table where these fields are stored

[SatyakiBose · Accepted solution]

Hello @nath0507 

The fields that are highlighted in the screenshot are from the change_request table.

You can perform the below steps to access these fields:

1. Open any change request on your instance.
2. Navigate to the planning section
3. Right click on the field & click on configure dictionary.

The values that you put in these fields are stored in the sys_audit table.

• Navigate to the sys_audit table.
• Filter the table name and field name column with the table and field you want to check
• The document key holds the sys_id of the record you wish to check (sys_id of the change record)
• now check the old value and new value column.
• It will store the current value and old value of the field that you are checking.
• update count column will tell you how many times the field has been updated, and the older the update count, means its the current value.