Insurance Underwriting Quotes Dimension table names and their remarks are given here.
Logical Dimension Table Name |
Remarks |
Quote Source Dimension |
This table stores the description of the source of the quote. For example, Producing Agency, Producing Agent, Customer, etc. |
Quote Source Method Dimension |
This table stores the description of the source method of the quotes. For example, Turbo rater, quick quote, etc. |
Quote Submission Method Dimension |
This table stores details of different methods from which the Insurance Company receives the quote. For example, mail, fax, internet, etc. |
Quote Declination Type Dimension |
This table stores all types of quote declinations. For example, Rates too high, Billing Plan, Fraud and Bankruptcy, Uninsurable Risks, Age of Building, etc. |
The mapping details for the Insurance Underwriting Quotes Dimension tables are given here.
Map Reference Number |
Source Table Name |
Logical Stage Table Name |
Dimension Table Name |
Logical Dimension Table Name |
251 |
STG_QUOTE_SOURCE |
Stage Quote Source |
DIM_QUOTE_SOURCE |
Quote Source Dimension |
252 |
STG_QUOTE_SOURCE_METHOD |
Stage Quote Source Method |
DIM_QUOTE_SOURCE_METHOD |
Quote Source Method Dimension |
253 |
STG_QUOTE_SUBMISSION_METHOD |
Stage Quote Submission Method |
DIM_QUOTE_SUBMISSION_METHOD |
Quote Submission Method Dimension |
250 |
STG_QUOTE_DECLINATION_TYPE |
Stage Quote Declination Type |
DIM_QUOTE_DECLINATION_TYPE |
Quote Declination Type Dimension |