Table: Organisational Codes
Primary Key: Organisational
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Organisational ID | Long | 4 | ✓ | |
| Organisational Code | Text | 255 | ||
| Organisational Unit | Text | 255 | ||
| Key Item | Text | 255 | ||
| Organisational Unit Description | Text | 255 | ||
| Organisational Unit Parent | Text | 255 | ||
| Active | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Organisational Codes$Code
- Organisational Codes$ID [PRIMARY KEY] [UNIQUE]
- Organisational Codes$Key Item