Clinical Consolidation 3 (NURS 3370)

The intent of the consolidated clinical experience is to support the integration of theory and practice from all previous terms. The nurse’s role in the interdisciplinary team is emphasized.

Course code: NURS 3370

Credits: 6.0

Tuition: $0^*

Length: 180.0 hours

Course outline: https://www.vcc.ca/cfm-files/course-outline.cfm?subject=NURS&number=3370

Prerequisites

NURS 3262
NURS 3263
NURS 3264
NURS 3266

Schedule†

NURS 3370 schedule for programs:

NUSB

Course dates and times may vary throughout the term. Select the CRN number below to see a full schedule.

CRN #	Instructor	Dates	Day/Time	Instructor
75135		January 4, 2021 to February 10, 2021	Mon, Tue, Wed \| 12:00 a.m - 12:00 a.m

Schedule†

NURS 3370 schedule for programs:

NUSD

Course dates and times may vary throughout the term. Select the CRN number below to see a full schedule.

CRN #	Instructor	Dates	Day/Time	Instructor
60644		September 7, 2021 to October 13, 2021	Tue, Wed \| 12:00 a.m - 12:00 a.m
60644 Off Site			Mon, Tue, Wed \| 12:00 a.m - 12:00 a.m

query

RESULTSET

query
	BEGIN_TIME_ROUND	DAY_OF_WEEK	END_DATE	END_TIME_ROUND	SIRASGN_PIDM	SSBSECT_CRN	SSBSECT_SEATS_AVAIL	SSBSECT_TERM_CODE	SSBSECT_VOICE_AVAIL	SSBSECT_WAIT_COUNT	SSRBLCK_BLCK_CODE	SSRMEET_BEGIN_TIME	SSRMEET_BLDG_CODE	SSRMEET_END_DATE	SSRMEET_END_TIME	SSRMEET_ROOM_CODE	SSRMEET_SCHD_CODE	SSRMEET_START_DATE	START_DATE	STVSCHD_DESC
1	2020-12-01 00:00:00.0	Mon Tue Wed	10-Feb-2021	2020-12-01 00:00:00.0	[empty string]	75135	0	202070	N	0	NUSB321	[empty string]	ONLINE	2021-02-10 00:00:00.0	[empty string]	[empty string]	C	2021-01-04 00:00:00.0	04-Jan-2021	Clinical
2	2020-12-01 00:00:00.0	Tue Wed	08-Sep-2021	2020-12-01 00:00:00.0	[empty string]	60644	24	202160	N	0	NUSD321	[empty string]	OFFSTE	2021-09-08 00:00:00.0	[empty string]	[empty string]	C	2021-09-07 00:00:00.0	07-Sep-2021	Clinical
3	2020-12-01 00:00:00.0	Mon Tue Wed	06-Oct-2021	2020-12-01 00:00:00.0	[empty string]	60644	24	202160	N	0	NUSD321	[empty string]	OFFSTE	2021-10-06 00:00:00.0	[empty string]	[empty string]	C	2021-09-13 00:00:00.0	13-Sep-2021	Clinical
4	2020-12-01 00:00:00.0	Tue Wed	13-Oct-2021	2020-12-01 00:00:00.0	[empty string]	60644	24	202160	N	0	NUSD321	[empty string]	OFFSTE	2021-10-13 00:00:00.0	[empty string]	[empty string]	C	2021-10-12 00:00:00.0	12-Oct-2021	Clinical

CACHED

false

EXECUTIONTIME

SQL

SELECT ssbsect_crn, ssbsect_term_code, ssrblck_blck_code, ssrmeet_start_date, ssrmeet_end_date, TO_CHAR(ssrmeet_start_date, 'DD-Mon-YYYY') AS start_date, TO_CHAR(ssrmeet_end_date, 'DD-Mon-YYYY') AS end_date, ssrmeet_begin_time, ssrmeet_end_time, TRUNC( TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS')) + ( ROUND( (TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS') - TRUNC(TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS')) ) * 96 ) / 96) as begin_time_round, TRUNC( TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS')) + ( ROUND( (TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS') - TRUNC(TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS')) ) * 96 ) / 96) as end_time_round, DECODE(ssrmeet_sun_day, 'U', 'Sun ', '') || DECODE(ssrmeet_mon_day, 'M', 'Mon ', '') || DECODE(ssrmeet_tue_day, 'T', 'Tue ', '') || DECODE(ssrmeet_wed_day, 'W', 'Wed ', '') || DECODE(ssrmeet_thu_day, 'R', 'Thu ', '') || DECODE(ssrmeet_fri_day, 'F', 'Fri ', '') || DECODE(ssrmeet_sat_day, 'S', 'Sat ','') AS day_of_week, ssrmeet_bldg_code, ssrmeet_room_code, sirasgn_pidm, ssbsect_seats_avail, ssbsect_wait_count, ssbsect_voice_avail, ssrmeet_schd_code, stvschd_desc FROM ssbsect INNER JOIN stvschd ON ssbsect_schd_code = stvschd_code AND ssbsect_schd_code NOT IN ('PLA', 'CL', 'CB', 'CI', 'T') LEFT OUTER JOIN ssrblck ON ssrblck_term_code = ssbsect_term_code AND ssrblck_crn = ssbsect_crn LEFT OUTER JOIN ssrmeet ON ssrmeet_term_code = ssbsect_term_code AND ssrmeet_crn = ssbsect_crn LEFT OUTER JOIN sirasgn ON sirasgn_crn = ssbsect_crn AND sirasgn_term_code = ssbsect_term_code WHERE ssbsect.ssbsect_subj_code = 'NURS' AND ssbsect.ssbsect_crse_numb = '3370' AND ssbsect.ssbsect_term_code >= 202070 AND ssbsect.ssbsect_ssts_code = 'A' AND ssbsect.ssbsect_ptrm_end_date > sysdate-1 ORDER BY ssrmeet_start_date, ssrmeet_begin_time, ssbsect_crn

array

struct
1	75135
2	NUSB321

struct
1	60644
2	NUSD321

struct
1	60644
2	NUSD321

struct
1	60644
2	NUSD321

array

struct
1	NUSB
2	75135
3	NUSB321

struct
1	NUSD NUSD NUSD
2	60644
3	NUSD321

Contact us

Frequently asked questions

Ask a question

Book an appointment with an advisor

fill out an online form
Call 604.871.7000, option 2

INTERNATIONAL STUDENTS

Visit VCC International for contact information.

* Fees are approximate and subject to change. Students are required to pay any applicable fee increases. Fees listed are for domestic students. For international programs, visit VCC International.

† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.

Clinical Consolidation 3 (NURS 3370)

Prerequisites

Schedule†

NURS 3370 schedule for programs:

Schedule†

NURS 3370 schedule for programs:

Additional Information

Contact us