US Department of Labor Form 5500 Policy Index

Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_LABOR_FORM_5500_POLICY_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
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	d817fbfed94727a09c37f490c0d22c2a
ACK_ID	Form acknowledgement ID. Unique identifier for each form 5500 filing. Can be used to join to the filing index table to identify submissions.	VARCHAR	20220721142437NAL0003954128001
PLAN_NAME	Name of the plan.	VARCHAR	MIDWEST TELEVISION, INC.
POLICY_START_DATE	Date of policy start.	DATE	2011-01-01
POLICY_END_DATE	Date of policy end.	DATE	2018-12-31
PLAN_FIRST_EFFECTIVE_DATE	Date when this plan became effective. This is a different property from the policy_start_date. The plan effective date can be used to reference the duration of the plan's lifespan, while the policy_start_date and policy_end_date refers to the duration of a policy covering a portion of the plan's lifespan.	DATE	1988-07-01
INSURANCE_CARRIER_NAIC_CODE	The carrier's unique NAIC (National Association of Insurance Commissioner's) code. Note - this is separate from a NAICS (North American Industry Classification System) identifier.	VARCHAR	65978
INSURANCE_CARRIER_EIN	EIN (Employer Identification Number) of the insurance carrier.	VARCHAR	135123390
INSURANCE_CARRIER_NAME	Name of the insurance carrier.	VARCHAR	ANTHEM HEALTH PLANS OF MAINE, INC.
EMPLOYEES_COVERED_EOY	Number of employees covered under the plan at the end of the policy year.	NUMBER	522
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.	FLOAT	51570.0
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).	FLOAT	95975.0
INSURANCE_TYPES	Array containing the text descriptions of the types of insurance indicated for this policy.	ARRAY	[ "Health Insurance", "Prescription Drug Insurance", "HMO ...
IS_FIRST_PLAN_FILING	Indicates if this is the first form 5500 filing for the plan.	BOOLEAN	False
IS_FINAL_PLAN_FILING	Indicates if this is expected to be the last filing for the plan.	BOOLEAN	False