This is held in the HighStone SQL Definitions as SQL 1000000 - 0.
The following definition is used:
1000010,SQLSCRIPT
1000040,SETVALUES
1000060,SQLSCRIPT
1000070,SQLSCRIPT
The Keyword entries are defined as follows:
Keyword |
Action |
SQLSCRIPT |
Each SQL Script in the series is executed in sequence. |
NEWGUIDS |
This section identifies those Schemes that have Allocated Costs within the defined target Monthly Period, and then ensures the GUID record entries are added to the target table where necessary. The returned Record Set must include the target Scheme Identifier (integer) in the first field - other fields are ignored. Any number of lists may be submitted, HighStone compiles an ongoing list of Unique Identifiers, and then uses the last SQL in the definition to add missing GUIDs to the target working table. |
SETVALUES |
Each SQL Script in the series returns the Target GUID Entry, and one or more Return Values for the target source record. The Return Values are saved in the target data table. The target GUID must be the first value in each record, and other fields must be named to match the target column in the target data table. HighStone also rounds any Numeric Double values to 2 decimal places (rounding out any multiplication calculations). |
SPSSCHEMES |
A special section that collates Costs against Schemes where the Pricing Model spans more than one Target Scheme. The process moves all Costs Values to the single Scheme in the Pricing Model that is classed as the Primary Scheme. |
All source SQL Statements are processed to support:
TRUE and FALSE keywords
CURRENTPERIOD keyword that defines the target Reporting Month.
The following are the main stages to the Contract Application Build:
Stage Identifier |
Actions |
1000010 |
Set the Period Starting Values. If required updates the Previous Period Totals with the values from the previous Month - triggered when the target Month is changed. Current Period Costs are set to zero ready to receive new values. |
1000040 |
Pulls in the Cost Allocation Values from the various Cost Source records. This collates the Costs for Staff, Labour, Plant, Materials, Sub-Contract for the various elements. |
1000060 |
Calculation stages that build the interim and final Cost Totals across each Application record. |
1000070 |
Contract Scheme Application Report Build |
|
|
|
|
More: