Wiki: IBRH

MAINTAIN BENEFIT REMITTANCE AMOUNTS#

Remittance History tracks the number of participants on each coverage step by remittance period. It also allows adjustments to be done after the remittance update has been done but before the remittance reports have been run.

Maintain Remittance History data is stored on the P2K_BE_REMITTANCE_HISTORIES and P2K_BE_REMITTANCE_COMPONENTS tables.

Plan/Coverage: This is a unique user-defined code that identifies the plan to the organization. Plan_Code is a mandatory 16-character alphanumeric field that is defaulted from the plans entered on IBPN.

Coverage is a user-defined code uniquely identifying the coverage to the organization. Coverage_Code is a mandatory 16-character alphanumeric field that is defaulted from the plans entered on IBPN.

Description: This is a user-defined description of the benefit plan. Description is an optional 50-character alphanumeric field that is defaulted from the plan/coverage.

Plan Type: Type indicates the plan type that categorizes this plan. Plan_Type_Code is a mandatory 16-character alphanumeric field that is defaulted from the plan/coverage.

Policy #: This field holds the insurance policy number assigned by the insurance carrier. Policy_Number is an optional 30-character alphanumeric field that is defaulted from the plan/coverage.

Entity: This field identifies the organization to which the plan is attached (may be blank). Entity_Code is an optional 16-character alphanumeric field that is defaulted from the plan/coverage.

Remittance History#

Calendar Period: This field is the year and period number to uniquely identify the Calendar Periods.

A monthly calendar for the calendar year Jan-Dec 1998 would have calendar periods 1998-01 through 1998-12. A weekly calendar for the fiscal year Apr 1998-Mar 1999 would have calendar periods 1999-01 through 1999-52 or 1999-53.

Calendar_Period is a mandatory 10-character number field you must either manually enter or use the LOV (F9).

State/Province: This is the standard abbreviation of the state or province where the person resides. State_Province from P2K_CM_STATE_PROVINCES is a mandatory 16-character alphanumeric field you must either manually enter or use the LOV (F9).

Coverage Step: The coverage step code indicates the set of rates applicable to this enrollment. Codes may be numeric (e.g. 01, 02, 03...) or they may be alphanumeric (e.g. A, B, C, FS, MN...).

Coverage_Step_Code is a mandatory 16-character alphanumeric field you must manually enter.

Participants: This field holds the number of employees enrolled in the coverage. Participants is an optional 5-digit numeric field that is maintained by the system.

Execution ID: This field provides the execution log ID of the benefit calculation. MEX_Id is an optional 10-digit numeric field that is system maintained.

Remittance Components#

BC: BC Code is a High Line provided code to define the benefits component. All BC codes begin with the letter “B” followed by a 4-digit number.

Definitions of each of the benefits components may be found in Benefit Components section.
BC_Code is a mandatory 16-character alphanumeric field provided by High Line.

Rule: BC Rule is a High Line provided 2-digit code to describe the possible options available for each benefits component. The rules shown are applicable to the highlighted benefits component in the BC Code field of the form. BC_Rule_Code from the P2K_BE_BC_RULES table is a mandatory 2-character numeric field provided by High Line.

Seq #: Sequence specifies the order in which the Benefits or Payroll Calculation program will calculate the benefits components. Component_Sequence is a mandatory 5-character numeric field provided by High Line.

Description: The component description is a brief explanation of the benefits component code highlighted. Description is an optional 50-character alphanumeric field either provided by High Line or that you may manually enter.

BC Action: This is the action performed by this benefits component. BC_Action is an optional fixed lexicon (X_BC_Action) you may use to look up the value.

Adjusted Amount: This is the amount to be adjusted for the remittance report. Adjustment_Amount is an optional 18-digit numeric field you may manually enter.

Amount: This is the value of the person's coverage component amount. Amount is an optional 18-digit numeric field that is system populated.