What/How it runs
cron daily at 20:13
/lawson/law/prod/usrscripts
OIGCron.sh
 OIGload.pl
 OIGDRload.pl


Parent process
EPIC produces OIG.csv file at 3:15 on the EPIC server???
At least once a month, manually go to this website???
 https://medicaid.ms.gov/providers/provider-terminations/
 and determine if the csv has been updated, if so, manually download it into
 Common/WIMEPIC/OIGDBFiles/SanctionedProvidersList.csv


WIM
This piece has been removed since Homecare is not on EPIC
@@W_OIG_DrList_CPSI that is scheduled daily 22:58/10:58PM
@@OIGHOMECARE.knx
@@/Common/Lawson/homecare_docs.csv


Moveit
OIG DB Download that is scheduled at 3:05AM
Pulls http://oig.hhs.gov/exclusions/downloadables/UPDATED.csv
 and moves it to Common\WIMEPIC\OIGDBFiles\OrigUPDATED.csv


Kronos7-4
Window Task Scheduler that is scheduled daily at 3:20AM
OIGcsvConvert - Powershell script C:/Scripts/OIGcsvConvert.ps1
Reprocesses OrigUPDATED.csv to UPDATED.csv so perl script will read it later


WIM
W_MedicaidOIG that is scheduled daily 3:25AM
CSVappend.kni and CSVappend.KNX
 Common\WIMEPIC\OIGDBFiles\UPDATED.csv


Moveit
OIG that is scheduled at 4:05AM
Pulls from EPIC (/epic/prdfiles/fgh/extracts/Oig)
Moves it to /lawson/law/prod/work/OIG/oig.csv


Moveit
OIG CSV to Lawson, that is scheduled daily at 4:10AM
Moves homecare doc file and the UPDATED.csv to /lawson/law/prod/work/OIG/


Child process
there are 3 crystal reports scheduled on the CrystalR3 server, Paul/Joann can help with this.
Infor10 OIG Dr by NPI.rpt
 runs at 23:30PM daily
     select dr.NPI,dr.lname,dr.fname, oig.firstname,dr.dob, oig.dob,
     oig.address, oig.city, oig.state, oig.upin,dr.src from turnover.dr dr
     join turnover.OIG oig on (oig.npi=dr.npi)
     where oig.npi is not null
     and oig.npi>0
     order by dr.src,dr.lname , dr.fname ,oig.firstname;

Infor10 OIG Employee_new.rpt
 runs at 23:30PM first day of every month
     select e.employee,e.last_name,e.first_name, oig.firstname,to_char(p.birthdate,'MM/DD/YY') as EMPDOB, oig.dob,
     oig.address, oig.city, oig.state, oig.upin,e.process_level from prod.employee e
     join turnover.OIG oig on (oig.lastname = upper(rtrim(e.last_name))
      and e.first_name like (substr(oig.firstname,1,1))||'%')
     join prod.paemployee p on ( e.company=p.company and e.employee=p.employee )
     where e.company=10 and e.emp_status in ('A1','A2')
     and to_char(p.birthdate,'MM/DD/YY')=oig.dob
     order by e.process_level,e.last_name , e.first_name ,oig.firstname;

Infor10 OIG Active Vendors.rpt
 runs at 23:35PM first day of every month
     select v.vendor, v.vendor_vname, oig.busname, oig.address,
     oig.city, oig.state
     from prod.apvenmast v
     join turnover.oig oig on ( oig.busname=upper(rtrim(v.vendor_vname)) )
     where v.vendor_status='A'
     order by oig.busname;



Input system/files
/lawson/law/prod/work/OIG
oig.csv (EPIC physicians)
UPDATED.csv (OIG website)
homecare_docs.csv  --- No longer produced.


Output system/files
Lawson Oracle TURNOVER schema OIG and DR files
OIG table is OIG website - truncates table and loads
DR table is all the physicians from all the files removes records from src file with old dates then loads


Automation
connects to oracle dbase and writes into tables


Hard Coding
OIGCron.sh
    none
OIGload.pl
    oracle perl path
OIGDRload.pl
    oracle perl path

Contacts
Jonas Bull who doesn't work here anymore
Richard Carter
Lawson Team


DOWNTIME
none - can be skipped a day or two
can run early or late
can run multiple times it just deletes and writes records in tables


NOTES
OIGload.pl
changed to get rid of hardcoding FROM
my $env=$ARGV[0];
my $date=$ARGV[1];
unless ($env) {die "Need a file";}
$date=Todays_Date('d') unless ($date);
my $dbuser='system';
my $dbpass='accessORA';
my $dbhost='lawdb';
my $sid='lawprod11g.fghnet.com';


change it TO:
my $file=$ARGV[0];
my $env=$ARGV[1];
my $date=$ARGV[2];
unless ($file) {die "Need a file";}
$date=Todays_Date('d') unless ($date);

my $dbuser='system';

my $dbpass='accessORA';
my $dbhost='infordb';
my $sid='lawprod.fghnet.com';

if ($env eq 'test'){ $dbpass='accessORA'; $dbhost='infortdb'; $sid='lawtest.fghnet.com'; }