Entity EPFProgression

Description of Entity EPFProgression

This entity is for the Malaysia Payroll.

EPF stands for Employment Provident Fund. Its main aim is to provide a measure of security for old age retirement to its members. It also provides supplementary benefits to members to use part of the savings for house ownership and other schemes.


List of all Dependencies of the Entity EPFProgression

Name

Code

Class Name

Relation_770982

Relation_770982

Reference


List of Attributes of the Entity EPFProgression

Name

Code

EmployeeSysId

EmployeeSysId

Effective Date

EPFEffectiveDate

Career Code

EPFCareerId

EPF Policy

EPFProgPolicyId

EPF Scheme

EPFProgSchemeId

EPFEEVolPercent

EPFEEVolPercent

EPFERVolPercent

EPFERVolPercent

Remarks

EPFProgRemarks

Current

EPFProgCurrent

EPFEEVolAmt

EPFEEVolAmt

EPFERVolAmt

EPFERVolAmt


Entity Attribute EmployeeSysId of the Entity EPFProgression

Card of Attribute EmployeeSysId of the Entity EPFProgression

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity EPFProgression

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


Entity Attribute Effective Date of the Entity EPFProgression

Card of Attribute Effective Date of the Entity EPFProgression

Name

Effective Date

Code

EPFEffectiveDate

Data Type

date

Mandatory

Yes


Description of Attribute Effective Date of the Entity EPFProgression

Shows the effective date of the EPF progression. It also holds the primary key for the EPFProgression table.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Career Code of the Entity EPFProgression

Card of Attribute Career Code of the Entity EPFProgression

Name

Career Code

Code

EPFCareerId

Data Type

char(20)

Mandatory

No


Description of Attribute Career Code of the Entity EPFProgression

Shows the identity of the career for the employee.
Example: FirstRecord / Transfer / Promotion / SalaryAdjust etc


Entity Attribute EPF Policy of the Entity EPFProgression

Card of Attribute EPF Policy of the Entity EPFProgression

Name

EPF Policy

Code

EPFProgPolicyId

Data Type

char(20)

Mandatory

No


Description of Attribute EPF Policy of the Entity EPFProgression

Shows the identity of the EPF Policy.


Entity Attribute EPF Scheme of the Entity EPFProgression

Card of Attribute EPF Scheme of the Entity EPFProgression

Name

EPF Scheme

Code

EPFProgSchemeId

Data Type

char(20)

Mandatory

No


Description of Attribute EPF Scheme of the Entity EPFProgression

Shows the identity of the EPF scheme.
Example: Pension / NonPension / Private etc


Entity Attribute EPFEEVolPercent of the Entity EPFProgression

Card of Attribute EPFEEVolPercent of the Entity EPFProgression

Name

EPFEEVolPercent

Code

EPFEEVolPercent

Data Type

double

Mandatory

No


Description of Attribute EPFEEVolPercent of the Entity EPFProgression

Shows the voluntary percentage of the EPF for the employee.


Entity Attribute EPFERVolPercent of the Entity EPFProgression

Card of Attribute EPFERVolPercent of the Entity EPFProgression

Name

EPFERVolPercent

Code

EPFERVolPercent

Data Type

double

Mandatory

No


Description of Attribute EPFERVolPercent of the Entity EPFProgression

Shows the voluntary percentage of the EPF for the employer.


Entity Attribute Remarks of the Entity EPFProgression

Card of Attribute Remarks of the Entity EPFProgression

Name

Remarks

Code

EPFProgRemarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity EPFProgression

Stores any remarks about the EPF progression.


Entity Attribute Current of the Entity EPFProgression

Card of Attribute Current of the Entity EPFProgression

Name

Current

Code

EPFProgCurrent

Data Type

smallint

Mandatory

No


Description of Attribute Current of the Entity EPFProgression

Shows if the employee is currently employed in that company.


Entity Attribute EPFEEVolAmt of the Entity EPFProgression

Card of Attribute EPFEEVolAmt of the Entity EPFProgression

Name

EPFEEVolAmt

Code

EPFEEVolAmt

Data Type

double

Mandatory

No


Description of Attribute EPFEEVolAmt of the Entity EPFProgression

Shows the voluntary amount of the EPF for the employee.


Entity Attribute EPFERVolAmt of the Entity EPFProgression

Card of Attribute EPFERVolAmt of the Entity EPFProgression

Name

EPFERVolAmt

Code

EPFERVolAmt

Data Type

double

Mandatory

No


Description of Attribute EPFERVolAmt of the Entity EPFProgression

Shows the voluntary amount of the EPF for the employer.