Entity FWLProgression

Description of Entity FWLProgression

This entity would record all the foreign worker information, e.g. Work permit number, the issue date of the work permit number etc.

Tax and Statutory contribution policies vary from time to time as the Government responds to different economic and social factors. Changes, if any, are gradual and implemented in phases or stages. The Payroll Module is designed around these factors.

The Foreign Worker Levy (FWL) rates for different types of skill categories are contained in a table. Each employee is then assigned an FWL class through a FWL progression record. The first FWL progression record is automatically created when the employee's identity type in the personal record is set as FIN.


List of all Dependencies of the Entity FWLProgression

Name

Code

Class Name

Relation_79332

Relation_79332

Reference


List of Attributes of the Entity FWLProgression

Name

Code

EmployeeSysId

EmployeeSysId

Effective Date

FWLEffectiveDate

Career Code

FWLCareerId

Expiry Date

FWLExpiryDate

Application Date

FWLApplicationDate

Arrival Date

FWLArrivalDate

Cancellation Date

FWLCancellationDate

Issue Date

FWLIssueDate

Permit No

FWLPermitNumber

FWLFormulaId

FWLFormulaId

Current

FWLCurrent

Remarks

FWLRemarks


Entity Attribute EmployeeSysId of the Entity FWLProgression

Card of Attribute EmployeeSysId of the Entity FWLProgression

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity FWLProgression

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 FWLProgression

Card of Attribute Effective Date of the Entity FWLProgression

Name

Effective Date

Code

FWLEffectiveDate

Data Type

date

Mandatory

Yes


Description of Attribute Effective Date of the Entity FWLProgression

Shows the effective date of the Foreign Worker Levy. It also holds the primary key for the FWLProgression table.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Career Code of the Entity FWLProgression

Card of Attribute Career Code of the Entity FWLProgression

Name

Career Code

Code

FWLCareerId

Data Type

char(20)

Mandatory

No


Description of Attribute Career Code of the Entity FWLProgression

Shows the identity of the career for the foreign worker levy.
Example: FirstRecord / Transfer / Promotion / SalaryAdjust etc


Entity Attribute Expiry Date of the Entity FWLProgression

Card of Attribute Expiry Date of the Entity FWLProgression

Name

Expiry Date

Code

FWLExpiryDate

Data Type

date

Mandatory

No


Description of Attribute Expiry Date of the Entity FWLProgression

Stores the expiry date of the Foreign Worker Levy.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Application Date of the Entity FWLProgression

Card of Attribute Application Date of the Entity FWLProgression

Name

Application Date

Code

FWLApplicationDate

Data Type

date

Mandatory

No


Description of Attribute Application Date of the Entity FWLProgression

Shows the application date for the Foreign Worker Levy, i.e. the date of when the employee applied for the FWL.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Arrival Date of the Entity FWLProgression

Card of Attribute Arrival Date of the Entity FWLProgression

Name

Arrival Date

Code

FWLArrivalDate

Data Type

date

Mandatory

No


Description of Attribute Arrival Date of the Entity FWLProgression

Shows the arrival date of the FWL employee.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Cancellation Date of the Entity FWLProgression

Card of Attribute Cancellation Date of the Entity FWLProgression

Name

Cancellation Date

Code

FWLCancellationDate

Data Type

date

Mandatory

No


Description of Attribute Cancellation Date of the Entity FWLProgression

Shows the cancellation date of the FWL.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Issue Date of the Entity FWLProgression

Card of Attribute Issue Date of the Entity FWLProgression

Name

Issue Date

Code

FWLIssueDate

Data Type

date

Mandatory

No


Description of Attribute Issue Date of the Entity FWLProgression

Shows the date of issue of the FWL.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Permit No of the Entity FWLProgression

Card of Attribute Permit No of the Entity FWLProgression

Name

Permit No

Code

FWLPermitNumber

Data Type

char(30)

Mandatory

No


Description of Attribute Permit No of the Entity FWLProgression

The FWL permit number.


Entity Attribute FWLFormulaId of the Entity FWLProgression

Card of Attribute FWLFormulaId of the Entity FWLProgression

Name

FWLFormulaId

Code

FWLFormulaId

Data Type

char(20)

Mandatory

No


Description of Attribute FWLFormulaId of the Entity FWLProgression

Shows the identity of the formula for the FWL.


Entity Attribute Current of the Entity FWLProgression

Card of Attribute Current of the Entity FWLProgression

Name

Current

Code

FWLCurrent

Data Type

smallint

Mandatory

No


Description of Attribute Current of the Entity FWLProgression

Shows if the employee is currently employed in that company.


Entity Attribute Remarks of the Entity FWLProgression

Card of Attribute Remarks of the Entity FWLProgression

Name

Remarks

Code

FWLRemarks

Data Type

char(255)

Mandatory

No


Description of Attribute Remarks of the Entity FWLProgression

Stores any remarks about the Foreign Worker Levy progression.