A curated collection of standardized data definitions, abbreviations, and naming conventions for enterprise data architecture.
This repository contains sample data definitions from mdatool.com - the world's largest library of standardized database terminology across 6 industry domains.
Perfect for:
- 🏥 Healthcare data architects
- 💰 Financial data engineers
- 🛒 E-commerce platform builders
- 🚚 Supply chain data modelers
- 💊 Pharmacy system designers
- 💻 Software engineering teams
| Domain | Definitions | Sample |
|---|---|---|
| Healthcare | 4,600+ | View Samples |
| Banking & Finance | 2,100+ | View Samples |
| Retail & E-commerce | 1,600+ | View Samples |
| Software | 3,300+ | View Samples |
| Pharmacy | 400+ | View Samples |
| Global Fleet | 400+ | View Samples |
Total: 17,000+ verified definitions | Browse all →
PHI (Protected Health Information)
Definition: Any individually identifiable health information transmitted or maintained
by a covered entity, protected under HIPAA regulations.
Common Fields:
- patient_id
- medical_record_number
- diagnosis_code (ICD-10)
- procedure_code (CPT)
Standards: HIPAA, HL7 FHIR
HCC (Hierarchical Condition Category)
Definition: Risk adjustment model used by CMS to calculate Medicare Advantage payments
based on patient health status and predicted healthcare costs.
Common Fields:
- hcc_code
- hcc_description
- risk_score
- capture_date
Standards: CMS-HCC Model V28
→ See 4,600+ Healthcare definitions
AML (Anti-Money Laundering)
Definition: Set of procedures and regulations designed to prevent criminals from
disguising illegally obtained funds as legitimate income.
Common Fields:
- transaction_amount
- suspicious_activity_flag
- kyc_status
- screening_result
Standards: BSA, FinCEN, FATF
SWIFT (Society for Worldwide Interbank Financial Telecommunication)
Definition: Global messaging network for secure financial transactions between banks.
Common Fields:
- swift_code (BIC)
- iban
- wire_reference_number
- settlement_date
Standards: ISO 9362, ISO 20022
→ See 2,100+ Finance definitions
Beyond definitions, mdatool.com provides free engineering tools:
Convert DDL between Oracle, PostgreSQL, MySQL, SQL Server, Snowflake
-- Oracle
CREATE TABLE employees (
employee_id NUMBER(10),
hire_date DATE DEFAULT SYSDATE
);
-- Auto-converts to PostgreSQL →
CREATE TABLE employees (
employee_id INTEGER,
hire_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);Catch security issues and performance problems
-- Detects:
✗ SELECT * usage
✗ Missing WHERE clause on UPDATE
✗ SQL injection vulnerabilities
✗ Functions on indexed columns
✓ Suggests optimizationsEnforce consistent naming conventions
-- Flags inconsistencies:
✗ CustomerID (PascalCase)
✗ product_name (snake_case)
✗ orderDate (camelCase)
✓ Suggests: customer_id, product_name, order_dateawesome-data-definitions/
├── healthcare/
│ └── common-terms.md
├── banking-finance/
│ └── payment-terms.md
├── retail-ecommerce/
│ └── order-management.md
├── software/
│ └── database-terms.md
├── pharmacy/
│ └── prescription-fields.md
├── global-fleet/
│ └── logistics-terms.md
└── naming-conventions/
├── snake-case-guide.md
├── database-standards.md
└── industry-best-practices.md
- Blog: Engineering guides and best practices
- Glossary: Browse all 17,000+ definitions
- Naming Guide: Complete database naming conventions
Want to add definitions or suggest improvements?
- This is a sample repository - full database at mdatool.com
- Submit suggestions via Issues
- For enterprise contributions, email: admin@mdatool.com
See CONTRIBUTING.md for details.
MIT License - see LICENSE file for details.
Sample definitions are provided for reference. Full access available at mdatool.com.
If you find this helpful:
- ⭐ Star this repository
- 🔗 Share with your team
- 🐦 Follow updates at mdatool.com
Built for data professionals, by data professionals.