Configuration SQL Definition

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:

 

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:

SQL Series 1000000

SQL Series 1000010

SQL Series 1000040

SQL Series 1000060

SQL Series 1000070