Appearance
dbo.EthEstimatorPerformance
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.EthEstimatorPerformance.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | Estimator | nvarchar(200) | no | Name of the estimator this performance summary row is for. | |
| 2 | State | nvarchar(10) | yes | Australian state the estimator's jobs are located in. | |
| 5 | Year | nvarchar(10) | yes | Calendar/reporting year this performance summary row covers. | |
| 6 | Quoted | int | yes | Count of quotes submitted by the estimator in the period. | |
| 7 | Won | int | yes | Count of the estimator's quotes that were won/authorised in the period. | |
| 8 | Lost | int | yes | Count of the estimator's quotes that were lost/declined in the period. | |
| 9 | Maybe | int | yes | Count of the estimator's quotes still pending/undecided in the period. | |
| 12 | WonValue | decimal(38,2) | yes | Total dollar value of the estimator's won quotes in the period. | |
| 13 | InstructingClient | nvarchar(255) | yes | Name of the insurer/client that instructed the jobs being summarised. | |
| 14 | QuotationType | varchar(37) | yes | Type/category of quotation the summary figures relate to. | |
| 16 | QuotedValue | decimal(38,2) | yes | Total dollar value of all quotes submitted by the estimator in the period. | |
| 17 | JobNumber | nvarchar(10) | yes | Job number associated with this summary row, where applicable. | |
| 18 | NMonth | varchar(20) | yes | Numeric or short-form month value used for sorting the reporting period. |
Referenced by
Procedures: dbo.LoadEthEstimatorPerformance, dbo.spEthEstimatorPerformance