US DOL Form 5500 Schedule C Part 3 Index
Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_LABOR_FORM_5500_SCHEDULE_C_PART3_INDEX
| Name | Description | Type | Example |
|---|---|---|---|
| Unique identifier for a particular service provider termination event. | VARCHAR |
|
| 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 |
|
| Details which part of the Form 5500 the row was pulled from. | VARCHAR |
|
| The Employer Identification Number (EIN) is a unique nine-digit number assigned by the IRS to the service provider for tax identification purposes. | VARCHAR |
|
| The full legal name of the service provider entity or individual. | VARCHAR |
|
| The role or job title of the individual within the service provider organization responsible for the services rendered to the plan. | VARCHAR |
|
| A detailed reason or justification for the termination of the service provider's contract or services during the plan year. | VARCHAR |
|
| The street address where the service provider's office or principal place of business is located. | VARCHAR |
|
| The city in which the service provider's office or principal place of business is located. | VARCHAR |
|
| 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 |
|
| The ZIP code or postal code for the service provider's office or principal place of business, joinable to Cybersyn's GEOGRAPHY tables. | VARCHAR |
|
| The country where the service provider's office or principal place of business is located, joinable to Cybersyn's GEOGRAPHY tables. | VARCHAR |
|
| The telephone number where the service provider can be contacted for business purposes. | VARCHAR |
|
Last updated