UNENROLL EMPLOYEE BENEFIT ELECTIONS
Back to current versionRestore this version

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
#
NameBeg
Pos
End
Pos
Constant
Value
Derivation
Expression
Notes
00HEADER RECORD00 Dummy record to skip the file header
11BEL.BPN_ID.PLAN_CODE310 P2K_SMGLX(‘GWRS_PLAN_TRNSLT’,~)Lexicon will translate the Policy number in the file to a Plan Code
12BEL.EEM_ID.EID_ID.PERSON_CODE4655 LPAD(~,11,’0’)This derivation expression is temporary until the EE # length has been finalized.
13BEL.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
14BEL.ELECTION_STATUS-1-1 90 Lexicon value for ‘Remove’
15BEL.BCG_ID.COVERAGE_CODE310 P2K_SMGLX(‘GWRS_PLAN_TRNSLT’,~)Lexicon will translate the Policy number in the file to an eP Plan Coverage Code
16BELC.BBC_ID.BC_CODE-1-1 B1000
17BELC.F_AMOUNT_OVERRIDE120123TRUECASE When (:BELC.F_AMOUNT_OVERRIDE)=’0000’ then ‘TRUE’ else ‘FALSE’ endOnly process records which contain 0000, this indicates an unelection
18BEL.BE_EFFECTIVE_DATE234 241 NLV2(~,(to_char(to_date(rtrim(~),’YYYMMDD’),’DD-Mon-YYYY’)),’01-Jan-0001’)
20TRAILER RECORD00 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.