Community Practicum (HRCA 1328)

This practical course provides students with an opportunity to apply knowledge and skills from all other courses with individuals and families in a community setting. Opportunity will be provided for students to become more familiar with the role of the Health Care Assistant within a Home Support Agency and gain abilities that will prepare graduates to assume the role of a Community Health Worker.

Course code: HRCA 1328

Credits: 2.0

Tuition: $0^*

Length: 60 hours

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

Schedule†

HRCA 1328 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
44636	David, Regeline	June 7, 2021 to June 18, 2021	Mon, Tue, Wed, Thu, Fri \| 7:00 a.m - 2:00 p.m	David, Regeline
44636 Off Site		June 7, 2021 to June 18, 2021	Mon, Tue, Wed, Thu \| 7:00 a.m - 2:00 p.m
44637	Bauden, Bonnie	June 7, 2021 to June 18, 2021	Mon, Tue, Wed, Thu, Fri \| 7:00 a.m - 2:00 p.m	Bauden, Bonnie
44637 Off Site		June 7, 2021 to June 18, 2021	Mon, Tue, Wed, Thu \| 7:00 a.m - 2:00 p.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-05-01 07:00:00.0	Mon Tue Wed Thu Fri	11-Jun-2021	2020-05-01 14:00:00.0	20001479	44636	12	202140	N	0	HCES131	0700	OFFSTE	2021-06-11 00:00:00.0	1359	[empty string]	P	2021-06-07 00:00:00.0	07-Jun-2021	Practicum
2	2020-05-01 07:00:00.0	Mon Tue Wed Thu Fri	11-Jun-2021	2020-05-01 14:00:00.0	30043201	44637	12	202140	N	0	HCES132	0700	OFFSTE	2021-06-11 00:00:00.0	1359	[empty string]	P	2021-06-07 00:00:00.0	07-Jun-2021	Practicum
3	2020-05-01 07:00:00.0	Mon Tue Wed Thu	17-Jun-2021	2020-05-01 14:00:00.0	20001479	44636	12	202140	N	0	HCES131	0700	OFFSTE	2021-06-17 00:00:00.0	1359	[empty string]	P	2021-06-14 00:00:00.0	14-Jun-2021	Practicum
4	2020-05-01 07:00:00.0	Mon Tue Wed Thu	17-Jun-2021	2020-05-01 14:00:00.0	30043201	44637	12	202140	N	0	HCES132	0700	OFFSTE	2021-06-17 00:00:00.0	1359	[empty string]	P	2021-06-14 00:00:00.0	14-Jun-2021	Practicum
5	2020-05-01 08:00:00.0	Fri	18-Jun-2021	2020-05-01 15:00:00.0	20001479	44636	12	202140	N	0	HCES131	0800	BWY-B	2021-06-18 00:00:00.0	1459	2230	P	2021-06-18 00:00:00.0	18-Jun-2021	Practicum
6	2020-05-01 08:00:00.0	Fri	18-Jun-2021	2020-05-01 15:00:00.0	30043201	44637	12	202140	N	0	HCES132	0800	BWY-B	2021-06-18 00:00:00.0	1459	2231	P	2021-06-18 00:00:00.0	18-Jun-2021	Practicum

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 = '1328' 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	44636
2	HCES131

struct
1	44637
2	HCES132

struct
1	44636
2	HCES131

struct
1	44637
2	HCES132

struct
1	44636
2	HCES131

struct
1	44637
2	HCES132

array

struct
1	HCES HCES HCES
2	44636 44637
3	HCES131

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.

Community Practicum (HRCA 1328)

Schedule†

HRCA 1328 schedule for programs:

Additional Information

Contact us