Transcript CASCE: Central Administration System for Continuing Education

2001 NC AHEC ITG Meeting
November 1-2, 2001
A. J. “Tony” Kane, MS
Assoc. Director, Statewide Information and Technology
NC AHEC Program Office
1
Review of CIO and ITG Structure
November 1, 2001
9:50 - 10:20 am
North Carolina
Area Health Education Centers
2
Comparing The CIO & ITG



The CIO Group has
one representative
from every AHEC
CIOs can act as filter
between ITG &
non-IT AHEC groups
ITG allows sharing
general info among
wide IT audience
North Carolina
Area Health Education Centers
Chief
IT
Information
Management
Officers Video
Sys Admin
Support
Help Information
Desk
Technology
Network
Group
3
AHEC Technology Email Lists
(all @listserv.unc.edu)

CIO : Chief Information Officers
– One “seat” per AHEC + Program Office

ITG : Information Technology Group
– Superset of CIO List
– All technologies: Networking, Admin, Video...

ITG-Video : Videoconferencing Workgroup
– Currently used for Scheduling AHEC VCR
North Carolina
Area Health Education Centers
4
AHEC Technology Email Lists
(all @listserv.unc.edu)

AHEC-Healthstream
– Statewide Workgroup on Healthstream topics

CASCE_Data_Standards
– a.k.a. CASCE Advisory Group
– For system-wide standards/change agreement

CASCE : All CASCE Users
– General announcements regarding updates,
scheduled maintenance, etc.
North Carolina
Area Health Education Centers
5
Review of CIO and ITG Structure
Questions?
North Carolina
Area Health Education Centers
6
Current Technology Issues Facing
the AHEC
November 1, 2001
11:15 am - 12:15 pm
North Carolina
Area Health Education Centers
7
Current Technology Issues…
Health Insurance Portability and
Accountability Act
 Staying Competitive as a Non-Profit in
For-Profit Markets
 Staying Current with, and Supporting,
Ubiquitous Technologies
 The Unquenchable Thirst for Bandwidth
 Two Hats and Half a Head

North Carolina
Area Health Education Centers
8
Current Technology Issues:
HIPAA
Health Insurance Portability and
Accountability Act
 Standards: Codes, Transactions, ...
 Premise and Equipment Security
 Agreements with Partners
 Authorization, Audit Trails, Disaster
Recovery Plans

North Carolina
Area Health Education Centers
9
Current Technology Issues:
Competing
Competing as a Non-Profit in For-Profit
Markets - Continuing Education
 Diversification

– For Profits: Acquisition
– Non Profits: Partnering
Working together as a system
 Sharing resources, expertise

North Carolina
Area Health Education Centers
10
Current Technology Issues:
Staying Current
Software, Pulling Along Hardware
 Personal Digital Assistants (PDA)
 Wireless Communications
 Authentication & Authorization
 Internal Training on New Technologies
 User Training and Support
 IP V6 - New Addressing Scheme

North Carolina
Area Health Education Centers
11
Current Technology Issues:
Bandwidth
Demand Driven by Applications
 Merging of Voice, Video, & Data over
same physical media
 Streaming Video on Demand
 Voice over IP (VOIP)
 Instant authentication
 Virtual Private Networks / Storage

North Carolina
Area Health Education Centers
12
Current Technology Issues:
2 Hats & ½ Head

Hat 1: IT the Discipline
– Training: Internal and External, Helpdesk

Hat 2: IT the Infrastructure:
– Planning, Life Cycle Support, Migration...

½ Head: Limited Resources!
– Staff: Get/Keep Heads & Filling Them
– Hard/Software: Being a Fiduciary

Suggested Strategies: Tracking & KISS!
North Carolina
Area Health Education Centers
13
Current Technology Issues facing
the AHEC
What else do you see?
North Carolina
Area Health Education Centers
14
CASCE :
How it is working,
What it could be doing, and
Where it is going
November 1, 2001
11:15 am - 12:15 pm
North Carolina
Area Health Education Centers
15
CASCE: How’s It Going
6 of 9 AHEC Using (2 paralleling)
 3 Remaining AHECs Committed by 7/02
 #1 Priority: Eliminating Duplicate Entry
 Statewide Advisory Structure in Place
 Jim: Fiscal Reporting

