US Department Of Labor Form 5500 Broker Index

Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_LABOR_FORM_5500_BROKER_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
BROKER_ID	Unique hash identifying each broker by the broker's name, city, state, and zip.	VARCHAR	a3197045d125f35e8d1bd77ddd1c8046
INSURANCE_POLICY_ID	Unique hash identifying each policy by the plan, acknowledgement id, sponsor EIN, insurance carrier EIN, policy start and end dates, and policy types.	VARCHAR	c949502a0a6d2d1aa928e66188b0684c
ACK_ID	Form acknowledgement ID. Unique identifier for each form 5500 filing.	VARCHAR	20240214110941NAL0047795073001
INSURANCE_BROKER_NAME	Name of the agent, broker, or other person to whom commissions or fees were paid.	VARCHAR	GERALD GREENEN
INSURANCE_BROKER_ADDRESS	Address of the agent, broker, or other person to whom commissions or fees were paid.	VARCHAR	12720 HILLCREST ROAD, SUITE 810-B
INSURANCE_BROKER_CITY	City of the agent, broker, or other person to whom commissions or fees were paid.	VARCHAR	FRESNO
INSURANCE_BROKER_STATE	State of the agent, broker, or other person to whom commissions or fees were paid.	VARCHAR	WI
INSURANCE_BROKER_ZIP	Zip of the agent, broker, or other person to whom commissions or fees were paid.	VARCHAR	75230
COMMISSIONS_PAID_TO_BROKER	All sales and/or base commissions in monetary amount that are paid by an insurer, that are charged directly to the contract or policy and that are paid to a licensed agent or broker for the sale or placement of the contract or policy.	NUMBER	28722
FEES_PAID_TO_BROKER	Payments (excluding sales and/or base commissions) by an insurer attributable directly or indirectly to a contract or policy to agents, brokers, and other persons for items such as service fees, consulting fees, finders fees, profitability and persistency bonuses, awards, prizes, and non-monetary forms of compensation).	NUMBER	912
FEE_NOTES	Notes detailing the purpose of the fees.	VARCHAR	ADDITIONAL COMPENSATION
INSURANCE_BROKER_ORGANIZATION_TYPE	Type of organization that the broker is associated with.	VARCHAR	Insurance Agent or Broker
INSURANCE_BROKER_GEO_ID_CITY	City of the agent, broker, or other person to whom commissions or fees were paid, joinable to GEOGRAPHY_INDEX table.	VARCHAR	geoId/2676460
INSURANCE_BROKER_GEO_ID_STATE	State of the agent, broker, or other person to whom commissions or fees were paid, joinable to GEOGRAPHY_INDEX table.	VARCHAR	geoId/01
INSURANCE_BROKER_GEO_ID_ZIP	Zip of the agent, broker, or other person to whom commissions or fees were paid, joinable to GEOGRAPHY_INDEX table.	VARCHAR	zip/30188