-- MySQL dump 10.13  Distrib 8.0.44, for Linux (x86_64)
--
-- Host: localhost    Database: ceulocker
-- ------------------------------------------------------
-- Server version	8.0.44-0ubuntu0.22.04.1

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 `sys_help_bubbles`
--

DROP TABLE IF EXISTS `sys_help_bubbles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_help_bubbles` (
  `help_id` int NOT NULL AUTO_INCREMENT,
  `help_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `help_article` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `help_label` varchar(96) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `section` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint unsigned NOT NULL DEFAULT '1',
  `help_for_page` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`help_id`)
) ENGINE=InnoDB AUTO_INCREMENT=219 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_help_bubbles`
--

LOCK TABLES `sys_help_bubbles` WRITE;
/*!40000 ALTER TABLE `sys_help_bubbles` DISABLE KEYS */;
INSERT INTO `sys_help_bubbles` VALUES (1,'Click a provider to make it the active provider, click the trash can to remove it.  Active providers can not be removed.','','choose provider team to manage',NULL,1,0),(2,'Manage your team members.','','manage provider team members',NULL,1,0),(3,'REQUIRED - Please enter the full course description. For CEU providers, it is to your great benefit to provide as much information and detail as possible about the course you are holding. This field will also be searchable and the official approved courses calendar, providing you a method of getting more views on your approved course listing','','course description editor','provider course editor',1,0),(4,'OK','','course title field','provider course editor',1,0),(5,'REQUIRED - Please enter the website information/registration URL for this course, or your company website. This address will be a live link on the approved course calendar, providing you greater exposure and traffic to your course website. Double check to make sure it is a valid URL!','','website URL field','provider course editor',1,0),(6,'Automatic - This is the CEULocker ID for this course','','CEULID field','provider course editor',1,0),(7,'REQUIRED - Please enter the CEU requested for this course. Approval May or May Not be for full CEU Hours Requested.','','CEUs select fields','provider course editor',1,0),(8,'REQUIRED - Please enter the type of course: Didiactic/In-person, HomeStudy or Online','','course type','provider course editor',1,0),(9,'REQUIRED - Please Add as Many Dates &amp; Locations as Needed','','course dates','provider course editor',1,0),(10,'Please enter the sku/id that the CEU Provider uses to identify their Application','','provider internal ID','provider course editor',1,0),(11,'Only this account can view these notes','','private notes','provider course editor',1,0),(12,'REQUIRED - Please Add the Start and End Date for the Course at this Location','','course dates','provider course date form',1,0),(13,'REQUIRED - Please Add the Start and End Times for the Course at this Location. Times are 24 hour format eg 6am = 06:00 and 6pm = 18:00','','course times','provider course date form',1,0),(14,'REQUIRED - Please Add the Course Location.  Please fill out as precisely as possible for showing the Course Location on the Course Search Map.','','course times','provider course date form',1,0),(15,'REQUIRED - Please Add the Valid From and To Dates for the Course','','course dates - online/homestudy','provider course date form',1,0),(16,'The applications life cycle status {Draft, Submitted, In Review, Approved, Not Yet Approved, Declined }','https://help.ceulocker.com/portal/en/kb/articles/holders-entering-ceu-credit-into-dashboard','CEU Credit Event Status','',1,0),(17,'Date the application was created. ','','This CEU Credit Entry Created','',1,0),(18,'Date the application was last modified.','','This CEU Credit Entry Last Modified','',1,0),(19,'Full text description of the application','','CEU Approved Hours','',1,0),(20,'Date/time the application was approved by the organization.','','Date Approved','',1,0),(21,'The approval code/number issued by an organization for an approved application.','','Approval Number','',1,0),(22,'From date the Application is Approved by the Organization.','','Date Approved From','provider course editor',1,0),(23,'To date the Application is Approved by the Organization.','','Date Approved To','provider course editor',1,0),(24,'Date/Time the Holder began the course.','','Date You Started this CEU Credit','holder course editor',1,0),(25,'Date/Time the Holder completed the course.','','Date You Completed this CEU Credit','holder course editor',1,0),(26,'This is a dynamic choice, from the list of possible licensing categories they setup for the Organization spoke','','holderLicensing','holder course editor',1,0),(27,'This determines whether the approved course credit listing appears on the approved calendar of the organization you are submitting to. Turn this option off if you are holding a private course.','','','',1,0),(28,'It is in the Providers best interest to provide a short descriptive title for the uploaded PDF being attached. This will make it easier for administrators and reviewers to understand what supporting documentation you are supplying.','','','',1,0),(29,'This field will be used as the contact point for your approved course listing on the official calendar','','','',1,0),(30,'CEU Locker system fee credits are purchased by CEU providers as a method of supporting the development of the platform. One credit is needed for each application you are submitting. These credits are separate from any fees that an accrediting organization might charge for their review.','https://help.ceulocker.com/portal/en/kb/articles/system-fee-credits','','',1,0),(31,'Licensing buckets are designed to give you a visual understanding of your progress to fulfilling any lysing requirements in this profession.','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,0),(32,'This area outlines the number of continuing education credits that you have stored in your dashboard, which have not been assigned to a active licensing bucket','','','',1,0),(33,'This is where CEU holders add additional credit information to their dashboard. Credit entry can happen by two methods, 1) inputting a previously approved CEULid, or  2) entering course credit details manually for storage.','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,0),(34,'Reviewers can leave private comments that only the organizations administrator can see.','','','',1,0),(35,'Reviewers can leave public comments, that the administrator may choose to send out to the CEU Provider.','','','',1,0),(36,'OPTIONAL: Reviewers that are wishing to track their time spent on individual reviews, may record that information here','','','',1,0),(37,'Administrators may add approved CEULid numbers into any CEU Holder\'s Locker on a 1:1 basis.  The CEULid must have been approved by your Organization, but the CEU Holder\'s account does not need to be connected to your Organization.','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,0),(38,'The instant decision action is a short form version of the larger full scale, decision page. The results of action on this instant decision pop up are exactly the same, resulting in Approval, Not Yet Approved, or Denial status notifications being sent immediately.','','','',1,0),(39,'Fully approved decision status is an irreversible status change on a CEULid application. The CEU Provider is immediately notified via email and their dashboard of the approval, along with their Official Approval Seal. It is important for the administrator to double check the Approved From: and Approved To: dates on this form.','','',NULL,1,1),(40,'Crib Sheets supply the three main user groups connected to your organization, with critical downloadable information they can use to be successful in your platform. See examples here.','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,1),(41,'These instruction areas appear at the top of key areas for users connected to your organization. Please see additional instructions.','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,1),(42,'Text entered here by Administrators, is appended to the official email notifications sent to see your Providers. The text template areas allow you to enter repetitive text in one location, and have it added to all email notifications being sent out. Before a Final Decision is made in your Decision Center, you have the ability to modify this text template before the email is sent.','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,1),(43,'Licensing Buckets at the Administrative account level, provide your Organization with the ability to inform the professionals connected to your organization, about critical licensing requirements necessary.','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,1),(44,'The Credit Hour Calculations function, at the Administrative account level, provides a handy way of educating your professionals and the CEU providers, on the proper name, proper abbreviation, and method of calculation of credits used in your professional region.','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,1),(45,'Administrators can set up the various approval terms and bins, along with the fees, for CEU providers making submissions (and CEU Holders, if permitted)','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,1),(46,'Administrators can set up the various approval terms and bins, along with the fees, for CEU providers making submissions (and CEU Holders, if permitted)','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,1),(47,'Administrators are able to establish required questions for various user groups to answer when interacting with your platform','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,1),(48,'The Reviewer\'s Scale area of the Administrative Panel, allows you to establish one or more areas for your Reviewers to submit metrics on course credit applications','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,1),(49,'This area allows Administrators to establish the number of days provided a Reviewer to complete an individual CEUL review, before the review is marked URGENT on their dashboard. Additionally, the Reviewer Completion Threshold is the percentage of all assigned reviewers to a specific CEUL, that must be completed, before the application is moved onto the Decision Center.','','','',1,0),(50,'Change of an Organization\'s official name, requires secondary approval in CEU Locker. Please complete this form.','','','',1,0),(51,'An Organization\'s abbreviated name is used widely throughout CEU Locker. Abbreviation less than 8 characters is required in the system.','','','',1,0),(52,'Load your Organization\'s logo in square dimension sizing. Minimum 300px square.  JPG or PNG file format only.','','','',1,0),(53,'The official email address where all CEU Locker communication and messages will be sent. If desired, Finance only email address and additional blind copy addresses may be entered.','','','',1,0),(54,'This URL is the location where CEU providers and CU holders may obtain information about course credit approval requirements and licensing information on your website. Do not put the URL of your homepage or course calendar in this field.','','','',1,0),(55,'CEU Providers can manage Team Members that have access to their account assets.','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,1),(56,'Validated users connected to your Organization on the CEU Locker platform, can be researched here.','https://help.ceulocker.com/portal/en/kb/articles/admins-validated-users-connected-to-your-organization-on-the-ceu-locker-platform-can-be-researched-here','','',1,0),(57,'Promo Codes for a wide variety of uses can be generated here.','https://help.ceulocker.com/portal/en/kb/articles/admins-promo-codes-for-a-wide-variety-of-uses-can-be-generated-here','','',1,0),(58,'OPTIONAL: In some cases, organizations are required to track their own dedicated approval numbers. Those local approval numbers can be entered here and will be sent to the CEU provider. NOTE: 95% of all organizations use the unique CEULid number for their official approval.','','','',1,0),(59,'Stored ID','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,1),(60,'Manage emails in my profile','https://help.ceulocker.com/portal/en/kb/ceu-locker-support','','',1,1),(97,'How do I assign a course to  a Reviewer?','https://help.ceulocker.com/portal/en/kb/articles/admins-how-do-i-assign-a-course-to-a-reviewer','',NULL,1,0),(98,'How do  I remove a course from a Reviewer\'s Queue? ','https://help.ceulocker.com/portal/en/kb/articles/admins-how-do-i-remove-a-course-from-a-reviewer-s-queue','',NULL,1,0),(99,'ADMINS: How do I approve/deny a course application? ','https://help.ceulocker.com/portal/en/kb/articles/admins-how-do-i-approve-deny-a-course-application','',NULL,1,0),(103,'ADMINS: How Do I Add a Reviewer in my Admin Panel? ','https://help.ceulocker.com/portal/en/kb/articles/admins-how-do-i-add-a-reviewer-in-my-admin-panel','',NULL,1,0),(138,'Reviewer Scoring','https://help.ceulocker.com/portal/en/kb/articles/reviewers-how-do-i-complete-a-review-for-a-course-application-on-my-reviewer-dashboard','',NULL,1,1),(218,'What if i don\'t know the dates yet?','','','',1,0);
/*!40000 ALTER TABLE `sys_help_bubbles` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2026-01-23  5:03:56
