D0800221 - Cache Plan ID By Group And Category
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| mnJobnumberAKey1 | JOBS | MATH_NUMERIC | REQ | INPUT | 
The job number (work station ID) which executed the particular job.  | ||||
| szBenefitGroupCodeKey2 | DIVC | char | OPT | BOTH | 
The benefit group to which the employee is assigned. Benefit groups facilitate employee enrollment by categorizing benefit plans and 
  | ||||
| szBenefitGroupCategoryKey3 | 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 
  | ||||
| szPlanIdKey4 | PLAN | char | OPT | BOTH | 
An abbreviation or number that identifies a specific employee benefit. Examples are:
  o  Employee Health Insurance
  o  Accidental Death 
  | ||||
| szPlanAdditionalOptionKey5 | 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 
  | ||||
| idCacheCursor | GENLNG | ID | REQ | BOTH | 
General purpose ID variable.  | ||||
| mnNumberKeys | NKEYS | MATH_NUMERIC | REQ | INPUT | 
The number of keys in an index that will be used to retrieve, delete, or update a record.  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| szCategoryDescription001 | DL01 | char | OPT | BOTH | 
A user defined name or remark.  | ||||
| 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 
  | ||||
| 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 
  | ||||
| cDefaultPlan | XDFP | char | OPT | BOTH | 
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 
  | ||||
| szPlanAndOptionDesc50 | DS01 | char | OPT | BOTH | 
A free-form, 80-character text field.  | ||||
| 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 
  | ||||
| mnEmployeeDbaId | FDBA | MATH_NUMERIC | OPT | BOTH | 
The DBA defined in the Payroll Transactions Constants table (F069116) that is used to calculate the dollar amount that the employee 
  | ||||
| mnDbaEmployerId | SDBA | MATH_NUMERIC | OPT | BOTH | 
The DBA defined in the Payroll Transactions Constants table (F069116) that the system uses to calculate the dollar amount that the 
  | ||||
| mnPayrollDedPoints | PDDP | MATH_NUMERIC | OPT | BOTH | 
The DBA defined in the Payroll Transactions Constants file (F069116) that is used to calculate the points amount that the employee 
  | ||||
| mnPayrollCreditPoints | PDCP | MATH_NUMERIC | OPT | BOTH | 
The DBA defined in the Payroll Transactions Constants table (F069116) that will be used to calculate the points amount that the employer 
  | ||||
| cAmountOrRateYn | EAOR | char | OPT | BOTH | 
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) 
  | ||||
| cMandatoryParticipation | MANP | char | OPT | BOTH | 
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. 
  | ||||
| cElectPlanFlag | EPFG | char | OPT | BOTH | 
The Elect Plan Flag specifies whether an employee may enroll in the plan when plan options are available. Valid values include:
0
The plan 
  | ||||
| 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, 
  | ||||
| mnSequenceNumber1 | SEQ | MATH_NUMERIC | OPT | BOTH | 
A number that specifies the sequence of information.  | ||||
| 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 
  | ||||
| mnPlanCost | PCOS | MATH_NUMERIC | OPT | BOTH | 
The cost that the system calculates for a plan or plan option.  | ||||
| mnPlanCredit | PCRE | MATH_NUMERIC | OPT | BOTH | 
The credit that the system calculates for a plan or plan option.  | ||||
| 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.  | ||||
| mnPlanCreditFlex | PCRE | MATH_NUMERIC | OPT | BOTH | 
The credit that the system calculates for a plan or plan option.  | ||||
| cFlatAmtOrCalculated | EV01 | char | OPT | BOTH | 
An option that specifies the type of processing for an event.  | ||||
| None | 
| None |