BenefitFlow Data Glossary

Which reference do I need?

You want to	Use
Understand a column you exported from the app	This page (Data Glossary)
Know what’s in the SFTP feed and its exact column order	Bulk Data Schema
Map BenefitFlow fields to your CRM	CRM Field Mapping
Narrow a search (filter by industry, funding, plan type, etc.)	Filtering Guide

What this covers

Every column in the CSV files you export from BenefitFlow in the app, in the order they appear. There are six export types, listed below.

How our exports are formatted

Rule	Detail
Column names	Every column is prefixed with its data group, `Group: Field` (for example `Retirement: Plan Assets`).
Encoding	UTF-8 with a byte-order mark.
EIN	Always `XX-XXXXXXX`.
Dates	ISO `YYYY-MM-DD`. Renewal dates are month and day only (`Sep 1`).
ZIP / NAICS / NPN	Plain digits, no apostrophe or quotes.
Money	Two decimal places, no dollar sign or commas.
Empty vs zero	Blank means unknown; `0` means a real zero.
Lists in one cell	Comma-separated; aliases use semicolons.

Employer export

One row per employer. 147 columns.

#	Column	Meaning
1	BenefitFlow: Record Type	Row type identifier for the file.
2	Firmographic: Employer Name	Company name.
3	Firmographic: Employer Website	Primary domain.
4	Firmographic: Employer LinkedIn URL	Company LinkedIn page.
5	Firmographic: Company Description	Company summary.
6	Firmographic: DBA / Aliases	Other names the company files or trades under, semicolon-separated.
7	Firmographic: Parent Company	Ultimate parent if a subsidiary; blank if top of its tree.
8	Firmographic: Parent Company ID	BenefitFlow ID for the parent.
9	Firmographic: Employer NAICS Description	Industry description.
10	Firmographic: Employer NAICS Code	NAICS code.
11	Firmographic: Employer EIN	Federal EIN, XX-XXXXXXX.
12	Firmographic: Employer Address	Street address.
13	Firmographic: Employer City	City.
14	Firmographic: Employer State	Two-letter state.
15	Firmographic: Employer Zip Code	ZIP.
16	Firmographic: Employer ID	BenefitFlow unique ID for the employer.
17	Firmographic: Phone Number	Employer phone.
18	Firmographic: Total Employees	Total employee count.
19	Firmographic: Benefit Eligible Employees	Benefits-eligible count.
20	Firmographic: Headcount Growth YoY %	Year-over-year change in employee count, percent.
21	Firmographic: Number of Locations	Physical locations.
22	Firmographic: Employer Estimated Revenue	Revenue band.
23	Firmographic: Founded Year	Year founded.
24	Firmographic: Company Type	Public, Private, Nonprofit, and so on.
25	Firmographic: IPO Date	Date of IPO, if public.
26	Funding: Total Raised	Total capital raised to date.
27	Funding: Last Round	Most recent funding round type.
28	Funding: Last Round Date	Date of the most recent round.
29	Funding: Investors	Named investors, comma-separated.
30	Firmographic: Benefits Rating	Glassdoor average rating, 0 to 5.
31	Firmographic: Number of Available Contacts	Contacts BenefitFlow has for this employer.
32	Benefits: 5500 Signor Name	Person who signed the Form 5500.
33	Benefits: Filing Date	Most recent Form 5500 filing date.
34	Benefits: Funding	Fully-Insured or Self-Funded.
35	Benefits: Entity Type	Single-, Multi-, or Multiple-Employer.
36	Benefits: Primary Carrier	Carrier with the largest premium share.
37	Benefits: Line of Business	Benefit lines offered, comma-separated.
38	Benefits: Total Premiums	Total annual premiums.
39	Benefits: Total Commissions	Total broker commissions across all brokers.
40	Benefits: Renewal Date	Benefits renewal month and day, no year.
41	Benefits: Primary Broker	Broker with the largest share of the business.
42	Benefits: Primary Broker Website	Primary broker domain.
43	Benefits: Primary Broker Tenure	Years the primary broker has served this employer.
44	Benefits: Primary Broker Commissions	Commissions to the primary broker.
45	Benefits: Primary Broker Closest Office Name	Closest primary-broker office, display name.
46	Benefits: Primary Broker Closest Office City	City of the geographically closest office.
47	Benefits: Primary Broker Closest Office State	State of the closest office.
48	Benefits: Primary Broker Closest Office Zip	ZIP of the closest office.
49	Benefits: Primary Broker Closest Office Address	Full address of the closest office.
50	Benefits: Primary Broker Reported Office Name	Broker office named on the 5500 filing.
51	Benefits: Primary Broker Reported Office City	Reported office city.
52	Benefits: Primary Broker Reported Office State	Reported office state.
53	Benefits: Primary Broker ID	BenefitFlow ID for the primary broker.
54	Benefits: Primary Broker Closest Office ID	BenefitFlow ID for the closest office.
55	Benefits: TPA	Third-party administrator for health and welfare.
56	Benefits: Actuary Firm	Actuarial firm.
57	Benefits: Accounting Firm	Accountant on the 5500 filing.
58	Retirement: Financial Advisor	Retirement plan financial advisor.
59	Retirement: Recordkeeper	Retirement plan recordkeeper.
60	Retirement: Plan Name	Name of the largest retirement plan.
61	Retirement: Plan Type	For example 401(k), Defined Benefit.
62	Retirement: Plan Features	Plan features, comma-separated.
63	Retirement: Plan Assets	Total plan assets.
64	Retirement: Total Participants	Total plan participants.
65	Retirement: Active Participants	Active plan participants.
66	Retirement: Employer Contribution	Employer contribution amount.
67	Retirement: Total Contributions	Employer plus participant contributions.
68	Retirement: Avg Account Balance	Assets divided by participants.
69	Retirement: Participation Rate %	Participants with a balance, percent of total.
70	Retirement: Loans Outstanding	Participant loans outstanding.
71	Retirement: Fidelity Bond	Fidelity bond amount.
72	Retirement: Plan Year End	Retirement plan year-end date.
73	P&C: Renewal Date	P&C renewal month and day, no year.
74	P&C: Broker	Broker handling P&C.
75	P&C: Carrier	P&C carrier.
76	P&C: PEO	Professional Employer Organization, if any.
77	P&C: X-Mod Factor	Workers’ comp experience modification factor.
78	P&C: Last X-Mod Date	Effective date of the most recent X-Mod.
79	P&C: L12M OSHA Inspections	OSHA inspections, last 12 months.
80	P&C: L12M OSHA Violations	OSHA violations, last 12 months.
81	P&C: L12M OSHA Total Accidents	Recorded accidents, last 12 months.
82	P&C: L12M OSHA Total Penalties	OSHA penalty dollars, last 12 months.
83	P&C: Miles Driven	Fleet miles driven (DOT MCS-150).
84	P&C: Vehicles	Fleet vehicle count.
85	P&C: Drivers	Fleet driver count.
86	P&C: L12M DOT Inspections	DOT inspections, last 12 months.
87	P&C: L12M DOT Violations	DOT violations, last 12 months.
88	P&C: L12M DOT Out of Service Total	Out-of-service events, last 12 months.
89	P&C: L12M DOT Crashes	Crashes, last 12 months.
90	P&C: L12M DOT Fatalities	Fatalities, last 12 months.
91	P&C: Broker ID	BenefitFlow ID for the P&C broker.
92	P&C: Broker Reported Office City	P&C broker office city per filing.
93	P&C: Broker Reported Office State	P&C broker office state per filing.
94	P&C: Broker Reported Office Zip	P&C broker office ZIP per filing.
95	P&C: Broker Reported Office Address	P&C broker office address per filing.
96	Modeled Premium: Medical	Modeled Medical premium.
97	Modeled Premium: Dental	Modeled Dental premium.
98	Modeled Premium: Life	Modeled Life premium.
99	Modeled Premium: Temporary Disability	Modeled Temporary Disability premium.
100	Modeled Premium: Long Term Disability	Modeled Long Term Disability premium.
101	Modeled Premium: Vision	Modeled Vision premium.
102	Modeled Premium: Critical Illness	Modeled Critical Illness premium.
103	Modeled Premium: Accident	Modeled Accident premium.
104	Modeled Premium: AD&D	Modeled AD&D premium.
105	Modeled Premium: Stop Loss	Modeled Stop Loss premium.
106	Modeled Premium: Indemnity	Modeled Indemnity premium.
107	Modeled Premium: Prescription Drug	Modeled Prescription Drug premium.
108	Modeled Commissions: Medical	Modeled commission for the Medical line.
109	Modeled Commissions: Dental	Modeled commission for the Dental line.
110	Modeled Commissions: Life	Modeled commission for the Life line.
111	Modeled Commissions: Temporary Disability	Modeled commission for the Temporary Disability line.
112	Modeled Commissions: Long Term Disability	Modeled commission for the Long Term Disability line.
113	Modeled Commissions: Vision	Modeled commission for the Vision line.
114	Modeled Commissions: Critical Illness	Modeled commission for the Critical Illness line.
115	Modeled Commissions: Accident	Modeled commission for the Accident line.
116	Modeled Commissions: AD&D	Modeled commission for the AD&D line.
117	Modeled Commissions: Stop Loss	Modeled commission for the Stop Loss line.
118	Modeled Commissions: Indemnity	Modeled commission for the Indemnity line.
119	Modeled Commissions: Prescription Drug	Modeled commission for the Prescription Drug line.
120	Primary Carrier: Medical	Primary carrier for the Medical line.
121	Primary Carrier: Dental	Primary carrier for the Dental line.
122	Primary Carrier: Life	Primary carrier for the Life line.
123	Primary Carrier: Temporary Disability	Primary carrier for the Temporary Disability line.
124	Primary Carrier: Long Term Disability	Primary carrier for the Long Term Disability line.
125	Primary Carrier: Vision	Primary carrier for the Vision line.
126	Primary Carrier: Critical Illness	Primary carrier for the Critical Illness line.
127	Primary Carrier: Accident	Primary carrier for the Accident line.
128	Primary Carrier: AD&D	Primary carrier for the AD&D line.
129	Primary Carrier: Stop Loss	Primary carrier for the Stop Loss line.
130	Primary Carrier: Indemnity	Primary carrier for the Indemnity line.
131	Primary Carrier: Prescription Drug	Primary carrier for the Prescription Drug line.
132	Primary Broker: Medical	Primary broker for the Medical line.
133	Primary Broker: Dental	Primary broker for the Dental line.
134	Primary Broker: Life	Primary broker for the Life line.
135	Primary Broker: Temporary Disability	Primary broker for the Temporary Disability line.
136	Primary Broker: Long Term Disability	Primary broker for the Long Term Disability line.
137	Primary Broker: Vision	Primary broker for the Vision line.
138	Primary Broker: Critical Illness	Primary broker for the Critical Illness line.
139	Primary Broker: Accident	Primary broker for the Accident line.
140	Primary Broker: AD&D	Primary broker for the AD&D line.
141	Primary Broker: Stop Loss	Primary broker for the Stop Loss line.
142	Primary Broker: Indemnity	Primary broker for the Indemnity line.
143	Primary Broker: Prescription Drug	Primary broker for the Prescription Drug line.
144	BenefitFlow: Lead Source	Always BenefitFlow.
145	BenefitFlow: Export Date	Date the file was generated.
146	BenefitFlow: User	Email of the user who ran the export.
147	BenefitFlow: Employer URL	Direct link to the employer profile.

