D0800285 - Available Plans Enrollment Cache
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnJobnumberA | JOBS | MATH_NUMERIC | REQ | INPUT |
The job number (work station ID) which executed the particular job. | ||||
szCacheActionCode | CACTN | char | REQ | INPUT |
A code that indicates the activity you want to perform. Valid codes:
o Get - Retrieve the cache element
o Add - Add a cache element
o
| ||||
idCacheCursor | GENLNG | ID | REQ | BOTH |
General purpose ID variable. | ||||
mnIndexID | NKEYS | MATH_NUMERIC | OPT | INPUT |
The number of keys in an index that will be used to retrieve, delete, or update a record. | ||||
mnNumberKeys | NKEYS | MATH_NUMERIC | OPT | INPUT |
The number of keys in an index that will be used to retrieve, delete, or update a record. | ||||
cSuppressErrorMessage | SUPPS | char | OPT | INPUT |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
| ||||
szCacheName | PID | char | REQ | INPUT |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szErrorMessageID | DTAI | char | OPT | OUTPUT |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
mnEnrollmentEventType | EVET | MATH_NUMERIC | OPT | NONE |
A field that indicates the event during which the enrollment occurs. Valid values include:
1 Open Enrollment
2 Enrollment for current plan
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szBenefitGroupCategory | SBGR | char | OPT | NONE |
The category of a benefit group. The category is used to group benefit plans according to the type and/or rule. For
| ||||
szCategoryDescription | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
szPlanId | PLAN | char | OPT | NONE |
An abbreviation or number that identifies a specific employee benefit. Examples are:
o Employee Health Insurance
o Accidental Death
| ||||
szPlanAdditionalOption | AOPT | char | OPT | NONE |
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table
| ||||
mnSequenceNumberView | SEQ# | MATH_NUMERIC | OPT | NONE |
A number used to sequence information for review purposes only. | ||||
cDepBen | DBEN | char | OPT | NONE |
A code that indicates whether the person is a dependent or a beneficiary of the employee. Valid codes are:
D
The person is a
| ||||
mnTrackPCPNumberFlag | PCPF | MATH_NUMERIC | OPT | NONE |
An option that specifies whether the benefit plan or benefit plan option tracks primary care physician numbers. If you choose this option,
| ||||
cAmountOrRateYn | EAOR | char | OPT | NONE |
A code that indicates whether you can enter an amount or rate when you enroll an employee in a benefit plan. Typically, you enter Y (yes)
| ||||
mnEmployeeDeductionDBA | 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
| ||||
mnEmployerCostDBA | 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
| ||||
mnEEFlexCostDBA | 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
| ||||
mnERFlexCreditDBA | 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
| ||||
mnPlanCost | PCOS | MATH_NUMERIC | OPT | NONE |
The cost that the system calculates for a plan or plan option. | ||||
mnEmployeeFlexCost | EEFC | MATH_NUMERIC | OPT | NONE |
The amount of flex credits given to an employee by the employer when the employee chooses the benefit plan. | ||||
mnPlanCredit | PCRE | MATH_NUMERIC | OPT | NONE |
The credit that the system calculates for a plan or plan option. | ||||
mnDeductionAmtRate | DRTM | MATH_NUMERIC | OPT | NONE |
The value of this field is either a percentage, a dollar amount or an hourly rate depending upon where it is being used;
A When used in
| ||||
mnBenefitAmtRate | BRTM | MATH_NUMERIC | OPT | NONE |
The value of this field is either a percentage, a dollar amount or an hourly rate depending upon where it is being used.
When used in
| ||||
jdDateEffectiveRates | EFT | JDEDATE | OPT | 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
| ||||
jdDateEndingEffective | EFTE | JDEDATE | OPT | NONE |
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
| ||||
cMandatoryParticipation | MANP | char | OPT | NONE |
A code that tells indicates whether the plan is required for all employees. Valid codes are:
Y
Yes, all employees must participate in this plan.
| ||||
cDefaultPlan | XDFP | char | OPT | NONE |
A code that specifies if the plan is a default plan in the category. An employee is automatically enrolled in this plan if no other plans within
| ||||
mnMinNumOfDep | MINDEP | MATH_NUMERIC | OPT | NONE |
The minimum number of people that can be covered under a specific plan or plan option. This number includes the employee. For
| ||||
mnMaximumNumberofDependents | MXDP | MATH_NUMERIC | OPT | NONE |
This variable denotes the maximum number of dependents that may be enrolled in a benefit plan. | ||||
cSelection001 | SL01 | char | OPT | NONE |
A code used to prompt detail selection from a list of items. Typically, the legitimate selection codes are explained at the bottom of the
| ||||
szEnrollmentEventCode | EECD | char | OPT | NONE |
The user defined code (08/BE) that you use to denote an enrollment event such as marriage. | ||||
cCategoryType | CATY | char | OPT | NONE |
A code that identifies categories for DBAs that use special flex calculation plans, such as lump sum employer flex credits and employee
| ||||
szESignature | ESIGN | char | OPT | NONE |
A code that identifies an electronic signature that the system assigns when an employee approves of an action in a self-service process. | ||||
mnCategorySequenceNumber | SEQN | MATH_NUMERIC | OPT | NONE |
A number used to organize the table into a logical group for online viewing and reporting. | ||||
cDefaultingAllowedFlag | DEFFLG | char | OPT | NONE |
A code that specifies whether the system automatically displays a benefit plan or benefit plan option as the chosen plan, based on prior
| ||||
szPlanGroupingCode | PLNGRP | char | OPT | NONE |
An option that allows the user to designate which benefit plans or benefit plan options are related, based on a provider or other criteria. | ||||
cNonParticipatingPlanFlag | NPPLFL | char | OPT | NONE |
A code that specifies whether an employee can elect to decline participation in the benefit plan. | ||||
szShortPlanOptionDesc | SPLDES | char | OPT | NONE |
A short description (up to 15 characters) of the benefit plan or benefit plan option. | ||||
szShortCategoryDescription | SCTDES | char | OPT | NONE |
A short description (up to 15 characters) of the benefit category. | ||||
szBenefitCategoryClassific | BCATCL | char | OPT | NONE |
A code that designates benefit categories that are grouped together. | ||||
cDeclineCoverageNotifyFlag | DCNF | char | OPT | NONE |
A code that the system uses to indicate that the benefit administrator needs to be notified when an employee elects to decline benefit
| ||||
szPlanOrOptionDescription | DS50 | char | OPT | NONE |
A descriptive statement of up to 50 characters in length. | ||||
cChangeBeneficiary | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnDescendingCategorySeqNum | SEQN | MATH_NUMERIC | OPT | NONE |
A number used to organize the table into a logical group for online viewing and reporting. | ||||
mnDescendingPlanSeqNum | SEQ# | MATH_NUMERIC | OPT | NONE |
A number used to sequence information for review purposes only. | ||||
mnDescendingCategoryClass | NKEYS | MATH_NUMERIC | OPT | NONE |
The number of keys in an index that will be used to retrieve, delete, or update a record. | ||||
cGenericFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cAutomaticDefaultofCurrent | ADCE | char | OPT | NONE |
Use this field to specify whether the system should automatically default to the current enrollment. Valid values are:
0 Do not allow
| ||||
cAllowBenChangesOnly | ABENCO | char | OPT | NONE |
A code that designates whether the only changes that you can make to plans within a benefit category are changes to the beneficiary
| ||||
cAllowedPlanOption | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szPrimaryCarePhysicianNumb | PCP# | char | OPT | NONE |
A code that identifies the employee's or dependent's Primary Care Physician (PCP). | ||||
cGenericFlag1 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cGenericFlag2 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cGenericFlag3 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnNumberOfDependents | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
cActiveFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cPCPVisited | PCPVST | char | OPT | NONE |
An option that indicates whether an employee has previously visited the primary care physician. Valid values are: 0 No 1 Yes | ||||
cMustStayInPlanGrouping | SIPG | char | OPT | NONE |
This code that identifies what plans an employee can elect during a life event change. Valid values are:
0
An employee can enroll in any
| ||||
cNewEnroll | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnERCost | RTAM | MATH_NUMERIC | OPT | 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,
| ||||
szPlanType | PLTY | char | OPT | NONE |
A user defined code (system 08/type PT) that identifies the specific type of plan. For example, L can be used to identify a life insurance
|
B0000580 Convert String to Math Numeric | ||||
N0800074 Determine Open Benefit Category |
F085520W Available Plans and Plan Options by Employee Work Table |