Dental Communication 2 (DREC 1232)

This course focuses on the business and financial management of an entire dental practice. Utilizing dental management software, students build and maintain several hundred patients in a unique virtual practice. Personal data, medical histories, patient treatment, estimates, services rendered, insurance processing, day,month and year end procedures as well as appointment control are entered.

Course code: DREC 1232

Credits: 7.0

Tuition: $0^*

Length: 135 hours

Schedule†

DREC 1232 schedule for programs:

DRCO

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
44075	Squires, Ellen	30-Mar-2020	Mon \| 9:00 a.m - 4:00 p.m	Squires, Ellen
44075 VCC Downtown Campus		01-Apr-2020	Wed \| 9:00 a.m - 4:00 p.m
44075 VCC Downtown Campus		03-Apr-2020	Fri \| 9:00 a.m - 4: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-01-01 09:00:00.0	Mon	30-Mar-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-03-30 00:00:00.0	1559	526	B	2020-03-30 00:00:00.0	30-Mar-2020	Lab
2	2020-01-01 09:00:00.0	Wed	01-Apr-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-04-01 00:00:00.0	1559	521	B	2020-04-01 00:00:00.0	01-Apr-2020	Lab
3	2020-01-01 09:00:00.0	Fri	03-Apr-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-04-03 00:00:00.0	1559	521	B	2020-04-03 00:00:00.0	03-Apr-2020	Lab
4	2020-01-01 09:00:00.0	Tue	07-Apr-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-04-07 00:00:00.0	1559	521	B	2020-04-07 00:00:00.0	07-Apr-2020	Lab
5	2020-01-01 09:00:00.0	Wed	15-Apr-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-04-15 00:00:00.0	1559	521	B	2020-04-15 00:00:00.0	15-Apr-2020	Lab
6	2020-01-01 09:00:00.0	Thu	16-Apr-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-04-16 00:00:00.0	1559	526	B	2020-04-16 00:00:00.0	16-Apr-2020	Lab
7	2020-01-01 09:00:00.0	Mon	20-Apr-2020	2020-01-01 12:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-04-20 00:00:00.0	1159	521	B	2020-04-20 00:00:00.0	20-Apr-2020	Lab
8	2020-01-01 13:00:00.0	Tue	21-Apr-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	1300	DTN	2020-04-21 00:00:00.0	1559	521	B	2020-04-21 00:00:00.0	21-Apr-2020	Lab
9	2020-01-01 13:00:00.0	Thu	23-Apr-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	1300	DTN	2020-04-23 00:00:00.0	1559	521	B	2020-04-23 00:00:00.0	23-Apr-2020	Lab
10	2020-01-01 13:00:00.0	Mon	27-Apr-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	1300	DTN	2020-04-27 00:00:00.0	1559	521	B	2020-04-27 00:00:00.0	27-Apr-2020	Lab
11	2020-01-01 09:00:00.0	Wed	29-Apr-2020	2020-01-01 12:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-04-29 00:00:00.0	1159	521	B	2020-04-29 00:00:00.0	29-Apr-2020	Lab
12	2020-01-01 09:00:00.0	Mon	04-May-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-05-04 00:00:00.0	1559	521	B	2020-05-04 00:00:00.0	04-May-2020	Lab
13	2020-01-01 09:00:00.0	Tue	05-May-2020	2020-01-01 12:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-05-05 00:00:00.0	1159	521	B	2020-05-05 00:00:00.0	05-May-2020	Lab
14	2020-01-01 13:00:00.0	Wed	06-May-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	1300	DTN	2020-05-06 00:00:00.0	1559	521	B	2020-05-06 00:00:00.0	06-May-2020	Lab
15	2020-01-01 09:00:00.0	Thu	07-May-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-05-07 00:00:00.0	1559	521	B	2020-05-07 00:00:00.0	07-May-2020	Lab
16	2020-01-01 09:00:00.0	Mon	11-May-2020	2020-01-01 12:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-05-11 00:00:00.0	1159	521	B	2020-05-11 00:00:00.0	11-May-2020	Lab
17	2020-01-01 13:00:00.0	Tue	12-May-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	1300	DTN	2020-05-12 00:00:00.0	1559	521	B	2020-05-12 00:00:00.0	12-May-2020	Lab
18	2020-01-01 09:00:00.0	Wed	13-May-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-05-13 00:00:00.0	1559	521	B	2020-05-13 00:00:00.0	13-May-2020	Lab
19	2020-01-01 13:00:00.0	Tue	19-May-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	1300	DTN	2020-05-19 00:00:00.0	1559	521	B	2020-05-19 00:00:00.0	19-May-2020	Lab
20	2020-01-01 09:00:00.0	Tue	26-May-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-05-26 00:00:00.0	1559	526	B	2020-05-26 00:00:00.0	26-May-2020	Lab
21	2020-01-01 09:00:00.0	Wed	27-May-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-05-27 00:00:00.0	1559	526	B	2020-05-27 00:00:00.0	27-May-2020	Lab
22	2020-01-01 09:00:00.0	Thu	28-May-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-05-28 00:00:00.0	1559	526	B	2020-05-28 00:00:00.0	28-May-2020	Lab
23	2020-01-01 09:00:00.0	Fri	29-May-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-05-29 00:00:00.0	1559	526	B	2020-05-29 00:00:00.0	29-May-2020	Lab
24	2020-01-01 09:00:00.0	Mon	01-Jun-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-06-01 00:00:00.0	1559	526	B	2020-06-01 00:00:00.0	01-Jun-2020	Lab
25	2020-01-01 09:00:00.0	Tue	02-Jun-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-06-02 00:00:00.0	1559	526	B	2020-06-02 00:00:00.0	02-Jun-2020	Lab
26	2020-01-01 09:00:00.0	Fri	05-Jun-2020	2020-01-01 16:00:00.0	50053988	44075	2	202040	N	0	DRCO121	0900	DTN	2020-06-05 00:00:00.0	1559	526	B	2020-06-05 00:00:00.0	05-Jun-2020	Lab

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 = 'DREC' AND ssbsect.ssbsect_crse_numb = '1232' 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	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

struct
1	44075
2	DRCO121

array

struct
1	DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO DRCO
2	44075
3	DRCO121

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.

Dental Communication 2 (DREC 1232)

Schedule†

DREC 1232 schedule for programs:

Additional Information

Contact us