Field Name,Field Type,Example,Field Description
unique_plan_id,string,F0005937974123ABC456EMC789,"Unique 15-character, alphanumeric code identifying the broadband plan offered for sale. Letter characters must be capitalized, and only A-Z and 0-9 (ASCII 65-90 and 48-57). No special characters can be used in the ID."
provider_name,string,Acme Data Inc.,The provider name  
service_plan_name,string,10G Unlimited World,The name of the service plan.
tier_plan_name,string,Gold,The plan speed tier name if applicable. Can be NULL if there is no plan speed tier name 
connection_type,categorical,Fixed,"Enter ""Fixed"" or ""Mobile"" to indicate the type of connection."
monthly_price ,decimal,59.95,"The cost per month of the plan, without any introductory rates, in dollars and cents. Must be a maximum of two decimal places."
intro_rate,categorical,Yes,Enter Yes or No to indicate whether the plan has an introductory rate option. Value must be “Yes” or “No”
intro_rate_price,numeric,39.95,"The cost per month of the plan during the introductory period, in dollars and cents. Must be a maximum of two decimal places. Can be NULL if no introductory rate"
intro_rate_time,integer,6,The length of time in months the introductory rate applies. Can be NULL if no introductory rate
contract_req,categorical,Yes,Indicate whether the monthly price requires a contract or not. Value must be “Yes” or “No”
contract_time,integer,24,"The required time, in months, of the contract for the monthly rate. Can be NULL if no contract"
contract_terms_url,string,https://acmedata.com/terms,The URL of the provider’s webpage where the terms of service for the contract agreement are published. Can be NULL if no contract
early_termination_fee,decimal,90,"The fee associated with ending the contract early  in dollars and cents, with a maximum of two decimal places. Can be NULL if no early termination fee"
single_purchase_fee_descr ,string,Service cost; installation fee,Semicolon-delimited list identifying the category of one-time fees associated with the plan.  Number and order of entries must match single_purchase_fees  field below. Can be NULL if no one-time fees
single_purchase_fees ,string,59.95; 50.00,"Semicolon-delimited list of the one-time fees in dollars and cents, with up to two decimal places for each. Number and order of entries must match SingelPurchaseFeeDescr field above. Can be NULL if no one-time fees"
monthly_provider_fee_descr ,string,Equipment rental; virus protection subscription,Semicolon-delimited list of additional monthly fees associated with the plan. Number and order of entries must match MonthlyProviderFee field below. Can be NULL if no monthly fees
monthly_provider_fee,string,9.95;4.00,Semicolon delimited list of monthly fees in dollars and cents. Number and order of entries should match the monthly_provider_fee_descr field above. Can be NULL if no monthly fees
tax,string,Included,"Enter one of the following: - the value of the applicable state and federal taxes associated with the plan, or - “Varies” if the taxes vary within the geographic area in which the plan is made available, or - “Included” if all taxes are included in the monthly price of the plan entered in the MonthlyPrice field."
bundle_discounts_url,string,https://www.acmedata.com/fixed-plan/discounts,The URL for the provider’s webpage that lists the available billing discounts and pricing options for service bundles  or other discounts. 
typical_download_speed ,decimal,43.6,"The typical download speed associated with the plan measured in megabits per second (Mbps), with a maximum of two  decimal places."
typical_upload_speed ,numeric,4.07,"The typical upload speed associated with the plan measured in megabits per second (Mbps), with a maximum of two decimal places."
typical_latency ,numeric,139,"The typical latency associated with the plan, measured in milliseconds (ms)"
monthly_data_allow,numeric,50,The number of gigabytes (GB) of data included with monthly price. Can be zero if all usage is metered (pay-by-the-GB plans); and can be NULL if there are no monthly limits 
over_usage_data_price,numeric,5,"The charges for additional data usage, beyond the value entered in MonthlyDataAllow, in $/GB "
additional_data_increment,numeric,10,Increment of data added in GB (note that total cost for an overage will be this value times the $/GB above). Can be NULL if no additional increments of data 
data_allowance_policy_url,string,https://www.acmedata.com/data-charges,The link to the provider’s data allowance policy webpage
network_management_policy_url,string,https://www.acmedata.com/how-we-manage-our-networks,The link for the provider's network management policy webpage
privacy_policy_url,string,https://www.acmedata.com/about/privacy,Identifies the URL for the provider's privacy policy webpage
customer_support_phone ,string,1 (800) 555 8990,The provider's customer support phone number 
customer_support_web ,string,https://www.acmedata.com/help,Link for the provider's webpage with customer support information