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.

Remit Report: The Remittance Report field is a user-defined code uniquely identifying the report within the organization. Remit_Report_Code is a mandatory 16-character alphanumeric field you must manually enter.

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.

Unit: Unit identifies the organization to which the schedule is applied. Unit_Code is an optional 16-character alphanumeric field you may either manually enter or use the LOV (F9).

Group: Group identifies the organization to which the schedule is applied. Group_Code is an optional 16-character alphanumeric field you may either manually enter or use the LOV (F9).

BC: BC Code defines 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 the benefit components section.

: BC_Code is a mandatory 16-character alphanumeric field provided by High Line.

Rule: BC Rule is a 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 that is provided.

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 that is provided.

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.