pears.NetDBSetupPrerequisites [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.NetDBSetupPrerequisites ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create procedure "pears"."NetDBSetupPrerequisites"( in "WebUserID" char(20) default null ) 
begin
  create table if not exists "pears"."ErrorList"(
    "ErrorCode" integer not null,
    "ErrorMessage" char(250) null,
    "TotalCount" integer null,
    "LastOccurrence" "datetime" null,
    "HelpMessage" char(1024) null,
    constraint "ErrorCode" primary key("ErrorCode" asc),
    ) in "system";
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 79,'invalid new user',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 80,'missing Parameter string',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 82,'Invalid data',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 83,'invalid user',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 84,'invalid type',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 85,'invalid message type',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 86,'invalid shift type',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 87,'invalid availability type',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 88,'Invalid transaction type',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 89,'invalid staff',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 90,'Unable to create a reminder',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 91,'No default ID found',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 92,'unable to create a reminder',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 93,'pDiaryID required',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 94,'Invalid Event Type',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 95,'Invalid Event code',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 96,'Invalid Action',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 97,'There is an error with the linking on your profile',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 99,'Permission denied',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 100,'invalid date or time',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 101,'invalid date',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 102,'invalid time',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 105,'invalid start date',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 106,'invalid start time',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 107,'invalid end date',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 108,'invalid end time',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 110,'Invalid Event date',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 111,'invalid shift date',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 112,'invalid date of birth',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 113,'Shift must not be in the past','If you wish to record an event in the past, please contact your consultant' ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 114,'Unable to add events more than six months in the future',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 115,'Start date must be a Monday',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 116,'Finish day appears to be before start day',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 117,'Date must be between',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 118,'Minutes Before cannot exceed 30240 minutes (or 21 days)',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 119,'pdate is null',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 120,'Invalid start date or time',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 121,'Invalid end date or time',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 122,'Finish time appears to be before Start time',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 130,'order reason required',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 132,'RefCode required','https://iqxusers.co.uk/iqxhelp/doku.php?id=iqxweb:pages-functions:login' ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 133,'please enter a comment detailing your reasons',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 135,'quantity is 0',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 136,'reason is compulsory',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 138,'Missing surname, forenames, email address or template contact ID',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 139,'incomplete message',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 140,'Please ensure there is a Company Name',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 141,'Please ensure there is a valid Account Code',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 142,'Please enter both a forename and a surname',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 143,'No Fax number or Email Address provided.',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 144,'no message',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 145,'Description required',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 146,'Please ensure the Position field is filled',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 160,'Check NI number',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 161,'invalid quantity',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 162,'please check data',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 163,'Please use a unique Account Code',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 164,'Check your bank details are correct',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 165,'invalid recipient',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 166,'Please enter a valid Pay Rate',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 167,'Please enter a valid Charge Rate',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 168,'no SMS-enabled phone or email address',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 169,'Please check Vacancy',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 170,'Please check Person',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 171,'Please check Status',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 172,'Please enter a valid shift type',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 180,'You are not logged in',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 181,'please enter a login',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 186,'only candidates should use the registration form - other users should log in directly',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 190,'please enter a valid email address',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 191,'Registration',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 194,'unspecified error',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 200,'Timesheet already finalised or deleted',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 201,'Not able to create line',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 202,'Cancellation failed',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 203,'Confirmation failed',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 204,'Candidate not available',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 205,'Not an agency login',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 206,'No company link',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 207,'*** has already been submitted',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 208,'Already Applied',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 209,'Apply',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 210,'the Note is too long. It has been limited to 50 characters',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 211,'this person is already in the short list',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 212,'You have already Applied for this post',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 213,'This person is already in the short list',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 214,'Login not found',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 215,'you may already be registered','please contact the agency' ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 216,'Please contact our support team for information why you can''t register',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 217,'you appear to be logged in already','please close and re-open your browser' ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 218,'A record exists for you but is archived. Please contact',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 219,'Login exists but the link broken. Please contact',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 220,'Person exists but there is no login. Please contact',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 221,'that email address already exists. Please check it or contact your consultant',null ) ;
  insert into "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) on existing update defaults off values( 222,'Email address already in use',null ) 
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetDBSetupPrerequisites" IS 
{create PROCEDURE pears."NetDBSetupPrerequisites"(in WebUserID char(20) default null)
BEGIN
	
     CREATE TABLE IF NOT EXISTS pears.ErrorList (
	    ErrorCode INTEGER NOT NULL,
	    ErrorMessage CHAR(250) NULL,
	    TotalCount INTEGER NULL,
	    LastOccurrence datetime NULL,
	    HelpMessage CHAR(1024) NULL,
	    CONSTRAINT ErrorCode PRIMARY KEY ( ErrorCode ASC )
    ) IN system;

    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(79,'invalid new user',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(80,'missing Parameter string',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(82,'Invalid data',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(83,'invalid user',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(84,'invalid type',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(85,'invalid message type',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(86,'invalid shift type',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(87,'invalid availability type',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(88,'Invalid transaction type',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(89,'invalid staff',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(90,'Unable to create a reminder',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(91,'No default ID found',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(92,'unable to create a reminder',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(93,'pDiaryID required',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(94,'Invalid Event Type',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(95,'Invalid Event code',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(96,'Invalid Action',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(97,'There is an error with the linking on your profile',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(99,'Permission denied',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(100,'invalid date or time',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(101,'invalid date',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(102,'invalid time',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(105,'invalid start date',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(106,'invalid start time',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(107,'invalid end date',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(108,'invalid end time',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(110,'Invalid Event date',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(111,'invalid shift date',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(112,'invalid date of birth',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(113,'Shift must not be in the past','If you wish to record an event in the past, please contact your consultant');
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(114,'Unable to add events more than six months in the future',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(115,'Start date must be a Monday',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(116,'Finish day appears to be before start day',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(117,'Date must be between',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(118,'Minutes Before cannot exceed 30240 minutes (or 21 days)',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(119,'pdate is null',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(120,'Invalid start date or time',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(121,'Invalid end date or time',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(122,'Finish time appears to be before Start time',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(130,'order reason required',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(132,'RefCode required','https://iqxusers.co.uk/iqxhelp/doku.php?id=iqxweb:pages-functions:login');
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(133,'please enter a comment detailing your reasons',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(135,'quantity is 0',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(136,'reason is compulsory',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(138,'Missing surname, forenames, email address or template contact ID',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(139,'incomplete message',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(140,'Please ensure there is a Company Name',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(141,'Please ensure there is a valid Account Code',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(142,'Please enter both a forename and a surname',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(143,'No Fax number or Email Address provided.',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(144,'no message',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(145,'Description required',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(146,'Please ensure the Position field is filled',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(160,'Check NI number',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(161,'invalid quantity',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(162,'please check data',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(163,'Please use a unique Account Code',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(164,'Check your bank details are correct',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(165,'invalid recipient',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(166,'Please enter a valid Pay Rate',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(167,'Please enter a valid Charge Rate',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(168,'no SMS-enabled phone or email address',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(169,'Please check Vacancy',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(170,'Please check Person',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(171,'Please check Status',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(172,'Please enter a valid shift type',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(180,'You are not logged in',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(181,'please enter a login',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(186,'only candidates should use the registration form - other users should log in directly',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(190,'please enter a valid email address',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(191,'Registration',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(194,'unspecified error',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(200,'Timesheet already finalised or deleted',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(201,'Not able to create line',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(202,'Cancellation failed',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(203,'Confirmation failed',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(204,'Candidate not available',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(205,'Not an agency login',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(206,'No company link',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(207,'*** has already been submitted',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(208,'Already Applied',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(209,'Apply',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(210,'the Note is too long. It has been limited to 50 characters',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(211,'this person is already in the short list',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(212,'You have already Applied for this post',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(213,'This person is already in the short list',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(214,'Login not found',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(215,'you may already be registered','please contact the agency');
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(216,'Please contact our support team for information why you can''t register',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(217,'you appear to be logged in already','please close and re-open your browser');
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(218,'A record exists for you but is archived. Please contact',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(219,'Login exists but the link broken. Please contact',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(220,'Person exists but there is no login. Please contact',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(221,'that email address already exists. Please check it or contact your consultant',null);
    insert into ErrorList (ErrorCode,ErrorMessage,HelpMessage) on existing update defaults off values(222,'Email address already in use',null);

END
}
</code>