This is version 1 2 3 4 5 6 7 8 9 10 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

This interface format is used to load a source file for elections only, there are no election components updated with this file or interface. The elections 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			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	-1	-1		P2K_SMGLX('GWRS_PLAN_TRNSLT',~)	The derivation will decode the policy number to the plan code.
1	2	BEL.EEM_ID.EID_ID.PERSON_CODE	-1	-1		LTRIM(~,'0')	The person code will be trimmed of any leading zeros
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	11		The election status will be hard coded to Elected, LBEN will then enroll the employee.
1	5	BEL.BCG_ID.COVERAGE_CODE	-1	-1		P2K_SMGLX('GWRS_PLAN_TRNSLT',~)	The derivation will decode the original value from the plan code field to the actual coverage code.
1	6	BEL.F_QUALIFIER***	-1	-1	TRUE	CASE when (:BEL.BPN_ID.PLAN_CODE) ='99999-05' then 'TRUE' when (:BEL.BPN_ID.PLAN_CODE) = '99999-02' then 'TRUE' else 'FALSE' end	The LMTD will use this field to determine if the record qualifies for this interface. The derivation will check to make the original value in BEL.BPN_ID.PLAN_CODE is either 99999-02 or 99999-05, if it is not then the record will be bypassed.
2	0	TRAILER RECORD**	0	0

*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 5 must have a Record Type of "Qualify Record'

---

Notes #

Click to create a new notes page