-
Type:
Support Activity
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Support Task Type:Configuration
-
Environment:Production
-
Reported by:EDI
-
Company:Dakotaland
-
Module:BenAdmin - Customization
-
Issue Importance:Must Have
-
Severity:Simple
Company Template: Lincoln_Life_Final
Affected Columns: OLI Cvgs, OAD Cvgs, OSLI Cvgs, OSAD Cvgs, OCLI Cvgs
Leading values: OLI-, OAD-, OSLI-, OSAD-, OCLI-
Export Date: 1/3/18
Hi Vinayak Kulkarni,
Sorry I finally have the time to test and open a ticket for this file. This Lincoln format is different than other Lincoln files that were built for other clients. I had another ticket a while ago JIRA# WT-11672 regarding a lincoln macro to use, but Amit had said it will pass all enrolled Life coverages on the same column with commas separating them. This won't work for my file, because the affected columns are spread out differently.
I was also suggested to try the check box "Do Not Apply Padding For Blank Value" under the Edit Sub Template Field, but the leading value are still coming out on every row although the employee is not enrolled in the plan. Is there a way to only pass leading value if enrolled in the benefit? If this is possible, the file will be ready to go weekly. In the meantime I've been removing them manually which only takes me about a few minutes to do before posting to the carrier.
See screenshot for comparison between a good file and bad file. Let me know if you need additional info.
Thank you,
Alex
| Field | Original Value | New Value |
|---|---|---|
| Description |
*Company Template:* Lincoln_Life_Final *Affected Columns:* OLI Cvgs, OAD Cvgs, OSLI Cvgs, OSAD Cvgs, OCLI Cvgs *Leading values:* OLI-, OAD-, OSLI-, OSAD-, OCLI- *Export Date:* 1/3/18 Hi [~Vinayak.Kulkarni], Sorry I finally have the time to test and open a ticket for this file. This Lincoln format is different than other Lincoln files that were built for other clients. I had another ticket a while ago JIRA# I was also suggested to try the check box "Do Not Apply Padding For Blank Value" under the *Edit Sub Template Field*, but the leading value are still coming out on every row although the employee is not enrolled in the plan. Is there a way to only pass leading value if enrolled in the benefit? If this is possible, the file will be ready to go weekly. In the meantime I've been removing them manually which only takes me about a few minutes to do before posting to the carrier. See screenshot for comparison between a good file and bad file. |
*Company Template:* Lincoln_Life_Final *Affected Columns:* OLI Cvgs, OAD Cvgs, OSLI Cvgs, OSAD Cvgs, OCLI Cvgs *Leading values:* OLI-, OAD-, OSLI-, OSAD-, OCLI- *Export Date:* 1/3/18 Hi [~Vinayak.Kulkarni], Sorry I finally have the time to test and open a ticket for this file. This Lincoln format is different than other Lincoln files that were built for other clients. I had another ticket a while ago JIRA# I was also suggested to try the check box "Do Not Apply Padding For Blank Value" under the *Edit Sub Template Field*, but the leading value are still coming out on every row although the employee is not enrolled in the plan. Is there a way to only pass leading value if enrolled in the benefit? If this is possible, the file will be ready to go weekly. In the meantime I've been removing them manually which only takes me about a few minutes to do before posting to the carrier. See screenshot for comparison between a good file and bad file. Let me know if you need additional info. Thank you, Alex |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Attachment | screenshot-1.png [ 71325 ] |
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Alex Nguyen [ alexn ] |
| Resolution | Done [ 10000 ] | |
| Status | In Progress [ 3 ] | Resolved [ 5 ] |
Thank you so much, Vinayak Kulkarni. For testing, I tried both check boxes for the OCLI and it's coming out correctly on file. Sorry I must have missed the 2nd option the last time we discussed. I'm sure the other columns will also work.
Alex
| Status | Resolved [ 5 ] | Closed [ 6 ] |
| Link | This issue relates to EDI-1944 [ EDI-1944 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
3h 50m | 1 |
|
1m 58s | 1 |
|
14h 54m | 1 |
Hi Alex Nguyen
Do Not Apply Padding for blank value will work only if Is padding required, please try making below highlighted change and save sub-template
Let us know if this doesn't work. Thanks.