Entity Formula

Description of Entity Formula

To create formula based elements. The definition of these elements varies and depends on where you have launched the Formula Generator from. The Formula Generator may appear slightly different as not all its features are applicable to all modules in Sage EasyPay, however the overall concept of creating and modifying a formula is the same. The advantage of using formula based elements is the flexibility as you can use pre-defined system variables alongside variables of your own definition. The formula is similar to algebraic expressions. Each expression is made up of variables and operators and/or values.


List of all Dependencies of the Entity Formula

Name

Code

Class Name

Relation_46400

Relation_46400

Reference

Ref_5170

Ref_5170

Reference

Ref_5167

Ref_5167

Reference

Ref_5161

Ref_5161

Reference

Ref_5158

Ref_5158

Reference

Relation_100532

Relation_100532

Reference

Relation_648504

Relation_648504

Reference

Relation_1128284

Relation_1128284

Reference

Relation_1646393

Relation_1646393

Reference

Relation_1646394

Relation_1646394

Reference

Relation_1646395

Relation_1646395

Reference


List of Attributes of the Entity Formula

Name

Code

Formula ID

FormulaId

Active

FormulaActive

Preprocess

FormulaPreprocess

Recurring

FormulaRecurring

Formula Category

FormulaCategory

Formula Sub Category

FormulaSubCategory

Formula Type

FormulaType

Formula Range Basis

FormulaRangeBasis

Description

FormulaDesc

Formula Exchange Rate ID

FormulaExRateId

Formula Stage

FormulaStage

Formula Rank

FormulaRank


Entity Attribute Formula ID of the Entity Formula

Card of Attribute Formula ID of the Entity Formula

Name

Formula ID

Code

FormulaId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Formula ID of the Entity Formula

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 Active of the Entity Formula

Card of Attribute Active of the Entity Formula

Name

Active

Code

FormulaActive

Data Type

smallint

Mandatory

No


Description of Attribute Active of the Entity Formula

Shows if the formula is working, then it will display records having this attribute as true. This is to enable easy selection and to prevent any wrong calculations from happening.
Example: Active = "1"


Entity Attribute Preprocess of the Entity Formula

Card of Attribute Preprocess of the Entity Formula

Name

Preprocess

Code

FormulaPreprocess

Data Type

smallint

Mandatory

No


Description of Attribute Preprocess of the Entity Formula

Shows the preprocessed formula.


Entity Attribute Recurring of the Entity Formula

Card of Attribute Recurring of the Entity Formula

Name

Recurring

Code

FormulaRecurring

Data Type

smallint

Mandatory

No


Description of Attribute Recurring of the Entity Formula

Shows the recurring formula. Otherwise, "0".


Entity Attribute Formula Category of the Entity Formula

Card of Attribute Formula Category of the Entity Formula

Name

Formula Category

Code

FormulaCategory

Data Type

char(20)

Mandatory

No


Description of Attribute Formula Category of the Entity Formula

States which category the formula falls under.
Example: OT / Shift / FWL


Entity Attribute Formula Sub Category of the Entity Formula

Card of Attribute Formula Sub Category of the Entity Formula

Name

Formula Sub Category

Code

FormulaSubCategory

Data Type

char(20)

Mandatory

No


Description of Attribute Formula Sub Category of the Entity Formula

This is the sub category for FormulaCategory.
Example: OTHourRate / ShiftFixedRate / FWLCalDay


Entity Attribute Formula Type of the Entity Formula

Card of Attribute Formula Type of the Entity Formula

Name

Formula Type

Code

FormulaType

Data Type

char(20)

Mandatory

No


Description of Attribute Formula Type of the Entity Formula

Stores what type of formula being used.
Example:
- Formula: The amount depends on the formula you have created
- Free: The amount varies with each payroll run
- Tabulated: The amount varies with each range based criteria
- Fixed: The amount is a constant amount


Entity Attribute Formula Range Basis of the Entity Formula

Card of Attribute Formula Range Basis of the Entity Formula

Name

Formula Range Basis

Code

FormulaRangeBasis

Data Type

char(20)

Mandatory

No


Description of Attribute Formula Range Basis of the Entity Formula

Holds the range basis for the formula. It is used for Maximum and Minimum in the FormulaRange Entity.
Example: SDF Wage for SDF Formula / CPF Wage for CDAC fund / CPFContriWage


Entity Attribute Description of the Entity Formula

Card of Attribute Description of the Entity Formula

Name

Description

Code

FormulaDesc

Data Type

char(255)

Mandatory

No


Description of Attribute Description of the Entity Formula

Shows the full description of the formula.
Example: Paid Holiday / Paid Maternity Leave / Medical Claims etc


Entity Attribute Formula Exchange Rate ID of the Entity Formula

Card of Attribute Formula Exchange Rate ID of the Entity Formula

Name

Formula Exchange Rate ID

Code

FormulaExRateId

Data Type

char(20)

Mandatory

No


Description of Attribute Formula Exchange Rate ID of the Entity Formula

Shows the identity of the exchange rate for the formula.


Entity Attribute Formula Stage of the Entity Formula

Card of Attribute Formula Stage of the Entity Formula

Name

Formula Stage

Code

FormulaStage

Data Type

integer

Mandatory

No


Description of Attribute Formula Stage of the Entity Formula

Shows which stage the formula is at.


Entity Attribute Formula Rank of the Entity Formula

Card of Attribute Formula Rank of the Entity Formula

Name

Formula Rank

Code

FormulaRank

Data Type

integer

Mandatory

No


Description of Attribute Formula Rank of the Entity Formula

Shows the rank of the formula.