This interface format is used to load a source file for un-enrolling employee benefit elections. The file will be loaded into the P2K_BE_ELECTIONS table (IBEL).
Rec # | Field # | Name | Beg Pos | End Pos | Constant Value | Derivation Expression | Notes |
---|---|---|---|---|---|---|---|
0 | 0 | HEADER RECORD | 0 | 0 | Dummy record to skip the file header | ||
1 | 1 | BEL.BPN_ID.PLAN_CODE | 3 | 10 | P2K_SMGLX(‘GWRS_PLAN_TRNSLT’,~) | Lexicon will translate the Policy number in the file to a Plan Code | |
1 | 2 | BEL.EEM_ID.EID_ID.PERSON_CODE | 46 | 55 | LPAD(~,11,’0’) | This derivation expression is temporary until the EE # length has been finalized. | |
1 | 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 | |
1 | 4 | BEL.ELECTION_STATUS | -1 | -1 | 90 | Lexicon value for ‘Remove’ | |
1 | 5 | BEL.BCG_ID.COVERAGE_CODE | 3 | 10 | P2K_SMGLX(‘GWRS_PLAN_TRNSLT’,~) | Lexicon will translate the Policy number in the file to an eP Plan Coverage Code | |
1 | 6 | BELC.BBC_ID.BC_CODE | -1 | -1 | B1000 | ||
1 | 7 | BELC.F_AMOUNT_OVERRIDE | 120 | 123 | TRUE | CASE When (:BELC.F_AMOUNT_OVERRIDE)=’0000’ then ‘TRUE’ else ‘FALSE’ end | Only process records which contain 0000, this indicates an unelection |
1 | 8 | BEL.BE_EFFECTIVE_DATE | 234 | 241 | NLV2(~,(to_char(to_date(rtrim(~),’YYYMMDD’),’DD-Mon-YYYY’)),’01-Jan-0001’) | ||
2 | 0 | TRAILER RECORD | 0 | 0 | Dummy record to skip the file trailer |
The qualifier will return TRUE for any record in the file that has 0000 in the amount field. This indicates an enrolled record in IBEL that will be changed to unenrolled. When processed by LBEN, the record in IBEL/IBEN will show with a status of To Be Elected, there will be no Coverage Code and B1000 will be removed from IBEN, IBEL will not show an amount field.