US Department Of Labor Form 5500 Schedule C Part3 Index

Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_LABOR_FORM_5500_SCHEDULE_C_PART3_INDEX

View data sources, attributes, and sample queries here.

NameDescriptionTypeExample

SERVICE_PROVIDER_TERMINATION_ID

Unique identifier for a particular service provider termination event.

VARCHAR

20201014145222NAL0004142915001_1

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

20161017141740P030020356605001

FORM_TYPE

Details which part of the Form 5500 the row was pulled from.

VARCHAR

FORM_5500-SCHEDULE_C-PART_III

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

741550819

SERVICE_PROVIDER_NAME

The full legal name of the service provider entity or individual.

VARCHAR

LINK, MURREL & COMPANY

SERVICE_PROVIDER_POSITION

The role or job title of the individual within the service provider organization responsible for the services rendered to the plan.

VARCHAR

ACCOUNTANT

TERMINATION_EXPLANATION

A detailed reason or justification for the termination of the service provider's contract or services during the plan year.

VARCHAR

INCREASE IN HIS TAX WORKLOAD DOES NOT ALLOW TIME FOR AUDITS

SERVICE_PROVIDER_ADDRESS

The street address where the service provider's office or principal place of business is located.

VARCHAR

9309 GLACIER HWY STE B-200

SERVICE_PROVIDER_CITY

The city in which the service provider's office or principal place of business is located.

VARCHAR

HOUSTON

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/06

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/21045

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

SERVICE_PROVIDER_PHONE_NUM

The telephone number where the service provider can be contacted for business purposes.

VARCHAR

2704433643

Last updated

Copyright © 2024 Cybersyn