This is version 1 2 3 4 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

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 2 otherwise, section 10.

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 2.

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