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 |
|---|---|---|---|---|---|---|---|
| 1 | 1 | HEADER RECORD* | 0 | 0 | (Optional) If there is a header record in the file than a header field must be defined in the interface. This field must have a record type of "Header" | ||
| 30 | 1 | BEL.BPN_ID.PLAN_CODE | -1 | -1 | |||
| 30 | 2 | BEL.EEM_ID.EID_ID.PERSON_CODE | -1 | -1 | |||
| 30 | 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 | |
| 30 | 4 | BEL.ELECTION_STATUS | -1 | -1 | To update employee enrollments records should be loaded with a value of "11-Elected". These records will use the IBEL logic to change the status to "01-Enrolled". "80-Declinded" or "90-Remove" can also be used to remove employees from coverage's. "00-Not yet Elected" will result in no changes occurring to the record and should not be used. | ||
| 30 | 5 | BEL.BCG_ID.COVERAGE_CODE | -1 | -1 | |||
| 30 | 6 | BEL.F_QUALIFIER*** | -1 | -1 | TRUE | DECODE(~,'Y','TRUE','FALSE') | (Optional) The LMTD will use this field to determine if the record qualifies for this interface. If the value returned in the derivation does not match the value in the constant field than the record will be bypassed and not loaded. |
| 70 | 1 | TRAILER RECORD** | 0 | 0 | (Optional)If there is a trailer record in the file than a trailer field must be defined in the interface. |
- *Record 0, Field 0 must have a Record Type of "Header Record". There should be 1 record in IDIF for each header record in the file
- **Record 2, Field 0 must have a Record Type of "Trailer Record". There should be 1 record in IDIF for each trailer record in the file
- ***Record 1, Field 5 must have a Record Type of "Qualify Record"
This interface format is a sample of client specific set up used to load a source file for elections only.
| 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"
