|
This table will contain the different ranges for each FormulaId and each range can has its own set of formula. |
|
Name |
Code |
Class Name |
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
Yes |
|
Shows the identity for the formula range. This also acts as the primary key for the HRFormulaRange table. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the maximum range. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the minimum range. |
|
Name |
|
|
Code |
|
|
Data Type |
char(255) |
|
Mandatory |
No |
|
Shows the formula for the entity. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows a first constant for the record. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows a second constant for the record. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows a third constant for the record. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows a forth constant for the record. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows a fifth constant for the record. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Show the first selected keywords for generating the formula. The commonly used details are available here. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Show the second selected keywords for generating the formula. The commonly used details are available here. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Show the third selected keywords for generating the formula. The commonly used details are available here. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Show the forth selected keywords for generating the formula. The commonly used details are available here. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Show the fifth selected keywords for generating the formula. The commonly used details are available here. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Show the sixth selected keywords for generating the formula. The commonly used details are available here. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Show the seventh selected keywords for generating the formula. The commonly used details are available here. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Show the eighth selected keywords for generating the formula. The commonly used details are available here. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Show the ninth selected keywords for generating the formula. The commonly used details are available here. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Show the tenth selected keywords for generating the formula. The commonly used details are available here. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
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. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
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. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
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. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
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. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
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. |
|
|
|