Entity HRFormula

Description of Entity HRFormula

This table will contain the different ranges for each FormulaId and each range can has its own set of formula.

C1 - C5 are the constant
K1 - K10 are the keywords where the values will be supplied by the system.
U1 - U5 are the userdefined keywords where the user will supply the values.


List of all Dependencies of the Entity HRFormula

Name

Code

Class Name

Relation_284437

Relation_284437

Reference

Relation_274890

Relation_274890

Reference

Relation_271698

Relation_271698

Reference

Relation_271690

Relation_271690

Reference


List of Attributes of the Entity HRFormula

Name

Code

Formula ID

HRFormulaId

Description

HRFormulaDesc

HRFormulaCategory

HRFormulaCategory

HRFormulaSubCategory

HRFormulaSubCategory

HRFormulaType

HRFormulaType

HRFormulaActive

HRFormulaActive


Entity Attribute Formula ID of the Entity HRFormula

Card of Attribute Formula ID of the Entity HRFormula

Name

Formula ID

Code

HRFormulaId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Formula ID of the Entity HRFormula

Shows the identity of the formula. This is the primary key for the HRFormula table.
Example: SectionRatio / WtAverage etc


Entity Attribute Description of the Entity HRFormula

Card of Attribute Description of the Entity HRFormula

Name

Description

Code

HRFormulaDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity HRFormula

Stores a description about the formula.


Entity Attribute HRFormulaCategory of the Entity HRFormula

Card of Attribute HRFormulaCategory of the Entity HRFormula

Name

HRFormulaCategory

Code

HRFormulaCategory

Data Type

char(20)

Mandatory

No


Description of Attribute HRFormulaCategory of the Entity HRFormula

Shows the category for the formula.
Example: FormDesigner


Entity Attribute HRFormulaSubCategory of the Entity HRFormula

Card of Attribute HRFormulaSubCategory of the Entity HRFormula

Name

HRFormulaSubCategory

Code

HRFormulaSubCategory

Data Type

char(20)

Mandatory

No


Description of Attribute HRFormulaSubCategory of the Entity HRFormula

Shows the sub category for the formula.
Example: Section / Weight


Entity Attribute HRFormulaType of the Entity HRFormula

Card of Attribute HRFormulaType of the Entity HRFormula

Name

HRFormulaType

Code

HRFormulaType

Data Type

char(20)

Mandatory

No


Description of Attribute HRFormulaType of the Entity HRFormula

Shows the type of the formula.
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 HRFormulaActive of the Entity HRFormula

Card of Attribute HRFormulaActive of the Entity HRFormula

Name

HRFormulaActive

Code

HRFormulaActive

Data Type

smallint

Mandatory

No


Description of Attribute HRFormulaActive of the Entity HRFormula

Indicates if the formula is active or not, in a form of a checkbox.