AdjustEnrollmentDateToCorrectPP

Adjust Enrollment Date To Correct Pay Period

Minor Business Rule

Object Name: N0800098

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The NER adjusts an enrollment date to the employee's correct pay period date.

Setup Notes and Prerequisites
The enrollment date passed in,is the date determined by the date code.

Special Logic

Technical Specification
Retrieve the employee's pay period code (PPCD) and the last pay period number (    ) in the employee
master table, F060116.

If the pay period code is blank, the assumption is that the employee is a new hire or rehire.  In
this case, there is no need to adjust enrollment date and return.

If the pay period code <> Blank
  Retrieve a flag (BGPP) from the plan/plan option tag table,
  F08320B

  If the flag (BGPP) = 0, no need to adjust the enrollment date and return

  If the flag (BGPP) <> 0

    Retrieve the pay period end date for employee's pay cycle code and last pay period
    # from F069066 (Master Pay Cycle).  Increment one day to the pay period end date
    and the date becomes the employee's current pay period begin date.

    Employee's current pay period = Last pay period number + 1
    Retrieve the pay period end date for employee's pay cycle code and current pay
    period number from F069066.

    If the enrollment date parameter is less than the employee's current pay
    period begin date, adjust the enrollment date to the current pay period begin date
    and return.

    If the enrollment date parameter falls on or in between the current pay period
    begin date and end date,
       -If flag (BGPP) = 1, adjust the enrollment date to the current pay period
        begin date and return

       -If flag (BGPP) = 2, adjust the enrollment date to the beginning of the
        employee's next pay period (ie. current pay period end date plus one day)
        and return
    End If   //End of enrollment date >=begin date and enrollment date <=ENd date//

    If the enrollment date parameter is beyond the employee's current pay period
    (ie. enrollment date > current pay period end date)
       -Find from the F069066 which pay period # the enrollment date falls in and
        retrieve the end date for the determined pay period #.
       -If the flag (BGPP) is 1, calculate the begin date of the determined pay period
        the enrollment date falls in (ie. increment one day to the end date of previous
        pay period). Adjust the enrollment date to the begin date.
       -If the flag (BGPP)= 2, adjust the enrollment date to the begin date of the
        next pay period following the enrollment (i.e increment one day to the end
        date of the determined pay period the enrollment falls in).
    End If  //End of enrollment date beyond the current end date//

  End If  // End of flag (BGPP) <> 0

End If   //End of Pay period <> Blank//

Data Structure

D0800098 - Adjust Enrollment Date To Correct Pay Period

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.

jdEnrollmentDate 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.

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.

jdAdjustedEnrollmentDate EFT JDEDATE OPT OUTPUT

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.

Related Functions

None

Related Tables

None

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.
jdEnrollmentDate	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.
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.
jdAdjustedEnrollmentDate	EFT	JDEDATE	OPT	OUTPUT
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.