Entity FormulaProperty

Description of Entity FormulaProperty

This Table contains the FormulaId for each Property.

Example:

KeyWordId      FormulaId
------------------      ---------------
Bonus Code      Bonus
Donation Code      CDAC


List of all Dependencies of the Entity FormulaProperty

Name

Code

Class Name

Relation_66177

Relation_66177

Reference

Ref_5167

Ref_5167

Reference


List of Attributes of the Entity FormulaProperty

Name

Code

KeyWord ID

KeyWordId

Formula ID

FormulaId


Entity Attribute KeyWord ID of the Entity FormulaProperty

Card of Attribute KeyWord ID of the Entity FormulaProperty

Name

KeyWord ID

Code

KeyWordId

Data Type

char(20)

Mandatory

Yes


Description of Attribute KeyWord ID of the Entity FormulaProperty

Shows the identity of the keyword. This also acts as a primary key for the KeyWord table.
Example: Allowance / Basic Rate / Decrement etc


Entity Attribute Formula ID of the Entity FormulaProperty

Card of Attribute Formula ID of the Entity FormulaProperty

Name

Formula ID

Code

FormulaId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Formula ID of the Entity FormulaProperty

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)