Example row: Walmart

Column	Value
Firmographic: Employer Name	Walmart
Firmographic: Employer EIN	71-0415188
Firmographic: Employer City	Bentonville
Firmographic: Employer State	AR
Firmographic: Company Type	Public Company
Firmographic: Employer Estimated Revenue	$1B+
Firmographic: Total Employees	2076632
Benefits: Funding	Self-Funded
Benefits: Primary Carrier	Kaiser Permanente
Benefits: Total Premiums	1077048873.00
Benefits: Primary Broker	Mercer
Retirement: Plan Type	401(k)
Retirement: Plan Assets	50790179678.00
Retirement: Participation Rate %	59.0
P&C: L12M OSHA Inspections	202
Modeled Premium: Medical	12486372920.40

Columns without data are left blank. Walmart is self-insured for workers’ comp, so its P&C X-Mod columns are blank. Modeled Premium is BenefitFlow’s estimate of full annual premium by product, so it is not comparable to Total Premiums (the reported, filed figure) and runs much higher for a self-funded employer like Walmart.

Employer Contact export

One row per contact (with full employer context). 161 columns.

#	Column	Meaning
1	BenefitFlow: Record Type	Row type identifier for the file.
2	Contact: Full Name	Contact full name.
3	Contact: First Name	First name.
4	Contact: Last Name	Last name.
5	Contact: LinkedIn URL	LinkedIn profile.
6	Contact: Email	Work email.
7	Contact: Mobile Phone 1	Mobile, E.164 format.
8	Contact: Professional Phone 1	Office phone, E.164 format.
9	Contact: City	Contact city.
10	Contact: State	Contact state.
11	Contact: Job Role	Categorized role.
12	Contact: Job Title	Full job title.
13	Contact: Yrs. In Role	Years in the current role.
14	Contact: Yrs. At Company	Years at the company.
15	Firmographic: Employer Name	Company name.
16	Firmographic: Employer Website	Primary domain.
17	Firmographic: Employer LinkedIn URL	Company LinkedIn page.
18	Firmographic: Company Description	Company summary.
19	Firmographic: DBA / Aliases	Other names the company files or trades under, semicolon-separated.
20	Firmographic: Parent Company	Ultimate parent if a subsidiary; blank if top of its tree.
21	Firmographic: Parent Company ID	BenefitFlow ID for the parent.
22	Firmographic: Employer NAICS Description	Industry description.
23	Firmographic: Employer NAICS Code	NAICS code.
24	Firmographic: Employer EIN	Federal EIN, XX-XXXXXXX.
25	Firmographic: Employer Address	Street address.
26	Firmographic: Employer City	City.
27	Firmographic: Employer State	Two-letter state.
28	Firmographic: Employer Zip Code	ZIP.
29	Firmographic: Employer ID	BenefitFlow unique ID for the employer.
30	Firmographic: Phone Number	Employer phone.
31	Firmographic: Total Employees	Total employee count.
32	Firmographic: Benefit Eligible Employees	Benefits-eligible count.
33	Firmographic: Headcount Growth YoY %	Year-over-year change in employee count, percent.
34	Firmographic: Number of Locations	Physical locations.
35	Firmographic: Employer Estimated Revenue	Revenue band.
36	Firmographic: Founded Year	Year founded.
37	Firmographic: Company Type	Public, Private, Nonprofit, and so on.
38	Firmographic: IPO Date	Date of IPO, if public.
39	Funding: Total Raised	Total capital raised to date.
40	Funding: Last Round	Most recent funding round type.
41	Funding: Last Round Date	Date of the most recent round.
42	Funding: Investors	Named investors, comma-separated.
43	Firmographic: Benefits Rating	Glassdoor average rating, 0 to 5.
44	Firmographic: Number of Available Contacts	Contacts BenefitFlow has for this employer.
45	Benefits: 5500 Signor Name	Person who signed the Form 5500.
46	Benefits: Filing Date	Most recent Form 5500 filing date.
47	Benefits: Funding	Fully-Insured or Self-Funded.
48	Benefits: Entity Type	Single-, Multi-, or Multiple-Employer.
49	Benefits: Primary Carrier	Carrier with the largest premium share.
50	Benefits: Line of Business	Benefit lines offered, comma-separated.
51	Benefits: Total Premiums	Total annual premiums.
52	Benefits: Total Commissions	Total broker commissions across all brokers.
53	Benefits: Renewal Date	Benefits renewal month and day, no year.
54	Benefits: Primary Broker	Broker with the largest share of the business.
55	Benefits: Primary Broker Website	Primary broker domain.
56	Benefits: Primary Broker Tenure	Years the primary broker has served this employer.
57	Benefits: Primary Broker Commissions	Commissions to the primary broker.
58	Benefits: Primary Broker Closest Office Name	Closest primary-broker office, display name.
59	Benefits: Primary Broker Closest Office City	City of the geographically closest office.
60	Benefits: Primary Broker Closest Office State	State of the closest office.
61	Benefits: Primary Broker Closest Office Zip	ZIP of the closest office.
62	Benefits: Primary Broker Closest Office Address	Full address of the closest office.
63	Benefits: Primary Broker Reported Office Name	Broker office named on the 5500 filing.
64	Benefits: Primary Broker Reported Office City	Reported office city.
65	Benefits: Primary Broker Reported Office State	Reported office state.
66	Benefits: Primary Broker ID	BenefitFlow ID for the primary broker.
67	Benefits: Primary Broker Closest Office ID	BenefitFlow ID for the closest office.
68	Benefits: TPA	Third-party administrator for health and welfare.
69	Benefits: Actuary Firm	Actuarial firm.
70	Benefits: Accounting Firm	Accountant on the 5500 filing.
71	Retirement: Financial Advisor	Retirement plan financial advisor.
72	Retirement: Recordkeeper	Retirement plan recordkeeper.
73	Retirement: Plan Name	Name of the largest retirement plan.
74	Retirement: Plan Type	For example 401(k), Defined Benefit.
75	Retirement: Plan Features	Plan features, comma-separated.
76	Retirement: Plan Assets	Total plan assets.
77	Retirement: Total Participants	Total plan participants.
78	Retirement: Active Participants	Active plan participants.
79	Retirement: Employer Contribution	Employer contribution amount.
80	Retirement: Total Contributions	Employer plus participant contributions.
81	Retirement: Avg Account Balance	Assets divided by participants.
82	Retirement: Participation Rate %	Participants with a balance, percent of total.
83	Retirement: Loans Outstanding	Participant loans outstanding.
84	Retirement: Fidelity Bond	Fidelity bond amount.
85	Retirement: Plan Year End	Retirement plan year-end date.
86	P&C: Renewal Date	P&C renewal month and day, no year.
87	P&C: Broker	Broker handling P&C.
88	P&C: Carrier	P&C carrier.
89	P&C: PEO	Professional Employer Organization, if any.
90	P&C: X-Mod Factor	Workers’ comp experience modification factor.
91	P&C: Last X-Mod Date	Effective date of the most recent X-Mod.
92	P&C: L12M OSHA Inspections	OSHA inspections, last 12 months.
93	P&C: L12M OSHA Violations	OSHA violations, last 12 months.
94	P&C: L12M OSHA Total Accidents	Recorded accidents, last 12 months.
95	P&C: L12M OSHA Total Penalties	OSHA penalty dollars, last 12 months.
96	P&C: Miles Driven	Fleet miles driven (DOT MCS-150).
97	P&C: Vehicles	Fleet vehicle count.
98	P&C: Drivers	Fleet driver count.
99	P&C: L12M DOT Inspections	DOT inspections, last 12 months.
100	P&C: L12M DOT Violations	DOT violations, last 12 months.
101	P&C: L12M DOT Out of Service Total	Out-of-service events, last 12 months.
102	P&C: L12M DOT Crashes	Crashes, last 12 months.
103	P&C: L12M DOT Fatalities	Fatalities, last 12 months.
104	P&C: Broker ID	BenefitFlow ID for the P&C broker.
105	P&C: Broker Reported Office City	P&C broker office city per filing.
106	P&C: Broker Reported Office State	P&C broker office state per filing.
107	P&C: Broker Reported Office Zip	P&C broker office ZIP per filing.
108	P&C: Broker Reported Office Address	P&C broker office address per filing.
109	Modeled Premium: Medical	Modeled Medical premium.
110	Modeled Premium: Dental	Modeled Dental premium.
111	Modeled Premium: Life	Modeled Life premium.
112	Modeled Premium: Temporary Disability	Modeled Temporary Disability premium.
113	Modeled Premium: Long Term Disability	Modeled Long Term Disability premium.
114	Modeled Premium: Vision	Modeled Vision premium.
115	Modeled Premium: Critical Illness	Modeled Critical Illness premium.
116	Modeled Premium: Accident	Modeled Accident premium.
117	Modeled Premium: AD&D	Modeled AD&D premium.
118	Modeled Premium: Stop Loss	Modeled Stop Loss premium.
119	Modeled Premium: Indemnity	Modeled Indemnity premium.
120	Modeled Premium: Prescription Drug	Modeled Prescription Drug premium.
121	Modeled Commissions: Medical	Modeled commission for the Medical line.
122	Modeled Commissions: Dental	Modeled commission for the Dental line.
123	Modeled Commissions: Life	Modeled commission for the Life line.
124	Modeled Commissions: Temporary Disability	Modeled commission for the Temporary Disability line.
125	Modeled Commissions: Long Term Disability	Modeled commission for the Long Term Disability line.
126	Modeled Commissions: Vision	Modeled commission for the Vision line.
127	Modeled Commissions: Critical Illness	Modeled commission for the Critical Illness line.
128	Modeled Commissions: Accident	Modeled commission for the Accident line.
129	Modeled Commissions: AD&D	Modeled commission for the AD&D line.
130	Modeled Commissions: Stop Loss	Modeled commission for the Stop Loss line.
131	Modeled Commissions: Indemnity	Modeled commission for the Indemnity line.
132	Modeled Commissions: Prescription Drug	Modeled commission for the Prescription Drug line.
133	Primary Carrier: Medical	Primary carrier for the Medical line.
134	Primary Carrier: Dental	Primary carrier for the Dental line.
135	Primary Carrier: Life	Primary carrier for the Life line.
136	Primary Carrier: Temporary Disability	Primary carrier for the Temporary Disability line.
137	Primary Carrier: Long Term Disability	Primary carrier for the Long Term Disability line.
138	Primary Carrier: Vision	Primary carrier for the Vision line.
139	Primary Carrier: Critical Illness	Primary carrier for the Critical Illness line.
140	Primary Carrier: Accident	Primary carrier for the Accident line.
141	Primary Carrier: AD&D	Primary carrier for the AD&D line.
142	Primary Carrier: Stop Loss	Primary carrier for the Stop Loss line.
143	Primary Carrier: Indemnity	Primary carrier for the Indemnity line.
144	Primary Carrier: Prescription Drug	Primary carrier for the Prescription Drug line.
145	Primary Broker: Medical	Primary broker for the Medical line.
146	Primary Broker: Dental	Primary broker for the Dental line.
147	Primary Broker: Life	Primary broker for the Life line.
148	Primary Broker: Temporary Disability	Primary broker for the Temporary Disability line.
149	Primary Broker: Long Term Disability	Primary broker for the Long Term Disability line.
150	Primary Broker: Vision	Primary broker for the Vision line.
151	Primary Broker: Critical Illness	Primary broker for the Critical Illness line.
152	Primary Broker: Accident	Primary broker for the Accident line.
153	Primary Broker: AD&D	Primary broker for the AD&D line.
154	Primary Broker: Stop Loss	Primary broker for the Stop Loss line.
155	Primary Broker: Indemnity	Primary broker for the Indemnity line.
156	Primary Broker: Prescription Drug	Primary broker for the Prescription Drug line.
157	BenefitFlow: Lead Source	Always BenefitFlow.
158	BenefitFlow: Export Date	Date the file was generated.
159	BenefitFlow: Data Last Updated	Date the record was last refreshed.
160	BenefitFlow: User	Email of the user who ran the export.
161	BenefitFlow: Employer URL	Direct link to the employer profile.

