Contract Application Calculation

System Administration Information

Configuration Outline

All results are held in a single data table [tblProjectCosts].  This table is indexed directly to the main Schemes table [tblProjects] using the GUID identifier to link the tables.

The core calculation steps are defined as a series of SQL Scripts held in the HighStone System Table - tbsSQLStatements.  The structure for this is as follows:

• A title configuration entry that defines a list of target SQL Numbers / Action Classes that the calculation process moves through.  Each stage is entered as a Number,Keyword pair, each pair on a separate line and set in the order in which the steps are applied.  The Number refers to a series of SQL Scripts, the Keyword must match one of the defined options.  This definition is held in SQL Id 1000000, SQL Count 0.

• A configuration SQL that holds the SQL script used to display the results.  This is held in SQL Id 1000000, SQL Count 2.

• A number of SQL Statement Series are defined to hold the actual SQL Scripts.

More:

Contract Application SQL Definition