Final Drives and Undercarriage (HMEC 1170)

This course introduces students to the installation of undercarriages, removal and installation of final drives, and final drive service. Topics included are from the Industry Training Authority Heavy Mechanical Trades Foundation Program sections I5, I15, and I22. See: http://www.itabc.ca/sites/default/files/docs/partners/RTO/heavy-mechanical-foundation-march-2014.pdf for more information. This course is part of the full-time Heavy Mechanical Trades Foundation program

Course code: HMEC 1170

Credits: 1.0

Tuition: $0^*

Length: 25 hours

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

Schedule†

HMEC 1170 schedule for programs:

HMEC

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
43113	Kelly, Alan	April 20, 2020 to April 23, 2020	Mon, Tue, Wed, Thu \| 7:15 a.m - 2:30 p.m	Kelly, Alan
45851		June 29, 2020 to July 2, 2020	Mon, Tue, Thu \| 7:15 a.m - 2:30 p.m
61248		September 8, 2020 to September 10, 2020	Tue, Wed, Thu \| 7:15 a.m - 2:30 p.m
73905		November 16, 2020 to November 19, 2020	Mon, Tue, Wed, Thu \| 7:15 a.m - 2:30 p.m
73943	Griffith, Toby	February 8, 2021 to February 11, 2021	Mon, Tue, Wed, Thu \| 7:15 a.m - 2:30 p.m	Griffith, Toby

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-03-01 07:15:00.0	Mon Tue Wed Thu	23-Apr-2020	2020-03-01 14:30:00.0	30113828	43113	0	202040	N	0	HMEC111	0715	ANNACI	2020-04-23 00:00:00.0	1429	[empty string]	K	2020-04-20 00:00:00.0	20-Apr-2020	Shop/Teaching Kitchen
2	2020-03-01 07:15:00.0	Mon Tue Thu	02-Jul-2020	2020-03-01 14:30:00.0	[empty string]	45851	1	202040	N	0	HMEC1114	0715	ANNACI	2020-07-02 00:00:00.0	1429	[empty string]	K	2020-06-29 00:00:00.0	29-Jun-2020	Shop/Teaching Kitchen
3	2020-03-01 07:15:00.0	Tue Wed Thu	10-Sep-2020	2020-03-01 14:30:00.0	[empty string]	61248	7	202060	N	0	HMEC111	0715	ANNACI	2020-09-10 00:00:00.0	1429	[empty string]	K	2020-09-08 00:00:00.0	08-Sep-2020	Shop/Teaching Kitchen
4	2020-03-01 07:15:00.0	Mon Tue Wed Thu	19-Nov-2020	2020-03-01 14:30:00.0	[empty string]	73905	16	202070	N	0	HMEC111	0715	ANNACI	2020-11-19 00:00:00.0	1429	[empty string]	K	2020-11-16 00:00:00.0	16-Nov-2020	Shop/Teaching Kitchen
5	2020-03-01 07:15:00.0	Mon Tue Wed Thu	11-Feb-2021	2020-03-01 14:30:00.0	50147207	73943	16	202070	N	0	HMEC11111	0715	ANNACI	2021-02-11 00:00:00.0	1429	[empty string]	K	2021-02-08 00:00:00.0	08-Feb-2021	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 = 'HMEC' AND ssbsect.ssbsect_crse_numb = '1170' 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	43113
2	HMEC111

struct
1	45851
2	HMEC1114

struct
1	61248
2	HMEC111

struct
1	73905
2	HMEC111

struct
1	73943
2	HMEC11111

array

struct
1	HMEC
2	43113 45851 61248 73905 73943
3	HMEC111

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.

Final Drives and Undercarriage (HMEC 1170)

Schedule†

HMEC 1170 schedule for programs:

Additional Information

Contact us