Example row: a Walmart contact

Column	Value
Contact: Full Name	Jordan Ellis
Contact: Job Title	Director, Benefits
Contact: Job Role	HR & Talent
Contact: City	Bentonville
Contact: State	AR
Firmographic: Employer Name	Walmart
Firmographic: Employer EIN	71-0415188
Benefits: Primary Carrier	Kaiser Permanente
Retirement: Plan Type	401(k)
P&C: L12M OSHA Inspections	202

Contact details are illustrative; the employer context is real.

Policy export

One row per policy or plan. 53 columns.

#	Column	Meaning
1	BenefitFlow: Record Type	Row type identifier for the file.
2	Firmographic: Employer Name	Company name.
3	Firmographic: Employer NAICS Description	Industry description.
4	Firmographic: Employer NAICS Code	NAICS code.
5	Firmographic: Employer EIN	Federal EIN, XX-XXXXXXX.
6	Firmographic: Employer City	City.
7	Firmographic: Employer State	Two-letter state.
8	Firmographic: Employer Zip Code	ZIP.
9	Firmographic: Employer ID	BenefitFlow unique ID for the employer.
10	Firmographic: Total Employees	Total employee count.
11	Firmographic: Benefit Eligible Employees	Benefits-eligible count.
12	Benefits: 5500 Signor Name	Person who signed the Form 5500.
13	Benefits: Filing Date	Most recent Form 5500 filing date.
14	Firmographic: Phone Number	Employer phone.
15	Benefits: Funding	Fully-Insured or Self-Funded.
16	Benefits: Entity Type	Single-, Multi-, or Multiple-Employer.
17	Benefits: Plan Name	Name of the largest retirement plan.
18	Benefits: Policy Number	Policy or plan sequence number (not unique across employers).
19	Benefits: Carrier	Carrier for this policy.
20	Benefits: Line of Business	Benefit lines offered, comma-separated.
21	Benefits: Line of Business, Detail	Additional line detail when available.
22	Benefits: Total Premiums	Total annual premiums.
23	Benefits: Covered Lives	People covered.
24	Benefits: PEPM Rate	Per-employee-per-month rate.
25	Benefits: Total Commissions	Total broker commissions across all brokers.
26	Benefits: Renewal Date	Benefits renewal month and day, no year.
27	Benefits: Primary Broker	Broker with the largest share of the business.
28	Benefits: Primary Broker Website	Primary broker domain.
29	Benefits: Commissions	Commissions to the primary broker.
30	Benefits: Primary Broker Closest Office Name	Closest broker office, display name.
31	Benefits: Primary Broker Closest Office City	City of the geographically closest office.
32	Benefits: Primary Broker Closest Office State	State of the closest office.
33	Benefits: Primary Broker Closest Office Zip	ZIP of the closest office.
34	Benefits: Primary Broker Closest Office Address	Full address of the closest office.
35	Benefits: Primary Broker Reported Office City	Reported office city.
36	Benefits: Primary Broker Reported Office State	Reported office state.
37	Benefits: Primary Broker ID	BenefitFlow ID for the broker firm.
38	Modeled Premium: Medical	Modeled Medical premium for this policy.
39	Modeled Premium: Dental	Modeled Dental premium for this policy.
40	Modeled Premium: Life	Modeled Life premium for this policy.
41	Modeled Premium: Temporary Disability	Modeled Temporary Disability premium for this policy.
42	Modeled Premium: Long Term Disability	Modeled Long Term Disability premium for this policy.
43	Modeled Premium: Vision	Modeled Vision premium for this policy.
44	Modeled Premium: Critical Illness	Modeled Critical Illness premium for this policy.
45	Modeled Premium: Accident	Modeled Accident premium for this policy.
46	Modeled Premium: AD&D	Modeled AD&D premium for this policy.
47	Modeled Premium: Stop Loss	Modeled Stop Loss premium for this policy.
48	Modeled Premium: Indemnity	Modeled Indemnity premium for this policy.
49	Modeled Premium: Prescription Drug	Modeled Prescription Drug premium for this policy.
50	BenefitFlow: Lead Source	Always BenefitFlow.
51	BenefitFlow: Export Date	Date the file was generated.
52	BenefitFlow: User	Email of the user who ran the export.
53	BenefitFlow: Employer URL	Direct link to the employer profile.

