Entity HRFormulaRange

Description of Entity HRFormulaRange

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 HRFormulaRange

Name

Code

Class Name

Relation_274890

Relation_274890

Reference


List of Attributes of the Entity HRFormulaRange

Name

Code

HRFormulaRangeId

HRFormulaRangeId

Maximum

Maximum

Minimum

Minimum

Formula

Formula

Constant1

Constant1

Constant2

Constant2

Constant3

Constant3

Constant4

Constant4

Constant5

Constant5

Selected Keywords K1

Keywords1

Selected Keywords K2

Keywords2

Selected Keywords K3

Keywords3

Selected Keywords K4

Keywords4

Selected Keywords K5

Keywords5

Selected Keywords K6

Keywords6

Selected Keywords K7

Keywords7

Selected Keywords K8

Keywords8

Selected Keywords K9

Keywords9

Selected Keywords K10

Keywords10

U1

UserDef1

U2

UserDef2

U3

UserDef3

U4

UserDef4

U5

UserDef5


Entity Attribute HRFormulaRangeId of the Entity HRFormulaRange

Card of Attribute HRFormulaRangeId of the Entity HRFormulaRange

Name

HRFormulaRangeId

Code

HRFormulaRangeId

Data Type

integer

Mandatory

Yes


Description of Attribute HRFormulaRangeId of the Entity HRFormulaRange

Shows the identity for the formula range. This also acts as the primary key for the HRFormulaRange table.


Entity Attribute Maximum of the Entity HRFormulaRange

Card of Attribute Maximum of the Entity HRFormulaRange

Name

Maximum

Code

Maximum

Data Type

double

Mandatory

No


Description of Attribute Maximum of the Entity HRFormulaRange

Shows the maximum range.


Entity Attribute Minimum of the Entity HRFormulaRange

Card of Attribute Minimum of the Entity HRFormulaRange

Name

Minimum

Code

Minimum

Data Type

double

Mandatory

No


Description of Attribute Minimum of the Entity HRFormulaRange

Shows the minimum range.


Entity Attribute Formula of the Entity HRFormulaRange

Card of Attribute Formula of the Entity HRFormulaRange

Name

Formula

Code

Formula

Data Type

char(255)

Mandatory

No


Description of Attribute Formula of the Entity HRFormulaRange

Shows the formula for the entity.


Entity Attribute Constant1 of the Entity HRFormulaRange

Card of Attribute Constant1 of the Entity HRFormulaRange

Name

Constant1

Code

Constant1

Data Type

double

Mandatory

No


Description of Attribute Constant1 of the Entity HRFormulaRange

Shows a first constant for the record.


Entity Attribute Constant2 of the Entity HRFormulaRange

Card of Attribute Constant2 of the Entity HRFormulaRange

Name

Constant2

Code

Constant2

Data Type

double

Mandatory

No


Description of Attribute Constant2 of the Entity HRFormulaRange

Shows a second constant for the record.


Entity Attribute Constant3 of the Entity HRFormulaRange

Card of Attribute Constant3 of the Entity HRFormulaRange

Name

Constant3

Code

Constant3

Data Type

double

Mandatory

No


Description of Attribute Constant3 of the Entity HRFormulaRange

Shows a third constant for the record.


Entity Attribute Constant4 of the Entity HRFormulaRange

Card of Attribute Constant4 of the Entity HRFormulaRange

Name

Constant4

Code

Constant4

Data Type

double

Mandatory

No


Description of Attribute Constant4 of the Entity HRFormulaRange

Shows a forth constant for the record.


Entity Attribute Constant5 of the Entity HRFormulaRange

Card of Attribute Constant5 of the Entity HRFormulaRange

Name

Constant5

Code

Constant5

Data Type

double

Mandatory

No


Description of Attribute Constant5 of the Entity HRFormulaRange

Shows a fifth constant for the record.


Entity Attribute Selected Keywords K1 of the Entity HRFormulaRange

Card of Attribute Selected Keywords K1 of the Entity HRFormulaRange

Name

Selected Keywords K1

Code

Keywords1

Data Type

char(20)

Mandatory

No


Description of Attribute Selected Keywords K1 of the Entity HRFormulaRange

Show the first selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc


Entity Attribute Selected Keywords K2 of the Entity HRFormulaRange

Card of Attribute Selected Keywords K2 of the Entity HRFormulaRange

Name

Selected Keywords K2

Code

Keywords2

Data Type

char(20)

Mandatory

No


Description of Attribute Selected Keywords K2 of the Entity HRFormulaRange

Show the second selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc


Entity Attribute Selected Keywords K3 of the Entity HRFormulaRange

Card of Attribute Selected Keywords K3 of the Entity HRFormulaRange

Name

Selected Keywords K3

Code

Keywords3

Data Type

char(20)

Mandatory

No


Description of Attribute Selected Keywords K3 of the Entity HRFormulaRange

