-- MySQL dump 10.13  Distrib 5.5.54, for Linux (i686)
--
-- Host: localhost    Database: scrivas
-- ------------------------------------------------------
-- Server version	5.5.54

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `pages`
--

DROP TABLE IF EXISTS `pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `info` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pages`
--

LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
INSERT INTO `pages` VALUES (1,'About','<h3>ABOUT US&nbsp;</h3>\r\n<p class=\"sub\">Scrivas is a privately held medical scribe company specializing in medical scribe services for hospital emergency departments, urgent cares, in-patient hospitalists, private practices.</p>\r\n<p class=\"sub\">&nbsp;</p>\r\n<h5>Commitment to</h5>\r\n<h3>SERVICE</h3>\r\n<h4>SERVICE IS OUR&nbsp;CORE&nbsp; PHILOSOPHY</h4>\r\n<p class=\"sub\">Scrivas is a premier medical scribe company, committed to serving our clients. We constantly exceed expectations, starting with the quality of our scribes, the responsiveness of our management team, and return on investment. <br /><br /></p>\r\n<p class=\"sub\">Scrivas\' service consistently produces improvements in physician productivity, charges, billing, and coding that surpasses nationally cited averages for scribe companies. <br /><br /></p>\r\n<p class=\"sub\">At Scrivas, we take the time to listen to our clients and customize a solution that is specific to each client\'s needs. <br /><br /></p>\r\n<p class=\"sub\">We recognize the importance of having a turn-key solution for your scribe needs, &nbsp;and our management team is always available to make adjustments in coverage, scheduling, or documentation.</p>'),(2,'Services','<p>&nbsp;</p>\r\n<!-- Services 2 -->\r\n<div id=\"services2\">\r\n<div class=\"container\">\r\n<div class=\"row\">\r\n<div class=\"col-md-12 content-head\" data-animated=\"0\">\r\n<div class=\"ico\"><img src=\"images/ico/16.png\" alt=\"\" /></div>\r\n<h3>Our Services</h3>\r\n<div class=\"sep\">&nbsp;</div>\r\n<p>Nunc nec urna quis est gravida facilisis integer vitae felis vel</p>\r\n</div>\r\n</div>\r\n<div class=\"row\" data-animated=\"0\">\r\n<div class=\"col-md-4 service-content service-content2\"><em> <img class=\"ico-current\" src=\"images/ico/17.png\" alt=\"\" /> <img class=\"ico-hover\" src=\"images/ico/17-hr.png\" alt=\"\" /> </em>\r\n<h4>Hwosl Oksoikd</h4>\r\n<p>Curabitur nulla odiog bibendum sit amet facde nl ipsum lobortis id justo donlec sollicdLorem ipsum dolor sit ad et consectetur adipisicing elit sed.</p>\r\n</div>\r\n<div class=\"col-md-4 service-content service-content2\"><em> <img class=\"ico-current\" src=\"images/ico/18.png\" alt=\"\" /> <img class=\"ico-hover\" src=\"images/ico/18-hr.png\" alt=\"\" /> </em>\r\n<h4>Uowkdo Okspokdo</h4>\r\n<p>Curabitur nulla odiog bibendum sit amet facde nl ipsum lobortis id justo donlec sollicdLorem ipsum dolor sit ad et consectetur adipisicing elit sed.</p>\r\n</div>\r\n<div class=\"col-md-4 service-content service-content2\"><em> <img class=\"ico-current\" src=\"images/ico/19.png\" alt=\"\" /> <img class=\"ico-hover\" src=\"images/ico/19-hr.png\" alt=\"\" /> </em>\r\n<h4>Yutyos Oksokwo</h4>\r\n<p>Curabitur nulla odiog bibendum sit amet facde nl ipsum lobortis id justo donlec sollicdLorem ipsum dolor sit ad et consectetur adipisicing elit sed.</p>\r\n</div>\r\n</div>\r\n<div class=\"row\" data-animated=\"0\">\r\n<div class=\"col-md-4 service-content service-content2\"><em> <img class=\"ico-current\" src=\"images/ico/20.png\" alt=\"\" /> <img class=\"ico-hover\" src=\"images/ico/20-hr.png\" alt=\"\" /> </em>\r\n<h4>Lorem Ipsum</h4>\r\n<p>Curabitur nulla odiog bibendum sit amet facde nl ipsum lobortis id justo donlec sollicdLorem ipsum dolor sit ad et consectetur adipisicing elit sed.</p>\r\n</div>\r\n<div class=\"col-md-4 service-content service-content2\"><em> <img class=\"ico-current\" src=\"images/ico/21.png\" alt=\"\" /> <img class=\"ico-hover\" src=\"images/ico/21-hr.png\" alt=\"\" /> </em>\r\n<h4>Curabitur nulla</h4>\r\n<p>Curabitur nulla odiog bibendum sit amet facde nl ipsum lobortis id justo donlec sollicdLorem ipsum dolor sit ad et consectetur adipisicing elit sed.</p>\r\n</div>\r\n<div class=\"col-md-4 service-content service-content2\"><em> <img class=\"ico-current\" src=\"images/ico/22.png\" alt=\"\" /> <img class=\"ico-hover\" src=\"images/ico/22-hr.png\" alt=\"\" /> </em>\r\n<h4>Vlobortis id justo</h4>\r\n<p>Curabitur nulla odiog bibendum sit amet facde nl ipsum lobortis id justo donlec sollicdLorem ipsum dolor sit ad et consectetur adipisicing elit sed.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>'),(3,'Why Use Scribes','<p>&nbsp;</p>\r\n<!-- About Info -->\r\n<div id=\"about2\">\r\n<div class=\"container\">\r\n<div class=\"row\">\r\n<div class=\"col-md-12 content-head\" data-animated=\"0\">\r\n<div class=\"text-sep\">We Build Trust</div>\r\n<h3>Why Use Scribes</h3>\r\n<div class=\"sep\">&nbsp;</div>\r\n<p class=\"sub\">There are many reasons why physicians and medical providers choose to bring medical scribes into their facilities. A well trained scribe will undoubtedly increase efficiency, reimbursement, compliance and patient satisfaction.</p>\r\n</div>\r\n</div>\r\n<div class=\"row\"><!-- Tab Content -->\r\n<div class=\"col-md-5 tab-side\">\r\n<ul id=\"myTab\" class=\"nav nav-tabs\">\r\n<li class=\"active\"><a class=\"i-div\" href=\"#service-one\" data-toggle=\"tab\"> Efficiency </a></li>\r\n<li><a class=\"a-div\" href=\"#service-two\" data-toggle=\"tab\"> Reimbursement </a></li>\r\n<li><a class=\"w-div\" href=\"#service-three\" data-toggle=\"tab\"> Compliance </a></li>\r\n<li><a class=\"t-div\" href=\"#service-four\" data-toggle=\"tab\"> Satisfaction </a></li>\r\n</ul>\r\n<div id=\"myTabContent\" class=\"tab-content\">\r\n<div id=\"service-one\" class=\"tab-pane fade in active\">\r\n<h4>Improvements</h4>\r\n<ul class=\"list\">\r\n<li>Two-thirds of a primary care physician\'s day is spent on clerical work that could be done by someone else, according to Health Affairs Journal. This leads to an unfortunate decrease in the productivity of a doctor.</li>\r\n<li>Scribes significantly increase physician productivity and save an average of three minutes per visit and typically accommodate four extra patients per day.</li>\r\n<li>With productivity improvements alone, the return on investment of our scribe program is typically three to four times the investment.</li>\r\n</ul>\r\n<h4>Role of the Scribe</h4>\r\n<ul class=\"list\">\r\n<li>Scribes are the interface between an EMR and a physician. They are not just a transcriptionist. Their role as physician assistant reduces the burden of complying with documentation.</li>\r\n<li>A scribe guides the process of completing a thorough EMR record for each patient encounter. This is a sample of some typical scribe tasks:\r\n<ul class=\"list\">\r\n<li>Document +/- elements of history and physical exam</li>\r\n<li>Document vital signs</li>\r\n<li>Keep track of lab values and radiology results</li>\r\n<li>Pull pertinent past medical records</li>\r\n<li>Enter discharge information</li>\r\n<li>Compose work excuse notes</li>\r\n<li>Write prescriptions and orders to be signed off by physician</li>\r\n<li>Document when consultants are paged and call back</li>\r\n<li>Enter findings from re-exams</li>\r\n<li>Filter interruptions from support staff and phone calls</li>\r\n</ul>\r\n</li>\r\n</ul>\r\n<div class=\"space40\">&nbsp;</div>\r\n<!--a href=\"#\" class=\"btn1 border-black\">View our Work</a--></div>\r\n<div id=\"service-two\" class=\"tab-pane fade\">\r\n<h4>Practice/ED Metrics</h4>\r\n<ul class=\"list\">\r\n<li>Improve patient throughput and \"time to doctor\"</li>\r\n<li>Improve Patient Satisfaction scores</li>\r\n<li>Decrease the patients who \"left without being seen\"</li>\r\n<li>Improve Hospital Consumer Assessment of Healthcare Providers &amp; System scores</li>\r\n<li>Increase in office staff productivity</li>\r\n</ul>\r\n<h4>Revenue Capture</h4>\r\n<ul class=\"list\">\r\n<li>Improve coding/billing</li>\r\n<li>Decrease overtime physician hours - time spent completing charts at the end of shift</li>\r\n<li>Increase Relative Value Units</li>\r\n</ul>\r\n<div class=\"space40\">&nbsp;</div>\r\n<!--a href=\"#\" class=\"btn1 border-black\">View our Work</a--></div>\r\n<div id=\"service-three\" class=\"tab-pane fade\">\r\n<h4>Electronic Health Records</h4>\r\n<ul class=\"list\">\r\n<li>Completion of all required and recommended fields</li>\r\n<li>Capture and import laboratory/radiology results</li>\r\n<li>Document critical care</li>\r\n<li>Document conversations with consultants and PCPs</li>\r\n<li>Expand Medical Decision Making (MDM)</li>\r\n<li>CMS compliance with meaningful use Stages 1, 2, &amp; 3</li>\r\n<li>Prepare disposition and diagnosis</li>\r\n<li>Transition to ICD-10 implementation</li>\r\n</ul>\r\n<h4>Regulatory</h4>\r\n<ul class=\"list\">\r\n<li>Federal regulatory standards with regards to CMS and HIPAA</li>\r\n<li>Capture documentation of National Quality Measure outcomes</li>\r\n<li>Meaningful Use (medication reconciliation, family history and other criteria)</li>\r\n<li>PQRS reporting</li>\r\n<li>The Joint Commission (TJC) records compliance</li>\r\n</ul>\r\n<div class=\"space40\">&nbsp;</div>\r\n<!--a href=\"#\" class=\"btn1 border-black\">View our Work</a--></div>\r\n<div id=\"service-four\" class=\"tab-pane fade\">\r\n<h4>Focus on Patient Care</h4>\r\n<ul class=\"list\">\r\n<li>The objective of our scribe program is to help medical providers focus on medical care instead of documentation.</li>\r\n<li>Scribes afford the opportunity to engage in more interpersonal communication with the patient. Our scribes allow a doctor to sit down, make more eye contact, and convey other positive nonverbal cues to show the patient they are listening.</li>\r\n<li>Managing the workflows and keeping the physician more organized has a positive, indirect impact upon other staff. This gives way to a better work environment.</li>\r\n<li>Prepping the doctor before each encounter, reminding them of the particular patient&#146;s name and chief complaint, reassures the patient and conveys a message of physician engagement and interest.</li>\r\n<li>Verbalizing to the scribe what should be documented while the patient is present allows the opportunity for the patient to ask questions or seek clarification about their diagnosis and the plan for their care.</li>\r\n<li>Increase physician satisfaction in the workplace, and reduce burn-out by keeping the physician engaged in what they love to do &#150; being a physician, not a clerk.</li>\r\n</ul>\r\n<div class=\"space40\">&nbsp;</div>\r\n<!--a href=\"#\" class=\"btn1 border-black\">View our Work</a--></div>\r\n</div>\r\n</div>\r\n<!-- Tab Slider -->\r\n<div class=\"col-md-7\"><img class=\"img-responsive t-img1\" src=\"images/xtra/1.png\" alt=\"\" /> <img class=\"img-responsive t-img2\" src=\"images/xtra/2.png\" alt=\"\" /> <img class=\"img-responsive t-img3\" src=\"images/xtra/3.png\" alt=\"\" /> <img class=\"img-responsive t-img4\" src=\"images/xtra/4.png\" alt=\"\" /></div>\r\n</div>\r\n<!-- /.row --></div>\r\n</div>'),(4,'Why Outsource',''),(5,'Team',''),(6,'Training',''),(7,'Quality',''),(8,'Contact','');
/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scribes`
--

DROP TABLE IF EXISTS `scribes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scribes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `lname` varchar(200) NOT NULL,
  `email` varchar(300) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `scribes`
--

LOCK TABLES `scribes` WRITE;
/*!40000 ALTER TABLE `scribes` DISABLE KEYS */;
INSERT INTO `scribes` VALUES (8,'Javier','Figueroa','javi@backroompr.com'),(13,'asdf','asdf','asdf');
/*!40000 ALTER TABLE `scribes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'scrivas'
--

--
-- Dumping routines for database 'scrivas'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-02-04 11:00:39
