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

June 27, 2017, 07:09:49 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
 
   Home   Help Search Login Register  
Pages: 1 ... 4 5 [6]
 51 
 on: July 21, 2011, 11:24:37 AM 
Started by clong - Last post by Le Nguyen
Hi Cecilia,

Have you able to find a solution for your problem? also, for clarification, are you trying to match with Banner or NOLIJ records?

thanks.

 52 
 on: July 20, 2011, 10:07:39 AM 
Started by pascarellamary - Last post by pascarellamary
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.

 53 
 on: July 18, 2011, 10:39:46 AM 
Started by clong - Last post by Rick B.
Hi Cecilia,

Your question is a good one, and there are a number of possible approaches to solving the "missing SSN" issue.  The TAMF is a simple, pipe-delimited flat file, where the SSN is the first field and the AMCAS ID is the 3rd field.  The file can be imported into a program like Microsoft Access, and written to a table.  Then, the separate SSN file can be imported into a second table.  With the AMCAS ID in both tables, the records can be matched and an Update query can be used to place the SSN into the TAMF table.  Then, that table can be written out again (exported) as a text file, containing both the SSN and the AMCAS ID before being submitted via SRTLOAD.

This process can be a little dicey, so I might recommend an alternate.  After you run SRTLOAD in Update mode, the TAMF data is stored into temporary tables in Banner.  The AMCAS ID is loaded into SATURN_SRTIDEN, and the SSN can be found in SATURN_SRTPERS.  Once again, using Microsoft Access or writing some sql code, match the AMCAS ID from SRTIDEN with the AMCAS ID in the SSN file.  Using the RIDM from SRTIDEN, perform the update of SSN into SRTPERS before running SRRSRIN.  This too, sounds a little complicated, but if you have an ID with Update access to these temp tables in Banner, it can be accomplished in a fairly straightforward manner.

I'd be happy to discuss this with you in more detail.  Give me a call at 973-972-1455 or e-mail at baderri.umdnj.edu

Regards,

Rick Bader,  Director, SISS  UMDNJ

 54 
 on: July 15, 2011, 09:04:46 AM 
Started by clong - Last post by clong
This will be our first year using PTCAS at Georgia Health Science University (formally MCG).

We are going to load the TAMF file through NOLIJ. But, the ssn's will not be included on the TAMF file so there is an additional file with the ssn's and PTCAS ID that will be downloaded.  Is anyone merging these two files or have you set up matching rules for this process?

Thanks
Cecilia

 55 
 on: June 28, 2011, 09:38:08 AM 
Started by Tony Wynne - Last post by Tony Wynne
We have uploaded a presentation given at Liaison's Centralized Application Service (CAS) Summit in Washington, DC on May 13th, 2011 to the "documents" section of the forum.  This presentation introduces the CAS-ERP Data Integration Advisory Committee to the CAS constituency, and seeks to help CAS members understand the mission and goals of the committee. More importantly, it serves to address the impacts that the committee will have on CAS data being imported into institution student information systems.

Please click on "documents" in the menu at the top of the page to find the presentation. Please let me know if you have any questions.

Thanks,

Tony Wynne
ERP Data Integration Committee CAS Liaison

 56 
 on: June 27, 2011, 02:07:45 PM 
Started by Deno Tufares, Jr. - Last post by Deno Tufares, Jr.
I have some detailed documentation for implementing PharmCAS - AADSAS and other cases are very similar.  If you would like this documentation, please let me know...

In VERY simplified terms; Basically once you define exactly what fields that you want to import, the export file from the CAS system will have to be generated and the file layout has to be defined in Banner (as well as some rule forms).  Once this is done, cross walks will have to be built for CAS codes to your Banner codes.  Then you can start testing… 

 57 
 on: May 24, 2011, 01:28:10 PM 
Started by Jerome Giudicelli - Last post by Jerome Giudicelli
Welcome to the PeopleSoft forum.

This section of the CAS-ERP Data Integration Forum is dedicated to providing PeopleSoft users a place to post questions, comments, and other PeopleSoft-specific items.

As your moderators, we are here to facilitate this section of the forum, and will work with you to ensure you get the answers you need.  But this is *YOUR* forum, and *YOUR* place to converse with others that may have the same data related questions/issues you may have.

  * Mark Nelson, Product Manager for Recruiting and Admissions, University of Michigan
  * Mark Sauberan, Database Administrator, University at Buffalo School of Pharmacy and Pharmaceutical Sciences

 58 
 on: May 23, 2011, 09:37:00 AM 
Started by Jerome Giudicelli - Last post by Jerome Giudicelli
Welcome to the Banner forum.

This section of the CAS-ERP Data Integration Forum is dedicated to providing Banner users a place to post questions, comments, and other Banner-specific items.

As your moderators, we are here to facilitate this section of the forum, and will work with you to ensure you get the answers you need.  But this is *YOUR* forum, and *YOUR* place to converse with others that may have the same data related questions/issues you may have.

   * Rick Bader, Director of Systems and Support, University of Medicine and Dentistry of New Jersey
   * Le Hoang Nguyen, Banner Senior Programmer Analyst, Western University of Health Sciences
   * Eric Richardson, Manager, Enterprise Systems, Jefferson Information Technologies, Thomas Jefferson University
   * Deno Tufares, Jr., Functional Manager Student Systems, Center for Information Technology Services, University of Maryland

 59 
 on: May 18, 2011, 03:21:48 PM 
Started by Tony Wynne - Last post by Tony Wynne
Welcome to the CAS/General forum.  This section of the CAS-ERP Data Integration Forum is dedicated to providing the Cetralized Application Services and others a place to post question, comments, and other non-ERP secific items.

As your moderator, I'm here to facilitate this section of the forum, and will work with you to ensure you get the answers you need.  But this is *YOUR* forum, and *YOUR* place to converse with others that may have the same data related questions/issues you may have.

Thanks -
Tony Wynne
AAVMC/VMCAS

Pages: 1 ... 4 5 [6]
Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!