DeletePlanAndOptionDBARecords

F08330 Transaction Business Function

Master Business Function

Object Name: N0800044

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this NER is to delete all DBA information for a given Address Number, DBA, and Begin
Date.

Setup Notes and Prerequisites
This NER is designed to be called from other NERs in N0800044 and is not designed to be called from
any other application or NER.

Special Logic

Technical Specifications
Fetch the DBAs and Options for the given Plan ID and Plan Additional Option from F083202.

If this fetch is successful then set cOptionFlag = "1"
End If
If cOptionFlag is equal to Or cOptionFlag is equal to "1"And cOption (From F083202) is
not equal to "3" then

If passed in DBA is not equal to then

Delete f06106 with keys Address Number, Passed in DBA ID, and DBA Begin Date

End If

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	OPT	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
szPlanId	PLAN	char	OPT	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	OPT	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.
jdDateDbaBegins	DTDB	JDEDATE	OPT	INPUT
The beginning date on the employee's DBA instruction record (F06106) for this enrollment. In most cases, this is the same as the beginning effective date of the enrollment. However, it can be later than the beginning effective date if the enrollment is changed retroactively. Only active enrollment records have a value in this field since they are the only enrollment records that result in payroll deductions, benefits, or accruals. Active records have a beginning status that starts with A.
jdDateEffectiveRates	EFT	JDEDATE	OPT	INPUT
The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnEmployeeDbaId	FDBA	MATH_NUMERIC	OPT	INPUT
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	INPUT
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	INPUT
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	INPUT
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.
mnEmployeeDbaIdOption	FDBA	MATH_NUMERIC	OPT	INPUT
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.
mnDbaEmployerIdOption	SDBA	MATH_NUMERIC	OPT	INPUT
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.
mnPayrollDedPointsOption	PDDP	MATH_NUMERIC	OPT	INPUT
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.
mnPayrollCreditPointsOption	PDCP	MATH_NUMERIC	OPT	INPUT
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.

End If
If cOptionFlag is equal to "1" And cOption (From F083202) is not equal
to "1" And DBA ID (From F083202) is not equal to   then
Delete f06106 with keys Address Number, DBA ID (From F083202), and DBA Begin Date
End If

This code repeats four times using the Employee Dollar DBA and Option,
Employer Dollar DBA and Option, Employee Points DBA and Option, (Not Supported in B732), and Employer
Points DBA and Option. (Not Supported in B732).

Options are not used in B733.

Data Structure

D0800044H - Delete Plan and Option DBA Record

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnAddressNumber AN8 MATH_NUMERIC OPT INPUT

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

szPlanId PLAN char OPT 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 OPT 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.

jdDateDbaBegins DTDB JDEDATE OPT INPUT

The beginning date on the employee's DBA instruction record (F06106) for this enrollment. In most cases, this is the same as the beginning
effective date of the enrollment. However, it can be later than the beginning effective date if the enrollment is changed retroactively. Only
active enrollment records have a value in this field since they are the only enrollment records that result in payroll deductions, benefits, or
accruals. Active records have a beginning status that starts with A.

jdDateEffectiveRates EFT JDEDATE OPT INPUT

The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost
effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.

mnEmployeeDbaId FDBA MATH_NUMERIC OPT INPUT

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 INPUT

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 INPUT

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 INPUT

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.

mnEmployeeDbaIdOption FDBA MATH_NUMERIC OPT INPUT

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.

mnDbaEmployerIdOption SDBA MATH_NUMERIC OPT INPUT

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.

mnPayrollDedPointsOption PDDP MATH_NUMERIC OPT INPUT

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.

mnPayrollCreditPointsOption PDCP MATH_NUMERIC OPT INPUT

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.

Related Functions

None

Related Tables

None

EndDate401kPlan
EndDate401kPlan

F08330 Transaction Business Function

Master Business Function

Object Name: N0800044

Parent DLL: CHRM

Location: Client/Server

Language: NER

^

Data Structure

D0800044I - End Date 401K Plan

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnAddressNumber AN8 MATH_NUMERIC REQ INPUT

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

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.

jdDateEffectiveRates EFT JDEDATE REQ INPUT

The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost
effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.

jdDateDbaBegins DTDB JDEDATE REQ INPUT

