The Month Closes, the PCAM Typing Starts
The seminars, webinars and on-demand programs went well. Now someone keys every attorney into PCAM, one ARDC number and one set of hours at a time.
- ARDC numbers copied off sign-in sheetsAnd the emails to attorneys whose handwriting left a digit in doubt.
- Professional responsibility hours split by handEthics, diversity and mental health hours worked out again for every attendee.
- A month of attendance keyed in one sittingSeminar, webinar and on-demand attendees, course by course.
Set Up Once, Then It Runs
Start from the PCAM Format
Choose "Start from a board's format" and pick Illinois MCLE Board (PCAM). The import layout, the file header and a file name PCAM accepts are set for you.
Answer a Short Setup
Your provider name and PCAM provider number once, and which registration question holds the ARDC number. No question yet? The setup creates one that takes seven digits.
Type Each Course's PCAM Details Once
The PCAM Course ID, how attorneys attend and any professional responsibility hours go on the course's credit, typed once.
Import the Ready File
The month's attendance arrives by email in PCAM's import file, every course and attorney in it, ready to import as is.
- Column 4, header: 100: Provider Number, from: Fixed text : cle0042 Formatting:Trim spaces, thenUPPER CASE
- Column 5, header: 100: File Creation Date, from: Completion › Date the file is sent Formatting:Write the date as
%Y%m%d - Column 6, header: 100: Transaction Number, from: Count › File number
- Column 7, header: 100: Record Count, from: Count › Lines in the file
- Column 15, header: 500: PCAM Course ID, from: Credit field › PCAM Course ID Formatting:Digits only
- Column 16, header: 500: Attendance Completion Date, from: Completion › Completion date Formatting:Write the date as
%Y%m%d - Column 18, header: 500: ARDC Number, from: Registration field › ARDC number Formatting:Digits only
- Column 23, header: 500: Total Credit Hours, from: Credit › Credit hours Formatting:Number with decimals
0.## - Column 24, header: 500: PR Credit - Mental Health & Substance Abuse, from: Credit field › Illinois PR hours: mental health and substance abuse Formatting:Trim spaces, thenDefault when blank
0, thenNumber with decimals0.##
2 more columns
Your Import File, Built While You Teach
ARDC Numbers From Registration
Asked once on your form and checked for seven digits while the attorney is still on it.
PR Hours Split for You
Mental health and substance abuse, diversity and inclusion and other professional responsibility hours each land in their own column, from the course's credit.
Every Course in One File
Seminars, webinars and on-demand programs together, each attorney's line naming its PCAM course.
Every Attorney Reported Once
Each completion goes into exactly one file, so nobody is reported twice or missed for finishing the night before a send.
On Your Schedule
Monthly from the start, or weekly after a big conference, emailed to whoever imports.
Every File on Record
A preview before each send, and Send History with a download and Resend for a year after.
Bar Association Seminars, Firm Training and On-Demand CLE, on One Platform
Whether you run a county bar's lunch programs, a firm's in-house training or a full catalog of on-demand CLE, the PCAM file comes out of everything else you already run.
- Registration that does the collectingARDC number, bar membership and anything else you need, asked once.
- In the room, live online and on demandCheck-in at the door, Zoom and GoToMeeting attendance sync, or recorded programs attorneys take on their own time.
- Quizzes and evaluations before creditOnly attorneys who finished are reported.
- Certificates attorneys keepIssued on completion, from your own template.
Questions from Illinois CLE Providers
How long does setup take?
One short sitting. Choose "Start from a board's format" in a Spreadsheet Report and pick Illinois MCLE Board (PCAM), enter your provider name and PCAM provider number, choose your ARDC number question or let LecturePanda create it, and add each course's PCAM details to its credit. We're glad to set it up with you on a call using one of your own courses.
What do we need to have ready?
Your PCAM provider number, and for each course its PCAM Course ID, how attorneys attend it and its professional responsibility hours. LecturePanda takes care of the import layout, the dates, the counts and the schedule.
Our seminar carries ethics, diversity and mental health hours. Does that work?
Yes. The course's credit carries its total Illinois hours, and its professional responsibility hours by area are typed on the same credit. Every attorney's line in the file carries the total and the split, with nothing to work out by hand.
What if an attorney types their ARDC number wrong?
The ARDC number question takes seven digits, so a missing digit or a stray letter is caught on the spot by the attorney who knows the number. The preview shows the next file's lines before it goes, and Send History keeps every file, with its lines, for a year.
Some of our attendees aren't Illinois attorneys. What happens to them?
They register and attend as usual. The PCAM file carries the attorneys who gave an ARDC number, so out-of-state lawyers, paralegals and guests stay out of it on their own.
Does it work for free programs and in-house firm training?
Yes. A firm's in-house CLE, a free bar association lunch program and a paid seminar all report the same way, and Spreadsheet Reports are part of the LecturePanda subscription; see pricing.
Can we still change the file?
Yes. Once it's set up, the PCAM report is an ordinary Spreadsheet Report: change the schedule, add a recipient or adjust a column whenever you need to. Send a test shows you the result first.
Looking for the MCLE Board's provider resources?
The Illinois MCLE Board's provider support page, with PCAM's import resources, is at mcleboard.org.
Also for Continuing Legal Education
Nebraska MCLE
Attendance files for the MCLE portal, Nebraska bar numbers from registration.
Maine CLE
Attendance rosters for the Board of Overseers of the Bar, sent on schedule.
Spreadsheet Reports
Completions in any recipient's columns, on a schedule.
Teaching Illinois Attorneys?
Bring one of your accredited courses to a demo and we'll set up its PCAM import file with you, from the ARDC number question to the file you import.
Request a Demo