What/How it runs
WIM, weekly Wed 7:01PM, HCHPendingNewHires.kni, HCHPendingNewHires.knx


Parent process
normal hiring processes


Child process
none


Input system/files
lawson dbase tables


Output system/files
common\IS\downloads\hchpendingnewhire.csv



Automation
none


ARCHIVE
none


Hard Coding
EMPLOYEE.emp_status in ( '00', 'A1','A2', 'A3', 'A4', 'A5', 'A6', 'A7') and PAEMPLOYEE.locat_code = '08' 
and ((EMPLOYEE.date_hired > (SYSDATE - 21)) AND (EMPLOYEE.date_hired < SYSDATE));


Contacts
Lawson Team, Hope


DOWNTIME
none, you can run it early or late.  Doesn't matter. It's just for IT viewing for Security folks