– Filling gaps that are causing paralleling

Rhoda: Partner Reporting
– UNC CME Reporting & Pharmacy Query
North Carolina
Area Health Education Centers
16
CASCE: How’s It Going

Performance Problem Summer 2001
– Some regional network issues
– Major OIS server issue: 200MHz Pentium
OIS Committed to Upgrade by EOY
 Investigating Migration to AHEC Digital
Library (ADL) Server
 Became viable when ADL Converted
from Access to SQL Server July 2001

North Carolina
Area Health Education Centers
17
CASCE Technology Overview
Central
Database
SQL Server
ODBC
AHEC Websites
Staff Directory
Program Calendar
[Future: Reg]
EXCEL
Data Extraction
& Analysis
WORD
Customized
Output
SQL Server Login
MS IIS / Cold Fusion
Demos:
Greensboro
Northwest
HTML / JavaScript
LDAP Login
Periodic Email
Reports:
UNC CME,
Schools, etc.
Hardcopy of
Online Reports:
Accounting, etc.
North Carolina
Area Health Education Centers
CASCE
Web Interface
Online Reports:
Miscellaneous
Operational
Web
Query
Hardcopy of
Analysis:
Administrative
Demo
Labels
Nametags
Form Letters
18
North Carolina
Area Health Education Centers
19
North Carolina
Area Health Education Centers
20
North Carolina
Area Health Education Centers
21
CASCE: What it Could Be..
Dynamic Statewide Staff Directory
(check out WWW.NCAHEC.NET)
 Simple Calendar of CE Programs
(demo also on main website)
 Data Available for Regional Developers

– Weblet: Shared Searchable CE Calendar
– Library: On-line Transcript of All AHEC CE
– Local: Automated Interfaces to …?
North Carolina
Area Health Education Centers
22
CASCE: What it Could Be..

Nightly Cycle
– Backup Production
– Restore to Test

Production Database
– CASCE
– Other Realtime Data

Development Database
– Executive Info System
– Data Mining & Other DS
North Carolina
Area Health Education Centers
23
The Big Picture:
Supporting Informed Decisions
Program
Office & G.A.
Regional AHEC
Director & Boards
Regional Discipline
Directors & Advisory Panels
Central Administration System for
Continuing Education
North Carolina
Area Health Education Centers
data
data
data
24
North Carolina
Area Health Education Centers
25
CASCE: Where is it going
CASCE is only the first “view” into a
Central Customer Database for AHEC
 Others to follow: Student Rotations
 Complete Picture of Services Delivered
and Received - centered on the person
 One of the best, if not THE best
databases on Health Professionals in NC

North Carolina
Area Health Education Centers
26
The Big Picture:
A Central Customer Database
Organizations
ORPCE
User
Rotations
Matriculations
People
CASCE
User
HC Programs
HCWD
User
North Carolina
Area Health Education Centers
CE Programs
Customer &
Partner
Interfaces
27
CASCE: The First Step toward an
AHEC Central Customer Database
Questions?
North Carolina
Area Health Education Centers
28
Role of IS in A Central Database
November 2, 2001
8:30 - 10:00 am
North Carolina
Area Health Education Centers
29
What Can You Do?
Ensure Fast & Reliable Internet
 Provide System Analysis Expertise
 Offer Local Microsoft Office Support:

– Word Mail Merging
– Creating Excel Web Queries
– Excel Formatting, Conversion, Wizards
Use Central Data whenever Possible
 Develop a NC AHEC Generic Weblet!

North Carolina
Area Health Education Centers
30
How Can You Do It?
Using ODBC over TCP/IP, regional
developers can access/view the central data
 Systematic, even Parallel, Development:

– Subroutine (not function) calls can be simulated
by passing argument in dynamically-built
hyperlinks to provide functionality
A Searchable, CE Calendar Weblet display
calls, i.e. has hyperlink to, ...
 An Event Detail Weblet, which can “call”...

North Carolina
Area Health Education Centers
31
What Can You Do?
Discussion
North Carolina
Area Health Education Centers
32