How to Report Course Completion Credits to the FDOH CE Tracking Database Rev. 1.85 - 11/14/2007 FDOH/CE Broker: How to Report Course Completion rev. 1.85 TABLE OF CONTENTS SECTION PAGE Table of Contents i Introduction 1–1 Option 1: Enter Course Completion Online 2–1 Option 2: Electronic Upload: Text File 3–1 Electronic File Format 3–4 Record Types 1 and 2 3–5 Record Type 3 3–6 Record Type 4 3–7 Record Types 5 and 6 3 – 10 Multiple Course Records 3 – 11 Option 3: Electronic Upload: Excel File 4–1 Electronic File Format 4–4 Record Types 1 and 2 4–5 Record Type 3 4–6 Record Type 4 4–7 Record Types 5 and 6 4–9 Multiple Course Records 4 – 10 Simplified Excel File Electronic File Format 4 – 11 Columns A, B, C, D, E, F, G, and H 4 – 12 Partial Credit Reporting for Multiple Licenses 4 – 13 Multiple Course Records 4 – 13 Option 4: Scan Card Submission 5–1 Appendix A: File Validation Errors 7–1 Pre-Import Inspection 7–1 File Validation (post submission) 7–5 Appendix B: Profession and Subject Area Codes © 2007 Information Systems of Florida 8–1 FDOH/CE Broker: How to Report Course Completion rev. 1.85 INTRODUCTION Welcome to the FDOH Continuing Education Database powered by CE Broker. Florida Statute 456.025(7) requires CE Providers approved by the Florida Department of Health to electronically submit CE course completion. A variety of electronic submission options are available to you, providing immediate feedback of the CE credit posted to licensee records. When submitting course completion, CE Providers attest that the Professional has completed the course. To report, CE Providers will need the following: the Professional's Florida DOH license number the Professional's last and first name (as listed on their Florida Department of Health license) the Course ID number or course publishing tracking number the Date Completed All course credit should be reported within ninety (90) days following completion by the licensee(s). Submissions over ninety (90) days are considered late. There are five options for submitting completed course credit; you may use one of the following or any combination, depending on what is best for your organization and program: Option 1: Option 2: Option 3: Option 4: Option 5: Online Entry of Course Completions Electronic File Upload using Text (*.TXT) files Electronic File Upload using Excel (*.XLS) files Scan Card Submission XML Web Services Does my course need to be in the FDOH database before I can report credit? Option 1 Do I need to publish my course before I can report course completions? Will I need technical help to submit hours? 1 Y2 N Y Y Y 1 2 N 3 Y Y Y Y 1 N 2 N Y Y Y 1 N2 Y Y Y Y 1 N Y Y Y Y Y Option 2 Y Option 3 Y Option 4 Y Option 5 Y Will there be an electronic roster for me to review? Will I be able to edit the information online? Will I get a message about my submission status? 1 Adding your course to CE Broker confers two benefits: (1) Some Boards/Councils require approval of a course before you can offer it to licensees, and this process is streamlined by the course addition procedure; and (2) It will tell CE Broker how your course’s hours will apply to a licensee’s transcript. It is simple to add your course to the FDOH database. The only information you need to supply is the title of the course, the type of course being offered (Live or Anytime), the hours that may apply to a licensee’s transcript when they complete the course, and any attachments required by the Boar/Council, if applicable. 2 You may publish a course before or after the date it begins, but you must publish before reporting course completions. When submitting course credits via electronic file upload or scan card, you are not required to publish your course. 3 Generating the text file for Options 2&3 involves some care and requires technical assistance to ensure that the data is properly organized (see technical information beginning on page 3-4). Each option, and the required file formatting, will be explored in greater detail in the following sections. © 2007 Information Systems of Florida 1–1 FDOH/CE Broker: How to Report Course Completion rev. 1.85 OPTION 1: ENTER COURSE COMPLETION ONLINE CE Broker provides a web interface for CE Providers to enter course completion data online directly into the FDOH CE Tracking Database. It’s important to remember that you must publish your course before you report credit online using this method. Once you have published your course, you may begin to enter course completions. For each “Live” course with a different Date Completed, you will have a different Publishing Tracking #. As a result, for all live courses with a different dates completed, you will have separate online rosters. You will need all Publishing Tracking #s (begin with 10-) for all courses you’d like to report, Florida DOH license numbers for all attendees (including both the alpha and numeric portions) and the Date Completed. For another way to view your Publishing Tracking #s, select INFORMATION UPDATE/ADDITIONS, COURSES and click SEARCH. On the left, you will see Course ID #s (begin with 20-) and on the right, click the VIEW link to see all publishings for each course. To access the ENTER COURSE COMPLETIONS screen, click COURSE COMPLETION from the menu bar and then select ENTER COURSE COMPLETIONS ONLINE from the dropdown menu. Type in the Publishing Tracking # of the course and click SEARCH. Brief course details and a blank roster will appear. Once you confirm the course name and dates are displayed correctly, enter the required information into the Course Credit Roster for each license number (Professional). As you enter data, screen messages will alert you, as the entry occurs, to license number format problems (such as an invalid number of digits). It is recommended that you do not enter names on this screen. Once you submit the Publishing Tracking # and license numbers for this roster, you will be able to view and edit an online version which will have pre-filled names matching the license numbers you entered. You only need to correct errors, not input information that is easily found by our system! Resubmit the roster with your corrections if there are errors. Note: Partial credit may be granted if allowed by the regulating Board/Council. Further information on partial credit is presented later in this section. The system will pre-fill the Date Completed for all “Live” courses to coincide with the last date of the course. If you are reporting an “Anytime” course type, the date completed must be entered manually. If you need to enter more than ten Licensees, Click ADDITIONAL LINES and another ten lines will be added to the roster. There is no limit to the number of Professionals for whom you can report. Don’t forget to click the SUBMIT NOW button when you have finished. © 2007 Information Systems of Florida 2–1 FDOH/CE Broker: How to Report Course Completion rev. 1.85 1. ENTER PUBLISHING TRACKING NUMBER HERE AND CLICK SEARCH. 2. CONFIRM THE COURSE DETAILS ARE CORRECT. 3. ENTER THE REQUIRED DATA FOR EACH PROFESSIONAL RECEIVING COURSE COMPLETION CREDIT. 4. IF YOU NEED MORE ENTRY SPACES, CLICK “ADDITIONAL LINES” FOR ANOTHER 10 LINES. Partial Credit Whether a particular Board/Council will accept partial credit is determined by individual Board/Council policy, not Florida Administrative Code rule or statute. Partial credit is reported when a licensee only completes some portion of the total hours offered. For example, if a Professional left halfway through an all-day program. If you offer an 8-hour course, of which 2 hours is HIV/AIDS and 6 hours is General, and your Board/Council accepts partial credit, you will be able to report partial credit up to the total of 2 hours for HIV/AIDS and 6 hours for General. Click the PARTIAL CREDIT link to the right of the Date Completed box and a new screen will appear listing the licensee name, license #, and each subject area approved for this course by profession(s). If the course was approved for more than one subject area, you will need to specify the subject area for which to report hours. The fields for total hours and subject area will be pre-filled with the number of hours accepted by the Board/Council for that course. Modify the total hours and hours for each subject area as needed. Hours reported for each subject area may not exceed the total hours (by subject area) for which the course was originally approved. © 2007 Information Systems of Florida 2–2 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Roster Summary You will receive a Roster Summary within one minute following submission of course completions online. This summary serves as your “receipt” and will indicate the date and time the roster was received, the number of lines received and the number of rejections, if any. Print it each time you submit a roster. THE DATE AND TIME THE ROSTER WAS RECEIVED THE NUMBER OF LINES RECEIVED THE NUMBER OF ENTRIES IN THIS POSTING THE NUMBER OF REJECTIONS Rejections may result for several reasons. For example, the license number of the Professional may not match the FDOH licensing database or if you enter a future date for the Date Completed, data will be rejected. If you’d like to verify licensing information in advance of reporting, please visit the MQA licensing information website at: http://ww2.doh.state.fl.us/irm00praes/praslist.asp Please see Appendix A for a complete listing of the different possible validation errors. Click the VIEW REJECT(S) link to open the processed roster and make necessary adjustments: “REJECTED” STATUS CODE OF THIS ROSTER ENTRY MAKE ADJUSTMENTS TO INVALID ENTRIES, IF NECESSARY. Rejected fields will appear in red until the roster is resubmitted. After making corrections, click SUBMIT NOW at the bottom of the screen. It’s important to remember that all license #s submitted successfully the first time will appear the second time as rejections because they are seen by the system as duplicates of previously reported credit. Once you have corrected and resubmitted your roster, the system will always maintain a history of the roster online, there is no need for you to keep records outside the system. © 2007 Information Systems of Florida 2–3 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Course Credit Worksheet Rosters with rejected entries will also appear on the Course Credit Worksheet tab of your Communication Center. This worksheet makes it easy for you to scan courses containing rejects by placing them in ascending chronological order by the Date Completed: CLICK THE PUBLISHING TRACKING # TO ACCESS THE PROCESSED ROSTER FOR THIS COURSE. SELECT THE DELETE CHECKBOX, THEN CLICK APPLY, TO REMOVE THIS ENTRY FROM THIS LIST. To make adjustments to processed roster, click on the Course Publishing Tracking # for the course in the first column. This will open the roster (pictured earlier) so you may make changes. When you resubmit, both the roster and worksheet will automatically update. If you have reviewed entries that were rejected and do not wish to make changes, select the beside the course entry on the Course Credit Worksheet and then the APPLY button. DELETE box Timing Out If you need to leave the computer during the process of inputting your course completion data, you are encouraged to submit your roster, even if you have not added all the attendees, yet. Provided the data passes pre-import inspection, it will be entered into the system. If you do not submit your roster and you are away from your computer for an extended time, the system will time out and you will lose any data you previously entered. After 45 minutes without user activity, the system will time out. You may submit additional attendees to the original roster the same way you would to report course completions in the first place. Click COURSE COMPLETION, then select ENTER COURSE COMPLETIONS ONLINE from the dropdown menu. At the Enter Course Completions screen, type in the Publishing Tracking # of the course for which you had posted a partial Roster and click SEARCH. Your roster will appear underneath the course details, and you may continue to enter attendees. Remember that data entered previously will be rejected as duplicates when you resubmit the roster. © 2007 Information Systems of Florida 2–4 FDOH/CE Broker: How to Report Course Completion rev. 1.85 OPTION 2: ELECTRONIC FILE UPLOAD — Text Files To accommodate the large variety of Florida CE Providers, CE Broker utilizes a common file format into which course registration data may be easily imported. Use of this electronic file enables CE Providers to transmit data without requiring CD-ROMs, diskettes, tapes, papers, etc. You will receive immediate feedback of reported course completions, as will course attendees. If subscribed, attendees will also receive a message in their CE Broker Communication Center To access the Upload Course Completion screen, go to the menu bar and click on COURSE COMPLETION. Then select UPLOAD COURSE COMPLETION from the dropdown menu. On the Upload Course Completion screen, you will see an input field for entering the location of your course completion data file: COURSE COMPLETION DATA FILE INPUT FIELD CLICK BROWSE TO LOCATE THE FILE YOU ARE UPLOADING TO THE CE BROKER SYSTEM. Click the BROWSE button to locate your file. Select the file and open it using the “Choose File” dialog box that appears (note: the dialog box may look different from the one shown, depending on your version of Windows): Once the path to your file appears in the file input field, click SUBMIT NOW to upload your file to CE Broker. CE Broker will then validate the data and process the CE credits. © 2007 Information Systems of Florida 3–1 FDOH/CE Broker: How to Report Course Completion rev. 1.85 You will receive a Roster Summary within one minute following submission of course completions online. This summary serves as your “receipt” and will indicate the date and time the roster was received, the number of lines received and the number of rejections, if any. Print it each time you submit a roster. THE DATE AND TIME THE ROSTER WAS RECEIVED THE NUMBER OF LINES RECEIVED THE NUMBER OF ENTRIES IN THIS POSTING THE NUMBER OF REJECTIONS Rejections may result for several reasons. For example, when the license number of the Professional could not be matched with the licensing database or when the date completed is a future date. To verify licensing information, visit the MQA licensing information website at: http://ww2.doh.state.fl.us/irm00praes/praslist.asp Please see Appendix A for a complete listing of the different possible validation errors. Next to the Number of Rejects will be a link to VIEW REJECT(S). Clicking it will open the Processed Roster for you to make any necessary adjustments: “REJECTED” STATUS CODE OF THIS ROSTER ENTRY MAKE ADJUSTMENTS TO INVALID ENTRIES, IF NECESSARY. Fields that have been rejected will appear in red until the roster is resubmitted. After making your corrections, click SUBMIT NOW at the bottom of the screen. Uploading Another File You can submit more attendees by following the same procedure used to upload course credits in the first place. Go to the menu bar and click on COURSE COMPLETION. Then select UPLOAD COURSE COMPLETION from the dropdown menu. At the Upload Course Completion screen, BROWSE to your new file, click OPEN, and then submit it. CE Broker will add any new entries to your previous submission. Any licensee already submitted for a publication will display as a reject. © 2007 Information Systems of Florida 3–2 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Course Credit Worksheet If you have published this course in CE Broker, you will be notified of rosters with rejected entries on the Course Credit Worksheet tab of your Communication Center. This Worksheet makes it easy for you to scan courses containing rejects by placing them in ascending chronological order by the course completion date: CLICK THE PUBLISHING TRACKING # TO ACCESS THE PROCESSED ROSTER FOR THIS COURSE. SELECT THE DELETE CHECKBOX, THEN CLICK APPLY, TO REMOVE THIS ENTRY FROM THIS LIST. To make adjustments to a course credit submission, click on the Course Publishing Tracking # for that course in the first column. This will open the Processed Roster (pictured earlier) on which you may make your changes. Resubmit this roster, and both this roster and your worksheet will automatically update. If you have reviewed the entries that rejected and do not wish to make changes, select the beside the course entry on the Course Credit Worksheet and then the APPLY button. DELETE box The technical discussion on the following pages will cover the actual format of the file containing your course completion credit data. You may wish to provide this document to your technical support personnel. © 2007 Information Systems of Florida 3–3 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Text File Format and Structure Text files ( “.txt” extension; for example, “CourseCompletionData.txt” ) can be created in any word processor or text editor. Do not use any special formatting or characters when creating this file. Enter the data in the proper positions as detailed below, and save as a “plain text” file. If you wish to learn how to employ Excel files, instead, their usage is discussed in Option 3 on page 4-1. The data contained within the text file should be organized in a table structure like the one shown here: 1 50- 123456789 Bay Medical Center 2 20- 1045 10- 178 12/03/2003 Infection Control 3 20- 1045 DN 123 John Smith 12/03/2003 004.0 3 20- 1045 DN 201 Jane Doe 12/03/2003 004.0 3 20- 1045 DN 321 Richard Roe 12/03/2003 004.0 5 20- 1045 0003 6 000001 000007 Note that there are a varying number of columns from row to row, but there will always be a minimum of FIVE rows. Each row represents a different record. They are: Row 1: Row 2: Row 3: Row 4: Row 5: Row 6: Provider Record Course Record (course name is optional) Attendee Record Partial Credit Record (optional) Course Control Record End of File (EOF) Record Each row, or record, must contain exactly 100 characters , divided according to the specific needs of the record type indicated. The next few pages contain detailed explanations for each of the mentioned record types, as well as a final example demonstrating a file that integrates information on multiple courses and attendees. © 2007 Information Systems of Florida 3–4 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Row 1: Record Type 1 (Provider Record) There is only one Provider Record per file. This table illustrates the FIVE columns needed for this record and the actual information that is required at each position: Character Position 1 2-4 5-13 14-93 94-100 Field Name Record Type CE Broker Provider Tracking # Prefix CE Broker Provider Tracking # Suffix Provider Name Spaces Data Type Numeric Numeric Numeric Character Character Length (Character Count) 1 3 9 80 7 Description Will always be “1” Will always be “50-” The digits after the CE Broker Provider Tracking # Prefix 1st 80 characters of Spaces Provider Name in CE Broker (Note: Blank spaces also count). In the following example of Record Type 1, you can see how the row has been structured according to the rules established above. The character positions are labeled in red. Note how “Bay Medical Center” takes up 18 of the allotted 80 characters for the fourth column (Provider Name). 1 2-4 5-13 14-93 94-100 1 50- 123456789 Bay Medical Center (blank) Row 2: Record Type 2 (Course Record) There will be at least one Course Record per file, but you may submit a file that contains data for multiple courses (more on that later). This table illustrates the EIGHT columns needed for this record and the actual information that is required at each position: Character Position 1 2-4 5-13 14-16 17-25 (optional) 26-35 36-85 (if anytime (optional) course then leave blank) Field Name Record Type CE Broker Course Tracking # Prefix CE Broker Course Tracking # Suffix CE Broker Course Publication Tracking # Prefix CE Broker Course Course Publication Publication End Date Tracking # Suffix Course Name Spaces Data Type Numeric Numeric Numeric Numeric Numeric Numeric Character Character Length (Char. Count) 1 3 9 3 9 10 50 15 Description Will always be “2” Will always be “20-” The digits Will always after the be “10-“ CE Broker Course Tracking # Prefix The digits after the CE Broker Publication Tracking # Prefix Format: mm/dd/ccyy 1st 50 characters of CE Broker approved course name. Spaces (example: 1/21/2004) 86-100 The following example illustrates Record Type 2: 1 2-4 5-13 14-16 17-25 26-35 36-85 86-100 2 20- 1045 10- 178 12/03/2003 Infection Control (blank) © 2007 Information Systems of Florida 3–5 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Row 3: Record Type 3 (Attendee Record) For each Course Record, there must be at least one Attendee Record. Attendee Records always follow the Course Record to which the licensee attended. If a licensee has more than one license and is receiving partial credit, their information must be entered twice. These two tables illustrate the TEN columns needed for this record and the actual information that is required at each position: Character Position 1 2-4 5-13 14-17 18-26 Field Name Record Type CE Broker Course Tracking # Prefix CE Broker Course Tracking # Suffix Licensee’s Profession Code Licensee’s License Number Data Type Numeric Numeric Numeric Character Numeric Length (Character Count) 1 3 9 4 9 Description Will always be “3” Will always be “20-” The digits after the CE Broker Course Tracking # Prefix. Character Position 27-46 (optional) 47-71 (optional) 72-81 82-86 (needed on- 87-100 ly if partial credit) Field Name First Name Last Name Date Completed CE Credit Hours Completed Spaces Data Type Character Character Numeric Numeric Character Length (Character Count) 20 25 10 5 14 Description Licensee’s First Name Licensee’s Last Name If course type is anytime, provide date. The License # assigned by PRAES is a 4+9 digit alphanumeric number. For organizational reasons, CE Broker has divided it into two parts: (same as in Record • Profession Code (first 4 characters) Type 2: Course • License Number (last 9 numbers) Record) Leave blank unless Spaces this row is followed by a Record Type 4 (partial credit), as it If course type is live will default to the and Column 17-25 hours approved by & Column 26-35 in Board and/or record type 2 are Council. utilized then this field is optional. If used, include If column 17-25 in leading zeroes. Ex: record type 2 was 008.0 – Licensee to not utilized, then receive 8 CE you must complete Credit Hours this column. 004.5 – Licensee to receive 4 ½ CE Format: Credit Hours. mm/dd/ccyy Must be less than the approved hours (example: for the course. 01/21/2004) The following example illustrates Record Type 3, with multiple attendees: 1 2-4 5-13 14-17 18-26 27-46 47-71 72-81 82-86 87-100 3 20- 1045 DN 123 John Smith 12/03/2003 (blank) (blank) 3 20- 1045 DN 201 Jane Doe 12/03/2003 (blank) (blank) 3 20- 1045 DN 321 Richard Roe 12/03/2003 (blank) (blank) © 2007 Information Systems of Florida 3–6 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Row 4: Record Type 4 (Partial Credit Record) An optional record, the Partial Credit Record is needed only when there are partial credits to be reported for a licensee. The Partial Credit Record will always follow the Attendee Record to which it pertains. First, input the total number of credit hours that the licensee actually completed in the Attendee Record. If the course was approved for only one subject area, that one subject area will simply receive the number of hours submitted in the Attendee Record. There is no need to do anything further. If the course was approved for more than one subject area, you will need to specify which subject area in which to post hours. The total of the hours reported by subject area must equal the partial credit specified in the credits completed entry of the Attendee Record. The hours for each subject area also may not exceed the hours in each subject area for which the course was originally approved (during the course addition process). Note: If the program detects a space in record type 4, it will ignore the remainder of the line. These tables illustrate the TWENTY-FIVE columns possible for this record and the actual information that is required at each position. Note: You will rarely use all these fields. More often than not, you will employ two or three code and hour pairs (see character positions 14-17, 18-19 and 20-24). Char. Position 1 2-4 Field Name Record Type Data Type 5-13 14-17 18-19 20-24 CE Broker CE Broker Profession Code Course Tracking Course Tracking # Prefix # Suffix Subject Area Partial Credit Hours completed Numeric Numeric Numeric Character Character Numeric Length (Char. Count) 1 3 9 4 2 5 Description Will always be “4” Will always be “20-” The digits after the CE Broker Course Tracking # Prefix. Consists of licensee’s 2- to 4letter Profession Code. Consists of licensee’s 2letter Subject Area Code. Include leading zeroes. Ex: 008.0 – Licensee to receive 8 CE Credit Hours 004.5 – Licensee to receive 4 ½ CE Credit Hours. (same as in Record Type 2: Course Record) Char. Position 25-28 29-30 31-35 Field Name Profession Code Subject Area Data Type Character Length (Char. Count) Description See Appendix B for appropriate codes. 40-41 42-46 Partial Credit Profession Code Hours completed Subject Area Partial Credit Hours completed Character Numeric Character Character Numeric 4 2 5 4 2 5 (same as 14-17) (same as 18-19) (same as 20-24) (same as 14-17) (same as 18-19) (same as 20-24) Char. Position 47-50 51-52 53-57 58-61 62-63 64-68 Field Name Profession Code Subject Area Partial Credit Profession Code Hours completed Subject Area Partial Credit Hours completed Data Type Character Character Numeric Character Character Numeric Length (Char. Count) 4 2 5 4 2 5 Description (same as 14-17) (same as 18-19) (same as 20-24) (same as 14-17) (same as 18-19) (same as 20-24) © 2007 Information Systems of Florida 36-39 3–7 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Char. Position 69-72 73-74 75-79 80-83 84-85 86-90 Field Name Profession Code Subject Area Partial Credit Profession Code Hours completed Subject Area Partial Credit Hours completed Data Type Character Character Numeric Character Character Numeric Length (Char. Count) 4 2 5 4 2 5 Description (same as 14-17) (same as 18-19) (same as 20-24) (same as 14-17) (same as 18-19) (same as 20-24) Char. Position 91-100 Field Name Spaces Data Type Character Length (Char. Count) 10 Description Spaces The Record Type 4 example below assumes a course was approved for the Registered Nurse profession with the following subject areas and hours breakdown: RNGN RNHA RNME (General) 14 (HIV/AIDS) 2 (Medical Errors) 2 Total Hours: 18 For illustrative purposes, the following record shows all three subject areas and their maximum hours. In such a case, it would be unnecessary to include a Partial Credit Record, since there is no partial credit to report. 1 2-4 5-13 14-17 18-19 20-24 25-28 29-30 31-35 36-39 40-41 42-46 91-100 4 20- 1045 RN GN 014.0 RN HA 002.0 RN ME 002.0 (blank) Now let’s look at it with Attendee Records included: 3 20- 1045 RN 123 John 4 20- 1045 RN 014.0 RN 3 20- 1045 RN 201 Jane Doe 12/03/2003 3 20- 1045 RN 321 Richard Roe 12/03/2003 009.0 (blank) 4 20- 1045 RN 006.0 RN 002.0 RN 001.0 (blank) GN GN Smith ME HA 12/03/2003 016.0 002.0 (blank) (blank) ME (blank) As you can see, John Smith completed 16 hours broken down in the accompanying Partial Credit Record into 14 hours of General and 2 hours of Medical Errors. Jane Doe completed the entire course for full credit and does not need a Partial Credit Record. Richard Roe just received 9 hours, having only finished 6 hours of General, 2 hours of HIV/AIDS, and 1 hour of Medical Errors. © 2007 Information Systems of Florida 3–8 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Partial Credit and Multi-License Reporting of Credit Once a licensee subscribes to CE Broker, they will have the ability to link their licenses on one account. The following example assumes that the licensee has subscribed and linked their licenses on one account. If a Registered Nurse is also a Clinical Social Worker, an additional Record Type 4 would be required to report the second profession’s hours. Although not required when full credit is being applied, with partial credit, the multi-license posting will not automatically occur. Hours for partial credit will post as the detail specifies – one license at a time. For example: 3 20- 1045 RN 4 20- 1045 RN 4 20- 1045 CN 321 Richard Roe 12/03/2003 009.0 (blank) GN 006.0 RN 002.0 RN 001.0 (blank) GN 009.0 HA ME (blank) Richard Roe will also receive 9 hours toward his second license in the General subject area. See Appendix B for a complete listing of profession and subject area codes. © 2007 Information Systems of Florida 3–9 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Row 5: Record Type 5 (Course Control Record) For each Course Record there must also be an accompanying Course Control Record. A Course Control Record always follows the attendee records of the course to which it pertains. This table illustrates the FIVE columns needed for this record and the actual information that is required at each position: Character Position 1 2-4 5-13 14-17 18-100 Field Name Record Type CE Broker Course Tracking # Prefix CE Broker Course Tracking # Suffix Number of Attendees Spaces Data Type Numeric Numeric Numeric Numeric Character Length (Char. Count) 1 3 9 4 83 Description Will always be “5” Will always be “20-” The digits after the CE Broker Course Tracking # Prefix Number of Licensees that attended course (matches number of Attendee Records) Spaces (same as in Record Type 2: Course Record) Include leading zeroes. Example: If there were 10 attendees, this field would be 0010. The following example illustrates Record Type 5: 1 2-4 5-13 14-17 18-100 5 20- 1045 0003 (blank) Row 6: Record Type 6 (“EOF” End of File Record) Always the last record in the file, there is only one EOF (End of File) record per file. This table illustrates the FOUR columns needed for this record and the actual information that is required at each position: Character Position 1 2-7 8-13 14-100 Field Name Record Type Total Number of Course Records in this file Total Number of records Spaces in this file Data Type Numeric Numeric Numeric Character Length (Char. Count) 1 6 6 87 Description Will always be “6” Total number of Course Records in this file. Total number of rows in- Spaces cluding the EOF record. Include leading zeroes, if applicable. Example: If there were a total of 3 Course Records in the file, this field would be 000003. Include leading zeroes, if applicable. Example: If there were a total of 22 records (or rows) in the file, this field would be 000022. The following example illustrates Record Type 6: 1 2-7 8-13 14-100 6 000001 000007 (blank) © 2007 Information Systems of Florida 3 – 10 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Files Containing Data for Multiple Courses You may also submit files containing course completion data for more than one course. In that event, your file must include a separate Course Record—as well as its accompanying Attendee Records and Course Control Record—for each course. For example: Depending on the program you use to generate this file, it will look far different than the examples shown above. More likely, it will resemble something like the following image taken from Windows Notepad: Note how some entries will abut each other because of their character positions in the record/row; therefore, it is of extreme importance that you double-check the information you have input before you upload this file to CE Broker, or else any validation errors will delay the processing of your roster. © 2007 Information Systems of Florida 3 – 11 FDOH/CE Broker: How to Report Course Completion rev. 1.85 OPTION 3: ELECTRONIC FILE UPLOAD — Excel Files To submit completed continuing education course credit, CE Providers do not need to use CE Broker’s Input Course Credits screen. To accommodate the large variety of Florida CE Providers, CE Broker utilizes a common file format into which course registration data may be easily imported. Use of this electronic file enables CE Providers to transmit their data without requiring CD-ROMs, diskettes, tapes, papers, etc. They will also receive immediate feedback of their credit hour postings. If subscribed, attendees will also receive a message in their Communication Center that their transcript has been updated. To access the Upload Course Completion screen, go to the menu bar and click on COURSE COMPLETION. Then select UPLOAD COURSE COMPLETION from the dropdown menu. At the Upload Course Completion screen, you will see an input field for entering the location of your course completion data file: COURSE COMPLETION DATA FILE INPUT FIELD CLICK BROWSE TO LOCATE THE FILE YOU ARE UPLOADING TO THE CE BROKER SYSTEM. Click the BROWSE button to locate your file. Select the file and open it using the “Choose File” dialog box that appears (note: depending on your version of Windows, the dialog box may look different from the one shown): Once the path to your file appears in the file input field, click SUBMIT NOW to upload your file to CE Broker. CE Broker will then validate the data and process the CE credits. © 2007 Information Systems of Florida 4–1 FDOH/CE Broker: How to Report Course Completion rev. 1.85 You will receive a Roster Summary within one minute following submission of course completions online. This summary serves as your “receipt” and will indicate the date and time the roster was received, the number of lines received and the number of rejections, if any. Print it each time you submit a roster. THE DATE AND TIME THE ROSTER WAS RECEIVED THE NUMBER OF LINES RECEIVED THE NUMBER OF ENTRIES IN THIS POSTING THE NUMBER OF REJECTIONS Rejections may result for several reasons. For example, when the license number of the Professional could not be matched with the licensing database or when the date completed is a future date. To verify licensing information visit the MQA licensing information website at: http://ww2.doh.state.fl.us/irm00praes/praslist.asp Please see Appendix A for a listing of all the different possible validation errors. Next to the Number of Rejects will be a link to VIEW REJECT(S). Clicking it will open the Processed Roster for you to make any necessary adjustments: “REJECTED” STATUS CODE OF THIS ROSTER ENTRY MAKE ADJUSTMENTS TO INVALID ENTRIES, IF NECESSARY. Fields that have been rejected will appear in red until the roster is resubmitted. After making your corrections, click SUBMIT NOW at the bottom of the screen. Uploading Another File You can submit more attendees by following the same procedure used to upload course credits in the first place. Go to the menu bar and click on COURSE COMPLETION. Then select UPLOAD COURSE COMPLETION from the dropdown menu. At the Upload Course Completion screen, BROWSE to your new file, click OPEN, and then submit it. CE Broker will add any new entries to your previous submission. Any licensee already submitted for a publication will display as a reject. © 2007 Information Systems of Florida 4–2 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Course Credit Worksheet If you have published this course in CE Broker, you will be notified of Rosters with rejected entries on the Course Credit Worksheet tab of your Communication Center. This Worksheet makes it easy for you to scan courses containing rejects by placing them in ascending chronological order by the course completion date: CLICK THE PUBLISHING TRACKING # TO ACCESS THE PROCESSED ROSTER FOR THIS COURSE. SELECT THE DELETE CHECKBOX, THEN CLICK APPLY, TO REMOVE THIS ENTRY FROM THIS LIST. To make adjustments to a course credit submission, click on the Course Publishing Tracking # for that course in the first column. This will open the Processed Roster (pictured earlier) on which you may make your changes. Resubmit this roster, and both this roster and your worksheet will automatically update. If you have reviewed the entries that rejected and do not wish to make changes, select the beside the course entry on the Course Credit Worksheet and then the APPLY button. DELETE box The technical discussion on the following pages will cover the actual format of the Excel file containing your course completion credit data. As illustrated on page 3-10 (in Option 2), text file entries will abut each other because of their character positions in the record/row; requiring extreme care in ensuring the proper placement and precision of the data being entered. Excel spreadsheets, on the other hand, have established column positions within which to organize your course completion information. These are noted in the following explanatory tables in the row labeled “Excel Position.” © 2007 Information Systems of Florida 4–3 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Excel File Format and Structure Excel files ( “.xls” extension; for example, “CourseCompletionData.xls” ) are created in Microsoft Excel. Do not use any special formatting or characters when creating this file. Simply enter the data in the proper positions as detailed below. If you wish to learn how to employ text files instead, their usage is discussed in Option 2 on page 3-1. The data contained in the Excel file should be organized in a table structure like the one shown here: 1 50- 123456789 Bay Medical Center 2 20- 1045 10- 178 12/3/2003 Infection Control 3 20- 1045 DN 123 John Smith 12/3/2003 4 3 20- 1045 DN 201 Jane Doe 12/3/2003 4 3 20- 1045 DN 321 Richard Roe 12/3/2003 4 5 20- 1045 3 6 1 7 Note that there are a varying number of columns from row to row, but there will always be a minimum of FIVE rows. Each row represents a different record. They are: Row 1: Row 2: Row 3: Row 4: Row 5: Row 6: Provider Record Course Record (course name is optional) Attendee Record Partial Credit Record (optional) Course Control Record End of File (EOF) Record Each row, or record, is allowed a maximum length of 100 characters, divided according to the specific needs of the record type indicated. The next few pages contain detailed explanations for each of the mentioned record types, as well as a final example demonstrating a file that integrates information on multiple courses and attendees. © 2007 Information Systems of Florida 4–4 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Row 1: Record Type 1 (Provider Record) There is only one Provider Record per file. This table illustrates the FOUR columns needed for this record and the actual information that is required at each position: Excel Position Column A Column B Column C Column D Field Name Record Type CE Broker Provider Tracking # Prefix CE Broker Provider Tracking # Suffix Provider Name Data Type Numeric Numeric Numeric Character Length (Character Count) 1 3 9 80 Description Will always be “1” Will always be “50-” The digits after the CE Broker Provider Tracking # Prefix 1st 80 characters of Provider Name in CE Broker (Note: Blank spaces also count). In the following example of Record Type 1, you can see how the row has been structured according to the rules established above. The excel positions are labeled in red. Note how “Bay Medical Center” takes up 18 of the allotted 80 characters for the fourth column (Provider Name). A B C D 1 50- 123456789 Bay Medical Center Row 2: Record Type 2 (Course Record) There will be at least one Course Record per file, but you may submit a file that contains data for multiple courses (more on that later). This table illustrates the SEVEN columns needed for this record and the actual information that is required at each position: Excel Position Column A Column B Column C Column D Column E (optional) Column F (leading zeroes are not required) — if column E is used then you must enter a course publication date, unless it is an anytime course. Column G (optional) Field Name Record Type CE Broker Course Tracking # Prefix CE Broker Course Tracking # Suffix CE Broker Course Publication Tracking # Prefix CE Broker Course Publication Tracking # Suffix Course Publication End Date Course Name Data Type Numeric Numeric Numeric Numeric Numeric Numeric Character Length (Char. Count) 1 3 9 3 9 10 50 Description Will always be “2” Will always be “20-” The digits after the CE Broker Course Tracking # Prefix Will always be “10-“ The digits after the CE Broker Publication Tracking # Prefix Format: mm/dd/ccyy 1st 50 characters of CE Broker approved course name. (example: 1/21/2004) The following example illustrates Record Type 2: A B C D E F G 2 20- 1045 10- 178 12/3/2003 Infection Control © 2007 Information Systems of Florida 4–5 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Row 3: Record Type 3 (Attendee Record) For each Course Record, there must be at least one Attendee Record. Attendee Records always follow the Course Record to which the licensee attended. If a licensee has more than one license and is receiving partial credit, their information must be entered twice. These two tables illustrate the NINE columns needed for this record and the actual information that is required at each position: Excel Position Column A Column B Column C Column D Column E Field Name Record Type CE Broker Course Tracking # Prefix CE Broker Course Tracking # Suffix Licensee’s Profession Code Licensee’s License Number Data Type Numeric Numeric Numeric Character Numeric Length (Character Count) 1 3 9 4 9 Description Will always be “3” Will always be “20-” The digits after the CE Broker Course Tracking # Prefix. Excel Position Column F (optional) Column G (optional) Column H (leading zeroes are not required) Column I (optional unless partial credit hours are being entered) (leading zeroes are not required) Field Name First Name Last Name Date Completed CE Credit Hours Completed Data Type Character Character Numeric Numeric Length (Character Count) 20 25 10 5 Description Licensee’s First Name Licensee’s Last Name If course type is anytime, provide date completed. The License # assigned by PRAES is a 4+9 digit alphanumeric number. For organizational reasons, CE Broker has divided it into two parts: (same as in Record • Profession Code (up to 4 characters) Type 2: Course • License Number (up to 9 numbers) Record) Leave blank unless this row contains partial credit for a single subject area course, as it will default to the hours approved by Board and/or If course type is live and Council. Column E & Column F in record type 2 are Leading zero are not required utilized then this field is Ex: optional 8 – Licensee to receive 8 CE Credit Hours If column E in record 4.5 – Licensee to receive 4 ½ CE type 2 was not utilized, Credit Hours. then you must complete Must be less than the approved this column. hours for the course. Format: mm/dd/ccyy (example: 1/21/2004) The following example illustrates Record Type 3, with multiple attendees: A B C D E F G H I 3 20- 1045 DN 123 John Smith 12/3/2003 (blank) 3 20- 1045 DN 201 Jane Doe 12/3/2003 (blank) 3 20- 1045 DN 321 Richard Roe 12/3/2003 (blank) © 2007 Information Systems of Florida 4–6 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Row 4: Record Type 4 (Partial Credit Record) An optional record, the Partial Credit Record is needed only when there are partial credits to be reported for a licensee. The Partial Credit Record will always follow the Attendee Record to which it pertains. First, input the total number of credit hours that the licensee actually completed in the Attendee Record. If the course was approved for only one subject area, that one subject area will simply receive the number of hours submitted in the Attendee Record. There is no need to do anything further. If the course was approved for more than one subject area, you will need to specify which subject area in which to report hours. The total of the hours reported by subject area must equal the partial credit specified in the credits completed entry of the Attendee Record. The hours for each subject area also may not exceed the hours in each subject area for which the course was originally approved (during the course addition process). These tables illustrate the TWENTY-FOUR columns possible for this record and the actual information that is required at each position. Note: You will rarely use all these fields. More often than not, you will employ two or three code and hour pairs (see column positions D, E and F). Excel Position Column A Column B Column C Column D Column E Column F Field Name Record Type CE Broker Course Tracking # Prefix CE Broker Course Tracking # Suffix Profession Code Subject Area Partial Credit Hours completed Data Type Numeric Numeric Numeric Character Character Numeric Length (Char. Count) 1 3 9 4 2 5 Description Will always be “4” Will always be “20-” The digits after the CE Broker Course Tracking # Prefix. Consists of licensee’s 2- to 4-letter Profession Code. Consists of licensee’s 2letter Subject Area Code. Leading zeroes are not required Ex: 8 – Licensee to receive 8 See Appendix B Credit Hours for appropriate 4.5 – Licensee to codes. receive 4 ½ Credit Hours. Column J Column K Column L (same as in Record Type 2: Course Record) Excel Position Column G Column H Column I Field Name Profession Code Subject Area Partial Credit Profession Code Hours completed Subject Area Partial Credit Hours completed Data Type Character Character Numeric Character Character Numeric Length (Char. Count) 4 2 5 4 2 5 Description (same as D) (same as E) (same as F) (same as D) (same as E) (same as F) Excel Position Column M Column N Column O Column P Column Q Column R Field Name Profession Code Subject Area Partial Credit Profession Code Hours completed Subject Area Partial Credit Hours completed Data Type Character Character Numeric Character Character Numeric Length (Char. Count) 4 2 5 4 2 5 Description (same as D) (same as E) (same as F) (same as D) (same as E) (same as F) © 2007 Information Systems of Florida 4–7 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Excel Position Column S Column T Column U Column V Column W Column X Field Name Profession Code Subject Area Partial Credit Profession Code Hours completed Subject Area Partial Credit Hours completed Data Type Character Character Numeric Character Character Numeric Length (Char. Count) 4 2 5 4 2 5 Description (same as D) (same as E) (same as F) (same as D) (same as E) (same as F) The Record Type 4 example below assumes a course was approved for the Registered Nurse profession with the following subject areas and hours breakdown: RNGN RNHA RNME (General) 14 (HIV/AIDS) 2 (Medical Errors) 2 Total Hours: 18 For illustrative purposes, the next record shows all three subject areas and their maximum hours. In this case, it would actually be unnecessary to include a Partial Credit Record, since there is none to report. A B C D E F G H I J K L 4 20- 1045 RN GN 14 RN HA 2 RN ME 2 RN ME 1 Now let’s look at it with Attendee Records included: 3 20- 1045 RN 123 John Smith 12/3/2003 16 4 20- 1045 RN GN 14 RN ME 2 3 20- 1045 RN 201 Jane Doe 12/3/2003 3 20- 1045 RN 321 Richard Roe 12/3/2003 9 4 20- 1045 RN GN 6 RN HA 2 As you can see, John Smith completed 16 hours broken down in the accompanying Partial Credit Record into 14 hours of General and 2 hours of Medical Errors. Jane Doe completed the entire course for full credit and does not need a Partial Credit Record. Richard Roe just received 9 hours, having only finished 6 hours of General, 2 hours of HIV/AIDS, and 1 hour of Medical Errors. Partial Credit and Multi-License Reporting of Credit Once a licensee subscribes to CE Broker, they will have the ability to link their licenses on one account. The following example assumes that the licensee has subscribed and linked their licenses on one account: If a Registered Nurse is also a Clinical Social Worker, an additional Record Type 4 would be required to report the second profession’s hours. Although not required when full credit is being applied, with partial credit, the multi-license posting will not automatically occur. Hours for partial credit will post as the detail specifies – one license at a time. For example, Richard Roe will also receive 9 hours toward his second license in the General subject area: 3 20- 1045 RN 321 Richard Roe 12/3/2003 9 4 20- 1045 RN GN 6 RN HA 2 4 20- 1045 CN GN 9 RN ME 1 See Appendix B for a complete listing of profession and subject area codes. © 2007 Information Systems of Florida 4–8 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Row 5: Record Type 5 (Course Control Record) For each Course Record there must also be an accompanying Course Control Record. A Course Control Record always follows the attendee records of the course to which it pertains. This table illustrates the FOUR columns needed for this record and the actual information that is required at each position: Excel Position Column A Column B Column C Column D Field Name Record Type CE Broker Course Tracking # Prefix CE Broker Course Tracking # Suffix Number of Attendees Data Type Numeric Numeric Numeric Numeric Length (Char. Count) 1 3 9 4 Description Will always be “5” Will always be “20-” The digits after the CE Broker Course Tracking # Prefix Number of Licensees that attended course (matches number of Attendee Records) (same as in Record Type 2: Course Record) Leading zeroes are not required. The following example illustrates Record Type 5: A B C D 5 20- 1045 3 Row 6: Record Type 6 (“EOF” End of File Record) Always the last record in the file, there is only one EOF (End of File) record per file. This table illustrates the THREE columns needed for this record and the actual information that is required at each position: Excel Position Column A Column B Column C Field Name Record Type Total Number of Course Records Total Number of records in this in this file file Data Type Numeric Numeric Numeric Length (Char. Count) 1 6 6 Description Will always be “6” Total number of Course Records in this file. Total number of rows including the EOF record. Leading zeroes are not required. Leading zeroes are not required. The following example illustrates Record Type 6: A B C 6 1 7 © 2007 Information Systems of Florida 4–9 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Files Containing Data for Multiple Courses You may also submit files containing course completion data for more than one course. In that event, your file must include a separate Course Record—as well as its accompanying Attendee Records and Course Control Record—for each course. Your Excel file will look far different than the previous examples shown. More likely, it will resemble this screenshot provided. Note: Column alignment is not important. © 2007 Information Systems of Florida 4 – 10 FDOH/CE Broker: How to Report Course Completion rev. 1.85 OPTION 3: ELECTRONIC FILE UPLOAD — Simplified Excel Files Simplified Excel File Format and Structure Excel files (“.xls” extension; for example, “CourseCompletionData.xls” ) are created in Microsoft Excel. Do not use any special formatting or characters when creating this file. Simply enter the data in the proper positions as detailed below. If you wish to learn how to employ text files instead, their usage is discussed in Option 2 on page 3-1. The data contained in the Simplified Excel file should be organized in a table structure like the one shown here: (required) (required)* Column A Column B 2486 (only used for partial credit) (optional) (required) Column C Column D Column E Column F Column G Column H 12056 abc1234 5892 RN123475 12/3/2004 GN 1 2486 12056 abc1234 5892 RN415678 12/3/2004 2486 12056 abc1234 5892 RN856974 12/3/2004 2486 12056 abc1234 5892 RN235619 12/3/2004 2486 12056 abc1234 5892 RN128888 12/3/2004 2486 12056 abc1234 5892 RN254962 12/3/2004 * Please note you must either enter the CE Broker Course Tracking Number Suffix or the CE Provider Course Number, only one of which is required. Column A : Column B : Column C : Column D : Column E : Column F : Column G : Column H : CE Broker Provider Number Suffix ( without 50-prefix) — required CE Broker Course Tracking Number Suffix (without 20-prefix) — required * CE Provider Course Number — required * CE Broker Course Publishing Tracking Number (without 10- prefix) — optional Florida Department of Health Licensee Number (alpha & numeric) — required Course Completion Date Subject Area Code — only used for partial credit CE Credit Hours Completed — only used for partial credit The next few pages contain detailed explanations for each of the mentioned columns, as well as a final example demonstrating a file that integrates information on multiple courses and attendees. © 2007 Information Systems of Florida 4 – 11 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Column A: CE Broker Provider Number Suffix (without 50-prefix) The CE Broker provider number is located on the organizational profile within your account in CE Broker. You need only enter the suffix of the CE Broker provider number. For Example: If your CE Broker Provider Number is 50-2486 you will enter 2486 in Column A. Column B: CE Broker Course Tracking Number Suffix (without 20-prefix) You need only enter the suffix of the CE Broker Course Tracking Number. For Example: If your CE Broker Course Tracking number is 20-12056 you will enter 12056 in Column B. Please note, if you have requested to be able to enter your own Provider course numbers in CE Broker you will utilize Column C. Column B will remain blank. Column C: CE Provider Course Number If you have requested to be able to enter your own Provider course numbers in CE Broker you will utilize Column C instead of Column B. You will enter the Provider course number you have associated with the course entered in CE Broker. Column D: CE Broker Course Publishing Tracking Number (without 10- prefix) – optional If you have published your courses in CE Broker and you choose to utilize this column you need only enter the suffix of the course publishing tracking number. For Example: If your CE Broker Course Publishing Tracking number is 10-5892 you will enter 5892 in Column D. It is not necessary to enter the course publishing tracking number suffix in this column. It is an optional field and can be left blank. Column E: Florida Department of Health Licensee Number (alpha & numeric) Enter the Florida Department of Health Licensee Number of the attendee. The license number must include both the alpha and numeric character. For Example: RN123475 A list of alpha rank codes by profession can be located in Appendix B: Profession and Subject Area Codes of this manual. Column F: Course Completion Date Enter the date the attendee completed the course Column G: Subject Area Code – only used for partial credit * There is no need to enter the subject area code for an attendee unless the attendee is receiving partial credit for the program. For Example: If the program was valid for 10hrs in the General (GN) subject area and you have an attendee that will only receive 5 hours credit, you will need to enter the subject area code GN in Column F and the number 5 in the CE Credit Hours Completed Column G. A list of subject area codes by profession can be located in Appendix B: Profession and Subject Area Codes of this manual. Column H: CE Credit Hours Completed – only used for partial credit * There is no need to enter the CE Credit Hours Completed for an attendee unless the attendee is receiving partial credit for the program. For Example: If the program was valid for 10hrs in the General (GN) subject area and you have an attendee that will only receive 5 hours credit, you will need to enter the subject area code GN in Column F and the number 5 in the CE Credit Hours Completed Column G. * Please note: If the program was valid for more than one subject area, and the attendee received partial credit in more than one subject area, you can add additional columns to accommodate the additional subject area codes (up to 8 total) and the completed hours. In the example below, columns I & J have been added to illustrate additional partial credit subject areas and hours completed. As you can see, licensee RN123475 will receive 1hr General (GN) and 1hr Medical Errors (ME). © 2007 Information Systems of Florida 4 – 12 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Example for Partial credit for more than one subject area: (required) (required)* (optional) (required) (only used for partial credit) Column A Column B Column C Column D Column E Column F Column G Column H Column I Column J 2486 12/3/2004 GN 1 ME 1 12056 5892 RN123475 Partial Credit Reporting for Multi-Licensed Attendee If a Registered Nurse is also a Clinical Social Worker, an additional row would be required to post the second profession’s hours. Although not required when full credit is being applied, with partial credit, the multi-license posting will not automatically occur. For example: this licensee will receive 1 hour toward their first license RN123475 and1 hour toward their second license SW23988 in the General subject area: (required) (required)* Column A Column B 2486 2486 (only used for partial credit) (optional) (required) Column D Column E Column F Column G Column H 12056 5892 RN123475 12/3/2004 GN 1 12056 5892 SW23988 12/3/2004 GN 1 Column C * Please note you must either enter the CE Broker Course Tracking Number Suffix or the CE Provider Course Number, only one of which is required. Files Containing Data for Multiple Courses You may also submit files containing course completion data for more than one course. For example: this file contains course completion information for 3 different courses. (required) (required)* Column A Column B 2486 (only used for partial credit) (optional) (required) Column D Column E Column F 12056 5892 RN123475 12/3/2004 2486 12056 5892 RN415678 12/3/2004 2486 22056 5892 RN856974 12/3/2004 2486 22056 5892 RN235619 12/3/2004 2486 59663 5892 RN128888 12/3/2004 2486 59663 5892 RN254962 12/3/2004 Column C Column G Column H * Please note you must either enter the CE Broker Course Tracking Number Suffix or the CE Provider Course Number, only one of which is required. © 2007 Information Systems of Florida 4 – 13 FDOH/CE Broker: How to Report Course Completion rev. 1.85 OPTION 4: SCAN CARD (OMR) SUBMISSION Scan Cards, also called Optical Mark Recognition (OMR), are named for the technology used to read and score the scan cards. While your course is required to be entered into the FDOH CE Tracking Database for Scan Card Submission, it does not need to be published. Currently, there is only one type of scan card used to record course completion data: Blank scan cards can be ordered directly from the FDOH or you can print scan cards directly from your account in CE Broker and they will be pre-filled with your Organization and course information. To order scan cards from the FDOH log into your account and go to INFORMATION UPDATES/ADDITIONS and select REQUEST SCAN CARDS from the drop down. To print scan cards from your account, go to COURSE COMPLETION and select GENERATE SCAN CARDS from the dropdown. A small example is pictured below, with a full-page version on a following page: Course completions submitted with scan cards will only be able to report one subject area. If you courses wish to grant credit for multiple subject areas in your courses, please use another method to report course completions. Since scan cards allow only one subject area per course, hours completed by an attendee will always apply to that subject area; thus, you would enter either full or partial credit into the same credit hours entry box on the scan card. Brief descriptions of some scan card data fields are on the following page, and a full-size sample scan card is on page 5-3. © 2007 Information Systems of Florida 5–1 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Scan card data fields include: Section A: Profession code (such as RN) and License number (a numeric value) Section B: Provider ID Number (the “50-“ number found by clicking on USERS, then selecting ORGANIZATION PROFILE and looking at the top of the profile) Section C: Course Number (the “20-“ number found under INFORMATION UPDATES/ADDITIONS, COURSES, then SEARCH) You may also use your own CE Provider Course Tracking Number if this has been indicated on your account. For those wishing to upload via text files, Excel spreadsheets or XML Web Services, this is a big change. There will be no need to store system Course ID #s or keep track of two sets of IDs. You will be able to use your own Course ID # to report course completions. Section D: Credit Hours If you print the scan cards from your account, this field will automatically populate with the number of hours you have entered for your course. The Credit Hours field contains a decimal point, which allows entry of course hours to a tenth of an hour. Because there is only one field for hours on a scan card, you may not report partial credit using the scan card unless the course was accepted for only one subject area. For instance, if the subject area was HIV/AIDS and the course was 4 hours long, you would be able to give partial credit for anything up to 4 hours. But if the course is an 8 hour course with 2 hours HIV and 6 hours General, it would be impossible for the system to identify whether the licensee completed the HIV or General portion or a combination of both. Entering partial credit online is a better option for reporting in this case. Section E: Course Ending Date If you print the scan cards from your account using the “10-“ Publishing Tracking Number , this field will automatically populate with the ending date of the course. After licensees complete scan cards during your program, mail them to CE Broker for processing: Florida Department of Health Division of Medical Quality Assurance CE Tracking Unit, Bin #C01 4052 Bald Cypress Way Tallahassee, FL 32399-3251 Once scan cards are successfully processed, you will receive a message in your CE Broker Communication Center that your online roster is available. Make adjustments the same way you would if you entered the information online. Scan cards that are successfully processed may create rejections based on the data entered. For example, the license # may not exist in the FL DOH database or may have been entered incorrectly, or the Course Number or Provider ID Number can’t be found. Cards that will not scan at all are either missing data in required fields or may be ripped or torn. CE Broker sends all rejected scan cards to the Florida DOH. © 2007 Information Systems of Florida 5–2 FDOH/CE Broker: How to Report Course Completion rev. 1.85 APPENDIX A: FILE VALIDATION ERRORS FOR TEXT OR XLS UPLOAD The FDOH CE Tracking Database implements two levels of validation on the course completion data submitted via text or XLS file upload by CE Providers: Pre-Import Inspection: During submission, before entry into the system File Validation: After submission and importation into the system Pre-Import Inspection These following error conditions will be validated before the attendance roster is imported. The file must pass all pre-import validations before the file will be accepted. If any of these error conditions exist, the file will be rejected and the first error will be reported to the entity who submitted the roster. Pre-Import Inspection Criteria Pre-Import Error Messages The File should not be empty (zero records) The File is Empty. The length of each record must be exactly 100 characters in length Record #: Incorrect Record Length: [Current Length] If column-one value different than (1,2,3,4,5,6) Record #: Invalid Record Type The File should have only one Provider record (Record Type 1) The File must contain only one Provider record. The File must have at least one Course record (Record Type 2) The File must have at least one Course record The File must have at least one Attendee record (Record Type 3) The File must have at least one Attendee record The File must have at least one Course Control record (Record Type 5) The File must have at least one Course Control record and must follow an attendee record (Record Type 3) or partial credit record (Record Type 4) The File should have only one End of File (EOF) record (Record Type 6) The File must contain only one End of File (EOF) record First Record in file should always be a Record Type 1 (Provider Record) Record 1: Expected Provider Record Second Record in file should always be a Record Type 2 (Course Record) Record 2: Expected Course Record Third Record in file should always be a Record Type 3 (Attendee Record) Record 3: Expected Attendee Record Last Record in file should always be an End of File Record #: Expected End of File (EOF) Record (EOF) record After a Course Control Record (Record Type 5), the next record must be a Course Record (Record Type 2) or an End of File (Record Type 6) Record #: Expected a Record Type 2 or Record Type 6 After an Attendee Record (Record Type 3), the next record must be an Attendee Record (Record Record #: Expected a Record Type 3 or Record Type 4 or Record Type 5 © 2007 Information Systems of Florida 7–1 FDOH/CE Broker: How to Report Course Completion Pre-Import Inspection Criteria rev. 1.85 Pre-Import Error Messages Type 3) or a Partial Credit Record (Record Type 4) or a Course Control Record (Record Type 4) After a Course Record (Record Type 2), the next record must be an Attendee Record (Record Type 3) Record #: Expected a Record Type 3 CE Broker Provider Tracking Number Prefix must be “50-“. Record 1: Expected “50-“ in columns 2 through 4. (CE Broker Provider Tracking Number Prefix) CE Broker Provider Tracking Number must be a numeric value (digits only) Record 1: CE Broker Provider Tracking Number Suffix must be numeric Provider Name is a required entry Record 1: Provider Name can not be blank Provider Name does not match the Name in CE Broker Record 1: Provider Name does not match the Name in CE Broker The Provider ID must match the provider logged into CE Broker The Provider ID does not exist or doesn’t match the ID of the logged Provider The CE Broker Course Tracking Number Prefix must be “20-“. Record 2: Expected “20-“ in columns 2 through 4 (CE Broker Course Tracking Number Prefix) CE Broker Course Tracking Number must be a numeric value (digits only) Record #: CE Broker Course Tracking Number Suffix must be numeric The Provider ID must match the COURSE:id_provider for the Course in the file Record #: The Course does not match the Provider [CE Broker Provider Tracking Number (prefix + suffix)] CE Broker Course Publication Tracking Prefix must Record 2: Expected “10-“ in columns 14 through 16 be “10-“. (CE Broker Course Publication Tracking Number Prefix) The Course must be APPROVED or EXPIRED in the COURSE_STATUS table based on COURSE:id_course (from the file). If EXPIRED, the Completion Date in the file must be prior to the Expiration Date. Record #: The Entered Course does not exist or is not Approved or the completed date is after the expiration date. CE Broker Course Publication Tracking Number must be a numeric value (digits only) Record #: CE Broker Course Publication Tracking Number Suffix must be numeric The CE Broker Course Publication must exist in PUBLISH_COURSE table Record #: The entered Course Publication does not exist: [Course Publication Id in file] The CE Broker Course Publication must be linked to the CE Broker Course Record #: The Entered Course Publication is not a publication for the entered course. Course Publication End Date is a required entry for Record #: Course Publication End Date can not be a LIVE Delivery Method. It is optional for an blank ANYTIME Delivery Method. Course Name is a required entry Record #: Course Name can not be blank Course Name does not match the Name in CE Broker Record #: Course Name does not match the Name in CE Broker. © 2007 Information Systems of Florida 7–2 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Pre-Import Inspection Criteria Pre-Import Error Messages The CE Broker Course Tracking Number in the Partial Credit Record must be the same as the preceding Record Type 2 Record #: The Course Number in the Attendee Record (Record Type 4) does not match the Course Number in the Course Record (preceding Record Type 2). Attendee’s Profession Code is a required entry Record #: Attendee’s Profession Code can not be blank Attendee’s License Number must be a numeric value (digits only) Record #: Attendee’s License Number must be numeric Date Completed must be entered in mm/dd/ccyy format Record #: Invalid Date Completed: [Date Completed] Optional Entry: CE Credit Hours Completed If entered, the format must be “xxx.x” Record #: Invalid Format [CE Credit Hours Completed in file] The CE Broker Course Tracking Number in the Course Control record must be the same as the preceding Record Type 2 Record #: The Course Number in the Course Control Record (Record Type 5) does not match the Course Number in the Course Record (preceding Record Type 2 record). The Number of Attendees must be numeric (digits only) and a length of 4 Record #: The Number of Attendees (Record Type 5) is missing or the field length is not equal 4 The sum of all attendees for a course do not equal the number of attendees Record #: The Number of Attendees (Record Type 5) do not equal the sum of attendees for this course [CE Broker Course Tracking Number (prefix + suffix)] The Total Number of Courses must be numeric (digits only) and a length of 6 Record #: The Total Number of Courses (Record Type 6) is missing or the field length is not equal 6 The Total Number of Records in file must be numeric (digits only) and a length of 6 Record #: The Total Number of Records (Record Type 6) is missing or the field length is not equal 6 The total number of course records (Record Type 6) do not equal the sum of Course Records (Record Type 2s) Record #: The total number of course records (Record Type 6) do not equal the sum of Course Records (Record Type 2s) The total number of records (Record Type 6) do not equal the sum of all records in file Record #: The total number of records (Record Type 6) do not equal the sum of records in file) CE Credit Hours Completed for a Partial Credit Record (Record Type 4) must be in the following format: “xxx.x” Record #: Invalid Format [Ce Credit Hours Completed in file] Do not allow submission of a Partial Credit Record (Record Type 4) for those Boards/Councils that do not allow partial credit Record#: Partial Credit is not allowed by the Board/Council for which the licensee is licensed For a Partial Credit Record (Record Type 4), the Record #: Missing Profession or Subject Area in © 2007 Information Systems of Florida 7–3 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Pre-Import Inspection Criteria Pre-Import Error Messages profession code and the Subject area code cannot be blank Partial Credit Record (Record Type 4) For Partial Credit Record (Record Type 4), the total hours submitted in the Record Type 3 should equal the sum of all hours submitted in the Record Type 4 Record #: The total hours in the Partial Credit Record (Record Type 4): [sum of hours] does not match with the Attendee Earned Hours: [hours submitted in Record Type 3] For a Partial Credit Record (Record Type 4), all profession codes must be the same Record #: More than one distinct profession in the same Partial Credit Record (Record Type 4) © 2007 Information Systems of Florida 7–4 FDOH/CE Broker: How to Report Course Completion rev. 1.85 File Validation (post-submission) These are data validations to ensure the integrity of the data submitted via text or XLS file upload. These errors are saved in the system after all roster records are imported. These errors appear on the roster marked with an “R” beside the rejected entries. The rejects will also appear in the Course Credit Worksheet tab of your Communication Center. File Validation Error Message An Attendee (License Number) must appear only once for each course publication Attendee cannot appear more than once for the same course publication If License Number (id_license) not found in USER_PROFILE This License Number not found on the DOH/MQA Licensing Database If any credit method other than <anytime>, then the Completed Date must be equal to the dt_end of the course publication Record #: End Date must be equal to the End date of the course publication:[Publication End Date] If CE Credit Hours Completed is not blank, the hours completed can not exceed the maximum number of course hours Completed hours cannot be greater than offered hours The profession of the attendee must be one of those tracked by CE Broker. Profession not being tracked by CE Broker The Subject Area code submitted for a Partial One or more Subject Area codes do not match the Credit Record must match a Subject Area code for Subject Area codes for the course the course Do not allow submission of a partial credit for those Boards/Councils that do not allow partial credit. © 2007 Information Systems of Florida Partial Credit is not allowed by the Board/Council for this licensee 7–5 FDOH/CE Broker: How to Report Course Completion rev. 1.85 APPENDIX B: PROFESSION AND SUBJECT AREA CODES When granting partial credit using the electronic file upload methods, refer to the chart contained in this section for the proper code combinations to enter in the required fields. This table is organized alphabetically by Board, and each Board section is broken down into four columns: Profession names FDOH-assigned profession codes Applicable subject areas CE Broker-assigned subject area codes Although the following Boards are also listed in the chart below, they do not currently allow partial credit: Optometry Psychology (partial credit allowed for “Concurrent Session” courses only) For the most part, subject areas are repeated from profession to profession, and where a code is not specified, it has already been listed earlier in the chart. Florida Board of Acupuncture Profession Rank Code Subject area Subject area code Acupuncturist AP HIV/AIDS HA End-of-Life & Palliative Health Care EP Medical Errors ME Laws & Rules of the Board LB Laboratory Test Findings FL Image Findings FI General GN Florida Board of Athletic Training Profession Rank Code Subject area Subject area code Athletic Trainer AL HIV/AIDS HA End-of-Life & Palliative Health Care EP Medical Errors ME Cardiopulmonary Resuscitation (CPR) and First Aid Training CF General GN Florida Board of Chiropractic Profession Rank Code Subject area Subject area code Chiropractic Physician CH HIV/AIDS HA Medical Errors ME Laws and Rules of the Board LB Risk Management RM General GN General (Acupuncture) AP General (Chemistry) CY © 2007 Information Systems of Florida 8–1 FDOH/CE Broker: How to Report Course Completion rev. 1.85 General (Laboratory Diagnosis) LD General (Microbiology) MY General (NeuroMuscular Diagnosis) NM Certified Chiropractic Physicians’ Assistant CI General (Nutrition) NT General (Pathology) PY General (Phlebotomy) PL General (Physiology) PH General (Physiotherapy) PS General (Principles or Practice of Chiropractic) PP General (Proprietary Drug Admin) PD General (Public Health) PB General (Spinal Anatomy) SA General (X-ray Technique or Interpretation) XR Ethics MX Record Keeping/Documentation and Coding NO HIV/AIDS HA Medical Errors ME General GN Florida Board of Clinical Laboratory Personnel Profession Rank Code Subject area Subject area code Clinical Laboratory Director DI HIV/AIDS HA Medical Errors ME Laws & Rules of the Board LB General GN General (Clinical Chemistry / UA / Toxicology) GC General (Andrology) NX General (Blood Banking) GO General (Blood Gas Analysis) GB General (Cytogenetics) GY General (Cytology) GG General (Histocompatibilty) GE General (Histology) GT General (Immunohematology) GI General (Molecular Pathology) GU General (Microbiology / Mycology / Parasitology) GM General (Hematology) GH General (Radioassay/Nuclear Medicine) GL © 2007 Information Systems of Florida 8–2 FDOH/CE Broker: How to Report Course Completion Clinical Laboratory Supervisor Clinical Laboratory Technician © 2007 Information Systems of Florida SU TC rev. 1.85 General (Embryology) NY General (Serology/Immunology) GS Supervision/Administration, Quality Control/Quality Assurance, and Safety SQ HIV/AIDS HA Medical Errors ME Laws & Rules of the Board LB General GN General (Clinical Chemistry / UA / Toxicology) GC General (Andrology) NX General (Blood Banking) GO General (Blood Gas Analysis) GB General (Cytogenetics) GY General (Cytology) GG General (Histocompatibilty) GE General (Histology) GT General (Immunohematology) GI General (Molecular Pathology) GU General (Microbiology / Mycology / Parasitology) GM General (Hematology) GH General (Radioassay/Nuclear Medicine) GL General (Embryology) NY General (Serology/Immunology) GS Supervision/Administration, Quality Control/Quality Assurance, and Safety SQ HIV/AIDS HA Medical Errors ME Laws & Rules of the Board LB General GN General (Clinical Chemistry / UA / Toxicology) GC General (Andrology) NX General (Blood Banking) GO General (Blood Gas Analysis) GB General (Cytogenetics) GY General (Cytology) GG General (Histocompatibilty) GE General (Histology) GT General (Immunohematology) GI 8–3 FDOH/CE Broker: How to Report Course Completion rev. 1.85 General (Molecular Pathology) GU General (Microbiology / Mycology / Parasitology) GM General (Hematology) GH General (Radioassay/Nuclear Medicine) GL General (Embryology) NY General (Serology/Immunology) GS Supervision/Administration, Quality SQ Control/Quality Assurance, and Safety Clinical Laboratory Technologist TN HIV/AIDS HA Medical Errors ME Laws & Rules of the Board LB General GN General (Clinical Chemistry / UA / Toxicology) GC General (Andrology) NX General (Blood Banking) GO General (Blood Gas Analysis) GB General (Cytogenetics) GY General (Cytology) GG General (Histocompatibilty) GE General (Histology) GT General (Immunohematology) GI General (Molecular Pathology) GU General (Microbiology / Mycology / Parasitology) GM General (Hematology) GH General (Radioassay/Nuclear Medicine) GL General (Embryology) NY General (Serology/Immunology) GS Supervision/Administration, Quality SQ Control/Quality Assurance, and Safety Florida Board of Clinical Social Work, Marriage & Family Therapy & Mental Health Consulting Profession Rank Code Subject area Subject area code Licensed Clinical Social Worker SW End-of-Life & Palliative Health Care EP Medical Errors ME Domestic Violence DV General GN General (Supervisory) – minimum 16 hour course GX Hypnosis HP General (Supervisory) SG © 2007 Information Systems of Florida 8–4 FDOH/CE Broker: How to Report Course Completion General (Administrative, Office Mgmt and Other Non-Clerical Skills) rev. 1.85 AD Professional Ethics & Boundary Issues BI Licensed Marriage and Family Therapist MT Sex Therapy ST Laws and Rules of the Board LB End-of-Life & Palliative Health Care EP Medical Errors ME Domestic Violence DV General GN General (Supervisory) – minimum 16 hour course GX Hypnosis HP General (Supervisory) SG General (Administrative, Office Mgmt and Other Non-Clerical Skills) AD Professional Ethics & Boundary Issues BI Licensed Mental Health Counselor MH Sex Therapy ST Laws and Rules of the Board LB End-of-Life & Palliative Health Care EP Medical Errors ME Domestic Violence DV General GN General (Supervisory) – minimum 16 hour course GX Hypnosis HP General (Supervisory) SG General (Administrative, Office Mgmt and Other Non-Clerical Skills) AD Professional Ethics & Boundary Issues BI Sex Therapy ST Laws and Rules of the Board LB Florida Board of Dentistry Profession Rank Code Subject area Subject area code Dentist DN HIV/AIDS HA End-of-Life & Palliative Health Care EP Medical Errors ME Domestic Violence DV General GN Cardiopulmonary Resuscitation CR Anesthesia Related AG Management of Medical Emergencies MM Advanced Cardiac Life Support (ACLS) © 2007 Information Systems of Florida VO 8–5 FDOH/CE Broker: How to Report Course Completion Dental Hygienist DH rev. 1.85 Advanced Trauma Life Support (ATLS) BC Pediatric Advanced Life Support (PALS) BD Practice Management KM HIV/AIDS HA End-of-Life & Palliative Health Care EP Medical Errors ME Domestic Violence DV General GN Cardiopulmonary Resuscitation CR Advanced Cardiac Life Support (ACLS) VO Advanced Trauma Life Support (ATLS) BC Pediatric Advanced Life Support (PALS) BD Florida Council of Dietetics and Nutrition Profession Rank Code Subject area Subject area code Nutrition Counselor NC HIV/AIDS HA End-of-Life & Palliative Health Care EP Dietician/ Nutritionist ND Medical Errors ME General GN HIV/AIDS HA End-of-Life & Palliative Health Care EP Medical Errors ME General GN Florida Electrolysis Council Profession Rank Code Subject area Subject area code Electrologist EO HIV/AIDS HA Blood-borne diseases BB Medical Errors ME General GN General (Laser & Light Based Hair Removal Courses) CI Florida Board of Hearing Aid Specialists Profession Rank Code Subject area Subject area code Hearing Aid Specialist AS HIV/AIDS HA Medical Errors ME Laws & Rules of the Board LB General GN Florida Board of Massage Therapy © 2007 Information Systems of Florida 8–6 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Profession Rank Code Subject area Subject area code Massage Therapist MA HIV/AIDS HA Medical Errors ME Laws & Rules of the Board LB Professional Ethics PE General (relevant to focus on Massage Therapy techniques) GF General GN General (CPR) CP Florida Council of Medical Physicists Profession Rank Code Subject area Subject area code Diagnostic Radiological Physicist DRP Medical Errors ME General GN Medical Errors ME General GN Therapeutic Radiological Physicist TRP Medical Nuclear Radiological Physicist MNP Medical Health Physicist MHP Medical Errors ME General GN Medical Errors ME General GN Florida Board of Medicine Profession Rank Code Subject area Subject area code Medical Doctors ME HIV/AIDS (AMA Category I) AK Medical Errors (AMA Category I) AO Domestic Violence (AMA Category I) AU End-of-Life & Palliative Health Care (AMA Category I) AI Risk Management (AMA Category I) AT General (AMA Category I) AJ Medical Errors ME Domestic Violence DV HIV/AIDS (AMA Category I) AK Medical Doctors – Public Health Certificate Medical Doctors – Public Psychiatry Certificate © 2007 Information Systems of Florida PHC PPC Medical Errors (AMA Category I) AO Domestic Violence (AMA Category I) AU End-of-Life & Palliative Health Care (AMA Category I) AI Risk Management (AMA Category I) AT General (AMA Category I) AJ Medical Errors ME Domestic Violence DV HIV/AIDS (AMA Category I) AK Medical Errors (AMA Category I) AO Domestic Violence (AMA Category I) AU 8–7 FDOH/CE Broker: How to Report Course Completion Medical Doctors – Area Clinical Need Medical Doctors – Limited License Medical Doctor Medical Faculty Certificate Visiting Faculty Certificate © 2007 Information Systems of Florida ACN LL MFC VFC rev. 1.85 End-of-Life & Palliative Health Care (AMA Category I) AI Risk Management (AMA Category I) AT General (AMA Category I) AJ Medical Errors ME Domestic Violence DV HIV/AIDS (AMA Category I) AK Medical Errors (AMA Category I) AO Domestic Violence (AMA Category I) AU End-of-Life & Palliative Health Care (AMA Category I) AI Risk Management (AMA Category I) AT General (AMA Category I) AJ Medical Errors ME Domestic Violence DV HIV/AIDS (AMA Category I) AK Medical Errors (AMA Category I) AO Domestic Violence (AMA Category I) AU End-of-Life & Palliative Health Care (AMA Category I) AI Risk Management (AMA Category I) AT General (AMA Category I) AJ Medical Errors ME Domestic Violence DV HIV/AIDS (AMA Category I) AK Medical Errors (AMA Category I) AO Domestic Violence (AMA Category I) AU End-of-Life & Palliative Health Care (AMA Category I) AI Risk Management (AMA Category I) AT General (AMA Category I) AJ Medical Errors ME Domestic Violence DV HIV/AIDS (AMA Category I) AK Medical Errors (AMA Category I) AO Domestic Violence (AMA Category I) AU End-of-Life & Palliative Health Care (AMA Category I) AI Risk Management (AMA Category I) AT General (AMA Category I) AJ Medical Errors ME Domestic Violence DV 8–8 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Florida Council of Licensed Midwifery Profession Rank Code Subject area Subject area code Midwife MW HIV/AIDS HA Medical Errors ME Domestic Violence DV Laws and Rules of the Board LB General GN Florida Board of Nursing Profession Rank Code Subject area Subject area code Advanced Registered Nurse Practitioner ARNP HIV/AIDS HA End-of-Life & Palliative Health Care EP Medical Errors ME General GN Domestic Violence DV Laws & Rules of the Board LB Legal Aspects of Nursing LA Licensed Practical Nurse Registered Nurse Practitioner © 2007 Information Systems of Florida PN RN Universal Precautions VP Advanced Cardiac Life Support (ACLS) VO Basic Life Support (BLS) NR Pediatric Advanced Life Support (PALS) BD CPR/AED EY HIV/AIDS HA End-of-Life & Palliative Health Care EP Medical Errors ME General GN Domestic Violence DV Laws & Rules of the Board LB General (Remedial course for those reapplying to take NCLEX) RE Legal Aspects of Nursing LA Universal Precautions VP Advanced Cardiac Life Support (ACLS) VO Basic Life Support (BLS) NR Pediatric Advanced Life Support (PALS) BD CPR/AED EY HIV/AIDS HA End-of-Life & Palliative Health Care EP 8–9 FDOH/CE Broker: How to Report Course Completion Advanced Registered Nurse Practitioner Temporary ANT rev. 1.85 Medical Errors ME General GN Domestic Violence DV Laws & Rules of the Board LB General (Remedial course for those reapplying to take NCLEX) RE Legal Aspects of Nursing LA Universal Precautions VP Advanced Cardiac Life Support (ACLS) VO Basic Life Support (BLS) NR Pediatric Advanced Life Support (PALS) BD CPR/AED EY HIV/AIDS HA End-of-Life & Palliative Health Care EP Medical Errors ME General GN Domestic Violence DV Laws & Rules of the Board LB General (Remedial course for those reapplying to take NCLEX) RE Legal Aspects of Nursing LA Universal Precautions VP Advanced Cardiac Life Support (ACLS) VO Basic Life Support (BLS) NR Pediatric Advanced Life Support (PALS) BD CPR/AED EY Florida Board of Nursing — Certified Nursing Assistants Profession Rank Code Subject area Subject area code Certified Nursing Assistant CNA General GN HIV/AIDS, Infection Control HZ Domestic Violence DV Medical Record Documentation and VS Legal Aspects Appropriate to Nursing Assistants © 2007 Information Systems of Florida Resident Rights VY Communication with Cognitively Impaired Clients VC CPR Skills CK Medical Error Prevention and Safety ER Pediatric Advanced Life Support (PALS) BD 8 – 10 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Florida Board of Nursing Home Administrators Profession Rank Code Subject area Subject area code Nursing Home Administrator NH HIV/AIDS HA Medical Errors ME General (must be in one of the Domains of Practice - Personnel, Finance, Marketing, Physical Resource Management, Laws, Regulatory Codes and Governing Boards, Resident Care) DF Florida Board of Occupational Therapy Profession Rank Code Subject area Subject area code Occupational Therapist OT HIV/AIDS HA End-of-Life & Palliative Health Care EP Medical Errors ME Laws & Rules LB General GN General (Prescription Devices) GV HIV/AIDS HA End-of-Life & Palliative Health Care EP Occupational Therapy Assistant OTA Medical Errors ME Laws & Rules LB General GN General (Prescription Devices) GV Florida Board of Opticianry Profession Rank Code Subject area Subject area code Regular Licensed Optician DO HIV/AIDS HA Medical Errors ME Laws & Rules of the Board for Initial Licensure LI Laws & Rules of the Board for Renewal Licensure only LR Technical Practice TP Technical Practice (Contact Lens Theory and Practice) TC Risk Management RM Elective EL Florida Board of Optometry (partial credit not allowed by this Board) Profession Rank Code Certified Optometrist OPC Optometrist OP Subject area Subject area code Florida Board of Orthotists & Prosthetists © 2007 Information Systems of Florida 8 – 11 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Profession Rank Code Subject area Subject area code Orthotist ORT HIV/AIDS HA Medical Errors ME Laws & Rules of the Board LB Cardiopulmonary Resuscitation CR General GN HIV/AIDS HA Prosthetist Orthotist & Prosthetist (Dual) Pedorthist Orthotic Fitter Orthotic Fitter Assistant PRO POR PED ORF OFA Medical Errors ME Laws & Rules of the Board LB Cardiopulmonary Resuscitation CR General GN HIV/AIDS HA Medical Errors ME Laws & Rules of the Board LB Cardiopulmonary Resuscitation CR General GN HIV/AIDS HA Medical Errors ME Laws & Rules of the Board LB Cardiopulmonary Resuscitation CR General GN HIV/AIDS HA Medical Errors ME Laws & Rules of the Board LB Cardiopulmonary Resuscitation CR General GN HIV/AIDS HA Medical Errors ME Laws & Rules of the Board LB Cardiopulmonary Resuscitation CR General GN Florida Board of Osteopathic Medicine Profession Rank Code Subject area Subject area code Osteopathic Physician OS HIV/AIDS HA HIV/AIDS (AOA Category I-A) XT End-of-Life & Palliative Health Care EP End-of-Life & Palliative Health Care (AOA Category I-A) EM Medical Errors ME © 2007 Information Systems of Florida Medical Errors (AOA Category I-A) XO Domestic Violence DV 8 – 12 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Domestic Violence (AOA Category IA) XU Laws & Rules of the Board LB Laws & Rules of the Board (AOA Category I-A) XV Risk Management RM Risk Management (AOA Category IA) XN Managed Care MC General GN General (AOA Category I) GA General (AOA Category I-A) IA Laws on Uses & Abuses of Controlled Substances LU Laws on Uses & Abuses of Controlled Substances (AOA Category I-A) XM Florida Board of Pharmacy Profession Rank Code Subject area Subject area code Pharmacist PS HIV/AIDS HA End-of-Life & Palliative Health Care EP Medical Errors ME General GN General - Order and Evaluation of Laboratory Tests Initial Certification 3 hours ZQ General - Order and Evaluation of SS Laboratory Tests Recertification - 1 hr Nuclear Pharmacist Consultant Pharmacist NP PU Misfills MSF Laws & Rules of the Board LB In-Depth Treatment of Nuclear Pharmacist Practice PN Misfills MSF Laws & Rules of the Board LB In-Depth Analysis of Consultant Pharmacist Practice DA Misfills MSF Laws & Rules of the Board LB Florida Board of Physical Therapy Profession Rank Code Subject area Subject area code Physical Therapy Assistant PTA HIV/AIDS HA Medical Errors ME General (Risk Management) RG General GN HIV/AIDS HA Physical Therapy © 2007 Information Systems of Florida PT 8 – 13 FDOH/CE Broker: How to Report Course Completion rev. 1.85 Medical Errors ME General (Risk Management) RG General GN Florida Physician Assistant Profession Rank Code Subject area Subject area code Physician Assistants PA General (AMA Category I) AJ Medical Errors (AMA Category I) AO Domestic Violence (AMA Category I) AU End of Life and Palliative Health Care AI (AMA Category I) HIV/Aids (AMA Category I) AK General (AMA Category II) AL Medical Errors (AMA Category II) MG Domestic Violence (AMA Category II) AH Physician Assistants Temporary PAT General (AMA Category I) AJ Medical Errors (AMA Category I) AO Domestic Violence (AMA Category I) AU End of Life and Palliative Health Care AI (AMA Category I) HIV/Aids (AMA Category I) AK General (AMA Category II) AL Medical Errors (AMA Category II) MG Domestic Violence (AMA Category II) AH Florida Board of Podiatry Profession Rank Code Subject area Subject area code Podiatric Physician PO HIV/AIDS HA Medical Errors ME General GN General (Practice Management) GQ Risk Management RM Laws & Rules of the Board LB 8 hour CE recertification course set forth in Section 461.0135 F.S. Rule 64B18-17.001[8] (Includes Laws and Rules and Medical Errors) CH Certified Podiatric X-Ray Assistant PXA Florida Board of Psychology (partial credit allowed for “Concurrent Session” courses only) Profession Rank Code Subject area Subject area code Limited License Psychologist LPY Medical Errors ME Domestic Violence DV End-of-Life & Palliative Health Care EP © 2007 Information Systems of Florida Professional Ethics PE Laws & Rules of the Board LB 8 – 14 FDOH/CE Broker: How to Report Course Completion Psychologist PY rev. 1.85 General GN Medical Errors ME Domestic Violence DV End-of-Life & Palliative Health Care EP Professional Ethics PE Laws & Rules of the Board LB General GN Florida Board of Respiratory Care Profession Rank Code Subject area Subject area code Respiratory Care Practitioner, Critical Care TUC HIV/AIDS HA Medical Errors ME General (direct delivery of respiratory care services) GR Management IW Risk Management RM Respiratory Care Practitioner, NonCritical Care Certified Respiratory Care Therapist (CRT) © 2007 Information Systems of Florida TUN TT Personal Growth IE Educational Techniques IQ CPR/AED EY Advanced Cardiac Life Support (ACLS) VO Pediatric Advanced Life Support (PALS) BD Basic Life Support (BLS) NR Neonatal Resuscitation MB Emergency Preparedness PO HIV/AIDS HA Medical Errors ME General (direct delivery of respiratory care services) GR Management IW Risk Management RM Personal Growth IE Educational Techniques IQ CPR/AED EY Advanced Cardiac Life Support (ACLS) VO Pediatric Advanced Life Support (PALS) BD Basic Life Support (BLS) NR Neonatal Resuscitation MB Emergency Preparedness PO HIV/AIDS HA Medical Errors ME 8 – 15 FDOH/CE Broker: How to Report Course Completion Registered Respiratory Therapist (RRT) RT rev. 1.85 General (direct delivery of respiratory care services) GR Management IW Risk Management RM Personal Growth IE Educational Techniques IQ CPR/AED EY Advanced Cardiac Life Support (ACLS) VO Pediatric Advanced Life Support (PALS) BD Basic Life Support (BLS) NR Neonatal Resuscitation MB Emergency Preparedness PO HIV/AIDS HA Medical Errors ME General (direct delivery of respiratory care services) GR Management IW Risk Management RM Personal Growth IE Educational Techniques IQ CPR/AED EY Advanced Cardiac Life Support (ACLS) VO Pediatric Advanced Life Support (PALS) BD Basic Life Support (BLS) NR Neonatal Resuscitation MB Emergency Preparedness PO Subject area code Florida Office of School Psychology Profession Rank Code Subject area School Psychologist SS Medical Errors ME Domestic Violence DV General GN Florida Board of Speech-Language Pathology & Audiology Profession Rank Code Subject area Speech Language Pathologist SA Medical Errors ME General (Clinically Related) GD General (Non-Clinically Related) GK Medical Errors ME General (Clinically Related) GD General (Non-Clinically Related) GK Audiologist © 2007 Information Systems of Florida AY Subject area code 8 – 16 FDOH/CE Broker: How to Report Course Completion Speech Language Pathologist Assistant SI Audiologist Assistant AI Provisional Speech Language Pathologist Provisional Audiologist SZ AZ rev. 1.85 Medical Errors ME General (Clinically Related) GD Medical Errors ME General (Clinically Related) GD Medical Errors ME General (Clinically Related) GD General (Non-Clinically Related) GK Medical Errors ME General (Clinically Related) GD General (Non-Clinically Related) GK Florida Bureau of Emergency Medical Services Profession Rank Code Subject area Subject area code Emergency Medical Technician EMT EMT refresher training based on the 1996 DOT EMT – Basic National Standard Refresher Curriculum UV HIV/AIDS refresher training PX CPR for the professional rescuer (hours DO NOT apply toward license renewal) IX CPR for the professional rescuer (hours apply toward license renewal) IV PMD refresher training based on the 1998 DOT EMT – Paramedic National Standard Refresher Curriculum IB HIV/AIDS refresher training PX Current Advanced Cardiac Life Support (ACLS) card - (hours DO NOT apply toward license renewal) VN Current Advanced Cardiac Life Support (ACLS) card - (hours apply toward license renewal) VG Paramedic © 2007 Information Systems of Florida PMD 8 – 17
© Copyright 2025