DB - Database Field #
Database Fields allow the user to access a large amount of information about the employee from within a UserCalc. Database fields that may be read include, but are not limited to, common definitions (CM), employee master file information (HR), and payroll information (PR).If the Database (DB) type is used, a list of all the available Database fields will be accessible in the Operand (You may access this list by pressing ‘F9’ or by double clicking on the ‘Operand 1’ header). The user may select from this list, after which the program will return to the UserCalc form to continue.
- Statement
- If employees are in Group 56 then go to section 200 otherwise, section 100.
Line | CMD | OT | Operand 1 | OPER | OT | Operand2 | OT | Operand3 | If Goto | Else GoTo |
---|---|---|---|---|---|---|---|---|---|---|
00010 | IF | DB | DGR.GROUP_CODE | EQ | A | 56 | 00200 | 0100 |
- Statement
- Let the date variable be the Hire Date plus 3 months then go to section 2000.
Line | CMD | OT | Operand 1 | OPER | OT | Operand2 | OT | Operand3 | If Goto | Else GoTo |
---|---|---|---|---|---|---|---|---|---|---|
00010 | LET | V | PROB DATE | BD | DB | EEM.HIRE_DATE | A | +3M | 02000 |