Atomic Warehouse Model Data Model

Entity

Entity Underwriting Process Detail

Description

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

Attributes
Actual End Dt
Actual Labor Hours
Actual Start Dt
Actual Time Spent
Dangerous Ind
Decision Outcome Ind
Delay Reason Code Sk
Effective From Dt
Effective To Dt
Load Info Sk
Medical Examination Required Ind
Name
Number Of Services Allowed
Planned Cost Per Occurrence
Planned Duration
Planned End Dt
Planned Manpower
Planned Start Dt
Projected Claims Cost
Projected Sales General and Administration SGA Costs
Rate Adjustment Factor
Rate Adjustment Reason Ind
Source Code Sk
Statement Of Health Required Ind
Tenant Sk
Underwriting Activity Status Code Sk
Underwriting Decision Ind
Underwriting Decision Reason Ind
Underwriting Guideline Code Sk
Underwriting Process Sk
Valid From Ts
Valid To Ts

Relationship
Underwriting Process Detail_Underwriting Process_FK

Primary Key
Underwriting Process Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Actual End Dt

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 Dt

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 Code Sk

Description	Reason for discrepancy between planned and actual end date.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
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

Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
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.
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 Dt

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 manpower 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 Dt

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

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
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

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Underwriting Activity Status Code Sk

Description	Indicates the current state of the underwriting activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
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 Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Underwriting Process Sk

Description	The generated surrogate key of the Underwriting Process anchor.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Underwriting Process Detail_Underwriting Process_FK

Is Identifying Relationship	true
Child Table	Underwriting Process Detail
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	Underwriting Process
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Underwriting Process Detail PK

Key Attribute	Underwriting Process Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model