|
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 |
||
|
Reference |
||
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
Shows the identity of the formula. This is the primary key for the HRFormula table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Stores a description about the formula. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the category for the formula. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the sub category for the formula. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the type of the formula. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the formula is active or not, in a form of a checkbox. |
|
|
|