Form 5500 Schedule H Timeseries

Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_LABOR_FORM_5500_SCHEDULE_H_TIMESERIES

View data sources, attributes, and sample queries here.

NameDescriptionTypeExample

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

20181015123139P030098990047001

SPONSOR_EIN

EIN (Employer Identification Number) of this plan sponsor.

VARCHAR

221466804

PLAN_NUMBER

Three-digit plan number (PN).

VARCHAR

001

VARIABLE

Unique identifier for a variable, joinable to the timeseries table.

VARCHAR

INS_CO_GEN_ACCT_EOY_AMT

VARIABLE_NAME

Human-readable unique name for the variable.

VARCHAR

Assets | General investments | Value of funds held in insurance ...

DATE

Date associated with the value.

VARCHAR

2017-12-31

VALUE

Value reported for the variable.

FLOAT

430342.0

UNIT

Unit of measurement for the reported value.

VARCHAR

USD

Last updated

Copyright © 2024 Cybersyn