In order to improve the reliability and efficiency of use of aggregated reports (and to assist in diagnostics in the event of any problem) it would be extremely beneficial to have the following database values included on aggregated reports:
- Contract ID
- Company ID (Communicated by)
- User ID (Communicated by)
- Process ID
- Process Form ID
- Associated process form ID (e.g. ID of the CEN that a quote or extension request relates to)
- EWN status
- CEN status
- Quote Status
Currently the only way to uniquely identify a particular process form is by concatenating contract name (editable string) and form reference or by extracting these from hyperlinks and status names (as configured) have to be converted back to their database values via a lookup table.