Back to packs

SEC Form PF

SEC_FORM_PFfree

10 data-quality rules for SEC Form PF, filed by SEC-registered private fund advisers via the PFRD/IARD system. Covers required adviser/fund identifiers (CRD, CIK, fund ID/LEI), fund-type validity, non-negative gross/net assets, AUM consistency, reporting period, and duplicate suppression. Use it to validate Form PF data before filing.

10 rules 0 downloadsNo ratings yet
secform-pfprivate-fundsasset-managementregulatory-reporting
0.0(0 ratings)

Sign in to rate this pack

Test this pack with your data

Download the template, fill in your data, and see quality results instantly.

Test This Pack

Download & Install

Choose your tool — get a ready-to-run file

Run this on your data? Upload your CSV — we'll auto-map the columns, validate, and report the bad rows.Test my dataWant this certified on your data? Book a 30-min demo.Book a demo
Or use the CLI
$ npx dqhub install sec-form-pf --format soda --table YOUR_TABLE

Reference data required

This contract's checks join against 2 reference tables. Load them into your warehouse — DQHub ships the public ones, the rest link to their source. All reference data →

Bundled — download
Customer-loaded — source

About this pack

10 data-quality rules for SEC Form PF, filed by SEC-registered private fund advisers via the PFRD/IARD system. Covers required adviser/fund identifiers (CRD, CIK, fund ID/LEI), fund-type validity, non-negative gross/net assets, AUM consistency, reporting period, and duplicate suppression. Use it to validate Form PF data before filing.

What's included

3completeness rules
2referential integrity rules
2range rules
1format rules
1consistency rules
1uniqueness rules

Checks included (10)

Required Adviser/Fund Identifiers Present

Each filing must carry the adviser CRD number, fund identification number, and the reporting period end.

Private Fund Identifier Present(fund_id)

The private fund identification number (915-prefixed) must be present.

Reporting Period End Present(reporting_period_end)

The reporting period end date must be present.

Adviser CRD Is Registered

The adviser CRD number must exist in the IARD adviser registry.

Reporting Currency Is Valid ISO 4217

The reporting currency must be a valid ISO 4217 code.

Gross Asset Value Is Non-Negative(gross_asset_value)

Reported gross asset value cannot be negative.

Borrowings Are Non-Negative(total_borrowings)

Reported borrowings/leverage amounts cannot be negative.

Fund Type Is Valid(fund_type)

Fund type must be a Form PF category (hedge_fund, liquidity_fund, private_equity_fund, real_estate_fund, securitized_asset_fund, other).

Net Assets Do Not Exceed Gross Assets

Net asset value should not exceed gross asset value for a fund.

One Filing per Fund per Period(fund_period_key)

A fund should appear once per reporting period in a filing.