The new Fee Schedule has requirements that v1 did not, which if not abided by, will prevent the fee schedule from being uploaded. See below for the details and examples of valid entries.
Swords > SetUp / Enrollment > Import > Fee Schedule
Valid headers and aliases:
Headers:
- Assignee Type:
Required: True
Alias: assignee type
Type: string
Valid choices are:
- INDIVIDUAL
- SPECIALITY
- Assignees:
Required: False
alias: assignees, ASSiigNees
Type: string
Example: doctor_id1|doctor_id2|doctor_id3 = 1|2|3
- Specialties:
Required: False
Alias: specialties
Type: string
Example: Pediatric Registered Nurse|Perinatal Registered Nurse
- Plan Name:
Required: False
Alias: plan name, PLAN NAME, Plan Name, PLAN Name
Type: string
Example: Plan #1, Plan #2
- Offices:
Required: False
alias: offices
Type: string
Example: office_id1|office_id2|office_id3 = 1|2|3
- Insurance Payers:
Required: False
alias: insurance payers or payers or payers id
Type: string
Example: payer_id1|payer_id2|payer_id3|payer_id4| = Payer id1|Payer id2
- Effective Date:
Required: False
Alias: effective, effective date
Type: string
Example: yyyy-mm-dd => 2024-01-21
- Ineffective Date:
Required: False
Alias: ineffective, ineffective date
Type: string
Example: yyyy-mm-dd => 2024-01-21
------------------------------------------------------------------
# From here on, it's item level
- Procedure:
Required: TRUE
Alias: procedure, code, procedure code
Type: string
Example: CPT123, 1245
- Type:
Required: TRUE
Alias: type, code type
Type: string
Valid choices: CPT, HCPCS, Revenue, Custom, ICD9, ICD10
Example: CPT
- Custom Description:
Required: FALSE
Alias: custom description, description
Type: string
Valid choices: Free Text
Example: Some custom descriptions that make sense to us
- Price:
Required: column required TRUE
Alias: price
Type: string or a number
Example: $10.3 or 10 or 0.3 or 0
- Allowed:
Required: FALSE, and blank is valid value
Alias: allowed amount
Type: string or a number
Example: $10.3 or 10 or 0.3 or 0
- Picklist Category:
Required: FALSE
Alias: picklist, category, picklist category
Type: string
Valid choices: Free Text
Example: Some custom category
- CPT/HCPCS Modifier:
Required: FALSE
Alias: ("cpt hcpcs modifier", "cpt/hcpcs modifier")
Type: string
Valid values: empty (or blank), a:b, a:b:c, a:b:c:d. a|b|c|d|e IS NOT VALID
- NDC Code:
Required: FALSE
Alias: "ndc code"
type: string
Valid values: anything
- NDC Quantity":
Required: FALSE
Alias: "ndc quantity"
type: numeric
Valid value: 3 or 3.3, 0.0001
- NDC Units:
Required: FALSE
Alias: ndc units
type: string
Valid Values: ("F2", "GR", "ME", "ML", "UN"), f2, gr, me, ml, mL, un
- Service Code:
Required: FALSE
Alias: service or service code
type: string
valid values: free text here
Rules:
If you say, Assignee Type = INDIVIDUAL, then Specialties must be null
If you say, Assignee Type = SPECIALTY, then Assignees must be null
If Effective and Ineffective are provided, then ineffective must be after the effective