Framework database tools provides the ability to run extracurricular updates to Framework system and job data.
This may be required when Framework data has been updated externally outside of the Framework suite or when statistics need to be recalculated.
The following table describes the database tools available:
| # | Database Tool Name | Description | When is it needed? |
|---|---|---|---|
| 1 | Add zero records to all tables | This process ensure all tables in the Framework database have a 'zero record' (i.e a record with a PKID of 0) in them, as required for the Framework system internally to link data. | |
| 2 | Compile Construction Chart Data | ||
| 3 | Compile Labour Allocation Entity Statistics (Carpenter) | ||
| 4 | Compile Labour Allocation Entity Statistics (Standard) | ||
| 5 | Create Construction Programme | ||
| 6 | Forecast Labour Requirements | ||
| 7 | Link Purchase Orders | ||
| 8 | Linked Files - Create Client Folders | ||
| 9 | Linked Files - Create Job Folders | ||
| 10 | Linked Files - Create Land Folders (All Lands) | ||
| 11 | Linked Files - Create Purchase Order Folders | ||
| 12 | Permanently Delete Client (this cannot be undone) | ||
| 13 | Permanently Delete File (this cannot be undone) | ||
| 14 | Permanently Delete Job (this cannot be undone) | ||
| 15 | Recalculate Logistics Progress | ||
| 16 | Run Logistics MS-Access Triggers | ||
| 17 | Update All Construction Details | ||
| 18 | Update Construction Claims | ||
| 19 | Update Construction Delays | ||
| 20 | Update Construction History Notes | ||
| 21 | Update Construction Progress | ||
| 22 | Update Construction Progress (All including non-dirty) | ||
| 23 | Update Job Status | ||
| 24 | Update Logistics Item Completion Statistics | ||
| 25 | Update Maintenance Request Work Flow Stage | ||
| 26 | Update System Keys | ||
| 27 | Update Total Number of Tender Appointments | ||
| 28 | Update Workflow Stage |