What/How it runs
WIM, weekly every Friday at 1:PM, W_dental_Fri
dental.kni
 dental.knx
 dental.bat
 gpg_encrypt.ps


Parent process
dont know


Child process
dont know


Input system/files
Lawson dbase tables


Output system/files
common\lawson\Dental\forrestgeneral.txt


Automation
This sends dental ins info to ameritas

It uses PGP encryption with a public key that we received from Ameritas.
Powershell script gets the file, encrypts with the public key then uploads the file
to the Ameritas server.
Then we make a copy and rename the file for archival.

/*  This was the old method.
It's an sftp so it needs a public key loaded on their 
servers (they sometimes even get it right)
It also requires a private key (keys located in the crypto folder) and
of course it requires the psftp.exe binary
*/


ARCHIVE
\\fghuser\common\Common\Lawson\Dental\Archives\forrestgeneral_dentalYYYYMMDD.txt


Hard Coding
better look, it has quite a bit
BEN.plan_code in ('DENT', 'DNTH', 'DNWC','DNTJ','DNTM') and ((BEN.stop_date > CURRENT_DATE-30) or
 (BEN.start_date > CURRENT_DATE-30) or (to_char(BEN.stop_date,'YYYYMMDD') = 17000101 ))
 AND
 (ben.employee not in
 (select employee from prod.benefit b
      where B.plan_code in ('DENT', 'DNTH', 'DNWC','DNTJ','DNTM') and ((B.stop_date > CURRENT_DATE-30) or
      (B.start_date > CURRENT_DATE-30) or (to_char(B.stop_date,'YYYYMMDD') = 17000101 )) 
      and
      ((b.cov_option=ben.cov_option
      and b.stop_date!=ben.stop_date
      and b.stop_date=to_date('17000101','YYYYMMDD')
      or
      ( b.cov_option!=ben.cov_option
      and b.stop_date!=ben.stop_date
      and b.stop_date=to_date('17000101','YYYYMMDD')
      )
      ))))


Contacts
LAwson Team, Hope Jordan & Richard Carter


DOWNTIME
Just rerun it.  But you need to let them know if it's 
very late because their process wont pick it up.