Sage EasyPay Data Model

Entity InsurCoverage

Description of Entity InsurCoverage

The number to select depends on the difference in coverage plan.
Example: If you have two different coverage amount for employee and family then select two and set accordingly.

List of all Dependencies of the Entity InsurCoverage

Relation_984284

Relation_984284

Reference

Relation_979481

Relation_979481

Reference

List of Attributes of the Entity InsurCoverage

Insurance Benefit Code

InsurBenefitCode

InsurCoverageSysId

InsurCoverageSysId

Total Year Premium 1

TotalYrPremium1

Total Year Premium 2

TotalYrPremium2

Total Year Premium 3

TotalYrPremium3

Total Year Premium 4

TotalYrPremium4

Total Year Premium 5

TotalYrPremium5

Emp Year Premium 1

Emp Year Premium 2

Emp Year Premium 3

Emp Year Premium 4

Emp Year Premium 5

Total Month Premium 1

TotalMthPremium1

Total Month Premium 2

TotalMthPremium2

Total Month Premium 3

TotalMthPremium3

Total Month Premium 4

TotalMthPremium4

Total Month Premium 5

TotalMthPremium5

Emp Month Premium 1

Emp Month Premium 2

Emp Month Premium 3

Emp Month Premium 4

Emp Month Premium 5

Basis Coverage 1

Basis Coverage 2

Basis Coverage 3

Basis Coverage 4

Basis Coverage 5

Entity Attribute Insurance Benefit Code of the Entity InsurCoverage

Card of Attribute Insurance Benefit Code of the Entity InsurCoverage

Name	Insurance Benefit Code
Code	InsurBenefitCode
Data Type	char(20)
Mandatory	Yes

Description of Attribute Insurance Benefit Code of the Entity InsurCoverage

Shows the benefit code for the insurance. It holds the primary key for the InsurBenefit table.

Entity Attribute InsurCoverageSysId of the Entity InsurCoverage

Card of Attribute InsurCoverageSysId of the Entity InsurCoverage

Name	InsurCoverageSysId
Code	InsurCoverageSysId
Data Type	integer
Mandatory	Yes

Description of Attribute InsurCoverageSysId of the Entity InsurCoverage

A system generated identity. It is blind to the user. This also holds the primary key for the InsurCoverage table.

Entity Attribute Total Year Premium 1 of the Entity InsurCoverage

Card of Attribute Total Year Premium 1 of the Entity InsurCoverage

Name	Total Year Premium 1
Code	TotalYrPremium1
Data Type	double
Mandatory	No

Description of Attribute Total Year Premium 1 of the Entity InsurCoverage

Shows the total year premium.

Entity Attribute Total Year Premium 2 of the Entity InsurCoverage

Card of Attribute Total Year Premium 2 of the Entity InsurCoverage

Name	Total Year Premium 2
Code	TotalYrPremium2
Data Type	double
Mandatory	No

Description of Attribute Total Year Premium 2 of the Entity InsurCoverage

Shows the total year premium.

Entity Attribute Total Year Premium 3 of the Entity InsurCoverage

Card of Attribute Total Year Premium 3 of the Entity InsurCoverage

Name	Total Year Premium 3
Code	TotalYrPremium3
Data Type	double
Mandatory	No

Description of Attribute Total Year Premium 3 of the Entity InsurCoverage

Shows the total year premium.

Entity Attribute Total Year Premium 4 of the Entity InsurCoverage

Card of Attribute Total Year Premium 4 of the Entity InsurCoverage

Name	Total Year Premium 4
Code	TotalYrPremium4
Data Type	double
Mandatory	No

Description of Attribute Total Year Premium 4 of the Entity InsurCoverage

Shows the total year premium.

Entity Attribute Total Year Premium 5 of the Entity InsurCoverage

Card of Attribute Total Year Premium 5 of the Entity InsurCoverage

Name	Total Year Premium 5
Code	TotalYrPremium5
Data Type	double
Mandatory	No

Description of Attribute Total Year Premium 5 of the Entity InsurCoverage

Shows the total year premium.

Entity Attribute Emp Year Premium 1 of the Entity InsurCoverage

Card of Attribute Emp Year Premium 1 of the Entity InsurCoverage

Name	Emp Year Premium 1
Code	EmpYrPremium1
Data Type	double
Mandatory	No

Description of Attribute Emp Year Premium 1 of the Entity InsurCoverage

Shows the employee year premium.

Entity Attribute Emp Year Premium 2 of the Entity InsurCoverage

Card of Attribute Emp Year Premium 2 of the Entity InsurCoverage

Name	Emp Year Premium 2
Code	EmpYrPremium2
Data Type	double
Mandatory	No

Description of Attribute Emp Year Premium 2 of the Entity InsurCoverage

Shows the employee year premium.

Entity Attribute Emp Year Premium 3 of the Entity InsurCoverage

Card of Attribute Emp Year Premium 3 of the Entity InsurCoverage

Name	Emp Year Premium 3
Code	EmpYrPremium3
Data Type	double
Mandatory	No

Description of Attribute Emp Year Premium 3 of the Entity InsurCoverage

Shows the employee year premium.

Entity Attribute Emp Year Premium 4 of the Entity InsurCoverage

Card of Attribute Emp Year Premium 4 of the Entity InsurCoverage

Name	Emp Year Premium 4
Code	EmpYrPremium4
Data Type	double
Mandatory	No

Description of Attribute Emp Year Premium 4 of the Entity InsurCoverage

Shows the employee year premium.

Entity Attribute Emp Year Premium 5 of the Entity InsurCoverage

Card of Attribute Emp Year Premium 5 of the Entity InsurCoverage

