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

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
8 26-Nov-2021 10:22 2 KB Kevin Higgs to previous
7 26-Nov-2021 10:22 4 KB jtolentino to previous | to last Changed Apostrophe on Rec 30, Field 1 of first IDIF.
6 26-Nov-2021 10:22 4 KB jtolentino to previous | to last Added approvals, loading requirements, and override information.
5 26-Nov-2021 10:22 4 KB rmorrell to previous | to last
4 26-Nov-2021 10:22 4 KB khiggs to previous | to last
3 26-Nov-2021 10:22 2 KB JEscott to previous | to last
2 26-Nov-2021 10:22 2 KB RForbes to previous | to last
1 26-Nov-2021 10:22 2 KB JEscott to last

Page References

Incoming links Outgoing links
LOADING ELECTIONS AND COMPONENT AMOUNTS INTO IBEL
LOADING ELECTIONS AND COMPONENT AMOUNTS INTO IBEL

Version management

Difference between version and

At line 4 changed 15 lines
|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| 3| 15| |{{{P2K_SMGLX('GWRS_PLAN_TRNSLT',~)}}}|The derivation will translate the policy number in the file to the plan code using a user defined lexicon.
|1| 2| BEL.EEM_ID.EID_ID.PERSON_CODE| 46| 55| |{{{ LTRIM(~,'0')}}}|The person code will be trimmed of any leading zeros.
|1| 3| BEL.ELECTION_STATUS| -1 |-1| 00| | The election status will be hard coded to Not Yet Elected, LBEN will then elect and enroll the employee. Since this field does not have a value within the file, it has been defined with -1.
|1| 4| BEL.BCG_ID.COVERAGE_CODE| -1| -1| |{{{ P2K_SMGLX('GWRS_PLAN_TRNSLT',~)}}}| Since both coverage code and plan code are the same for these plans, the derivation expression from plan code field may be used. Since this field does not have a value within the file, it has been defined with -1.
|1| 5| BELC.BBC_ID.BC_CODE| -1| -1| B1000| | Hard coded to B1000 so the system know which BC Code to update. Since this field does not have a value within the file, it has been defined with -1.
|1| 6 |BELC.AMOUNT_OVERRIDE |120| 123| |{{{ TO_NUMBER(~)/10}}}|This field will pick up the amount from the flat file.
|1| 7| BEL.F_QUALIFIER*** |-1| -1| TRUE| {{{ CASE when
(:BEL.BPN_ID.PLAN_CODE) ='99999-05'
then 'FALSE'
when (:BEL.BPN_ID.PLAN_CODE) =
'99999-02'
then 'FALSE'
else 'TRUE'
end }}}|This derivation will ensure that if the wrong file is selected (i.e.: file for 401A policies) the records will not qualify. The records will only qualify if the value in the BEL.BPN_ID.PLAN_CODE field does not match 99999-02 or 99999-05.
|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 translate the policy number in the file to the plan code using a user defined lexicon.
|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| 00| | The election status will be hard coded to Not Yet Elected, LBEN will then elect and enroll the employee. Since this field does not have a value within the file, it has been defined with -1.
|1| 5| BEL.BCG_ID.COVERAGE_CODE| -1| -1| |{{{ P2K_SMGLX('GWRS_PLAN_TRNSLT',~)}}}| Since both coverage code and plan code are the same for these plans, the derivation expression from plan code field may be used. Since this field does not have a value within the file, it has been defined with -1.
|1| 6| BELC.BBC_ID.BC_CODE| -1| -1| B1000| | Hard coded to B1000 so the system know which BC Code to update. Since this field does not have a value within the file, it has been defined with -1.
|1| 7 |BELC.AMOUNT_OVERRIDE |-1| -1| |{{{ TO_NUMBER(~)/10}}} |This field will pick up the amount from the flat file.
|1| 8 |BEL.BE_EFFECTIVE_DATE|-1|-1| |{{{NLV2(~,(to_char(to_date(rtrim(~),’YYYMMDD’),’DD-Mon-YYYY’)),’01-Jan-0001’)}}} |
|1| 9| BEL.F_QUALIFIER*** |-1| -1| TRUE| {{{ CASE
When (:BELC.AMOUNT_OVERRIDE)=’0000’
then ‘FALSE’
else ‘TRUE’
end }}}|Do not process records with zeros – these are for unenrollments
At line 23 changed one line
;:***Record 1, Field 7 must have a Record Type of 'Qualify Record'
;:***Record 1, Field 9 must have a Record Type of 'Qualify Record'
At line 26 removed 2 lines
[{If var='loginstatus' contains 'authenticated'
At line 29 changed 4 lines
![Discussion|Edit:Internal.LOADING+ELECTIONS+AND+COMPONENT+AMOUNTS+INTO+IBEL]
[{InsertPage page='Internal.LOADING+ELECTIONS+AND+COMPONENT+AMOUNTS+INTO+IBEL' default='Click to create a new discussion page'}]
}]
![Notes|Edit:Internal.LOADING+ELECTIONS+AND+COMPONENT+AMOUNTS+INTO+IBEL]
[{InsertPage page='Internal.LOADING+ELECTIONS+AND+COMPONENT+AMOUNTS+INTO+IBEL' default='Click to create a new notes page'}]
This page (revision-8) was last changed on 26-Nov-2021 10:22 by Kevin HiggsTop