The beginning date on the employee's DBA instruction record (F06106) for this enrollment. In most cases, this is the same as the beginning
effective date of the enrollment. However, it can be later than the beginning effective date if the enrollment is changed retroactively. Only
active enrollment records have a value in this field since they are the only enrollment records that result in payroll deductions, benefits, or
accruals. Active records have a beginning status that starts with A.

jdDateDbaEnds DTDE JDEDATE REQ INPUT

The ending date on the employee's DBA instruction record (F06106) for this enrollment. In most cases, this is the same as the ending
effective date of the enrollment. However, it can be later than the ending effective date if the enrollment is changed retroactively. Only active
enrollment records have a value in this field since they are the only enrollment records that result in payroll deductions, benefits, or accruals. Active
records have a beginning status that starts with A.

szProgramId PID char OPT INPUT

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

jdDateUpdated UPMJ JDEDATE OPT INPUT

The date that specifies the last update to the file record.

szUserId USER char OPT INPUT

The code that identifies a user profile.

szComputerID CTID char OPT INPUT

Related Functions

None

Related Tables

None

F08330BeginDoc
F08330BeginDoc

F08330 Transaction Business Function

Master Business Function

Object Name: N0800044

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this NER is to check an employees status and if they are not locked to call 'F08330
Begin Doc TMBF Cache' to add the employees header information to cache.

Setup Notes and Prerequisites

Special Logic

Technical Specifications
Call 'Build Employee No Display' to get Address Number.
Call 'F060116 Validate Employee Identification'

If Employee is valid then
Fetch Employee Status
Status Flag:
0 = No Lockout
1 = Lockout, no changes allowed
2 = Lockout, all changes allowed
3 = Lockout, some changes allowed
4 = Add new employed
5 = Terminated employee
6 = Employee on Leave of Absence

Fetch data from F060116 to use to check employee status flag
Call 'Set Employee Current Status Flag' to get Status Flag
If cStatusFlag is equal to '2' or '3' then
BF cWarningFlag = "Y"
End If
If cStatusFlag is equal to "1" then record is locked
Set NER Error '0331'
End If
If not locked then place into cache
Call 'X0010 Get Next Number' to use Next Number as Job Number
Add header info to cache by calling 'F08330 Begin Doc TMBF Cache'
End If
End If

Data Structure

D0800044A - F08330 Begin Doc

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnJobnumberA JOBS MATH_NUMERIC OPT BOTH

Special Output Returned
Job Number is created within this F08330 Begin Doc and returned but it must be kept in a variable to
retrieve the data from cache.
^

cActionCode2 ACTN char NONE INPUT

Add    'A'
Delete 'D' or
Change 'C'
records in cache
^

cProcessEdits EV01 char NONE INPUT

An option that specifies the type of processing for an event.

cErrorCondition EV01 char NONE OUTPUT

An option that specifies the type of processing for an event.

cRecordWrittenToWorkFile EV01 char NONE NONE

An option that specifies the type of processing for an event.

szVersion VERS char NONE NONE

A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.

szEmployeeIdentification ENDYOW char NONE BOTH

The employee number, TAX ID, or Alternate number, depending on the employee number mode that is set up in the Payroll Constants for
company 00000.

cModeEmployeeNumber EM char NONE INPUT

A code that specifies the type of employee number displayed on inquiry screens. Valid values are:    1   Display the eight-digit Address
Book number (default).    2   Display the nine-digit Social Security number.    3   Display the eight-digit Additional Employee number preceded by a
forward slash (/). All forms of employee number remain valid.

cWarningFlag EV01 char NONE OUTPUT

An option that specifies the type of processing for an event.

szProgramId PID char NONE INPUT

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

Related Functions

None

Related Tables

None

F08330ClearDetail
F08330ClearDetail

F08330 Transaction Business Function

Master Business Function

Object Name: N0800044

Parent DLL: CHRM

Location: Client/Server

Language: NER

^
^

Data Structure

D0800044E - F08330ClearCache

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnJobnumberA JOBS MATH_NUMERIC OPT INPUT

Special Input Expected
Job Number from f08330 Begin Doc
^

cClearCacheFlag EV01 char NONE NONE

An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None

F08330DateOverlapCheck
F08330DateOverlapCheck

F08330 Transaction Business Function

Master Business Function

Object Name: N0800044

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this NER is to verify that two date ranges do not overlap.  If they do overlap then
return BF cDateOverlapFlag = "Y".

Setup Notes and Prerequisites

Special Logic

Technical Specifications
Begin Date1 and End Date1 are passed in as one range of dates and Begin Date2 and End Date2 are
passed in as the second range of dates.