The Modeled Premium columns estimate how this policy’s total premium splits across benefit lines. A single-line policy puts its full premium in that line’s column. A multi-line policy is split across its lines, and the split adds up to Total Premiums. The columns are blank when the policy’s lines aren’t among these 12, such as Legal or Wellness/EAP.

Example row: an NEA policy

Column	Value
Firmographic: Employer Name	National Education Association Of The United States
Firmographic: Employer EIN	53-0115260
Benefits: Plan Name	NEA Welfare Benefit Plan
Benefits: Line of Business	Health, Prescription Drug, HMO
Benefits: Total Premiums	276335.00
Benefits: Covered Lives	14
Benefits: PEPM Rate	1644.85
Benefits: Renewal Date	Sep 1

Broker export

One row per broker firm. 14 columns.

#	Column	Meaning
1	BenefitFlow: Record Type	Row type identifier for the file.
2	Broker: ID	BenefitFlow ID for the broker firm.
3	Broker: Name	Broker firm name.
4	Broker: Website	Broker firm domain.
5	Broker: Headquarters	Firm headquarters city and state.
6	Broker: Total Office Locations	Office locations in BenefitFlow.
7	Broker: Total Clients	Employer clients.
8	Broker: Total Contacts	Contacts at the firm.
9	Broker: Total Commissions	Total broker commissions across all brokers.
10	Broker: Total Carrier Premiums	Aggregate premiums placed across clients.
11	BenefitFlow: Lead Source	Always BenefitFlow.
12	BenefitFlow: Export Date	Date the file was generated.
13	BenefitFlow: User	Email of the user who ran the export.
14	BenefitFlow: Broker URL	Direct link to the broker profile.

