User-defined Stored Procedures

The following user-defined stored procedures are optional to implement.

Implementation is the responsibility of your system or SQL administrator, in consultation with Star.

Budgeted Margin and Realisation

The Selected Budget tab, Job Details region supports Budget Fee, Budgeted Realisation, and Budgeted Margin. Budgeted Margin and Budgeted Realisation calculations are customisable using the following user-defined stored procedure:

• ps_sdlc_tblWIP_SELECT_JobBudgetMarginAndRealisation_UserDefined

Budget Fee is editable with the appropriate UDF privileges.

Prior Year

Prior Year functionality can be fully customised.

The following user-defined stored procedures can be used to define both the layout of the grid on the Prior Year tab (at both levels) and the default calculations that populate it.

• ps_sdlc_tblJobPriorYearSplits_INSERT_JobBudgetCalcPriorYear_UserDefined

  This script allows the customisation of the calculations that populate the Prior Year table, as well as the ability to use non-required fields for other purposes.

  Whereas Star provide the standard version of the JobBudgetCalcPriorYear procedure for StarPM, there was no equivalent for WinForms. In any implementation of WinForms Job Budgeting using this functionality, both Web and WinForms procedures should be reviewed to ensure consistency. For example, where an overnight Job process is run to keep figures up-to-date a single procedure can be used only If calculations are the same in both Web and WinForms.

• ps_sdlc_tblJobPriorYearSplits_SELECT_JobBudget_PYSplits_UserDefined

  This script allows the customisation of the top level of the Prior Year grid display.

• ps_sdlc_tblJobPriorYearSplits_SELECT_JobBudget_PYSummary_UserDefined

  This script allows the customisation of the expanded (drill-down) Prior Year grid display.

• ps_sdlc_tblJobPriorYearSplits_SELECT_JobBudgetHeaders_UserDefined

  This script allows both the definition of headers for columns inserted into the Prior Year grid and the customisation of existing column headers, if appropriated for alternative usage. A select statement gives a string titles a field name that matches a column in either grid level, e.g.

  SELECT ‘Alternate Use Title’ AS [Margin], ……..

  Replace Terms are not supported if reserved characters or HTML tags are included in column headers.