Every combination of dates that can cause an overlap is checked in a series of 'If' statements.  If
overlap is found then BF cDateOverlapFlag = "Y".

Data Structure

D0800044C - P08330 Overlapping Date Check

Parameter Name Data Item Data Type Req/Opt I/O/Both

jdDateEffectiveRates EFT JDEDATE NONE NONE

The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost
effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.

jdDateEndingEffective EFTE JDEDATE NONE NONE

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

jdDateBegin DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdDateEnd DATE01 JDEDATE NONE NONE

Event point for JDE Date.

cDateOverlapFlag EV01 char NONE NONE

Special Output Returned
'Y' is returned if the dates overlap

Related Functions

None

Related Tables

None

F08330EditLine
F08330EditLine

F08330 Transaction Business Function

Master Business Function

Object Name: N0800044

Parent DLL: CHRM

Location: Client/Server

Language: NER

Data Structure

D0800044B - F08330EditLine

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnJobnumberA JOBS MATH_NUMERIC OPT INPUT

Special Input Expected
Job number from F08330 Begin Doc
^

cActionCode2 ACTN char OPT INPUT

Special Input Expected
Add    'A'
delete 'D' or
change 'C'
to alter records in the tables
^

cErrorCode ERRC char NONE OUTPUT

This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
Set Server program (XT4914).

szPlanId PLAN char OPT 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 OPT 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.

jdDateEligible DELG JDEDATE OPT INPUT

The date on which the employee is eligible to enroll in the benefit plan. This date is not necessarily the date that the employee begins
participating in the plan. For example: The XYZ Company requires that employees work for the company for six months before they are eligible to
participate in the 401(k) plan. Employees can enroll in 401(k) two times per year, on January 1 and July 1. Therefore, an employee who
begins working for XYZ Company on 03/01/05 has an eligibility date of 01/01/06. The eligibility date is the date on which the employee becomes
eligible, provided that eligibility continues. If the employee changes to a non-eligible status, the eligibility date on the new record is set to
blank.

jdDateOfParticipation DPTC JDEDATE OPT INPUT

The date on which the employee begins participating in the plan for the specified enrollment period. For example: The XYZ Company
requires that employees work for the company for six months before they are eligible to participate in the 401(k) plan. Employees can enroll in
401(k) two times per year, on January 1 and July 1. An employee who begins working for XYZ Company on 03/01/05 is eligible to participate in
the plan on 01/01/06. However, if the employee does not enroll in the plan until 07/01/06, the employee's participation date is 07/01/06. The
participation date is the first date on which the employee begins participating in the plan, provided that the employee continues to participate.
When participation stops, the participation date on the new record is set to blank. If the employee has a break in eligibility, the participation
date is the date that participation began for the latest enrollment period.

jdDateDbaBegins DTDB JDEDATE OPT BOTH

The beginning date on the employee's DBA instruction record (F06106) for this enrollment. In most cases, this is the same as the beginning
effective date of the enrollment. However, it can be later than the beginning effective date if the enrollment is changed retroactively. Only
active enrollment records have a value in this field since they are the only enrollment records that result in payroll deductions, benefits, or
accruals. Active records have a beginning status that starts with A.

jdDateDbaEnds DTDE JDEDATE OPT BOTH

The ending date on the employee's DBA instruction record (F06106) for this enrollment. In most cases, this is the same as the ending
effective date of the enrollment. However, it can be later than the ending effective date if the enrollment is changed retroactively. Only active
enrollment records have a value in this field since they are the only enrollment records that result in payroll deductions, benefits, or accruals. Active
records have a beginning status that starts with A.

szEnrollmentStatus XDFS char OPT INPUT

A code that indicates the status of an employee's enrollment in a plan. It is a user defined code (08/ES), and you must use the following
restrictions for the definitions:   o  All statuses indicating active participation in a plan must begin with the letter A.   o  All statuses indicating an
ending status that does not result in a new enrollment (such as a termination) must have the letter X in the first position of Description 2 (data item
DL02), General User Defined Codes form.   o  A status beginning with the letter X, when used as an ending status, represents a mistaken
enrollment. No employee DBA instructions are written.   o  An asterisk (*) indicates all statuses not otherwise specified.

szEnrollmentStatusEnding XEST char OPT INPUT

