This page (revision-8) was last changed on 26-Nov-2021 10:22 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
8 26-Nov-2021 10:22 2 KB Kevin Higgs to previous
7 26-Nov-2021 10:22 4 KB jtolentino to previous | to last Changed Apostrophe on Rec 30, Field 1 of first IDIF.
6 26-Nov-2021 10:22 4 KB jtolentino to previous | to last Added approvals, loading requirements, and override information.
5 26-Nov-2021 10:22 4 KB rmorrell to previous | to last
4 26-Nov-2021 10:22 4 KB khiggs to previous | to last
3 26-Nov-2021 10:22 2 KB JEscott to previous | to last
2 26-Nov-2021 10:22 2 KB RForbes to previous | to last
1 26-Nov-2021 10:22 2 KB JEscott to last

Page References

Incoming links Outgoing links
LOADING ELECTIONS AND COMPONENT AMOUNTS INTO IBEL
LOADING ELECTIONS AND COMPONENT AMOUNTS INTO IBEL

Version management

Difference between version and

At line 1 added 16 lines
Here is the minimum set up required to load elections with a BC code value via [LBEN]. The load file is a comma delimited format.
||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.
This page (revision-8) was last changed on 26-Nov-2021 10:22 by Kevin HiggsTop