Here is an example of an interface that was done for a specific client. The load file is a fixed format, and is used to load employee elections and component amounts into IBEL.
| Rec # | Field # | Name | Beg Pos | End Pos | Constant Value | Derivation Expression | Notes |
|---|---|---|---|---|---|---|---|
| 0 | 0 | HEADER RECORD* | 0 | 0 | Since there is 1 header record in the file, one field must be defined in the interface for the header record. | ||
| 1 | 1 | BEL.BPN_ID.PLAN_CODE | 3 | 15 | P2K_SMGLX('GWRS_PLAN_TRNSLT',~) | The derivation will translate the policy number in the file to the plan code using a user defined lexicon. | |
| 1 | 2 | BEL.EEM_ID.EID_ID.PERSON_CODE | 46 | 55 | LTRIM(~,'0') | The person code will be trimmed of any leading zeros. | |
| 1 | 3 | BEL.ELECTION_STATUS | -1 | -1 | 00 | The election status will be hard coded to Not Yet Elected, LBEN will then elect and enroll the employee. Since this field does not have a value within the file, it has been defined with -1. | |
| 1 | 4 | BEL.BCG_ID.COVERAGE_CODE | -1 | -1 | P2K_SMGLX('GWRS_PLAN_TRNSLT',~) | Since both coverage code and plan code are the same for these plans, the derivation expression from plan code field may be used. Since this field does not have a value within the file, it has been defined with -1. | |
| 1 | 5 | BELC.BBC_ID.BC_CODE | -1 | -1 | B1000 | Hard coded to B1000 so the system know which BC Code to update. Since this field does not have a value within the file, it has been defined with -1. | |
| 1 | 6 | BELC.AMOUNT_OVERRIDE | 120 | 123 | TO_NUMBER(~)/10 | This field will pick up the amount from the flat file. | |
| 1 | 7 | BEL.F_QUALIFIER*** | -1 | -1 | TRUE | CASE when (:BEL.BPN_ID.PLAN_CODE) ='99999-05' then 'FALSE' when (:BEL.BPN_ID.PLAN_CODE) = '99999-02' then 'FALSE' else 'TRUE' end | This derivation will ensure that if the wrong file is selected (i.e.: file for 401A policies) the records will not qualify. The records will only qualify if the value in the BEL.BPN_ID.PLAN_CODE field does not match 99999-02 or 99999-05. |
| 2 | 0 | TRAILER RECORD** | 0 | 0 | Since there is 1 trailer record in the file, one field must be defined in the interface for the trailer record. |
- *Record 0, Field 0 must have a Record Type of 'Header Record'
- **Record 2, Field 0 must have a Record Type of 'Trailer Record'
- ***Record 1, Field 7 must have a Record Type of 'Qualify Record'
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation