US DOL Form 5500 Schedule C Part 1 Item 1 Index

Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_LABOR_FORM_5500_SCHEDULE_C_PART1_ITEM1_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
SERVICE_PROVIDER_INDIRECT_COMPENSATION_ELIGIBILITY_ID	Unique identifier for a particular service provider's eligibility for indirect compensation.	VARCHAR	20100709145721P030363363521001_9
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	20240415135510NAL0001181667001
FORM_TYPE	Details which part of the Form 5500 the row was pulled from.	VARCHAR	FORM_5500-SCHEDULE_C-PART_I-ITEM_I
SERVICE_PROVIDER_EIN	The Employer Identification Number (EIN) is a unique nine-digit number assigned by the IRS to the service provider for tax identification purposes.	VARCHAR	231945930
SERVICE_PROVIDER_NAME	The full legal name of the service provider entity or individual.	VARCHAR	WELLS FARGO FUNDS DISTRIBUTOR, LLC
SERVICE_PROVIDER_ADDRESS	The street address where the service provider's office or principal place of business is located.	VARCHAR	1290 AVENUE OF THE AMERICAS
SERVICE_PROVIDER_CITY	The city in which the service provider's office or principal place of business is located.	VARCHAR	MILWAUKEE
SERVICE_PROVIDER_GEO_ID_STATE	The state or territory code where the service provider's office or principal place of business is located, joinable to Cybersyn's GEOGRAPHY tables.	VARCHAR	geoId/20
SERVICE_PROVIDER_GEO_ID_ZIP	The ZIP code or postal code for the service provider's office or principal place of business, joinable to Cybersyn's GEOGRAPHY tables.	VARCHAR	zip/94105
SERVICE_PROVIDER_GEO_ID_COUNTRY	The country where the service provider's office or principal place of business is located, joinable to Cybersyn's GEOGRAPHY tables.	VARCHAR	country/USA