Warning | ||
---|---|---|
| ||
Database tool operations permanently affect your data and should only be performed in consultation with Insula Software. |
...
Two tabs are available on the Database Tools screen:
- Tools Tab
- Services Tab
...
Info |
---|
The Database Tools screen is not accessible from all Framework ECM modules. |
Tools Tab
Perform A Database Modification Using A Database Tool
...
The following contains a list of database tools in Framework ECM.
Database Tool | Description | Typical Criteria |
---|---|---|
Add Zero Records to All Tables | The Add Zero Records to all Tables tool ensures that the Framework database contains the necessary data to operate correctly. | |
Compile Construction Chart Data | The Compile Construction Chart Data tool prepares Framework construction data so that it displays correctly on the Construction Chart report. | Apply To: · All jobs by major stage · Region/Division · Criteria: Construction |
Compile Labour Allocation Entity Statistics (Carpenter) | The Forecast Labour Requirements tool is used to apply a pre-determined labour program to determine how carpenter labour is currently allocated to jobs and their activities. | Apply To: · All jobs by major stage · Region/Division · Criteria: Construction |
Compile Labour Allocation Entity Statistics (Standard) | The Forecast Labour Requirements tool is used to apply a pre-determined labour program to determine how various labour is currently allocated to jobs and their activities. | Apply To: · All jobs by major stage · Region/Division · Criteria: Construction |
Create Construction Programme | The Create Construction Programme tool automates the creation of a pre-determined construction program against jobs, based on the selected criteria. | Apply To: · All jobs by major stage · Region/Division · Criteria: Construction |
Forecast Labour Requirements | The Forecast Labour Requirements tool is used to apply a pre-determined labour program to determine which jobs and activities will require labour allocation. | Apply To: · All jobs by major stage · Region/Division · Criteria: Construction |
Linked Files - Create Client Folders | Creates the Client Linked Files based on the criteria and Linked Files path in the Configuration. | |
Linked Files - Create Job Folders | Creates the Client Linked Files based on the criteria and Linked Files path in the Configuration. | |
Linked Files - Create Land Folders (All Lands) | Creates the Land Linked Files for all enterprise land with a Land Number, based on the Linked Files path in the Configuration. | |
Linked Files - Create Purchase Order Folders | Creates the Client Linked Files based on the criteria and Linked Files path in the Configuration. | |
Permanently Delete Client (This Cannot Be Undone) | The Permanently Delete Client tool deletes a client record so that is physically removed from the database and is no longer accessible. This is different to changing the status to Deleted, and is irreversible. | Apply To: · Current job |
Permanently Delete File (This Cannot Be Undone) | The Permanently Delete Client tool deletes a client record so that is physically removed from the database and is no longer accessible. This is different to changing the status to Deleted, and is irreversible. | Apply To: · Current job |
Permanently Delete Job (This Cannot Be Undone) | The Permanently Delete Client tool deletes a client record so that is physically removed from the database and is no longer accessible. This is different to changing the status to Deleted, and is irreversible. | Apply To: · Current job |
Recalculate Logistics Progress | The Permanently Delete Client tool deletes a client record so that is physically removed from the database and is no longer accessible. This is different to changing the status to Deleted, and is irreversible. | Apply To: · Current job |
Run Logistics MS-Access Triggers | The Run Logistics MS-Access Triggers tool forces the launch of a pre-determined triggers database. | |
Update All Construction Details | The Update All Construction Details tool combines the following tools; Update Work Flow Stage Update Construction Progress Update Construction Claims Update Construction Delays; | Apply To: · All jobs by major stage · Region/Division · Criteria: Construction |
Update Construction Claims | The purpose of the Update Construction Claims tool is to force the capture of claim dates and use them to raise the claims, based on the selected criteria. | Apply To: · All jobs by major stage · Region/Division · Criteria: Construction |
Update Construction Delays | The Update Construction Delays tool forces the recalculation of all statistics and ensures the anticipated completion date is correct. | Apply To: · All jobs by major stage · Region/Division · Criteria: Construction |
Update Construction History Notes | The Update Construction History Notes tool is used to force the Supervisors Comments for the progress period to be viewed in the Construction Overview screen, based on the selected criteria. | Apply To: · All jobs by major stage · Region/Division · Criteria: Construction |
Update Construction Progress | The purpose of the Update Construction Progress tool is to update a jobs progress percentage, statistics and relevant forecasting for all periods with recent activity, based on the selected criteria. | Apply To: · All jobs by major stage · Region/Division · Criteria: Construction |
Update Construction Progress (All including non-dirty) | The purpose of the Update Construction Progress tool is to update a jobs progress percentage, statistics and relevant forecasting, based on the selected criteria. The “non-dirty” relates to progress periods that have not had recent activity. This tool will run across all progress periods associated with the job. | Apply To: · All jobs by major stage · Region/Division · Criteria: Construction |
Update Job Status | The Update Job Status tool is used to force the update of status (Active, On Hold, Cancelled, Deleted) on jobs, based on the selected criteria. | Apply To: · All jobs |
Update Logistics Item Completion Statistics | The Update Logistics Item Completion Statistics tool is used to force the calculation of the progress percentages on individual activities within the construction program for a job. | Apply To: · All jobs by major stage · Region/Division · Criteria: Construction |
Update Maintenance Request Work Flow Stage | The Update Maintenance Request Work Flow Stage tool is used to force the update of the request stage on jobs, based on the selected criteria. | Apply To: · All jobs by major stage · Region/Division · Criteria: Maintenance |
Update System Keys | This area is currently under development. | Apply To: · All jobs |
Update Total Number of Tender Appointments | The Update Total Number of Tender Appointments tool ensures the Tender appointment count for a job is updated and correct. | Apply To: · All jobs |
Update Workflow Stage | The Update Workflow Stage tool is used to force the update of minor stage on jobs, based on the selected criteria. | Apply To: All jobs |
Services Tab
Refreshing A Data Service
...