| Prescription Drug Formulary Template | ||||||||||||||||
| All fields with an asterisk (*) are required. To validate the template, press the Validate button or Ctrl + Shift + V. To finalize, press Finalize button or Ctrl + Shift + F. | ||||||||||||||||
| Fields with an "#" indicate a field that would be moved or removed under this PRA package. | ||||||||||||||||
| Click the Create Formulary IDs button (or Ctrl + Shift + C) to create Formulary IDs. | ||||||||||||||||
| After creating Formulary IDs, select the ID from the drop down in Column A and 7 tiers will automatically be popoulated. | ||||||||||||||||
| Select how many tiers a formulary uses from Number of Tiers and unused rows (tiers) will be greyed out. | ||||||||||||||||
| Enter all RXCUIs on the Drug Lists sheet. To add more drug lists, click Add Drug List (Ctrl + Shift + A) and to delete the last drug list added press Delete Drug Lists (or Ctrl + Shift + D). | ||||||||||||||||
| HIOS Issuer ID* | ||||||||||||||||
| Issuer State* | ||||||||||||||||
| Formulary ID* Required: Select the Formulary ID |
Formulary URL* Required: Enter the Formulary URL |
Drug List ID* Required: Select the Drug List ID (from Drug Lists sheet) |
Number of Tiers* Required: Select the number of Tiers |
Drug Tier ID* Required: The template will populate a Drug Tier ID 1-7 |
Drug Tier Type* Required: Select all the Drug Types included in this tier |
1 Month In Network Retail Pharmacy Copayment*# Required: Enter a copayment amount |
1 Month In Network Retail Pharmacy Coinsurance*# Required: Enter a coinsurance amount |
1 Month Out of Network Retail Pharmacy Benefit Offered?*# Required: Does this tier offer 1 Month Out of Network Mail Order Pharmacy benefits? |
1 Month Out of Network Retail Pharmacy Copayment*# Required if Offered: Enter a copayment amount |
1 Month Out of Network Retail Pharmacy Coinsurance*# Required if Offered: Enter a coinsurance amount |
3 Month In Network Mail Order Pharmacy Benefit Offered?*# Required: Does this tier offer 3 Month In Network Mail Order Pharmacy benefits? |
3 Month In Network Mail Order Pharmacy Copayment*# Required if Offered: Enter a copayment amount |
3 Month In Network Mail Order Pharmacy Coinsurance*# Required if Offered: Enter a coinsurance amount |
3 Month Out of Network Mail Order Pharmacy Benefit Offered?*# Required: Does this tier offer 3 Month Out of Network Mail Order benefits? |
3 Month Out of Network Mail Order Pharmacy Copayment*# Required if Offered: Enter a copayment amount |
3 Month Out of Network Mail Order Pharmacy Coinsurance*# Required if Offered: Enter a coinsurance amount |
| Drug Lists | |||||||
| Fields with an "~" indicate a field that would be added under this PRA package. | |||||||
| All fields with an asterisk (*) are required. To validate the template, press the Validate button or Ctrl + Shift + V. To finalize, press Finalize button or Ctrl + Shift + F. | |||||||
| Click the Create Formulary IDs button (or Ctrl + Shift + C) to create Formulary IDs. | |||||||
| After creating Formulary IDs, select the ID from the drop down in Column A and 7 tiers will automatically be popoulated. | |||||||
| Select how many tiers a formulary uses from Number of Tiers and unused rows (tiers) will be greyed out. | |||||||
| Enter all RXCUIs on the Drug Lists sheet. To add more drug lists, click Add Drug List (Ctrl + Shift + A) and to delete the last drug list added press Delete Drug Lists (or Ctrl + Shift + D). | |||||||
| Drug List ID 1 | |||||||
| RXCUI* Required: Enter the RXCUI |
Tier Level* Required: Select the Tier this drug is in, or select NA if this drug is not a part of this Drug List |
Prior Authorization Required Required if Tier Level is not NA: Select "Yes" if Prior Authorization is Required |
Step Therapy Required Required if Tier Level is not NA: Select "Yes" if Step Therapy is Required |
Quantity Limits Required if Tier Level is not NA:~ Select "Yes" if Coverage features Quantity Limits. |
Fill Limits Required if Tier Level is not NA:~ Select "Yes" if Coverage features Fill Limits. |
Pharmacy Restrictions Required if Tier Level is not NA:~ Select "Yes" if Coverage features Pharmacy Restrictions. |
Over-the Counter Step Therapy Protocol Required if Tier Level is not NA:~ Select "Yes" if Coverage features OTC Step Therapy Protocols. |
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |