CREATE TABLE `option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_id` (`question_id`),
  CONSTRAINT `option_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=12997 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `option`
--

INSERT INTO `option` VALUES (12293,1,'There were no physical complications and the client was motivated',1),(12294,1,'The client was court-ordered and had the ability to pay for services',NULL),(12295,1,'The client was intelligent and highly motivated',NULL),(12296,1,'The client lived close by and was gainfully employed',NULL),(12297,2,'The client was assigned a primary counselor',NULL),(12298,2,'An initial assessment was completed',NULL),(12299,2,'The client was admitted to the program',NULL),(12300,2,'The client signed all required consent forms',1),(12301,3,'The client admitting all of his legal problems were alcohol related',NULL),(12302,3,'The client\'s denial of use of prescription medication',NULL),(12303,3,'The client\'s report of increased use of alcohol and occasional memory loss',1),(12304,3,'The client\'s conviction for his second DUI offense',NULL),(12305,4,'The client was provided an estimate of the cost of his treatment',1),(12306,4,'The client\' rights were explained to him',NULL),(12307,4,'The client was provided a copy of the programs goals and objectives',NULL),(12308,4,'The client was provided information about schedule times for meetings',NULL),(12309,5,'Co-dependency',NULL),(12310,5,'Substance Dependence',1),(12311,5,'Relationship Issues',NULL),(12312,5,'Prone to Relapse',NULL),(12313,6,'Client reports intimacy and co-dependency issues',1),(12314,6,'Client reports being homosexual',NULL),(12315,6,'Client attended 3 prior treatments',NULL),(12316,6,'Client reports being molested at age 13',NULL),(12317,7,'Client reports intimacy and co-dependency issues',NULL),(12318,7,'Client reports being homosexual',NULL),(12319,7,'Client attended 3 prior treatments',1),(12320,7,'Client reports being molested at age 13',NULL),(12337,9,'Unresolved Grief/Loss Issues',1),(12338,9,'Prone to Relapse',NULL),(12339,9,'Relationship Issues',NULL),(12340,9,'Anger Issues',NULL),(12341,8,'Substance Dependence',NULL),(12342,8,'Prone to Relapse',NULL),(12343,8,'Relationship Issues',NULL),(12344,8,'Anger Issues',1),(12349,10,'Describe the history and nature of sexual promiscuity',NULL),(12350,10,'Implement adaptive stress-reduction techniques',NULL),(12351,10,'Identify occupational problems and how the relate to addiction',NULL),(12352,10,'Write a detailed chemical use history, describing treatment attempts and situations surrounding relapse',1),(12353,11,'Refer client to physician to perform physical exam',NULL),(12354,11,'Assign the client to complete 12-step recovery program\'s, Step One paper, admitting powerlessness over mood-altering chemicals, and present in group therapy session',1),(12355,11,'Attend group therapy sessions focused on addiction',NULL),(12356,11,'Direct staff to administer the client\'s prescription medication',NULL),(12357,12,'Whenever the client asks for it',NULL),(12358,12,'When they need care your treatment center cannot provide',NULL),(12359,12,'When they have a medical condition that needs to be treated in a medical setting',NULL),(12360,12,'When they have family and marriage issues best addressed by a family counselor',NULL),(12361,12,'B, C & D',1),(12362,12,'All of the above',NULL),(12363,13,'Ignore this problem and move onto his parental issues',NULL),(12364,13,'Start to tutor him',NULL),(12365,13,'Write a resume with him and begin a job hunt',NULL),(12366,13,'Refer him to job training or a vocational school',1),(12367,14,'The center’s treatment philosophy',NULL),(12368,14,'Start to tutPersonal and friendly relationships with the staff and ownership of the facilityor him',1),(12369,14,'Past successes and failures in referrals',NULL),(12370,14,'Costs and availability of payment options',NULL),(12371,15,'There is no bad or wrong time to refer a client to another level of care',1),(12372,15,'If unsure about anything, keep trying – you’ll figure it out',NULL),(12373,15,'Once referred, privacy rights cease to be in force',NULL),(12374,15,'You should always receive a cut of the treatment cost for referring a client',NULL),(12375,16,'Only warranted when a client becomes agitated with their progress',NULL),(12376,16,'Not appropriate until after a 30 day counseling period',NULL),(12377,16,'A sign that the treatment plan process is active, fluid and healthy',1),(12378,16,'A sign that counseling is not working',NULL),(12379,17,'Will happen and this fact should be discussed openly with the client beforehand',NULL),(12380,17,'Doesn’t happen much any longer due to highly effective sedatives',NULL),(12381,17,'Is an inevitability, especially after only one or two trips to rehab',NULL),(12382,17,'Can be minimized by exceptional service coordination and productive referrals',1),(12383,18,'Fact Only',NULL),(12384,18,'Objective Criteria',NULL),(12385,18,'Subjective Criteria',1),(12386,18,'None – Diagnoses can only be made by medical professionals',NULL),(12387,19,'Self-disclosure',NULL),(12388,19,'Screening',1),(12389,19,'Assessment',NULL),(12390,19,'Delving into the root causes of addiction',NULL),(12391,20,'Clarification of any information that may be confusing the client',NULL),(12392,20,'Asking for insurance information',NULL),(12393,20,'Using a warm tone when speaking to the client',NULL),(12394,20,'A, C and D only',1),(12395,20,'All of the Above',NULL),(12396,21,'Complete a mental status exam.',NULL),(12397,21,'Engage the client\'s family in treatment.',NULL),(12398,21,'Develop a treatment plan.',NULL),(12399,21,'Establish rapport with the client.',1),(12400,22,'Diagnostic',NULL),(12401,22,'Eligibility',1),(12402,22,'Establishing a rapport',NULL),(12403,22,'Screening information',NULL),(12404,23,'Develop a treatment plan.',NULL),(12405,23,'Have the client sign appropriate documents.',NULL),(12406,23,'Determine one\'s appropriateness and eligibility for admission.',1),(12407,23,'Identify the client\'s strengths and weaknesses.',NULL),(12408,24,'Collecting samples to determine of the client is HIV positive',NULL),(12409,24,'Making sure family members are notified of the client’s decision',NULL),(12410,24,'Complete admission forms which will help formulate the treatment plan',1),(12411,24,'Ensuring that proper transportation to and from referrals has been secured',NULL),(12412,25,'Introducing the client to others in the program',NULL),(12413,25,'Discussing the negative effects of drugs',NULL),(12414,25,'Offering a facility tour to family and friends',NULL),(12415,25,'Discussing program goals and general program features',1),(12416,26,'Remain in denial about his/her addiction.',NULL),(12417,26,'Have incorrect information and unanswered questions about the program.',1),(12418,26,'Need to be referred to an outside agency.',NULL),(12419,26,'Need additional education about addiction.',NULL),(12420,27,'The first step in the admissions process',NULL),(12421,27,'Comprised of various information sources including interviews, personal records and tests',1),(12422,27,'Focused on very specific pieces of information to use in treatment',NULL),(12423,27,'The best way to introduce client rights information to the client',NULL),(12424,28,'Screening',NULL),(12425,28,'Orientation',1),(12426,28,'Assessment',NULL),(12427,28,'Group therapy sessions',NULL),(12428,29,'A client\'s fears and denial.',NULL),(12429,29,'Confidentiality',NULL),(12430,29,'Information gathering.',NULL),(12431,29,'Treatment planning.',1),(12432,30,'Denial of the problem',NULL),(12433,30,'Enablers including friends and family',NULL),(12434,30,'The presence of other counselors',NULL),(12435,30,'Blackouts or repression of behaviors and activities',NULL),(12436,30,'A, B and D',1),(12437,30,'All of the Above',NULL),(12438,31,'Identifying the client\'s problems and needs, strengths and weaknesses',1),(12439,31,'Explaining the rules of the program',NULL),(12440,31,'Having the client sign Release of Information forms',NULL),(12441,31,'Confronting the client\'s denial',NULL),(12442,32,'Bogus as all people have roughly the same needs in treatment',NULL),(12443,32,'Important because of cultural and/or gender differences',1),(12444,32,'Difficult to treat because of their family relationships',NULL),(12445,32,'More likely to be referred to another level of care',NULL),(12446,33,'3',NULL),(12447,33,'5',1),(12448,33,'9',NULL),(12449,33,'1',NULL),(12450,34,'Appropriate interventions',1),(12451,34,'Detox',NULL),(12452,34,'Understanding the science of addiction',NULL),(12453,34,'Collection of monies due',NULL),(12454,35,'Denial, surrender, and acceptance.',NULL),(12455,35,'Self-hatred, anger, and guilt.',NULL),(12456,35,'Remorse, self-hatred, and shame.',1),(12457,35,'Shame, euphoric recall, and relapse.',NULL),(12458,36,'Recognizing a deviation from normal physical responses',NULL),(12459,36,'Ruling out non-drug related issues',NULL),(12460,36,'Diagnosing which combination of drugs is causing the deviation from normal',NULL),(12461,36,'All of the above',1),(12462,37,'A licensed physician should conduct a physical examination of the client.',NULL),(12463,37,'The client should complete psychological tests to be used in the evaluation.',NULL),(12464,37,'The counselor should conduct an initial family therapy session in order to address problems caused by the client\'s use.',NULL),(12465,37,'The counselor should provide the client with an overview describing the goal, objectives, rules, and obligations of the program.',1),(12466,38,'Intake',1),(12467,38,'Orientation',NULL),(12468,38,'Case review',NULL),(12469,38,'Psychosocial Assessment',NULL),(12470,39,'Blood analysis',1),(12471,39,'Biopsy',NULL),(12472,39,'Reflex analysis',NULL),(12473,39,'DNA testing',NULL),(12474,40,'Skilled staff to administer',NULL),(12475,40,'No motivation on the part of the client',NULL),(12476,40,'Motivation on the part of the client',1),(12477,40,'Nothing; they have not been used in over 2 decades',NULL),(12478,41,'Assessment',NULL),(12479,41,'Intake',NULL),(12480,41,'Orientation',1),(12481,41,'Referral',NULL),(12482,42,'Self-disclosure',NULL),(12483,42,'Releasing information',NULL),(12484,42,'Protecting confidentiality',NULL),(12485,42,'Obtaining informed consent for treatment',1),(12486,43,'Not the counselor’s responsibility',NULL),(12487,43,'Intended to identify problems that need to be dealt with',1),(12488,43,'Rarely able to treat an addicted individual',NULL),(12489,43,'Separate from any referral activity',NULL),(12490,44,'Rarely apply to a treatment center',NULL),(12491,44,'Must be reviewed for accuracy and pertinence',1),(12492,44,'Are only offered in English',NULL),(12493,44,'Are cheap and usually ineffective',NULL),(12494,45,'Evaluating referral outcomes are not a part of clinical evaluation',NULL),(12495,45,'Evaluations only apply to medical referrals',NULL),(12496,45,'Evaluations are generally inaccurate because the referred to center will manipulate results',NULL),(12497,45,'Evaluations should include whether or not a referral completed the task as promised',1),(12498,46,'Advanced medical testing such as CT scans and chest X-rays to look for damage',1),(12499,46,'Group counseling only to begin with, then individual counseling',NULL),(12500,46,'Routine wellness testing including primary care and preventative care',NULL),(12501,46,'As little as possible until the patient has reached two weeks from admission',NULL),(12502,47,'Cognitive impairment, mental health issues, no insurance',NULL),(12503,47,'Mental Health issues, no insurance, denial',1),(12504,47,'Denial, cognitive impairment, mental health issues',NULL),(12505,47,'Blackouts, poor memory, prior treatment',NULL),(12506,48,'Respect, empathy, willingness to confront client denial',NULL),(12507,48,'Respect, empathy, recognition of personal value judgments',1),(12508,48,'Respect, detachment,  acceptance of non-readiness of stage of change',NULL),(12509,48,'Empathy, willingness to confront client denial, acceptance of non-readiness of stage of change',NULL),(12510,49,'Crisis states requires 911 to be called for a client, risk potential requires client to monitored',NULL),(12511,49,'Crisis states  indicates an act of self-harm by the client, risk potential in clients indicates a potential for self-harm',NULL),(12512,49,'Crisis state is identified as an acute reaction(s) by a client requiring immediate assistance, risk potential  identifies areas In a client’s life that unstable',1),(12513,49,'Crisis states can affect areas in a client’s life like – legal, relationships, job and risk potential can affect how the counselor feels about the client',NULL),(12514,50,'Psychopharmacology and psychiatric treatment',NULL),(12515,50,'Determining level of care placement and stage of readiness for treatment',1),(12516,50,'Aftercare treatment and confronting denial',NULL),(12517,50,'Identifying risk potential and becoming friendly with the client they are assessing',NULL),(12518,51,'Clients who have psychosocial issues and medical issue.',NULL),(12519,51,'Client who have family issues and substance misuse  issues',NULL),(12520,51,'Clients who have legal issues and substance misuse issues',NULL),(12521,51,'Clients who have substance misuse issues and mental health issues',1),(12522,52,'Inform client that there is a single best treatment for co-occurring disorders',NULL),(12523,52,'Act like they know about a mental health issues when they don’t so they can re-assure the client',NULL),(12524,52,'Become familiar with the specific role that your program or setting plays in delivering services related to COD in the wider context of the system of care',1),(12525,52,'Remain detached from client during the assessment process in order to obtain unbiased information',NULL),(12526,53,'Minimal, low, severe',1),(12527,53,'Acute, non-threatening, crisis',NULL),(12528,53,'Moderate, extreme, none',NULL),(12529,53,'History of suicide, no history of suicide, threatening suicide',NULL),(12530,54,'Whether the substance abuse (or mental health) client being screened show signs of a possible mental health (or substance abuse) problem',1),(12531,54,'What kind of problem the person might have',NULL),(12532,54,'How serious a client’s problems might be',NULL),(12533,54,'Whether the client need psychiatric medication',NULL),(12534,55,'The ASI',NULL),(12535,55,'The Beck Depression Inventory',NULL),(12536,55,'Personality Assessment Inventory (PAI)',NULL),(12537,55,'There is no one best tool',1),(12538,56,'Medication management, individual session and family sessions',NULL),(12539,56,'Integrated case management, outpatient substance abuse treatment and psychotropic medication management',NULL),(12540,56,'12-step support groups, anti-depressants, family sessions',NULL),(12541,56,'All of the above',1),(12542,57,'Identify and Obtain collateral information (with the correct ROI) from family members and pertinent other',NULL),(12543,57,'Invite family members to join assessment process to make sure the client is telling the truth',NULL),(12544,57,'Conduct a safety screening',NULL),(12545,57,'Both A & C',1),(12546,58,'The counselor being able to ask anything during the assessment',NULL),(12547,58,'The client being able to enter any level of care they are requesting',NULL),(12548,58,'Formal recognition by a service system that individuals with COD may enter a range of community service sites',1),(12549,58,'None of the above',NULL),(12550,59,'The counselor asking the client questions that only relate to that client',NULL),(12551,59,'The counselor not focusing on forms but finding out what the client wants based on their own perceptions',1),(12552,59,'The counselor focusing on one client at a time',NULL),(12553,59,'The counselor keeping the client focused on the assessment questions',NULL),(12554,60,'Promoting safety and gentleness during the assessment interview',1),(12555,60,'Asking the details of a client’s trauma',NULL),(12556,60,'Showing no reaction if a client provides information of a significant trauma',NULL),(12557,60,'Cutting the client off if they try to give details of a significant trauma',NULL),(12558,61,'Level of care/placement for treatment',NULL),(12559,61,'Level of client’s current risk',NULL),(12560,61,'Whether the client is COD',NULL),(12561,61,'The severity of the mental and substance use disorders',1),(12562,62,'Each disorder has a specific intervention matched to problem',1),(12563,62,'Whether the client is taking psychotropic medication',NULL),(12564,62,'Client’s mental health symptoms before their substance use issues',NULL),(12565,62,'Client’s substance use issues before their mental health issues',NULL),(12566,63,'To determine whether a client meets criteria for substance abuse treatment',NULL),(12567,63,'To determine whether a client needs detoxification',1),(12568,63,'To determine whether a client meets DSM criteria for a substance use diagnosis',NULL),(12569,63,'To determine whether a client needs a psychiatric evaluation',NULL),(12570,64,'Potential for suicide',NULL),(12571,64,'Potential for seizures',1),(12572,64,'Potential for chronic mental health issues',NULL),(12573,64,'Potential for cognitive issues',NULL),(12574,65,'Partial Hospitalization and Medically Managed Inpatient',1),(12575,65,'Partial Hospitalization and Intensive Outpatient',NULL),(12576,65,'Medically Managed Inpatient and Intensive Outpatient',NULL),(12577,65,'Intensive Outpatient and Low-Intensity Residential',NULL),(12578,66,'Level of care placement decisions',NULL),(12579,66,'Link assessment to need for and focus of treatment',NULL),(12580,66,'Clinical outcomes: impact of treatment',NULL),(12581,66,'Provide diagnosis',1),(12582,67,'The ASAM provides criteria for insurance company approval and the LOCUS doesn’t',NULL),(12583,67,'The ASAM provides placement criteria for primary substance use and the LOCUS provides placement criteria for primary or co-occurring mental health issues',1),(12584,67,'The ASAM provides criteria for substance diagnosis and the LOCUS provides criteria for mental health diagnosis',NULL),(12585,67,'The ASAM provides criteria for substance abuse treatment placement and the LOCUS provides criteria for co-occurring diagnosis',NULL),(12586,68,'Anyone working in the mental health field',NULL),(12587,68,'Qualified Health Professionals only',NULL),(12588,68,'Licensed Professionals, Registered Interns and Certified Addiction Professionals',1),(12589,68,'Master level counselors',NULL),(12590,69,'Will complete both the ASAM & the LOCUS/CALOCUS',1),(12591,69,'Will refer the client to a mental health agency for assessment',NULL),(12592,69,'Will only ask questions related to the client’s substance use history and defer questions on client’s mental health for a psychiatric evaluation',NULL),(12593,69,'Will complete only the LOCUS/CALOCUS',NULL),(12594,70,'Guide the DSM-5 diagnosis',NULL),(12595,70,'Guide assessments and summarizing findings',1),(12596,70,'Guide mental health assessments',NULL),(12597,70,'None of the above',NULL),(12598,71,'Draw up a new contract with the client.',NULL),(12599,71,'Talk to the client about possible denial.',NULL),(12600,71,'Create new goals and objectives, and suggest alternate forms of therapy.',NULL),(12601,71,'Discuss these concerns with the client and make necessary changes in treatment goals.',1),(12602,72,'Reviewing documentation in progress notes.',1),(12603,72,'Consulting with the client\'s significant others.',NULL),(12604,72,'Referring the client to a professional outside your agency for an objective review.',NULL),(12605,72,'Asking the client to write a personal evaluation of his/her own progress.',NULL),(12606,73,'Identify alternative courses of action.',NULL),(12607,73,'Offer emotional support.',NULL),(12608,73,'Contact emergency personnel.',NULL),(12609,73,'Assess the degree of risk.',1),(12610,74,'Screening.',NULL),(12611,74,'Orientation.',NULL),(12612,74,'The assessment.',1),(12613,74,'Intake.',NULL),(12614,75,'Summarize the inappropriateness of the client\'s feelings.',NULL),(12615,75,'Confront the client\'s behavior.',NULL),(12616,75,'Instruct the client in relaxation techniques.',NULL),(12617,75,'Call for assistance.',1),(12618,76,'To check for cocaine in the bloodstream',NULL),(12619,76,'To diagnose and report infectious diseases.',NULL),(12620,76,'To ensure eligibility and appropriateness for a level of care.',1),(12621,76,'Evaluation of a client’s suitability for life in the outside world after treatment.',NULL),(12622,77,'They should be involved in all aspects of intervention and treatment',1),(12623,77,'They are likely the underlying problem and should be removed from the process',NULL),(12624,77,'Only parents and siblings should participate in treatment',NULL),(12625,77,'There is no place for family – treatment is strictly for the individual',NULL),(12626,78,'Be as technical as possible',NULL),(12627,78,'Use realistic terms and simple, lay language',1),(12628,78,'Defer to your boss to break the bad news',NULL),(12629,78,'Paint a rosy and optimistic picture of the situation',NULL),(12630,79,'Understand their level of commitment to getting clean',1),(12631,79,'Remove the family from all discussions',NULL),(12632,79,'Admit the client no matter what their outlook or needs – they need treatment. Period.',NULL),(12633,79,'Offer worst-case scenarios to see their reactions',NULL),(12634,80,'Can apply to addictive disorders as well as to mental health disorders, including gambling',1),(12635,80,'Requires extensive training to understand',NULL),(12636,80,'Provides a linear model of stages that are fixed and static',NULL),(12637,80,'Recommends that only motivated people should receive treatment',NULL),(12638,81,'Match treatment to the client’s readiness to change',1),(12639,81,'Ensure residential care is not wastefully utilized',NULL),(12640,81,'Avoid confrontational approaches that alienate the client',NULL),(12641,81,'Individualize the referral and treatment plan',NULL),(12642,81,'All of the above',NULL),(12643,82,'Is unnecessary as their judgment is so poor',NULL),(12644,82,'Is as important as assessing what the client needs',1),(12645,82,'Gives a false impression that they should have choice about treatments',NULL),(12646,82,'Leads to disrespect of the clinician’s authority and expertise',NULL),(12647,83,'Vague to protect confidentiality',NULL),(12648,83,'General to allow flexibility in lengths-of-stay',NULL),(12649,83,'Preprinted to improve consistency',NULL),(12650,83,'Highly technical to demonstrate professionalism',NULL),(12651,83,'Assessment-based to improve individualization',1),(12652,84,'Standardized and generic to allow speedy documentation',NULL),(12653,84,'Comprehensive and wordy enough to show professionalism',NULL),(12654,84,'Exclusively patient quotes so as to demonstrate individualization',NULL),(12655,84,'Brief and behavioral to allow measurable outcome',1),(12656,85,'screening',NULL),(12657,85,'orientation',NULL),(12658,85,'the assessment',1),(12659,85,'intake',NULL),(12660,86,'The initial treatment plan should be based on assessment of the needs as revealed during the intake',1),(12661,86,'The treatment plan is to be developed before the treatment plan can be developed',NULL),(12662,86,'The client must be motivated for treatment before the treatment plan can be developed',NULL),(12663,86,'All group members give input into formulating the treatment plan',NULL),(12664,86,'The counselor must develop the treatment plan without any feedback from the client',NULL),(12665,87,'focus on what the client says',1),(12666,87,'follow clinical textbooks',NULL),(12667,87,'consider feedback from other clients',NULL),(12668,87,'rely on information from the source of referral',NULL),(12669,87,'use their own intuition',NULL),(12670,88,'Is NOT just a written plan on paper',NULL),(12671,88,'Is most important with the most complex clients',NULL),(12672,88,'Should represent a shared vision',NULL),(12673,88,'All of the above',1),(12674,89,'O.A.R.S',NULL),(12675,89,'F.R.A.M.E.S',NULL),(12676,89,'M.A.T.R.S',1),(12677,89,'None of the above',NULL),(12678,90,'History of drug & alcohol issues',NULL),(12679,90,'Current presenting issues',1),(12680,90,'Family’s view of the client’s issues',NULL),(12681,90,'Legal history',NULL),(12682,91,'relevant to the client & incremental',1),(12683,91,'reflective of the agency & counselor goals',NULL),(12684,91,'preformatted & brief',NULL),(12685,91,'focused on long term goals & discharge',NULL),(12686,92,'a specific client-determined goal',NULL),(12687,92,'a concrete vision the client holds',NULL),(12688,92,'a concrete client outcome measure',NULL),(12689,92,'a specific skill that the patient must acquire to achieve a goal',1),(12690,93,'Reflects client stage of change',NULL),(12691,93,'Individualized for each client',NULL),(12692,93,'Reflects client’s pathology',1),(12693,93,'Client determined',NULL),(12694,94,'An abstract client issue',NULL),(12695,94,'A brief clinical statement of a client issue',1),(12696,94,'A vague client issue',NULL),(12697,94,'A brief statement of client’s goals',NULL),(12698,95,'Diagnostically focused',1),(12699,95,'Flexible and changing',NULL),(12700,95,'Individualized',NULL),(12701,95,'Collaborative',NULL),(12702,96,'The therapist’s interventions',NULL),(12703,96,'What is going to be done, when and by whom',NULL),(12704,96,'Client problems within the six ASAM dimensions',NULL),(12705,96,'How long a client’s particular problem has existed',1),(12706,97,'Specific, intelligible to client and expressed in behavioral terms',1),(12707,97,'Direct, abstinence driven, group focused',NULL),(12708,97,'Fixed, long term, program directed',NULL),(12709,97,'Counselor determined, abstinence driven, measurable',NULL),(12710,98,'Gathering information',NULL),(12711,98,'Data analysis',NULL),(12712,98,'Prescribing anti-psychotic medication',1),(12713,98,'Treatment plan development',NULL),(12714,99,'A well-developed outline for the discharge summary',NULL),(12715,99,'More than one goal established by the counselor',NULL),(12716,99,'Clear expectations, specific goals, and methods of achievement',NULL),(12717,99,'A detailed explanation of goals and objectives',1),(12718,100,'The counselor is not listening and doesn’t care',NULL),(12719,100,'They don’t have a voice in the treatment planning process',NULL),(12720,100,'It’s safe to express their uncertainty about whether they have a problem or not',1),(12721,100,'The counselor is judging them',NULL),(12722,101,'Match the client’s own perception of the situation',NULL),(12723,101,'Provides a motivational (personal) reason to address the situation',NULL),(12724,101,'Lays out a framework of tasks and actions that are understandable and reasonable to the client',NULL),(12725,101,'All of the above',1),(12726,102,'The client will remain abstinent from all drugs and alcohol',1),(12727,102,'The client will develop a positive self-image.',NULL),(12728,102,'The client will develop a program of recovery that matches a sober lifestyle',NULL),(12729,102,'The client will learn healthy communication skills',NULL),(12730,103,'Measurable, Attainable, Treatment, Realistic, Specific',NULL),(12731,103,'Measurable, Active, Treatment, Realistic, Specific',NULL),(12732,103,'Measurable, Attainable, Treatment, Realistic, Substance Related',NULL),(12733,103,'Measurable, Attainable, Time-limited, Realistic, Specific',1),(12734,104,'Client level of functioning or impairment',NULL),(12735,104,'Evidence-based practice counselor will use for each objective listed',NULL),(12736,104,'Time frame agreed upon for each objective listed',NULL),(12737,104,'All of the above',1),(12738,104,'None of the above',NULL),(12739,105,'Prioritize pressing needs by addressing the client’s pressing problems',1),(12740,105,'Keep them short and only address what the counselor sees as appropriate',NULL),(12741,105,'Use the client’s stated weaknesses',NULL),(12742,105,'Keep the goals firm and static as originally stated, no straying from established goals',NULL),(12743,106,'Salient, incremental and meaningful',NULL),(12744,106,'Able to increase desired behaviors',NULL),(12745,106,'Open-ended and focused on client weaknesses',NULL),(12746,106,'Specific and behavior-focused',NULL),(12747,106,'All of the above except C',1),(12748,107,'I can picture how quitting substance use would improve my self-esteem but I can’t imagine ever shooting up again',NULL),(12749,107,'I don’t see how my substance use warrants concern',1),(12750,107,'I am feeling good about setting a quit date, but I am wondering if I have the courage to follow through',NULL),(12751,107,'Staying clean for the past few weeks really makes me feel good, but part of me wants to celebrate by getting loaded',NULL),(12752,107,'These recent months of abstinence have made me feel that I’m progressing toward recovery, but I’m still wondering whether abstinence is really necessary',NULL),(12753,108,'I can picture how quitting substance use would improve my self-esteem but I can’t imagine ever shooting up again',NULL),(12754,108,'I don’t see how my substance use warrants concern',NULL),(12755,108,'I am feeling good about setting a quit date, but I am wondering if I have the courage to follow through',NULL),(12756,108,'Staying clean for the past few weeks really makes me feel good, but part of me wants to celebrate by getting loaded',NULL),(12757,108,'These recent months of abstinence have made me feel that I’m progressing toward recovery, but I’m still wondering whether abstinence is really necessary',1),(12758,109,'I can picture how quitting substance use would improve my self-esteem but I can’t imagine ever shooting up again',NULL),(12759,109,'I don’t see how my substance use warrants concern',NULL),(12760,109,'I am feeling good about setting a quit date, but I am wondering if I have the courage to follow through',1),(12761,109,'Staying clean for the past few weeks really makes me feel good, but part of me wants to celebrate by getting loaded',NULL),(12762,109,'These recent months of abstinence have made me feel that I’m progressing toward recovery, but I’m still wondering whether abstinence is really necessary',NULL),(12763,110,'I can picture how quitting substance use would improve my self-esteem but I can’t imagine ever shooting up again',1),(12764,110,'I don’t see how my substance use warrants concern',NULL),(12765,110,'I am feeling good about setting a quit date, but I am wondering if I have the courage to follow through',NULL),(12766,110,'Staying clean for the past few weeks really makes me feel good, but part of me wants to celebrate by getting loaded',NULL),(12767,110,'These recent months of abstinence have made me feel that I’m progressing toward recovery, but I’m still wondering whether abstinence is really necessary',NULL),(12768,111,'I can picture how quitting substance use would improve my self-esteem but I can’t imagine ever shooting up again',NULL),(12769,111,'I don’t see how my substance use warrants concern',NULL),(12770,111,'I am feeling good about setting a quit date, but I am wondering if I have the courage to follow through',NULL),(12771,111,'Staying clean for the past few weeks really makes me feel good, but part of me wants to celebrate by getting loaded',1),(12772,111,'These recent months of abstinence have made me feel that I’m progressing toward recovery, but I’m still wondering whether abstinence is really necessary',NULL),(12773,112,'Confront and challenge',NULL),(12774,112,'Present consequences to client to inject a  reality check',NULL),(12775,112,'Roll with it',1),(12776,112,'Shut client down and decide client is not ready to begin recovery',NULL),(12777,113,'In the counselor’s journal',NULL),(12778,113,'In the client’s chart',1),(12779,113,'In the daily log',NULL),(12780,113,'In the outcome record',NULL),(12781,114,'Understanding and validation',NULL),(12782,114,'Mildly confrontational and in recovery themselves',NULL),(12783,114,'Active listening and empathy',NULL),(12784,114,'Tolerance and patience',NULL),(12785,114,'All of the above except B',1),(12786,115,'Medical diagnosis',1),(12787,115,'Continued Care',NULL),(12788,115,'Discharge Planning',NULL),(12789,115,'Notating changes client treatment / recovery status',NULL),(12790,116,'Goal & objective number',NULL),(12791,116,'How client is doing in treatment',NULL),(12792,116,'Changes in goals or objectives and explanation why',NULL),(12793,116,'Successful completion of goals & objectives',NULL),(12794,116,'The participation of others in client’s treatment',NULL),(12795,116,'All of the above',1),(12796,117,'Assessment information and progress notes reflecting the treatment plan',1),(12797,117,'Assessment information and client’s admission of drug use',NULL),(12798,117,'Progress notes and program guidelines',NULL),(12799,117,'Progress notes and release of information',NULL),(12800,118,'After bio-psychosocial is completed',NULL),(12801,118,'After intake is completed',NULL),(12802,118,'During the treatment plan session',NULL),(12803,118,'During the assessment interview',1),(12804,119,'To guide the beginning days/weeks of treatment',NULL),(12805,119,'To establish behavioral contracts',NULL),(12806,119,'To establish level of care',NULL),(12807,119,'To weed out clients not serious about treatment',1),(12808,120,'TTM is a dynamic process that affect a client’s readiness for change',1),(12809,120,'TTM is focused more on pre-existing client characteristics',NULL),(12810,120,'TTM is focused on a more family approach',NULL),(12811,120,'TTM  is a client behavior based process',NULL),(12812,121,'The master treatment plan',NULL),(12813,121,'The discharge plan',NULL),(12814,121,'The initial treatment plan',1),(12815,121,'A behavior contract',NULL),(12816,122,'Pre-contemplation',NULL),(12817,122,'Contemplation',1),(12818,122,'Preparation',NULL),(12819,122,'Action',NULL),(12820,122,'Maintenance',NULL),(12821,123,'Pre-contemplation',NULL),(12822,123,'Contemplation',NULL),(12823,123,'Preparation',NULL),(12824,123,'Action',1),(12825,123,'Maintenance',NULL),(12826,124,'Pre-contemplation',1),(12827,124,'Contemplation',NULL),(12828,124,'Preparation',NULL),(12829,124,'Action',NULL),(12830,124,'Maintenance',NULL),(12831,125,'True',NULL),(12832,125,'False',1),(12833,126,'True',NULL),(12834,126,'False',1),(12835,127,'True',1),(12836,127,'False',NULL),(12837,128,'True',NULL),(12838,128,'False',1),(12839,129,'True',1),(12840,129,'False',NULL),(12841,130,'True',NULL),(12842,130,'False',1),(12843,131,'True',1),(12844,131,'False',NULL),(12845,132,'True',1),(12846,132,'False',NULL),(12847,133,'Whenever the client asks for it',NULL),(12848,133,'When they need care your treatment center cannot provide',NULL),(12849,133,'When they have a medical condition that needs to be treated in a medical setting',NULL),(12850,133,'When they have family and marriage issues best addressed by a family counselor',NULL),(12851,133,'B, C & D',1),(12852,133,'None of the above',NULL),(12853,134,'Ignore this problem and move onto his parental issues',NULL),(12854,134,'Start to tutor him',NULL),(12855,134,'Write a resume with him and begin a job hunt',NULL),(12856,134,'Refer him to job training or a vocational school',1),(12857,135,'The center’s treatment philosophy',NULL),(12858,135,'Personal and friendly relationships with the staff and ownership of the facility',1),(12859,135,'Past successes and failures in referrals',NULL),(12860,135,'Costs and availability of payment options',NULL),(12861,136,'There is no bad or wrong time to refer a client to another level of care',1),(12862,136,'If unsure about anything, keep trying – you’ll figure it out',NULL),(12863,136,'Once referred, privacy rights cease to be in force',NULL),(12864,136,'You should always receive a cut of the treatment cost for referring a client',NULL),(12865,137,'Only warranted when a client becomes agitated with their progress',NULL),(12866,137,'Not appropriate until after a 30 day counseling period',NULL),(12867,137,'A sign that the treatment plan process is active, fluid and healthy',1),(12868,137,'A sign that counseling is not working',NULL),(12869,138,'Will happen and this fact should be discussed openly with the client beforehand',NULL),(12870,138,'Doesn’t happen much any longer due to highly effective sedatives',NULL),(12871,138,'Is an inevitability, especially after only one or two trips to rehab',NULL),(12872,138,'Can be minimized by exceptional service coordination and productive referrals',1),(12873,139,'Counselor sends an HIV / AIDS client to a facility without the capability to accommodate medical issues',NULL),(12874,139,'Client is an alcoholic and counselor refers them to NA',NULL),(12875,139,'Client has a history of domestic violence and the counselor refers them to a family counselor that specializes in anger management',1),(12876,139,'Client wants to find a job so the counselor refers them to a financial specialist to learn how to save money',NULL),(12877,140,'Evaluate your facility’s ability to handle his case and refer out to detox, treatment centers and medical facilities as necessary',1),(12878,140,'HIV has a slow progression. Treat the primary substance abuse problem now and defer the medical treatment',NULL),(12879,140,'Immediately send him to a HIV/AIDS clinic to be tested and avoid an admission to prevent the spread of the disease in your center',NULL),(12880,140,'Get him into treatment and begin treating for HIV',NULL),(12881,141,'Orienting the client with the treatment center',NULL),(12882,141,'Understanding what treatment has worked in the past',NULL),(12883,141,'Determining the client’s ability to pay',NULL),(12884,141,'Assessing the urgency of the issue at hand',1),(12885,142,'The act of referring a patient to another facility',NULL),(12886,142,'Unrelated to case management',NULL),(12887,142,'Creating the foundation for and addressing the needs of the treatment plan',1),(12888,142,'None of the above',NULL),(12889,143,'Making sure all documentation is complete and accurate',NULL),(12890,143,'A balance and cooperation between counselor, client and referrals',NULL),(12891,143,'Identifying improvements in the treatment and service plan',NULL),(12892,143,'Keeping family and other enablers away from the process',NULL),(12893,143,'A, B & C',1),(12894,143,'B, C & D',NULL),(12895,144,'Taking money from a referral source.',NULL),(12896,144,'Directing a client toward the referral that the counselor thinks is best.',NULL),(12897,144,'All are unethical',NULL),(12898,144,'Meeting with the client at a restaurant outside of treatment to follow up on the referral.',NULL),(12899,144,'A & D',1),(12900,145,'Never, there’s no need',NULL),(12901,145,'At least every six months and more often for high volume referral facilities',1),(12902,145,'When a problem crops up, no particular schedule',NULL),(12903,145,'Once every few years',NULL),(12904,146,'Referral to a medical professional or hospital',NULL),(12905,146,'Referral to what the counselor believes is the best insurance company for the client',1),(12906,146,'Referral to a county-level HIV/AIDS prevention and support program',NULL),(12907,146,'Referral to another treatment center',NULL),(12908,147,'Treat and release to a Halfway House',NULL),(12909,147,'Refer, refer, refer',NULL),(12910,147,'Treat, defer and refer',1),(12911,147,'Refer for a nominal fee',NULL),(12912,148,'Important, because a client’s participation in their own treatment plan offers a greater likelihood of successful recovery',1),(12913,148,'Not important, because family members will have to make these decisions while the client is high',NULL),(12914,148,'Important, because otherwise the client will be hostile',NULL),(12915,148,'Not important, because the referral will be made one way or other',NULL),(12916,149,'Sarah is doomed to failure – if it hasn’t worked twice, it won’t work this time',NULL),(12917,149,'Counselors should notify techs that she will be a difficult client and to pay extra attention to her',NULL),(12918,149,'As a counselor, learning from strategies that did and did not work in prior treatments will increase the likelihood of a successful treatment this time around',1),(12919,149,'Sarah should be referred out to a treatment center of last resort',NULL),(12920,150,'The counselor being able to interpret and evaluate the screening and assessment.',NULL),(12921,150,'Having an understanding of the community referral options available to the client.',NULL),(12922,150,'Establishing accurate treatment and recovery expectations with the client and involved significant others',1),(12923,150,'None of the above',NULL),(12924,151,'Strengths Perspective',NULL),(12925,151,'Generalist',NULL),(12926,151,'Solution Focused',NULL),(12927,151,'PACT',NULL),(12928,151,'A, B & D',1),(12929,151,'All of the above',NULL),(12930,152,'Treatment and referrals',NULL),(12931,152,'Planning and linking',1),(12932,152,'Counseling and discharge planning',NULL),(12933,152,'Grief counseling and assessment',NULL),(12934,152,'All of the above',NULL),(12935,153,'Help in achieving self-sufficiency',NULL),(12936,153,'Enhanced access to care',NULL),(12937,153,'Drug testing',NULL),(12938,153,'Improved Treatment Outcomes',NULL),(12939,153,'A, B & D',1),(12940,153,'All of the above',NULL),(12941,154,'Coaching and connecting',NULL),(12942,154,'Confronting and referring',NULL),(12943,154,'Advocating and reducing barriers',NULL),(12944,154,'Both A & C',1),(12945,155,'Nothing, both types of assessments are virtually the same',NULL),(12946,155,'Case management assessment focuses on client needs',1),(12947,155,'Case management assessment indicates what type of counseling style would be most beneficial',NULL),(12948,155,'Case management assessments are done after treatment is completed',NULL),(12949,156,'True',1),(12950,156,'False',NULL),(12951,157,'Neighbors doing chores for each other',NULL),(12952,157,'Neighbors being friendly in their immediate neighborhood',NULL),(12953,157,'Neighbor’s offering money to others',NULL),(12954,157,'Groups of people helping others in their real world struggles',1),(12955,158,'Increased crime rates',NULL),(12956,158,'Expansion of community-based services',1),(12957,158,'Increased outpatient mental health facilities',NULL),(12958,158,'Expansion of mental health services',NULL),(12959,159,'Improving treatment retention and outcomes',1),(12960,159,'Improving needs assessments and treatment plans',NULL),(12961,159,'Improving counseling and discharge planning',NULL),(12962,159,'Improving diagnosing and therapy',NULL),(12963,160,'Insane asylums',NULL),(12964,160,'County work farms',1),(12965,160,'Shelters',NULL),(12966,160,'Chain gangs',NULL),(12967,161,'Decriminalize drugs',NULL),(12968,161,'Educate society that addicts are not criminals',NULL),(12969,161,'Provided substance abuse services in jails',NULL),(12970,161,'Link criminal justice with drug treatment',1),(12971,162,'Adhering to applicable laws, regulations and agency policies governing the disclosure of client-identifying data.',NULL),(12972,162,'Assuring comprehensive, quality care for the client.',NULL),(12973,162,'Recognizing issues that are beyond the counselor\'s base of knowledge and/or skill.',NULL),(12974,162,'Demonstrating respect and non-judgmental attitudes toward clients in all contacts with community professionals and agencies.',NULL),(12975,162,'All of the above',NULL),(12976,162,'Both A & B',1),(12977,163,'Insurance Utilization Review',NULL),(12978,163,'Awareness of limitations of the client and of a client service',NULL),(12979,163,'Discharge/Aftercare planning',NULL),(12980,163,'Both B & C',1),(12981,164,'Diagnosing',NULL),(12982,164,'Medicating',NULL),(12983,164,'Collaborating',1),(12984,164,'Labeling',NULL),(12985,165,'Addiction and mental health treatment combined',1),(12986,165,'Multicultural treatment',NULL),(12987,165,'Drug and alcohol treatment',NULL),(12988,165,'Addiction treatment & case management combined',NULL),(12989,166,'Brief Strength Based Case Management',1),(12990,166,'Integrated Case Management',NULL),(12991,166,'Social Work',NULL),(12992,166,'Consultation',NULL),(12993,167,'Substance abuse treatment',NULL),(12994,167,'Case management',NULL),(12995,167,'Co-occurring treatment',NULL),(12996,167,'All of the above',1);

--
-- Table structure for table `question`
--

CREATE TABLE `question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `course_id` int(11) NOT NULL,
  `correct_answer_id` int(11) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `course_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=168 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `question`
--

INSERT INTO `question` VALUES (1,'Based on the information in the clinical evaluation case study, select the BEST response: What are the PRIMARY factors that made the client appropriate for this level of care?',27,12293,NULL,NULL),(2,'Based on the information in the clinical evaluation case study, select the BEST response: Which of the following essential tasks was NOT completed during the client\'s intake process?',27,12300,NULL,NULL),(3,'Based on the information in the clinical evaluation case study, select the BEST response:  Which of the following client behaviors contributed the most to the counselor\'s development of the provisional diagnosis of \"alcohol dependency?\"',27,12303,NULL,NULL),(4,'Based on the information in the clinical evaluation case study, select the BEST response: Which of the following essential orientation functions were NOT performed with this client?',27,12305,NULL,NULL),(5,'Please answer the following questions based on Case Study #1 you reviewed previously: When prioritizing the following client\'s problems which of the following would come first:\r\n',28,12310,NULL,NULL),(6,'Please answer the following questions based on Case Study #1 you reviewed previously: What statement can be used as a clarifier for the problem of relationship issues:\r\n\r\n',28,12313,NULL,NULL),(7,'Please answer the following questions based on Case Study #1 you reviewed previously: What statement can be used as a clarifier for the problem of prone to relapse issues:\r\n\r\n\r\n',28,12319,NULL,NULL),(8,'Please answer the following questions based on Case Study #1 you reviewed previously: All of the following would be appropriate problems, for this case study, needing treatment plans, except:\r\n\r\n\r\n',28,12344,NULL,NULL),(9,'Please answer the following questions based on Case Study #1 you reviewed previously: If \"Accept the loss of loved one and increase social contact with others,\" is the goal, what would the appropriate problem for this client:\r\n\r\n\r\n',28,12337,NULL,NULL),(10,'Please answer the following questions based on Case Study #1 you reviewed previously: The best possible a treatment plan objective for this client\'s problem of relapse proneness would be to:\r\n',28,12352,NULL,NULL),(11,'Please answer the following questions based on Case Study #1 you reviewed previously: The best possible a treatment plan intervention to match the objective of \"Verbally admit to powerlessness over mood-altering substances,\" for this client\'s problem of substance dependence would be to:',28,12354,NULL,NULL),(12,'When is it Appropriate to Refer a Client to Another Facility?',29,12361,NULL,NULL),(13,'John enters treatment and laments the fact that he is unable to get a job. He believes that if he had the skills to get a good job, it would help his substance abuse problem. As a counselor you should:',29,12366,NULL,NULL),(14,'Which is not an appropriate criterion, on its own, to be used for evaluating a facility before a referral?',29,12368,NULL,NULL),(15,'Which is true about a referral?',29,12371,NULL,NULL),(16,'Changes to the Treatment Plan Are:',29,12377,NULL,NULL),(17,'Dropping out of treatment:',29,12382,NULL,NULL),(18,'When a counselor is making a diagnosis they must use:',27,12385,NULL,NULL),(19,'The first step in establishing a rapport with a possible admission / client is:',27,12388,NULL,NULL),(20,'Which of the following will help the counselor establish a rapport with the client:',27,12394,NULL,NULL),(21,'During the screening process, a critical task that the counselor has is to:',27,12399,NULL,NULL),(22,'Understanding previous treatment efforts are criteria related to:',27,12401,NULL,NULL),(23,'The primary purpose of the screening process is to:',27,12406,NULL,NULL),(24,'One of the primary tasks of a counselor during the intake process is:',27,12410,NULL,NULL),(25,'Orientation primarily focuses on:',27,12415,NULL,NULL),(26,'If the orientation process is neglected or incomplete a client may:',27,12417,NULL,NULL),(27,'The assessment is:',27,12421,NULL,NULL),(28,'Providing the client with information regarding program rules, and infractions that can lead to discharge, normally occurs during the:',27,12425,NULL,NULL),(29,'During the intake, a counselor can expect to address all of the following issues EXCEPT:',27,12431,NULL,NULL),(30,'Common barriers to the assessment process include:',27,12436,NULL,NULL),(31,'When conducting an assessment, what is the counselor\'s primary focus?',27,12438,NULL,NULL),(32,'Special populations are:',27,12443,NULL,NULL),(33,'How many critical elements of effective treatment exist?',27,12447,NULL,NULL),(34,'One of the five stages of a comprehensive assessment is:',27,12450,NULL,NULL),(35,'Despite vast personality differences, virtually all substance abusers experience:',27,12456,NULL,NULL),(36,' Which of the following are the key elements in recognizing drug use and abuse?',27,12461,NULL,NULL),(37,'A 42-year-old male has just completed intake admission forms and is considered appropriate and eligible for treatment. Which step should occur next?',27,12465,NULL,NULL),(38,'The completion of various forms, including releases of information, financial, and consent for treatment, happens during the client\'s:',27,12466,NULL,NULL),(39,'Which of the following are commonly used chemical testing methods?',27,12470,NULL,NULL),(40,'A self-administered test requires:',27,12476,NULL,NULL),(41,'The description of the client\'s rights typically occurs during the:',27,12480,NULL,NULL),(42,'Before therapy or counseling begins, clients may be given information about the treatment they will receive, as well as possible risks involved. This process is known as:',27,12485,NULL,NULL),(43,'Treatment plan development is:',27,12487,NULL,NULL),(44,'Standardized assessment instruments:',27,12491,NULL,NULL),(45,'The treatment planning process includes an evaluation of an outcome of the referral. Which of the following statements is true?',27,12497,NULL,NULL),(46,'Client interventions may include:',27,12498,NULL,NULL),(47,'What are some of the barriers to assessment?',27,12503,NULL,NULL),(48,'A counselor’s attitude during Screening, Intake and Assessment should demonstrate:',27,12507,NULL,NULL),(49,'What is the difference between crisis and risk?',27,12512,NULL,NULL),(50,'In conducting an assessment, counselors must be skilled in:',27,12515,NULL,NULL),(51,'Define co-occurring disorders:',27,12521,NULL,NULL),(52,'When assessing a client with co-occurring disorders the counselor should:',27,12524,NULL,NULL),(53,'Risk of harm may be rated according to the following criteria:',27,12526,NULL,NULL),(54,'The screening process for COD helps determine:',27,12530,NULL,NULL),(55,'What is the best assessment tool for COD?',27,12537,NULL,NULL),(56,'The ideal integrated treatment plan for client with COD includes:',27,12541,NULL,NULL),(57,'When conducting an assessment with clients that have co-occurring disorders or substance use only disorder the counselor will:',27,12545,NULL,NULL),(58,'What does “No Wrong Door” refer to?',27,12548,NULL,NULL),(59,'A person-centered assessment is:',27,12551,NULL,NULL),(60,'During the assessment, what does being Trauma Sensitive include?',27,12554,NULL,NULL),(61,'What does the Four Quadrant model determine?',27,12561,NULL,NULL),(62,'Integrated treatment plans for COD should focus on:',27,12562,NULL,NULL),(63,'What is the primary use of the ASAM criteria?',27,12567,NULL,NULL),(64,'Dimension 3 of the ASAM focuses on all of the following except:',27,12571,NULL,NULL),(65,'Which 2 levels of care provide psychiatric capability in addition to substance abuse services?',27,12574,NULL,NULL),(66,'The LOCUS provides all except the following:',27,12581,NULL,NULL),(67,'What is the main difference between the ASAM and the LOCUS?',27,12583,NULL,NULL),(68,'Who can complete the LOCUS/CALOCUS?',27,12588,NULL,NULL),(69,'When conducting an assessment with a client who has co-occurring issues, the counselor:',27,12590,NULL,NULL),(70,'The LOCI-2R is designed to:',27,12595,NULL,NULL),(71,'A client tells a counselor that she is unhappy with the way her treatment is progressing. The counselor should:',28,12601,NULL,NULL),(72,'The measurement of progress toward treatment plan goals is best assessed by:',28,12602,NULL,NULL),(73,'When a client discloses suicidal thoughts, the counselor\'s first step is to:',28,12609,NULL,NULL),(74,'The treatment plan is developed based on information collected during:',28,12612,NULL,NULL),(75,'During a session you notice that the client is getting progressively more agitated. You suspect a potential for violence unless something is done immediately. Your BEST course of action would be to:',28,12617,NULL,NULL),(76,'What is the Purpose of Screening in the treatment setting?',28,12620,NULL,NULL),(77,'How do Family Members Fit into Assessment and Treatment Planning',28,12622,NULL,NULL),(78,'When explaining your assessment findings to your client the counselor should:',28,12627,NULL,NULL),(79,'When evaluating client readiness you must:',28,12630,NULL,NULL),(80,'The Transtheoretical Model of Change:',28,12634,NULL,NULL),(81,'Assessment of resistance and denial is important to:',28,12638,NULL,NULL),(82,'To ask a client what goals she/he wish to work on:',28,12644,NULL,NULL),(83,'Treatment plans should be:',28,12651,NULL,NULL),(84,'Problem statements in treatment plans should be:',28,12655,NULL,NULL),(85,'The treatment plan is developed based on information collected during:',28,12658,NULL,NULL),(86,'In developing a treatment plan which of the following is true?',28,12660,NULL,NULL),(87,'In formulating treatment plans, effective counselors are willing to consider feedback from colleagues, but most importantly:',28,12665,NULL,NULL),(88,'A treatment plan:',28,12673,NULL,NULL),(89,'What is the acronym for writing strength-based, outcome driven objectives?',28,12676,NULL,NULL),(90,'Treatment Plans should be based on the client’s:',28,12679,NULL,NULL),(91,'Some of the qualities of a well written treatment plan are:',28,12682,NULL,NULL),(92,'What is an objective?',28,12689,NULL,NULL),(93,'All of the following should be included when writing a treatment plan goal EXCEPT:',28,12692,NULL,NULL),(94,'A treatment plan problem is defined as:',28,12695,NULL,NULL),(95,'An effective Treatment Plan must be all of the following EXCEPT:',28,12698,NULL,NULL),(96,'The Treatment Plan details all of the following EXCEPT:',28,12705,NULL,NULL),(97,'Treatment Plan problems, goals and objectives should be:',28,12706,NULL,NULL),(98,'What is not part of a comprehensive assessment?',28,12712,NULL,NULL),(99,'A mutually-agreed-upon treatment plan should include:',28,12717,NULL,NULL),(100,'When counselors keep a neutral attitude while working with the client on their treatment plan, the client may feel like:',28,12720,NULL,NULL),(101,'Using the Stages of Change in treatment planning allow for a problem, goal and objective to be created that:',28,12725,NULL,NULL),(102,'All of the following are examples of specific change oriented goals EXCEPT:',28,12726,NULL,NULL),(103,'The acronym M.A.T.R.S. stands for:',28,12733,NULL,NULL),(104,'Treatment Plan interventions should reflect:',28,12737,NULL,NULL),(105,'When establishing treatment plan goals, keep in mind to:',28,12739,NULL,NULL),(106,'Well-formed treatment plan goals are:',28,12747,NULL,NULL),(107,'Which client statement reflects someone in the Pre-Contemplation Stage?',28,12749,NULL,NULL),(108,'Which client statement reflects someone in the Maintenance Stage?',28,12757,NULL,NULL),(109,'Which client statement reflects someone in the Preparation Stage?',28,12760,NULL,NULL),(110,'Which client statement reflects someone in the Contemplation Stage?',28,12763,NULL,NULL),(111,'Which client statement reflects someone in the Action Stage?',28,12771,NULL,NULL),(112,'When met with client resistance it is best practice to:',28,12775,NULL,NULL),(113,'Where does the counselor keep track of the client’s progress or lack of progress with treatment plan goals & objectives?',28,12778,NULL,NULL),(114,'Therapist / counselors should demonstrate what qualities during treatment planning?',28,12785,NULL,NULL),(115,'The treatment plan review aides in decision making in all of the following EXCEPT:',28,12786,NULL,NULL),(116,'Progress notes must include:',28,12795,NULL,NULL),(117,'The initial services authorization by insurance companies is determined by:',28,12796,NULL,NULL),(118,'Treatment Planning begins:',28,12803,NULL,NULL),(119,'The Initial Treatment Plan is used:',28,12807,NULL,NULL),(120,'The Transtheorectical Model (TTM) is different from traditional treatment planning methods in the following way:',28,12808,NULL,NULL),(121,'The abstinence contract, schedule of activities, and recovery activities are all part of:',28,12814,NULL,NULL),(122,'What stage of motivational readiness to change corresponds with the following client statement: “I guess this is making my life difficult, but it’s just too hard to change.”',28,12817,NULL,NULL),(123,'What stage of motivational readiness to change corresponds with the following client statement: “I’ve stopped gambling now for eight months and doing well with urges to gamble.”',28,12824,NULL,NULL),(124,'What stage of motivational readiness to change corresponds with the following client statement: “I don’t have a problem with anger; it’s just because I’m depressed.”',28,12826,NULL,NULL),(125,'It is not the severity or functioning that determines the treatment plan, but the diagnosis, preferably in DSM terms.',28,12832,NULL,NULL),(126,'If a person is ambivalent, it is best to set the treatment plan goals for them.',28,12834,NULL,NULL),(127,'The counselor’s role is to work collaboratively with the client when creating the treatment plan.',28,12835,NULL,NULL),(128,'If a client disagrees with your assessment or treatment plan recommendations, it is best to gently remind him or her that you are the professional and they are the client.',28,12838,NULL,NULL),(129,'Progress Notes too often just document attendance at a session or compliance with treatment expectations, instead of specific information on response to treatment.',28,12839,NULL,NULL),(130,'Goals should be written for the client as we know what is best for their recovery.',28,12842,NULL,NULL),(131,'Clients should be encouraged to express their concerns with the treatment plan.',28,12843,NULL,NULL),(132,'Clients in early stages of change need relapse prevention strategies.',28,12845,NULL,NULL),(133,'When is it Appropriate to Refer a Client to Another Facility?',29,12851,NULL,NULL),(134,'John enters treatment and laments the fact that he is unable to get a job. He believes that if he had the skills to get a good job, it would help his substance abuse problem. As a counselor you should:',29,12856,NULL,NULL),(135,'Which is not an appropriate criterion, on its own, to be used for evaluating a facility before a referral?',29,12858,NULL,NULL),(136,'Which is true about a referral?',29,12861,NULL,NULL),(137,'Changes to the Treatment Plan Are:',29,12867,NULL,NULL),(138,'Dropping out of treatment:',29,12872,NULL,NULL),(139,'Which of the following is a good example of a counselor matching client needs to a referral?',29,12875,NULL,NULL),(140,'A potential client calls your treatment center looking for treatment for a heroin addiction. He is an Injected Drug User and may have been exposed to HIV and Hepatitis. Your best course of action would be to:',29,12877,NULL,NULL),(141,'Which of the following would be the first step in understanding a client’s needs:',29,12884,NULL,NULL),(142,'Service Coordination is:',29,12887,NULL,NULL),(143,'Service Coordination is made successful by:',29,12893,NULL,NULL),(144,'Which of the following are considered unethical behavior on the part of an addiction counselor?',29,12899,NULL,NULL),(145,'An initial evaluation of the centers to which clients are referred is important. How often should you re-evaluate referral facilities?',29,12901,NULL,NULL),(146,'Which of the following would not be considered an appropriate referral?',29,12905,NULL,NULL),(147,'A counselor’s treatment obligations include:',29,12910,NULL,NULL),(148,'A client’s understanding of why a referral is made is:',29,12912,NULL,NULL),(149,'Sarah is now in her third stint in rehab. She enters your treatment center hoping for a different outcome. Which of the following is true?',29,12918,NULL,NULL),(150,'Successful Service Coordination Involves:',29,12922,NULL,NULL),(151,'Models of Case Management include:',29,12928,NULL,NULL),(152,'Primary Functions of Case Management include:',29,12931,NULL,NULL),(153,'In substance abuse treatment, case management provides:',29,12939,NULL,NULL),(154,'Case Management aides in a client’s recovery by:',29,12944,NULL,NULL),(155,'The primary difference between treatment assessments and case management assessments is:',29,12946,NULL,NULL),(156,'The Stages of Change guide both treatment and case management.',29,12949,NULL,NULL),(157,'The concept of “friendly neighbors” involved:',29,12954,NULL,NULL),(158,'Deinstitutionalization of persons who were in long-term psychiatric care resulted in:',29,12956,NULL,NULL),(159,'Case management enhances treatment by:',29,12959,NULL,NULL),(160,'Historically, drug addicts were sent where to “get help?”',29,12964,NULL,NULL),(161,'In 1972 TASC began to:',29,12970,NULL,NULL),(162,'Consultation with other professionals benefits clients by:',29,12976,NULL,NULL),(163,'The referral process involves knowledge of community resources and:',29,12980,NULL,NULL),(164,'Case management with people with co-occurring disorders requires:',29,12983,NULL,NULL),(165,'Integrated Services is:',29,12985,NULL,NULL),(166,'An alternative to traditional case management is:',29,12989,NULL,NULL),(167,'Referral, Service Coordination, and Consultation are all part of:',29,12996,NULL,NULL);

--
-- Table structure for table `response`
--

CREATE TABLE `response` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `question_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `response` varchar(60) NOT NULL,
  `attempt` int(11) NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`,`question_id`,`course_id`),
  KEY `question_id` (`question_id`),
  KEY `test_id` (`course_id`),
  KEY `response` (`response`),
  CONSTRAINT `response_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `response_ibfk_4` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `response`
