This is a sample of theminimum set up required to load elections with a BC code value via LBEN.
- The load file in the sample is a comma delimited format, but fixed position files are also supported.
- If 'Approval Required' has been set up on IBPN, the approval process must be established on IDAP prior to the load taking place.
- Loading benefits is limited to only the current employment. This can include employments with a termination date.
- This interface will only allow 1 BC code to be updated. If more than 1 BC code is to be populated - the LBEN process cannot be used.
SAMPLE INTERFACE
| Rec # | Field # | Name | Beg Pos | End Pos | Constant Value | Derivation Expression | Notes |
|---|---|---|---|---|---|---|---|
| 10 | 1 | HEADER RECORD* | 0 | 0 | (Optional) If there is a header record in the file than a header field must be defined in the interface. | ||
| 30 | 1 | BEL.BPN_ID.PLAN_CODE | -1 | -1 | |||
| 30 | 2 | BEL.EEM_ID.EID_ID.PERSON_CODE | -1 | -1 | |||
| 30 | 3 | BEL.EEM_ID.TERMINATION_DATE | -1 | -1 | '' | The constant value of two quotation marks (no space) is used to determine a NULL termination date which will be the ACTIVE employment | |
| 30 | 4 | BEL.ELECTION_STATUS | -1 | -1 | '80-Declinded' or '90-Remove' can also be used. '00-Not yet Elected' will result in no changes occuring to the record and should not be used. | ||
| 30 | 5 | BEL.BCG_ID.COVERAGE_CODE | -1 | -1 | |||
| 30 | 6 | BELC.BBC_ID.BC_CODE | -1 | -1 | |||
| 30 | 7 | BELC.AMOUNT_OVERRIDE | -1 | -1 | The AMOUNT_OVERRIDE is used when loading values into an enrollment record and not the AMOUNT field. | ||
| 30 | 8 | BEL.BE_EFFECTIVE_DATE | -1 | -1 | |||
| 30 | 9 | BEL.F_QUALIFIER*** | -1 | -1 | TRUE | DECODE(~,'Y','TRUE','FALSE' | (Optional) The LMTD will use this field to determine if the record qualifies for this interface. If the value returned in the derivation does not match the value in the constant field than the record will be bypassed and not loaded. |
| 70 | 1 | TRAILER RECORD** | 0 | 0 | (Optional)If there is a trailer record in the file than a trailer field must be defined in the interface. |
