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 an eP 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. [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.UNENROLL EMPLOYEE BENEFIT ELECTIONS] [{InsertPage page='Internal.UNENROLL EMPLOYEE BENEFIT ELECTIONS' default='Click to create a new discussion page'}] }]