Clinical 2 (HRCA 1227)

This supervised practical experience provides students with an opportunity to apply knowledge and skills from all other courses in the Health Care Assistant/ESL program and work with individuals experiencing cognitive challenges in a multi-level or complex care setting.

Course code: HRCA 1227

Credits: 2.0

Tuition: $0^*

Length: 60 hours

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

Prerequisites

Completion of the following courses in the Health Care Assistant/ESL program: ELSK 0701, HRCA 1103, HRCA 1105, HRCA 1120, HRCA 1122, HRCA 1130, HRCA 1140, HRCA 1135, HRCA 1224, HRCA 1230, HRCA 1240, HRCA 1232

Corequisites

ELSK 0702

Schedule†

HRCA 1227 schedule for programs:

HCES

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
43943	David, Regeline	March 20, 2020 to April 17, 2020	Fri \| 7:00 a.m - 1:00 p.m	David, Regeline

Schedule†

HRCA 1227 schedule for programs:

HRCA

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
44614	David, Regeline	March 19, 2021 to April 16, 2021	Fri \| 7:00 a.m - 1:00 p.m	David, Regeline
44617	Bauden, Bonnie	March 19, 2021 to April 16, 2021	Fri \| 7:00 a.m - 1:00 p.m	Bauden, Bonnie

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-02-01 07:00:00.0	Fri	03-Apr-2020	2020-02-01 13:00:00.0	20001479	43943	1	202040	N	0	HCES121	0700	OFFSTE	2020-04-03 00:00:00.0	1259	[empty string]	C	2020-03-20 00:00:00.0	20-Mar-2020	Clinical
2	2020-02-01 07:00:00.0	Mon Tue Wed Thu Fri	17-Apr-2020	2020-02-01 13:00:00.0	20001479	43943	1	202040	N	0	HCES121	0700	OFFSTE	2020-04-17 00:00:00.0	1259	[empty string]	C	2020-04-06 00:00:00.0	06-Apr-2020	Clinical
3	2020-02-01 07:00:00.0	Fri	26-Mar-2021	2020-02-01 13:00:00.0	20001479	44614	12	202140	N	0	HCES121	0700	OFFSTE	2021-03-26 00:00:00.0	1259	[empty string]	C	2021-03-19 00:00:00.0	19-Mar-2021	Clinical
4	2020-02-01 07:00:00.0	Fri	26-Mar-2021	2020-02-01 13:00:00.0	30043201	44617	12	202140	N	0	HCES122	0700	OFFSTE	2021-03-26 00:00:00.0	1259	[empty string]	C	2021-03-19 00:00:00.0	19-Mar-2021	Clinical
5	2020-02-01 07:00:00.0	Mon Tue Wed Thu Fri	16-Apr-2021	2020-02-01 13:00:00.0	20001479	44614	12	202140	N	0	HCES121	0700	OFFSTE	2021-04-16 00:00:00.0	1259	[empty string]	C	2021-03-29 00:00:00.0	29-Mar-2021	Clinical
6	2020-02-01 07:00:00.0	Mon Tue Wed Thu Fri	16-Apr-2021	2020-02-01 13:00:00.0	30043201	44617	12	202140	N	0	HCES122	0700	OFFSTE	2021-04-16 00:00:00.0	1259	[empty string]	C	2021-03-29 00:00:00.0	29-Mar-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 = 'HRCA' AND ssbsect.ssbsect_crse_numb = '1227' AND ssbsect.ssbsect_term_code >= 202040 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	43943
2	HCES121

struct
1	43943
2	HCES121

struct
1	44614
2	HCES121

struct
1	44617
2	HCES122

struct
1	44614
2	HCES121

struct
1	44617
2	HCES122

array

struct
1	HCES HCES
2	43943
3	HCES121

struct
1	HRCA HRCA
2	44614 44617
3	[empty string]

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 2 (HRCA 1227)

Prerequisites

Corequisites

Schedule†

HRCA 1227 schedule for programs:

Schedule†

HRCA 1227 schedule for programs:

Additional Information

Contact us