Specialized Treatment (ESTH 1220)

This course is designed to enhance skills taught in Skin Treatments 1 and provide an introduction to the Advanced Skin & Body Therapy Diploma program. Students be will introduce to advanced holistic studies and electro-therapy. This course will include product knowledge and prescription home care. This course is part of the full-time Skin & Body Treatment Program.

Course code: ESTH 1220

Credits: 3.0

Tuition: $0^*

Length: 90 hours

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

Schedule†

ESTH 1220 schedule for programs:

ESTH

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
46076	Fisette, Jaclyn	April 20, 2020 to May 7, 2020	Mon, Tue, Wed, Thu \| 9:00 a.m - 4:00 p.m	Fisette, Jaclyn
43442	Nagai-Price, Chikage	April 21, 2020 to May 6, 2020	Wed \| 9:00 a.m - 6:00 p.m	Nagai-Price, Chikage
43442 VCC Downtown Campus			Mon, Tue \| 9:00 a.m - 6:00 p.m
43466	Boulanger, Paula	April 23, 2020 to May 9, 2020	Thu \| 9:00 a.m - 6:00 p.m	Boulanger, Paula
43466 VCC Downtown Campus			Fri, Sat \| 9:00 a.m - 6:00 p.m
45422	Crump, Tyra	July 2, 2020 to July 18, 2020	Thu, Fri, Sat \| 9:00 a.m - 6:00 p.m	Crump, Tyra
60438	Hogan, Paula	August 10, 2020 to August 26, 2020	Mon, Tue, Wed \| 9:00 a.m - 6:00 p.m	Hogan, Paula
60444	McDonald, Pamela	August 13, 2020 to August 29, 2020	Thu, Fri, Sat \| 9:00 a.m - 6:00 p.m	McDonald, Pamela

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 09:00:00.0	Mon Tue Wed Thu	07-May-2020	2020-03-01 16:00:00.0	50248970	46076	10	202040	N	0	ESTHSS121	0900	MISSS	2020-05-07 00:00:00.0	1559	[empty string]	L	2020-04-20 00:00:00.0	20-Apr-2020	Lecture
2	2020-03-01 09:00:00.0	Wed	06-May-2020	2020-03-01 18:00:00.0	50265754	43442	-3	202040	N	0	ESTH121	0900	DTN	2020-05-06 00:00:00.0	1759	205C	L	2020-04-21 00:00:00.0	21-Apr-2020	Lecture
3	2020-03-01 09:00:00.0	Mon Tue	06-May-2020	2020-03-01 18:00:00.0	50265754	43442	-3	202040	N	0	ESTH121	0900	DTN	2020-05-06 00:00:00.0	1759	205C	L	2020-04-21 00:00:00.0	21-Apr-2020	Lecture
4	2020-03-01 09:00:00.0	Thu	09-May-2020	2020-03-01 18:00:00.0	50217008	43466	1	202040	N	0	ESTH122	0900	DTN	2020-05-09 00:00:00.0	1759	205C	L	2020-04-23 00:00:00.0	23-Apr-2020	Lecture
5	2020-03-01 09:00:00.0	Fri Sat	09-May-2020	2020-03-01 18:00:00.0	50217008	43466	1	202040	N	0	ESTH122	0900	DTN	2020-05-09 00:00:00.0	1759	205C	L	2020-04-23 00:00:00.0	23-Apr-2020	Lecture
6	2020-03-01 09:00:00.0	Thu Fri Sat	18-Jul-2020	2020-03-01 18:00:00.0	50266411	45422	2	202040	N	0	ESTH1214	0900	DTN	2020-07-18 00:00:00.0	1759	205B	L	2020-07-02 00:00:00.0	02-Jul-2020	Lecture
7	2020-03-01 09:00:00.0	Mon Tue Wed	26-Aug-2020	2020-03-01 18:00:00.0	50170718	60438	1	202060	N	0	ESTH121	0900	DTN	2020-08-26 00:00:00.0	1759	206A	L	2020-08-10 00:00:00.0	10-Aug-2020	Lecture
8	2020-03-01 09:00:00.0	Thu Fri Sat	29-Aug-2020	2020-03-01 18:00:00.0	50282568	60444	1	202060	N	0	ESTH122	0900	DTN	2020-08-29 00:00:00.0	1759	206A	L	2020-08-13 00:00:00.0	13-Aug-2020	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 = 'ESTH' AND ssbsect.ssbsect_crse_numb = '1220' 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	46076
2	ESTHSS121

struct
1	43442
2	ESTH121

struct
1	43442
2	ESTH121

struct
1	43466
2	ESTH122

struct
1	43466
2	ESTH122

struct
1	45422
2	ESTH1214

struct
1	60438
2	ESTH121

struct
1	60444
2	ESTH122

array

struct
1	ESTH
2	46076 43442 43466 45422 60438 60444
3	ESTHSS121

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.

Specialized Treatment (ESTH 1220)

Schedule†

ESTH 1220 schedule for programs:

Additional Information

Contact us