A code that indicates the ending status of an employee's enrollment in a plan. This status represents the reason for ending the old
enrollment and is used as the beginning status of any resulting new enrollment. You can define this code using user defined code table 08/ES. See
data item XDFS (Status - Enrollment) for restrictions on the allowed values. Note: An ending status that begins with the letter X represents a
mistaken enrollment.

jdDateEffectiveRates EFT JDEDATE OPT INPUT

The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost
effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.

jdDateEndingEffective EFTE JDEDATE OPT INPUT

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

mnAddressNumber AN8 MATH_NUMERIC NONE NONE

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

mnAmtPayrollCreditPoints RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnAmtPayrollDedPoints RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnAmtEmployeeDbaId RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnAmtDbaEmployerId RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

cRecordWrittenToCache EV01 char OPT BOTH

Special Input Expected
'Y' if record has been written to cache
^

szEnrollmentEventCode EECD char OPT INPUT

The user defined code (08/BE) that you use to denote an enrollment event such as marriage.

jdEventDate DATE01 JDEDATE OPT INPUT

Event point for JDE Date.

szUserId USER char OPT INPUT

The code that identifies a user profile.

jdDateUpdated UPMJ JDEDATE OPT INPUT

The date that specifies the last update to the file record.

szBenefitGroupCategory SBGR char OPT INPUT

The category of a benefit group. The category is used to group benefit plans according to the type and/or rule. For
example: MEDICAL Required Medical Selections   DENTAL Optional Dental Selections   LIFE Required Life Ins Selections Valid categories are set up in the Generic
Rate and Message table (F00191) for system 08/type SG. Associated text for categories is stored in the General Message Detail table
(F00192). For more information, see program P00191.

mnAmtDBAEEIdOption RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnAmtDBAERIdOption RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnAmtEEDedPtsOption RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnAmtERCreditPtsOption RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnEmployeeDbaId FDBA MATH_NUMERIC OPT INPUT

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.

mnEmployeeDbaIdOption FDBA MATH_NUMERIC OPT INPUT

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 INPUT

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.

mnDbaEmployerIdOption SDBA MATH_NUMERIC OPT INPUT

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 INPUT

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.

mnPayrollDedPointsOption PDDP MATH_NUMERIC OPT INPUT

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 INPUT

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.

mnPayrollCreditPointsOption PDCP MATH_NUMERIC OPT INPUT

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.

Related Functions

None

Related Tables

None

F08330EndDoc
F08330EndDoc

F08330 Transaction Business Function

Master Business Function

Object Name: N0800044

Parent DLL: CHRM

Location: Client/Server

Language: NER

^

Data Structure

D0800044D - F08330 End Doc

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnJobnumberA JOBS MATH_NUMERIC OPT INPUT

Special Input Expected
Job Number from F08330 Begin Doc
^

cErrorConditions EV01 char OPT OUTPUT

An option that specifies the type of processing for an event.

mnFactorConvertPtsToDollars MATH01 MATH_NUMERIC OPT INPUT

- - - Good Performance Low Value.

cClearCacheFlag EV01 char OPT INPUT

An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None

LoadPlanAndOptionDBARecords
LoadPlanAndOptionDBARecords

F08330 Transaction Business Function

Master Business Function

Object Name: N0800044

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this NER is to determine the Additional Amount, Override Amount, and DBA Code to be
used by the Update Payroll DBA Record NER.
Setup Notes and Prerequisites
This NER is designed to be called from other NERs in N0800044 and is not designed to be called from
any other application or NER.

Special Logic

Technical Specifications
Fetch the DBAs and Options for the given Plan ID and Plan Additional Option from F083202.

If this fetch is successful then set cOptionFlag = "1"
End If

If cOptionFlag is equal to  Or cOptionFlag is equal to "1"And OptionRule (From F083202)
is equal to "2" Then
mnAdditionalAmount = "0"
mnOverrideAmount = BF mnAmtDBAEmployeeID (Employee Amount Passed in)
mnDBACode = BF EmployeeDbaId (Passed in)
Call 'Update Payroll DBA Record' passing in the above variables
End If
If OptionFlag is equal to "1"And OptionRule (From F083202) is equal to "1"
mnAdditionalAmount = AmountAdditional1 (From F083202)
mnOverrideAmount = "0"
mnDBACode = BF mnEmployeeDbaId (Passed in)
Call 'Update Payroll DBA Record' passing in the above variables
End If
If cOptionFlag is equal to "1" And OptionRule (From F083202) is not
equal to "1"
mnAdditionalAmount = "0"
mnOverrideAmount = AmountAdditional1 (From F083202)
mnDBACode = mnAOPTEmployeeDBA (From F083202)
Call 'Update Payroll DBA Record' passing in the above variables
End If
This code repeats four times using the Employee Dollar DBA, Option, and Additional Amount, the
Employer Dollar DBA, Option, and Additional Amount, thee Employee Points DBA, Option, and Additional Amount,
(Not Supported in B732), and the Employer Points DBA, Option, and Additional Amount. (Not Supported
in B732)

