CAS-ERP Data Integration Forum

ERP => Banner => Topic started by: svanhoo1 on July 11, 2014, 09:28:45 AM



Title: VMCAS load
Post by: svanhoo1 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


Title: Re: VMCAS load
Post by: Deno Tufares, Jr. 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);