US Department Of Labor Form 5500 Filing Index

Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_LABOR_FORM_5500_FILING_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
ACK_ID	Form acknowledgement ID. Unique identifier for each form 5500 filing. Can be used to join to the policy index table to find attached insurance policies.	VARCHAR	20180227130441P030004915093001
FORM_TYPE	Identifies this as a standard Form 5500 filing.	VARCHAR	FORM_5500
SPONSOR_EIN	EIN (Employer Identification Number) of this plan sponsor.	VARCHAR	300524186
SPONSOR_NAME	Name of this plan sponsor, which is the employer providing the benefit plan.	VARCHAR	EMS ENGINEERED MATERIALS SOLUTIONS, LLC
SPONSOR_NAICS_CODE	NAICS (North American Industry Classification System) identifier of this plan sponsor.	VARCHAR	339900
SPONSOR_NAICS_DESCRIPTION	Text description of the NAICS identifier of this plan sponsor.	VARCHAR	Other Fabricated Metal Product Manufacturing
IS_AMENDED_FILING	Indicates whether this is an amended filing to correct any errors and/or omissions to an earlier filing for this period.	BOOLEAN	False
ADMIN_SIGNED_NAME	Name of individual signing as plan administrator, which is someone authorized to act on behalf of the plan sponsor and oversee the operations and administration of the plan. Either the plan sponsor or plan administrator must sign the filing.	VARCHAR	MICHELLE DAVIS
SPONSOR_SIGNED_NAME	Name of individual signing as employer or plan sponsor. Either the plan sponsor or plan administrator must sign the filing.	VARCHAR	KENNETH HEBERT
DIRECT_FILING_ENTITY_SIGNED_NAME	Name of individual signing as direct filing entity (DFE). DFEs are investment arrangements such as trusts that manage money from several plans. For DFE Form 5500 filings, a person authorized to sign on behalf of the DFE must sign the filing.	VARCHAR	KARI BLACKLEDGE
ADMIN_PHONE_NUM	Phone number of the plan administrator.	VARCHAR	8002502741
SPONSOR_DIRECT_FILING_ENTITY_PHONE_NUM	Phone number of the plan sponsor or direct filing entity (DFE).	VARCHAR	7606996800
PREPARER_PHONE_NUM	Phone number of the authorized Form 5500 filing preparer - a third-party preparer may be authorized to sign and submit the electronic filing on behalf of the plan administrator, plan sponsor or DFE.	VARCHAR	5162485000
SPONSOR_ADDRESS	Street address of the plan sponsor.	VARCHAR	1901 INDIAN WOOD CIRCLE
SPONSOR_CITY	City of the plan sponsor.	VARCHAR	CHARLOTTE
SPONSOR_STATE	State of the plan sponsor.	VARCHAR	MO
SPONSOR_ZIP	Zip code of the plan sponsor.	VARCHAR	67209
SPONSOR_GEO_ID_CITY	A unique identifier of the city where the sponsoring business is headquartered. Joinable to the GEOGRAPHY_INDEX table.	VARCHAR	geoId/4004450
SPONSOR_GEO_ID_STATE	A unique identifier of the state where the sponsoring business is headquartered. Joinable to the GEOGRAPHY_INDEX table.	VARCHAR	geoId/17
SPONSOR_GEO_ID_ZIP	A unique identifier of the zip code where the sponsoring business is headquartered. Joinable to the GEOGRAPHY_INDEX table.	VARCHAR	zip/67209
REPORTING_PERIOD_START_DATE	Starting date of the filing period.	DATE	2010-10-01
REPORTING_PERIOD_END_DATE	Ending date of the filing period.	DATE	2015-09-30
FILING_DATE	Date this filing was received.	DATE	2012-03-05