ltblNonPrimaryPathwayOptions

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

NonPrimaryPathwayOptionsID

int

4

null

tblBRAIN_MDT.NonPrimaryPathwayOptionsID	FK_tblBRAIN_MDT_ltblNonPrimaryPathwayOptionsR
tblBREAST_MDT.NonPrimaryPathwayOptionsID	FK_tblBREAST_MDT_ltblNonPrimaryPathwayOptionsR
tblCOLORECTAL_MDT.NonPrimaryPathwayOptionsID	FK_tblCOLORECTAL_MDT_ltblNonPrimaryPathwayOptionsR
tblCUP_MDT.NonPrimaryPathwayOptionsID	FK_tblCUP_MDT_ltblNonPrimaryPathwayOptionsR
tblGYNAECOLOGY_MDT.NonPrimaryPathwayOptionsID	FK_tblGYNAECOLOGY_MDT_ltblNonPrimaryPathwayOptionsR
tblHAEMATOLOGY_MDT.NonPrimaryPathwayOptionsID	FK_tblHAEMATOLOGY_MDT_ltblNonPrimaryPathwayOptionsR
tblHEAD_NECK_MDT.NonPrimaryPathwayOptionsID	FK_tblHEAD_NECK_MDT_ltblNonPrimaryPathwayOptionsR
tblLUNG_MDT.NonPrimaryPathwayOptionsID	FK_tblLUNG_MDT_ltblNonPrimaryPathwayOptionsR
tblMAIN_REFERRALS.NonPrimaryPathwayOptionsID	FK_tblMAIN_REFERRALS_ltblNonPrimaryPathwayOptionsR
tblOTHER_MDT.NonPrimaryPathwayOptionsID	FK_tblOTHER_MDT_ltblNonPrimaryPathwayOptionsR
tblPAEDIATRIC_MDT.NonPrimaryPathwayOptionsID	FK_tblPAEDIATRIC_MDT_ltblNonPrimaryPathwayOptionsR
tblSARCOMA_MDT.NonPrimaryPathwayOptionsID	FK_tblSARCOMA_MDT_ltblNonPrimaryPathwayOptionsR
tblSKIN_MDT.NonPrimaryPathwayOptionsID	FK_tblSKIN_MDT_ltblNonPrimaryPathwayOptionsR
tblUGI_MDT.NonPrimaryPathwayOptionsID	FK_tblUGI_MDT_ltblNonPrimaryPathwayOptionsR
tblUROLOGY_MDT.NonPrimaryPathwayOptionsID	FK_tblUROLOGY_MDT_ltblNonPrimaryPathwayOptionsR
vwTertiaryReferralsReferral.NonPrimaryPathwayOptionsID	Implied ConstraintR

NonPrimaryPathwayOptionsDesc

varchar

50

null

COSDValue

varchar

2

√

null

IsDeleted

bit

1

null

Indexes

Constraint Name	Type	Sort	Column(s)
PK_ltblNonPrimaryPathwayOptions	Primary key	Asc	NonPrimaryPathwayOptionsID

Relationships

Close relationships within degrees of separation