Sage EasyPay Data Model

Entity InsurPlan

Description of Entity InsurPlan

There is a plan basis in the module. The number to select depends on the difference in coverage plan.
Example: If you have 2 different coverage amounts for employees and families, then select 2 and set accordingly.

List of all Dependencies of the Entity InsurPlan

Relation_979446

Relation_979446

Reference

List of Attributes of the Entity InsurPlan

Insurance Plan ID

No of Basis Plan

Entity Attribute Insurance Plan ID of the Entity InsurPlan

Card of Attribute Insurance Plan ID of the Entity InsurPlan

Name	Insurance Plan ID
Code	InsurPlanId
Data Type	char(20)
Mandatory	Yes

Description of Attribute Insurance Plan ID of the Entity InsurPlan

Shows the identity of the insurance plan. This is the primary key for the InsurPlan table.

Entity Attribute Description of the Entity InsurPlan

Card of Attribute Description of the Entity InsurPlan

Name	Description
Code	InsurPlanDesc
Data Type	char(200)
Mandatory	No

Description of Attribute Description of the Entity InsurPlan

Stores a description about the insurance plan.

Entity Attribute Group Plan of the Entity InsurPlan

Card of Attribute Group Plan of the Entity InsurPlan

Name	Group Plan
Code	InsurGroupPlan
Data Type	smallint
Mandatory	No

Description of Attribute Group Plan of the Entity InsurPlan

Indicates if the insurance is a group plan, in a form of a checkbox.

Entity Attribute Plan Basis 1 of the Entity InsurPlan

Card of Attribute Plan Basis 1 of the Entity InsurPlan

Name	Plan Basis 1
Code	InsurBasis1
Data Type	char(20)
Mandatory	No

Description of Attribute Plan Basis 1 of the Entity InsurPlan

Shows a basis of the insurance.

Entity Attribute Plan Basis 2 of the Entity InsurPlan

Card of Attribute Plan Basis 2 of the Entity InsurPlan

Name	Plan Basis 2
Code	InsurBasis2
Data Type	char(20)
Mandatory	No

Description of Attribute Plan Basis 2 of the Entity InsurPlan

Shows a basis of the insurance.

Entity Attribute Plan Basis 3 of the Entity InsurPlan

Card of Attribute Plan Basis 3 of the Entity InsurPlan

Name	Plan Basis 3
Code	InsurBasis3
Data Type	char(20)
Mandatory	No

Description of Attribute Plan Basis 3 of the Entity InsurPlan

Shows a basis of the insurance.

Entity Attribute Plan Basis 4 of the Entity InsurPlan

Card of Attribute Plan Basis 4 of the Entity InsurPlan

Name	Plan Basis 4
Code	InsurBasis4
Data Type	char(20)
Mandatory	No

Description of Attribute Plan Basis 4 of the Entity InsurPlan

Shows a basis of the insurance.

Entity Attribute Plan Basis 5 of the Entity InsurPlan

Card of Attribute Plan Basis 5 of the Entity InsurPlan

Name	Plan Basis 5
Code	InsurBasis5
Data Type	char(20)
Mandatory	No

Description of Attribute Plan Basis 5 of the Entity InsurPlan

Shows a basis of the insurance.

Entity Attribute No of Basis Plan of the Entity InsurPlan

Card of Attribute No of Basis Plan of the Entity InsurPlan

Name	No of Basis Plan
Code	InsurBasisNo
Data Type	integer
Mandatory	No

Description of Attribute No of Basis Plan of the Entity InsurPlan

Shows the number of basis plans.