Name	Emp Year Premium 5
Code	EmpYrPremium5
Data Type	double
Mandatory	No

Description of Attribute Emp Year Premium 5 of the Entity InsurCoverage

Shows the employee year premium.

Entity Attribute Total Month Premium 1 of the Entity InsurCoverage

Card of Attribute Total Month Premium 1 of the Entity InsurCoverage

Name	Total Month Premium 1
Code	TotalMthPremium1
Data Type	double
Mandatory	No

Description of Attribute Total Month Premium 1 of the Entity InsurCoverage

Shows the total month premium.

Entity Attribute Total Month Premium 2 of the Entity InsurCoverage

Card of Attribute Total Month Premium 2 of the Entity InsurCoverage

Name	Total Month Premium 2
Code	TotalMthPremium2
Data Type	double
Mandatory	No

Description of Attribute Total Month Premium 2 of the Entity InsurCoverage

Shows the total month premium.

Entity Attribute Total Month Premium 3 of the Entity InsurCoverage

Card of Attribute Total Month Premium 3 of the Entity InsurCoverage

Name	Total Month Premium 3
Code	TotalMthPremium3
Data Type	double
Mandatory	No

Description of Attribute Total Month Premium 3 of the Entity InsurCoverage

Shows the total month premium.

Entity Attribute Total Month Premium 4 of the Entity InsurCoverage

Card of Attribute Total Month Premium 4 of the Entity InsurCoverage

Name	Total Month Premium 4
Code	TotalMthPremium4
Data Type	double
Mandatory	No

Description of Attribute Total Month Premium 4 of the Entity InsurCoverage

Shows the total month premium.

Entity Attribute Total Month Premium 5 of the Entity InsurCoverage

Card of Attribute Total Month Premium 5 of the Entity InsurCoverage

Name	Total Month Premium 5
Code	TotalMthPremium5
Data Type	double
Mandatory	No

Description of Attribute Total Month Premium 5 of the Entity InsurCoverage

Shows the total month premium.

Entity Attribute Emp Month Premium 1 of the Entity InsurCoverage

Card of Attribute Emp Month Premium 1 of the Entity InsurCoverage

Name	Emp Month Premium 1
Code	EmpMthPremium1
Data Type	double
Mandatory	No

Description of Attribute Emp Month Premium 1 of the Entity InsurCoverage

Shows the employee month premium.

Entity Attribute Emp Month Premium 2 of the Entity InsurCoverage

Card of Attribute Emp Month Premium 2 of the Entity InsurCoverage

Name	Emp Month Premium 2
Code	EmpMthPremium2
Data Type	double
Mandatory	No

Description of Attribute Emp Month Premium 2 of the Entity InsurCoverage

Shows the employee month premium.

Entity Attribute Emp Month Premium 3 of the Entity InsurCoverage

Card of Attribute Emp Month Premium 3 of the Entity InsurCoverage

Name	Emp Month Premium 3
Code	EmpMthPremium3
Data Type	double
Mandatory	No

Description of Attribute Emp Month Premium 3 of the Entity InsurCoverage

Shows the employee month premium.

Entity Attribute Emp Month Premium 4 of the Entity InsurCoverage

Card of Attribute Emp Month Premium 4 of the Entity InsurCoverage

Name	Emp Month Premium 4
Code	EmpMthPremium4
Data Type	double
Mandatory	No

Description of Attribute Emp Month Premium 4 of the Entity InsurCoverage

Shows the employee month premium.

Entity Attribute Emp Month Premium 5 of the Entity InsurCoverage

Card of Attribute Emp Month Premium 5 of the Entity InsurCoverage

Name	Emp Month Premium 5
Code	EmpMthPremium5
Data Type	double
Mandatory	No

Description of Attribute Emp Month Premium 5 of the Entity InsurCoverage

Shows the employee month premium.

Entity Attribute Basis Coverage 1 of the Entity InsurCoverage

Card of Attribute Basis Coverage 1 of the Entity InsurCoverage

Name	Basis Coverage 1
Code	BasisCoverage1
Data Type	double
Mandatory	No

Description of Attribute Basis Coverage 1 of the Entity InsurCoverage

Shows the coverage basis for the insurance.

Entity Attribute Basis Coverage 2 of the Entity InsurCoverage

Card of Attribute Basis Coverage 2 of the Entity InsurCoverage

Name	Basis Coverage 2
Code	BasisCoverage2
Data Type	double
Mandatory	No

Description of Attribute Basis Coverage 2 of the Entity InsurCoverage

Shows the coverage basis for the insurance.

Entity Attribute Basis Coverage 3 of the Entity InsurCoverage

Card of Attribute Basis Coverage 3 of the Entity InsurCoverage

Name	Basis Coverage 3
Code	BasisCoverage3
Data Type	double
Mandatory	No

Description of Attribute Basis Coverage 3 of the Entity InsurCoverage

Shows the coverage basis for the insurance.

Entity Attribute Basis Coverage 4 of the Entity InsurCoverage

Card of Attribute Basis Coverage 4 of the Entity InsurCoverage

Name	Basis Coverage 4
Code	BasisCoverage4
Data Type	double
Mandatory	No

Description of Attribute Basis Coverage 4 of the Entity InsurCoverage

Shows the coverage basis for the insurance.

Entity Attribute Basis Coverage 5 of the Entity InsurCoverage

Card of Attribute Basis Coverage 5 of the Entity InsurCoverage

Name	Basis Coverage 5
Code	BasisCoverage5
Data Type	double
Mandatory	No

Description of Attribute Basis Coverage 5 of the Entity InsurCoverage

Shows the coverage basis for the insurance.