Logical Dimension Table Name

Remarks

Underwriting Product Class Dimension

This table stores identification details of the underwriting class and its respective name or names. Underwriting class is carrier specific nomenclature representing the underwriting groups or products or risks in a given organization.

Application Dimension

This table stores the underwriting application details.

Application Type Dimension

This table stores the application type details such as fresh, existing, and enhancements.

Application Group Dimension

This table stores the underwriting application group details. Application group can contain one or more applications.

Application Status Dimension

This table stores the master list of application status such as processing, cancelled by customer, outstanding, outstanding from restructuring, etc.

Document Submission Status Dimension

This table stores the list of various status that a document can have. Document once submitted to an Insurance Company contains different status such as Pending, Received, Mailed for approval, Received Back, Under Processing, Approved, etc.

Rejection Reason Dimension

This table stores all the rejection reasons given by prospects for not buying a product or service.

Application Reject Reasons Dimension

This table stores the list of rejection reasons possible when processing an application.

Application Decision Event Dimension

This table stores the details of the outcome of all decision events for the individual application. During the process of underwriting, an application goes through various stages such as personal identity verification, address verification, employment verification, etc.

Underwriting Model Type Dimension

This table stores the list of all types of underwriting model types.

Underwriting Element Dimension

This table stores the classification details of insurance policy underwriting related to tobacco usage.

Sample values: BLENDED, NONSMOKER, SMOKER, TOBACCO, etc.

Insurance Underwriting Issue Type Dimension

This table stores the Insurance Underwriting issue type details for a policy. For example Full Underwriting, Mass Underwriting, Reduced Underwriting, Simplified Underwriting, etc.

Sample values: OTHER, UNKNOWN, AVIATION, PERCOVERAGE, etc.

Insurance Underwriting Issue Sub Type Dimension

This table stores the Insurance Underwriting issue sub type details for a policy. This table provides additional details about the type of underwriting that was applied to the coverage.

Sample values: OTHER, UNKNOWN, FULLMED, NONMED, PARAMED.

Map Reference Number

Source Table Name

Logical Stage Table Name

Dimension Table Name

Logical Dimension Table Name

523

STG_UNW_PRODUCT_CLASS_MASTER

Stage Underwriting Product Class Master

DIM_UNW_PRODUCT_CLASS

Underwriting Product Class Dimension

664

STG_APPLICATIONS 

Stage Applications

DIM_APPLICATION

Application Dimension

162

STG_APPL_TYPE_MASTER

Stage Application Type Master

DIM_APPLICATION_TYPE

Application Type Dimension

665

STG_APPLICATION_GROUP_MASTER

Stage Application Group Master

DIM_APPLICATION_GROUP

Application Group Dimension

166

STG_APPL_STATUS_MASTER

Stage Application Status Master

DIM_APPLICATION_STATUS

Application Status Dimension

673

STG_DOC_SUBMISSN_STATUS_MASTER

Stage Document Submission Status Master

DIM_DOC_SUBMISSION_STATUS

Document Submission Status Dimension

93

STG_REJECTION_REASON_MASTER

Stage Rejection Reason Master

DIM_REJECTION_REASON

Rejection Reason Dimension

3

STG_APPL_REJECT_REASON_MASTER

Stage Application Reject Reasons Master

DIM_APPLICATION_REJECT_REASONS

Application Reject Reasons Dimension

666

STG_APPLN_DECISION_EVNT_MASTER

Stage Application Decision Event Master

DIM_APPLN_DECISION_EVNT

Application Decision Event Dimension

409

STG_UNDRWRTNG_MDL_TYPE_MASTER

Stage Underwriting Model Type Master

DIM_UNDERWRITING_MODEL_TYPE

Underwriting Model Type Dimension

522

STG_UNDERWRITING_ELMNT_MASTER

Stage Underwriting Element Master

DIM_UNDERWRITING_ELEMENT

Underwriting Element Dimension

238

STG_UNDERWRITER_MASTER

Stage Underwriter Master

DIM_UNDERWRITER

Underwriter Dimension

725

STG_INS_UNW_ISSUE_TYPE_MASTER

Stage Insurance Underwriting Issue Type Master

DIM_INS_UNW_ISSUE_TYPE

Insurance Underwriting Issue Type Dimension

726

STG_INS_UNW_ISSUE_STYPE_MASTER

Stage Insurance Underwriting Issue Sub Type Master

DIM_INS_UNW_ISSUE_STYPE

Insurance Underwriting Issue Sub Type Dimension