--


--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `access_code` varchar(60) DEFAULT NULL,
  `staff_type_select` varchar(60) DEFAULT NULL,
  `footer_column_1` blob,
  `footer_column_2` blob,
  `payment_activated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'cap2019',NULL,'','',0);

--
-- Table structure for table `training`
--

CREATE TABLE `training` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `title` varchar(90) DEFAULT NULL,
  `date_completed` int(90) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `training_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `training`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `lname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `email` varchar(60) CHARACTER SET utf8 NOT NULL,
  `pass` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `birthdate_day` int(11) NOT NULL,
  `birthdate_month` int(11) NOT NULL,
  `birthdate_year` int(11) NOT NULL,
  `join_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `confirmation_code` int(11) DEFAULT NULL,
  `confirmed` int(1) NOT NULL DEFAULT '1',
  `CEU_count` int(11) DEFAULT NULL,
  `access_level` int(11) DEFAULT '0',
  `staff_type` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `active` int(1) NOT NULL DEFAULT '1',
  `hired_date` int(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (10,'John','Sheppard','jcshep@gmail.com','78bfd17437cb85e2d2acb28c01717fe5f8b13d1fd54fe9fc974934403d79a205',2,2,1941,'2014-03-04 20:52:18',46863347,1,25,1,NULL,1,NULL),(110,'Cornell','Peters','fortriscorp@gmail.com','fe2e757802f5cff053eb5307ea69e65203bfff78e82b9144d47600008902a547',2,6,1982,'2015-02-18 19:54:58',30182285,1,35,1,NULL,1,NULL),(202,'Erik','Hurvitz','erik@addictionacademy.com','f1b297e81a3c55654cdcae359f37a4cfb210b4cf6d29d23f1594d47b8f5a5b22',0,0,0,'2018-06-21 19:35:07',33302461,1,14,1,NULL,1,NULL);

--
-- Table structure for table `user_course_access`
--

CREATE TABLE `user_course_access` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `status` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `time_completed` int(11) unsigned DEFAULT NULL,
  `evaluated` int(11) DEFAULT '0',
  `essay_grade` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `user_course_access_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `user_course_access_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_course_access`
--


--
-- Current Database: `demo_school`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `demo_school` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `demo_school`;

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  `short_description` text CHARACTER SET utf8,
  `description` text CHARACTER SET utf8,
  `passing_percentage` int(11) DEFAULT NULL,
  `cost` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `instruction_methods` text CHARACTER SET utf8,
  `evaluation_method` text CHARACTER SET utf8,
  `study_guide` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `study_guide_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `case_study` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `syllabus` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `video` text CHARACTER SET utf8,
  `ceu_credit` int(11) unsigned DEFAULT '0',
  `promo_code` varchar(60) DEFAULT NULL,
  `frequency_required` varchar(90) DEFAULT NULL,
  `staff_requirement` varchar(90) DEFAULT NULL,
  `required_within_time` varchar(90) DEFAULT NULL,
  `in_person` varchar(11) DEFAULT NULL,
  `essay_question` int(1) DEFAULT NULL,
  `essay_question_content` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course`
--

INSERT INTO `course` VALUES (3,'HIV / AIDS - 2 CEU','HIV is an acronym for human immunodeficiency virus and it is the disease that often leads to AIDS. Continuing Education Course (2 CEUs)','<p style=\"margin: 0px; padding: 0px; font-size: 12px; color: rgb(68, 68, 68); line-height: 18px; font-family: helvetica, arial, sans-serif;\">This class provides information on HIV and AIDS- related illnesses. Materials will be presented on the symptoms, causes, pathophysiology, diagnosis, transmission and prevention, treatment, epidemiology, prognosis, and history of HIV and AIDS.</p>',80,'0','Online Only',NULL,'Online-HIVAIDS-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'','730',NULL,'30','0',NULL,NULL),(4,'Aggression Management - 2 CEU','The effective handling of aggression is one of the most demanding aspects of working in Behavioral Health. It is an area in which the ability to manage self and assertively communicate with others is essential. This course will explore identifying, preventing and managing aggressive behavior through the use of verbal de-escalation interventions. ','<strong>Course Overview and Objectives</strong><br><br>The effective handling of aggression is one of the most demanding aspects of working in Behavioral Health. It is an area in which the ability to manage self and assertively communicate with others is essential. This course will explore identifying, preventing and managing aggressive behavior through the use of verbal de-escalation interventions. <br><br>Upon successful completion of this course the learner will be able to: <br><br><ol><li>Define “Aggression” and “Verbal De-escalation\" <br></li><li>Identify warning signs for aggressive behavior. <br></li><li>Give examples of verbal\r\nde-escalation techniques to use in a crisis situation\r\n   </li></ol>',80,'0','Online Only',NULL,'online-aggression-management-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL,NULL,NULL),(5,'Infection Control - 1 CEU','Healthcare workers are required to participate in an annual training on infection prevention and control. 1 CEU','<p>Healthcare workers are required to participate in an annual training on infection prevention and control. At the end of this study guide participants will be able to:</p>\r\n<ul>\r\n<li>Understand modes of transmission of bacteria and infections</li><li>Understand universal precautions</li><li>Practice proper hand washing techniques</li>\r\n<li>Take action to prevention of the spread of disease in your workplace</li>\r\n</ul>\r\n\r\n\r\n\r\n',80,'0','Online Only',NULL,'Online-InfectionControl-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',NULL,NULL,NULL,NULL,NULL,NULL),(7,'HIPAA - 2 CEU','Confidentiality is one of the most basic rights that our clients have. All healthcare workers are legally and morally bound to protect the confidentiality of others.','<p style=\"margin: 0px; font-size: 12px; font-family: Helvetica;\">Confidentiality is one of the most basic rights that our clients have. All healthcare workers are legally and morally bound to protect the confidentiality of others.</p><p style=\"margin: 0px; font-size: 12px; font-family: Helvetica;\"><br></p>\r\n<p style=\"margin: 0px; font-size: 12px; font-family: Helvetica;\">This course is designed to:</p><p style=\"margin: 0px; font-size: 12px; font-family: Helvetica;\"></p><ol><li>Give you an overview of The Health Insurance Portability and Accountability Act of 1996 (HIPAA).</li><li>Familiarize you with any major changes that have been implemented with the new 2013 Omnibus Rule Changes.</li><li>Help you recognize the serious consequences if you fail to comply with HIPAA.</li></ol><p></p>\r\n\r\n',80,'0','Online Only',NULL,'Online-HIPAA-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL,NULL,NULL),(8,'The American’s With Disability Act - 1 CEU','The Americans with Disabilities Act (ADA), which was signed into law on July 26, 1990, is the nation’s first comprehensive civil rights law addressing the needs of people with disabilities, prohibiting discrimination in employment, public services, public accommodations, and telecommunications. The ADA assures equality of opportunity, full participation, independent living, and economic self-sufficiency to persons with disabilities.','The Americans with Disabilities Act (ADA), which was signed into law on July 26, 1990, is the nation’s first comprehensive civil rights law addressing the needs of people with disabilities, prohibiting discrimination in employment, public services, public accommodations, and telecommunications. The ADA assures equality of opportunity, full participation, independent living, and economic self-sufficiency to persons with disabilities.',80,'0','Online',NULL,'ADAonlinefinal.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',NULL,NULL,NULL,NULL,NULL,NULL),(9,'Abuse Reporting & Affirmative Duties - 1 CEU','Every individual in Florida has a responsibility to report suspected abuse or neglect. In addition, Florida Law specifies professionals in certain occupations as required to report abuse or neglect. This course will take you through the legal requirements in Florida regarding abuse reporting and affirmative duties.','<p>Everyone in Florida is a mandated reporter but some people are professionally mandated reporters. Every person has a responsibility to report suspected abuse or neglect. In addition, Florida Law specifies professionals in certain occupations as required to do so. These professionals are mandated to make a report if they have reasonable  cause to suspect abuse, neglect or exploitation is of a child or a vulnerable adult. Providers of substance abuse services shall adhere to the statutory requirements for reporting abuse, neglect, and deaths of children under Chapter 39, F.S., and of adults under Section 415.1034 and paragraph 397.501(7)(c), F.S.</p>',80,'0','Online',NULL,'finalcurrentchapter 415.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'','730',NULL,'90','0',NULL,NULL),(10,'Sexual Harassment - 2 CEU','After completing this self-study session, you will be able to: Define sexual harassment, Identify the types of sexual harassment and Identify behaviors that may be interpreted as sexual harassment.','<p>After completing this self-study session, you will be able to:</p><ul>\r\n<li>Define sexual harassment.</li><li>Identify the types of sexual harassment.</li><li>Identify behaviors that may be interpreted as sexual harassment.</li></ul>',80,'0','Online',NULL,'finalsexualharassment.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'','730',NULL,'90','0',NULL,NULL),(11,'Domestic Violence - 2 CEU','This course is designed to assist the behavioral healthcare worker in understanding domestic violence and the mandates that involve behavioral healthcare workers. In addition to defining domestic violence, this course will review the effects of domestic violence, the cycle of violence, associated risk factors, safety planning, confidentiality and the legalities of domestic violence.','This course is designed to assist the behavioral healthcare worker in understanding domestic violence and the mandates that involve behavioral healthcare workers. In addition to defining domestic violence, this course will review the effects of domestic violence, the cycle of violence, associated risk factors, safety planning, confidentiality and the legalities of domestic violence.&nbsp;\r\n<div><br></div><div>Upon completion of this course the participant will:&nbsp;</div><div><ul><li><span style=\"font-size: 10pt;\">Be able to define domestic violence.</span></li><li><span style=\"font-size: 10pt;\">Be able to discuss the statistics related to domestic violence.</span></li><li><span style=\"font-size: 10pt;\">Develop an understanding of the impact and consequences of domestic violence on the\r\nvictim from a health, psychological, and emotional perspective.</span></li><li><span style=\"font-size: 10pt;\">Be able to assess, counsel and formulate safety plans for clients at risk of domestic violence\r\nor who are currently in a violence relationship.&nbsp;</span></li><li><span style=\"font-size: 10pt;\">Be able to identify national and local domestic violence resources.</span></li></ul></div>',80,'0','Online Only',NULL,'finaldomesticviolence.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL,NULL,NULL),(12,'Understanding Co-occurring Disorders - 2 CEU','Prevalence rates show that individuals with co-occurring disorders are common in both the substance abuse and mental health treatment systems. This course will provide participants with an understanding of the concept and term: co-occurring disorders.','Prevalence rates show that individuals with co-occurring disorders are common in both the substance abuse and mental health treatment systems. This course will provide participants with an understanding of the concept and term: co-occurring disorders. Participants will become familiar with the assessment, symptoms, and treatment of co-occurring disorders, and will be provided with an example of a special population that exists within the realm of co-occurring disorders. &nbsp;<div><br></div><div>On completion of this course, participants will be able to identify/demonstrate familiarity with:&nbsp;</div><div><ol><li><span style=\"font-size: 10pt;\">The definition and terms related to co-occurring disorders.&nbsp;</span></li><li><span style=\"font-size: 10pt;\">The assessment of co-occurring disorders and common symptoms.&nbsp;</span></li><li><span style=\"font-size: 10pt;\">The relationship between substance abuse and mental health concerns.&nbsp;</span></li><li><span style=\"font-size: 10pt;\">The symptoms of specific co-occurring disorders.&nbsp;</span></li><li><span style=\"font-size: 10pt;\">Available treatments for clients with co-occurring disorders.&nbsp;</span></li><li><span style=\"font-size: 10pt;\">A special population example and co-occurring disorders.</span></li></ol></div>',80,'0','Online',NULL,'Co-Occuring Disorders.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL,NULL,NULL),(13,'Ethics & Boundaries - 2 CEU','The purpose of this training is to clarify professional ethical expectations for addiction professionals, assist in defining professional boundaries, and highlight potential boundary problems.','<p style=\"font-family: -apple-system-font; font-size: 12px; line-height: 16px;\">The purpose of this training is to clarify professional ethical expectations for addiction professionals, assist in defining professional boundaries, and highlight potential boundary problems.</p><p style=\"font-family: -apple-system-font; font-size: 12px; line-height: 16px;\">Upon completion of this course the participant will:</p><p style=\"font-family: -apple-system-font; font-size: 12px; line-height: 16px;\"></p><ol><li>Be able to understand and define ethics.</li><li>Understand and be able to demonstrate ethical and professional behavior.</li><li>Be able to define, implement and practice client informed consent.</li><li>Be able to define and recognize boundary issues between client and counselor.</li><li>Be able to define and interpret the roles of transference, counter-transference and other potential boundary issues in clinical practice.</li></ol><p></p>',80,'0','Online Only',NULL,'ethicsfinal.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL,NULL,NULL),(14,'Suicide and Self-Harm - 2 CEU','Nearly everyone at some time in his or her life thinks about suicide. Most everyone decides to live because they come to realize that the crisis is temporary, but death in not. On the other hand, people in the midst of a crisis often perceive their dilemma as inescapable and feel an utter loss of control.','Nearly everyone at some time in his or her life thinks about suicide. Most everyone decides to live because they come to realize that the crisis is\r\ntemporary, but death in not. On the other hand, people in the midst of a crisis often perceive their dilemma as inescapable and feel an utter loss of control.',80,'0','',NULL,'AAP-Suicide-Self-Harm.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL,NULL,NULL),(15,'Cultural Diversity - 2 CEU','','',80,'0','Online Only',NULL,NULL,NULL,NULL,'Cultural-Diversity.ppsx',NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL,NULL,NULL),(25,'Incident Reporting Requirements - 1 CEU','All public or private substance abuse service providers, licensed by The Department of Children and Families (DCF) must create and maintain policies and procedures for Incident Reporting.','<p>All public or private substance abuse service providers, licensed by The Department of Children and Families (DCF) must create and maintain policies and procedures for Incident Reporting. This course details the internal procedure for completing and filing an incident report form for an unusual event, as well as, the procedure for reporting a critical incident to the DCF and Joint Commission.</p>',80,'0','',NULL,'AAP-Incident-Reporting.pdf','Incident-Reporting-Appendix.pdf',NULL,NULL,NULL,NULL,NULL,1,'',NULL,NULL,NULL,'0',NULL,NULL),(26,'Certified Behavioral Health Technician','<p>As a CBHT you will most often assist counselors and therapists by providing critical support services to patients who are receiving drug rehab, substance abuse or mental health treatment in a variety of treatment settings. </p>','<p>As a CBHT you will most often assist counselors and therapists by providing critical support services to patients who are receiving drug rehab, substance abuse or mental health treatment in a variety of treatment settings. With this certification you will be taking a huge step forward in your career in the addiction industry. Here at the Academy for Addiction Professionals you’ll learn the skills and knowledge necessary for receiving a designation that will open up doors in the recovery industry.</p>',80,'','',NULL,'AAP-CBHT-Online.pdf',NULL,NULL,'CBHT-Presentation.pptx','CBHT-Confidentiality.pptx',NULL,NULL,30,'','',NULL,'','0',1,'Please write an essay of 1000 words on both of the following two topics:\r\n\r\nIn your own words, and using this course material and your own research, write 1000 words on the principles of effective crisis management (including suicidality) and offer a brief example of the development and resolution of a crisis involving a newly admitted client.\r\n\r\nand \r\n\r\nUsing both the information contained in this course and your own research, write 1000 words on the core principles of confidentialty (including HIPAA), why they are important and the ramifications of a breach.');

--
-- Table structure for table `course_category`
--

CREATE TABLE `course_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_category`
--

INSERT INTO `course_category` VALUES (1,'Continuing Education'),(2,'Personal Development'),(3,'Communication'),(4,'Management & Leadership'),(5,'Marketing'),(6,'Organizational Efficiency'),(7,'Certified Behavioral Health Technician (CBHT)');

--
-- Table structure for table `course_has_category`
--

CREATE TABLE `course_has_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  `course_offering_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  KEY `course_offering_id` (`course_offering_id`),
  KEY `course_category_id` (`course_category_id`),
  CONSTRAINT `course_has_category_ibfk_3` FOREIGN KEY (`course_offering_id`) REFERENCES `offerings` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_5` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_6` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_has_category`
--

INSERT INTO `course_has_category` VALUES (9,4,1,1),(13,5,1,1),(14,11,1,1),(15,12,1,1),(16,15,1,1),(17,13,1,1),(18,14,1,1),(19,7,1,1),(20,8,1,1),(21,10,1,1),(22,3,1,1),(23,25,1,1),(24,9,1,1);

--
-- Table structure for table `evaluation`
--

CREATE TABLE `evaluation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT NULL,
  `date` int(11) NOT NULL,
  `student_name` varchar(60) DEFAULT NULL,
  `question_1` text,
  `question_2` text,
  `question_3` text,
  `question_4` text,
  `question_5` text,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `evaluation`
--

INSERT INTO `evaluation` VALUES (15,4,1427386170,'kris schupbach','learning','nothing\r\n','nothing','yes','same',5),(16,4,1427421842,'Deshaun Jones','The Different types of barriers.','Nothing,Everything was informative. ','I think this was well but together.','Yes it was.','First time taken this course in the future I will no a little more about these courses and will be able to choice..',4),(17,5,1427423480,'Deshaun Jones ','The different types of diseases that\'s out there','Everything was very informative','Nothing','Yes is was','',4),(18,5,1427423580,'Deshaun Jones ','The different types of diseases that\'s out there','Everything was very informative','Nothing','Yes is was','First time take course',5),(19,4,1427435159,'William Robinson ','Very easy to understand ','Nothing','Nothing','Yes','Searching a client ',3),(20,4,1427498282,'a','everythig','othing','nothing','yes','cpr',3),(21,5,1431426018,'Joyns Fleming','ease of use','information was valuable','nothing','yes','computerized',5),(22,11,1433064894,'Robert Elvir','The clear presentation.','Lack of A/V aides.','Add A/V aids.','yes','Laws',3),(23,13,1433270595,'','','','','','',5),(24,12,1433271685,'Ron Cook','','','','','',4),(25,11,1433864218,'Albert Diaz','Wording.','Obvious','None','Yes','Same',4),(26,5,1433864456,'Albert Diaz','Yes','Yes','Nothing','Yes','All',4),(27,5,1433864459,'Albert Diaz','Yes','Yes','Nothing','Yes','All',4),(28,9,1433946160,'Ron Cook','','','','','',4),(29,14,1433946716,'Ron Cook','','','','','',4),(30,12,1434374865,'Pedro Diaz','','','','','',5),(31,13,1434375773,'Pedro Diaz','','','','','',4),(32,9,1434375995,'Pedro Diaz','','','','','',5),(33,14,1434376329,'Pedro Diaz','','','','','',4),(34,15,1434376575,'Pedro Diaz','','','','','',4),(35,5,1435166762,'','','','','','',5),(36,4,1454952013,'Eric Crear','it was quick','nothing','nothing','yes','The same',5),(37,4,1455022353,'Al Diaz','Everything.','Reading.','Nothing.','Yes.','All types.',5),(38,4,1455045695,'','','','','','',5),(39,5,1455491901,'Melanie Duffy','Very informative.','It was all fine. No complaints.','I have no answer for that.','Yes, it was well written.','Psychopharmacology',4),(40,5,1455640585,'Burt Boyle','All','All','Good','Yes it was','',5),(41,11,1458136526,'Pedro Diaz','Convenience. ','It was all good.','Don\'t know.','It was interesting.','Don\'t know.',4),(42,4,1459528711,'Sonya Skinner','Everything.','None.','Nothing, great course!!','Very stimulating, thank you.','',5),(43,14,1460250321,'Sonya Skinner','Everything','N/A','Nothing','Yes','',5),(44,7,1460252018,'Sonya Skinner','Everything','Nothing','Nothing','Yes','',5),(45,5,1461184659,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating.','Required courses to renew our credentials.',5),(46,11,1461186639,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating.','Required courses to renew our credentials.',5),(47,15,1461465425,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating.','CEU\'s that are needed to nenew our nursing credentials.',5),(48,12,1461468529,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating','CEU\'s that pertain to our nursing credentials.',5),(49,13,1461776358,'Sonya Skinner','Everything','None','Nothing','Very stimulating.','CEU\'s needed for licensure.',5),(50,8,1461860606,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating.','CEU\'s pertaining to renewal of licensure.',5),(51,8,1462002614,'Joyns Fleming','everything','nothing','nothing','very','same',5),(52,10,1462487919,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating','CEU on Medical Errors, required for our licensure!',5),(53,3,1463162417,'Sonya Skinner','Everything','Nothing','Nothing','Very stimulating','CEU\'s  that are required for licensure.',5),(54,5,1487903557,'Andrea Bonkosky','that the course is online. ','the web portal was down at times','n/a','yes.','n/a',4),(55,25,1488072433,'Andrea Bonkosky','It\'s offered online and I can access at any time.','n/a. the course was great.','n/a. the course was great. ','yes.','No other courses at this time. ',4),(56,5,1488072513,'Andrea Bonkosky','I can access the course online at any time. ','n/a. I enjoyed the course.','n/a. I enjoyed the course.','yes. ','no other courses at this time. ',4),(57,8,1488072656,'Andrea Bonkosky','I can access the course online at any time. ','n/a. I enjoyed the course. ','n/a. ','Yes. ','no other courses at this time. ',4),(58,10,1488075475,'Andrea Bonkosky','It was online and was accessible at all times. ','Experienced problems with the portal. The exam was not loading. Once it loaded, it shows me as taking it 5 times; when in fact, it was taken and passed successfully on the first attempt. ','Experienced problems with the web portal that requiring fixing. ','yes. ','n/a',4),(59,11,1488076863,'Andrea Bonkosky','I can access course online at any time. ','I had to take the exam several times due to experiencing technical difficulties with loading the portal among other factors. ','n.a','yes.','none at this time. ',3),(60,13,1488078041,'Andrea Bonkosky','online course that can be accessed online at any time. ','none at this time. ','none at this time','yes.','none at this time',3),(61,15,1488078303,'Andrea Bonkosky','The course can be accessed online at any time. ','too short. not enough information covered. important information was left out. ','n.a','no','a more developed cultural competency course. ',1),(62,12,1488079543,'Andrea Bonkosky','The course is accessible online. ','n/a','n/a','yes.','I can\'t think of any at this time. ',4),(63,3,1488163905,'Theodore Thompson ','','','','','',5),(64,7,1498963143,'Christopher Foster','That there was multiple options and it allowed the users to pick different options','There is not enough questions','Nothing','Yes','None',5),(65,5,1498964410,'Chris Foster','The questions made you think','I felt the questions had multiple answers','The system has errors','Yes','None',5),(66,5,1498973757,'Sam carpenter','Solid information.','Na','More pictures','Yes','Na',5),(67,14,1498974417,' ',' ',' ',' ',' ',' ',5),(68,4,1499283353,'John Sannicandro','ease of access','na','more examples','yes','similar course on client direct care',3),(69,4,1499963922,'','','','','','',3),(70,4,1499963950,'','','','','','',3),(71,5,1499964658,'','','','','','',3),(72,4,1500580956,'Mark Macaluso','it was very straight forward and educational.','nothing it was fine','nothing','yes','',5),(73,5,1502562192,'William Judd','Nothing','All','Nothing','no','none ',5),(74,4,1513356583,'','','','','','',3),(75,4,1518782781,'Frankie johnson','N/a','N/a','N/a','N/a','N/a',4),(76,11,1520295974,'Serge Bazin','How specific it was lol','How specific it was','Not be so specific','No','none',3),(77,4,1520346773,'','','','','','',3),(78,4,1520346794,'','','','','','',3),(79,4,1520531105,'','','','','','',3),(80,4,1520531297,'','','','','','',3),(81,4,1520531298,'','','','','','',3),(82,4,1522325261,'Frankie johnson','Na ','Na','Na','Na','Na',2),(83,4,1522325351,'Frankie johnson','Na','Na','Na','Na','Na',2),(84,5,1522326295,'Frankie johnson','Na','Na','Na','Na','Na',2),(85,11,1522345285,'Frankie johnson','Na','Na','Na','Na','Na',2),(86,3,1522345982,'Frankie johnson','Na','Na','Na','Na','Na',2),(87,5,1522697280,'Dawn DeCosta','Nothing','Repetitious','Interactive','No','',2),(88,4,1522759039,'','','','','','',4),(89,4,1522759061,'Shantel Ingraham','','','','','',4),(90,9,1523581702,'FRANKIE B JOHNSON','Na','Na','Na','Na','Na',2),(91,8,1524351112,'FRANKIE B JOHNSON','Na','Na','Na','Na','Na',3),(92,3,1524514823,'Lewis E. Hastings','fast','stuff','have someone else take the test','yes','N/A',5),(93,5,1524526350,'Joseph Kennedy','Mostly common sense but very informative','Hard read','A video or some pictures','no','',3),(94,13,1524574998,'Frankie johnson','Na','Na','Na','Na','',3),(95,14,1524575994,'FRANKIE B JOHNSON','Na','Na','Na','Na','',3),(96,15,1524576389,'FRANKIE B JOHNSON','Na','Na','Na','Na','',3),(97,25,1524577894,'FRANKIE B JOHNSON','Na','Na','Na','Na','',3);

--
-- Table structure for table `exam_results`
--

CREATE TABLE `exam_results` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `grade` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `exam_results_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `exam_results_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1375 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exam_results`
--

INSERT INTO `exam_results` VALUES (35,10,7,100),(36,10,7,100),(37,10,7,100),(38,10,7,100),(114,10,12,47),(115,10,12,100),(116,10,12,100),(274,10,5,20),(275,10,5,93),(596,10,4,100),(1063,110,9,63),(1372,10,3,70),(1373,10,26,35),(1374,110,26,92);

--
-- Table structure for table `materials`
--

CREATE TABLE `materials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `name` varchar(60) NOT NULL,
  `filename` varchar(60) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `materials_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `materials`
--


--
-- Table structure for table `offering_has_category`
--

CREATE TABLE `offering_has_category` (
  `offering_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  KEY `offering_id` (`offering_id`),
  KEY `course_id` (`course_category_id`),
  CONSTRAINT `offering_has_category_ibfk_1` FOREIGN KEY (`offering_id`) REFERENCES `offerings` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `offering_has_category_ibfk_2` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offering_has_category`
--

INSERT INTO `offering_has_category` VALUES (1,1),(1,2),(1,3),(1,4),(1,5);

--
-- Table structure for table `offerings`
--

CREATE TABLE `offerings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offerings`
--

INSERT INTO `offerings` VALUES (1,'Professional Development');

--
-- Table structure for table `option`
--

CREATE TABLE `option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_id` (`question_id`),
  CONSTRAINT `option_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=12149 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `option`
--

INSERT INTO `option` VALUES (4,6,'1 in 2',NULL),(5,6,'1 in 5',NULL),(6,6,'1 in 3',NULL),(7,6,'1 in 4',NULL),(8,7,'An effective vaccine is now available to prevent the disease.',NULL),(9,7,'HIV testing is not only free but compulsory for everyone over age 18.',NULL),(10,7,'People believe that antiretroviral drugs have solved the HIV problem.',NULL),(11,7,'The number of new infections is continuing to decline.',NULL),(12,8,'Free HIV testing of all patients over age 13.',NULL),(13,8,'Developing a vaccine to prevent HIV infection.',NULL),(14,8,'Reducing the rate of new infections.',NULL),(15,8,'Compulsory HIV testing of all patients in emergency departments.',NULL),(16,9,'Black/African Americans.',NULL),(17,9,'Seniors.',NULL),(18,9,'Hispanics.',NULL),(19,9,'Native Americans.',NULL),(20,10,'Women and children, seniors, and transgender persons',NULL),(21,10,'Men who have sex with men, women who have sex with women, prisoners',NULL),(22,10,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',NULL),(23,10,'Women who have sex with women, homeless people, and seniors',NULL),(24,11,'Adopt compulsory hand-washing policies for staff and inmates.',NULL),(25,11,'Provide inmates with condoms and access to bleach for cleaning injection equipment.',NULL),(26,11,'Increase the number of correctional officers who monitor inmate activity.',NULL),(27,11,'Enroll inmates in HIV vaccine clinical trials.',NULL),(28,12,'When they enter prison.',NULL),(29,12,'Within 60 days prior to release.',NULL),(30,12,'Within 30 days prior to release.',NULL),(31,12,'Never; it is not required by law.',NULL),(32,13,'Healthcare workers are more focused on mental health issues in seniors.',NULL),(33,13,'Seniors avoid answering questions about sexual activity.',NULL),(34,13,'Seniors believe they are immune to HIV/AIDS.',NULL),(35,13,'Symptoms of AIDS such as fatigue and weight loss mimic those of normal aging.',NULL),(36,14,'Saliva and cervical secretions',NULL),(37,14,'Saliva, tears, serous fluid, and vaginal secretions',NULL),(38,14,'Blood, semen, breast milk, and vaginal and cervical secretions',NULL),(39,14,'Blood, semen, and urine',NULL),(40,15,'Blood collected for transfusion',NULL),(41,15,'Used needles and syringes',NULL),(42,15,'Casual contact with an infected patient',NULL),(43,15,'A public toilet seat',NULL),(44,16,'Increases the risk of HIV transmission.',NULL),(45,16,'Reduces the risk of HIV transmission.',NULL),(46,16,'Makes no difference in the risk of HIV transmission.',NULL),(47,16,'Increases the risk of pregnancy in women.',NULL),(48,17,'Syphilis',NULL),(49,17,'Hepatitis B (HBV)',NULL),(50,17,'Chlamydia',NULL),(51,17,'Tuberculosis (TB)',NULL),(52,18,'Relatively simple if the patient has health insurance.',NULL),(53,18,'A complex, multi-drug process that takes at least 6 months.',NULL),(54,18,'Usually not successful in African American patients.',NULL),(55,18,'Successful in most patients.',NULL),(56,19,'Unnecessary in HIV patient situations.',NULL),(57,19,'Warranted only if a patient has been diagnosed with TB.',NULL),(58,19,'Effective only if properly fitted and appropriately worn in all areas where risk of exposure is high.',NULL),(59,19,'Primarily used with patients who are coinfected with hepatitis.',NULL),(60,20,'Brain tumors from syphilis.',NULL),(61,20,'Liver disease from chronic hepatitis C.',NULL),(62,20,'Heart disease from antiretroviral drugs.',NULL),(63,20,'Stroke related to antiretroviral drugs.',NULL),(295,53,'True',NULL),(296,53,'False',1),(299,55,'True',NULL),(300,55,'False',1),(325,60,'True',1),(326,60,'False',NULL),(327,62,'True',1),(328,62,'False',NULL),(329,63,'Defensive level, anxiety level, acting out, tension reduction',NULL),(330,63,'Tension inducing, anxiety level, defensive level, acting out',NULL),(331,63,'Anxiety level, defensive level, acting out, tension reduction',1),(332,63,'Acting out, anxiety level, defensive level, tension reduction',NULL),(333,64,'True',1),(334,64,'False',NULL),(339,82,'Clenched fists',NULL),(340,82,'Pacing',NULL),(341,82,'Rapid breathing',NULL),(342,82,'Withdrawn behavior',NULL),(343,82,'All of the Above',1),(344,83,'The person is under the influence of a substance',NULL),(345,83,'The person has a history of psychiatric illness',NULL),(346,83,'The person is facing a high level of stress',NULL),(347,83,'All of the Above',1),(348,83,'A and B',NULL),(409,58,'Using a calm voice and acronyms or jargon',NULL),(410,58,'Giving the person your full attention',NULL),(411,58,'Paraphrasing what the person is saying',NULL),(412,58,'Validating the person’s feelings about the situation',NULL),(413,58,'All of the above',NULL),(414,58,'B, C, and D',1),(415,59,'Speak slowly clearly and gently',NULL),(416,59,'Walk fast away from client to avoid an altercation',NULL),(417,59,'Appear confident and display calmness',NULL),(418,59,'Show you are listening',NULL),(419,59,'A, C, and D',1),(420,59,'A and B',NULL),(421,61,'Don’t use jargon',NULL),(422,61,'Avoid demeaning language',NULL),(423,61,'Find someone that speaks that person’s language',NULL),(424,61,'A and B',NULL),(425,61,'All of the above',1),(449,54,'True',1),(450,54,'False',NULL),(451,57,'Telling the patient what he/she is feeling.',NULL),(452,57,'Summarize what the patient stated and repeat back to verify accuracy ',1),(453,57,'Make client aware of the incongruities from their statement',NULL),(454,57,'None of the above',NULL),(455,65,'Acting out',NULL),(456,65,'Tension Reduction',NULL),(457,65,'Anxiety Level',NULL),(458,65,'Defensive Level',1),(459,85,'True',1),(460,85,'False',NULL),(463,26,'True',1),(464,26,'False',NULL),(465,27,'False',1),(466,27,'True',NULL),(467,28,'True',1),(468,28,'False',NULL),(469,29,'False',1),(470,29,'True',NULL),(471,30,'True',1),(472,30,'False',NULL),(473,31,'True',NULL),(474,31,'False',1),(475,32,'True',1),(476,32,'False',NULL),(477,33,'True',1),(478,33,'False',NULL),(479,34,'True',1),(480,34,'False',NULL),(481,35,'Abstinence',NULL),(482,35,'Monogamous Relationship with partners not infected with HIV/AIDS',NULL),(483,35,'Protected Sex',NULL),(484,35,'Sterile needles',NULL),(485,35,'All of the above',1),(486,36,'a)	1 in 2',NULL),(487,36,'b)	1 in 6',1),(488,36,'c)	1 in 3',NULL),(489,36,'d)	1 in 4',NULL),(490,37,'Black/African Americans',1),(491,37,'Seniors',NULL),(492,37,'Hispanics',NULL),(493,37,'Native Americans',NULL),(498,38,'Women and children, seniors, and transgender persons',NULL),(499,38,'Men who have sex with men, women who have sex with women, prisoners',NULL),(500,38,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',1),(501,38,'Women who have sex with women, homeless people, and seniors',NULL),(506,39,'Saliva and cervical secretions',NULL),(507,39,'Saliva, tears, serous fluid, and vaginal secretions',NULL),(508,39,'Blood, semen, breast milk, and vaginal and cervical secretions',1),(509,39,'Blood, semen, and urine',NULL),(510,40,'Blood collected for transfusion',NULL),(511,40,'Used needles and syringes',1),(512,40,'Casual contact with an infected patient',NULL),(513,40,'A public toilet seat',NULL),(514,41,'Are entitled to know their child\'s HIV test results without their child\'s consent.',NULL),(515,41,'May not be informed directly or indirectly of their child\'s HIV test results without the child\'s consent.',1),(516,41,'May be informed indirectly of their child\'s HIV test results when sent a bill for said testing.',NULL),(517,41,'Must give consent for their child to be tested for HIV.',NULL),(519,47,'Bona fide medical emergencies',NULL),(520,47,'Court order',NULL),(521,47,'All of the above',1),(522,48,'Sudden shift in mood or behavior',NULL),(523,48,'Skin rash',NULL),(524,48,'Muscle weakness',NULL),(525,48,'Confusion',NULL),(526,48,'a, c, and d ',1),(527,49,'Medical personnel involved with the diagnosis or treatment of the person tested; ',NULL),(528,49,'Licensed medical professionals who regularly participate as part of an interdisciplinary team ',NULL),(529,49,'Staff that handle body fluids ',NULL),(530,49,'Personnel involved in utilization review, risk management or peer review activities; ',NULL),(531,49,'Financial staff who compile or review medical records as part of routine billing activities',NULL),(532,49,'All of the above',1),(533,42,'Be tested for HIV at their initial prenatal visit and at 28-32 weeks.',1),(534,42,'Be tested for HCV at the first prenatal visit.',NULL),(535,42,'Not be offered HIV testing on an opt-out basis (right to refuse).',NULL),(536,42,'Request to be tested for HIV',NULL),(537,67,'A source',NULL),(538,67,'A mode of transmission',NULL),(539,67,'A host',NULL),(540,67,'All of the above',1),(541,68,'Every healthcare worker plays a vital role ',NULL),(542,68,'Staff education is an important aspect',NULL),(543,68,'Utilizes measures used to minimize the risk of transmission',NULL),(544,68,'All of the above',1),(545,69,'Droplets are generated by coughs, sneezes, talking',NULL),(546,69,'Droplet transmission is the most frequent mode of transmission in the healthcare setting',1),(547,69,'You can become infected when they land in eyes, mouth or nose',NULL),(548,69,'They can transmit infection when propelled a short distance and land on a surface',NULL),(549,70,'HIV',NULL),(550,70,'Hepatitis B',NULL),(551,70,'Tuberculosis',1),(552,70,'Herpes',NULL),(553,71,'From mosquitos or insect bites',1),(554,71,'From blood or body fluids',NULL),(555,71,'From food or water',NULL),(556,71,'From coughs and sneezes ',NULL),(557,72,'Wear a fit-tested NIOSH-approved N95',1),(558,72,'Wear a surgical mask',NULL),(559,72,'Take 15 minute hot shower after exposure',NULL),(560,72,'Wash your hands with soap and water for 10 minutes',NULL),(561,73,'Direct contact',NULL),(562,73,'Indirect contact',NULL),(563,73,'Respiratory transmission',NULL),(564,73,'Vector-born transmission',NULL),(565,73,'All of the above',1),(566,74,'Gloves, gowns, respirators',NULL),(567,74,'Face masks, goggles, face shields',NULL),(568,74,'Shoes and socks',NULL),(569,74,'A and B',1),(570,74,'A and C',NULL),(571,75,'Wear protective gloves',NULL),(572,75,'Run away from spill in order to not get contaminated ',NULL),(573,75,'Use a 1:100 or 1:10 bleach based dilution to decontaminate surfaces ',NULL),(574,75,'A and B',NULL),(575,75,'A and C',1),(576,81,'Sweat',1),(577,81,'Saliva',NULL),(578,81,'Blood',NULL),(579,81,'None of the above',NULL),(580,78,'30 seconds',NULL),(581,78,'15 seconds',NULL),(582,78,'At least for 20 seconds',1),(583,78,'60 seconds',NULL),(584,79,'Viruses',NULL),(585,79,'Parasites',NULL),(586,79,'Bacteria',NULL),(587,79,'Fungus',NULL),(588,79,'All of the above',1),(589,80,'Air',NULL),(590,80,'Water',NULL),(591,80,'Bodily fluids',NULL),(592,80,'A and B',1),(593,80,'A and C',NULL),(594,88,'Airborne',NULL),(595,88,'Droplet',NULL),(596,88,'Contact',1),(597,88,'A and B',NULL),(598,89,'Airborne Precautions',NULL),(599,89,'Contact Precautions',NULL),(600,89,'Standard Precautions',1),(601,89,'Droplet Precautions',NULL),(602,90,'True',NULL),(603,90,'False',1),(604,91,'Where clinical professionals, in this case in the addiction industry, have multiple relationship roles with their clients',1),(605,91,'An unaviodable part of doing business in the addiction treatment industry',NULL),(606,91,'A multiple role relationship that is generally suitable for the therapist-client relationship',NULL),(607,91,'All of the above',NULL),(608,92,'To give authorization for treatment center employees to use private information',NULL),(609,92,'To secure a person\'s private financial information',NULL),(610,92,'To define the the proper use of an individual\'s health records',1),(611,92,'To punish addiction treatment centers that misuse personal information',NULL),(612,93,'Health Information Portability Protection Act',NULL),(613,93,'Health Insurance Portability and Accountability Act',1),(614,93,'Human Interest Protection  Act',NULL),(615,93,'None of the above',NULL),(616,94,'True',NULL),(617,94,'False',1),(618,95,'A fraudulent accounting scheme',NULL),(619,95,'The requirement for an arrested person to be brought into court or before a judge',1),(620,95,'The legal definition of self-inflicted bodily harm',NULL),(621,95,'None of the above',NULL),(622,96,'The clinician is the professional',NULL),(623,96,'Proper boundaries cannot be defined therefore this is a moot point',NULL),(624,96,'The client may not understand proper boundaries and may not be able to defend themselves against violations',NULL),(625,96,'The counselor must report to their supervisor',NULL),(626,96,'A and C',1),(627,96,'A and D',NULL),(628,97,'True',1),(629,97,'False',NULL),(630,98,'Quid Pro Quo',NULL),(631,98,'Professional Business',NULL),(632,98,'Dual Relationship',1),(633,98,'None of the Above',NULL),(634,99,'On a need to know basis within the facility',NULL),(635,99,'Medical emergencies',NULL),(636,99,'When parents ask',NULL),(637,99,'Client information can never be disclosed without written consent',NULL),(638,99,'B and C',NULL),(639,99,'A and B',1),(640,100,'Crossed Legs',NULL),(641,100,'Standing Tall',NULL),(642,100,'Slouching',NULL),(643,100,'Red face',NULL),(644,100,'B and D',1),(645,100,'A and B',NULL),(646,101,'True',NULL),(647,101,'False',1),(648,102,'Stress and history of violence',1),(649,102,'Stress and a long marriage',NULL),(650,102,'A long marriage and a high degree of social interaction',NULL),(651,102,'A high degree of social interaction and a history of violence',NULL),(652,103,'Perception and prejudice',NULL),(653,103,'Noise',NULL),(654,103,'Language',NULL),(655,103,'All of the above',1),(656,104,'Common depression',NULL),(657,104,'bipolar disorder doesn\'t fall under the DSMIV-TR purview',NULL),(658,104,'Mood changes that last for 48 hours or less',NULL),(659,104,'Significant mood changes that last for weeks or months',1),(660,105,'True',NULL),(661,105,'False',1),(662,106,'Use',NULL),(663,106,'Abuse',1),(664,106,'Misuse',NULL),(665,106,'Addiction',NULL),(666,107,'A good idea to use as proof',NULL),(667,107,'Not a problem if the copies are lost',NULL),(668,107,'A bad idea unless needed for an important purpose.',1),(669,107,'Something that should never be done',NULL),(670,108,'True',NULL),(671,108,'False',1),(674,110,'True',NULL),(675,110,'False',1),(676,111,'True',NULL),(677,111,'False',1),(678,112,'True',1),(679,112,'False',NULL),(680,113,'True',NULL),(681,113,'False',1),(682,109,'True',1),(683,109,'False',NULL),(684,114,'It eliminates the possibility of infection',NULL),(685,114,'It helps determine the exposure risk of staff members',1),(686,114,'A and B',NULL),(687,114,'None of the above',NULL),(688,115,'Common cold, Pinkeye, Flu',1),(689,115,'Common cold, Flu, HIV',NULL),(690,115,'HIV, Common cold, Pinkeye, Flu',NULL),(691,115,'AIDS, Pinkeye, Flu',NULL),(692,116,'Health Information Property Accountability Association',NULL),(693,116,'Human Insurance Process Accumulation Act',NULL),(694,116,'Health Insurance Portability and Accountability Act',1),(695,117,'Electronic Medical Record ',NULL),(696,117,'Security ',NULL),(697,117,'HITECH',1),(698,117,'HHS',NULL),(699,118,'Medical record number',NULL),(700,118,'Telephone number',NULL),(701,118,'Fax number',NULL),(702,118,'Social security number',NULL),(703,118,'All of the above',1),(704,118,'a, b, d',NULL),(705,119,'True',NULL),(706,119,'False',1),(707,120,'Disciplinary action',NULL),(708,120,'Loss of access privileges',NULL),(709,120,'Fines and penalties',NULL),(710,120,'Imprisonment',NULL),(711,120,'All of the above',1),(712,121,'Yes, if he is an employee and you know him.',NULL),(713,121,'Yes, if your manager says that it’s okay.',NULL),(714,121,'No, sharing log-in IDs and passwords is a security violation.',1),(715,121,'a and b',NULL),(716,122,'I am only expected to complete the minimum requirements of my job.',NULL),(717,122,' A workforce member\'s access to PHI is limited to only what is needed to perform his/her responsibilities.',NULL),(718,122,'Requests for and disclosures of PHI are limited to what is needed to perform the task.',NULL),(719,122,'A medical center is no longer allowed to provide information about patients to the media under any circumstances.',NULL),(720,122,'b and c',1),(725,124,'Yes',NULL),(726,124,'No',1),(734,126,'Yes for example I may need to  communicate client information to my boss for shift change.',NULL),(735,126,'No, because the intended users phone could be lost or stolen and exposed to a third party.',1),(744,125,'Yes.  They can be used interchangeably.',NULL),(745,125,'No. Consents are used to get the patient\'s permission to use or disclose health information for treatment, payment or business operations. Authorizations are used to obtain permission to disclose PHI for activities outside the realm of treatment, payment or business operations.',1),(746,127,'State and local governments',NULL),(747,127,'Private employers',NULL),(748,127,'Employment agencies',NULL),(749,127,'Labor organizations',NULL),(750,127,'All of the above',1),(751,128,'No means of transportation',NULL),(752,128,'A criminal history',NULL),(753,128,'A physical or mental impairment that substantially limits one or more life activities',1),(754,128,'None of the above',NULL),(755,128,'All of the above',NULL),(756,129,'Sexual preference',NULL),(757,129,'Kleptomania',NULL),(758,129,'Illegal Drug use',NULL),(759,129,'All of the above',1),(764,131,'Changing a training manual',NULL),(765,131,'Letting employee sleep during work hours',NULL),(766,131,'Providing an interpreter',NULL),(767,131,'A and C',1),(768,130,'True',1),(769,130,'False',NULL),(770,132,'True',1),(771,132,'False',NULL),(772,133,'True',NULL),(773,133,'False',1),(774,134,'True',1),(775,134,'False',NULL),(776,135,'True',NULL),(777,135,'False',1),(778,136,'Walking',NULL),(779,136,'Breathing',NULL),(780,136,'Eating',NULL),(781,136,'Major bodily functions',NULL),(782,136,'All of the above',1),(831,146,'A public health problem, impacting large numbers of the population',1),(832,146,'A family problem, best dealt with within the family ',NULL),(833,146,'A reportable crime in Florida regardless of whether or not a weapon was used in the abuse',NULL),(834,146,'All of the above',NULL),(847,150,'Verbal abuse',NULL),(848,150,'Physical acting out',NULL),(849,150,'Difficulty getting along with others',1),(850,150,'All of the above',NULL),(851,151,'Forcing sexual acts',NULL),(852,151,'Isolating the victim',NULL),(853,151,'The abuser threatening suicide',NULL),(854,151,'All of the above',1),(855,152,'Drug or alcohol abuse',NULL),(856,152,'Intense jealousy',NULL),(857,152,'Welcoming of others into relationship',1),(858,152,'Will not allow a break-up of the relationship',NULL),(859,153,'Emotional insecurity and depression',1),(860,153,'Belief in the bonds of marriage and monogamy',NULL),(861,153,'Maturity and self-reliance',NULL),(862,153,'Strong ego and many friends',NULL),(867,154,'Withhold money',NULL),(868,154,'Intimidate',NULL),(869,154,'Use children to deliver messages',NULL),(870,154,'All of the above',1),(871,155,'Signs of a victim',NULL),(872,155,'Parts of the cycle of violence',NULL),(873,155,'Signs of an abuser',1),(874,155,'Signs of marital conflict',NULL),(891,160,'Intervening directly with the abuser',NULL),(892,160,'Acknowledging client barriers for seeking help',1),(893,160,'Filing police reports on behalf of the victim',NULL),(894,160,'None of the above',NULL),(903,163,'Increasing safety at home',NULL),(904,163,'Planning for emotional support',NULL),(905,163,'Immediate and long term safety',NULL),(906,163,'All of the above',1),(907,164,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a gunshot wound, or life threatening injury indicating an act of violence.',1),(908,164,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a broken arm, leg etc.',NULL),(909,164,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a fall',NULL),(910,164,'None of the above',NULL),(919,149,'Low self-esteem, low income and drug and alcohol abuse',NULL),(920,149,'Individual, societal, relational and community',1),(921,149,'Anger, passivity, Anti-social personality traits and Borderline personality traits',NULL),(922,149,'All of the above',NULL),(927,158,'Emotional discomfort',NULL),(928,158,'Blaming the victim',1),(929,158,'Cultural barriers',NULL),(930,158,'Uncooperative behavior by the victim',NULL),(931,159,'Accurate documentation and safe guarding evidence',1),(932,159,'Staying disconnected',NULL),(933,159,'Demand the criminal justice system get involved',NULL),(934,159,'All of the above',NULL),(939,161,'Helping victim create a safety plan',NULL),(940,161,'Give advice whether to leave or stay in abusive relationship',1),(941,161,'Validate victims experience',NULL),(942,161,'Respect confidentiality of victim',NULL),(943,165,'That the assessment was conducted and no Domestic Violence signs were indicated',NULL),(944,165,'That the assessment was conducted and the worker did not get an answer about DV from the patient',NULL),(945,165,'That the assessment was conducted and that the patient did not disclose abuse',1),(946,165,'None of the above',NULL),(947,156,'911—If you are in immediate danger',NULL),(948,156,'The National Domestic Violence Hotline at 1-800-799-SAFE (7233)',NULL),(949,156,'The National Sexual Assault Hotline at 1-800-656-4673',NULL),(950,156,'All of the above',1),(955,162,'800-799-7233',NULL),(956,162,'800-500-1119',1),(957,162,'800-656-4673',NULL),(958,162,'800-656-6767',NULL),(959,147,'Stalking, psychological violence; neglect and physical violence',NULL),(960,147,'Physical violence, sexual violence; stalking; and emotional violence',NULL),(961,147,'Physical violence; sexual violence; threats of physical and sexual violence; emotional and psychological violence',1),(962,147,'None of the above',NULL),(963,148,'Witnessing or experiencing violence as a child',NULL),(964,148,'Economic security',1),(965,148,'Weak community sanctions against Domestic Violence such as police being unwilling to intervene',NULL),(966,148,'Dominance and control by one partner in the relationship',NULL),(967,157,'9.2% to 30.5%',1),(968,157,'15%',NULL),(969,157,'24.3%',NULL),(970,157,'14.8%',NULL),(971,166,'a. The presence of two or more disorders at the same time',1),(972,166,'b. The presence of at least 2 mental health disorders',NULL),(973,166,'c. The presence of at least 2 substance related disorders',NULL),(974,166,'d. None of the above',NULL),(979,168,'a. Alcohol and drugs can increase underlying risk for mental disorders.',NULL),(980,168,'b. Alcohol or drugs are often used to self-medicate symptoms of depression or anxiety.',NULL),(981,168,'c. Psychiatric problems do not get worse by using drugs or alcohol.',1),(982,168,'d. Alcohol and drug abuse can make symptoms of a mental health problem worse.',NULL),(983,167,'a. Schizophrenia and Depression ',NULL),(984,167,'b. Bipolar Disorder and Anxiety Disorder',1),(985,167,'c. Depression and Fibromyalgia',NULL),(986,167,'d. Bipolar Disorder and Chronic Fatigue',NULL),(987,169,'a. Lying about one’s addiction',NULL),(988,169,'b. Denial frequently occurs in mental disorders',NULL),(989,169,'c. If the problem is not acknowledged, it doesn\'t exist.',NULL),(990,169,'d. All of the above',1),(991,170,'a. Feeling restless or jumpy',NULL),(992,170,'b. Trouble concentrating',NULL),(993,170,'c. Decreased need for sleep',NULL),(994,170,'d. A and B',1),(995,171,'a. Sequential model of treatment',NULL),(996,171,'b. Parallel model of treatment',NULL),(997,171,'c. Integrated model of treatment',1),(998,171,'d. All of the above',NULL),(999,172,'a. Abusing alcohol and/or other drugs',NULL),(1000,172,'b. A complex interplay of genetics, the environment, and other outside factors. ',1),(1001,172,'c. The environment',NULL),(1002,172,'d. Genetics',NULL),(1011,175,'a. Depression?',NULL),(1012,175,'b. Bipolar Disorder?',NULL),(1013,175,'c. Obsessive Compulsive Disorder?',1),(1014,175,'d. Social Anxiety Disorder? ',NULL),(1015,176,'a. Obsessive Compulsive Disorder?',NULL),(1016,176,'b. Anxiety Disorder?',NULL),(1017,176,'c. Mania phase in Bipolar Disorder?',1),(1018,176,'d. Depression?',NULL),(1019,177,'True',1),(1020,177,'False',NULL),(1021,178,'True',1),(1022,178,'False',NULL),(1023,179,'True',1),(1024,179,'False',NULL),(1025,180,'True',1),(1026,180,'False',NULL),(1042,184,'a. A counselor\'s beliefs',NULL),(1043,184,'b. A counselor\'s moral compass',NULL),(1044,184,'c. A counselor\'s values',NULL),(1045,184,'d. A counselor\'s daily routine',1),(1071,189,'a. Are not worth understanding',NULL),(1072,189,'b. Mean that a counselor must be able to make ethical decisions on the fly.',1),(1073,189,'c. Are unavoidable but largely irrelevant.',NULL),(1074,189,'d. Don\'t exist - there are standard responses to every problem.',NULL),(1075,189,'e. All of the above',NULL),(1076,190,'a. Confidentiality',1),(1077,190,'b. Issuance of a Certificate of Financial Responsibility',NULL),(1078,190,'c. Oral records only',NULL),(1079,190,'d. Current clients only',NULL),(1080,190,'e. All of the above',NULL),(1083,192,'a. Should be encouraged',NULL),(1084,192,'b. Can increase the risk of exploitation or misinterpretation',1),(1085,192,'c. Is rarely a problem',NULL),(1086,192,'d. Can keep the client-counselor relationship more interesting',NULL),(1087,192,'e. All of the above',NULL),(1088,193,'a. Administered by the counselor with minimal client input.',NULL),(1089,193,'b. Not a part of professional ethics.',NULL),(1090,193,'c. Helpful in allowing the client to understand the direction of their treatment.',1),(1091,193,'d. Just about signing paperwork',NULL),(1092,193,'e. All of the above',NULL),(1133,173,'a. Behaviors to prevent weight gain such as self-induced vomiting',NULL),(1134,173,'b. Frequent episodes of consuming very large amounts of food ',1),(1135,173,'c. Intense fear of weight gain',NULL),(1136,173,'d. All of the above',NULL),(1137,174,'a. Restricting food intake',NULL),(1138,174,'b. Frequent episodes of consuming  large amount of food followed by self-induced vomiting',1),(1139,174,'c. Extreme loss of weight',NULL),(1140,174,'d. All of the above',NULL),(1141,201,'Self-Harm is most common in early adolescence',NULL),(1142,201,'Self-Harm is most common in college age students',1),(1143,201,'Self-Harm is most common at the age of 20',NULL),(1144,201,'Self-Harm is most common at the age of 40',NULL),(1145,201,'Self-Harm is most common in early twenties.',NULL),(1146,202,'True    ',1),(1147,202,'False',NULL),(1148,203,'Suicide is highest in college students',NULL),(1149,203,'Suicide is highest in white males over 85',NULL),(1150,203,'Suicide is highest for people aged 10-24',NULL),(1151,203,'Suicide is highest for people aged 25-34',NULL),(1152,203,'Suicide is highest for people aged 45-64',1),(1153,204,'Unrelenting low mood',NULL),(1154,204,'Anxiety, psychic pain, inner tension',NULL),(1155,204,'Sleep problems',NULL),(1156,204,'Threatening suicide or expressing strong wish to die',NULL),(1157,204,'All of the above',1),(1158,205,'Ask directly about suicide, be specific in your inquiry',NULL),(1159,205,'Determine level of suicide risk; low, moderate or high',NULL),(1160,205,'Medications, what they are currently taking, what they have taken in the past and what did or did not work',NULL),(1161,205,'Prior attempts increase possibility of successful suicide',NULL),(1162,205,'All of the above',1),(1163,206,'Yes',1),(1164,206,'No',NULL),(1165,207,'Substance Abuse and Mental Health Disorders',1),(1166,207,'Self-Harm and Substance Abuse',NULL),(1167,207,'Eating Disorder and Mental Health Disorder',NULL),(1168,208,'Victims of Domestic Violence are 5 times more likely to commit suicide.',NULL),(1169,208,'Victims of Domestic Violence are 12 times more likely to commit suicide.',1),(1170,208,'Victims of Domestic Violence are 21 times more likely to commit suicide.',NULL),(1171,209,'10 times',NULL),(1172,209,'17 times',NULL),(1173,209,'42 times',NULL),(1174,209,'23 times',1),(1175,210,'Can’t get out of the depression',NULL),(1176,210,'Can’t think clearly',NULL),(1177,210,'Can’t stop the pain',NULL),(1178,210,'Can’t see themselves as worthwhile',NULL),(1179,210,'All of the above',1),(1180,211,'True',1),(1181,211,'False',NULL),(1182,212,'Cultural Tolerance',NULL),(1183,212,'Cultural Acculturation',NULL),(1184,212,'Cultural Competence',NULL),(1185,212,'Cultural Assimilation',1),(1186,213,'African American',NULL),(1187,213,'American Indian',NULL),(1188,213,'Asian American',NULL),(1189,213,'Caucasian',1),(1190,213,'Hispanic',NULL),(1191,214,'True',NULL),(1192,214,'False',1),(1193,215,'True',1),(1194,215,'False',NULL),(1195,181,'a. Fines under federal law',NULL),(1196,181,'b. Losing your job',NULL),(1197,181,'c. Prison time',NULL),(1198,181,'d. Legal issues',NULL),(1199,181,'e. All of the above',1),(1200,182,'a. Is our moral but not legal obligation',NULL),(1201,182,'b. Is our legal and moral obligation',1),(1202,182,'c. Is neither our legal nor moral obligation',NULL),(1203,182,'d. Is our legal but not moral obligation',NULL),(1204,182,'e. All of the above',NULL),(1205,183,'a. Keep functions separate based on location',NULL),(1206,183,'b. Understand your role as a counselor',NULL),(1207,183,'c. By having an honest conversation with the client about your relationship',NULL),(1208,183,'d. Stay wary of possible confidentiality breaches',NULL),(1209,183,'e. All of the above',1),(1210,185,'a. Basic requiring no knowledge of law and precedent',NULL),(1211,185,'b. Generally easy and apply to every client',NULL),(1212,185,'c. Nuanced making them often very difficult',1),(1213,185,'d. Cut and dried when following the law',NULL),(1214,185,'e. All of the above',NULL),(1220,186,'a. The counselor cannot make up their mind',NULL),(1221,186,'b. Counselors have more than one client',NULL),(1222,186,'c. Counselors have more than one relationship with the client',1),(1223,186,'d. The counselor is empathetic towards a client',NULL),(1224,186,'e. All of the above',NULL),(1225,187,'a. Are set by the client',NULL),(1226,187,'b. Don’t generally apply to counselors',NULL),(1227,187,'c. Were more important in the past',NULL),(1228,187,'d. Are an important part of counseling',1),(1229,187,'e. All of the above',NULL),(1230,188,'a. May require a counselor to sign an agreement to uphold certain standards.',NULL),(1231,188,'b. Are important',NULL),(1232,188,'c. Require counselor training, in most states',NULL),(1233,188,'d. Are generally self-regulated by the industry',NULL),(1234,188,'e. All of the above',1),(1235,191,'True',NULL),(1236,191,'False',1),(1242,200,'a. Clinical, moral, legal',NULL),(1243,200,'b. Legal, moral, ethical',1),(1244,200,'c. Ethical, moral, clinical',NULL),(1245,200,'d. Ethical, legal, clinical',NULL),(1246,200,'e. None of the above',NULL),(1247,199,'a. Areas a professional counselor is interested in working in',NULL),(1248,199,'b. All areas of clinical practice',NULL),(1249,199,'c. Actions that a member of the profession is trained and authorized to perform',1),(1250,199,'d. Clinical practice in areas where the counselor can receive clinical supervision',NULL),(1251,199,'e. None of the above',NULL),(1252,198,'a. Counselor and hair stylist',NULL),(1253,198,'b. Counselor to your best friends brother',NULL),(1254,198,'c. Counselor and supervisor',NULL),(1255,198,'d. Counselor and 12-step sponsor',NULL),(1256,198,'e. All of the above',1),(1257,197,'a. May make clinical mistakes',NULL),(1258,197,'b. May begin to burn out',NULL),(1259,197,'c. May cross professional boundaries',NULL),(1260,197,'d. May exploit the client',NULL),(1261,197,'e. All of the above',1),(1262,196,'a. A counselor sharing their personal feelings with their client',NULL),(1263,196,'b. A counselor experiencing an emotional connection beyond what is acceptable in the client-counselor relationship.',1),(1264,196,'c. A client focusing on their feelings for the counselor',NULL),(1265,196,'d. A counselor having a dual relationship with their client',NULL),(1266,196,'e. A client placing feelings about others from their lies onto the counselor',NULL),(1267,195,'a. A client placing feelings about others from their lives onto the counselor',1),(1268,195,'b. A client focusing on their feelings for the counselor',NULL),(1269,195,'c. A client transferring their feelings with the feelings of the counselor',NULL),(1270,195,'d. A client falling in love with the counselor',NULL),(1271,195,'e. All of the above',NULL),(1272,194,'a. Should never be done',NULL),(1273,194,'b. Should be done with every client',NULL),(1274,194,'c. Should be done when counselor has strong belief client will benefit',1),(1275,194,'d. Should be done when the client asks a personal questions',NULL),(1276,194,'e. All of the above',NULL),(1789,1142,'Making derogatory or sexually explicit comments',NULL),(1790,1142,'Displaying sexually suggestive posters',NULL),(1791,1142,'Making unwanted physical contact',NULL),(1792,1142,'All of the above',1),(1869,1141,'Welcomed, physical in nature, and occur in or impact the workplace',NULL),(1870,1141,'Unwelcome, sexual in nature, and occur in or impact the workplace.',1),(1871,1141,'Unwelcome, sexual in nature and occur in the workplace',NULL),(1872,1141,'Unwelcome, physical in nature and occur in the workplace',NULL),(1873,1143,'Rewards or threats in the areas of hiring/firing, promotion, and performance review',1),(1874,1143,'Behavior that makes the workplace uncomfortable ',NULL),(1875,1143,'Unwelcome suggestive, sexually explicit or obscene letters, notes, emails or invitations.',NULL),(1876,1143,'Sexually explicit offensive comments',NULL),(1877,1144,'Express yourself verbally',NULL),(1878,1144,'Tell the harasser the behavior is making you uncomfortable',NULL),(1879,1144,'Express yourself non verbally',NULL),(1880,1144,'If you are afraid of retaliation say nothing and go straight to HR',NULL),(1881,1144,'All of the above',1),(1882,1145,'Disagrees with employers that discriminate based on sex, gender, race, religion or any other protected class.',NULL),(1883,1145,'Files a discrimination charge',NULL),(1884,1145,'Offers testimony or partakes in an investigation or court proceeding',NULL),(1885,1145,'All of the above',1),(1886,1146,'True',1),(1887,1146,'False',NULL),(1888,1147,'True',1),(1889,1147,'False',NULL),(1890,1148,'True',1),(1891,1148,'False',NULL),(1892,1149,'True',1),(1893,1149,'False',NULL),(1894,1150,'True',1),(1895,1150,'False',NULL),(1896,1151,'True',NULL),(1897,1151,'False',1),(1898,1152,'True',NULL),(1899,1152,'False',1),(1900,1154,'Yes',1),(1901,1154,'No',NULL),(1902,1155,'Yes',NULL),(1903,1155,'No',1),(1904,1156,'Yes',1),(1905,1156,'No',NULL),(11840,591,'FS 387.219 (1)',NULL),(11841,591,'FS 456.222 (4)',NULL),(11842,591,'FS 397.419 (2)',1),(11843,591,'FS 298.419 (1)',NULL),(11844,592,'Organizations',NULL),(11845,592,'Supervisors',NULL),(11846,592,'Risk Managers',NULL),(11847,592,'All Staff',1),(11848,593,'Verification of corrective action',NULL),(11849,593,'Results of Root Cause Analyses',NULL),(11850,593,'Provision for reporting to the Department',NULL),(11851,593,'a and b',NULL),(11852,593,'a and c',1),(11853,702,'As soon as possible and no later than 48 hours',NULL),(11854,702,'As soon as possible and no later than 72 hours',NULL),(11855,702,'As soon as possible and no later than 24 hours',1),(11856,702,'As soon as possible',NULL),(11857,703,'Collaborate for accuracy of events witnessed',NULL),(11858,703,'Both sign the Incident Report Form',NULL),(11859,703,'Each file a separate Incident Report Form',1),(11860,703,'Jointly prepare one Incident Report Form',NULL),(11861,704,'True',NULL),(11862,704,'False',1),(11863,705,'Complete one Incident Report listing all clients involved in the incident',NULL),(11864,705,'Complete a separate Incident Report for each client involved',1),(11865,705,'Have client’s Primary Therapist complete an incident report',NULL),(11866,705,'None of the above',NULL),(11867,706,'Any area of the Incident Report Form not requiring a response specific to the incident must be marked as “N/A” (Not applicable).',NULL),(11868,706,'A copy of the IRF is always included in the client’s medical records on file. ',1),(11869,706,'All staff members of a service provider are required to document all unusual events that occur to either a patient and/or staff member on an Incident Report Form ',NULL),(11870,706,'Incident Report Forms are confidential reports ',NULL),(11871,707,'Enter concise subjective statements of fact',NULL),(11872,707,'Express their own opinion of the occurrence',NULL),(11873,707,'Enter concise objective statements of fact',1),(11874,707,'a and b',NULL),(11875,708,'Promptly report a critical incidence within 6 hours',NULL),(11876,708,'Promptly report a critical incident within 24 hours',NULL),(11877,708,'Promptly report a critical incident within one business day',1),(11878,708,'None of the above',NULL),(11879,709,'The Critical Incident Reporting System (CIRS)',NULL),(11880,709,'The Critical Incident Analyses System (CIAS)',NULL),(11881,709,'The Incident Analysis and Reporting System (IRAS)',NULL),(11882,709,'The Incident Reporting and Analysis System (IRAS)',1),(11883,710,'All Substance Abuse Providers licensed by the DCF',NULL),(11884,710,'Managing Entities',NULL),(11885,710,'State  mental health treatment facilities  ',NULL),(11886,710,'A and B',1),(11887,710,'A and C',NULL),(11888,711,'True',1),(11889,711,'False',NULL),(11890,712,'1994',NULL),(11891,712,'1998',NULL),(11892,712,'1996',1),(11893,712,'1997',NULL),(11894,713,'True',NULL),(11895,713,'False',1),(11896,137,'FS 387.219 (1)',NULL),(11897,137,'FS 456.222 (4)',NULL),(11898,137,'FS 397.419 (2)',1),(11899,137,'FS 298.419 (1)',NULL),(11900,138,'Organizations',NULL),(11901,138,'FS 456.222 (4)',NULL),(11902,138,'Supervisors',NULL),(11903,138,'Risk Managers',NULL),(11904,138,'All Staff',1),(11905,139,'Verification of corrective action',NULL),(11906,139,'Results of Root Cause Analyses',NULL),(11907,139,'Provision for reporting to the Department',NULL),(11908,139,'a and b',NULL),(11909,139,'a and c',1),(11910,140,'True',NULL),(11911,140,'False',1),(11916,141,'Any area of the Incident Report Form not requiring a response specific to the incident must be marked as “N/A” (Not applicable).',NULL),(11917,141,'Incident Report Forms are always included in the client’s medical records on file. ',1),(11918,141,'All staff members of a service provider are required to document all unusual events that occur to either a patient and/or staff member on an Incident Report Form ',NULL),(11919,141,'Incident Report Forms are confidential reports ',NULL),(11920,142,'Promptly report a critical incidence within 6 hours',NULL),(11921,142,'Promptly report a critical incident within 24 hours',NULL),(11922,142,'Promptly report a critical incident within one business day',1),(11923,142,'None of the above',NULL),(11924,143,'The Critical Incident Reporting System (CIRS)',NULL),(11925,143,'The Critical Incident Analyses System (CIAS)',NULL),(11926,143,'The Incident Analysis and Reporting System (IRAS)',NULL),(11927,143,'The Incident Reporting and Analysis System (IRAS). ',1),(11928,144,'True',NULL),(11929,144,'False',1),(11930,145,'Promptly report a critical incidence within 6 hours',NULL),(11931,145,'Promptly report a critical incident within 24 hours',NULL),(11932,145,'Promptly report a critical incident within one business day',1),(11933,145,'None of the above',NULL),(11934,1131,'To report it to your supervisor',NULL),(11935,1131,'To report it only if you believe it is an emergency',NULL),(11936,1131,'To report it to the Florida Abuse Hotline of Children and Families',1),(11937,1131,'You are only required to report it to the person’s insurance company',NULL),(11938,1132,'Abandonment',NULL),(11939,1132,'Abuse',NULL),(11940,1132,'Exploitation',NULL),(11941,1132,'Neglect',1),(11942,1133,'Law enforcement officer',NULL),(11943,1133,'Nurse in an assisted living facility',NULL),(11944,1133,'School teacher',NULL),(11945,1133,'All of the above',1),(11946,1134,'They are ashamed ',NULL),(11947,1134,'They feel no one will believe them',NULL),(11948,1134,'They are afraid someone may retaliate if they report them',NULL),(11949,1134,'All of the above',1),(11950,1135,'True',1),(11951,1135,'False',NULL),(11952,1136,'True',NULL),(11953,1136,'False',1),(11954,1137,'Unauthorized taking of personal assets',NULL),(11955,1137,'Sale of the vulnerable adults home without their authorization',NULL),(11956,1137,'Caregiver failing to provide appropriate food to vulnerable adult',NULL),(11957,1137,'A and B',1),(11958,1137,'B and C',NULL),(11959,1138,'Exploitation',NULL),(11960,1138,'Abuse',1),(11961,1138,'Neglect',NULL),(11962,1138,'All of the above',NULL),(11963,1139,'Section 415.1034',NULL),(11964,1139,'Chapter 40, F.S.',NULL),(11965,1139,'Chapter 39, F.S.',1),(11966,1139,'Section 48 F.S.',NULL),(11967,1140,'800-222-2873',NULL),(11968,1140,'800-962-2873',1),(11969,1140,'800-914-0004',NULL),(11970,1140,'800-453-5145',NULL),(12060,1157,'True',NULL),(12061,1157,'False',1),(12062,1158,'Where clinical professionals, in this case in the addiction industry, have multiple relationship roles with their clients',1),(12063,1158,'An unaviodable part of doing business in the addiction treatment industry',NULL),(12064,1158,'A multiple role relationship that is generally suitable for the therapist-client relationship',NULL),(12065,1158,'All of the above',NULL),(12066,1159,'To punish addiction treatment centers that misuse personal information',NULL),(12067,1159,'To define the the proper use of an individual\'s health records',1),(12068,1159,'To secure a person\'s private financial information',NULL),(12069,1159,'To give authorization for treatment center employees to use private information',NULL),(12070,1160,'Health Information Portability Protection Act',NULL),(12071,1160,'Human Interest Protection  Act',NULL),(12072,1160,'Health Insurance Portability and Accountability Act',1),(12073,1160,'None of the above',NULL),(12074,1161,'True',NULL),(12075,1161,'False',1),(12076,1162,'A fraudulent accounting scheme',NULL),(12077,1162,'The legal definition of self-inflicted bodily harm',NULL),(12078,1162,'The requirement for an arrested person to be brought into court or before a judge',1),(12079,1162,'None of the above',NULL),(12080,1163,'The clinician is the professional',1),(12081,1163,'Proper boundaries cannot be defined therefore this is a moot point',NULL),(12082,1163,'The clients understand proper boundaries and are able to defend themselves against violations',NULL),(12083,1163,'The counselor must report to their supervisor',NULL),(12084,1164,'True',1),(12085,1164,'False',NULL),(12086,1165,'Quid Pro Quo',NULL),(12087,1165,'Dual Relationship',1),(12088,1165,'Professional Business',NULL),(12089,1165,'None of the Above',NULL),(12090,1166,'When parents ask',NULL),(12091,1166,'Client information can never be disclosed without written consent',NULL),(12092,1166,'On a need to know basis within the facility',1),(12093,1166,'None of the Above',NULL),(12094,1167,'Crossed Legs',NULL),(12095,1167,'Slouching',NULL),(12096,1167,'Eye contact',NULL),(12097,1167,'Standing Tall',1),(12098,1168,'True',NULL),(12099,1168,'False',1),(12100,1169,'A long marriage',NULL),(12101,1169,'Stress',1),(12102,1169,'A high degree of social interaction',NULL),(12103,1169,'Regular exercise ',NULL),(12104,1170,'Perception and prejudice',NULL),(12105,1170,'Noise',NULL),(12106,1170,'Language',NULL),(12107,1170,'All of the above',1),(12108,1171,'Common depression',NULL),(12109,1171,'Bipolar disorder doesn\'t fall under the DSMIV-TR purview',NULL),(12110,1171,'Significant mood changes that last for weeks or months',1),(12111,1171,'Mood changes that last for 48 hours or less',NULL),(12112,1172,'True',NULL),(12113,1172,'False',1),(12114,1173,'Use',NULL),(12115,1173,'Misuse',NULL),(12116,1173,'Addiction',NULL),(12117,1173,'Abuse',1),(12118,1174,'A good idea to use as proof',NULL),(12119,1174,'A bad idea unless needed for an important purpose.',1),(12120,1174,'Not a problem if the copies are lost',NULL),(12121,1174,'Something that should never be done',NULL),(12122,1175,'It helps determine the exposure risk of staff members',1),(12123,1175,'It eliminates the possibility of infection',NULL),(12124,1175,'A and B',NULL),(12125,1175,'None of the above',NULL),(12126,1176,'Common cold',NULL),(12127,1176,'HIV',NULL),(12128,1176,'Pinkeye',NULL),(12129,1176,'A & C',1),(12130,1176,'A & B',NULL),(12131,1177,'A hospital',NULL),(12132,1177,'A detox',NULL),(12133,1177,'An ARF',NULL),(12134,1177,'All of the above',1),(12137,1178,'True',NULL),(12138,1178,'False',1),(12139,1179,'True',NULL),(12140,1179,'False',1),(12141,1180,'True',NULL),(12142,1180,'False',1),(12145,1181,'True',1),(12146,1181,'False',NULL),(12147,1182,'True',NULL),(12148,1182,'False',1);

--
-- Table structure for table `question`
--

CREATE TABLE `question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `course_id` int(11) NOT NULL,
  `correct_answer_id` int(11) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `course_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1183 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `question`
--

INSERT INTO `question` VALUES (6,'According to CDC estimates, what proportion of people in the United States who are infected with HIV are unaware of their infection?',1,5,NULL,NULL),(7,'Americans have become complacent about HIV/AIDS because:',1,8,NULL,NULL),(8,'The 2010 National AIDS Strategy has three overarching goals, one of which is:',1,12,NULL,NULL),(9,'The Florida population hardest hit by HIV/AIDS is:',1,18,NULL,NULL),(10,'Which risk groups account for 75 percent of new HIV/AIDS infections?',1,22,NULL,NULL),(11,'Higher than average rates of AIDS and other STDs among correctional populations could be reduced by following the World Health Organization recommendation to:',1,24,NULL,NULL),(12,'Florida state law requires HIV testing of inmates:',1,28,NULL,NULL),(13,'Health professionals may fail to recognize the signs of HIV/AIDS infection in seniors because:',1,32,NULL,NULL),(14,'Which body fluids have been proven to transmit HIV infection?',1,36,NULL,NULL),(15,'Which of the following would most likely transmit an HIV infection?',1,40,NULL,NULL),(16,'Coinfection with STDs such as syphilis, gonorrhea, and genital warts:',1,44,NULL,NULL),(17,'The most common and most deadly coinfection for HIV-positive individuals is:',1,48,NULL,NULL),(18,'Treatment of HIV/TB coinfected patients is:',1,52,NULL,NULL),(19,'Respiratory protection equipment for healthcare workers is:',1,56,NULL,NULL),(20,'One of the leading causes of death among HIV-infected people is:',1,60,NULL,NULL),(26,'More than 1 million people in the U.S. are living with HIV. ',3,463,NULL,NULL),(27,'AIDS and HIV are the same',3,465,NULL,NULL),(28,'You can’t always tell by appearance if someone has HIV. ',3,467,NULL,NULL),(29,'Medications can cure HIV/AIDS.',3,469,NULL,NULL),(30,'All 50 states have people living with AIDS.',3,471,NULL,NULL),(31,'HIV is transmitted through casual contact such as sharing utensils. ',3,474,NULL,NULL),(32,'Abstinence is the only 100% effective method of not acquiring HIV/AIDS               ',3,475,NULL,NULL),(33,'Health care workers should assume that the blood and other body fluids               from all patients are potentially infectious.    \r\n               ',3,477,NULL,NULL),(34,'The results of HIV antibody tests are confidential and may not be publicly disclosed except with the resident’s written permission or as otherwise provided in Chapter 384, Florida Statues.\r\n',3,479,NULL,NULL),(35,'Way to protect yourself from HIV/AIDS include: \r\n',3,485,NULL,NULL),(36,'According to CDC estimates, what proportions of people in the United States who are infected with HIV are unaware of their infection?\r\n',3,487,NULL,NULL),(37,'The Florida population hardest hit by HIV/AIDS is:',3,490,NULL,NULL),(38,'Which risk groups account for 75 percent of new HIV/AIDS infections?',3,500,NULL,NULL),(39,'Which body fluids have been proven to transmit HIV infection?',3,508,NULL,NULL),(40,'Which of the following would most likely transmit an HIV infection?',3,511,NULL,NULL),(41,'Under Florida law, parents of a child under 18:',3,515,NULL,NULL),(42,'Florida law mandates that all pregnant women:',3,533,NULL,NULL),(47,'A provider may test without consent in which of the following:',3,521,NULL,NULL),(48,'Symptoms of AIDS Dementia Complex (ADC) include:',3,526,NULL,NULL),(49,'Need to know is outlined in section 64D-.003 F.A.C. and includes but is not limited to:',3,532,NULL,NULL),(53,'Staring a client down is a sign of being in charge and can help calm an aggressive person.',4,296,NULL,NULL),(54,'The amount of space required to allow someone to feel comfortable can depend on gender, mood, familiarity, or culture. ',4,449,NULL,NULL),(55,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation.',4,300,NULL,NULL),(57,'To paraphrase means?',4,452,NULL,NULL),(58,'Active listening involves:',4,414,NULL,NULL),(59,'How should staff act when faced with an aggressive person?',4,419,NULL,NULL),(60,'Assertive Communication is based on balance and mutual respect.',4,325,NULL,NULL),(61,'What can you do when you detect a language barrier between you and a client?',4,425,NULL,NULL),(62,'Power struggles are an example of a communication barrier.',4,327,NULL,NULL),(63,'What 4 stages of crisis management were discussed and listed in the correct occurrence?',4,331,NULL,NULL),(64,'You should avoid power struggles by offering a person choices.',4,333,NULL,NULL),(65,'During which stage of crisis management would the client challenge you, push buttons and not respond to your words?',4,458,NULL,NULL),(67,'The transmission of infectious agents requires?',5,540,NULL,NULL),(68,'What is true about infection prevention and control?',5,544,NULL,NULL),(69,'Which statement is NOT true about Droplet transmission?',5,546,NULL,NULL),(70,'Which of the following is NOT an example of a Bloodborne Pathogen?',5,551,NULL,NULL),(71,'When does Vector-borne transmission occur?',5,553,NULL,NULL),(72,'To protect yourself from airborne diseases, you should?',5,557,NULL,NULL),(73,' Bloodborne pathogens can be spread through',5,565,NULL,NULL),(74,'What is considered Personal Protective Equipment?',5,569,NULL,NULL),(75,'When cleaning a spill:',5,575,NULL,NULL),(78,'How long should you wash your hands for with soap and water?',5,582,NULL,NULL),(79,'Infectious diseases are caused by',5,588,NULL,NULL),(80,'Infectious diseases are transmitted most quickly through:',5,592,NULL,NULL),(81,'What is the body fluid NOT considered infectious?',5,576,NULL,NULL),(82,'Which of the following are signs of aggression?',4,343,NULL,NULL),(83,'What is/are possible risk factors to aggression?',4,347,NULL,NULL),(85,'Verbal de-escalation is the communication skills we use during a potentially dangerous, or threatening, situation in an attempt to prevent a person from causing harm to us, themselves or others. ',4,459,NULL,NULL),(88,'The most frequent mode of infection transmission in the healthcare setting is',5,596,NULL,NULL),(89,'Precautions recommended by CDC for the care of all patients is known as:',5,600,NULL,NULL),(90,'A counselor and client can enter into a personal relationship after five years has elapsed.',6,603,NULL,NULL),(91,'What is a “Dual Relationship”?',6,604,NULL,NULL),(92,'Explain the purpose of HIPAA guidelines.',6,610,NULL,NULL),(93,'What does the acronym HIPAA stand for?',6,613,NULL,NULL),(94,'Counselors who are physically attracted to clients are only trying to fulfill an unmet need in their personal life.',6,617,NULL,NULL),(95,'What is the Right of Habeas Corpus?',6,619,NULL,NULL),(96,'Give two reason why maintaining proper boundaries is the responsibility of the staff.',6,626,NULL,NULL),(97,'Anger is a choice in a range of available behaviors',6,628,NULL,NULL),(98,'Your client owns a mechanic shop and offers to repair your car for free out of appreciation for your help.  This is an example of what type of relationship?',6,632,NULL,NULL),(99,'Give two instances when client confidential information can be disclosed without their consent.',6,639,NULL,NULL),(100,'Name 2 signs of Aggression',6,644,NULL,NULL),(101,'Staring a client down is a sign of being in charge and can help to calm an aggressive person',6,647,NULL,NULL),(102,'Name 2 Risk Factors to Aggression',6,648,NULL,NULL),(103,'Which of the following can inhibit communication?',6,655,NULL,NULL),(104,'How does DSMIV-TR characterize bipolar disorder?',6,659,NULL,NULL),(105,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation',6,661,NULL,NULL),(106,'Stage 3 of susbtance dependence is',6,663,NULL,NULL),(107,'Copying confidential information is:',6,668,NULL,NULL),(108,'Behavioral Healthcare facilities are able, by law to bill insurance companies without actual written consent from client',6,671,NULL,NULL),(109,'With written permission behavioral healthcare facilities can share information with parents and spouses',6,682,NULL,NULL),(110,'After a client has been discharged from treatment for five years it is no longer necessary to have written permission to discuss information',6,675,NULL,NULL),(111,'Oral information is not protected by HIPAA guidelines',6,677,NULL,NULL),(112,'There is a fine for healthcare facilities that violate HIPAA guidelines',6,678,NULL,NULL),(113,'It is permissible to discuss specifics of cases in 12 step meetings because the meetings are confidential',6,681,NULL,NULL),(114,'Why is infection control important?',6,685,NULL,NULL),(115,'What illnesses are spread through contact? ',6,688,NULL,NULL),(116,'What does HIPAA stand for?',7,694,NULL,NULL),(117,'The __________ Act widens the scope of privacy and security protections under HIPAA for electronic protected health information (ePHI).',7,697,NULL,NULL),(118,'What is an example/examples of PHI (Protected Health Information?',7,703,NULL,NULL),(119,'It is ok to discuss a patient with my spouse of he/she won’t tell anyone.',7,706,NULL,NULL),(120,'What can happen to a person who knowingly violates patient privacy for personal gain or malicious harm?',7,711,NULL,NULL),(121,'If someone forgets his log-in ID, can I let him use mine?',7,714,NULL,NULL),(122,'What does \"minimum necessary\" mean?',7,720,NULL,NULL),(124,'Are members of your organization who are not involved in a patient\'s care allowed to review the patient\'s chart out of curiosity?',7,726,NULL,NULL),(125,'Are Consents and Authorizations the same?',7,745,NULL,NULL),(126,'Is text messaging is a secure way to transmit patient information within your facility.',7,735,NULL,NULL),(127,'Who must comply with the ADA?',8,750,NULL,NULL),(128,'According to the ADA, a person with a disability has:',8,753,NULL,NULL),(129,'What is a condition not covered by the ADA?',8,759,NULL,NULL),(130,'Under the ADA, an employer is required to make a reasonable accommodation to the known disability of a qualified applicant or employee if it does not impose “undue hardship”?',8,768,NULL,NULL),(131,'What is an example of a “reasonable accommodation”?',8,767,NULL,NULL),(132,'Under Title V, ADA prohibits coercion and retaliation to anyone who has assisted, encouraged or made a charge under the Act.',8,770,NULL,NULL),(133,'The ADA requires that organizations hire the disabled.',8,773,NULL,NULL),(134,'If an employer believes that a medical condition is causing a performance or conduct problem, it may ask the employee how to solve the problem.',8,774,NULL,NULL),(135,'According to the ADA, all people with disabilities (or even all people with the same disability) will require the same accommodation.',8,777,NULL,NULL),(136,'According to the ADA, “major life activities” include',8,782,NULL,NULL),(137,'The Florida Statute (FS) requiring a licensed public or private substance abuse service provider to create an internal quality improvement program is:',9,11898,NULL,NULL),(138,'Incident Reporting is the affirmative duty of',9,11904,NULL,NULL),(139,'According to Chapter 65D-30 of the Florida Administrative Code, Incident Reporting must include:',9,11909,NULL,NULL),(140,'If a staff member is uncertain as to whether an event should be documented and reported, an Incident Report Form should NOT be completed.',9,11911,NULL,NULL),(141,'Which of the following statements is NOT true of Incident Reporting ',9,11917,NULL,NULL),(142,'When entering narrative documentation on an Incident Report Form staff MUST ',9,11922,NULL,NULL),(143,'DCF has created an online reporting system called:',9,11927,NULL,NULL),(144,'The DCF incident reporting procedures replace exploitation reporting protocols, as required by law. ',9,11929,NULL,NULL),(145,'In accordance with The Children and Families Operating Procedure 215-6 Department licensed providers MUST',9,11932,NULL,NULL),(146,'Domestic Violence is best conceptualized as:',11,831,NULL,NULL),(147,'The four main types of Domestic Violence are:',11,961,NULL,NULL),(148,'Risk factors for Domestic Violence victimization include all the following EXCEPT:',11,964,NULL,NULL),(149,'What combination contributes to the risk of becoming a victim or a perpetrator of Domestic Violence?',11,920,NULL,NULL),(150,'Children from violent homes may demonstrate:',11,849,NULL,NULL),(151,'Patterns of controlling behavior can include:',11,854,NULL,NULL),(152,'Signs of a potential abuser in a dating relationship include all of the following EXCEPT',11,857,NULL,NULL),(153,'Which of the following are characteristics of a potential abuser:',11,859,NULL,NULL),(154,'To gain power and control an abuser may:',11,870,NULL,NULL),(155,'Tension building and making up are:',11,873,NULL,NULL),(156,'In dealing with Domestic Violence the most important phone numbers are:',11,950,NULL,NULL),(157,'The rate of Domestic Violence detection among behavioral health practitioners and healthcare workers is:',11,967,NULL,NULL),(158,'Missed cases of Domestic Violence may be due to all of the following EXCEPT:',11,928,NULL,NULL),(159,'Healthcare workers can help in detecting Domestic Violence by:',11,931,NULL,NULL),(160,'Mental health staff can become effective advocates by:',11,892,NULL,NULL),(161,'Advocating for Domestic Violence victims includes all of the following EXCEPT:',11,940,NULL,NULL),(162,'In Florida, the Domestic Violence Hotline Number is:',11,956,NULL,NULL),(163,'Safety plans cover: ',11,906,NULL,NULL),(164,'Florida state reporting laws require:',11,907,NULL,NULL),(165,'If a patient does not disclose Domestic Violence to a behavioral healthcare worker, the worker should document:',11,945,NULL,NULL),(166,'What does co-occurring disorder mean?',12,971,NULL,NULL),(167,'What mental conditions are more likely to abuse substances?',12,984,NULL,NULL),(168,'Which of the following statements are False?',12,981,NULL,NULL),(169,'What describes the term Denial?',12,990,NULL,NULL),(170,'What are signs and symptoms of anxiety disorders?',12,994,NULL,NULL),(171,'SAMSHA recommends the following treatment model for co-occurring disorders:',12,997,NULL,NULL),(172,'Mental disorders are caused by:',12,1000,NULL,NULL),(173,'A common sign of binge eating disorder is:',12,1134,NULL,NULL),(174,'A common sign of bulimia nervosa is',12,1138,NULL,NULL),(175,'Hand-washing until your skin becomes raw is a sign of which of the following disorders:',12,1013,NULL,NULL),(176,'Hyperactivity is a symptom of which of the following disorders:',12,1017,NULL,NULL),(177,'Some people develop mental health issues after excessive drinking or drug use.',12,1019,NULL,NULL),(178,'A mental disorder can complicate the challenge in overcoming an addiction to drugs or alcohol.',12,1021,NULL,NULL),(179,'About 50% of people with severe mental disorders are affected by substance abuse.',12,1023,NULL,NULL),(180,'People with a mental health illness are more likely to experience an alcohol or substance use disorder than those not affected by a mental illness.',12,1025,NULL,NULL),(181,'The ramifications of allowing/causing a breach in confidentiality can include:',13,1199,NULL,NULL),(182,'Adhering to confidentiality',13,1201,NULL,NULL),(183,'Some dual roles are unavoidable. How do you deal with them?',13,1209,NULL,NULL),(184,'Which of the following is not generally a basis of decision making?',13,1045,NULL,NULL),(185,'Ethical decisions in treatment are:',13,1212,NULL,NULL),(186,'Dual relationships occur when',13,1222,NULL,NULL),(187,'Boundaries',13,1228,NULL,NULL),(188,'Professional Ethics:',13,1234,NULL,NULL),(189,'Ethical Nuances',13,1072,NULL,NULL),(190,'42 CFR applies to:',13,1076,NULL,NULL),(191,'Both HIPAA and 42 CFR are concerned with client confidentiality as it relates to substance use disorder. ',13,1236,NULL,NULL),(192,'Blurring boundaries',13,1084,NULL,NULL),(193,'Informed consent is:',13,1090,NULL,NULL),(194,'Counselor self-disclosure:',13,1274,NULL,NULL),(195,'Transference is:',13,1267,NULL,NULL),(196,'Counter-transference is:',13,1263,NULL,NULL),(197,'When a counselor is not aware of transference & counter-transference issues, the counselor:',13,1261,NULL,NULL),(198,'Which of the following are examples of dual relationships?',13,1256,NULL,NULL),(199,'Scope of Practice is defined as:',13,1249,NULL,NULL),(200,'Ethical considerations can typically be viewed from which of the following three different perspectives?',13,1243,NULL,NULL),(201,'What are the usual Demographics of Self-Harm?',14,1142,NULL,NULL),(202,'The suicide rate is higher than the rate of homicide',14,1146,NULL,NULL),(203,'What is the age group with highest suicide risk?',14,1152,NULL,NULL),(204,'What are observable signs of serious depression that are correlated to Suicidality? ',14,1157,NULL,NULL),(205,'What are the components of a good Suicide Assessment?',14,1162,NULL,NULL),(206,'Do behavioral addictions increase a person’s risk of suicide?',14,1163,NULL,NULL),(207,'What are the two most prevalent risk factors associated with suicide?',14,1165,NULL,NULL),(208,'How much more likely to commit suicide are victims of domestic abuse?',14,1169,NULL,NULL),(209,'How much higher is the rate of Suicide with Eating Disorder clients’?',14,1174,NULL,NULL),(210,'What are some crisis elements that increase suicidality?',14,1179,NULL,NULL),(211,'Both race and ethnicity represent cultures',15,1180,NULL,NULL),(212,'The process that represents the absorption of many different cultures into a given area',15,1185,NULL,NULL),(213,'Which of the following is not a racial and ethnic minority group',15,1189,NULL,NULL),(214,'Eye contact has a similar meaning among most cultures',15,1192,NULL,NULL),(215,'Spirituality is part of every ethnic group',15,1193,NULL,NULL),(591,'The Florida Statute (FS) requiring a licensed public or private substance abuse service provider to create an internal quality improvement program is:	',25,11842,NULL,NULL),(592,'Incident Reporting is the affirmative duty of',25,11847,NULL,NULL),(593,'According to Chapter 65D-30 of the Florida Administrative Code, Incident Reporting must include:',25,11852,NULL,NULL),(702,'The staff member most immediately involved in and/or observing an unusual incident is required to complete an Incident Report Form.  ',25,11855,NULL,NULL),(703,'If two staff members are involved in or witness an unusual event the staff members are required to',25,11859,NULL,NULL),(704,'If a staff member is uncertain as to whether an event should be documented and reported, an Incident Report Form should NOT be completed.',25,11862,NULL,NULL),(705,'If more than one client is involved in an unusual event staff must ',25,11864,NULL,NULL),(706,'Which of the following statements is NOT true of Incident Reporting ',25,11868,NULL,NULL),(707,'When entering narrative documentation on an Incident Report Form staff MUST ',25,11873,NULL,NULL),(708,'In accordance with The Children and Families Operating Procedure 215-6 Department licensed providers MUST',25,11877,NULL,NULL),(709,'DCF has created an online reporting system called:',25,11882,NULL,NULL),(710,'Providers who must report critical incidents through IRAS include:',25,11886,NULL,NULL),(711,'The entry of the critical incident into IRAS DOES NOT substitute for a direct phone call to the Department’s leadership staff when the incident type or severity of the incident warrants such contact.',25,11888,NULL,NULL),(712,'The Joint Commission adopted a formal Sentinel Event Policy to assist healthcare providers ',25,11892,NULL,NULL),(713,'It is mandatory for all substance abuse providers  have to report sentinel events to The Joint Commission',25,11895,NULL,NULL),(1131,'If you reasonably suspect child abuse you are required:',9,11936,NULL,NULL),(1132,'If a child is deprived of clothing, shelter, or medical services it is called:',9,11941,NULL,NULL),(1133,'Who is considered a professional mandatory reporter?',9,11945,NULL,NULL),(1134,'What is the reason that victims may not report their abusers?',9,11949,NULL,NULL),(1135,'A False Report is a report of abuse, neglect, or abandonment of a child to the central abuse hotline, in which the report is made maliciously.',9,11950,NULL,NULL),(1136,'A person who is required to report, and who knowingly and willfully fails to do so, or who knowingly and willfully prevents another person from doing so, is guilty of a misdemeanor of the first degree.',9,11953,NULL,NULL),(1137,'What is consider exploitation of a vulnerable adult?',9,11957,NULL,NULL),(1138,'Any willful act or threatened act by a relative, caregiver, or household member which causes or is likely to cause significant impairment to a vulnerable adult’s physical, mental, or emotional health is called',9,11960,NULL,NULL),(1139,'Providers shall adhere to the statutory requirements for reporting abuse, neglect, and deaths of children under:',9,11965,NULL,NULL),(1140,'The Abuse Hotline Phone Number is:',9,11968,NULL,NULL),(1141,'According to EEOC in order for behavior to be considered sexual harassment it must be ',10,1870,NULL,NULL),(1142,'A co-worker or supervisor can create a hostile work environment when they engage in one or more of the following behaviors:',10,792,NULL,NULL),(1143,'The Quid Pro Quo theory of sexual harassment involves:',10,1873,NULL,NULL),(1144,'IF you feel you are the victim of unwelcome sexual behavior you are encouraged to:',10,1881,NULL,NULL),(1145,'It is illegal for an employer or other employees to retaliate against any individual who:',10,1885,NULL,NULL),(1146,'Sexual Harassment in employment is legally recognized as a form of sex discrimination and is illegal.',10,1886,NULL,NULL),(1147,'Sexual harassment can occur outside the work site and still be considered work related.',10,1888,NULL,NULL),(1148,'Quid Pro Quo harassment is a form of sexual harassment when there is a request or demand of sexual favors in exchange for employment benefits or threatening reprisals if the favors are not given.',10,1890,NULL,NULL),(1149,'Friendly flirting is not sexual harassment when flirting is practiced between mutually consenting individuals who are equal in power or authority.',10,1892,NULL,NULL),(1150,'An employee witnesses another employee being harassed. Even though this involved a co-worker, the witness can be considered a victim in this case.',10,1894,NULL,NULL),(1151,'In order for it to be determined sexual harassment, the victim has to be of the opposite sex of the harasser.',10,1897,NULL,NULL),(1152,'It is solely the company’s responsibility to prevent sexual harassment',10,1899,NULL,NULL),(1154,'Adella wants Antonio to feel part of the team and tries to encourage his participation. She approaches him more frequently than the other workers and she is constantly touching his shoulder and arm. Antonio feels uncomfortable with Adella invading his personal space and grimaces as she touches his shoulders. His facial and body expressions clearly indicate his annoyance. Could this be considered sexual harassment?”',10,1900,NULL,NULL),(1155,'Karen Linda and Elis have become good friends and sit together at lunch. They decided to have some fun by rating the men in the lunchroom. Joking, they rate the men who walk into the lunchroom and discuss the ratings with each other. Ted, a male therapist, who is sitting at a nearby table overhears their remarks. He finds the behavior offensive and unprofessional. Ted reports the incident to HR when he returns from lunch. Was the women’s behavior sexual harassment?',10,1903,NULL,NULL),(1156,'Susan, the director of marketing, has several employees reporting to her. One of the employees, John, has been called into her office right before lunch. Susan requests that John have lunch with her to discuss one of the major accounts that he is trying to acquire. John agrees to the lunch and realizes that this is a good opportunity to explain some of the problems he has encountered. While John and Susan are out at lunch she puts her hand on his leg and says she wants him to do well in the company and would like him to come over to her place tonight. Is this considered sexual harassment?',10,1904,NULL,NULL),(1157,'A counselor and client can enter into a personal relationship after five years has elapsed.',26,12061,NULL,NULL),(1158,'What is a “Dual Relationship”?',26,12062,NULL,NULL),(1159,'Explain the purpose of HIPAA guidelines.',26,12067,NULL,NULL),(1160,'What does the acronym HIPAA stand for?',26,12072,NULL,NULL),(1161,'Counselors who are physically attracted to clients are only trying to fulfill an unmet need in their personal life.',26,12075,NULL,NULL),(1162,'What is the Right of Habeas Corpus?',26,12078,NULL,NULL),(1163,'Give a reason why maintaining proper boundaries is the responsibility of the staff.',26,12080,NULL,NULL),(1164,'Anger is a choice in a range of available behaviors',26,12084,NULL,NULL),(1165,'Your client owns a mechanic shop and offers to repair your car for free out of appreciation for your help.  This is an example of what type of relationship?',26,12087,NULL,NULL),(1166,'Give an instance when client confidential information can be disclosed without their consent.',26,12092,NULL,NULL),(1167,'Name a sign of Aggression',26,12097,NULL,NULL),(1168,'Staring a client down is a sign of being in charge and can help to calm an aggressive person',26,12099,NULL,NULL),(1169,'Name a Risk Factor to Aggression',26,12101,NULL,NULL),(1170,'Which of the following can inhibit communication?',26,12107,NULL,NULL),(1171,'How does DSMIV-TR characterize bipolar disorder?',26,12110,NULL,NULL),(1172,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation',26,12113,NULL,NULL),(1173,'Stage 3 of susbtance dependence is',26,12117,NULL,NULL),(1174,'Copying confidential information is:',26,12119,NULL,NULL),(1175,'Why is infection control important?',26,12122,NULL,NULL),(1176,'What illnesses are spread through contact? ',26,12129,NULL,NULL),(1177,'Under the Marchman Act people can be taken into protective custody without consent to:',26,12134,NULL,NULL),(1178,'Without written permission behavioral healthcare facilities can only share information with parents and spouses',26,12138,NULL,NULL),(1179,'After a client has been discharged from treatment for five years it is no longer necessary to have written permission to discuss information',26,12140,NULL,NULL),(1180,'Oral information is not protected by HIPAA guidelines',26,12142,NULL,NULL),(1181,'There is a fine for healthcare facilities that violate HIPAA guidelines',26,12145,NULL,NULL),(1182,'It is permissible to discuss specifics of cases in 12 step meetings because the meetings are confidential',26,12148,NULL,NULL);

--
-- Table structure for table `response`
--

CREATE TABLE `response` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `question_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `response` varchar(60) NOT NULL,
  `attempt` int(11) NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`,`question_id`,`course_id`),
  KEY `question_id` (`question_id`),
  KEY `test_id` (`course_id`),
  KEY `response` (`response`),
  CONSTRAINT `response_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `response_ibfk_4` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=20214 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `response`
--

INSERT INTO `response` VALUES (492,10,116,7,'694',1,1),(493,10,117,7,'697',1,1),(494,10,118,7,'703',1,1),(495,10,119,7,'706',1,1),(496,10,120,7,'711',1,1),(497,10,121,7,'714',1,1),(498,10,122,7,'720',1,1),(499,10,124,7,'726',1,1),(500,10,125,7,'745',1,1),(501,10,126,7,'735',1,1),(502,10,116,7,'694',2,1),(503,10,117,7,'697',2,1),(504,10,118,7,'703',2,1),(505,10,119,7,'706',2,1),(506,10,120,7,'711',2,1),(507,10,121,7,'714',2,1),(508,10,122,7,'720',2,1),(509,10,124,7,'726',2,1),(510,10,125,7,'745',2,1),(511,10,126,7,'735',2,1),(512,10,116,7,'694',3,1),(513,10,117,7,'697',3,1),(514,10,118,7,'703',3,1),(515,10,119,7,'706',3,1),(516,10,120,7,'711',3,1),(517,10,121,7,'714',3,1),(518,10,122,7,'720',3,1),(519,10,124,7,'726',3,1),(520,10,125,7,'745',3,1),(521,10,126,7,'735',3,1),(522,10,116,7,'694',4,1),(523,10,117,7,'697',4,1),(524,10,118,7,'703',4,1),(525,10,119,7,'706',4,1),(526,10,120,7,'711',4,1),(527,10,121,7,'714',4,1),(528,10,122,7,'720',4,1),(529,10,124,7,'726',4,1),(530,10,125,7,'745',4,1),(531,10,126,7,'735',4,1),(1598,10,166,12,'971',1,1),(1599,10,167,12,'984',1,1),(1600,10,168,12,'981',1,1),(1601,10,169,12,'990',1,1),(1602,10,170,12,'991',1,NULL),(1603,10,171,12,'996',1,NULL),(1604,10,172,12,'1002',1,NULL),(1605,10,173,12,'1135',1,NULL),(1606,10,174,12,'1139',1,NULL),(1607,10,175,12,'1012',1,NULL),(1608,10,176,12,'1015',1,NULL),(1609,10,177,12,'1020',1,NULL),(1610,10,178,12,'1021',1,1),(1611,10,179,12,'1023',1,1),(1612,10,180,12,'1025',1,1),(1613,10,166,12,'971',2,1),(1614,10,167,12,'984',2,1),(1615,10,168,12,'981',2,1),(1616,10,169,12,'990',2,1),(1617,10,170,12,'994',2,1),(1618,10,171,12,'997',2,1),(1619,10,172,12,'1000',2,1),(1620,10,173,12,'1134',2,1),(1621,10,174,12,'1138',2,1),(1622,10,175,12,'1013',2,1),(1623,10,176,12,'1017',2,1),(1624,10,177,12,'1019',2,1),(1625,10,178,12,'1021',2,1),(1626,10,179,12,'1023',2,1),(1627,10,180,12,'1025',2,1),(1628,10,166,12,'971',3,1),(1629,10,167,12,'984',3,1),(1630,10,168,12,'981',3,1),(1631,10,169,12,'990',3,1),(1632,10,170,12,'994',3,1),(1633,10,171,12,'997',3,1),(1634,10,172,12,'1000',3,1),(1635,10,173,12,'1134',3,1),(1636,10,174,12,'1138',3,1),(1637,10,175,12,'1013',3,1),(1638,10,176,12,'1017',3,1),(1639,10,177,12,'1019',3,1),(1640,10,178,12,'1021',3,1),(1641,10,179,12,'1023',3,1),(1642,10,180,12,'1025',3,1),(3916,10,67,5,'537',1,NULL),(3917,10,68,5,'541',1,NULL),(3918,10,69,5,'545',1,NULL),(3919,10,70,5,'549',1,NULL),(3920,10,71,5,'553',1,1),(3921,10,72,5,'557',1,1),(3922,10,73,5,'561',1,NULL),(3923,10,74,5,'566',1,NULL),(3924,10,75,5,'571',1,NULL),(3925,10,78,5,'580',1,NULL),(3926,10,79,5,'584',1,NULL),(3927,10,80,5,'589',1,NULL),(3928,10,81,5,'576',1,1),(3929,10,88,5,'594',1,NULL),(3930,10,89,5,'598',1,NULL),(3931,10,67,5,'540',2,1),(3932,10,68,5,'544',2,1),(3933,10,69,5,'546',2,1),(3934,10,70,5,'551',2,1),(3935,10,71,5,'553',2,1),(3936,10,72,5,'557',2,1),(3937,10,73,5,'564',2,NULL),(3938,10,74,5,'569',2,1),(3939,10,75,5,'575',2,1),(3940,10,78,5,'582',2,1),(3941,10,79,5,'588',2,1),(3942,10,80,5,'592',2,1),(3943,10,81,5,'576',2,1),(3944,10,88,5,'596',2,1),(3945,10,89,5,'600',2,1),(8493,10,53,4,'296',1,1),(8494,10,54,4,'449',1,1),(8495,10,55,4,'300',1,1),(8496,10,57,4,'452',1,1),(8497,10,58,4,'414',1,1),(8498,10,59,4,'419',1,1),(8499,10,60,4,'325',1,1),(8500,10,61,4,'425',1,1),(8501,10,62,4,'327',1,1),(8502,10,63,4,'331',1,1),(8503,10,64,4,'333',1,1),(8504,10,65,4,'458',1,1),(8505,10,82,4,'343',1,1),(8506,10,83,4,'347',1,1),(8507,10,85,4,'459',1,1),(15547,110,1131,9,'11936',1,1),(15548,110,1132,9,'11941',1,1),(15549,110,1133,9,'11945',1,1),(15550,110,1134,9,'11949',1,1),(15551,110,1135,9,'11950',1,1),(15552,110,1136,9,'11952',1,NULL),(15553,110,1137,9,'11957',1,1),(15554,110,1138,9,'11960',1,1),(15555,110,1139,9,'11963',1,NULL),(15556,110,1140,9,'11967',1,NULL),(15557,110,137,9,'11896',1,NULL),(15558,110,138,9,'11904',1,1),(15559,110,139,9,'11909',1,1),(15560,110,140,9,'11911',1,1),(15561,110,141,9,'11916',1,NULL),(15562,110,142,9,'11920',1,NULL),(15563,110,143,9,'11927',1,1),(15564,110,144,9,'11929',1,1),(15565,110,145,9,'11930',1,NULL),(20143,10,26,3,'463',1,1),(20144,10,27,3,'465',1,1),(20145,10,28,3,'467',1,1),(20146,10,29,3,'469',1,1),(20147,10,30,3,'471',1,1),(20148,10,31,3,'474',1,1),(20149,10,32,3,'476',1,NULL),(20150,10,33,3,'477',1,1),(20151,10,34,3,'479',1,1),(20152,10,35,3,'485',1,1),(20153,10,36,3,'488',1,NULL),(20154,10,37,3,'490',1,1),(20155,10,38,3,'500',1,1),(20156,10,39,3,'509',1,NULL),(20157,10,40,3,'511',1,1),(20158,10,41,3,'514',1,NULL),(20159,10,42,3,'534',1,NULL),(20160,10,47,3,'520',1,NULL),(20161,10,48,3,'526',1,1),(20162,10,49,3,'532',1,1),(20163,10,1157,26,'12061',1,1),(20164,10,1158,26,'12062',1,1),(20165,10,1159,26,'12066',1,NULL),(20166,10,1160,26,'12071',1,NULL),(20167,10,1161,26,'12075',1,1),(20168,10,1162,26,'12077',1,NULL),(20169,10,1163,26,'12082',1,NULL),(20170,10,1164,26,'12084',1,1),(20171,10,1165,26,'12089',1,NULL),(20172,10,1166,26,'12090',1,NULL),(20173,10,1167,26,'12097',1,1),(20174,10,1168,26,'12098',1,NULL),(20175,10,1169,26,'12101',1,1),(20176,10,1170,26,'12107',1,1),(20177,10,1171,26,'12111',1,NULL),(20178,10,1172,26,'12112',1,NULL),(20179,10,1173,26,'12114',1,NULL),(20180,10,1174,26,'12120',1,NULL),(20181,10,1175,26,'12123',1,NULL),(20182,10,1176,26,'12126',1,NULL),(20183,10,1177,26,'12131',1,NULL),(20184,10,1178,26,'12137',1,NULL),(20185,10,1179,26,'12140',1,1),(20186,10,1180,26,'12142',1,1),(20187,10,1181,26,'12146',1,NULL),(20188,10,1182,26,'12147',1,NULL),(20189,110,1157,26,'12061',1,1),(20190,110,1158,26,'12062',1,1),(20191,110,1159,26,'12067',1,1),(20192,110,1160,26,'12072',1,1),(20193,110,1161,26,'12074',1,NULL),(20194,110,1162,26,'12078',1,1),(20195,110,1163,26,'12080',1,1),(20196,110,1164,26,'12084',1,1),(20197,110,1165,26,'12087',1,1),(20198,110,1166,26,'12092',1,1),(20199,110,1167,26,'12097',1,1),(20200,110,1168,26,'12099',1,1),(20201,110,1169,26,'12101',1,1),(20202,110,1170,26,'12107',1,1),(20203,110,1171,26,'12110',1,1),(20204,110,1172,26,'12113',1,1),(20205,110,1173,26,'12117',1,1),(20206,110,1174,26,'12119',1,1),(20207,110,1175,26,'12122',1,1),(20208,110,1177,26,'12134',1,1),(20209,110,1178,26,'12138',1,1),(20210,110,1179,26,'12140',1,1),(20211,110,1180,26,'12142',1,1),(20212,110,1181,26,'12145',1,1),(20213,110,1182,26,'12148',1,1);

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `access_code` varchar(60) DEFAULT NULL,
  `staff_type_select` varchar(60) DEFAULT NULL,
  `footer_column_1` blob,
  `footer_column_2` blob,
  `payment_activated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'Kornberg12',NULL,'','',0);

--
-- Table structure for table `training`
--

CREATE TABLE `training` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `title` varchar(90) DEFAULT NULL,
  `date_completed` int(90) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `training_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `training`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `lname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `email` varchar(60) CHARACTER SET utf8 NOT NULL,
  `pass` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `birthdate_day` int(11) NOT NULL,
  `birthdate_month` int(11) NOT NULL,
  `birthdate_year` int(11) NOT NULL,
  `join_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `confirmation_code` int(11) DEFAULT NULL,
  `confirmed` int(1) NOT NULL DEFAULT '1',
  `CEU_count` int(11) DEFAULT NULL,
  `access_level` int(11) DEFAULT '0',
  `staff_type` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `active` int(1) NOT NULL DEFAULT '1',
  `hired_date` int(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (10,'John','Sheppard','jcshep@gmail.com','78bfd17437cb85e2d2acb28c01717fe5f8b13d1fd54fe9fc974934403d79a205',2,2,1941,'2014-03-04 20:52:18',46863347,1,15,1,NULL,1,NULL),(110,'Cornell','Peters','fortriscorp@gmail.com','fe2e757802f5cff053eb5307ea69e65203bfff78e82b9144d47600008902a547',2,6,1982,'2015-02-18 19:54:58',30182285,1,35,1,NULL,1,NULL),(191,'Dayle','Selix','dselix@addictionacademy.com','123',0,0,0,'2018-06-13 17:21:58',72053629,1,0,1,NULL,1,NULL),(202,'Erik','Erik','erik@addictionacademy.com','32bb26c693a44f1fdb166af12137a6713e6d4e9a56a876110daa61fa7f9ca4b1',0,0,0,'2018-06-21 19:35:07',33302461,1,0,0,NULL,1,NULL);

--
-- Table structure for table `user_course_access`
--

CREATE TABLE `user_course_access` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `status` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `time_completed` int(11) unsigned DEFAULT NULL,
  `evaluated` int(11) DEFAULT '0',
  `essay_grade` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `user_course_access_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `user_course_access_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=788 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_course_access`
--

INSERT INTO `user_course_access` VALUES (774,10,3,'In Progress',NULL,0,NULL),(775,10,26,'In Progress',NULL,0,NULL),(776,110,26,'Completed',1528643534,0,'1'),(783,191,26,'In Progress',NULL,0,NULL),(784,202,3,'In Progress',NULL,0,NULL),(785,202,3,'In Progress',NULL,0,NULL),(786,202,26,'In Progress',NULL,0,NULL),(787,202,26,'In Progress',NULL,0,NULL);

--
-- Current Database: `dhope_school`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `dhope_school` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `dhope_school`;

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  `short_description` text CHARACTER SET utf8,
  `description` text CHARACTER SET utf8,
  `passing_percentage` int(11) DEFAULT NULL,
  `cost` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `instruction_methods` text CHARACTER SET utf8,
  `evaluation_method` text CHARACTER SET utf8,
  `study_guide` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `study_guide_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `case_study` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `syllabus` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `video` text CHARACTER SET utf8,
  `ceu_credit` int(11) unsigned DEFAULT '0',
  `promo_code` varchar(60) DEFAULT NULL,
  `frequency_required` int(11) DEFAULT NULL,
  `staff_requirement` int(11) DEFAULT NULL,
  `required_within_time` int(11) DEFAULT NULL,
  `in_person` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course`
--

INSERT INTO `course` VALUES (3,'HIV / AIDS','<p>HIV is an acronym for human immunodeficiency virus and it is the disease that often leads to AIDS. Continuing Education Course (2 CEUs)</p>','<p style=\"margin: 0px; padding: 0px; font-size: 12px; color: rgb(68, 68, 68); line-height: 18px; font-family: helvetica, arial, sans-serif;\">This class provides information on HIV and AIDS- related illnesses. Materials will be presented on the symptoms, causes, pathophysiology, diagnosis, transmission and prevention, treatment, epidemiology, prognosis, and history of HIV and AIDS.</p>',80,'0','Online Only',NULL,'Online-HIVAIDS-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',730,NULL,30,0),(4,'Aggression Management','<p>The effective handling of aggression is one of the most demanding aspects of working in Behavioral Health. It is an area in which the ability to manage self and assertively communicate with others is essential. This course will explore identifying, preventing and managing aggressive behavior through the use of verbal de-escalation interventions.</p>','<p><strong>Course Overview and Objectives</strong><br><br>The effective handling of aggression is one of the most demanding aspects of working in Behavioral Health. It is an area in which the ability to manage self and assertively communicate with others is essential. This course will explore identifying, preventing and managing aggressive behavior through the use of verbal de-escalation interventions. <br><br>Upon successful completion of this course the learner will be able to: </p><ol><li>Define “Aggression” and “Verbal De-escalation\" </li><li>Identify warning signs for aggressive behavior. </li><li>Give examples of verbal\r\nde-escalation techniques to use in a crisis situation\r\n   </li></ol>',80,'0','Online Only',NULL,'online-aggression-management-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',365,NULL,180,0),(5,'Infection Control','<p>Healthcare workers are required to participate in an annual training on infection prevention and control. 1 CEU</p>','<p>Healthcare workers are required to participate in an annual training on infection prevention and control. At the end of this study guide participants will be able to:</p><ul><li>Understand modes of transmission of bacteria and infections</li><li>Understand universal precautions</li><li>Practice proper hand washing techniques</li><li>Take action to prevention of the spread of disease in your workplace</li></ul>',80,'0','Online Only',NULL,'Online-InfectionControl-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,90,0),(7,'Confidentiality / HIPAA','<p>Confidentiality is one of the most basic rights that our clients have. All healthcare workers are legally and morally bound to protect the confidentiality of others.</p>','<p>Confidentiality is one of the most basic rights that our clients have. All healthcare workers are legally and morally bound to protect the confidentiality of others.</p><p>This course is designed to:</p><ol><li><span  style=\"font-size: 10pt;\">Give you an overview of The Health Insurance Portability and Accountability Act of 1996 </span><span  style=\"font-size: 10pt;\">(HIPAA).</span></li><li><span  style=\"font-size: 10pt;\">Familiarize you with any major changes that have been implemented with the new 2013 </span><span  style=\"font-size: 10pt;\">Omnibus Rule Changes.</span></li><li><span  style=\"font-size: 10pt;\">Help you recognize the serious consequences if you fail to comply with HIPAA.</span></li></ol>',80,'','Online',NULL,'HIPAA-2016.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',365,NULL,90,0),(8,'Incident Reporting Requirements','<p>All public or private substance abuse service providers, licensed by The Department of Children and Families (DCF) must create and maintain policies and procedures for Incident Reporting.</p>','<p>All public or private substance abuse service providers, licensed by The Department of Children and Families (DCF) must create and maintain policies and procedures for Incident Reporting. This course details the internal procedure for completing and filing an incident report form for an unusual event, as well as, the procedure for reporting a critical incident to the DCF and Joint Commission.</p>',80,'0','Online',NULL,'INCIDENTREPORTING_destinationhope.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,90,0),(9,'Abuse Reporting & Affirmative Duties','<p>Every individual in Florida has a responsibility to report suspected abuse or neglect. In addition, Florida Law specifies professionals in certain occupations as required to report abuse or neglect. This course will take you through the legal requirements in Florida regarding abuse reporting and affirmative duties.</p>','<p>Everyone in Florida is a mandated reporter but some people are professionally mandated reporters. Every person has a responsibility to report suspected abuse or neglect. In addition, Florida Law specifies professionals in certain occupations as required to do so. These professionals are mandated to make a report if they have reasonable  cause to suspect abuse, neglect or exploitation is of a child or a vulnerable adult. Providers of substance abuse services shall adhere to the statutory requirements for reporting abuse, neglect, and deaths of children under Chapter 39, F.S., and of adults under Section 415.1034 and paragraph 397.501(7)(c), F.S.</p>',80,'0','Online',NULL,'finalcurrentchapter 415.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',730,NULL,90,0),(10,'Sexual Harassment','<p>After completing this self-study session, you will be able to: Define sexual harassment, Identify the types of sexual harassment and Identify behaviors that may be interpreted as sexual harassment.</p>','<p>After completing this self-study session, you will be able to:</p><ul><li>Define sexual harassment.</li><li>Identify the types of sexual harassment.</li><li>Identify behaviors that may be interpreted as sexual harassment.</li></ul>',80,'0','Online',NULL,'finalsexualharassment.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',730,NULL,90,0),(11,'The Americans With Disabilities Act','<p>The Americans with Disabilities Act (ADA), which was signed into law on July 26, 1990, is the\r\nnation’s first comprehensive civil rights law addressing the needs of people with disabilities,\r\nprohibiting discrimination in employment, public services, public accommodations, and\r\ntelecommunications.</p>','<p>The Americans with Disabilities Act (ADA), which was signed into law on July 26, 1990, is the nation’s first comprehensive civil rights law addressing the needs of people with disabilities, prohibiting discrimination in employment, public services, public accommodations, and telecommunications. The ADA assures equality of opportunity, full participation, independent living, and economic self-sufficiency to persons with disabilities.</p>',80,'0','Online',NULL,'fADAonline.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,90,0),(12,'CPR','','',80,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'',730,NULL,180,1),(13,'Ethical Conduct','','',80,'','',NULL,'ethicsfinal.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',365,NULL,90,0),(16,'Cultural Diversity / Cultural Competence','','',80,'','',NULL,NULL,NULL,NULL,'culturaldiversityfinal.pptx',NULL,NULL,NULL,2,'',365,NULL,90,0),(19,'Sexual Abuse and Trauma','','',80,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,'',730,NULL,180,1),(20,'Relapse Prevention / Addiction Education','','',80,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,180,1),(21,'Medication Management','','',80,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'',180,NULL,30,1),(22,'New Employee Orientation','<p>The following study guide has been prepared to orient\r\nyou to various policies and guidelines to Destination Hope, Inc.  Please review this and complete the\r\npost-study test at the end of the packet.</p><p><strong></strong></p>','<p>This following study guide has been prepared to orient\r\nyou to various policies and guidelines to Destination Hope, Inc.  Please review this and complete the\r\npost-study test at the end of the packet.</p>',80,'0','Online',NULL,'New Employee Orientation Packet V1.docx',NULL,NULL,NULL,NULL,NULL,NULL,1,'',NULL,NULL,30,0),(23,'Domestic Violence','<p>This course is designed to assist the behavioral healthcare worker in understanding domestic violence and the mandates that involve behavioral healthcare workers. In addition to defining domestic violence, this course will review the effects of domestic violence, the cycle of violence, associated risk factors, safety planning, confidentiality and the legalities of domestic violence.</p>','<p>This course is designed to assist the behavioral healthcare worker in understanding domestic violence and the mandates that involve behavioral healthcare workers. In addition to defining domestic violence, this course will review the effects of domestic violence, the cycle of violence, associated risk factors, safety planning, confidentiality and the legalities of domestic violence. </p><p>Upon completion of this course the participant will: </p><ul>\r\n<li><span  style=\"font-size: 10pt;\">Be able to define domestic violence.</span></li><li><span  style=\"font-size: 10pt;\">Be able to discuss the statistics related to domestic violence.</span></li><li><span  style=\"font-size: 10pt;\">Develop an understanding of the impact and consequences of domestic violence on the\r\nvictim from a health, psychological, and emotional perspective.</span></li><li><span  style=\"font-size: 10pt;\">Be able to assess, counsel and formulate safety plans for clients at risk of domestic violence\r\nor who are currently in a violence relationship. </span></li><li><span  style=\"font-size: 10pt;\">Be able to identify national and local domestic violence resources.</span></li></ul>',80,'0','Online Only',NULL,'finaldomesticviolence.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,180,0),(24,'Understanding Co-occurring Disorders','<p>Prevalence rates show that individuals with co-occurring disorders are common in both the substance abuse and mental health treatment systems. This course will provide participants with an understanding of the concept and term: co-occurring disorders. Participants will become familiar with the assessment, symptoms, and treatment of co-occurring disorders, and will be provided with an example of a special population that exists within the realm of co-occurring disorders.</p>','<p>Prevalence rates show that individuals with co-occurring disorders are common in both the substance abuse and mental health treatment systems. This course will provide participants with an understanding of the concept and term: co-occurring disorders. Participants will become familiar with the assessment, symptoms, and treatment of co-occurring disorders, and will be provided with an example of a special population that exists within the realm of co-occurring disorders.  </p><p>On completion of this course, participants will be able to identify/demonstrate familiarity with: </p><ol><li><span  style=\"font-size: 10pt;\">The definition and terms related to co-occurring disorders. </span></li><li><span  style=\"font-size: 10pt;\">The assessment of co-occurring disorders and common symptoms. </span></li><li><span  style=\"font-size: 10pt;\">The relationship between substance abuse and mental health concerns. </span></li><li><span  style=\"font-size: 10pt;\">The symptoms of specific co-occurring disorders. </span></li><li><span  style=\"font-size: 10pt;\">Available treatments for clients with co-occurring disorders. </span></li><li><span  style=\"font-size: 10pt;\">A special population example and co-occurring disorders.</span></li></ol>',80,'','Online',NULL,'Co-Occuring Disorders.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',365,NULL,180,0),(25,'Disaster Preparedness','<p>An\r\neffective organizational safety program cannot exist without optimal reporting\r\nof medical/health errors and occurrences. </p>','<p>An\r\neffective organizational safety program cannot exist without optimal reporting\r\nof medical/health errors and occurrences. Therefore, it is the intent of\r\nDestination Hope, Inc. to adopt a non-punitive approach in its management of\r\nerrors and occurrences. All personnel are requiredto report suspected and\r\nidentified medical/health care errors, and should do so without the fear of\r\nreprisal in relationship to their employment. \r\nThis organization supports the concept that errors occur due to a\r\nbreakdown in systems and processes, and will focus on improving systems and\r\nprocesses, rather than disciplining those responsible for errors and\r\noccurrences. A focus will be placed on remedial actions and individual development\r\nto assist rather than punish staff members.</p>',80,'0','',NULL,'Disaster Preparedness.docx',NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,90,0),(26,'FLU SHOT','<p>We will keep track of which employees took the FLU shot.</p>','',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'',365,NULL,14,1),(27,'Relapse Prevention','<p>Relapse Prevention</p>','',80,'','',NULL,'Relapse Prevention.docx',NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,180,0),(28,'Medication Observation','<p>This training will go over three topics. Hand washing, medication observation and finally the taking of blood pressure. </p>','<p>When you have completed this course, you will know how to take a persons blood pressure correctly. You will also understand the types of medication common to our clients plus side effects of said medication. The trainee will be shown the types of common errors that are often made with medication observation plus go over the various protocols. Finally the trainee will be shown the proper way to wash their hands. </p>',70,'0','',NULL,NULL,NULL,NULL,'Psychotropic Medications.pptx',NULL,NULL,NULL,0,'',362,NULL,5,0),(29,'Hand washing','<p>This training demonstrates BHT\'s wash their hands properly.</p>','<p>Our BHT\'s will be trained towash their hands properly. This training will be taught by our RN in person with our employees.</p>',NULL,'0','',NULL,NULL,'06122017122558.pdf',NULL,NULL,NULL,NULL,NULL,1,'',362,NULL,5,1),(30,'Blood Pressure ','<p>This training is for the BHT\'s and will show them how to take blood pressure.</p>','<p>This training will go into detail how to administer a blood pressure test. This will be taught by a RN.</p>',NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'',362,NULL,5,1),(31,'WORKPLACE VIOLENCE PREVENTION','<p>This course deals with workplace violence prevention. At the end of this training, the trainee is expected to:</p><p>1.Identify the factors that increase the risk of workplace violence, and the types of violence that can occur in any workplace.</p><p>2.Know the strategies and techniques for preventing workplace violence.</p><p>3.Learn how to recognize signs of potentially violent behavior and how to defuse tension.</p><p>4.Know how to respond to threats of violence.</p>','<p>This course deals with workplace violence prevention. At the end of this training, the trainee is expected to:</p><p style=\"margin-left: 20px;\">1.Identify the factors that increase the risk of workplace violence, and the types of violence that can occur in any workplace.</p><p style=\"margin-left: 20px;\">2.Know the strategies and techniques for preventing workplace violence.</p><p style=\"margin-left: 20px;\">3.Learn how to recognize signs of potentially violent behavior and how to defuse tension.</p><p style=\"margin-left: 20px;\">4.Know how to respond to threats of violence.</p>',70,'','',NULL,'Workplace-Violence.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',360,NULL,90,0);

--
-- Table structure for table `course_category`
--

CREATE TABLE `course_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_category`
--

INSERT INTO `course_category` VALUES (1,'Admin'),(2,'Direct Care'),(3,'BHT');

--
-- Table structure for table `course_has_category`
--

CREATE TABLE `course_has_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  `course_offering_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  KEY `course_offering_id` (`course_offering_id`),
  KEY `course_category_id` (`course_category_id`),
  CONSTRAINT `course_has_category_ibfk_3` FOREIGN KEY (`course_offering_id`) REFERENCES `offerings` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_5` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_6` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_has_category`
--

INSERT INTO `course_has_category` VALUES (12,3,1,1),(13,5,1,1),(16,7,1,1),(17,8,1,1),(18,9,1,1),(19,10,1,1),(20,11,1,1),(21,12,2,1),(22,13,1,1),(25,16,1,1),(28,19,2,1),(29,20,2,1),(30,4,2,1),(32,3,2,1),(33,3,3,1),(35,4,3,1),(36,5,2,1),(37,5,3,1),(38,13,2,1),(39,13,3,1),(40,10,2,1),(41,10,3,1),(42,9,2,1),(43,9,3,1),(44,11,2,1),(45,11,3,1),(48,8,2,1),(49,8,3,1),(50,7,2,1),(51,7,3,1),(54,16,2,1),(55,16,3,1),(58,19,3,1),(59,20,3,1),(60,21,3,1),(61,22,1,1),(62,22,2,1),(63,22,3,1),(64,24,2,1),(65,24,3,1),(66,23,2,1),(67,23,3,1),(68,25,1,1),(69,25,2,1),(70,25,3,1),(71,26,1,1),(72,26,2,1),(73,26,3,1),(75,12,3,1),(76,27,2,1),(77,27,3,1),(78,28,3,1),(79,29,3,1),(80,30,3,1),(81,31,1,1),(82,31,2,1),(83,31,3,1);

--
-- Table structure for table `evaluation`
--

CREATE TABLE `evaluation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT NULL,
  `date` int(11) NOT NULL,
  `student_name` varchar(60) DEFAULT NULL,
  `question_1` text,
  `question_2` text,
  `question_3` text,
  `question_4` text,
  `question_5` text,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `evaluation`
--

INSERT INTO `evaluation` VALUES (9,2,1414693949,'','','','','','',3),(10,2,1414693963,'','','','','','',3),(11,2,1414694058,'','','','','','',5),(12,1,1414698803,'','','','','','',3);

--
-- Table structure for table `exam_results`
--

CREATE TABLE `exam_results` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `grade` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `exam_results_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `exam_results_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4664 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exam_results`
--

INSERT INTO `exam_results` VALUES (50,14,4,0),(51,14,4,0),(52,10,4,60),(54,14,4,69),(55,14,4,75),(57,14,4,94),(98,10,3,15),(99,10,3,100),(827,14,3,85),(1224,14,5,100),(3010,10,8,100),(3022,10,5,20),(3023,10,5,100),(3079,14,8,100),(3080,14,8,100),(3081,14,8,13),(3082,14,8,67),(3083,14,8,100),(3417,14,10,53),(4332,10,31,100),(4333,10,31,100),(4334,10,31,100),(4335,10,31,100);

--
-- Table structure for table `materials`
--

CREATE TABLE `materials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `name` varchar(60) NOT NULL,
  `filename` varchar(60) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `materials_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `materials`
--


--
-- Table structure for table `offering_has_category`
--

CREATE TABLE `offering_has_category` (
  `offering_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  KEY `offering_id` (`offering_id`),
  KEY `course_id` (`course_category_id`),
  CONSTRAINT `offering_has_category_ibfk_1` FOREIGN KEY (`offering_id`) REFERENCES `offerings` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `offering_has_category_ibfk_2` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offering_has_category`
--

INSERT INTO `offering_has_category` VALUES (1,1),(1,2),(1,3);

--
-- Table structure for table `offerings`
--

CREATE TABLE `offerings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offerings`
--

INSERT INTO `offerings` VALUES (1,'Compliance Training');

--
-- Table structure for table `option`
--

CREATE TABLE `option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_id` (`question_id`),
  CONSTRAINT `option_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1903 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `option`
--

INSERT INTO `option` VALUES (4,6,'1 in 2',NULL),(5,6,'1 in 5',NULL),(6,6,'1 in 3',NULL),(7,6,'1 in 4',NULL),(8,7,'An effective vaccine is now available to prevent the disease.',NULL),(9,7,'HIV testing is not only free but compulsory for everyone over age 18.',NULL),(10,7,'People believe that antiretroviral drugs have solved the HIV problem.',NULL),(11,7,'The number of new infections is continuing to decline.',NULL),(12,8,'Free HIV testing of all patients over age 13.',NULL),(13,8,'Developing a vaccine to prevent HIV infection.',NULL),(14,8,'Reducing the rate of new infections.',NULL),(15,8,'Compulsory HIV testing of all patients in emergency departments.',NULL),(16,9,'Black/African Americans.',NULL),(17,9,'Seniors.',NULL),(18,9,'Hispanics.',NULL),(19,9,'Native Americans.',NULL),(20,10,'Women and children, seniors, and transgender persons',NULL),(21,10,'Men who have sex with men, women who have sex with women, prisoners',NULL),(22,10,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',NULL),(23,10,'Women who have sex with women, homeless people, and seniors',NULL),(24,11,'Adopt compulsory hand-washing policies for staff and inmates.',NULL),(25,11,'Provide inmates with condoms and access to bleach for cleaning injection equipment.',NULL),(26,11,'Increase the number of correctional officers who monitor inmate activity.',NULL),(27,11,'Enroll inmates in HIV vaccine clinical trials.',NULL),(28,12,'When they enter prison.',NULL),(29,12,'Within 60 days prior to release.',NULL),(30,12,'Within 30 days prior to release.',NULL),(31,12,'Never; it is not required by law.',NULL),(32,13,'Healthcare workers are more focused on mental health issues in seniors.',NULL),(33,13,'Seniors avoid answering questions about sexual activity.',NULL),(34,13,'Seniors believe they are immune to HIV/AIDS.',NULL),(35,13,'Symptoms of AIDS such as fatigue and weight loss mimic those of normal aging.',NULL),(36,14,'Saliva and cervical secretions',NULL),(37,14,'Saliva, tears, serous fluid, and vaginal secretions',NULL),(38,14,'Blood, semen, breast milk, and vaginal and cervical secretions',NULL),(39,14,'Blood, semen, and urine',NULL),(40,15,'Blood collected for transfusion',NULL),(41,15,'Used needles and syringes',NULL),(42,15,'Casual contact with an infected patient',NULL),(43,15,'A public toilet seat',NULL),(44,16,'Increases the risk of HIV transmission.',NULL),(45,16,'Reduces the risk of HIV transmission.',NULL),(46,16,'Makes no difference in the risk of HIV transmission.',NULL),(47,16,'Increases the risk of pregnancy in women.',NULL),(48,17,'Syphilis',NULL),(49,17,'Hepatitis B (HBV)',NULL),(50,17,'Chlamydia',NULL),(51,17,'Tuberculosis (TB)',NULL),(52,18,'Relatively simple if the patient has health insurance.',NULL),(53,18,'A complex, multi-drug process that takes at least 6 months.',NULL),(54,18,'Usually not successful in African American patients.',NULL),(55,18,'Successful in most patients.',NULL),(56,19,'Unnecessary in HIV patient situations.',NULL),(57,19,'Warranted only if a patient has been diagnosed with TB.',NULL),(58,19,'Effective only if properly fitted and appropriately worn in all areas where risk of exposure is high.',NULL),(59,19,'Primarily used with patients who are coinfected with hepatitis.',NULL),(60,20,'Brain tumors from syphilis.',NULL),(61,20,'Liver disease from chronic hepatitis C.',NULL),(62,20,'Heart disease from antiretroviral drugs.',NULL),(63,20,'Stroke related to antiretroviral drugs.',NULL),(295,53,'True',NULL),(296,53,'False',1),(299,55,'True',NULL),(300,55,'False',1),(325,60,'True',1),(326,60,'False',NULL),(327,62,'True',1),(328,62,'False',NULL),(329,63,'Defensive level, anxiety level, acting out, tension reduction',NULL),(330,63,'Tension inducing, anxiety level, defensive level, acting out',NULL),(331,63,'Anxiety level, defensive level, acting out, tension reduction',1),(332,63,'Acting out, anxiety level, defensive level, tension reduction',NULL),(333,64,'True',1),(334,64,'False',NULL),(339,82,'Clenched fists',NULL),(340,82,'Pacing',NULL),(341,82,'Rapid breathing',NULL),(342,82,'Withdrawn behavior',NULL),(343,82,'All of the Above',1),(344,83,'The person is under the influence of a substance',NULL),(345,83,'The person has a history of psychiatric illness',NULL),(346,83,'The person is facing a high level of stress',NULL),(347,83,'All of the Above',1),(348,83,'A and B',NULL),(409,58,'Using a calm voice and acronyms or jargon',NULL),(410,58,'Giving the person your full attention',NULL),(411,58,'Paraphrasing what the person is saying',NULL),(412,58,'Validating the person’s feelings about the situation',NULL),(413,58,'All of the above',NULL),(414,58,'B, C, and D',1),(415,59,'Speak slowly clearly and gently',NULL),(416,59,'Walk fast away from client to avoid an altercation',NULL),(417,59,'Appear confident and display calmness',NULL),(418,59,'Show you are listening',NULL),(419,59,'A, C, and D',1),(420,59,'A and B',NULL),(421,61,'Don’t use jargon',NULL),(422,61,'Avoid demeaning language',NULL),(423,61,'Find someone that speaks that person’s language',NULL),(424,61,'A and B',NULL),(425,61,'All of the above',1),(449,54,'True',1),(450,54,'False',NULL),(451,57,'Telling the patient what he/she is feeling.',NULL),(452,57,'Summarize what the patient stated and repeat back to verify accuracy ',1),(453,57,'Make client aware of the incongruities from their statement',NULL),(454,57,'None of the above',NULL),(455,65,'Acting out',NULL),(456,65,'Tension Reduction',NULL),(457,65,'Anxiety Level',NULL),(458,65,'Defensive Level',1),(459,85,'True',1),(460,85,'False',NULL),(465,27,'False',1),(466,27,'True',NULL),(467,28,'True',1),(468,28,'False',NULL),(469,29,'False',1),(470,29,'True',NULL),(471,30,'True',1),(472,30,'False',NULL),(473,31,'True',NULL),(474,31,'False',1),(475,32,'True',1),(476,32,'False',NULL),(477,33,'True',1),(478,33,'False',NULL),(479,34,'True',1),(480,34,'False',NULL),(481,35,'Abstinence',NULL),(482,35,'Monogamous Relationship with partners not infected with HIV/AIDS',NULL),(483,35,'Protected Sex',NULL),(484,35,'Sterile needles',NULL),(485,35,'All of the above',1),(490,37,'Black/African Americans',1),(491,37,'Seniors',NULL),(492,37,'Hispanics',NULL),(493,37,'Native Americans',NULL),(498,38,'Women and children, seniors, and transgender persons',NULL),(499,38,'Men who have sex with men, women who have sex with women, prisoners',NULL),(500,38,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',1),(501,38,'Women who have sex with women, homeless people, and seniors',NULL),(506,39,'Saliva and cervical secretions',NULL),(507,39,'Saliva, tears, serous fluid, and vaginal secretions',NULL),(508,39,'Blood, semen, breast milk, and vaginal and cervical secretions',1),(509,39,'Blood, semen, and urine',NULL),(510,40,'Blood collected for transfusion',NULL),(511,40,'Used needles and syringes',1),(512,40,'Casual contact with an infected patient',NULL),(513,40,'A public toilet seat',NULL),(514,41,'Are entitled to know their child\'s HIV test results without their child\'s consent.',NULL),(515,41,'May not be informed directly or indirectly of their child\'s HIV test results without the child\'s consent.',1),(516,41,'May be informed indirectly of their child\'s HIV test results when sent a bill for said testing.',NULL),(517,41,'Must give consent for their child to be tested for HIV.',NULL),(519,47,'Bona fide medical emergencies',NULL),(520,47,'Court order',NULL),(521,47,'All of the above',1),(527,49,'Medical personnel involved with the diagnosis or treatment of the person tested; ',NULL),(528,49,'Licensed medical professionals who regularly participate as part of an interdisciplinary team ',NULL),(529,49,'Staff that handle body fluids ',NULL),(530,49,'Personnel involved in utilization review, risk management or peer review activities; ',NULL),(531,49,'Financial staff who compile or review medical records as part of routine billing activities',NULL),(532,49,'All of the above',1),(533,42,'Be tested for HIV at their initial prenatal visit and at 28-32 weeks.',1),(534,42,'Be tested for HCV at the first prenatal visit.',NULL),(535,42,'Not be offered HIV testing on an opt-out basis (right to refuse).',NULL),(536,42,'Request to be tested for HIV',NULL),(537,67,'A source',NULL),(538,67,'A mode of transmission',NULL),(539,67,'A host',NULL),(540,67,'All of the above',1),(541,68,'Every healthcare worker plays a vital role ',NULL),(542,68,'Staff education is an important aspect',NULL),(543,68,'Utilizes measures used to minimize the risk of transmission',NULL),(544,68,'All of the above',1),(545,69,'Droplets are generated by coughs, sneezes, talking',NULL),(546,69,'Droplet transmission is the most frequent mode of transmission in the healthcare setting',1),(547,69,'You can become infected when they land in eyes, mouth or nose',NULL),(548,69,'They can transmit infection when propelled a short distance and land on a surface',NULL),(549,70,'HIV',NULL),(550,70,'Hepatitis B',NULL),(551,70,'Tuberculosis',1),(552,70,'Herpes',NULL),(553,71,'From mosquitos or insect bites',1),(554,71,'From blood or body fluids',NULL),(555,71,'From food or water',NULL),(556,71,'From coughs and sneezes ',NULL),(557,72,'Wear a fit-tested NIOSH-approved N95',1),(558,72,'Wear a surgical mask',NULL),(559,72,'Take 15 minute hot shower after exposure',NULL),(560,72,'Wash your hands with soap and water for 10 minutes',NULL),(561,73,'Direct contact',NULL),(562,73,'Indirect contact',NULL),(563,73,'Respiratory transmission',NULL),(564,73,'Vector-born transmission',NULL),(565,73,'All of the above',1),(576,81,'Sweat',1),(577,81,'Saliva',NULL),(578,81,'Blood',NULL),(579,81,'None of the above',NULL),(580,78,'30 seconds',NULL),(581,78,'15 seconds',NULL),(582,78,'At least for 20 seconds',1),(583,78,'60 seconds',NULL),(598,89,'Airborne Precautions',NULL),(599,89,'Contact Precautions',NULL),(600,89,'Standard Precautions',1),(601,89,'Droplet Precautions',NULL),(602,90,'True',NULL),(603,90,'False',1),(604,91,'Where clinical professionals, in this case in the addiction industry, have multiple relationship roles with their clients',1),(605,91,'An unaviodable part of doing business in the addiction treatment industry',NULL),(606,91,'A multiple role relationship that is generally suitable for the therapist-client relationship',NULL),(607,91,'All of the above',NULL),(608,92,'To give authorization for treatment center employees to use private information',NULL),(609,92,'To secure a person\'s private financial information',NULL),(610,92,'To define the the proper use of an individual\'s health records',1),(611,92,'To punish addiction treatment centers that misuse personal information',NULL),(612,93,'Health Information Portability Protection Act',NULL),(613,93,'Health Insurance Portability and Accountability Act',1),(614,93,'Human Interest Protection  Act',NULL),(615,93,'None of the above',NULL),(616,94,'True',NULL),(617,94,'False',1),(618,95,'A fraudulent accounting scheme',NULL),(619,95,'The requirement for an arrested person to be brought into court or before a judge',1),(620,95,'The legal definition of self-inflicted bodily harm',NULL),(621,95,'None of the above',NULL),(622,96,'The clinician is the professional',NULL),(623,96,'Proper boundaries cannot be defined therefore this is a moot point',NULL),(624,96,'The client may not understand proper boundaries and may not be able to defend themselves against violations',NULL),(625,96,'The counselor must report to their supervisor',NULL),(626,96,'A and C',1),(627,96,'A and D',NULL),(628,97,'True',1),(629,97,'False',NULL),(630,98,'Quid Pro Quo',NULL),(631,98,'Professional Business',NULL),(632,98,'Dual Relationship',1),(633,98,'None of the Above',NULL),(634,99,'On a need to know basis within the facility',NULL),(635,99,'Medical emergencies',NULL),(636,99,'When parents ask',NULL),(637,99,'Client information can never be disclosed without written consent',NULL),(638,99,'B and C',NULL),(639,99,'A and B',1),(640,100,'Crossed Legs',NULL),(641,100,'Standing Tall',NULL),(642,100,'Slouching',NULL),(643,100,'Red face',NULL),(644,100,'B and D',1),(645,100,'A and B',NULL),(646,101,'True',NULL),(647,101,'False',1),(648,102,'Stress and history of violence',1),(649,102,'Stress and a long marriage',NULL),(650,102,'A long marriage and a high degree of social interaction',NULL),(651,102,'A high degree of social interaction and a history of violence',NULL),(652,103,'Perception and prejudice',NULL),(653,103,'Noise',NULL),(654,103,'Language',NULL),(655,103,'All of the above',1),(656,104,'Common depression',NULL),(657,104,'bipolar disorder doesn\'t fall under the DSMIV-TR purview',NULL),(658,104,'Mood changes that last for 48 hours or less',NULL),(659,104,'Significant mood changes that last for weeks or months',1),(660,105,'True',NULL),(661,105,'False',1),(662,106,'Use',NULL),(663,106,'Abuse',1),(664,106,'Misuse',NULL),(665,106,'Addiction',NULL),(666,107,'A good idea to use as proof',NULL),(667,107,'Not a problem if the copies are lost',NULL),(668,107,'A bad idea unless needed for an important purpose.',1),(669,107,'Something that should never be done',NULL),(670,108,'True',NULL),(671,108,'False',1),(674,110,'True',NULL),(675,110,'False',1),(676,111,'True',NULL),(677,111,'False',1),(678,112,'True',1),(679,112,'False',NULL),(680,113,'True',NULL),(681,113,'False',1),(682,109,'True',1),(683,109,'False',NULL),(684,114,'It eliminates the possibility of infection',NULL),(685,114,'It helps determine the exposure risk of staff members',1),(686,114,'A and B',NULL),(687,114,'None of the above',NULL),(688,115,'Common cold, Pinkeye, Flu',1),(689,115,'Common cold, Flu, HIV',NULL),(690,115,'HIV, Common cold, Pinkeye, Flu',NULL),(691,115,'AIDS, Pinkeye, Flu',NULL),(692,116,'FS 387.219 (1)',NULL),(693,116,'FS 456.222 (4)',NULL),(694,116,'FS 397.419 (2)',1),(695,116,'FS 298.419 (1)',NULL),(696,117,'Organizations',NULL),(697,117,'Supervisors',NULL),(698,117,'Risk Managers',NULL),(699,117,'All Staff',1),(700,118,'Verification of corrective action',NULL),(701,118,'Results of Root Cause Analyses',NULL),(702,118,'Provision for reporting to the Department',NULL),(703,118,'a and b',NULL),(704,118,'a and c',1),(705,119,'As soon as possible and no later than 48 hours',NULL),(706,119,'As soon as possible and no later than 72 hours',NULL),(707,119,'As soon as possible and no later than 24 hours',1),(708,119,'As soon as possible',NULL),(709,120,'Collaborate for accuracy of events witnessed',NULL),(710,120,'Both sign the Incident Report Form',NULL),(711,120,'Each file a separate Incident Report Form',1),(712,120,'Jointly prepare one Incident Report Form',NULL),(713,121,'True',NULL),(714,121,'False',1),(715,122,'Complete one Incident Report listing all clients involved in the incident',NULL),(716,122,'Complete a separate Incident Report for each client involved',1),(717,122,'Have client’s Primary Therapist complete an incident report',NULL),(718,122,'None of the above',NULL),(723,124,'Enter concise subjective statements of fact',NULL),(724,124,'Express their own opinion of the occurrence',NULL),(725,124,'Enter concise objective statements of fact',1),(726,124,'a and b',NULL),(727,125,'Promptly report a critical incidence within 6 hours',NULL),(728,125,'Promptly report a critical incident within 24 hours',NULL),(729,125,'Promptly report a critical incident within one business day',1),(730,125,'None of the above',NULL),(731,126,'The Critical Incident Reporting System (CIRS)',NULL),(732,126,'The Critical Incident Analyses System (CIAS)',NULL),(733,126,'The Incident Analysis and Reporting System (IRAS)',NULL),(734,126,'The Incident Reporting and Analysis System (IRAS)',1),(735,127,'All Substance Abuse Providers licensed by the DCF',NULL),(736,127,'Managing Entities',NULL),(737,127,'State  mental health treatment facilities  ',NULL),(738,127,'A and B',1),(739,127,'A and C',NULL),(740,128,'True',1),(741,128,'False',NULL),(742,129,'1994',NULL),(743,129,'1998',NULL),(744,129,'1996',1),(745,129,'1997',NULL),(746,130,'True',NULL),(747,130,'False',1),(748,131,'To report it to your supervisor',NULL),(749,131,'To report it only if you believe it is an emergency',NULL),(750,131,'To report it to the Florida Abuse Hotline of Children and Families',1),(751,131,'You are only required to report it to the person’s insurance company',NULL),(752,132,'Abandonment',NULL),(753,132,'Abuse',NULL),(754,132,'Exploitation',NULL),(755,132,'Neglect',1),(760,134,'They are ashamed ',NULL),(761,134,'They feel no one will believe them',NULL),(762,134,'They are afraid someone may retaliate if they report them',NULL),(763,134,'All of the above',1),(764,135,'True',1),(765,135,'False',NULL),(777,139,'Section 415.1034',NULL),(778,139,'Chapter 40, F.S.',NULL),(779,139,'Chapter 39, F.S.',1),(780,139,'Section 48 F.S.',NULL),(781,140,'800-222-2873',NULL),(782,140,'800-962-2873',1),(783,140,'800-914-0004',NULL),(784,140,'800-453-5145',NULL),(785,141,'Welcomed, physical in nature, and occur in or impact the workplace',NULL),(786,141,'Unwelcome, sexual in nature, and occur in or impact the workplace.',1),(787,141,'Unwelcome, sexual in nature and occur in the workplace',NULL),(788,141,'Unwelcome, physical in nature and occur in the workplace',NULL),(789,142,'Making derogatory or sexually explicit comments',NULL),(790,142,'Displaying sexually suggestive posters',NULL),(791,142,'Making unwanted physical contact',NULL),(792,142,'All of the above',1),(793,143,'Rewards or threats in the areas of hiring/firing, promotion, and performance review',1),(794,143,'Behavior that makes the workplace uncomfortable ',NULL),(795,143,'Unwelcome suggestive, sexually explicit or obscene letters, notes, emails or invitations.',NULL),(796,143,'Sexually explicit offensive comments',NULL),(797,144,'Express yourself verbally',NULL),(798,144,'Tell the harasser the behavior is making you uncomfortable',NULL),(799,144,'Express yourself non verbally',NULL),(800,144,'If you are afraid of retaliation say nothing and go straight to HR',NULL),(801,144,'All of the above',1),(802,145,'Disagrees with employers that discriminate based on sex, gender, race, religion or any other protected class.',NULL),(803,145,'Files a discrimination charge',NULL),(804,145,'Offers testimony or partakes in an investigation or court proceeding',NULL),(805,145,'All of the above',1),(810,148,'True',1),(811,148,'False',NULL),(812,149,'True',1),(813,149,'False',NULL),(814,150,'True',1),(815,150,'False',NULL),(816,151,'True',NULL),(817,151,'False',1),(818,152,'True',NULL),(819,152,'False',1),(820,154,'Yes',1),(821,154,'No',NULL),(822,155,'Yes',NULL),(823,155,'No',1),(824,156,'Yes',1),(825,156,'No',NULL),(826,136,'True',NULL),(827,136,'False',1),(828,138,'Exploitation',NULL),(829,138,'Abuse',1),(830,138,'Neglect',NULL),(831,138,'All of the above',NULL),(832,157,'State and local governments',NULL),(833,157,'Private employers',NULL),(834,157,'Employment agencies',NULL),(835,157,'Labor organizations',NULL),(836,157,'All of the above',1),(837,158,'No means of transportation',NULL),(838,158,'A criminal history',NULL),(839,158,'A physical or mental impairment that substantially limits one or more life activities',1),(840,158,'None of the above',NULL),(841,158,'All of the above',NULL),(842,159,'Sexual preference',NULL),(843,159,'Kleptomania',NULL),(844,159,'Illegal Drug use',NULL),(845,159,'All of the above',1),(846,160,'True',1),(847,160,'False',NULL),(848,161,'Changing a training manual',NULL),(849,161,'Letting employee sleep during work hours',NULL),(850,161,'Providing an interpreter',NULL),(851,161,'A and C',1),(852,162,'True',1),(853,162,'False',NULL),(854,163,'True',NULL),(855,163,'False',1),(856,164,'True',1),(857,164,'False',NULL),(858,165,'True',NULL),(859,165,'False',1),(860,166,'Walking',NULL),(861,166,'Breathing',NULL),(862,166,'Eating',NULL),(863,166,'Major bodily functions',NULL),(864,166,'All of the above',1),(865,146,'True',1),(866,146,'False',NULL),(867,147,'True',1),(868,147,'False',NULL),(869,133,'Law enforcement officer',NULL),(870,133,'Nurse in an assisted living facility',NULL),(871,133,'School teacher',NULL),(872,133,'All of the above',1),(876,169,'ZXZX',1),(1037,170,'A public health problem, impacting large numbers of the population',1),(1038,170,'A family problem, best dealt with within the family ',NULL),(1039,170,'A reportable crime in Florida regardless of whether or not a weapon was used in the abuse',NULL),(1040,170,'All of the above',NULL),(1041,171,'Stalking, psychological violence; neglect and physical violence',NULL),(1042,171,'Physical violence, sexual violence; stalking; and emotional violence',NULL),(1043,171,'Physical violence; sexual violence; threats of physical and sexual violence; emotional and psychological violence',1),(1044,171,'None of the above',NULL),(1045,172,'Witnessing or experiencing violence as a child',NULL),(1046,172,'Economic security',1),(1047,172,'Weak community sanctions against Domestic Violence such as police being unwilling to intervene',NULL),(1048,172,'Dominance and control by one partner in the relationship',NULL),(1049,173,'Low self-esteem, low income and drug and alcohol abuse',NULL),(1050,173,'Individual, societal, relational and community',1),(1051,173,'Anger, passivity, Anti-social personality traits and Borderline personality traits',NULL),(1052,173,'All of the above',NULL),(1053,174,'Verbal abuse',NULL),(1054,174,'Physical acting out',NULL),(1055,174,'Difficulty getting along with others',1),(1056,174,'All of the above',NULL),(1057,175,'Forcing sexual acts',NULL),(1058,175,'Isolating the victim',NULL),(1059,175,'The abuser threatening suicide',NULL),(1060,175,'All of the above',1),(1061,176,'Drug or alcohol abuse',NULL),(1062,176,'Intense jealousy',NULL),(1063,176,'Welcoming of others into relationship',1),(1064,176,'Will not allow a break-up of the relationship',NULL),(1065,177,'Emotional insecurity and depression',1),(1066,177,'Belief in the bonds of marriage and monogamy',NULL),(1067,177,'Maturity and self-reliance',NULL),(1068,177,'Strong ego and many friends',NULL),(1069,178,'Withhold money',NULL),(1070,178,'Intimidate',NULL),(1071,178,'Use children to deliver messages',NULL),(1072,178,'All of the above',1),(1073,179,'Signs of a victim',NULL),(1074,179,'Parts of the cycle of violence',1),(1075,179,'Signs of an abuser',NULL),(1076,179,'Signs of marital conflict',NULL),(1077,180,'911—If you are in immediate danger',NULL),(1078,180,'The National Domestic Violence Hotline at 1-800-799-SAFE (7233)',NULL),(1079,180,'The National Sexual Assault Hotline at 1-800-656-4673',NULL),(1080,180,'All of the above',1),(1081,181,'9.2% to 30.5%',1),(1082,181,'15%',NULL),(1083,181,'24.3%',NULL),(1084,181,'14.8%',NULL),(1085,182,'Emotional discomfort',NULL),(1086,182,'Blaming the victim',1),(1087,182,'Cultural barriers',NULL),(1088,182,'Uncooperative behavior by the victim',NULL),(1089,183,'Accurate documentation and safe guarding evidence',1),(1090,183,'Staying disconnected',NULL),(1091,183,'Demand the criminal justice system get involved',NULL),(1092,183,'All of the above',NULL),(1093,184,'Intervening directly with the abuser',NULL),(1094,184,'Acknowledging client barriers for seeking help',1),(1095,184,'Filing police reports on behalf of the victim',NULL),(1096,184,'None of the above',NULL),(1097,185,'Helping victim create a safety plan',NULL),(1098,185,'Give advice whether to leave or stay in abusive relationship',1),(1099,185,'Validate victims experience',NULL),(1100,185,'Respect confidentiality of victim',NULL),(1101,186,'800-799-7233',NULL),(1102,186,'800-500-1119',1),(1103,186,'800-656-4673',NULL),(1104,186,'800-656-6767',NULL),(1105,187,'Increasing safety at home',NULL),(1106,187,'Planning for emotional support',NULL),(1107,187,'Immediate and long term safety',NULL),(1108,187,'All of the above',1),(1109,188,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a gunshot wound, or life threatening injury indicating an act of violence.',1),(1110,188,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a broken arm, leg etc.',NULL),(1111,188,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a fall',NULL),(1112,188,'None of the above',NULL),(1113,189,'That the assessment was conducted and no Domestic Violence signs were indicated',NULL),(1114,189,'That the assessment was conducted and the worker did not get an answer about DV from the patient',NULL),(1115,189,'That the assessment was conducted and that the patient did not disclose abuse',1),(1116,189,'None of the above',NULL),(1161,566,'a. The presence of two or more disorders at the same time',1),(1162,566,'b. The presence of at least 2 mental health disorders',NULL),(1163,566,'c. The presence of at least 2 substance related disorders',NULL),(1164,566,'d. None of the above',NULL),(1165,567,'a. Schizophrenia and Depression ',NULL),(1166,567,'b. Bipolar Disorder and Anxiety Disorder',1),(1167,567,'c. Depression and Fibromyalgia',NULL),(1168,567,'d. Bipolar Disorder and Chronic Fatigue',NULL),(1169,568,'a. Alcohol and drugs can increase underlying risk for mental disorders.',NULL),(1170,568,'b. Alcohol or drugs are often used to self-medicate symptoms of depression or anxiety.',NULL),(1171,568,'c. Psychiatric problems do not get worse by using drugs or alcohol.',1),(1172,568,'d. Alcohol and drug abuse can make symptoms of a mental health problem worse.',NULL),(1173,569,'a. Lying about one’s addiction',NULL),(1174,569,'b. Denial frequently occurs in mental disorders',NULL),(1175,569,'c. If the problem is not acknowledged, it doesn\'t exist.',NULL),(1176,569,'d. All of the above',1),(1177,570,'a. Feeling restless or jumpy',NULL),(1178,570,'b. Trouble concentrating',NULL),(1179,570,'c. Decreased need for sleep',NULL),(1180,570,'d. A and B',1),(1181,571,'a. Sequential model of treatment',NULL),(1182,571,'b. Parallel model of treatment',NULL),(1183,571,'c. Integrated model of treatment',1),(1184,571,'d. All of the above',NULL),(1189,575,'a. Depression?',NULL),(1190,575,'b. Bipolar Disorder?',NULL),(1191,575,'c. Obsessive Compulsive Disorder?',1),(1192,575,'d. Social Anxiety Disorder? ',NULL),(1193,576,'a. Obsessive Compulsive Disorder?',NULL),(1194,576,'b. Anxiety Disorder?',NULL),(1195,576,'c. Mania phase in Bipolar Disorder?',1),(1196,576,'d. Depression?',NULL),(1197,577,'True',1),(1198,577,'False',NULL),(1199,578,'True',1),(1200,578,'False',NULL),(1201,579,'True',1),(1202,579,'False',NULL),(1203,580,'True',1),(1204,580,'False',NULL),(1205,36,'a)	1 in 2',NULL),(1206,36,'b)	1 in 7',1),(1207,36,'c)	1 in 3',NULL),(1208,36,'d)	1 in 4',NULL),(1209,581,'Discussing client issues only in private areas',NULL),(1210,581,'Requiring written authorization before releasing information',NULL),(1211,581,'Not utilizing client last names in public areas or medical record file covers',NULL),(1212,581,'All of the above',1),(1213,582,'Health Information Property Accountability Association',NULL),(1214,582,'Human Insurance Process Accumulation Act',NULL),(1215,582,'Health Insurance Portability and Accountability Act',1),(1216,583,'Security',NULL),(1217,583,'Privacy',1),(1218,583,'Confidentiality',NULL),(1219,584,'Electronic Medical Record ',NULL),(1220,584,'Security ',NULL),(1221,584,'HITECH',1),(1222,584,'HHS',NULL),(1223,585,'Medical record number',NULL),(1224,585,'Telephone number',NULL),(1225,585,'Fax number',NULL),(1226,585,'Social security number',NULL),(1227,585,'All of the above',1),(1228,585,'A, B and D',NULL),(1229,586,'Disciplinary action',NULL),(1230,586,'Loss of access privileges',NULL),(1231,586,'Fines and penalties',NULL),(1232,586,'Imprisonment',NULL),(1233,586,'All of the above',1),(1234,587,'Yes',NULL),(1235,587,'No',1),(1236,588,'Yes, if he is an employee and you know him.',NULL),(1237,588,'Yes, if your manager says that it’s okay.',NULL),(1238,588,'No, sharing log-in IDs and passwords is a security violation.',1),(1239,588,'A and B',NULL),(1240,589,'I am only expected to complete the minimum requirements of my job.',NULL),(1241,589,' Requests for and disclosures of PHI are limited to what is needed to perform the task.',1),(1242,589,'A medical center is no longer allowed to provide information about patients to the media under any circumstances',NULL),(1243,589,'A and B',NULL),(1244,590,'Yes.  They can be used interchangeably.',NULL),(1245,590,'No.  Consents are used to get the patient\'s permission to use or disclose health information for       treatment, payment or business operations. Authorizations are used to obtain permission to disclose    PHI for activities outside the realm of treatment, payment or business operations.',1),(1246,591,'True',1),(1247,591,'False',NULL),(1248,592,'True',1),(1249,592,'False',NULL),(1250,593,'True',NULL),(1251,593,'False',1),(1252,594,'Management of Safe Devices and Systems.',NULL),(1253,594,'Maintenance and Storage of Devices and Systems.',NULL),(1254,594,'Material Safety Data Sheets.',1),(1255,594,'Management, Storage and Distribution of Substances.',NULL),(1256,595,'True',1),(1257,595,'False',NULL),(1258,596,'Tornado',NULL),(1259,596,'Medical',NULL),(1260,596,'Bomb',1),(1261,596,'Patient Emergency',NULL),(1262,597,'Code Hot',NULL),(1263,597,'Code Red',1),(1264,597,'Code Fire',NULL),(1265,597,'Patient Emergency',NULL),(1266,598,'Code Yellow',NULL),(1267,598,'Code Grey',1),(1268,598,'Code Purple',NULL),(1269,598,'Code Pink',NULL),(1274,600,'Read, Act, Collect, Evacuate',NULL),(1275,600,'Read, Ask, Confine, Extinguish',NULL),(1276,600,'Rescue/Remove from danger, Alert/Alarm, Confine/Contain, Extinguish/Evacuate',1),(1281,602,'True',1),(1282,602,'False',NULL),(1283,603,'True',1),(1284,603,'False',NULL),(1285,604,'True',1),(1286,604,'False',NULL),(1291,605,'Code Red',NULL),(1292,605,'Code Purple',NULL),(1293,605,'Code White',1),(1294,605,'Code Green',NULL),(1299,607,'Outside lighting',NULL),(1300,607,'Alarm system',NULL),(1301,607,'Employee picture ID badges',NULL),(1302,607,'All of the above',1),(1303,608,'True',1),(1304,608,'False',NULL),(1305,609,'True',NULL),(1306,609,'False',1),(1307,610,'The beliefs customs, arts, etc., of a particular society, group, place or time.',NULL),(1308,610,'A way of thinking, behaving, or working that exists in a place or organization.',NULL),(1309,610,'A particular society that has its own beliefs or ways of life.',NULL),(1310,610,'All of the above',1),(1311,611,'True',NULL),(1312,611,'False',1),(1313,612,'True',1),(1314,612,'False',NULL),(1315,613,'Spirituality and religion are not the same',NULL),(1316,613,'Spirituality/Religion is not part of every ethnic group',1),(1317,613,'Religion is an organized system of belief in a higher power',NULL),(1318,613,'Spirituality/religion is the belief individuals have about themselves, their connections with others and their relationship with a higher power.',NULL),(1319,614,'True',1),(1320,614,'False',NULL),(1325,616,'Cultural Incapacity',NULL),(1326,616,'Cultural Destructiveness',NULL),(1327,616,'Cultural Blindness',1),(1328,616,'Cultural Pre-competence',NULL),(1329,617,'Acceptance of ethnic differences between people',NULL),(1330,617,'A willingness to work with clients of a different ethnic background',NULL),(1331,617,'Avoid jokes that offend',NULL),(1332,617,'Understand that diversity within cultures is as important as diversity between cultures.',NULL),(1333,617,'All of the above',1),(1334,618,'Practitioners are aware of their own values and biases',NULL),(1335,618,'Enables organizations and staff to work effectively in cross-cultural situations',NULL),(1336,618,'Builds trust in a relationship',NULL),(1337,618,'All of the above',1),(1338,572,'a. Abusing alcohol and/or other drugs',NULL),(1339,572,'b. A complex interplay of genetics, the environment, and other outside factors. ',1),(1340,572,'c. The environment',NULL),(1341,572,'d. Genetics',NULL),(1346,573,'Behaviors to prevent weight gain such as self-induced vomiting',NULL),(1347,573,'Frequent episodes of consuming very large amounts of food ',1),(1348,573,'Intense fear of weight gain',NULL),(1349,573,'All of the above',NULL),(1350,574,'Restricting food intake',NULL),(1351,574,'Frequent episodes of consuming very large amount of food followed by behaviors to prevent weight gain, such as self-induced vomiting.',1),(1352,574,'Extreme loss of weight',NULL),(1353,574,'All of the above',NULL),(1358,620,'Is our moral but not legal obligation',NULL),(1359,620,'Is our legal and moral obligation',1),(1360,620,'Is neither our legal nor moral obligation',NULL),(1361,620,'Is our legal but not moral obligation',NULL),(1362,620,'All of the above',NULL),(1363,621,'Keep functions separate based on location',NULL),(1364,621,'Understand your role as a counselor',NULL),(1365,621,'By having an honest conversation with the client about your relationship',NULL),(1366,621,'Stay wary of possible confidentiality breaches',NULL),(1367,621,'All of the above',1),(1368,622,'A counselor\'s beliefs',NULL),(1369,622,'A counselor\'s moral compass',NULL),(1370,622,'A counselor\'s experience',NULL),(1371,622,'A counselor\'s values',NULL),(1372,622,'A counselor\'s daily routine',1),(1373,623,'Basic requiring no knowledge of law and precedent',NULL),(1374,623,'Generally easy and apply to every client',NULL),(1375,623,'Nuanced making them often very difficult',1),(1376,623,'Cut and dried when following the law',NULL),(1377,623,'All of the above',NULL),(1378,624,'The counselor cannot make up their mind',NULL),(1379,624,'Counselors have more than one client',NULL),(1380,624,'Counselors have more than one relationship with the client',1),(1381,624,'The counselor is empathetic towards a client',NULL),(1382,624,'All of the above',NULL),(1383,625,'Are set by the client',NULL),(1384,625,'Don’t generally apply to counselors',NULL),(1385,625,'Were more important in the past',NULL),(1386,625,'Are an important part of counseling',1),(1387,625,'All of the above',NULL),(1388,626,'May require a counselor to sign an agreement to uphold certain standards.',NULL),(1389,626,'Are important',NULL),(1390,626,'Require counselor training, in most states',NULL),(1391,626,'Are generally self-regulated by the industry',NULL),(1392,626,'All of the above',1),(1393,627,'Are not worth understanding.',NULL),(1394,627,'Mean that a counselor must be able to make ethical decisions on the fly.',1),(1395,627,'Are unavoidable but largely irrelevant.',NULL),(1396,627,'Don\'t exist - there are standard responses to every problem.',NULL),(1397,627,'All of the above',NULL),(1398,628,'Confidentiality',1),(1399,628,'Issuance of a Certificate of Financial Responsibility',NULL),(1400,628,'Oral records only',NULL),(1401,628,'Current clients only',NULL),(1402,628,'All of the above',NULL),(1405,630,'Should be encouraged',NULL),(1406,630,'Can increase the risk of exploitation or misinterpretation',1),(1407,630,'Is rarely a problem',NULL),(1408,630,'Can keep the client-counselor relationship more interesting',NULL),(1409,630,'All of the above',NULL),(1410,631,'Is administered by the counselor with minimal client input.',NULL),(1411,631,'Not a part of professional ethics.',NULL),(1412,631,'Helpful in allowing the client to understand the direction of their treatment.',1),(1413,631,'Just about signing paperwork',NULL),(1414,631,'All of the above',NULL),(1415,632,'Should never be done',NULL),(1416,632,'Should be done with every client',NULL),(1417,632,'Should be done when counselor has strong belief client will benefit',1),(1418,632,'Should be done when the client asks a personal questions',NULL),(1419,632,'All of the above',NULL),(1430,635,'May make clinical mistakes',NULL),(1431,635,'May begin to burn out',NULL),(1432,635,'May exploit the client',NULL),(1433,635,'All of the above',1),(1434,636,'Counselor and hair stylist',NULL),(1435,636,'Counselor to your best friends brother',NULL),(1436,636,'Counselor and supervisor',NULL),(1437,636,'Counselor and 12-step sponsor',NULL),(1438,636,'All of the above',1),(1439,637,'Areas a professional counselor is interested in working in',NULL),(1440,637,'All areas of clinical practice',NULL),(1441,637,'Actions that a member of the profession is trained and authorized to perform',1),(1442,637,'Clinical practice in areas where the counselor can receive clinical supervision',NULL),(1443,637,'None of the above',NULL),(1444,638,'Clinical, moral, legal',NULL),(1445,638,'Legal, moral, ethical',1),(1446,638,'Ethical, moral, clinical',NULL),(1447,638,'Ethical, legal, clinical',NULL),(1448,638,'None of the above',NULL),(1449,639,'True',1),(1450,639,'False',NULL),(1451,640,'Submission to the conduct, either implicitly or explicitly, is made as a condition of term of employment.',NULL),(1452,640,'Unwelcome sexual behavior that is not directed at the employee personally, but is part of his or her work environment.',1),(1453,640,'Requests for sexual favors',NULL),(1454,641,'True',1),(1455,641,'False',NULL),(1456,642,'Get in their face to make sure they understand you point clearly.',NULL),(1457,642,'Use the \"buddy\" system anytime you think that your personal safety may be at stake Take Precautions - Defuse the Situation',NULL),(1458,642,'Report all threats to your supervisor',NULL),(1459,642,'B and C',1),(1460,642,'All of the above',NULL),(1467,645,'True',NULL),(1468,645,'False',1),(1469,644,'True',1),(1470,644,'False',NULL),(1471,646,'True',1),(1472,646,'False',NULL),(1473,647,'True',1),(1474,647,'False',NULL),(1475,648,'True',1),(1476,648,'False',NULL),(1477,649,'Self- disclosure',NULL),(1478,649,'Giving or receiving significant gifts',NULL),(1479,649,'Becoming friends',NULL),(1480,649,'Physical Contact',NULL),(1481,649,'All of the above',1),(1492,650,'An injury resulting from a fall',NULL),(1493,650,'A break in procedure',NULL),(1494,650,'Suicide attempt or gesture',NULL),(1495,650,'All of the above',1),(1496,651,'True',1),(1497,651,'False',NULL),(1498,652,'True',1),(1499,652,'False',NULL),(1500,653,'Risk Manager',NULL),(1501,653,'Any Employee',1),(1502,653,'Clinical Director',NULL),(1503,654,'Yes',NULL),(1504,654,'No',1),(1507,655,'True',1),(1508,655,'False',NULL),(1509,656,'True',1),(1510,656,'False',NULL),(1511,657,'True',1),(1512,657,'False',NULL),(1513,658,'Discussing client issues only in private areas',NULL),(1514,658,'Requiring written authorization before releasing information',NULL),(1515,658,'Not utilizing client last names in public areas or medical record file covers',NULL),(1516,658,'All of the above.',1),(1517,659,'Health Information Property Accountability Association',NULL),(1518,659,'Human Insurance Process Accumulation Act',NULL),(1519,659,'Health Insurance Portability and Accountability Act',1),(1520,660,'Security',NULL),(1521,660,'Privacy',1),(1522,660,'Confidentiality',NULL),(1523,661,'Electronic Medical Record ',NULL),(1524,661,'Security ',NULL),(1525,661,'HITECH',1),(1526,661,'HHS',NULL),(1527,662,'Medical record number',NULL),(1528,662,'Telephone number',NULL),(1529,662,'Fax number',NULL),(1530,662,'Social security number',NULL),(1531,662,'All of the above',1),(1532,662,'a, b, d',NULL),(1533,663,'Disciplinary action',NULL),(1534,663,'Loss of access privileges',NULL),(1535,663,'Fines and penalties',NULL),(1536,663,'Imprisonment',NULL),(1537,663,'All of the above',1),(1538,664,'Yes',NULL),(1539,664,'No',1),(1540,665,'Yes, if he is an employee and you know him.',NULL),(1541,665,'Yes, if your manager says that it’s okay.',NULL),(1542,665,'No, sharing log-in IDs and passwords is a security violation.',1),(1543,665,'a and b',NULL),(1544,666,'I am only expected to complete the minimum requirements of my job.',NULL),(1545,666,' A workforce member\'s access to PHI is limited to only what is needed to perform his/her responsibilities.',NULL),(1546,666,'Requests for and disclosures of PHI are limited to what is needed to perform the task.',NULL),(1547,666,'A medical center is no longer allowed to provide information about patients to the media under any circumstances.',NULL),(1548,666,'b and c',1),(1549,667,'Yes.  They can be used interchangeably.',NULL),(1550,667,'No.  Consents are used to get the patient\'s permission to use or disclose health information for     treatment, payment or business operations. Authorizations are used to obtain permission to disclose PHI for activities outside the realm of treatment, payment or business operations.',1),(1551,668,'True',1),(1552,668,'False',NULL),(1553,669,'True',1),(1554,669,'False',NULL),(1555,670,'True',1),(1556,670,'False',NULL),(1557,671,'True',NULL),(1558,671,'False',1),(1561,673,'True',1),(1562,673,'False',NULL),(1563,674,'Management of Safe Devices and Systems.',NULL),(1564,674,'Maintenance and Storage of Devices and Systems.',NULL),(1565,674,'Material Safety Data Sheets.',1),(1566,674,'Management, Storage and Distribution of Substances.',NULL),(1567,675,'Tornado',NULL),(1568,675,'Medical',NULL),(1569,675,'Bomb',1),(1570,675,'Patient Emergency',NULL),(1571,676,'Code Hot',NULL),(1572,676,'Code Red',1),(1573,676,'Code Fire',NULL),(1574,677,'Code Yellow',NULL),(1575,677,'Code Grey',1),(1576,677,'Code Purple',NULL),(1577,677,'Code Pink',NULL),(1582,679,'Read, Act, Collect, Evacuate',NULL),(1583,679,'Read, Ask, Confine, Extinguish',NULL),(1584,679,'Rescue/Remove from danger, Alert/Alarm, Confine/Contain, Extinguish/Evacuate',1),(1585,680,'True',1),(1586,680,'False',NULL),(1591,682,'During a Fire Marshall\'s inspection.',NULL),(1592,682,'During a Code Blue.',NULL),(1593,682,'During times of renovation or construction if fire safety is significantly compromised.',1),(1594,683,'True',1),(1595,683,'False',NULL),(1596,684,'True',1),(1597,684,'False',NULL),(1598,685,'True',1),(1599,685,'False',NULL),(1608,688,'Outside lighting',NULL),(1609,688,'Alarm system',NULL),(1610,688,'Employee picture ID badges',NULL),(1611,688,'All of the above.',1),(1612,689,'True',1),(1613,689,'False',NULL),(1614,690,'True',NULL),(1615,690,'False',1),(1616,691,'Gloves',1),(1617,691,'Mask Goggles',NULL),(1618,691,'Gowns',NULL),(1619,691,'All of the above.',NULL),(1620,692,'Call your supervisor.',NULL),(1621,692,'Call 911',NULL),(1622,692,'Put on gloves, wipe up spill (utilize Spill Kit) then disinfect with an EPA           registered disinfectant and/or a 1:10 sodium hypochlorite (bleach) solution.       ',1),(1623,693,'True',1),(1624,693,'False',NULL),(1625,694,'True',1),(1626,694,'False',NULL),(1627,695,'True',1),(1628,695,'False',NULL),(1629,696,'True',1),(1630,696,'False',NULL),(1631,697,'True',NULL),(1632,697,'False',1),(1633,698,'True',NULL),(1634,698,'False',1),(1637,700,'True',1),(1638,700,'False',NULL),(1639,701,'True',1),(1640,701,'False',NULL),(1647,26,'True',1),(1648,26,'False',NULL),(1649,48,'a) Sudden shift in mood or behavior',NULL),(1650,48,'b) Skin rash',NULL),(1651,48,'c) Muscle weakness',NULL),(1652,48,'d) Confusion',NULL),(1653,48,'a, c, and d ',1),(1659,88,'a) Airborne',NULL),(1660,88,'b) Droplet',NULL),(1661,88,'c) Contact',1),(1662,88,'A and B',NULL),(1668,79,'a) Viruses',NULL),(1669,79,'b) Parasites',NULL),(1670,79,'c) Bacteria',NULL),(1671,79,'d) Fungus',NULL),(1672,79,'All of the above',1),(1673,75,'a) Wear protective gloves',NULL),(1674,75,'b) Run away from spill in order to not get contaminated ',NULL),(1675,75,'c) Use a 1:100 or 1:10 bleach based dilution to decontaminate surfaces ',NULL),(1676,75,'d) A and B',NULL),(1677,75,'e) A and C',1),(1678,80,'a) Air',NULL),(1679,80,'b) Water',NULL),(1680,80,'c) Bodily fluids',NULL),(1681,80,'d) A and B',1),(1682,80,'e) A and C',NULL),(1683,74,'a) Gloves, gowns, respirators',NULL),(1684,74,'b) Face masks, goggles, face shields',NULL),(1685,74,'c) Shoes and socks',NULL),(1686,74,'d) A and B',1),(1687,74,'e) A and C',NULL),(1688,599,'True',NULL),(1689,599,'False',1),(1694,619,'Losing your job',NULL),(1695,619,'Prison time',NULL),(1696,619,'Legal issues',NULL),(1697,619,'All of the above',1),(1698,629,'True',NULL),(1699,629,'False',1),(1700,601,'Only A',NULL),(1701,601,'Only A and B',NULL),(1702,601,'Only B',NULL),(1703,601,'A, B and C',1),(1708,681,'Type A extinguisher',NULL),(1709,681,'Type A and B extinguisher',NULL),(1710,681,'Type B extinguisher',NULL),(1711,681,'Type A, B and C extinguisher',1),(1712,678,'True',NULL),(1713,678,'False',1),(1714,615,'a) Native Americans',NULL),(1715,615,'b) Asian',NULL),(1716,615,'c) Indian',NULL),(1717,615,'A and B',1),(1718,672,'True',1),(1719,672,'False',NULL),(1720,686,'Code Red',NULL),(1721,686,'Code Purple',NULL),(1722,686,'Code White',1),(1723,686,'Code Green',NULL),(1724,699,'Casual contact or contact with toilet seats, doorknobs, etc.',NULL),(1725,699,'Exposure to blood/body fluids by percutaneous exposure (needlesticks) and/or mucous membrane (mouth or eye) exposures.',1),(1726,687,'Ben Brafman',NULL),(1727,687,'Harvey Glotzer',NULL),(1728,687,'Andrew Merker',1),(1729,687,'Scott Smith',NULL),(1730,643,'True',1),(1731,643,'False',NULL),(1737,702,'Physical relapse',NULL),(1738,702,'Emotional relapse',NULL),(1739,702,'Mental relapse',NULL),(1740,702,'A & B',NULL),(1741,702,'All of the above',1),(1742,704,'Lying',NULL),(1743,704,'Fantasizing about using',NULL),(1744,704,'Mood swings',1),(1745,704,'Hanging out with old using friends',NULL),(1750,706,'Preparation',NULL),(1751,706,'Action',NULL),(1752,706,'Maintenance',1),(1753,706,'Contemplation',NULL),(1754,707,'True',NULL),(1755,707,'False',1),(1756,707,'Maintenance',NULL),(1757,708,'True',1),(1758,708,'False',NULL),(1759,708,'Maintenance',NULL),(1760,709,'Involvement of parents in their children’s lives',NULL),(1761,709,'Clear rules of conduct are consistently enforced within the family',NULL),(1762,709,'Strong and positive family bonds',NULL),(1763,709,'All of the above',1),(1766,710,'True',NULL),(1767,710,'False',1),(1768,711,'Parental monitoring of children’s activities and peers',NULL),(1769,711,'Home environments where parents abuse substances or suffer mental illness',NULL),(1770,711,'Poor social coping skills',NULL),(1771,711,'Failure in school performance',NULL),(1772,711,'A & C',NULL),(1773,711,'B, C, & D',1),(1774,705,'Precontemplation',NULL),(1775,705,'Comtemplation',1),(1776,705,'Preparation',NULL),(1777,705,'Action',NULL),(1778,712,'Precontemplation',NULL),(1779,712,'Comtemplation',NULL),(1780,712,'Preparation',1),(1781,712,'Action',NULL),(1782,633,'A client placing feelings about others from their lives onto the counselor',NULL),(1783,633,'A client focusing on their feelings for the counselor',NULL),(1784,633,'A client transferring their feelings with the feelings of the counselor',NULL),(1785,633,'A client falling in love with the counselor',NULL),(1786,633,'All of the above',1),(1787,634,'A counselor sharing their personal feelings with their client',NULL),(1788,634,'A counselor experiencing an emotional connection beyond what is acceptable in the client-counselor relationship.',1),(1789,634,'A client focusing on their feelings for the counselor',NULL),(1790,634,'A counselor having a dual relationship with their client',NULL),(1791,634,'A client placing feelings about others from their lives onto the counselor',NULL),(1796,123,'Any area of the Incident Report Form not requiring a response specific to the incident must be marked as “N/A” (Not applicable).',NULL),(1797,123,'Incident Report Forms are always included in the client’s medical records on file. ',1),(1798,123,'All staff members of a service provider are required to document all unusual events that occur to either a patient and/or staff member on an Incident Report Form ',NULL),(1799,123,'Incident Report Forms are confidential reports ',NULL),(1800,137,'Unauthorized taking of personal assets',NULL),(1801,137,'Sale of the vulnerable adults home without their authorization',NULL),(1802,137,'Caregiver failing to provide appropriate food to vulnerable adult',NULL),(1803,137,'A and B',1),(1804,137,'B and C',NULL),(1805,713,'Antipsychotics',NULL),(1806,713,'Antidepressents',NULL),(1807,713,'Anxiolytics',NULL),(1808,713,'Mood stabilizers',NULL),(1809,713,'Acid nuetralizers',NULL),(1810,713,'A, B, C, D',1),(1811,714,'Drowsiness',NULL),(1812,714,'Blurred vision',NULL),(1813,714,'Rapid heartbeat',NULL),(1814,714,'skin rashes',NULL),(1815,714,'sensitivity to the sun',NULL),(1816,714,'Increased hunger',1),(1819,716,'MSG',NULL),(1820,716,'Sugar',NULL),(1821,716,'Tyramine',1),(1822,716,'Sodium sulphite',NULL),(1823,716,'Potassium Bromate',NULL),(1828,717,'True',1),(1829,717,'False',NULL),(1830,718,'Serax',NULL),(1831,718,'Tranxene',NULL),(1832,718,'Asendin',NULL),(1833,718,'Lithium',1),(1834,719,'Right client',NULL),(1835,719,'Right medication',NULL),(1836,719,'Right look',1),(1837,719,'Right dosage',NULL),(1838,719,'Right time',NULL),(1839,719,'Right route',NULL),(1840,720,'Contact nursing',NULL),(1841,720,'Contact Supervisor',NULL),(1842,720,'Fill ouit incident report',NULL),(1843,720,'Call 911',NULL),(1844,720,'A, B and C',1),(1845,721,'Verify the clients picture in Kipu',NULL),(1846,721,'Verify date of birth verbally from client',NULL),(1847,721,'Check under tongue of client',NULL),(1848,721,'A, and B',1),(1849,722,'Clients bill of rights',NULL),(1850,722,'Intake sheet',NULL),(1851,722,'The client doctrine of medication observation',NULL),(1852,722,'MOR sheet',1),(1853,723,'Verify dosage against MOR in Kipu.',NULL),(1854,723,'Staff and client initials in Kipu after observation.',NULL),(1855,723,'Staff member asks the client to repeat the words, alligator alley.',NULL),(1856,723,'Staff member takes out correct dosage and hands to client.',1),(1857,724,'Late night sales clerk',NULL),(1858,724,'Emergency room nurse',NULL),(1859,724,'Family doctor',1),(1860,724,'Taxi cab driver',NULL),(1865,726,'Being absent in office meetings',NULL),(1866,726,'Leaving work early',NULL),(1867,726,'Complaining about the boss',NULL),(1868,726,'Swearing at other employees',1),(1869,727,'Do not lead to violence, so no caution is required',NULL),(1870,727,'Do not lead to violence, but still require some caution',NULL),(1871,727,'Lead to violence but require minimal caution',NULL),(1872,727,'Lead to violence and require strong caution',1),(1873,728,'Administrative control',NULL),(1874,728,'Behavioral control',NULL),(1875,728,'Environmental control',1),(1876,728,'Personal protective control',NULL),(1877,729,'True',NULL),(1878,729,'False',1),(1879,730,'Report the incident immediately',1),(1880,730,'Let it pass since they dont really mean it',NULL),(1881,730,'Tell this person to back off',NULL),(1882,730,'Respond back with a threat of your own',NULL),(1883,731,'Confusion',NULL),(1884,731,'Frustration',NULL),(1885,731,'Blame',NULL),(1886,731,'Hostility',1),(1887,732,'Ignore it',NULL),(1888,732,'Politely guide the customer out of the establishment',NULL),(1889,732,'Signal a co-employee to call security',1),(1890,732,'Fight backwith a threat',NULL),(1891,733,'Inform security to keep an eye out for the person',1),(1892,733,'Fearfully keep it a secret',NULL),(1893,733,'Use the side entrance instead of the main door to avoid being seen',NULL),(1894,733,'Find a different place to hang out to avoid the person',NULL),(1895,734,'Panic! Grab all of your belongings and run towards the door',NULL),(1896,734,'Hide and keep away from the shooters view',1),(1897,734,'Pretend you have a weapon and are prepared to use it',NULL),(1898,734,'Yell at them that \"Large Marge sent ya\"',NULL),(1899,735,'Ben Brafman',NULL),(1900,735,'Andrew Merker',NULL),(1901,735,'Harvey Glotzer',NULL),(1902,735,'Scott Smith',1);

--