Options are not used in B733.

Data Structure

D0800044G - Load Plan and Option DBA Records

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnAddressNumber AN8 MATH_NUMERIC OPT INPUT

^

szPlanId PLAN char OPT 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 OPT 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.

jdDateDbaBegins DTDB JDEDATE OPT INPUT

The beginning date on the employee's DBA instruction record (F06106) for this enrollment. In most cases, this is the same as the beginning
effective date of the enrollment. However, it can be later than the beginning effective date if the enrollment is changed retroactively. Only
active enrollment records have a value in this field since they are the only enrollment records that result in payroll deductions, benefits, or
accruals. Active records have a beginning status that starts with A.

szEnrollmentStatus XDFS char OPT INPUT

A code that indicates the status of an employee's enrollment in a plan. It is a user defined code (08/ES), and you must use the following
restrictions for the definitions:   o  All statuses indicating active participation in a plan must begin with the letter A.   o  All statuses indicating an
ending status that does not result in a new enrollment (such as a termination) must have the letter X in the first position of Description 2 (data item
DL02), General User Defined Codes form.   o  A status beginning with the letter X, when used as an ending status, represents a mistaken
enrollment. No employee DBA instructions are written.   o  An asterisk (*) indicates all statuses not otherwise specified.

mnAmtDBAEmployeeID RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnAmtDBAEmployerID RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnAmtPayrollCreditPoints RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnAmtPayrollDedPoints RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

jdDateDbaEnds DTDE JDEDATE OPT INPUT

The ending date on the employee's DBA instruction record (F06106) for this enrollment. In most cases, this is the same as the ending
effective date of the enrollment. However, it can be later than the ending effective date if the enrollment is changed retroactively. Only active
enrollment records have a value in this field since they are the only enrollment records that result in payroll deductions, benefits, or accruals. Active
records have a beginning status that starts with A.

szEnrollmentStatusEnding XEST char OPT INPUT

A code that indicates the ending status of an employee's enrollment in a plan. This status represents the reason for ending the old
enrollment and is used as the beginning status of any resulting new enrollment. You can define this code using user defined code table 08/ES. See
data item XDFS (Status - Enrollment) for restrictions on the allowed values. Note: An ending status that begins with the letter X represents a
mistaken enrollment.

mnJobnumberA JOBS MATH_NUMERIC OPT INPUT

Special Input Expected
From F08330 begin Doc
^

mnFactorConvertPtsToDollars MATH01 MATH_NUMERIC OPT INPUT

- - - Good Performance Low Value.

jdDateEffectiveRates EFT JDEDATE OPT INPUT

The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost
effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.

jdDateEndingEffective EFTE JDEDATE OPT INPUT

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

cActionCode2 ACTN char OPT INPUT

A code that specifies the action that is performed. Valid values are: A Add C Change

szUserId USER char OPT INPUT

The code that identifies a user profile.

jdDateUpdated UPMJ JDEDATE OPT INPUT

The date that specifies the last update to the file record.

szWorkStationId JOBN char OPT INPUT

The code that identifies the work station ID that executed a particular job.

mnAmtEEDBAIdOption RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnAmtERDBAIdOption RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnAmtEEDedPtsOption RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnAmtERCreditPtsOption RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnEmployeeDbaId FDBA MATH_NUMERIC OPT NONE

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 NONE

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 NONE

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 NONE

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.

mnEmployeeDbaIdOption FDBA MATH_NUMERIC OPT NONE

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.

mnDbaEmployerIdOption SDBA MATH_NUMERIC OPT NONE

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.

mnPayrollDedPointsOption PDDP MATH_NUMERIC OPT NONE

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.

mnPayrollCreditPointsOption PDCP MATH_NUMERIC OPT NONE

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.

Related Functions

None

Related Tables

None

UpdatePayrollDBARecord
UpdatePayrollDBARecord

F08330 Transaction Business Function

