CMS FFM Plan Management Copy and Paste in Templates Guide
i
Table of Contents
1 Copying and Pasting in Plan Management Templates ............................................................1
1.1 General Copy/Paste Recommendations ........................................................................1
1.2 Whole Template Copy/Paste Recommendations ..........................................................1
1.2.1 Column Level Copy/Paste Recommendations ...................................................1
1.2.2 Row Level Copy/Paste Recommendations ........................................................1
1.2.3 Cell Level Copy/Paste Recommendations .........................................................1
2 Network ID Template ............................................................................................................3
3 Prescription Drug Template ...................................................................................................4
3.1 Formulary Tiers Tab ....................................................................................................4
3.2 Drug List Tab ..............................................................................................................4
4 Service Area Template ..........................................................................................................5
5 Rate Tables Template ............................................................................................................6
5.1 Issuers in Individual Rated States.................................................................................6
5.2 Issuers in Family Tiered States ....................................................................................7
5.3 Issuers Submitting Medical and Dental Rates Combined .............................................8
6 Rating Business Rules Template .......................................................................................... 12
7 Plans & Benefits Template .................................................................................................. 14
7.1 Benefits Package Sheet .............................................................................................. 14
7.2 Cost Share Variances Sheet ....................................................................................... 14
8 ECP / Network Adequacy Template .................................................................................... 18
8.1 Facility ECPs Tab ...................................................................................................... 18
8.2 IndividualProviders(NA) Tab .................................................................................... 19
8.3 FacilityProviders(NA) Tab ........................................................................................ 19
9 Transparency in Coverage Template .................................................................................... 19
9.1 Issuer Level Data Tab ................................................................................................ 19
9.2 Plan Level Data Tab .................................................................................................. 20
List of Figures
Figure 1: Network Template .........................................................................................................3
Figure 2: Prescription Drug Template – Formulary Tiers Worksheet ...............................................4
Figure 3: Service Area Template ...................................................................................................5
Figure 4: Rate Tables Template with Age Bands and No Preference Tobacco Option .......................6
Figure 5: Rate Tables Template with Age Bands and Tobacco/Non-Tobacco Option ........................7
Figure 6: Rate Tables Template – Family Tiering Columns .............................................................7
Figure 7: Rate Tables Template – Individual Rate and Couple Fields ...............................................7
Figure 8: Rating Business Rules Template – Relationship to Primary Pop-up ................................. 12
Figure 9: Rating Business Rules Template – Relationship to Primary Pop-Up for Medical Plans with
“Child, Stepson or Stepdaughter, and Foster Child” selected
......................................................... 13
Figure 10: Plan & Benefits Template – Plan Level Data ............................................................... 14
Figure 11: Plan & Benefits Template – Bottom EHB Table........................................................... 14
Figure 12: Sample Excel Error Message ...................................................................................... 15
Figure 13: Cost Share Variance Sheet – Benefits Template Sample Columns ................................. 15
Figure 14: Subsection of Benefits Template ................................................................................. 15
Figure 15: Benefits Template Deductible Columns Selected for Copy ........................................... 16