Diagram for VDC simplified process (Audit and Observation projects):
Diagram for original process :
| Activity | Original Process | VDC Simplified Process |
| Get a record’s data | 8 tables plus logic for each field | 1 table |
| Get a field’s value | 5 tables plus logic | 1 table |
| Get a record’s status, project and division type | 4 tables | 1 table |
| Get field values for a grid | 6 tables plus logic | 1 table |
The VDC Simplified Process creates one table for each project and one table for each grid containing all field values*. This uses the project, grid and field names end users see in the application making it very easy for downstream reporting teams to understand and communicate with end users.
* VDC Simplified Process includes all fields that are included in the reporting database.