Example row: Marsh McLennan

Column	Value
Broker: Name	Marsh Mclennan
Broker: Headquarters	New York, NY
Broker: Total Office Locations	146
Broker: Total Clients	5869
Broker: Total Contacts	5502
Broker: Total Commissions	531856862.00
Broker: Total Carrier Premiums	9938120509.00

Broker Office export

One row per broker office location. 19 columns.

#	Column	Meaning
1	BenefitFlow: Record Type	Row type identifier for the file.
2	Broker: ID	BenefitFlow ID for the broker firm.
3	Broker: Name	Broker firm name.
4	Broker: Website	Broker firm domain.
5	Broker Office: Name	Office display name.
6	Broker Office: Address	Full street address.
7	Broker Office: City	City.
8	Broker Office: State	State.
9	Broker Office: Zip Code	ZIP.
10	Broker Office: ID	BenefitFlow unique ID for this office.
11	Broker Office: Total Clients	Clients serviced from this office.
12	Broker Office: Total Contacts	Contacts at this office.
13	Broker Office: Total Employees	Aggregate employees across serviced clients.
14	Broker Office: Total Commissions	Aggregate commissions for this office’s clients.
15	Broker Office: Total Carrier Premiums	Aggregate premiums placed by this office.
16	BenefitFlow: Lead Source	Always BenefitFlow.
17	BenefitFlow: Export Date	Date the file was generated.
18	BenefitFlow: User	Email of the user who ran the export.
19	BenefitFlow: Broker URL	Direct link to the broker profile.

