Entity CasRecord

Description of Entity CasRecord

This entity is for the initial configuration of Casual Pay. The basis allows you to set an overall grouping of casual workers. It affects reporting as well. Basis is the key determining factor for the distribution of cost to the various cost centres.


List of all Dependencies of the Entity CasRecord

Name

Code

Class Name

Relation_1409414

Relation_1409414

Reference

Relation_1539834

Relation_1539834

Reference

Relation_1403559

Relation_1403559

Reference

Relation_1409413

Relation_1409413

Reference


List of Attributes of the Entity CasRecord

Name

Code

EmployeeSysId

EmployeeSysId

CasualSGSPGenId

CasualSGSPGenId

Casual Working Date

CasualWorkingDate

Casual Payroll Date

CasualPayrollDate

Year

PayRecYear

Period

PayRecPeriod

Sub Period

PayRecSubPeriod

Reference No

RefNo

Casual Record Basis

CasualRecBasis

Hour Rate

HourRate

No Of Hour

NoOfHour

Remarks

Remarks

Daily Wage

DailyWage

Total Daily Wage

TotalDailyWage

Current Ordinary Wage

CurOrdinaryWage

Current Additional Wage

CurAdditionalWage

Non CPF Wage

NonCPFWage

Casual Payment

CasualPayment


Entity Attribute EmployeeSysId of the Entity CasRecord

Card of Attribute EmployeeSysId of the Entity CasRecord

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity CasRecord

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


Entity Attribute CasualSGSPGenId of the Entity CasRecord

Card of Attribute CasualSGSPGenId of the Entity CasRecord

Name

CasualSGSPGenId

Code

CasualSGSPGenId

Data Type

char(30)

Mandatory

Yes


Description of Attribute CasualSGSPGenId of the Entity CasRecord

Shows the generating identity of the casual record. This is the primary key for the CasRecord table.


Entity Attribute Casual Working Date of the Entity CasRecord

Card of Attribute Casual Working Date of the Entity CasRecord

Name

Casual Working Date

Code

CasualWorkingDate

Data Type

date

Mandatory

No


Description of Attribute Casual Working Date of the Entity CasRecord

Shows the casual working date.
It is in the format: DD-MM-YYYY.


Entity Attribute Casual Payroll Date of the Entity CasRecord

Card of Attribute Casual Payroll Date of the Entity CasRecord

Name

Casual Payroll Date

Code

CasualPayrollDate

Data Type

date

Mandatory

No


Description of Attribute Casual Payroll Date of the Entity CasRecord

Shows the casual payroll date.
It is in the format: DD-MM-YYYY.


Entity Attribute Year of the Entity CasRecord

Card of Attribute Year of the Entity CasRecord

Name

Year

Code

PayRecYear

Data Type

integer

Mandatory

No


Description of Attribute Year of the Entity CasRecord

Shows the year for the pay record.
Example: 2012


Entity Attribute Period of the Entity CasRecord

Card of Attribute Period of the Entity CasRecord

Name

Period

Code

PayRecPeriod

Data Type

integer

Mandatory

No


Description of Attribute Period of the Entity CasRecord

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


Entity Attribute Sub Period of the Entity CasRecord

Card of Attribute Sub Period of the Entity CasRecord

Name

Sub Period

Code

PayRecSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute Sub Period of the Entity CasRecord

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 Reference No of the Entity CasRecord

Card of Attribute Reference No of the Entity CasRecord

Name

Reference No

Code

RefNo

Data Type

char(50)

Mandatory

No


Description of Attribute Reference No of the Entity CasRecord

Shows the reference number for the casual record.


Entity Attribute Casual Record Basis of the Entity CasRecord

Card of Attribute Casual Record Basis of the Entity CasRecord

Name

Casual Record Basis

Code

CasualRecBasis

Data Type

char(20)

Mandatory

No


Description of Attribute Casual Record Basis of the Entity CasRecord

Shows the basis of the casual record.


Entity Attribute Hour Rate of the Entity CasRecord

Card of Attribute Hour Rate of the Entity CasRecord

Name

Hour Rate

Code

HourRate

Data Type

double

Mandatory

No


Description of Attribute Hour Rate of the Entity CasRecord

States the rate for an hour.


Entity Attribute No Of Hour of the Entity CasRecord

Card of Attribute No Of Hour of the Entity CasRecord

Name

No Of Hour

Code

NoOfHour

Data Type

double

Mandatory

No


Description of Attribute No Of Hour of the Entity CasRecord

States the number of hours.


Entity Attribute Remarks of the Entity CasRecord

Card of Attribute Remarks of the Entity CasRecord

Name

Remarks

Code

Remarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity CasRecord

Store remarks.


Entity Attribute Daily Wage of the Entity CasRecord

Card of Attribute Daily Wage of the Entity CasRecord

Name

Daily Wage

Code

DailyWage

Data Type

double

Mandatory

No


Description of Attribute Daily Wage of the Entity CasRecord

Shows the daily wage of the employee.


Entity Attribute Total Daily Wage of the Entity CasRecord

Card of Attribute Total Daily Wage of the Entity CasRecord

Name

Total Daily Wage

Code

TotalDailyWage

Data Type

double

Mandatory

No


Description of Attribute Total Daily Wage of the Entity CasRecord

Shows the total daily wage of the employee.


Entity Attribute Current Ordinary Wage of the Entity CasRecord

Card of Attribute Current Ordinary Wage of the Entity CasRecord

Name

Current Ordinary Wage

Code

CurOrdinaryWage

Data Type

double

Mandatory

No


Description of Attribute Current Ordinary Wage of the Entity CasRecord

Shows the current ordinary wage. These wages are due pertaining to the employee's employment in that month.


Entity Attribute Current Additional Wage of the Entity CasRecord

Card of Attribute Current Additional Wage of the Entity CasRecord

Name

Current Additional Wage

Code

CurAdditionalWage

Data Type

double

Mandatory

No


Description of Attribute Current Additional Wage of the Entity CasRecord

Shows the current additional wage. These wages are not due so employees and employers must make CPF contributions based on these wages earned by the employee.


Entity Attribute Non CPF Wage of the Entity CasRecord

Card of Attribute Non CPF Wage of the Entity CasRecord

Name

Non CPF Wage

Code

NonCPFWage

Data Type

double

Mandatory

No


Description of Attribute Non CPF Wage of the Entity CasRecord

Shows the wage which excludes CPF.


Entity Attribute Casual Payment of the Entity CasRecord

Card of Attribute Casual Payment of the Entity CasRecord

Name

Casual Payment

Code

CasualPayment

Data Type

smallint

Mandatory

No


Description of Attribute Casual Payment of the Entity CasRecord

Shows if the employer makes a casual payment to the employee.