Show the third selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc


Entity Attribute Selected Keywords K4 of the Entity HRFormulaRange

Card of Attribute Selected Keywords K4 of the Entity HRFormulaRange

Name

Selected Keywords K4

Code

Keywords4

Data Type

char(20)

Mandatory

No


Description of Attribute Selected Keywords K4 of the Entity HRFormulaRange

Show the forth selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc


Entity Attribute Selected Keywords K5 of the Entity HRFormulaRange

Card of Attribute Selected Keywords K5 of the Entity HRFormulaRange

Name

Selected Keywords K5

Code

Keywords5

Data Type

char(20)

Mandatory

No


Description of Attribute Selected Keywords K5 of the Entity HRFormulaRange

Show the fifth selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc


Entity Attribute Selected Keywords K6 of the Entity HRFormulaRange

Card of Attribute Selected Keywords K6 of the Entity HRFormulaRange

Name

Selected Keywords K6

Code

Keywords6

Data Type

char(20)

Mandatory

No


Description of Attribute Selected Keywords K6 of the Entity HRFormulaRange

Show the sixth selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc


Entity Attribute Selected Keywords K7 of the Entity HRFormulaRange

Card of Attribute Selected Keywords K7 of the Entity HRFormulaRange

Name

Selected Keywords K7

Code

Keywords7

Data Type

char(20)

Mandatory

No


Description of Attribute Selected Keywords K7 of the Entity HRFormulaRange

Show the seventh selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc


Entity Attribute Selected Keywords K8 of the Entity HRFormulaRange

Card of Attribute Selected Keywords K8 of the Entity HRFormulaRange

Name

Selected Keywords K8

Code

Keywords8

Data Type

char(20)

Mandatory

No


Description of Attribute Selected Keywords K8 of the Entity HRFormulaRange

Show the eighth selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc


Entity Attribute Selected Keywords K9 of the Entity HRFormulaRange

Card of Attribute Selected Keywords K9 of the Entity HRFormulaRange

Name

Selected Keywords K9

Code

Keywords9

Data Type

char(20)

Mandatory

No


Description of Attribute Selected Keywords K9 of the Entity HRFormulaRange

Show the ninth selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc


Entity Attribute Selected Keywords K10 of the Entity HRFormulaRange

Card of Attribute Selected Keywords K10 of the Entity HRFormulaRange

Name

Selected Keywords K10

Code

Keywords10

Data Type

char(20)

Mandatory

No


Description of Attribute Selected Keywords K10 of the Entity HRFormulaRange

Show the tenth selected keywords for generating the formula. The commonly used details are available here.
Example: Basic Wage / Age / Employee Working Hours etc


Entity Attribute U1 of the Entity HRFormulaRange

Card of Attribute U1 of the Entity HRFormulaRange

Name

U1

Code

UserDef1

Data Type

char(20)

Mandatory

No


Description of Attribute U1 of the Entity HRFormulaRange

Shows the first user defined parameter. They are used in the setting of their own defined formula for a specific pay item. A maximum of 5 user defined fields are allowed at any one time for each formula to each pay item code.


Entity Attribute U2 of the Entity HRFormulaRange

Card of Attribute U2 of the Entity HRFormulaRange

Name

U2

Code

UserDef2

Data Type

char(20)

Mandatory

No


Description of Attribute U2 of the Entity HRFormulaRange

Shows the second user defined parameter. They are used in the setting of their own defined formula for a specific pay item. A maximum of 5 user defined fields are allowed at any one time for each formula to each pay item code.


Entity Attribute U3 of the Entity HRFormulaRange

Card of Attribute U3 of the Entity HRFormulaRange

Name

U3

Code

UserDef3

Data Type

char(20)

Mandatory

No


Description of Attribute U3 of the Entity HRFormulaRange

Shows the third user defined parameter. They are used in the setting of their own defined formula for a specific pay item. A maximum of 5 user defined fields are allowed at any one time for each formula to each pay item code.


Entity Attribute U4 of the Entity HRFormulaRange

Card of Attribute U4 of the Entity HRFormulaRange

Name

U4

Code

UserDef4

Data Type

char(20)

Mandatory

No


Description of Attribute U4 of the Entity HRFormulaRange

Shows the forth user defined parameter. They are used in the setting of their own defined formula for a specific pay item. A maximum of 5 user defined fields are allowed at any one time for each formula to each pay item code.


Entity Attribute U5 of the Entity HRFormulaRange

Card of Attribute U5 of the Entity HRFormulaRange

Name

U5

Code

UserDef5

Data Type

char(20)

Mandatory

No


Description of Attribute U5 of the Entity HRFormulaRange

Shows the fifth user defined parameter. They are used in the setting of their own defined formula for a specific pay item. A maximum of 5 user defined fields are allowed at any one time for each formula to each pay item code.