Table 1.
Multi-institutional academic trainee interpretation log database schema
| Column name | Data type | Length | Description | Example |
|---|---|---|---|---|
| txtAccNumHash | Text | 35 | Institution followed by 128-bit hashed identifier (e.g., accession number) | SITE-e8919413fd481a5a33448ebe47aa46e2 |
| txtResidentID | Text | 7 | Institutional-specific resident ID | SITE153 |
| txtStudyName | Text | 255 | Study description | CT abdomen and pelvis with IV contrast |
| numGradYear | Integer | 4 | Four-digit year | 2013 |
| dteTimestamp | Date time | N/A | In UTC format | 2013-02-26T13:35-05:00 |
| numCPT | Text | 255 | Best-fit CPT codes, if available | 74177 |
| txtRPID | Text | 8 | Best-fit RadLex Playbook ID, if available | RPID860 |
| txtModality | Text | 4 | DICOM-compatible modality descriptor | CT |
| txtACGMECat | Integer | 2 | Database internal designation for ACGME categories for minimum procedural numbers | 2 |