Form 5500 Schedule C Part1 Item2 Index

Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_LABOR_FORM_5500_SCHEDULE_C_PART1_ITEM2_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
SERVICE_PROVIDER_COMPENSATION_ID	An identifier for an event of a service provider receiving direct or indirect compensation, formed from the ACK_ID, SERVICE_CODE, and order of the event listed in the filing.	VARCHAR	20230209132649NAL0031092705002___
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	20101221130252P030000765681001
FORM_TYPE	Details which part of the Form 5500 the row was pulled from.	VARCHAR	FORM_5500-SCHEDULE_C-PART_I-ITEM_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	060303370
SERVICE_PROVIDER_NAME	The full legal name of the service provider entity or individual.	VARCHAR	FOSTER & FOSTER, INC.
SERVICE_CODE	A numerical code representing the specific type of service provided to the plan, such as accounting, legal, investment advisory, etc.	NUMBER	14
SERVICE_DESCRIPTION	A brief narrative description of the nature of the services provided by the service provider to the plan.	VARCHAR	Consulting (pension)
SERVICE_PROVIDER_RELATIONSHIP	Information describing any relationship or arrangement between the service provider and the plan that might create a conflict of interest.	VARCHAR	FUND MANAGEMENT
DIRECT_COMPENSATION_AMOUNT	The total amount of direct compensation paid by the plan to the service provider during the plan year.	FLOAT	0.0
INDIRECT_COMPENSATION_FLAG	A Boolean showing whether the service provider received any indirect compensation in connection with services to the plan.	BOOLEAN	False
ELIGIBLE_INDIRECT_COMPENSATION_FLAG	A Boolean showing whether the indirect compensation received by the service provider qualifies as eligible indirect compensation under the plan’s rules.	BOOLEAN	True
INDIRECT_COMPENSATION_AMOUNT	The total amount of indirect compensation received by the service provider from sources other than the plan or plan sponsor.	FLOAT	0.0
FORMULA_GIVEN_FLAG	A Boolean showing whether the service provider provided a formula to determine the indirect compensation instead of an exact amount or estimated amount.	BOOLEAN	False
SERVICE_PROVIDER_ADDRESS	The street address where the service provider's office or principal place of business is located.	VARCHAR	4321 20TH AVENUE SOUTH
SERVICE_PROVIDER_CITY	The city in which the service provider's office or principal place of business is located.	VARCHAR	PHOENIX
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/39
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/58103
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