Variations in Health 2 (NURS 2004)

This course focuses on pathophysiology as it relates to the aging process and selected chronic illnesses. The main focus of this course is on the care of the older adult experiencing a health challenge. Cultural diversity in healing practices will be explored as well as evidence informed research and practice.

Course code: NURS 2004

Credits: 1.5

Tuition: $0^*

Length: 45 hours

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

Prerequisites

NURS 1007 - Consolidated Practice Experience 1

Corequisites

NURS 2001 - Professional Communication 2; NURS 2002 - Professional Practice 2; NURS 2003 -
Health Promotion 2; NURS 2005 - Pharmacology 2; NURS 2006 - Integrated Nursing Practice 2

Schedule†

NURS 2004 schedule for programs:

PNUD

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
60491	Dhaliwal, Kulwant	May 13, 2020 to July 29, 2020	Wed \| 12:30 p.m - 3:30 p.m	Dhaliwal, Kulwant
44647		January 8, 2021 to March 26, 2021	Fri \| 8:00 a.m - 11:30 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-07-01 12:30:00.0	Wed	29-Jul-2020	2020-07-01 15:30:00.0	30106415	60491	0	202060	N	0	PNUD121	1230	ONLINE	2020-07-29 00:00:00.0	1529	[empty string]	L	2020-05-13 00:00:00.0	13-May-2020	Lecture
2	2020-07-01 08:00:00.0	Thu	21-May-2020	2020-07-01 11:00:00.0	30106415	60491	0	202060	N	0	PNUD121	0800	ONLINE	2020-05-21 00:00:00.0	1059	[empty string]	B	2020-05-21 00:00:00.0	21-May-2020	Lecture
3	2020-07-01 08:00:00.0	Thu	21-May-2020	2020-07-01 11:00:00.0	30106415	60491	0	202060	N	0	PNUD121	0800	ONLINE	2020-05-21 00:00:00.0	1059	[empty string]	B	2020-05-21 00:00:00.0	21-May-2020	Lecture
4	2020-07-01 08:00:00.0	Mon	15-Jun-2020	2020-07-01 11:00:00.0	30106415	60491	0	202060	N	0	PNUD121	0800	ONLINE	2020-06-15 00:00:00.0	1059	[empty string]	B	2020-06-15 00:00:00.0	15-Jun-2020	Lecture
5	2020-07-01 08:00:00.0	Mon	15-Jun-2020	2020-07-01 11:00:00.0	30106415	60491	0	202060	N	0	PNUD121	0800	ONLINE	2020-06-15 00:00:00.0	1059	[empty string]	B	2020-06-15 00:00:00.0	15-Jun-2020	Lecture
6	2020-07-01 08:00:00.0	Thu	16-Jul-2020	2020-07-01 11:00:00.0	30106415	60491	0	202060	N	0	PNUD121	0800	ONLINE	2020-07-16 00:00:00.0	1059	[empty string]	B	2020-07-16 00:00:00.0	16-Jul-2020	Lecture
7	2020-07-01 08:00:00.0	Thu	16-Jul-2020	2020-07-01 11:00:00.0	30106415	60491	0	202060	N	0	PNUD121	0800	ONLINE	2020-07-16 00:00:00.0	1059	[empty string]	B	2020-07-16 00:00:00.0	16-Jul-2020	Lecture
8	2020-07-01 08:00:00.0	Fri	26-Mar-2021	2020-07-01 11:30:00.0	[empty string]	44647	-3	202140	N	0	PNUD121	0800	BWY-B	2021-03-26 00:00:00.0	1129	[empty string]	L	2021-01-08 00:00:00.0	08-Jan-2021	Lecture
9	2020-07-01 12:30:00.0	Wed	24-Feb-2021	2020-07-01 15:30:00.0	[empty string]	44647	-3	202140	N	0	PNUD121	1230	BWY-B	2021-02-24 00:00:00.0	1529	[empty string]	L	2021-02-24 00:00:00.0	24-Feb-2021	Lecture

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 = '2004' AND ssbsect.ssbsect_term_code >= 202060 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	60491
2	PNUD121

struct
1	60491
2	PNUD121

struct
1	60491
2	PNUD121

struct
1	60491
2	PNUD121

struct
1	60491
2	PNUD121

struct
1	60491
2	PNUD121

struct
1	60491
2	PNUD121

struct
1	44647
2	PNUD121

struct
1	44647
2	PNUD121

array

struct
1	PNUD PNUD PNUD PNUD PNUD PNUD PNUD
2	60491 44647
3	PNUD121

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.