Data Dictionary¶
This is a template. Replace every bracketed placeholder. This file itself establishes no policy and defines no real fields until filled in. Every field that appears anywhere in the workbook (input, calculated, or display-only) must have exactly one row here.
| Field ID | Field Name | Business Definition | Data Type | Unit/Format | Required | Default | Allowed Values | Validation | Source | Collection Method | Calculated Status | Business-Rule Reference | Sensitivity Classification | Used By (tabs/calcs) | Display Locations | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| [FIELD-ID] | [name] | [plain-language definition of what this field means to the business/customer] | [text/number/date/currency/percent/boolean/enum] | [e.g. USD, %, YYYY-MM-DD] | [Y/N] | [default value or "none"] | [enumerated list or range, if applicable] | [validation rule applied on entry] | [user-entered / imported / system default] | [manual entry / dropdown / formula] | [Input / Calculated / Display-only] | [reference to calculation-specification.md Calc ID, if applicable] | [Public / Internal / Sensitive-Personal / Sensitive-Financial] | [tab IDs and/or calc IDs] | [where this field is shown to the user] | [anything else relevant] |
| [FIELD-ID] | [name] | [definition] | [type] | [unit/format] | [Y/N] | [default] | [allowed values] | [validation] | [source] | [collection method] | [calculated status] | [rule ref] | [sensitivity] | [used by] | [display locations] | [notes] |
Sensitivity Classification Definitions¶
- Public — no restriction on disclosure.
- Internal — not customer-facing but not personally sensitive.
- Sensitive-Personal — personally identifying or personal-life information.
- Sensitive-Financial — income, account balances, debts, or other financial detail.
Fields classified Sensitive-Personal or Sensitive-Financial must be reviewed against company-level privacy and customer-trust standards before the product ships.
This is a template. Replace bracketed placeholders. This file itself establishes no policy.