Functional Description
Purpose
Return an amount from F083203 where jdDateEffectiveRates is within F083203 dates. If no amount exist
then the amount equals '0'.
Setup Notes and Prerequisites
Special Logic
Technical Specification
Loop through f083203 until there are no more records or where jdDateEffectiveRates is within F083203
dates.
If there is a matching record then pass back the amount from f083203 otherwise amount = 0.
^
D0800058 - Get Plan Master Rate
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szPlanId | PLAN | char | NONE | NONE |
An abbreviation or number that identifies a specific employee benefit. Examples are:
o Employee Health Insurance
o Accidental Death
| ||||
mnPayDeductBenAccType | PDBA | MATH_NUMERIC | NONE | NONE |
A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are
| ||||
cPlanTypeCode | PLNT | char | NONE | NONE |
A code which indicates whether the rates are Benefit Plans or COBRA Plans. | ||||
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
| ||||
mnAmtOrRate | RTAM | MATH_NUMERIC | NONE | NONE |
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,
| ||||
szPlanAdditionalOption | AOPT | char | NONE | NONE |
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table
|
None |
None |