Example row: Marsh McLennan, Dallas

Column	Value
Broker: Name	Marsh Mclennan
Broker Office: Name	Marsh Mclennan - Dallas, TX
Broker Office: City	Dallas
Broker Office: State	TX
Broker Office: Total Clients	295
Broker Office: Total Contacts	213
Broker Office: Total Commissions	25620318.00

Broker Contact export

One row per contact at a broker. 37 columns.

#	Column	Meaning
1	BenefitFlow: Record Type	Row type identifier for the file.
2	Contact: Full Name	Contact full name.
3	Contact: First Name	First name.
4	Contact: Last Name	Last name.
5	Contact: LinkedIn URL	LinkedIn profile.
6	Contact: Email	Work email.
7	Contact: Mobile Phone 1	Mobile, E.164 format.
8	Contact: Professional Phone 1	Office phone, E.164 format.
9	Contact: City	City.
10	Contact: State	State.
11	Contact: Job Role	Categorized role.
12	Contact: Job Title	Full job title.
13	Contact: Yrs. In Role	Years in the current role.
14	Contact: Yrs. At Company	Years at the company.
15	Contact: License Types	Insurance license types held, comma-separated.
16	Contact: NPN Number	National Producer Number.
17	Contact: Carrier Appointments	Count of active carrier appointments.
18	Broker: Name	Broker firm name.
19	Broker: ID	BenefitFlow ID for the broker firm.
20	Broker: Website	Broker firm domain.
21	Broker: Headquarters	Firm headquarters city and state.
22	Broker: Total Office Locations	Office locations in BenefitFlow.
23	Broker: Total Clients	Employer clients.
24	Broker: Total Contacts	Contacts at the firm.
25	Broker: Total Commissions	Total broker commissions across all brokers.
26	Broker: Total Carrier Premiums	Aggregate premiums placed across clients.
27	BenefitFlow: Broker URL	Direct link to the broker profile.
28	Broker Office: Closest Office ID	BenefitFlow ID for the closest office.
29	Broker Office: Closest Office Name	Closest office display name.
30	Broker Office: Closest Office Address	Closest office address.
31	Broker Office: Closest Office City	Closest office city.
32	Broker Office: Closest Office State	Closest office state.
33	Broker Office: Closest Office Zip	Closest office ZIP.
34	BenefitFlow: Lead Source	Always BenefitFlow.
35	BenefitFlow: Export Date	Date the file was generated.
36	BenefitFlow: Data Last Updated	Date the record was last refreshed.
37	BenefitFlow: User	Email of the user who ran the export.

