This page (revision-10) was last changed on 26-Nov-2021 10:22 by jtolentino

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
10 26-Nov-2021 10:22 3 KB jtolentino to previous Added approval information for benefit plans, and loading requirements.
9 26-Nov-2021 10:22 3 KB khiggs to previous | to last
8 26-Nov-2021 10:22 3 KB khiggs to previous | to last
7 26-Nov-2021 10:22 3 KB khiggs to previous | to last
6 26-Nov-2021 10:22 3 KB khiggs to previous | to last
5 26-Nov-2021 10:22 1 KB JEscott to previous | to last
4 26-Nov-2021 10:22 1 KB RForbes to previous | to last
3 26-Nov-2021 10:22 1 KB JEscott to previous | to last
2 26-Nov-2021 10:22 1 KB JEscott to previous | to last
1 26-Nov-2021 10:22 1 KB JEscott to last

Page References

Incoming links Outgoing links
LOADING ELECTIONS ONLY
LOADING ELECTIONS ONLY

Version management

Difference between version and

At line 3 removed 7 lines
This is a sample of the minimum set up required to load employee benefit coverages using [LBEN]. All the values will be derived from the coverage code indicated in the file. This load sample does not allow individual benefit components to be updated. The value from defaulting from the [IBPN] will be used. In this sample the interface will be expecting a .csv containing no more than 5 fields.
If Approval Required is set to 'Approval Required' on IBPN, an approval is needed before a plan is enrolled.
__Note__: Loading is limited to only the current active employment only. Loading will also not work if there is a Termination Date.
At line 4 added one line
| 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"
At line 13 changed 4 lines
|30| 3| 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-Declined" or "90-Remove" can also be used to remove employees from coverages. "00-Not yet Elected" will result in no changes occurring to the record and should not be used.
|30| 4| BEL.BCG_ID.COVERAGE_CODE| -1| -1| | |
|30| 5| BEL.BE_EFFECTIVE_DATE| -1| -1| | |
|30| 6| BEL.EEM_ID.TERMINATION_DATE|0|0| | |The constant value of two quotation marks (no space) can be used to determine a NULL termination date which will be the ACTIVE employment. Note this field does not need to be included on the file.
|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.
At line 13 added 3 lines
;:*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"
At line 17 added one line
At line 31 changed 2 lines
|30| 6| BEL.BE_EFFECTIVE_DATE| -1| -1| | |
|1| 7| BEL.F_QUALIFIER***| -1| -1| TRUE| {{{ CASE when
|1| 6| BEL.F_QUALIFIER***| -1| -1| TRUE| {{{ CASE when
This page (revision-10) was last changed on 26-Nov-2021 10:22 by jtolentinoTop