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	20181012154254P030239897847001
FORM_TYPE	Identifies this as a standard Form 5500 filing.	VARCHAR	FORM_5500
SPONSOR_EIN	EIN (Employer Identification Number) of this plan sponsor.	VARCHAR	752261257
SPONSOR_NAME	Name of this plan sponsor, which is the employer providing the benefit plan.	VARCHAR	PURVIS SYSTEMS INC
SPONSOR_NAICS_CODE	NAICS (North American Industry Classification System) identifier of this plan sponsor.	VARCHAR	622000
SPONSOR_NAICS_DESCRIPTION	Text description of the NAICS identifier of this plan sponsor.	VARCHAR	Insurance and Employee Benefit Funds
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	LELA M. LUXEN
SPONSOR_SIGNED_NAME	Name of individual signing as employer or plan sponsor. Either the plan sponsor or plan administrator must sign the filing.	VARCHAR	DARPAN BHARGAVA
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	PATRICK DOYLE
ADMIN_PHONE_NUM	Phone number of the plan administrator.	VARCHAR	7878985000
SPONSOR_DIRECT_FILING_ENTITY_PHONE_NUM	Phone number of the plan sponsor or direct filing entity (DFE).	VARCHAR	5618422458
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	4172353650
SPONSOR_ADDRESS	Street address of the plan sponsor.	VARCHAR	401 TERRY AVE N
SPONSOR_CITY	City of the plan sponsor.	VARCHAR	MEMPHIS
SPONSOR_STATE	State of the plan sponsor.	VARCHAR	TN
SPONSOR_ZIP	Zip code of the plan sponsor.	VARCHAR	75251
SPONSOR_GEO_ID_CITY	A unique identifier of the city where the sponsoring business is headquartered. Joinable to the GEOGRAPHY_INDEX table.	VARCHAR	geoId/0178264
SPONSOR_GEO_ID_STATE	A unique identifier of the state where the sponsoring business is headquartered. Joinable to the GEOGRAPHY_INDEX table.	VARCHAR	geoId/39
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/35490
REPORTING_PERIOD_START_DATE	Starting date of the filing period.	DATE	2016-01-01
REPORTING_PERIOD_END_DATE	Ending date of the filing period.	DATE	2010-12-31
FILING_DATE	Date this filing was received.	DATE	2012-01-30