create table Current_Work(

   ID COUNTER NOT NULL,

   Job_Type VARCHAR(255) NULL,

   Module_Type VARCHAR(10) NULL,

   Workstation_Name VARCHAR(80) NULL,

   Operator_Name VARCHAR(80) NULL,

   File_Name VARCHAR(255) NULL,

   File_Path VARCHAR(255) NULL,

   Date_Time DATETIME NULL,

   File_Creation_Date_Time DATETIME NULL

)



create table Deleted_Work(

   ID COUNTER NOT NULL,

   Job_Type VARCHAR(255) NULL,

   Module_Type VARCHAR(10) NULL,

   Workstation_Name VARCHAR(80) NULL,

   Operator_Name VARCHAR(80) NULL,

   File_Name VARCHAR(255) NULL,

   File_Path VARCHAR(255) NULL,

   Date_Time DATETIME NULL,

   File_Creation_Date_Time DATETIME NULL

)



create table Routed_Work(

   ID COUNTER NOT NULL,

   Job_Type VARCHAR(255) NULL,

   Module_Type VARCHAR(10) NULL,

   Workstation_Name VARCHAR(80) NULL,

   Operator_Name VARCHAR(80) NULL,

   File_Name VARCHAR(255) NULL,

   File_Path VARCHAR(255) NULL,

   Date_Time DATETIME NULL,

   File_Creation_Date_Time DATETIME NULL,

   Routed_To_Job_Type VARCHAR(255) NULL,

   Routed_To_File_Path VARCHAR(255) NULL

)



create table Completed_Work(

   ID COUNTER NOT NULL,

   Date_Time DATETIME NULL,

   Module_Type VARCHAR(10) NULL,

   Job_Type VARCHAR(255) NULL,

   Other_Destination VARCHAR(80) NULL,

   Input_Filename VARCHAR(255) NULL,

   Input_Directory VARCHAR(255) NULL,

   Output_Filename VARCHAR(255) NULL,

   Output_Directory VARCHAR(255) NULL,

   Output_Email_Address VARCHAR(255) NULL,

   Output_FtpServer_Address VARCHAR(255) NULL,

   Output_File_Format VARCHAR(5) NULL,

   Output_File_Size INTEGER NULL,

   Number_Of_Pages INTEGER NULL,

   Elapsed_Time INTEGER NULL,

   Routing_Rulename VARCHAR(255) NULL,

   Processed_By VARCHAR(80) NULL,

   KFI_Index_File VARCHAR(255) NULL,

   KFI_Index_File2 VARCHAR(255) NULL,

   Key_Strokes INTEGER NULL,

   Workstation_Name VARCHAR(80) NULL,

   Operator_Name VARCHAR(80) NULL,

   Zone_Errors INTEGER NULL,

   Scanner_Settings VARCHAR(255) NULL,

   Enhancement_Settings VARCHAR(255) NULL,

   File_Creation_Date_Time DATETIME NULL

)