ds_form_5500_filings_2025_v1


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACK_ID text 2147483647 √ null
FORM_PLAN_YEAR_BEGIN_DATE date 13 √ null
FORM_TAX_PRD date 13 √ null
TYPE_PLAN_ENTITY_CD int8 19 √ null
TYPE_DFE_PLAN_ENTITY_CD text 2147483647 √ null
INITIAL_FILING_IND int8 19 √ null
AMENDED_IND int8 19 √ null
FINAL_FILING_IND int8 19 √ null
SHORT_PLAN_YR_IND int8 19 √ null
COLLECTIVE_BARGAIN_IND int8 19 √ null
F5558_APPLICATION_FILED_IND int8 19 √ null
EXT_AUTOMATIC_IND int8 19 √ null
DFVC_PROGRAM_IND int8 19 √ null
EXT_SPECIAL_IND int8 19 √ null
EXT_SPECIAL_TEXT text 2147483647 √ null
PLAN_NAME text 2147483647 √ null
SPONS_DFE_PN text 2147483647 √ null
PLAN_EFF_DATE date 13 √ null
text 2147483647 √ null
SPONS_DFE_DBA_NAME text 2147483647 √ null
SPONS_DFE_CARE_OF_NAME text 2147483647 √ null
SPONS_DFE_MAIL_US_ADDRESS1 text 2147483647 √ null
SPONS_DFE_MAIL_US_ADDRESS2 text 2147483647 √ null
SPONS_DFE_MAIL_US_CITY text 2147483647 √ null
SPONS_DFE_MAIL_US_STATE text 2147483647 √ null
SPONS_DFE_MAIL_US_ZIP text 2147483647 √ null
SPONS_DFE_MAIL_FOREIGN_ADDR1 text 2147483647 √ null
SPONS_DFE_MAIL_FOREIGN_ADDR2 text 2147483647 √ null
SPONS_DFE_MAIL_FOREIGN_CITY text 2147483647 √ null
SPONS_DFE_MAIL_FORGN_PROV_ST text 2147483647 √ null
SPONS_DFE_MAIL_FOREIGN_CNTRY text 2147483647 √ null
SPONS_DFE_MAIL_FORGN_POSTAL_CD text 2147483647 √ null
SPONS_DFE_LOC_US_ADDRESS1 text 2147483647 √ null
SPONS_DFE_LOC_US_ADDRESS2 text 2147483647 √ null
SPONS_DFE_LOC_US_CITY text 2147483647 √ null
SPONS_DFE_LOC_US_STATE text 2147483647 √ null
SPONS_DFE_LOC_US_ZIP text 2147483647 √ null
SPONS_DFE_LOC_FOREIGN_ADDRESS1 text 2147483647 √ null
SPONS_DFE_LOC_FOREIGN_ADDRESS2 text 2147483647 √ null
SPONS_DFE_LOC_FOREIGN_CITY text 2147483647 √ null
SPONS_DFE_LOC_FORGN_PROV_ST text 2147483647 √ null
SPONS_DFE_LOC_FOREIGN_CNTRY text 2147483647 √ null
SPONS_DFE_LOC_FORGN_POSTAL_CD int8 19 √ null
SPONS_DFE_EIN text 2147483647 √ null
SPONS_DFE_PHONE_NUM text 2147483647 √ null
BUSINESS_CODE text 2147483647 √ null
ADMIN_NAME text 2147483647 √ null
ADMIN_CARE_OF_NAME text 2147483647 √ null
ADMIN_US_ADDRESS1 text 2147483647 √ null
ADMIN_US_ADDRESS2 text 2147483647 √ null
ADMIN_US_CITY text 2147483647 √ null
ADMIN_US_STATE text 2147483647 √ null
ADMIN_US_ZIP text 2147483647 √ null
ADMIN_FOREIGN_ADDRESS1 text 2147483647 √ null
ADMIN_FOREIGN_ADDRESS2 text 2147483647 √ null
ADMIN_FOREIGN_CITY text 2147483647 √ null
ADMIN_FOREIGN_PROV_STATE text 2147483647 √ null
ADMIN_FOREIGN_CNTRY text 2147483647 √ null
ADMIN_FOREIGN_POSTAL_CD int8 19 √ null
ADMIN_EIN text 2147483647 √ null
ADMIN_PHONE_NUM int8 19 √ null
LAST_RPT_SPONS_NAME text 2147483647 √ null
LAST_RPT_SPONS_EIN text 2147483647 √ null
LAST_RPT_PLAN_NUM text 2147483647 √ null
ADMIN_SIGNED_DATE text 2147483647 √ null
ADMIN_SIGNED_NAME text 2147483647 √ null
SPONS_SIGNED_DATE text 2147483647 √ null
SPONS_SIGNED_NAME text 2147483647 √ null
DFE_SIGNED_DATE text 2147483647 √ null
DFE_SIGNED_NAME text 2147483647 √ null
TOT_PARTCP_BOY_CNT int8 19 √ null
TOT_ACTIVE_PARTCP_CNT int8 19 √ null
RTD_SEP_PARTCP_RCVG_CNT int8 19 √ null
RTD_SEP_PARTCP_FUT_CNT int8 19 √ null
SUBTL_ACT_RTD_SEP_CNT int8 19 √ null
BENEF_RCVG_BNFT_CNT int8 19 √ null
TOT_ACT_RTD_SEP_BENEF_CNT int8 19 √ null
PARTCP_ACCOUNT_BAL_CNT int8 19 √ null
SEP_PARTCP_PARTL_VSTD_CNT int8 19 √ null
CONTRIB_EMPLRS_CNT int8 19 √ null
TYPE_PENSION_BNFT_CODE text 2147483647 √ null
TYPE_WELFARE_BNFT_CODE text 2147483647 √ null
FUNDING_INSURANCE_IND int8 19 √ null
FUNDING_SEC412_IND int8 19 √ null
FUNDING_TRUST_IND int8 19 √ null
FUNDING_GEN_ASSET_IND int8 19 √ null
BENEFIT_INSURANCE_IND int8 19 √ null
BENEFIT_SEC412_IND int8 19 √ null
BENEFIT_TRUST_IND int8 19 √ null
BENEFIT_GEN_ASSET_IND int8 19 √ null
SCH_R_ATTACHED_IND int8 19 √ null
SCH_MB_ATTACHED_IND int8 19 √ null
SCH_SB_ATTACHED_IND int8 19 √ null
SCH_H_ATTACHED_IND int8 19 √ null
SCH_I_ATTACHED_IND int8 19 √ null
SCH_A_ATTACHED_IND int8 19 √ null
NUM_SCH_A_ATTACHED_CNT text 2147483647 √ null
SCH_C_ATTACHED_IND int8 19 √ null
SCH_D_ATTACHED_IND int8 19 √ null
SCH_G_ATTACHED_IND int8 19 √ null
FILING_STATUS text 2147483647 √ null
DATE_RECEIVED date 13 √ null
VALID_ADMIN_SIGNATURE text 2147483647 √ null
VALID_DFE_SIGNATURE text 2147483647 √ null
VALID_SPONSOR_SIGNATURE text 2147483647 √ null
ADMIN_PHONE_NUM_FOREIGN int8 19 √ null
SPONS_DFE_PHONE_NUM_FOREIGN int8 19 √ null
ADMIN_NAME_SAME_SPON_IND int8 19 √ null
ADMIN_ADDRESS_SAME_SPON_IND text 2147483647 √ null
PREPARER_NAME text 2147483647 √ null
PREPARER_FIRM_NAME text 2147483647 √ null
PREPARER_US_ADDRESS1 text 2147483647 √ null
PREPARER_US_ADDRESS2 text 2147483647 √ null
PREPARER_US_CITY text 2147483647 √ null
PREPARER_US_STATE text 2147483647 √ null
PREPARER_US_ZIP text 2147483647 √ null
PREPARER_FOREIGN_ADDRESS1 text 2147483647 √ null
PREPARER_FOREIGN_ADDRESS2 text 2147483647 √ null
PREPARER_FOREIGN_CITY text 2147483647 √ null
PREPARER_FOREIGN_PROV_STATE text 2147483647 √ null
PREPARER_FOREIGN_CNTRY text 2147483647 √ null
PREPARER_FOREIGN_POSTAL_CD text 2147483647 √ null
PREPARER_PHONE_NUM text 2147483647 √ null
PREPARER_PHONE_NUM_FOREIGN text 2147483647 √ null
TOT_ACT_PARTCP_BOY_CNT int8 19 √ null
SUBJ_M1_FILING_REQ_IND int8 19 √ null
COMPLIANCE_M1_FILING_REQ_IND int8 19 √ null
M1_RECEIPT_CONFIRMATION_CODE int8 19 √ null
ADMIN_MANUAL_SIGNED_DATE text 2147483647 √ null
ADMIN_MANUAL_SIGNED_NAME text 2147483647 √ null
LAST_RPT_PLAN_NAME text 2147483647 √ null
SPONS_MANUAL_SIGNED_DATE text 2147483647 √ null
SPONS_MANUAL_SIGNED_NAME text 2147483647 √ null
DFE_MANUAL_SIGNED_DATE text 2147483647 √ null
DFE_MANUAL_SIGNED_NAME text 2147483647 √ null
ADOPTED_PLAN_PERM_SEC_ACT int8 19 √ null
PARTCP_ACCOUNT_BAL_CNT_BOY int8 19 √ null
SCH_DCG_ATTACHED_IND int8 19 √ null
NUM_SCH_DCG_ATTACHED_CNT int8 19 √ null
SCH_MEP_ATTACHED_IND int8 19 √ null

Relationships

Close relationships within degrees of separation