Entity MalBIKRecord

Description of Entity MalBIKRecord

This entity is for the Malaysia Payroll.


List of all Dependencies of the Entity MalBIKRecord

Name

Code

Class Name

Relationship_737

Relationship_737

Reference

Relationship_741

Relationship_741

Reference


List of Attributes of the Entity MalBIKRecord

Name

Code

EmployeeSysId

EmployeeSysId

MalBIKRecSGSPGenId

MalBIKRecSGSPGenId

Year

PayRecYear

Period

PayRecPeriod

Sub Period

PayRecSubPeriod

Pay Rec ID

PayRecID

BIK Amount

BIKAmount

BIKRecRecurSysId

BIKRecRecurSysId


Entity Attribute EmployeeSysId of the Entity MalBIKRecord

Card of Attribute EmployeeSysId of the Entity MalBIKRecord

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

No


Description of Attribute EmployeeSysId of the Entity MalBIKRecord

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


Entity Attribute MalBIKRecSGSPGenId of the Entity MalBIKRecord

Card of Attribute MalBIKRecSGSPGenId of the Entity MalBIKRecord

Name

MalBIKRecSGSPGenId

Code

MalBIKRecSGSPGenId

Data Type

char(30)

Mandatory

Yes


Description of Attribute MalBIKRecSGSPGenId of the Entity MalBIKRecord

Shows the generating identity of the Malaysia's Benefits-in-Kind (BIK) record. This is the primary key for the MalBIKRecord table.
Example: A1 / A66 / A110


Entity Attribute Year of the Entity MalBIKRecord

Card of Attribute Year of the Entity MalBIKRecord

Name

Year

Code

PayRecYear

Data Type

integer

Mandatory

No


Description of Attribute Year of the Entity MalBIKRecord

Shows the year for the pay record.
Example: 2012


Entity Attribute Period of the Entity MalBIKRecord

Card of Attribute Period of the Entity MalBIKRecord

Name

Period

Code

PayRecPeriod

Data Type

integer

Mandatory

No


Description of Attribute Period of the Entity MalBIKRecord

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


Entity Attribute Sub Period of the Entity MalBIKRecord

Card of Attribute Sub Period of the Entity MalBIKRecord

Name

Sub Period

Code

PayRecSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute Sub Period of the Entity MalBIKRecord

Holds the sub period for the pay record.

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 Pay Rec ID of the Entity MalBIKRecord

Card of Attribute Pay Rec ID of the Entity MalBIKRecord

Name

Pay Rec ID

Code

PayRecID

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Rec ID of the Entity MalBIKRecord

Stores the identity for the pay record.
Example: Normal / Normal Time Sheet


Entity Attribute BIK Amount of the Entity MalBIKRecord

Card of Attribute BIK Amount of the Entity MalBIKRecord

Name

BIK Amount

Code

BIKAmount

Data Type

double

Mandatory

No


Description of Attribute BIK Amount of the Entity MalBIKRecord

Shows the Benefits-in-Kind (BIK) amount.

BIKs are benefits not convertible into money, even though they have monetary value. The phrase "not convertible into money" means that when the benefit is given to the employee, it cannot be exchanged for cash due to the nature of the benefit itself.


Entity Attribute BIKRecRecurSysId of the Entity MalBIKRecord

Card of Attribute BIKRecRecurSysId of the Entity MalBIKRecord

Name

BIKRecRecurSysId

Code

BIKRecRecurSysId

Data Type

integer

Mandatory

No


Description of Attribute BIKRecRecurSysId of the Entity MalBIKRecord

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