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|Edit:Internal.LOADING+ELECTIONS+ONLY] 	
[{InsertPage page='Internal.LOADING+ELECTIONS+ONLY' default='Click to create a new notes page'}]