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

---

Notes #

Click to create a new notes page