Master Business Function

Object Name: N0800044

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this NER is to Update the Change Flag in F060116 with the key, Address Number, and
either add or update records in F06106 with keys Address Number, DBA code and Begin Date.

Setup Notes and Prerequisites
This NER is designed to be called from other NERs in N0800044 and is not designed to be called from
any other application or NER.

Special Logic

Technical Specifications
Retrieve header information using NER 'F08330 Begin Doc TMBF Cache'
Retrieve User Name, Current Date, and Workstation ID, from NER 'Get Audit Information'

Update the change flag in employee master if it has not already been updated using BF Address Number
(Passed in) as the key.

If BF DBACode (Passed in) is not NULL then
Fetch: General Voucher Flag, Deduction Group, Amount or Rate, Transaction Type Time Pay,
Deduction Basis, and Address Number Payee from F069116 using BF DBACode as the Key.
End If

Add Additional and Update Amounts if requested
Override the Update Amount if Requested

Set DBA End Date
If record exists in F06106 then update it, otherwise, add a new record.

Data Structure

D0800044F - Update Payroll DBA Record

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnAddressNumber AN8 MATH_NUMERIC OPT INPUT

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

mnOverrideAmount RTAM MATH_NUMERIC OPT INPUT

A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.

mnDBACode PDBA MATH_NUMERIC OPT INPUT

A code that defines the type of pay, deduction, benefit, or accrual. Pay types are numbered from 1 to 999. Deductions and benefits are
numbered from 1000 to 9999.

jdDateDbaBegins DTDB JDEDATE OPT INPUT

The beginning date on the employee's DBA instruction record (F06106) for this enrollment. In most cases, this is the same as the beginning
effective date of the enrollment. However, it can be later than the beginning effective date if the enrollment is changed retroactively. Only
active enrollment records have a value in this field since they are the only enrollment records that result in payroll deductions, benefits, or
accruals. Active records have a beginning status that starts with A.

jdDateDbaEnds DTDE JDEDATE OPT INPUT

The ending date on the employee's DBA instruction record (F06106) for this enrollment. In most cases, this is the same as the ending
effective date of the enrollment. However, it can be later than the ending effective date if the enrollment is changed retroactively. Only active
enrollment records have a value in this field since they are the only enrollment records that result in payroll deductions, benefits, or accruals. Active
records have a beginning status that starts with A.

szEnrollmentStatusEnding XEST char OPT INPUT

A code that indicates the ending status of an employee's enrollment in a plan. This status represents the reason for ending the old
enrollment and is used as the beginning status of any resulting new enrollment. You can define this code using user defined code table 08/ES. See
data item XDFS (Status - Enrollment) for restrictions on the allowed values. Note: An ending status that begins with the letter X represents a
mistaken enrollment.

mnJobnumberA JOBS MATH_NUMERIC OPT INPUT

Special Input Expected
From f08330 Begin Doc
^

szPlanId PLAN char OPT 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.

szUserId USER char OPT INPUT

The code that identifies a user profile.

jdDateUpdated UPMJ JDEDATE OPT INPUT

The date that specifies the last update to the file record.

szWorkStationId JOBN char OPT INPUT

The code that identifies the work station ID that executed a particular job.

mnAddressNumberPayee ANN8 MATH_NUMERIC OPT INPUT

The address book number for the supplier who receives the final payment. In Benefits administration, this is the address book number of the
company that issues the plan and receives premium payments for it. For wage attachments, payee is the address book number of the
agency, company, individual, or court that is to receive the payment of the check.

cDeductionBasis DESQ char OPT INPUT

A user defined code (07/DB) that specifies the basis of a deduction, benefit, or accrual. When the system calculates the gross amount for
disposable net wages, it does not use the basis of calculation. The gross amount includes all earnings that have a positive effect on the gross
and net payment. For wage attachments use one of the following codes: 1-8 Garnishment, tax levy, wage assignment (child support and
maintenance)   R Loan, interest   0 Fees Note:  When using the following codes (L = Prior Year, I= Inception to Date or P = Prior Month), it is required to
roll over pdba amounts at year end for any pdba code that is included in the basis of calculation.  Rollover (P07390) is required to create
historical summary records (F06145 or F06146) in the new year that summarize amounts used for these calculations.

cTransactTypeTimePay DISO char OPT INPUT

