Coverage, missing values and precision
Preserve what the source establishes—and what it does not.
Null is not zero
A numeric zero is a reported or calculated value. null means unavailable or not applicable under the response's definitions. Preserve availability metadata and any reason field. Do not turn a missing loan category into zero, infer a residual category by subtraction, or pad a missing historical quarter.
For example, a non-applicable risk-based capital ratio can be null for a CCULR-elected institution; it is not automatically a zero-percent capital ratio.
Count the right population
Directory records, captured current reports and federally insured filers can be different populations. Use returned coverage counts and labels. A cohort total is not a complete-industry total simply because every captured row was summed.
Members are memberships across institutions, not necessarily unique people across the system. A verified branch count and an office roster count may use different source definitions.
Respect precision and units
Read _usd as dollars and _pct as percentage units. Keep original decimal strings when the source endpoint provides them. Use decimal arithmetic for financial reconciliation and round only for presentation under the field definition.
Do not re-annualize an already annualized ratio or combine quarterly income flows as if they were end-of-period balances. Use metric definitions and period context from the response.
Read relationship evidence
Vendor relationships can be selected, reported live, historical, former or inferred. Preserve the status, source URL, evidence date and product category. An observed product does not establish an entire vendor suite, an exclusive contract, a contract value or a renewal date.
Proposed mergers are proposals. Approvals and completed events retain their own source boundaries. Check the actual event status before triggering a workflow.