D0800396 - Retrieve from Current Dep/Ben X-Reference Work Table
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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
| ||||
mnParticipantAddress | PAN8 | MATH_NUMERIC | OPT | BOTH |
The address number of the participant as defined in the Participant file table (F08901). | ||||
szNameMailing | MLNM | char | OPT | BOTH |
The company or person to whom billing or correspondence is addressed. | ||||
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
| ||||
cDepBeneRelationship | RELA | char | OPT | BOTH |
A user defined code (system 08/type RL) that defines the relationship of the dependent or beneficiary to the employee. | ||||
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
| ||||
cActiveInactiveFlg | CCAI | char | OPT | BOTH |
This field specifies whether a currency relationship is active (A) or inactive (I). The system calculates active currency relationships only.
| ||||
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. | ||||
szWorkStationId | JOBN | char | OPT | BOTH |
The code that identifies the work station ID that executed a particular job. | ||||
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
| ||||
szUserId | USER | char | OPT | BOTH |
The code that identifies a user profile. | ||||
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 | ||||
mnNewPercentage-SecondaryB | NSECPERC | MATH_NUMERIC | OPT | BOTH |
The new percentage of any proceeds from the benefit that will go to the secondary beneficiary if the primary beneficiaries are no longer
| ||||
mnNewPercentageBeneficiary | NEWPERC | MATH_NUMERIC | OPT | BOTH |
The new percentage of any proceeds from the benefit that will go to the primary beneficiary.
For example, the primary beneficiary might be
| ||||
mnDecondaryBeneficiaryPerc | SECPERC | MATH_NUMERIC | OPT | BOTH |
The percentage of any proceeds from the benefit that will go to the secondary beneficiary if the primary beneficiaries are no longer
| ||||
mnPercentageBeneficiary | PERC | MATH_NUMERIC | OPT | BOTH |
The percentage of any proceeds from the benefit that goes to the participant. For example, you can designate that as the primary
| ||||
szPrimaryCarePhysicianNumb | PCP# | char | OPT | BOTH |
A code that identifies the employee's or dependent's Primary Care Physician (PCP). | ||||
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
| ||||
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
| ||||
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
|
None |
None |