US SAVINGS BONDS INTERFACE#

Required Set Up#

There is specific set up and processing required to ensure that Canadian Savings Bonds are calculated and reported correctly.

To run the required monthly report the only set up required is the interface format in IDIF and the benefit plan itself. You may also indicate a contact for an employee as a bond owner, coowner etc.

Step 1 - Define Plan Type in IBPT#

Define a 'Bonds' plan type. All U.S. Saving Bond plans under this plan type, under the selected reporting entity (or under a BLANK entity) will be reported if this plan type is selected when running the 'UBBD' function.

Step 2- Define Plan Definitions in IBPN#

A separate bond plan must be set up for each concurrent bond contribution that is permitted (e.g. If three bonds may be purchased simultaneously, three plan definitions are required.)

The series code (e.g. EE or I) must be entered in the Policy Number field for each coverage. A bond coverage must be set up for each series offered (e.g. EE and I series).

A bond coverage may be set up for each bond denomination (e.g. $50, $100, etc.). This is optional, as the denomination value may instead be entered on the employee's enrollment record (IBEN). An effective date split of the enrollment record (IBEN) is recommended upon a change in the denomination elected.

Bond plans do not have to be entered on the behalf schedule (IBSC), if the 'Not Scheduled' toggle is ON. This will allow the plans to be added to the benefit election record (IBEL) on an ad hoc basis.

Below is a list of the components that need to be reviewed in order to set up a bond plan :

  • B0010 Pre-process/Qualify UserCalc {optional}
  • B0020 Enrollment Base Date
  • B0030 Enrollment Effective Date Rule
  • B0040 Hiring Qualification {optional}
  • B0050 Qualifying Period {optional}
  • B0060 Roll Forward/Back Rule {optional}
  • B0070 Effective Date
  • B0080 Eligibility Base Date
  • B0090 Eligibility Date Rule
  • B0100 Hiring Qualification {optional}
  • B0110 Qualifying Period {optional}
  • B0120 Roll Forward/Back Rule {optional}
  • B0130 Eligible Date
  • B0150 Expire Base Date
  • B0160 Expire Date Rule
  • B0170 Termination Qualification {optional}
  • B0180 Continuation Period {optional}
  • B0200 Expire Date
  • B0210 Eligibility End Base Date
  • B0220 Eligibility End Date Rule
  • B0230 Termination Qualification {optional}
  • B0240 Continuation Period
  • B0250 Roll Forward/Back Rule {optional}
  • B0260 Eligibility End Date
  • B0270 Premium End Date
  • B0140 Premium Start Date

The following group of benefit components are available to calculate the bond amounts to be remitted for the plan. They are all mandatory.

  • B1300 Bond Denomination
  • B1305 Bond Purchase Price
  • B1310 Deduction Amount
  • B1320 Amount Available for Bond Purchase
  • B1330 Number of Bonds Purchased
  • B1340 Value of Bonds Purchased

Step 3 - Define Interface Format in IDIF#

If not already defined in the Interface Formats Definition (IDIF) screen, load the standard interface file format using the starter_idif_hl$bonds.sql script. Modify the standard BONDS file requirements using the IDIF function. Rename the code from HL$BONDS to a user-defined code.

Step 4 - Modify Employee Contacts in IECT#

If the bond is owned by an employee contact then this should be indicated on IECT. This is done by selecting Bond Owner as the Contact Type. The contact may be an owner, co-owner, etc. and this is indicated on IBRA or IBRP by the Bond Participation field.

The set up is now complete and the UBBD may now be run to process all of the Canadian Savings Bonds plans and produce the flat file to be remitted.


Report Parameters & Filters#

Report Parameters
Reporting Entity Multiple selection, and LOV available. The entity which will be sending the report to the Federal Reserve
Plan Type Mandatory, LOV available. Usually 'BONDS'
Bond Purchase Date Mandatory, Date, and LOV available. The 'Report Date' is the date printed in the file.
Pay Ending Date Mandatory, Date, and LOV available. Usually the last pay date processed.
Order Type Mandatory, Date, LOV available. Promotional or Regular
Series Designator Mandatory, Date, LOV available. Series EE or I, to be matched to the Plan Number
Which Address Mandatory, Date, LOV available. Should the Primary or Mailing address be used on the file?
Interface Code The interface code from IDIF to be used to format the flat file
Interface Directory Mandatory, text. Must be a directory on the server for which the current User (as signed onto the client's network) has write capability. For example the entry 'C:\TEMP' accesses the'TEMP' directory on the server, not the local directory for the computer terminal being used.
File Name Mandatory, text. Enter the name of the file that will be created in the Interface Directory specified.
Write or Append Mandatory, LOV available. If the file already exists should the current information overwrite it or append to it?
Exception Level Mandatory, LOV available. A 'trace' report of exception messages may be produced to assist in the testing phase. If necessary, choose from 0 - 9 (highest) level of trace. Please note that this is a voluminous report and will cause very slow performance.
Print Execution Run Log Mandatory, LOV available. The run log may be printed (Yes) or not (No).
Trial Mandatory, LOV available.The report may be run in trial mode (Yes) or update mode (No)

Report Filter
Entity Mandatory, LOV available. Limits the process to the entity specified.