Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| patientid | int | 4 | √ | null |
|
|
Patient identifier - Links to the patient who has this identifier |
|
| idvalue | varchar | 30 | √ | null |
|
|
Identifier value - The actual identifier value or number |
|
| IDTypeID | int | 4 | √ | null |
|
|
ID type identifier - Links to identifier type classification |
|
| programID | int | 4 | √ | null |
|
|
Program identifier - Links to program type associated with this ID configuration |
|
| Main | int | 4 | √ | null |
|
|
Main ID flag - Numeric indicator whether this is the main identifier for the program |
|
| AllowDups | int | 4 | √ | null |
|
|
Allow duplicates flag - Numeric indicator whether duplicate values are allowed for this ID type |
|
| maxlength | int | 4 | √ | null |
|
|
Maximum length - Maximum character length allowed for this identifier type |
|
| IDType | varchar | 30 | √ | null |
|
|
ID type name - Descriptive name of the identifier type |
|
| lastName | varchar | 50 | √ | null |
|
|
Patient last name - Last name of the patient from patient demographics |
|
| firstName | varchar | 50 | √ | null |
|
|
Patient first name - First name of the patient from patient demographics |
Relationships
Close relationships within degrees of separation
