CAS-ERP Data Integration Forum
Welcome to the CAS-ERP Data Integration Forum
Liaison, in partnership with their hosted Centralized Application Systems (CAS), has created an CAS-ERP Data Integration Committee comprised of individuals using some of the major ERP systems (Banner, PeopleSoft) - we are still looking for individuals using Datatel and Jenzabar to join the committee - to improve, and to respond to questions about, CAS-ERP data integration within all programs and schools participating in any CAS and to provide guidance for those programs and schools who are contemplating CAS membership. Read more

August 23, 2017, 12:34:30 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
 
   Home   Help Search Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: Export Results from PTAdmit  (Read 3684 times)
pascarellamary
Newbie
*
Offline Offline

Posts: 1


« on: July 20, 2011, 10:07:39 AM »

Is anyone exporting CAS Admit data from multiple sources e.g., Nursing, OT and PT and then scripting data import into PS? How are you handling the different programming requirements. We've hit a snag with the format of PTCAS Admit data.
Logged
Mark Nelson
Moderator
Newbie
*****
Offline Offline

Posts: 4


« Reply #1 on: July 28, 2011, 09:23:57 AM »

Hello pascarellamary!  Thanks for posting your message on the new Integration Forum.  That's a great question you ask.  I think when you ask about exporting CAS Admit data, you are referring to WebADMT, right?  We are examing this same issue at the University of Michigan.  We have three CAS products that we load into PS currently (AADSAS, PharmCAS, and SOPHAS) and we are getting ready to add two more (HAMPCAS and NursingCAS).  We can no longer afford to build custom loads for each type of interface, and so we are working on a new process that will read the incoming data into a single 'CAS' prestaging table, then load the data into our application staging tables where we can leverage the delivered search/match/post processes.  I'm in the process of creating a white paper for how we do this today, what we need to do for the new implementation of NursingCAS and HAMPCAS this fall, and where we want to go in the future (we want to leverage PS File Parser and the new AAWS feature pack from Oracle).  This white paper should be ready and posted by end of next week.  Can you elaborate on the snag you hit with the format of the PTCAS Admit data?  Mark
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!