does anyone have schema documenation for cm_history table? We're interested in following column definition.
· History_type
· Action_number
Cybersecurity
DevOps Cloud
IT Operations Cloud
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more
Hello. We do not document the Dimensions CM schema and instead encourage users to use the Published Views for any reporting which are fully documented. Is there something you feel is missing from the Published Views to want to query the schema?
Thanks for the location of the documentation.
The type of history entry. Values are 'null' for action, ’A’ for archived, 'D' for delegation, 'E' for extracted, 'M' for merged, 'U' for update, 'C' for create. Would you happen to know the table name that has this information? We would like to do a join to pull the information automatically.
was not clear but, the action number wasn't reference like the history type. For example, action number 5. Would you happen to know where the action code are stored on a table?
The history_type for a request is A for action, D for delegation and U for update. I think you were looking at the item published views rather than requests. Take a look at the description of the pcms_chdoc_history published view.
The action_no field details the action number of the request. The action number is incremented whenever the request is actioned from one state to another.
The action number is incremented whenever the request is actioned from one state to another
does the number go back to 0 or 1 the next day?
The action number is incremented whenever the request is actioned from one state to another
does the number go back to 0 or 1 the next day?