OrganisationSites


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null
GermlineTesting.ReportingLabOrganisation FK_GermlineTesting_OrganisationSitesR
SomaticTesting.ReportingOrganisationID FK_SomaticTesting_OrganisationSitesR
tblAHP_CONTACTS.OrganisationID FK_tblAHP_CONTACTS_OrganisationSitesR
tblAO_ASSESSMENT.AssessmentOrganisationID FK_tblAO_ASSESSMENT_OrganisationSitesR
tblBRAIN_MDT.LabReportOrgID FK_tblBRAIN_MDT_OrganisationSites1R
tblBRAIN_MDT.MiscLabReportOrgID FK_tblBRAIN_MDT_OrganisationMiscSitesR
tblBRAIN_MDT.StageBrainOrgID FK_tblBRAIN_MDT_OrganisationSitesR
tblBREAST_MDT.MiscLabReportOrgID FK_tblBREAST_MDT_OrganisationSitesR
tblCNSContact.L_ORGANISATION FK_tblCNSContact_L_ORGANISATION_OrganisationSitesR
tblCOLORECTAL_MDT.MiscLabReportOrgID FK_tblCOLORECTAL_MDT_OrganisationMiscSitesR
tblCUP_MDT.MiscLabReportOrgID FK_tblCUP_MDT_OrganisationMiscSitesR
tblGYNAECOLOGY_MDT.MiscLabReportOrgID FK_tblGYNAECOLOGY_MDT_OrganisationMiscSitesR
tblGYNAECOLOGY_MDT.StageGynaeOrgID FK_tblGYNAECOLOGY_MDT_OrganisationSitesR
tblHAEMATOLOGY_MDT.LabLeukaemiaOrgID FK_tblHAEMATOLOGY_MDT_OrganisationSites3R
tblHAEMATOLOGY_MDT.LabMyelodysplasiaOrgID FK_tblHAEMATOLOGY_MDT_OrganisationSites4R
tblHAEMATOLOGY_MDT.LabResponseOrgID FK_tblHAEMATOLOGY_MDT_OrganisationSites2R
tblHAEMATOLOGY_MDT.MiscLabReportOrgID FK_tblHAEMATOLOGY_MDT_OrganisationMiscSitesR
tblHAEMATOLOGY_MDT.StageLeukaemiaOrgID FK_tblHAEMATOLOGY_MDT_OrganisationSites1R
tblHAEMATOLOGY_MDT.StageLymphomaOrgID FK_tblHAEMATOLOGY_MDT_OrganisationSitesR
tblHEAD_NECK_MDT.MiscLabReportOrgID FK_tblHEAD_NECK_MDT_OrganisationMiscSitesR
tblLUNG_MDT.MiscLabReportOrgID FK_tblLUNG_MDT_OrganisationMiscSitesR
tblMAIN_REFERRALS.FasterDiagnosisOrganisationID FK_tblMAIN_REFERRALS_OrganisationSitesR
tblMAIN_REFERRALS.LabReportOrgID FK_tblMAIN_REFERRALS_OrganisationSites1R
tblOTHER_MDT.MiscLabReportOrgID FK_tblOTHER_MDT_OrganisationMiscSitesR
tblPAEDIATRIC_MDT.LabMyelodysplasiaOrgID FK_tblPAEDIATRIC_MDT_OrganisationSites5R
tblPAEDIATRIC_MDT.LabReportBrainOrgID FK_tblPAEDIATRIC_MDT_OrganisationSitesR
tblPAEDIATRIC_MDT.LabReportSarcomaOrgID FK_tblPAEDIATRIC_MDT_OrganisationSites4R
tblPAEDIATRIC_MDT.MiscLabReportOrgID FK_tblPAEDIATRIC_MDT_OrganisationMiscSitesR
tblPAEDIATRIC_MDT.StageBrainOrgID FK_tblPAEDIATRIC_MDT_OrganisationSites1R
tblPAEDIATRIC_MDT.StageLymphomaOrgID FK_tblPAEDIATRIC_MDT_OrganisationSites6R
tblPAEDIATRIC_MDT.StageRenalReportOrgID FK_tblPAEDIATRIC_MDT_OrganisationSites2R
tblPAEDIATRIC_MDT.StageUGIOrgID FK_tblPAEDIATRIC_MDT_OrganisationSites3R
tblPathwayUpdateEvents.OrganisationID FK_tblPathwayUpdateEvents_OrganisationID_OrganisationSitesR
tblREFERRAL_BRAIN.LabReportOrgID FK_tblREFERRAL_BRAIN_OrganisationSites1R
tblREFERRAL_BRAIN.StageBrainOrgID FK_tblREFERRAL_BRAIN_OrganisationSitesR
tblREFERRAL_GYNAECOLOGY.StageGynaeOrgID FK_tblREFERRAL_GYNAECOLOGY_OrganisationSitesR
tblREFERRAL_HAEMATOLOGY.LabLeukaemiaOrgID FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites3R
tblREFERRAL_HAEMATOLOGY.LabMyelodysplasiaOrgID FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites4R
tblREFERRAL_HAEMATOLOGY.LabResponseOrgID FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites2R
tblREFERRAL_HAEMATOLOGY.StageLeukaemiaOrgID FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites1R
tblREFERRAL_HAEMATOLOGY.StageLymphomaOrgID FK_tblREFERRAL_HAEMATOLOGY_OrganisationSitesR
tblREFERRAL_PAEDIATRICS.LabMyelodysplasiaOrgID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites6R
tblREFERRAL_PAEDIATRICS.LabReportBrainOrgID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites2R
tblREFERRAL_PAEDIATRICS.LabReportSarcomaOrgID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites3R
tblREFERRAL_PAEDIATRICS.LabResponseOrgID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites7R
tblREFERRAL_PAEDIATRICS.StageBrainOrgID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites1R
tblREFERRAL_PAEDIATRICS.StageLymphomaOrgID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites5R
tblREFERRAL_PAEDIATRICS.StageRenalReportOrgID FK_tblREFERRAL_PAEDIATRICS_OrganisationSitesR
tblREFERRAL_PAEDIATRICS.StageUGIOrgID FK_tblREFERRAL_PAEDIATRICS_OrganisationSites4R
tblREFERRAL_SARCOMA.LabReportOrgID FK_tblREFERRAL_SARCOMA_OrganisationSitesR
tblREFERRAL_UPPER_GI.StageUGIOrgID FK_tblREFERRAL_UPPER_GI_OrganisationSitesR
tblREFERRAL_UROLOGY.LabReportOrgID FK_tblREFERRAL_UROLOGY_OrganisationSitesR
tblREFERRAL_UROLOGY.StageRenalReportOrgID FK_tblREFERRAL_UROLOGY_OrganisationSites2R
tblREFERRAL_UROLOGY.StageTesticularReportOrgID FK_tblREFERRAL_UROLOGY_OrganisationSites1R
tblSARCOMA_MDT.LabReportOrgID FK_tblSARCOMA_MDT_OrganisationSitesR
tblSARCOMA_MDT.MiscLabReportOrgID FK_tblSARCOMA_MDT_OrganisationMiscSitesR
tblSKIN_MDT.MiscLabReportOrgID FK_tblSKIN_MDT_OrganisationMiscSitesR
tblUGI_MDT.MiscLabReportOrgID FK_tblUGI_MDT_OrganisationMiscSitesR
tblUGI_MDT.StageUGIOrgID FK_tblUGI_MDT_OrganisationSitesR
tblUROLOGY_MDT.GeneralLabReportOrgID FK_tblUROLOGY_MDT_OrganisationSites3R
tblUROLOGY_MDT.LabReportOrgID FK_tblUROLOGY_MDT_OrganisationSitesR
tblUROLOGY_MDT.MiscLabReportOrgID FK_tblUROLOGY_MDT_OrganisationMiscSitesR
tblUROLOGY_MDT.StageRenalReportOrgID FK_tblUROLOGY_MDT_OrganisationSites2R
tblUROLOGY_MDT.StageTesticularReportOrgID FK_tblUROLOGY_MDT_OrganisationSites1R
ParentID int 4 √ null
Organisations.ID FK_OrganisationSites_OrganisationsR
Code varchar 5 null
Description nvarchar 500 null
ReadOnly bit 1 ((0))
E_TERTIARY_ENDPOINT varchar 500 √ null
E_TERTIARY_CERT_CN varchar 100 √ null
E_TERTIARY_VERSION_ID int 4 √ null
ltblTERTIARY_REFERRALS_VERSION.Id FK_OrganisationSites_ltblTERTIARY_REFERRALS_VERSIONR
ReasonDeleted tinyint 1 √ null
OrgDeletedReason.ID FK_OrgDeletedReasonR
IsDeleted bit 1 null
UpperCode varchar 5 null

Indexes

Constraint Name Type Sort Column(s)
PK_OrganisationSites Primary key Asc ID
IX_OrgCodeLookup Performance Asc Code
UQ_OrganisationSites_UpperCode Must be unique Asc UpperCode

Relationships

Close relationships within degrees of separation