vwTimedPathwayEventID

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

TimedPathwayEventID

int

4

null

TimedPathwayVersionID

int

4

null

TimedPathwayVersion.TimedPathwayVersionID

Implied ConstraintR

CareID

int

4

null

Relationships

Close relationships within degrees of separation

View Definition

CREATE VIEW dbo.vwTimedPathwayEventID 

AS

SELECT 
tpe.TimedPathwayEventID, tpe.TimedPathwayVersionID, tpa.CARE_ID AS CareID
FROM TimedPathwayEventClinic tpec 
JOIN TimedPathwayEvent tpe ON tpec.TimedPathwayEventID = tpe.TimedPathwayEventID
JOIN TimedPathwayAssociation tpa ON tpa.TimedPathwayVersionID = tpe.TimedPathwayVersionID

UNION

SELECT
tpe.TimedPathwayEventID, tpe.TimedPathwayVersionID, tpa.CARE_ID AS CareID
FROM TimedPathwayEventInvestigation tpi  
JOIN TimedPathwayEvent tpe ON tpi.TimedPathwayEventID = tpe.TimedPathwayEventID
JOIN TimedPathwayAssociation tpa ON tpa.TimedPathwayVersionID = tpe.TimedPathwayVersionID


UNION

SELECT
tpe.TimedPathwayEventID, tpe.TimedPathwayVersionID, tpa.CARE_ID AS CareID
FROM TimedPathwayEventMDT mdt
JOIN TimedPathwayEvent tpe ON mdt.TimedPathwayEventID = tpe.TimedPathwayEventID
JOIN TimedPathwayAssociation tpa ON tpa.TimedPathwayVersionID = tpe.TimedPathwayVersionID

UNION

SELECT 
tpe.TimedPathwayEventID, tpe.TimedPathwayVersionID, tpa.CARE_ID AS CareID
FROM TimedPathwayEventTriage tri 
JOIN TimedPathwayEvent tpe ON tri.TimedPathwayEventID = tpe.TimedPathwayEventID
JOIN TimedPathwayAssociation tpa ON tpa.TimedPathwayVersionID = tpe.TimedPathwayVersionID

UNION

SELECT
tpe.TimedPathwayEventID, tpe.TimedPathwayVersionID, tpa.CARE_ID AS CareID
FROM TimedPathwayEventOther oth 
JOIN TimedPathwayEvent tpe ON oth.TimedPathwayEventID = tpe.TimedPathwayEventID
JOIN TimedPathwayAssociation tpa ON tpa.TimedPathwayVersionID = tpe.TimedPathwayVersionID

UNION

SELECT
tpe.TimedPathwayEventID, tpe.TimedPathwayVersionID, tpa.CARE_ID AS CareID
FROM TimedPathwayEventDatePatientInformed dpi
JOIN TimedPathwayEvent tpe ON dpi.TimedPathwayEventID = tpe.TimedPathwayEventID
JOIN TimedPathwayAssociation tpa ON tpa.TimedPathwayVersionID = tpe.TimedPathwayVersionID

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views