A code used to distinguish between the following types of payroll entries: P Time Cards (Earnings)   D Deductions withheld   B Benefit (both
cash and non cash)   A Accrual of sick, vacation, comp, and so forth Note: These codes may only be changed by J.D. Edwards If you enter an *
in this field the system displays all four types of PDBAs.

szDeductionGroup DGRP char OPT INPUT

Specify a code common to all deductions or benefits that share the same limitations (for example, pay period dollar amount or percentage,
monthly,annual, and so on).  The system takes these limits from the first deduction encountered in the group, and withholds for all
deductions until the limit is reached for the aggregate.   Example: Deduction 6400, Group A, Annual Limit = $1000, No Pay Period Limit Deduction 6430,
Group A, No Annual or Pay Period Limit Deduction 7700, Group A, No Annual or Pay Period Limit Deduction 9400, Group B, No Annual or Pay
Period Limit Deduction 7550, Group B, No Annual Limit, Pay Period Limit = $50 For this example, the system looks at the deductions
assigned to Group A, and applies a $1000 annual limit for all three deductions. The system continues to take the deductions from an employee's
paycheck until a total of $1000 has been deducted between all entities in Group A for the year. For deductions in Group B, the system deducts
no more than $50 per pay period between for the two deductions.

cGenerateVoucherFlag GVCH char OPT INPUT

A code used to determine whether the system should generate a voucher for the DBA, tax, or wage attachment during the final update
phase of the payroll processing cycle. Valid codes are: N No, do not generate a voucher      Y Yes, generate a voucher

szPlanAdditionalOption AOPT char OPT 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.

cActionCode2 ACTN char OPT INPUT

A code that specifies the action that is performed. Valid values are: A Add C Change

szNameRemarkExplanation EXR char OPT INPUT

A name or remark that describes the purpose for using an account or conveys any other information that the user wants about the
transaction.

cArrearageRules ARRR char OPT INPUT

A code indicating how to adjust deductions when the employee is in a negative pay situation. Valid codes are: P Do a partial or full
deduction as needed. This is the default. F Do a full reduction or none at all. N Do not reduce. Q Same as code P. In addition, place the amount in
arrears, but do not apply the limits when collecting the arrearage. Write the arrearage balance to history. R Same as code P. In addition, place the
amount in arrears and apply the limits when collecting the arrearage. Write the arrearage balance to history.    G Same as code F. In addition,
place the amount in arrears, but do not apply the limits when collecting the arrearage. Write the arrearage balance to history.    H Same as
code F. In addition, place the amount in arrears and apply the limits when collecting the arrearage. Write the arrearage balance to
history. S Same as code P. In addition, place the amount in arrears for the current pay period only but do not apply the limits when collecting the
arrearage. Do not write the arrearage balance to history. T Same as code P. In addition, place the amount in arrears for the current pay period only and
apply the limits when collecting the arrearage. Do not write arrearage balance to history. I Same as code F. In addition, place the amount in
arrears for the current pay period only, but do not apply the limits when collecting the arrearage. Do not write arrearage balance to
history. J Same as code F. In addition, place the amount in arrears for the current pay period only and apply the limits when collecting the arrearage. Do
not write arrearage balance to history.

Related Functions

None

Related Tables

None

