Spreadsheet: 76174d1276714844-want-columns-to-hide-when-a-certain-drop-down-text-is-selected-help-example
Sheet: FMHPMHSUD

1 | Plan Name
2 | Plan Type |  |  | When EPO is selected from this drop down I want colums E and F to hide.  If it is not selected I want them to be displayed
3 | Plan Effective Date
4 | Benefit Year
 | Dates:
5 | Claims System
6 | Funding | 1
7 | CA LAP | 1
8 | Contract Type | Not Applicable
9 | Billing
10 | Non-Network Allowable
 | Percentile:
11 | Order of Benefits
12 | COB
13 | Managed By
14 | Location (CAC)
15 | Member [NAME] #
16 | Provider Access Phone #
17 | Comments
 | MHSUD INPATIENT
 |  | In Network |  | Out of Network |  | Revision Effective Date
18 | Copayment
19 | Coinsurance | [NAME] |  | Coinsurance OON |  |  |  | set help text outside print area
20 | Deductible - Individual/Family | Individual $ |  | Individual $
 |  | Family $ |  | Family $
 |  |  |  |  |  |  | add help text to explain system says "combined w/ medical = accumulator sharing back and forth with Medical Carrier"  - will put in writing to [NAME].
 |  | Combined: |  | Combined:
21 | [NAME] [NAME] requirements are discontinued after 10/1/2010 per Healthcare Reform legistation
 |  | Combined: |  | Combined: |  |  | Both Inpatient and Outpatient add annual [NAME] line under Lifetime, not gray.   to match if medical carrier needs it
21 | Annual Maximum
 |  | Combined: |  | Combined:
22 | OOP - Individual/Family | Individual $ |  | Individual $
 |  | Family $ |  | Family $
 |  | Combined: |  | Combined:
23 | Authorization Requirement
 |  |  |  |  |  |  | default INN/auth required for denial provider sanction, OON/variable based on medical plan - no default checkbox on OON
 |  | *Standard = member must call within 48 hours of admission Define medical grace period if not 48 hours______________ |  |  |  |  | Under Notification items, add checkbox that says "No Authorization or Notification required"- training that this is not allowed for FI
24 | Medical Necessity | Does the plan apply medical necessity standards for coverage? |  | Does the plan apply medical necessity standards for coverage? |  |  | In patient define grace period, add note field.
25 | Penalty - No Pre-Auth
 |  | Combined: |  | Combined: |  |  | Model Definition of Auth:  requires review to be sure the level of care requested matches the clinical presentation, medical necessity denial is an option here              Meaning to Intake:  requires review by clinician and application of medical necessity review              Meaning to Claims:  must have authorization to pay (if required), claims systems do not differentiate between authorization and notification  Model Definition of Notification:  simply a way to access benefits - letting somebody know that you are using the benefit, does not require 'permission'  Meaning to Intake:  OK to write open authorization without clinical review/assessment              Meaning to Claims:  same as above meaning to claims
26 | Penalty - Non-notif
 |  | Combined: |  | Combined:
27 | Penalty - Certificate of Completion
 |  | Combined: |  | Combined:
28 | ECT |  |  |  |  |  | add $/% | *ECT Note standard procedure rule for ECT is if Inpatient it follows the Inpatient benefit.
29 | Professional Fees |  |  |  |  |  | add $/% | *Professional Fees = Inpatient physician fees paid at same rate as the Medical Inpatient Services.
 | MHSUD OUTPATIENT |  |  |  |  |  | ask - IOP option to choose anything different than aligning to UBH standard set forth by [NAME] to take this to [NAME] to ask about deviations.
 |  | In Network |  | Out of Network |  | Revision Effective Date
30 | Copayment
31 | Coinsurance
32 | Deductible - Individual/Family | Individual $ |  | Individual $
 |  | Family $ |  | Family $
33 | [NAME] [NAME] requirements are discontinued after 9/1/2010 per healthcare reform
 |  | Combined: |  | Combined:
21 | Annual Maximum
 |  | Combined: |  | Combined:
34 | OOP - Individual/Family | Individual $ |  | Individual $
 |  | Family $ |  | Family $
 |  | Combined: |  | Combined:
35 | Authorization Requirement |  |  |  |  |  | default boxes to [NAME] and non-routine box checked. For INN/OON - Outpatient
 |  |  |  |  |  |  | notification dependent upon medical plan (either will be auth or notification or nothing)
 |  |  |  |  |  |  | Under Notification items, add checkbox that says "No Authorization or Notification required"- training that this is not allowed for FI
 |  |  |  |  |  |  | note: standard product would require no authorization for routine and nonroutine, if both boxes checked, this is not a parity plan.
36 | Medical Necessity
37 | Penalty - No Pre-Auth
38 | Penalty - Non-notif
39 | Penalty - Certificate of Completion
40 | ECT
41 | Emergency Room | $ |  | $
42 | Ambulance | $ |  | $
43 | Severe Mental Illness (SMI) | $ |  | $
 | OTHER BENEFITS (ER/Ambulance, SMI, etc.)
 | NON-VISIT FEATURES
 |  | Other: