Coshocton, East Liverpool, Saint John/Providence Medical - HR Simplified COBRA feed setup

Client: PrimeHealthcare (Saint John/Providence Medical)
Facility: Coshocton, East Liverpool (Ohio Valley/River Valley)
Company template:
NEW HRSimplified_COBRA Coverage
NEW HRSimplified_COBRA Participant
NEW HRSimplified_COBRA DEPENDENT
Export date: 1/31/18

Hello Development Team,

I need some assistance with building this HR Simplified COBRA feed as they require configuration in the backend. The new acquired facilities, Coshocton, East Liverpool, and Saint John/Providence Medical (found under PrimeHealthcare) need to be added to the existing HR Simplified COBRA global feeds. I started with Coshocton as part of testing to be sure carrier approves the file before working on the rest of other facilities. Their structure appears a bit different than the existing facilities that were built in the past by development. I have already asked them for coverage and carrier codes, but they could only provide the description of each on the latest structure for mapping. They are well aware that we will send them with values found on the structure and will accept this during testing.

As long as carrier system can read and load the data, that's all it matters. So far I have cloned the participant, coverage, and dependent templates from existing facility that is live. Data transformed the coverage, carrier, and divisions to match structure. All active plans selected for medical, dental, vision, and FSA. This all has been done for Coshocton. I exported the coverage file, but the coverage tiers are coming out blank. There are other settings I'm concern with especially the Current Election From Month and Current Election To Month under template settings. Existing facilities either have it on July or January although their Plan effective date is 1/1/2016. Coshocton and new facilities have the plan effective date as 11/1/2016 and FSA as 1/1/18.

Wanted to point this out in case it impacts how data being fetch on the carrier COBRA file. Once everything goes through and approve for Coshocton by carrier, I can do the same by cloning Coshocton COBRA templates to new facilities. Attached is the latest structure. Let me know if you need additional info.

Thank you,

Alex Prime EBS Account Structure 011718.xlsx

CC: Van Nguyen Amit Thorve

2/19/18 - File exported with coverage level. Secured email npm, pt, and en files to carrier to test. Advised they contain actual data and to load once approve so we can be prepared for the next file and to keep flag intact.