oyee 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.
szPlanAdditionalOptionAOPTcharOPTINPUT
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.
jdDateEligibleDELGJDEDATEOPTINPUT
The date on which the employee is eligible to enroll in the benefit plan. This date is not necessarily the date that the employee begins
participating in the plan. For example: The XYZ Company requires that employees work for the company for six months before they are eligible to
participate in the 401(k) plan. Employees can enroll in 401(k) two times per year, on January 1 and July 1. Therefore, an employee who
begins working for XYZ Company on 03/01/05 has an eligibility date of 01/01/06. The eligibility date is the date on which the employee becomes
eligible, provided that eligibility continues. If the employee changes to a non-eligible status, the eligibility date on the new record is set to
blank.
jdDateOfParticipationDPTCJDEDATEOPTINPUT
The date on which the employee begins participating in the plan for the specified enrollment period. For example: The XYZ Company
requires that employees work for the company for six months before they are eligible to participate in the 401(k) plan. Employees can enroll in
401(k) two times per year, on January 1 and July 1. An employee who begins working for XYZ Company on 03/01/05 is eligible to participate in
the plan on 01/01/06. However, if the employee does not enroll in the plan until 07/01/06, the employee's participation date is 07/01/06. The
participation date is the first date on which the employee begins participating in the plan, provided that the employee continues to participate.
When participation stops, the participation date on the new record is set to blank. If the employee has a break in eligibility, the participation
date is the date that participation began for the latest enrollment period.
jdDateDbaBeginsDTDBJDEDATEOPTBOTH
The beginning date on the employee's DBA instruction record (F06106) for this enrollment. In most cases, this is the same as the beginning
effective date of the enrollment. However, it can be later than the beginning effective date if the enrollment is changed retroactively. Only
active enrollment records have a value in this field since they are the only enrollment records that result in payroll deductions, benefits, or
accruals. Active records have a beginning status that starts with A.
jdDateDbaEndsDTDEJDEDATEOPTBOTH
The ending date on the employee's DBA instruction record (F06106) for this enrollment. In most cases, this is the same as the ending
effective date of the enrollment. However, it can be later than the ending effective date if the enrollment is changed retroactively. Only active
enrollment records have a value in this field since they are the only enrollment records that result in payroll deductions, benefits, or accruals. Active
records have a beginning status that starts with A.
szEnrollmentStatusXDFScharOPTINPUT
A code that indicates the status of an employee's enrollment in a plan. It is a user defined code (08/ES), and you must use the following
restrictions for the definitions:   o  All statuses indicating active participation in a plan must begin with the letter A.   o  All statuses indicating an
ending status that does not result in a new enrollment (such as a termination) must have the letter X in the first position of Description 2 (data item
DL02), General User Defined Codes form.   o  A status beginning with the letter X, when used as an ending status, represents a mistaken
enrollment. No employee DBA instructions are written.   o  An asterisk (*) indicates all statuses not otherwise specified.
szEnrollmentStatusEndingXESTcharOPTINPUT
A code that indicates the ending status of an employee's enrollment in a plan. This status represents the reason for ending the old
enrollment and is used as the beginning status of any resulting new enrollment. You can define this code using user defined code table 08/ES. See
data item XDFS (Status - Enrollment) for restrictions on the allowed values. Note: An ending status that begins with the letter X represents a
mistaken enrollment.
jdDateEffectiveRatesEFTJDEDATEOPTINPUT
The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost
effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
jdDateEndingEffectiveEFTEJDEDATEOPTINPUT
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.
mnAddressNumberAN8MATH_NUMERICNONENONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
mnAmtPayrollCreditPointsRTAMMATH_NUMERICOPTINPUT
A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.
mnAmtPayrollDedPointsRTAMMATH_NUMERICOPTINPUT
A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.
mnAmtEmployeeDbaIdRTAMMATH_NUMERICOPTINPUT
A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field
override the hourly rate.
mnAmtDbaEmployerIdRTAMMATH_NUMERICOPTINPUT
A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used.  Valid values are: 1 For a deduction,
benefit, or accrual, the meaning of this value depends on the method of calculation.  The method determines whether the deduction is a flat
monetary amount, a percentage, or a multiplication rate.  Table method DBAs, depending on which table method they use, can either use this
amount in the calculation or ignore it.  If there are exceptions to the table calculation, you can override the table code in the detail area, set up a
flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnJobnumberA	JOBS	MATH_NUMERIC	OPT	BOTH
Special Output Returned Job Number is created within this F08330 Begin Doc and returned but it must be kept in a variable to retrieve the data from cache. ^
cActionCode2	ACTN	char	NONE	INPUT
Add 'A' Delete 'D' or Change 'C' records in cache ^
cProcessEdits	EV01	char	NONE	INPUT
An option that specifies the type of processing for an event.
cErrorCondition	EV01	char	NONE	OUTPUT
An option that specifies the type of processing for an event.
cRecordWrittenToWorkFile	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szVersion	VERS	char	NONE	NONE
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
szEmployeeIdentification	ENDYOW	char	NONE	BOTH
The employee number, TAX ID, or Alternate number, depending on the employee number mode that is set up in the Payroll Constants for company 00000.
cModeEmployeeNumber	EM	char	NONE	INPUT
A code that specifies the type of employee number displayed on inquiry screens. Valid values are: 1 Display the eight-digit Address Book number (default). 2 Display the nine-digit Social Security number. 3 Display the eight-digit Additional Employee number preceded by a forward slash (/). All forms of employee number remain valid.
cWarningFlag	EV01	char	NONE	OUTPUT
An option that specifies the type of processing for an event.
szProgramId	PID	char	NONE	INPUT
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.