US Department Of Labor Form 5500 Schedule C Part1 Item1 Index

Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_LABOR_FORM_5500_SCHEDULE_C_PART1_ITEM1_INDEX

View data sources, attributes, and sample queries here.

NameDescriptionTypeExample

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

Last updated

Copyright © 2024 Cybersyn