FRBP 9037: redaction requirements for federal bankruptcy filings

Source: 04-frbp-9037.phisql (spec v1.0)

PhiSQL

-- FRBP 9037: redaction requirements for federal bankruptcy filings.
-- SSN to last 4, dates to year only, surnames to initials, accounts to last 4.
-- Demonstrates custom IDENTIFIER references.
-- Broader than the rule: FRBP 9037(a) limits only birth dates to the year and
-- only minors' names to initials, but PhiSQL cannot yet tell those apart, so
-- this truncates every date and abbreviates every surname.
-- Compiles to 04-frbp-9037.json.

POLICY frbp_9037
  DESCRIPTION 'FRBP 9037: SSN to last 4, dates to year only, accounts to last 4.';

DEIDENTIFY
  SSN     AS LAST_4,
  DATE    AS TRUNCATE_TO_YEAR,
  SURNAME AS ABBREVIATE;

REDACT IDENTIFIER('account_number') WITH LAST_4;

Compiles to

{
  "metadata": {
    "description": "FRBP 9037: SSN to last 4, dates to year only, accounts to last 4."
  },
  "identifiers": {
    "ssn": {
      "ssnFilterStrategies": [{ "strategy": "LAST_4" }]
    },
    "date": {
      "dateFilterStrategies": [{ "strategy": "TRUNCATE_TO_YEAR" }]
    },
    "surname": {
      "surnameFilterStrategies": [{ "strategy": "ABBREVIATE" }]
    },
    "identifiers": [
      {
        "classification": "account_number",
        "identifierFilterStrategies": [{ "strategy": "LAST_4" }]
      }
    ]
  }
}