Entity Insurance

Description of Entity Insurance

The Benefit and Compensation module helps to track the insurance coverage and pay-out to employees. Basic insurance related features are available, ranging from setting up new policies to payment and compensation. You can set up both Group and Individual policies, where Group refers to group coverage for employees and their families and Individual for only employees. Records of beneficiaries nominated by employees can be stored here as well.


List of all Dependencies of the Entity Insurance

Name

Code

Class Name

Relation_979511

Relation_979511

Reference

Relation_965139

Relation_965139

Reference

Relation_993852

Relation_993852

Reference

Relation_984316

Relation_984316

Reference

Relation_984309

Relation_984309

Reference


List of Attributes of the Entity Insurance

Name

Code

InsurGroupSysId

InsurGroupSysId

EmployeeSysId

EmployeeSysId

InsuranceSysId

InsuranceSysId

Sub Period

PayrollSubPeriod

Payroll Start Period

PayrollStartPeriod

Payroll Start Year

PayrollStartYear

Payroll End Period

PayrollEndPeriod

Payroll End Year

PayrollEndYear

Pay Element ID

PayrollPayElementId

Payment Count

PaymentCount

Payment Frequency

PaymentFreq

Remarks

Remarks

Payment Type

PaymentType


Entity Attribute InsurGroupSysId of the Entity Insurance

Card of Attribute InsurGroupSysId of the Entity Insurance

Name

InsurGroupSysId

Code

InsurGroupSysId

Data Type

integer

Mandatory

No


Description of Attribute InsurGroupSysId of the Entity Insurance

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


Entity Attribute EmployeeSysId of the Entity Insurance

Card of Attribute EmployeeSysId of the Entity Insurance

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity Insurance

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.


Entity Attribute InsuranceSysId of the Entity Insurance

Card of Attribute InsuranceSysId of the Entity Insurance

Name

InsuranceSysId

Code

InsuranceSysId

Data Type

integer

Mandatory

Yes


Description of Attribute InsuranceSysId of the Entity Insurance

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


Entity Attribute Sub Period of the Entity Insurance

Card of Attribute Sub Period of the Entity Insurance

Name

Sub Period

Code

PayrollSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute Sub Period of the Entity Insurance

Shows the sub period for the payroll.

Example:
Sub period 1 = 1 Payment Group (Hourly, Daily & Monthly rated)
Sub period 2 = 2 Payment Group (Hourly, Daily & Monthly rated)
Sub period 3 = 3 Payment Group (Hourly & Daily rated), divided by 3 and the balance is placed in the last sub-period
Sub Period 4 = 4 Payment Group (Hourly & Daily rated)


Entity Attribute Payroll Start Period of the Entity Insurance

Card of Attribute Payroll Start Period of the Entity Insurance

Name

Payroll Start Period

Code

PayrollStartPeriod

Data Type

integer

Mandatory

No


Description of Attribute Payroll Start Period of the Entity Insurance

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


Entity Attribute Payroll Start Year of the Entity Insurance

Card of Attribute Payroll Start Year of the Entity Insurance

Name

Payroll Start Year

Code

PayrollStartYear

Data Type

integer

Mandatory

No


Description of Attribute Payroll Start Year of the Entity Insurance

Shows the start year for the payroll.
Example: 2013


Entity Attribute Payroll End Period of the Entity Insurance

Card of Attribute Payroll End Period of the Entity Insurance

Name

Payroll End Period

Code

PayrollEndPeriod

Data Type

integer

Mandatory

No


Description of Attribute Payroll End Period of the Entity Insurance

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


Entity Attribute Payroll End Year of the Entity Insurance

Card of Attribute Payroll End Year of the Entity Insurance

Name

Payroll End Year

Code

PayrollEndYear

Data Type

integer

Mandatory

No


Description of Attribute Payroll End Year of the Entity Insurance

Shows the end year for the payroll.
Example: 2014


Entity Attribute Pay Element ID of the Entity Insurance

Card of Attribute Pay Element ID of the Entity Insurance

Name

Pay Element ID

Code

PayrollPayElementId

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Element ID of the Entity Insurance

Shows the identity of the pay element.
Example:
INCO = Income Tax Deduction / Withheld
NOIL = Notice in Lieu Deductions
NATI = National Service Pay
COMC = Community Chest
etc

or

Transport and/or Medical Claims for the Training entity.


Entity Attribute Payment Count of the Entity Insurance

Card of Attribute Payment Count of the Entity Insurance

Name

Payment Count

Code

PaymentCount

Data Type

integer

Mandatory

No


Description of Attribute Payment Count of the Entity Insurance

Shows the payment count for the insurance.


Entity Attribute Payment Frequency of the Entity Insurance

Card of Attribute Payment Frequency of the Entity Insurance

Name

Payment Frequency

Code

PaymentFreq

Data Type

char(20)

Mandatory

No


Description of Attribute Payment Frequency of the Entity Insurance

Shows the frequency of the payment.


Entity Attribute Remarks of the Entity Insurance

Card of Attribute Remarks of the Entity Insurance

Name

Remarks

Code

Remarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity Insurance

Store remarks.


Entity Attribute Payment Type of the Entity Insurance

Card of Attribute Payment Type of the Entity Insurance

Name

Payment Type

Code

PaymentType

Data Type

char(20)

Mandatory

No


Description of Attribute Payment Type of the Entity Insurance

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