F08336UpdateDepBenXref

F08336 Update Dep/Ben X-ref

Minor Business Rule

Object Name: N0800104

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The Named ER updates the dependent/beneficiary cross reference records (F08336) accordingly.

Setup Notes and Prerequisites
All data structure parameters are inputs and required.

Special Logic

Technical Specification
If the cActionFlag parameter is 'D', the NER deletes all dep/ben x-ref records, with the matching
keys, employee number, plan, plan option

If the cActionFlag parameter is 'C', the NER updates dep/ben x-ref records with the enrollment end
date passed in.  Before updates are peformed, the NER determines whether a new enrollment record is
created from ending the current enrollment.  New enrollment record is created if the 2nd description of
the UDC for the end status does not start with an 'X'. If a new enrollment record is created, the
dep/ben x-ref record will not be updated with end date.  If no new enrollment record is created, then the
NER ends date the dep/ben x-ref records with the enrollment end date only if the dep/ben x-ref records
do not have an end date or the end dates of the dep/ben x-ref records are greater than the enrollment
end date.

^

Data Structure

D0800104 - F08336 Update Dep/Ben X-ref

The NER does some checking on the enrollment end status before ending the dep/ben x-ref records. For
details, see the data structure item attachments for cActionflag and szEnrollmentStatusEnding.
^

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.
jdEnrollmentEffectiveDate	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.
jdEnrollmentEndDate	EFTE	JDEDATE	REQ	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.
cActionFlag	VC01A	char	REQ	INPUT
The Action Flag can be 'C' or 'D'. 'C'= Update the dep/ben x-ref record with the enrollment end date passed in, if the dep/ben x-ref record does not have an end date or the dep/ben x-ref end date is greater or equal to the enrollment end date. 'D' = Delete the dep/ben x-ref record ^
szEnrollmentStatusEnding	XEST	char	REQ	INPUT
The enrollment End Status is used to determine whether a new enrollment record is created in F08330 from ending a current enrollment. If the 2nd description of the UDC for the end status starts with an 'X', no new enrollment record is created. If that the case, it is OK to end date the dep/ben x-ref record. Otherwise, the dep/ben x-ref records are not end dated. ^
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.

Related Functions

None

Related Tables

None