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

October 18, 2017, 02:20:27 AM *
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: VMCAS load  (Read 4356 times)
svanhoo1
Newbie
*
Offline Offline

Posts: 2


« on: July 11, 2014, 09:28:45 AM »

For the past couple of years we have been loading vmcas files into Banner.  I had to write a pl/sql procedure to take the file and format it for SRTLOAD because the files contained multiple records for a person.  With the new 2014 files, our vetmed dept, can export the file in the format that we want (one record per person), eliminating the need for the pl/sql procedure.  However, when we looked at the file, the race codes are coming as a 'Y' or null for each race field.  We mapped the 5 race fields that we care about in SRATPFD, but can't figure out how to crosswalk the fields in SOTCNVT because the race fields in the file do not contain race codes, only a 'Y' or null.  Anyone loading these files?  How are you dealing with the race codes?  Thanks.  Shannon
Logged
Deno Tufares, Jr.
Moderator
Newbie
*****
Offline Offline

Posts: 4


« Reply #1 on: July 11, 2014, 10:48:21 AM »

Yes, we had to modify the SRTLOAD program to load these with the new Web Admit a follows...

Remember - the Race codes are always in the same order:

tmstrcpy(parm_conv_table,_TMC("ETHN"));
convert_validate_value(_TMC("ETHN"), ethn_code10,_TMC(""));

/**** SIMST383 - UMB MOD START -- MT 01/17/14 ***/
        if(compare(parm_prel_code,_TMC("PMCS"),EQS)){

          if(compare(str2uc(race1),_TMC("YES"),EQS))
                tmstrcpy(race1,_TMC("BLA"));

          if(compare(str2uc(race2),_TMC("YES"),EQS))
                tmstrcpy(race2,_TMC("ASI"));

          if(compare(str2uc(race3),_TMC("YES"),EQS))
                tmstrcpy(race3,_TMC("WHI"));

          if(compare(str2uc(race4),_TMC("YES"),EQS))
                tmstrcpy(race4,_TMC("HAW"));

          if(compare(str2uc(race5),_TMC("YES"),EQS))
                tmstrcpy(race5,_TMC("AME"));
        }
        else
/**** SIMST383 - UMB MOD END -- MT 01/17/14 ***/
tmstrcpy(ethn_code_self,race1);


Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

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