US Department Of Labor Form 5500 Schedule C Part2 Index

Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_LABOR_FORM_5500_SCHEDULE_C_PART2_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
SERVICE_PROVIDER_NONCOMPLIANCE_ID	Event identifier for a particular service provider failing to provide the required information to complete Schedule C.	VARCHAR	20201015140825NAL0005329571001_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	20210413152455NAL0006953825001
FORM_TYPE	Details which part of the Form 5500 the row was pulled from.	VARCHAR	FORM_5500-SCHEDULE_C-PART_II
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	830395113
SERVICE_PROVIDER_NAME	The full legal name of the service provider entity or individual.	VARCHAR	TRANSUNION RISK & ALTERNATIVE DATA
SERVICE_CODE	A numerical code representing the specific type of service provided to the plan, such as accounting, legal, investment advisory, etc.	VARCHAR	52
SERVICE_DESCRIPTION	A brief narrative description of the nature of the services provided by the service provider to the plan.	VARCHAR	Other services
NONCOMPLIANCE_EXPLANATION	A detailed description of the reasons why a service provider failed or refused to provide the required information necessary to complete Schedule C. This includes an account of the steps taken by the plan administrator to obtain the information and the circumstances leading to the noncompliance.	VARCHAR	FAILED TO PROVIDE INFORMATION
SERVICE_PROVIDER_ADDRESS	The street address where the service provider's office or principal place of business is located.	VARCHAR	1 TRANSAM PLAZA DRIVE, SUITE 360
SERVICE_PROVIDER_CITY	The city in which the service provider's office or principal place of business is located.	VARCHAR	TORONTO ON
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/45202
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