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?

https://admhelp.microfocus.com/dimensionscm/en/14.5.3/online_help/Content/PDFs/dmcm_reports_guide.pdf

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.

Unknown said:

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?

No, it increments upwards whenever the request is actioned.