| organisationguid | varchar | Unique identifier for the organisation. Part of the composite primary key. | {C3D4E5F6-A7B8-9012-CDEF-123456789012} | 38 | False |
| cdb | integer | EMIS Configuration Database identifier for the organisation. | 50002 | 4 | True |
| organisationname | varchar | The registered name of the organisation. | Anytown Medical Centre | 200 | False |
| odscode | varchar | ODS (Organisation Data Service) code — the NHS standard identifier for the organisation. | A81001 | 20 | True |
| parentorganisationguid | varchar | References the parent organisation (e.g., a federation or group practice). | {D4E5F6A7-B8C9-0123-DEFA-234567890123} | 38 | False |
| ccgorganisationguid | varchar | References the commissioning body responsible for this organisation (historically the CCG; CCGs were abolished in 2022 and replaced by Integrated Care Boards). This field represents the grandparent organisation in the hierarchy. | {E5F6A7B8-C9D0-1234-EFAB-345678901234} | 38 | True |
| organisationtype | varchar | Classifies the organisation type (e.g., GP Practice, Out of Hours, Community). | GP Practice | 50 | True |
| opendate | date | The date the organisation was registered as active. | 1995-04-01 | 3 | False |
| closedate | date | The date the organisation closed. Null if still active. | 2024-03-31 | 3 | True |
| mainlocationguid | varchar | References the primary physical location of the organisation in Admin_Location. | {A1B2C3D4-E5F6-7890-ABCD-EF1234567890} | 38 | False |