NOTE - duplicate copy in YEAR END folder
       NewCommon\IS\KNOWLEDGE BASE\LAWSON\Year End

What/How it runs
Kronos/Manual, Must be run after last payroll of the year and prior to the first payroll of the new year
  UnitedWayStopOld.KNX - will put stop dates on any deduction that doesn't have one.
                         Should not have to run as the automation puts stop dates, but can in case of user data entry.
  UnitedWayFIXold.KNX - Fix deds from 2002 that do not have amounts, so stop dates cannot be added until required field is populated
                         Should not have to run again, but in case of errors it can be maniuplated to do whatever you need.

  UnitedWayLoad.KNX - Pulls from online form MySQL dbase and creates PR514 DEDLOADCSV
  UnitedWayPTO.KNX - Creates time record file that LaSandra wants to manually load


Parent process
Richard Carter wrote an online form for employees to fill out donation information.


Child process
Payroll runs and it pulls the deductions from paychecks and sends to GL.  Finance sends check to United Way.


Input system/files
InforDB/EMDEDMASTR
UWGift/donations


Output system/files
E:\Kronos\IFC\UnitedWayYrEndLawLoad\DEDLOADCSV's
/lawson/law/prod/work/DEDLOADCSV/DEDLOADCSV
E:\Kronos\IFC\UnitedWayYrEndLawLoad\PTOTimeRecs.csv
InforDB/PR14-EMDEDMASTR


Automation
None


ARCHIVE
None


Hard Coding
Ded Code UTWY, UPTO
start and stop dates
UWGift 5 donation types


Contacts
Lawson Team, Richard for online donation forms dbase
             Ruth, Hope for Lawson
Payroll, LaSandra


DOWNTIME
None, it is manual at year end


INSTRUCTIONS
Run STEPS to Stop All Deductions FIRST
1)
Sign onto LID as OLINK02
 jobdef PR214, run (Co = 10 and deds = UTWY and UPTO)
 sign onto portal as yourself and export to CSV to keep for documentation (PR514BEFORE.csv in E:\Kronos\IFC\UnitedWayYrEndLawLoad)
 filter by blank end date so you know total records to balance to

2)
Run Kronos UnitedWayYrEndLawLoad/UnitedWayStopOld.KNX
 balance DEDLOADCSV total recrods with PR214 no stop dates.

3)
ftp DEDLOADCSVstop to Infor as OLINK02 (DEDLOADCSV)
jobdef PR514UW in REPORT ONLY
 work errors and rerun 2 and 3 if necessary

4)
Run PR514UW in update
 sign onto portal and export to CSV to keep for documentation (PR514Stop.csv and PR514StopErrors.csv)
 work any errors

5)
Run PR214 again
 sign onto portal and export to CSV to keep for documentation (PR214Middle.csv)

6)
Run Kronos UnitedWayYrEndLawLoad/UnitedWayFIXold.KNX
 balance DEDLOADCSV total recrods with PR514StopErrors.csv.

7)
ftp DEDLOADCSVfix to Infor as OLINK02 (DEDLOADCSV)
jobdef PR514UW in REPORT ONLY
 work errors and rerun 6 and 7 if necessary

8)
Run PR514UW in update
 sign onto portal and export to CSV to keep for documentation (PR514Fix.csv)
 work any errors

9)
Run PR214 again
 sign onto portal and export to CSV to keep for documentation (PR214Fix.csv)



Run STEPS to load NEW donations
1)
Run Kronos UnitedWayYrEndLawLoad/UnitedWayLoad.KNX

2)
ftp DEDLOADCSVload to Infor as OLINK02 (DEDLOADCSV)
jobdef PR514UW in report only
 work errors and rerun 1 and 2 if necessary

3)
Run PR514UW in update
 sign onto portal and export to CSV to keep for documentation (PR514Load.csv)
 work any errors

4)
Run PR214 again
 sign onto portal and export to CSV to keep for documentation (PR214AFTER.csv)

5)
Run Kronos UnitedWayYrEndLawLoad/UnitedWayPTO.KNX
 email PTOTimeRecs.csv to LaSandra Hudson.  She will load the time records manually in Lawson the first payroll run

NOTE:
 UnitedWayBalance.KNX pulls the deductions from MySQL.  I used it to compare to Lawson to verify my code was working as expected.
   It can be used as necessary.