-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:QA
-
Bug Type:Functional
-
Bug Severity:Medium
-
Level:Partner
-
Module:BenAdmin - Report
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
-
Browser:Google Chrome
-
Sprint:WT Sprint 36 - Bugs
Customization :
Customize Billing Report with Field Like as
SSN , FName, LName, Plan Design Name, Effective Date, Termination Date, Employee Cost , Employer Cost and Total Amount
Replication Steps :
1) Partner Login
2) Navigate up to Report -> Billing Report
3) Run Report
Issue: It throws DataSet error. If we un-mapped Date fields then report ran properly.
CC - Sachin Hingole
Hi
Verified this issue on Stage
Verified on company "JE Dunn For Hspl"
Verified with Mapping and without mapping of Date fields
Billing Reports are properly generating
WT-10739.xls
WT_10739.xls
Hence, Marking it as Ready for Production
cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande
Thank You !!
Priya Handepatil (Inactive)
added a comment - Hi
Verified this issue on Stage
Verified on company "JE Dunn For Hspl"
Verified with Mapping and without mapping of Date fields
Billing Reports are properly generating
WT-10739.xls WT_10739.xls
Hence, Marking it as Ready for Production
cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande
Thank You !! Good to go on Stage
CC - Sachin Hingole
Patch will move to stage with WT-8642.
Hi
Verified this issue on LB
Verified on company ""For Qa Fdu For Hspl"
Verified with Mapping and without mapping of Date fields
Billing Reports are properly generating
Billing Report 4.xls billing Report.xls Billing report2.xls Billing Report3.xls
Hence, Marking it as Ready for Stage
Thanks,
Priya Handepatil
CC:Sachin Hingole Prasad Pise Rakesh Roy
Priya Handepatil (Inactive)
added a comment - Hi
Verified this issue on LB
Verified on company ""For Qa Fdu For Hspl"
Verified with Mapping and without mapping of Date fields
Billing Reports are properly generating
Billing Report 4.xls billing Report.xls Billing report2.xls Billing Report3.xls
Hence, Marking it as Ready for Stage
Thanks,
Priya Handepatil
CC: Sachin Hingole Prasad Pise Rakesh Roy [~meghana joshi]
Sachin Hingole (Inactive)
added a comment - [~meghana joshi] 3c's :-
Concern:- Throws Data set error if Effective Date Fields exposed on Report
Cause :- Incorrect drop of temp. table for Enrollment fields
Correction:- Made conditional dropping of temp table for Enrollment fields
Affected File :- Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetBillingDetailsMonthly.StoredProcedure.sql
Affected Area :- Billing Details Report
Any of the enrollment fields(mentioned below) were throwing error when there was no selection made of Approved coverage fields.
Enrollment fields :-
-Qualifying Even Name
-Coverage tier label
-Health tier policy number
-Effective Date
-Termination Date
Approved coverage fields :-
-Applied Coverages
-Approved Coverages
-Approved Coverage Amount
-Enrollment Coverage Count
Tested Scenario :-
All above Enrollment as well Approved coverage fields with single and combinations
Jyoti Agrawal (Inactive)
added a comment - 3c's :-
Concern:- Throws Data set error if Effective Date Fields exposed on Report
Cause :- Incorrect drop of temp. table for Enrollment fields
Correction:- Made conditional dropping of temp table for Enrollment fields
Affected File :- Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetBillingDetailsMonthly.StoredProcedure.sql
Affected Area :- Billing Details Report
Any of the enrollment fields(mentioned below) were throwing error when there was no selection made of Approved coverage fields.
Enrollment fields :-
-Qualifying Even Name
-Coverage tier label
-Health tier policy number
-Effective Date
-Termination Date
Approved coverage fields :-
-Applied Coverages
-Approved Coverages
-Approved Coverage Amount
-Enrollment Coverage Count
Tested Scenario :-
All above Enrollment as well Approved coverage fields with single and combinations
Hi Jyoti Agrawal
I have verified this issue on Production
Verified on Company " TIBCO For HSPL"
Verified with Broker Login
Verified with Mapping of Date Fields
Test.xls
Verified with Unmapping of Date Fields
Test one.xls
Its working fine
Hence, Marking it as Production Complete
cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande [~meghana joshi]
Thank You !