vwMDT_ATTENDED

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ATTENDANCE_ID

int

null

MDT_ID

int

null

MEETING_ID

int

√

null

MDT_DATE

smalldatetime

√

null

NAME

varchar

√

null

SPECIALTY

varchar

√

null

TYPE

int

√

null

DISPLAY_ORDER

int

√

null

LEAD

int

√

null

PRESENT

int

√

null

DELETED

int

√

null

DATEDELETED

smalldatetime

√

null

COMMENTS

text

2147483647

√

null

MEETING_TYPE_ID

int

√

null

MEETING_TYPE_DESC

varchar

√

null

SUB_DESC

varchar

√

null

View Definition

CREATE VIEW [vwMDT_ATTENDED]
AS
SELECT     
	dbo.tblMDT_ATTENDANCE.ATTENDANCE_ID, 
	dbo.tblMDT_ATTENDANCE.MDT_ID, 
	dbo.tblMDT_ATTENDANCE.MEETING_ID, 
    dbo.tblMDT_ATTENDANCE.MDT_DATE, 
    dbo.tblMDT_ATTENDEES.NAME, 
    ltblMDT_ATTENDEES.MDT_DESC AS SPECIALTY, 
    dbo.tblMDT_ATTENDEES.TYPE, 
    dbo.tblMDT_ATTENDEES.DISPLAY_ORDER, 
    dbo.tblMDT_ATTENDEES.LEAD, 
    dbo.tblMDT_ATTENDANCE.PRESENT, 
    dbo.tblMDT_ATTENDEES.DELETED, 
    dbo.tblMDT_ATTENDEES.DATEDELETED,
    dbo.tblMDT_ATTENDANCE.COMMENTS, 
    dbo.tblMDT_MEETINGS.MEETING_TYPE_ID, 
    --dbo.ltblCANCER_SITES.CA_SITE, 
    dbo.ltblMDT_MEETING_TYPE.MEETING_TYPE_DESC,
    dbo.ltblCANCER_SUB_SITE.SUB_DESC
FROM         dbo.tblMDT_ATTENDANCE INNER JOIN
    dbo.tblMDT_ATTENDEES ON dbo.tblMDT_ATTENDANCE.MEETING_ID = dbo.tblMDT_ATTENDEES.MEETING_ID AND 
    dbo.tblMDT_ATTENDANCE.MDT_ID = dbo.tblMDT_ATTENDEES.MDT_ID LEFT OUTER JOIN
    dbo.tblMDT_MEETINGS INNER JOIN
	dbo.ltblMDT_MEETING_TYPE ON dbo.tblMDT_MEETINGS.MEETING_TYPE_ID = dbo.ltblMDT_MEETING_TYPE.MEETING_TYPE_ID INNER JOIN
    dbo.ltblCANCER_SUB_SITE ON dbo.tblMDT_MEETINGS.SUB_SITE = dbo.ltblCANCER_SUB_SITE.SUB_ID ON 
    dbo.tblMDT_ATTENDANCE.MEETING_ID = dbo.tblMDT_MEETINGS.MEETING_ID
    LEFT JOIN ltblMDT_ATTENDEES ON ltblMDT_ATTENDEES.MDT_ID = tblMDT_ATTENDEES.SPECIALTY_ID

Columns

View Definition

Possibly Referenced Tables/Views