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 4 added 20 lines
| 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
At line 7 changed one line
|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| 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
At line 19 changed 3 lines
;:*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'
;:*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"
At line 47 added 3 lines
This page (revision-10) was last changed on 26-Nov-2021 10:22 by jtolentinoTop