GetDBAsForPlanorPlanOption

Get Benefit DBAs for Plan or Plan Option

Minor Business Rule

Object Name: N0800063

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The NER retrieves the description of the plan or plan option and the four dba codes associated with
the plan or plan option.

Setup Notes and Prerequisites

Special Logic

Technical Specification

Retrieve Plan record from F08320, fetching the plan description, and the four dba codes (FDBA, SDBA,
PDDP, PDCP)

If Plan option is not blank,

  Retrieve the plan option record from F083202, fetching the
  option description and the four option dba codes (FDBA,
  SDBA, PDDP, PDCP).

  // Employee deduction dba//
  If Option FDBA is not equal to Zeros
     BF mnEmployeeDbaId = Option FDBA
  End If

  // Employer Credit dba//
  If Option SDBA is not equal to Zeros
    BF mnDbaEmployerId = Option SDBA
  End If

  //Employee point dba//
  If Option PDDP is not equal to Zeros
    BF mnPayrollDedPoints = Option PDDP
  End If

  //Employer point dba//
  If Option PDCP is not equal to Zeros
    BF mnPayrollCreditPoints = Option PDCP
  End If

End If  //End of plan option <> Blank//

^

Data Structure

DN0800063 - Get Benefit DBAs for Plan or Plan Option

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szPlanId	PLAN	char	REQ	INPUT
An abbreviation or number that identifies a specific employee benefit. Examples are: o Employee Health Insurance o Accidental Death and Dismemberment o Health Club Expense Reimbursement o Employee Stock Appreciation Rights A benefit plan typically is associated with a deduction, benefit, or accrual. For example, a medical plan is a benefit that might also require a deduction to withhold premiums from an employee's pay.
szPlanAdditionalOption	AOPT	char	REQ	INPUT
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table (F083202). Note: Additional options must have the same provider, policy number, and enrollment and eligibility rules as the benefit plan to which they are associated.
mnEmployeeDbaId	FDBA	MATH_NUMERIC	OPT	OUTPUT
The DBA defined in the Payroll Transactions Constants table (F069116) that is used to calculate the dollar amount that the employee contributes by enrolling in the plan. In most cases, this DBA is defined to deduct pay from the enrolled employee's check.
mnDbaEmployerId	SDBA	MATH_NUMERIC	OPT	OUTPUT
The DBA defined in the Payroll Transactions Constants table (F069116) that the system uses to calculate the dollar amount that the employer contributes to the employee enrolled in the plan. In most cases, this DBA is defined as a benefit to add pay to the enrolled employee's check.
mnPayrollDedPoints	PDDP	MATH_NUMERIC	OPT	OUTPUT
The DBA defined in the Payroll Transactions Constants file (F069116) that is used to calculate the points amount that the employee contributes by enrolling in the plan in a flexible spending environment. DBAs used for points in a benefit plan or option must meet two requirements: 1. The DBA must have blanks in the specification for Gross Effect and Net Effect (see data items PAYG and PAYN) so that the use of (non-dollar) points does not add or subtract dollars from employee pay. 2. The DBA must have an M in the specification for Journal Entry (Y/N/M) (see data item NMTH) so that the use of (non-dollar) points does not affect the G/L system.
mnPayrollCreditPoints	PDCP	MATH_NUMERIC	OPT	OUTPUT
The DBA defined in the Payroll Transactions Constants table (F069116) that will be used to calculate the points amount that the employer contributes to an employee enrolled in a flexible spending environment. DBAs used for points in a benefit plan or option must meet two requirements: 1. The DBA must have blanks in the specification for gross effect and net effect (see data items PAYG and PAYN) so that the use of (non-dollar) points does not add or subtract dollars from employee pay. 2. The DBA must have an M in the specification for Journal Entry (Y/N/M) (see data item NMTH) so that the use of (non-dollar) points does not affect the G/L system.
szPlanDescription	DL01	char	OPT	OUTPUT
A user defined name or remark.
szPlanOptionDescription	DL01	char	OPT	OUTPUT
A user defined name or remark.

Related Functions

None

Related Tables

None