Entity TMSOvertime

Description of Entity TMSOvertime

This entity shows the overtime for the Time Management System. Includes the frequency and costing amount.


List of all Dependencies of the Entity TMSOvertime

Name

Code

Class Name

Relation_1646374

Relation_1646374

Reference

Relation_1646395

Relation_1646395

Reference


List of Attributes of the Entity TMSOvertime

Name

Code

Formula ID

FormulaId

Current OT Freq

CurrentOTFreq

Last OT Freq

LastOTFreq

BackPay OT Freq

BackPayOTFreq

Current Costing Amt

CurrentCostingAmt

Last OT Costing Amt

LastOTCostingAmt

BackPay OT Costing Amount

BackPayOTCostingAmt


Entity Attribute Formula ID of the Entity TMSOvertime

Card of Attribute Formula ID of the Entity TMSOvertime

Name

Formula ID

Code

FormulaId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Formula ID of the Entity TMSOvertime

Shows the formula on what leave / deduction / allowance etc, the employee has taken. This is the primary key for the Formula table.
Example: ANL (Annual leave) / Deduction of Sick leave / HOL (Paid Holiday)


Entity Attribute Current OT Freq of the Entity TMSOvertime

Card of Attribute Current OT Freq of the Entity TMSOvertime

Name

Current OT Freq

Code

CurrentOTFreq

Data Type

double

Mandatory

No


Description of Attribute Current OT Freq of the Entity TMSOvertime

Shows the current number of hours the employee can work overtime.


Entity Attribute Last OT Freq of the Entity TMSOvertime

Card of Attribute Last OT Freq of the Entity TMSOvertime

Name

Last OT Freq

Code

LastOTFreq

Data Type

double

Mandatory

No


Description of Attribute Last OT Freq of the Entity TMSOvertime

Shows the last number of hours the employee can work overtime.


Entity Attribute BackPay OT Freq of the Entity TMSOvertime

Card of Attribute BackPay OT Freq of the Entity TMSOvertime

Name

BackPay OT Freq

Code

BackPayOTFreq

Data Type

double

Mandatory

No


Description of Attribute BackPay OT Freq of the Entity TMSOvertime

Shows the number of back pay hours the employee has worked.


Entity Attribute Current Costing Amt of the Entity TMSOvertime

Card of Attribute Current Costing Amt of the Entity TMSOvertime

Name

Current Costing Amt

Code

CurrentCostingAmt

Data Type

double

Mandatory

No


Description of Attribute Current Costing Amt of the Entity TMSOvertime

Shows the current costing amount for the Time Management System.


Entity Attribute Last OT Costing Amt of the Entity TMSOvertime

Card of Attribute Last OT Costing Amt of the Entity TMSOvertime

Name

Last OT Costing Amt

Code

LastOTCostingAmt

Data Type

double

Mandatory

No


Description of Attribute Last OT Costing Amt of the Entity TMSOvertime

Shows the costing amount of the last overtime for the Time Management System.


Entity Attribute BackPay OT Costing Amount of the Entity TMSOvertime

Card of Attribute BackPay OT Costing Amount of the Entity TMSOvertime

Name

BackPay OT Costing Amount

Code

BackPayOTCostingAmt

Data Type

double

Mandatory

No


Description of Attribute BackPay OT Costing Amount of the Entity TMSOvertime

Shows the costing amount of the back pay for the overtime Time Management System.