Business Data Model Data Model

Entity

Entity Underwriting Process

Description

A process of determining the insurability of a risk, in particular, in the process of issuing new insurance policies.

Attributes
Actual End Date
Actual Labor Hours
Actual Start Date
Actual Time Spent
Dangerous Ind
Decision Outcome Ind
Delay Reason
Medical Examination Required Ind
Name
Number Of Services Allowed
Planned Cost Per Occurrence
Planned Duration
Planned End Date
Planned Manpower
Planned Start Date
Projected Claims Cost
Projected Sales General and Administration SGA Costs
Rate Adjustment Factor
Rate Adjustment Reason Ind
Statement Of Health Required Ind
Underwriting Activity Status
Underwriting Decision Ind
Underwriting Decision Reason Ind
Underwriting Guideline

Relationship
Application is involved in Underwriting Activity
Underwriter performs Underwriting Activity
Medical Examination is required by Underwriting Activity
Underwriting Process_Actuarial Statistic Set_FK
Underwriting Process_Person_FK
Underwriting Process_Health Risk Assessment_FK
Underwriting Process_Disease Risk Assessment_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Actual End Date

Description	The actual date upon which the activity was ended.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Actual Labor Hours

Description	Actual number hours that it took to perform the activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Actual Start Date

Description	The actual date upon which the activity was started.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Actual Time Spent

Description	The actual time spent performing the activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Dangerous Ind

Description	Indicates whether or not the characteristics of this underwriting activity are considered dangerous by the modeled organization. In the case of insurance, performing dangerous activities will often increase risk premiums.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Decision Outcome Ind

Description	Indicates the outcome of the underwriting activity. For example: A = Approved N = Not Required R = Rejected T = Re-Rated
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Delay Reason

Description	Indicates the cause of any discrepancy between planned and actual end dates.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Medical Examination Required Ind

Description	Indicates whether or not a medical examination is required for the purposes of the underwriting activity. For example: 0 = Not Required 1 = Required
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Name

Description	Name of the activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Services Allowed

Description	Specifies a restriction on the quantity of eligible services allowed.
Data Type	Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Planned Cost Per Occurrence

Description	The planned monetary amount allocated for every occurrence of the activity. For example: The estimated cost for every outbound contact in a marketing activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Planned Duration

Description	The time planned for the performing of the activity. This is the total elapsed time over which the activity is expected to be performed and not the planned labor hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Planned End Date

Description	Date upon which the activity is planned to end.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Planned Manpower

Description	The planned labor hours required for the activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Planned Start Date

Description	Date upon which the activity is planned to start.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Projected Claims Cost

Description	The projected claims cost that the premium rate is based on.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Projected Sales General and Administration SGA Costs

Description	The projected sales general and administration costs (SG&A) that the premium rate is based on.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Rate Adjustment Factor

Description	The extent to which the standard underwriting rate was adjusted.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Rate Adjustment Reason Ind

Description	Indicates the reason for the adjustment of the standard rate. For example: C = Current Health Status F = Family History
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Statement Of Health Required Ind

Description	Indicates whether or not a statement of health is required for the purposes of the underwriting activity. For example: 0 = Not Required 1 = Required
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Underwriting Activity Status

Description	Indicates the current state of the underwriting activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Underwriting Decision Ind

Description	Indicates the nature of the underwriting decision. For example: Decline Modified Approval Not required Re-rated Standard Approval
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Underwriting Decision Reason Ind

Description	Indicates the reason for the underwriting decision. For example: Chronic medical condition Fraudulent claim discovery Insufficient policy administration infrastructure
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Underwriting Guideline

Description	Rule, standard, marketing decision, guideline, or practice used by a health plan or its agent to examine, accept, reject, renew, non-renew, cancel, or limit a coverage agreement.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Application is involved in Underwriting Activity

Is Identifying Relationship	false
Child Table	Underwriting Process
Child Role Name	involves
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Application
Parent Role Name	is involved in
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Underwriter performs Underwriting Activity

Is Identifying Relationship	false
Child Table	Underwriting Process
Child Role Name	is performed by
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Underwriter
Parent Role Name	performs
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Medical Examination is required by Underwriting Activity

Is Identifying Relationship	false
Child Table	Underwriting Process
Child Role Name	requires
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Medical Examination
Parent Role Name	is required by
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Underwriting Process_Actuarial Statistic Set_FK

Is Identifying Relationship	false
Child Table	Underwriting Process
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Actuarial Statistic Set
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Underwriting Process_Person_FK

Is Identifying Relationship	false
Child Table	Underwriting Process
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Person
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Underwriting Process_Health Risk Assessment_FK

Is Identifying Relationship	false
Child Table	Underwriting Process
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Health Risk Assessment
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Underwriting Process_Disease Risk Assessment_FK

Is Identifying Relationship	false
Child Table	Underwriting Process
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Disease Risk Assessment
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Overview

Top

Package

Entity

Business Data Model Data Model