-
Type:
Analysis
-
Status: In Review
-
Priority:
High
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:Production
-
Module:BenAdmin
-
Reported by:EDI
-
Company:Rogers Memorial Hospital
-
Item State:Development - In Analysis
-
Severity:Simple
we have several employees that are exporting on the file but their plan information is not exporting. Example - 394906553 Alan,Joshua
my build/mapping appears correct. the enrollment looks correct. can you assist on why these records are not exporting the plan information.
Refer to positions 238 - 269 from the attached layout and prod file. Your assistance is appreciated.
cc: Amanda Hagan
PBEFL89_P_UHC_RogerMemorialHosp_201711300759_53658923049.txt 2017 UMR Standard Eligibility File - 1500 bytes.doc
Field | Original Value | New Value |
---|---|---|
Assignee | Satya [ ID10004 ] | Prashant Samal [ prashant.samal ] |
Status | New [ 10508 ] | In Analysis [ 10008 ] |
Status | In Analysis [ 10008 ] | In Review [ 10203 ] |
Assignee | Prashant Samal [ prashant.samal ] | Kevin Hale [ kevin.hale ] |
Assignee | Kevin Hale [ kevin.hale ] | Amanda Hagan [ amanda.hagan ] |
Assignee | Amanda Hagan [ amanda.hagan ] | Jyoti Mayne [ jyoti.mayne ] |
Assignee | Jyoti Mayne [ jyoti.mayne ] | Shailendra Honrao [ shailendra.honrao ] |
Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
-
- Time Spent:
- 2h
-
understanding of the problem statement
discussion with jyoti
analysis of issue with the help of jyoti
draft comment and get it reviewed by jyoti
Assignee | Shailendra Honrao [ shailendra.honrao ] | Kevin Hale [ kevin.hale ] |
Remaining Estimate | 0h [ 0 ] | |
Time Spent | 2h [ 7200 ] | |
Worklog Id | 94211 [ 94211 ] |
Assignee | Kevin Hale [ kevin.hale ] | Shailendra Honrao [ shailendra.honrao ] |
-
- Time Spent:
- 8h
-
restore company,
data analysis
generate script to scan data
discussion with jyoti
Assignee | Shailendra Honrao [ shailendra.honrao ] | Kevin Hale [ kevin.hale ] |
Time Spent | 2h [ 7200 ] | 10h [ 36000 ] |
Worklog Id | 94580 [ 94580 ] |
Assignee | Kevin Hale [ kevin.hale ] | Amanda Hagan [ amanda.hagan ] |
Assignee | Amanda Hagan [ amanda.hagan ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
-
- Time Spent:
- 2h
-
Checked current year and 2018 policy numbers. On current and future export.
Time Spent | 10h [ 36000 ] | 12h [ 43200 ] |
Worklog Id | 95032 [ 95032 ] |
Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Swapnil Eksambekar [ swapnil.eksambekar ] |
Time Spent | 12h [ 43200 ] | 13h [ 46800 ] |
Worklog Id | 95150 [ 95150 ] |
Attachment | Copy of K35_T_EBSBenefits_Nasco_201712051214_24014469540 (003).xlsx [ 69566 ] |
Comment |
[ Hi [~Kevin.Hale] and [~amitthorve], In a previous file the location codes were showing for everyone. [^Copy of K35_T_EBSBenefits_Nasco_201712051214_24014469540 (003).xlsx]. There was an issue on this file with the wrong effective date showing and we created ticket Wt-12473 to that corrected. ] |
Attachment | Copy of K35_T_EBSBenefits_Nasco_201712051214_24014469540 (003).xlsx [ 69566 ] |
Time Spent | 13h [ 46800 ] | 13.25h [ 47700 ] |
Worklog Id | 96480 [ 96480 ] |
Time Spent | 13.25h [ 47700 ] | 13.5h [ 48600 ] |
Worklog Id | 96480 [ 96480 ] |
Time Spent | 13.5h [ 48600 ] | 14.5h [ 52200 ] |
Worklog Id | 96507 [ 96507 ] |
-
- Time Spent:
- 2.5h
-
Discussion with aniruddha
Verification of policy numbers
Assignee | Swapnil Eksambekar [ swapnil.eksambekar ] | Amit Thorve [ amitthorve ] |
Time Spent | 14.5h [ 52200 ] | 17h [ 61200 ] |
Worklog Id | 96613 [ 96613 ] |
Comment |
[ Hello [~amitthorve], We have verified 2018 policy numbers when flag is set to NO , They are coming as expected . Thanks, Swapnil e. CC-[~aniruddha.dev][~rakeshr][~hrishikesh.deshpande] ] |
Time Spent | 17h [ 61200 ] | 23h [ 82800 ] |
Worklog Id | 96757 [ 96757 ] |
Transition | Time In Source Status | Execution Times |
---|
|
3h 25m | 1 |
|
1h 55m | 1 |
Hello Kevin Hale,
There is no issue with the build/mapping.
You have mapped Health Tier Policy No. in the mapping between positions 238 - 269 in layout on production file.
After the verification from the backend, it is observed that Currently these employees do not have Health Tier Policy No in the system.
Policy numbers which were active from 01/01/2017 - 12/31/2017 were termed with never effective date of 12/31/2016 on 11/16/2017.
And the new policy no's for the plan are made effective from 01/01/2018 along with employee's change effective date of 01/01/2018
Therefore presently these employees do not have policy numbers in the system due to which the plan information is blank on the files.
Thanks
S Prashant.
__________________________________________
Kevin Hale