Form 5500 Schedule C Part1 Item3 Index

Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_LABOR_FORM_5500_SCHEDULE_C_PART1_ITEM3_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
SERVICE_PROVIDER_INDIRECT_COMPENSATION_ID	Event identifier for service providers receiving significant indirect compensation, formed from the ACK_ID, SERVICE_CODE, and order of the event listed in the filing.	VARCHAR	20161122175147P040020256599001__
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	20151015144325P040046996535001
FORM_TYPE	Details which part of the Form 5500 the row was pulled from.	VARCHAR	FORM_5500-SCHEDULE_C-PART_I-ITEM_III
SERVICE_PROVIDER_NAME	The full legal name of the service provider entity or individual.	VARCHAR	FIDELITY INVESTMENTS INSTITUTIONAL
SERVICE_CODE	A numerical code representing the specific type of service provided to the plan, such as accounting, legal, investment advisory, etc.	NUMBER	65
SERVICE_DESCRIPTION	A brief narrative description of the nature of the services provided by the service provider to the plan.	VARCHAR	Other services
INDIRECT_COMPENSATION_AMOUNT	The total amount of indirect compensation received by the service provider from a specific source in connection with services rendered to the plan.	FLOAT	0.0
SOURCE_PAYOR_NAME	The name of the entity or individual who paid the indirect compensation to the service provider.	VARCHAR	PAYCHEX, INC.
SOURCE_PAYOR_EIN	The Employer Identification Number (EIN) assigned by the IRS to the source payor of the indirect compensation.	VARCHAR	132624428
INDIRECT_COMPENSATION_EXPLANATION	A detailed description or explanation of the nature of the indirect compensation received, including any relevant details about how it was calculated or the services it pertains to.	VARCHAR	THE FORMULA IS .59% OF THE MARKET VALUE OF THE ASSETS.
SOURCE_PAYOR_ADDRESS	The street address of the source payor who provided the indirect compensation.	VARCHAR	225 PICTORIA DRIVE SUITE 450
SOURCE_PAYOR_CITY	The city in which the source payor is located.	VARCHAR	LUXEMBOURG
SOURCE_PAYOR_GEO_ID_STATE	The state or territory code where the source payor is located, joinable to Cybersyn's GEOGRAPHY tables.	VARCHAR	geoId/36
SOURCE_PAYOR_GEO_ID_ZIP	The ZIP code or postal code for the source payor's address, joinable to Cybersyn's GEOGRAPHY tables.	VARCHAR	zip/14623
SOURCE_PAYOR_GEO_ID_COUNTRY	The country where the source payor is located, joinable to Cybersyn's GEOGRAPHY tables.	VARCHAR	country/USA