D0800394 - Retrieve from Employee Current/Pending Elections Work Table
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnMode | MATH01 | MATH_NUMERIC | REQ | INPUT |
- - - Good Performance Low Value. | ||||
szError | 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
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | OPT | BOTH |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnSequenceNumberView | SEQ# | MATH_NUMERIC | OPT | BOTH |
A number used to sequence information for review purposes only. | ||||
szBenefitGroupCategory | SBGR | char | OPT | BOTH |
The category of a benefit group. The category is used to group benefit plans according to the type and/or rule. For
| ||||
szDescription001 | DL01 | char | OPT | BOTH |
A user defined name or remark. | ||||
szPlanId | PLAN | char | OPT | BOTH |
An abbreviation or number that identifies a specific employee benefit. Examples are:
o Employee Health Insurance
o Accidental Death
| ||||
szPlanAdditionalOption | AOPT | char | OPT | BOTH |
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table
| ||||
szDescription50Characters | DS50 | char | OPT | BOTH |
A descriptive statement of up to 50 characters in length. | ||||
jdDateEffectiveRates | EFT | JDEDATE | OPT | BOTH |
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
| ||||
cNon-ParticipatingPlanFlag | NPPLFL | char | OPT | BOTH |
A code that specifies whether an employee can elect to decline participation in the benefit plan. | ||||
cMustStayInPlanGrouping | SIPG | char | OPT | BOTH |
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
| ||||
szPrimaryCarePhysicianNumb | PCP# | char | OPT | BOTH |
A code that identifies the employee's or dependent's Primary Care Physician (PCP). | ||||
szPlanGroupingCode | PLNGRP | char | OPT | BOTH |
An option that allows the user to designate which benefit plans or benefit plan options are related, based on a provider or other criteria. | ||||
szBenefitCategoryClassific | BCATCL | char | OPT | BOTH |
A code that designates benefit categories that are grouped together. | ||||
szWorkStationId | JOBN | char | OPT | BOTH |
The code that identifies the work station ID that executed a particular job. | ||||
mnSequenceNumber2 | SEQN | MATH_NUMERIC | OPT | BOTH |
A number used to organize the table into a logical group for online viewing and reporting. | ||||
szUserId | USER | char | OPT | BOTH |
The code that identifies a user profile. | ||||
mnTimeLastUpdated | UPMT | MATH_NUMERIC | OPT | BOTH |
The time that specifies when the program executed the last update to this record. | ||||
jdDateUpdated | UPMJ | JDEDATE | OPT | BOTH |
The date that specifies the last update to the file record. | ||||
szProgramId | PID | char | OPT | BOTH |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
cCategoryType | CATY | char | OPT | BOTH |
A code that identifies categories for DBAs that use special flex calculation plans, such as lump sum employer flex credits and employee
| ||||
mnDeductionAmtRate | DRTM | MATH_NUMERIC | OPT | BOTH |
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 | BOTH |
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
| ||||
mnAmountAdditional2 | ERAM | MATH_NUMERIC | OPT | BOTH |
An additional amount that the employer contributes toward the cost of a benefit option. For example, an employer might pay 100.00 toward
| ||||
mnEmployeeFlexCost | EEFC | MATH_NUMERIC | OPT | BOTH |
The amount of flex credits given to an employee by the employer when the employee chooses the benefit plan. | ||||
cPCPVisited | PCPVST | char | OPT | BOTH |
An option that indicates whether an employee has previously visited the primary care physician. Valid values are: 0 No 1 Yes | ||||
mnTrackPCPNumberFlag | PCPF | MATH_NUMERIC | OPT | BOTH |
An option that specifies whether the benefit plan or benefit plan option tracks primary care physician numbers. If you choose this option,
| ||||
cDepBen | DBEN | char | OPT | BOTH |
A code that indicates whether the person is a dependent or a beneficiary of the employee. Valid codes are:
D
The person is a
| ||||
mnPlanCredit | PCRE | MATH_NUMERIC | OPT | BOTH |
The credit that the system calculates for a plan or plan option. | ||||
mnPlanCost | PCOS | MATH_NUMERIC | OPT | BOTH |
The cost that the system calculates for a plan or plan option. | ||||
jdDateEndingEffective | EFTE | JDEDATE | OPT | BOTH |
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
|
None |
None |