Example row: a broker contact

Column	Value
Contact: Full Name	Alex Rivera
Contact: Job Title	Senior Vice President
Contact: Job Role	Producer
Contact: License Types	Health, Life, Property, Casualty
Contact: NPN Number	1234567
Contact: Carrier Appointments	42
Broker: Name	Marsh Mclennan
Broker: Headquarters	New York, NY

Contact details are illustrative; the broker context is real.

The Basics

My Account

Which reference do I need?

What this covers

How our exports are formatted

Employer export

Example row: Walmart

Employer Contact export

Example row: a Walmart contact

Policy export

Example row: an NEA policy

Broker export

Example row: Marsh McLennan

Broker Office export

Example row: Marsh McLennan, Dallas

Broker Contact export

Example row: a broker contact

​Which reference do I need?

​What this covers

​How our exports are formatted

​Employer export

​Example row: Walmart

​Employer Contact export

​Example row: a Walmart contact

​Policy export

​Example row: an NEA policy

​Broker export

​Example row: Marsh McLennan

​Broker Office export

​Example row: Marsh McLennan, Dallas

​Broker Contact export

​Example row: a broker contact

Which reference do I need?

What this covers

How our exports are formatted

Employer export

Example row: Walmart

Employer Contact export

Example row: a Walmart contact

Policy export

Example row: an NEA policy

Broker export

Example row: Marsh McLennan

Broker Office export

Example row: Marsh McLennan, Dallas

Broker Contact export

Example row: a broker contact