Sage EasyPay Data Model

Entity InsurProg

Description of Entity InsurProg

The progression of the insurance.

List of all Dependencies of the Entity InsurProg

Relation_979442

Reference

Relation_979444

Reference

List of Attributes of the Entity InsurProg

Entity Attribute InsurPlanProgSysId of the Entity InsurProg

Card of Attribute InsurPlanProgSysId of the Entity InsurProg

Name	InsurPlanProgSysId
Code	InsurPlanProgSysId
Data Type	integer
Mandatory	Yes

Description of Attribute InsurPlanProgSysId of the Entity InsurProg

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

Entity Attribute Insur From Date of the Entity InsurProg

Card of Attribute Insur From Date of the Entity InsurProg

Name	Insur From Date
Code	InsurFromDate
Data Type	date
Mandatory	No

Description of Attribute Insur From Date of the Entity InsurProg

Shows the start date of the insurance progression.
It is in the format: DD-MM-YYYY.

Entity Attribute Insur To Date of the Entity InsurProg

Card of Attribute Insur To Date of the Entity InsurProg

Name	Insur To Date
Code	InsurToDate
Data Type	date
Mandatory	No

Description of Attribute Insur To Date of the Entity InsurProg

Shows the end date of the insurance progression.
It is usually in the format: DD-MM-YYYY.

Entity Attribute No Of Employee of the Entity InsurProg

Card of Attribute No Of Employee of the Entity InsurProg

Name	No Of Employee
Code	NoOfEmployee
Data Type	integer
Mandatory	No

Description of Attribute No Of Employee of the Entity InsurProg

Shows the number of employees for the insurance progression.

Entity Attribute Payment Frequency of the Entity InsurProg

Card of Attribute Payment Frequency of the Entity InsurProg

Name	Payment Frequency
Code	PaymentFreq
Data Type	char(20)
Mandatory	No

Description of Attribute Payment Frequency of the Entity InsurProg

Shows the frequency of the payment.

Entity Attribute Payroll Start Period of the Entity InsurProg

Card of Attribute Payroll Start Period of the Entity InsurProg

Name	Payroll Start Period
Code	PayrollStartPeriod
Data Type	integer
Mandatory	No

Description of Attribute Payroll Start Period of the Entity InsurProg

Shows the start period for the payroll.
Example: January = "1", February = "2", March = "3" etc.

Entity Attribute Payroll Start Year of the Entity InsurProg

Card of Attribute Payroll Start Year of the Entity InsurProg

Name	Payroll Start Year
Code	PayrollStartYear
Data Type	integer
Mandatory	No

Description of Attribute Payroll Start Year of the Entity InsurProg

Shows the start year for the payroll.
Example: 2013

Entity Attribute Payroll End Period of the Entity InsurProg

Card of Attribute Payroll End Period of the Entity InsurProg

Name	Payroll End Period
Code	PayrollEndPeriod
Data Type	integer
Mandatory	No

Description of Attribute Payroll End Period of the Entity InsurProg

Shows the end period for the payroll.
Example: October = "10" / November = "11" / December = "12" etc

Entity Attribute Payroll End Year of the Entity InsurProg

Card of Attribute Payroll End Year of the Entity InsurProg

Name	Payroll End Year
Code	PayrollEndYear
Data Type	integer
Mandatory	No

Description of Attribute Payroll End Year of the Entity InsurProg

Shows the end year for the payroll.
Example: 2014

Entity Attribute Payment Type of the Entity InsurProg

Card of Attribute Payment Type of the Entity InsurProg

Name	Payment Type
Code	PaymentType
Data Type	char(20)
Mandatory	No

Description of Attribute Payment Type of the Entity InsurProg

Shows the type of payment made.
Example: Percentage / Balance / Fixed Amount

Home