More information

Importing Benefit Codes

The following tables show examples of data fields used in the Benefit Codes section of the MasterPR.DEF file:

Header

Table: tblPRBeneCode
Context Section: CONTEXT,BENEFITCODE,HEADER,HBENE
Field ID	Req'd	Field Length	Default Value	Notes
PR_BENE_CODE	Y	User Defined		Benefit Code ID
PR_BENE_STATUS	N	1	A	A (Active), I (Inactive), or D (Discontinued)
PR_BENE_TITLE	Y	User Defined		Benefit Code Title
PR_BENE_GLEXP_ CODE	Y	User Defined		Must be set up using Maintain>Chart of Accounts Codes.
PR_BENE_GLLIAB_ CODE	Y	User Defined		Must be set up using Maintain>Chart of Accounts Codes.
PR_BENE_ CHECKSTUB	N	1	1	0 = No; 1 = Yes
PR_BENE_W2_BOX	N	2		W-2 Box Number, if any
PR_BENE_W2_CODE	N	14		W-2 Box Code, if any
PR_BENE_CALC_ METHOD	N	2	FA	Valid Calculation Methods: FP, FH, FA, AT, or PT. See Table 3.
PR_BENE_AMOUNT	Y	Currency	0.0000	Required for FH or FA.
PR_BENE_PERCENT	Y	Single	000.0000	Required for FP. Enter 5% as 05 or 5.
PR_BENE_MAX_ PERC	N	8	000.0000	Maximum percentage allowed on timesheet for PT. Enter 5% as 05 or 5.
PR_BENE_YEAR_ MAX	N	Currency	999,999.99	Maximum annual benefit calculation. Required for all calculation methods.
PR_BENE_FIT	N	2		Increase subject earnings? 0 = No; 1 = Yes
PR_BENE_SS	N	2		Increase subject earnings? 0 = No; 1 = Yes
PR_BENE_MC	N	2		Increase subject earnings? 0 = No; 1 = Yes
PR_BENE_FUTA	N	2		Increase subject earnings? 0 = No; 1 = Yes
PR_BENE_SWT	N	2		Increase subject earnings? 0 = No; 1 = Yes
PR_BENE_SUTA	N	2		Increase subject earnings? 0 = No; 1 = Yes
PR_BENE_LWT	N	2		Increase subject earnings? 0 = No; 1 = Yes
PR_BENE_LOCAL_ ER	N	2		Increase subject earnings? 0 = No; 1 = Yes
PR_BENE_ALLOC_ METHOD	N	2	AE	Valid Distribution Methods: AE, CE, and DC. See Table 5.
PR_BENE_EARN_ DISTCODE	Y	1		Required if PR_BENE_ALLOC_METHOD is AE; Must be a valid code with a distribution type of B or P (Maintain>Payroll>Distribution Codes).
PR_BENE_DIST_ CODE	Y	User Defined		Required if using a distribution method of DC. Must be a valid code with a distribution type of "B" or "P" (Maintain>Payroll>Distribution Codes).

Detail

Table: tblPRBeneCode
Context Section: CONTEXT,BENEFITCODE,DETAIL,DBENE
Field ID	Req'd	Field Length	Default Value	Notes
PR_EC_CODE	Y	User Defined		Required if calculation method of FP or FH. Can have more than one earning code. Must be a valid code (Maintain>Payroll>Earning Codes).