Heavy Mechanics level 2 (HMAP 2002)

Course code: HMAP 2002

Credits: 8.0

Tuition: $0^*

Length: 240 hours

Campus: Annacis Island

Schedule†

HMAP 2002 schedule for programs:

DEMP
DHP2
HDEP
TTMP
TTTP

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	Register
40002	Wheatley, Matt	06-Jan-2020 to 14-Feb-2020	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m	Wheatley, Matt	Waitlist Waitlist /applying/apply-now/registering-to-apprenticeship-training/
40003	Wheatley, Matt	09-Mar-2020 to 17-Apr-2020	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m	Wheatley, Matt	Waitlist Waitlist /applying/apply-now/registering-to-apprenticeship-training/
60425		19-May-2020 to 26-Jun-2020	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
60428		27-Jul-2020 to 04-Sep-2020	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
73403		05-Oct-2020 to 13-Nov-2020	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
43982		11-Jan-2021 to 19-Feb-2021	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
43985		08-Mar-2021 to 16-Apr-2021	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
60496		17-May-2021 to 25-Jun-2021	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
60499		26-Jul-2021 to 03-Sep-2021	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
70007		04-Oct-2021 to 12-Nov-2021	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
43977		10-Jan-2022 to 18-Feb-2022	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
43980		07-Mar-2022 to 14-Apr-2022	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
60003		16-May-2022 to 24-Jun-2022	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
60006		25-Jul-2022 to 02-Sep-2022	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
70008		03-Oct-2022 to 10-Nov-2022	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
40009		09-Jan-2023 to 17-Feb-2023	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
40012		06-Mar-2023 to 14-Apr-2023	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
60007		15-May-2023 to 23-Jun-2023	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
60010		24-Jul-2023 to 01-Sep-2023	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
70015		02-Oct-2023 to 10-Nov-2023	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
40020		08-Jan-2024 to 16-Feb-2024	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/
40023		04-Mar-2024 to 12-Apr-2024	Mon, Tue, Wed, Thu, Fri \| 6:30 a.m - 3:00 p.m		Register Register /applying/apply-now/registering-to-apprenticeship-training/

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	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	14-Feb-2020	2019-12-01 15:00:00.0	50189823	40002	0	202040	Y	4	[empty string]	0630	ANNACI	2020-02-14 00:00:00.0	1459	[empty string]	K	2020-01-06 00:00:00.0	06-Jan-2020	Shop/Teaching Kitchen
2	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	17-Apr-2020	2019-12-01 15:00:00.0	50189823	40003	0	202040	Y	2	[empty string]	0630	ANNACI	2020-04-17 00:00:00.0	1459	[empty string]	K	2020-03-09 00:00:00.0	09-Mar-2020	Shop/Teaching Kitchen
3	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	26-Jun-2020	2019-12-01 15:00:00.0	[empty string]	60425	9	202060	Y	0	[empty string]	0630	ANNACI	2020-06-26 00:00:00.0	1459	[empty string]	K	2020-05-19 00:00:00.0	19-May-2020	Shop/Teaching Kitchen
4	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	04-Sep-2020	2019-12-01 15:00:00.0	[empty string]	60428	11	202060	Y	0	[empty string]	0630	ANNACI	2020-09-04 00:00:00.0	1459	[empty string]	K	2020-07-27 00:00:00.0	27-Jul-2020	Shop/Teaching Kitchen
5	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	13-Nov-2020	2019-12-01 15:00:00.0	[empty string]	73403	12	202070	Y	0	[empty string]	0630	ANNACI	2020-11-13 00:00:00.0	1459	[empty string]	K	2020-10-05 00:00:00.0	05-Oct-2020	Shop/Teaching Kitchen
6	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	19-Feb-2021	2019-12-01 15:00:00.0	[empty string]	43982	15	202140	Y	0	[empty string]	0630	ANNACI	2021-02-19 00:00:00.0	1459	[empty string]	K	2021-01-11 00:00:00.0	11-Jan-2021	Shop/Teaching Kitchen
7	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	16-Apr-2021	2019-12-01 15:00:00.0	[empty string]	43985	16	202140	Y	0	[empty string]	0630	ANNACI	2021-04-16 00:00:00.0	1459	[empty string]	K	2021-03-08 00:00:00.0	08-Mar-2021	Shop/Teaching Kitchen
8	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	25-Jun-2021	2019-12-01 15:00:00.0	[empty string]	60496	16	202160	Y	0	[empty string]	0630	ANNACI	2021-06-25 00:00:00.0	1459	[empty string]	K	2021-05-17 00:00:00.0	17-May-2021	Shop/Teaching Kitchen
9	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	03-Sep-2021	2019-12-01 15:00:00.0	[empty string]	60499	15	202160	Y	0	[empty string]	0630	ANNACI	2021-09-03 00:00:00.0	1459	[empty string]	K	2021-07-26 00:00:00.0	26-Jul-2021	Shop/Teaching Kitchen
10	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	12-Nov-2021	2019-12-01 15:00:00.0	[empty string]	70007	16	202170	Y	0	[empty string]	0630	ANNACI	2021-11-12 00:00:00.0	1459	[empty string]	K	2021-10-04 00:00:00.0	04-Oct-2021	Shop/Teaching Kitchen
11	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	18-Feb-2022	2019-12-01 15:00:00.0	[empty string]	43977	16	202240	Y	0	[empty string]	0630	ANNACI	2022-02-18 00:00:00.0	1459	[empty string]	K	2022-01-10 00:00:00.0	10-Jan-2022	Shop/Teaching Kitchen
12	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	14-Apr-2022	2019-12-01 15:00:00.0	[empty string]	43980	16	202240	Y	0	[empty string]	0630	ANNACI	2022-04-14 00:00:00.0	1459	[empty string]	K	2022-03-07 00:00:00.0	07-Mar-2022	Shop/Teaching Kitchen
13	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	24-Jun-2022	2019-12-01 15:00:00.0	[empty string]	60003	16	202260	Y	0	[empty string]	0630	ANNACI	2022-06-24 00:00:00.0	1459	[empty string]	K	2022-05-16 00:00:00.0	16-May-2022	Shop/Teaching Kitchen
14	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	02-Sep-2022	2019-12-01 15:00:00.0	[empty string]	60006	16	202260	Y	0	[empty string]	0630	ANNACI	2022-09-02 00:00:00.0	1459	[empty string]	K	2022-07-25 00:00:00.0	25-Jul-2022	Shop/Teaching Kitchen
15	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	10-Nov-2022	2019-12-01 15:00:00.0	[empty string]	70008	16	202270	Y	0	[empty string]	0630	ANNACI	2022-11-10 00:00:00.0	1459	[empty string]	K	2022-10-03 00:00:00.0	03-Oct-2022	Shop/Teaching Kitchen
16	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	17-Feb-2023	2019-12-01 15:00:00.0	[empty string]	40009	16	202340	Y	0	[empty string]	0630	ANNACI	2023-02-17 00:00:00.0	1459	[empty string]	K	2023-01-09 00:00:00.0	09-Jan-2023	Shop/Teaching Kitchen
17	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	14-Apr-2023	2019-12-01 15:00:00.0	[empty string]	40012	16	202340	Y	0	[empty string]	0630	ANNACI	2023-04-14 00:00:00.0	1459	[empty string]	K	2023-03-06 00:00:00.0	06-Mar-2023	Shop/Teaching Kitchen
18	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	23-Jun-2023	2019-12-01 15:00:00.0	[empty string]	60007	16	202360	Y	0	[empty string]	0630	ANNACI	2023-06-23 00:00:00.0	1459	[empty string]	K	2023-05-15 00:00:00.0	15-May-2023	Shop/Teaching Kitchen
19	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	01-Sep-2023	2019-12-01 15:00:00.0	[empty string]	60010	16	202360	Y	0	[empty string]	0630	ANNACI	2023-09-01 00:00:00.0	1459	[empty string]	K	2023-07-24 00:00:00.0	24-Jul-2023	Shop/Teaching Kitchen
20	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	10-Nov-2023	2019-12-01 15:00:00.0	[empty string]	70015	16	202370	Y	0	[empty string]	0630	ANNACI	2023-11-10 00:00:00.0	1459	[empty string]	K	2023-10-02 00:00:00.0	02-Oct-2023	Shop/Teaching Kitchen
21	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	16-Feb-2024	2019-12-01 15:00:00.0	[empty string]	40020	16	202440	Y	0	[empty string]	0630	ANNACI	2024-02-16 00:00:00.0	1459	[empty string]	K	2024-01-08 00:00:00.0	08-Jan-2024	Shop/Teaching Kitchen
22	2019-12-01 06:30:00.0	Mon Tue Wed Thu Fri	12-Apr-2024	2019-12-01 15:00:00.0	[empty string]	40023	16	202440	Y	0	[empty string]	0630	ANNACI	2024-04-12 00:00:00.0	1459	[empty string]	K	2024-03-04 00:00:00.0	04-Mar-2024	Shop/Teaching Kitchen

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 = 'HMAP' AND ssbsect.ssbsect_crse_numb = '2002' AND ssbsect.ssbsect_term_code >= 201970 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	40002
2	[empty string]

struct
1	40003
2	[empty string]

struct
1	60425
2	[empty string]

struct
1	60428
2	[empty string]

struct
1	73403
2	[empty string]

struct
1	43982
2	[empty string]

struct
1	43985
2	[empty string]

struct
1	60496
2	[empty string]

struct
1	60499
2	[empty string]

struct
1	70007
2	[empty string]

struct
1	43977
2	[empty string]

struct
1	43980
2	[empty string]

struct
1	60003
2	[empty string]

struct
1	60006
2	[empty string]

struct
1	70008
2	[empty string]

struct
1	40009
2	[empty string]

struct
1	40012
2	[empty string]

struct
1	60007
2	[empty string]

struct
1	60010
2	[empty string]

struct
1	70015
2	[empty string]

struct
1	40020
2	[empty string]

struct
1	40023
2	[empty string]

array

struct
1	DEMP DHP2 HDEP TTMP TTTP
2	40002 40003 60425 60428 73403 43982 43985 60496 60499 70007 43977 43980 60003 60006 70008 40009 40012 60007 60010 70015 40020 40023
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.

Heavy Mechanics level 2 (HMAP 2002)

Schedule†

HMAP 2002 schedule for programs:

Additional Information

Contact us