pears.params

System parameters. Only one record in table.

• dbid

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."params"
-- Table comment: System parameters. Only one record in table.
-- Statement count: 13
 
-------------------------------------------------
--   Create tables
-------------------------------------------------
 
CREATE TABLE "pears"."params" (
    "dbid"                           CHAR(2) NOT NULL
   ,"whichconsultant"                CHAR(1) NULL
   ,"applicantname"                  CHAR(20) NULL
   ,"plapplicantname"                CHAR(20) NULL
   ,"contacteventname"               CHAR(20) NULL
   ,"plcontacteventname"             CHAR(20) NULL
   ,"copersonname"                   CHAR(20) NULL
   ,"plcopersonname"                 CHAR(20) NULL
   ,"staffname"                      CHAR(20) NULL
   ,"plstaffname"                    CHAR(20) NULL
   ,"plcompanyname"                  CHAR(20) NULL
   ,"plpersonname"                   CHAR(20) NULL
   ,"plvacancyname"                  CHAR(20) NULL
   ,"str1name"                       CHAR(20) NULL
   ,"str2name"                       CHAR(20) NULL
   ,"str3name"                       CHAR(20) NULL
   ,"str4name"                       CHAR(20) NULL
   ,"str5name"                       CHAR(20) NULL
   ,"vacancynotesname"               CHAR(30) NULL
   ,"personnotesname"                CHAR(30) NULL
   ,"commissionformula"              CHAR(200) NULL
   ,"vacancyname"                    CHAR(20) NULL
   ,"lastvacreference"               CHAR(10) NULL
   ,"companyname"                    CHAR(20) NULL
   ,"personname"                     CHAR(20) NULL
   ,"jobtitlename"                   CHAR(20) NULL
   ,"pljobtitlename"                 CHAR(20) NULL
   ,"branchname"                     CHAR(20) NULL
   ,"plbranchname"                   CHAR(20) NULL
   ,"blobinfile"                     SMALLINT NULL DEFAULT 0
   ,"positioninaddr"                 SMALLINT NULL DEFAULT 0
   ,"deptinaddr"                     SMALLINT NULL DEFAULT 0
   ,"autoappnumber"                  SMALLINT NULL DEFAULT 0
   ,"nextappnumber"                  INTEGER NULL
   ,"disallowcontactedits"           SMALLINT NULL DEFAULT 0
   ,"editcontactdays"                SMALLINT NULL DEFAULT 0
   ,"dbname"                         CHAR(30) NULL
   ,"tempaiddirectory"               CHAR(100) NULL
   ,"primcontactname"                CHAR(20) NULL
   ,"payrolllocked"                  SMALLINT NULL
   ,"availabilityusage"              SMALLINT NULL
   ,"weekonefriday"                  DATE NULL
   ,"currenttempyearnumber"          SMALLINT NULL
   ,"dbupflag"                       INTEGER NULL
   ,"lastpayrollnumber"              INTEGER NULL
   ,"readonlycontactoutcomes"        SMALLINT NULL DEFAULT 0
   ,"autovacnumber"                  SMALLINT NULL DEFAULT 0
   ,"nextvacnumber"                  INTEGER NULL
   ,"CurrentAnalysisPeriod"          INTEGER NULL
   ,"PermCommissionRate"             NUMERIC(6,2) NULL
   ,"NominalSegment1Length"          SMALLINT NULL
   ,"NominalSegment2Length"          SMALLINT NULL
   ,"NominalSegment3Length"          SMALLINT NULL
   ,"NominalSegment4Length"          SMALLINT NULL
   ,"NominalSegment5Length"          SMALLINT NULL
   ,"NominalSegment1Desc"            CHAR(12) NULL
   ,"NominalSegment2Desc"            CHAR(12) NULL
   ,"NominalSegment3Desc"            CHAR(12) NULL
   ,"NominalSegment4Desc"            CHAR(12) NULL
   ,"NominalSegment5Desc"            CHAR(12) NULL
   ,"Temps2000"                      SMALLINT NULL
   ,"NextTimeSheetNumber"            INTEGER NULL
   ,"MonthOneOffset"                 SMALLINT NULL
   ,"DefaultShiftFrom"               TIME NULL
   ,"DefaultShiftTo"                 TIME NULL
   ,"RemoveSpacesFromKeynames"       SMALLINT NULL
   ,"LSMAgencyID"                    INTEGER NULL
   ,"LastTransferBatch"              INTEGER NULL
   ,"SendCVContactClass"             CHAR(2) NULL
   ,"autoplacnumber"                 SMALLINT NULL DEFAULT 0
   ,"nextplacnumber"                 INTEGER NULL
   ,"autopayrollnumber"              SMALLINT NULL DEFAULT 0
   ,"TimeSheetNumberSystem"          SMALLINT NULL DEFAULT 0
   ,"LSMPassword"                    CHAR(10) NULL
   ,"LSMDirectory"                   CHAR(50) NULL
   ,"LSMDeltaPrefix"                 CHAR(10) NULL
   ,"LastLSMTransferBatch"           INTEGER NULL
   ,"LastLSMFTPTransferBatch"        INTEGER NULL
   ,"LastLSMEmployee"                INTEGER NULL
   ,"LastLSMClient"                  INTEGER NULL
   ,"LastLSMVacancy"                 INTEGER NULL
   ,"LastLSMChargerate"              INTEGER NULL
   ,"LastLSMSubsidy"                 INTEGER NULL
   ,"P45BlockTimesheets"             SMALLINT NULL DEFAULT 0
   ,"P45UnassignPayrollNumber"       SMALLINT NULL DEFAULT 0
   ,"InternalClientCode"             CHAR(12) NULL
   ,"AppNumberOnGrid"                SMALLINT NULL DEFAULT 0
   ,"EmailType"                      SMALLINT NULL DEFAULT 1
   ,"PayrollType"                    SMALLINT NULL DEFAULT 0
   ,"BACSWeeklyPAYEOnly"             SMALLINT NULL DEFAULT 0
   ,"lastclientcode"                 INTEGER NULL
   ,"LastLSMPermInvoice"             INTEGER NULL
   ,"LSMDialup"                      CHAR(30) NULL
   ,"LSMDialupUsage"                 SMALLINT NULL
   ,"LSMFTPServer"                   CHAR(50) NULL
   ,"SendCVProgressStatus"           CHAR(1) NULL
   ,"EmailFax"                       SMALLINT NULL DEFAULT 0
   ,"EmailSMS"                       SMALLINT NULL DEFAULT 0
   ,"EmailRTF"                       SMALLINT NULL DEFAULT 0
   ,"EmailWordSaveDoc"               SMALLINT NULL DEFAULT 0
   ,"EmailFaxAddress"                CHAR(50) NULL
   ,"EmailSMSAddress"                CHAR(50) NULL
   ,"EmailFaxSubject"                CHAR(50) NULL
   ,"EmailSMSSubject"                CHAR(50) NULL
   ,"SendEmailContactClass"          CHAR(2) NULL
   ,"SendFaxContactClass"            CHAR(2) NULL
   ,"SendSMSContactClass"            CHAR(2) NULL
   ,"ReceiveEmailContactClass"       CHAR(2) NULL
   ,"FaxHeaderCVText"                CHAR(50) NULL
   ,"FaxHeaderToWord"                SMALLINT NULL
   ,"FaxLetterAsAttachment"          SMALLINT NULL DEFAULT 0
   ,"AllowPlainTextFax"              SMALLINT NULL DEFAULT 0
   ,"EmailStayLoggedIn"              SMALLINT NULL DEFAULT 0
   ,"DialPrefix"                     CHAR(30) NULL
   ,"DefaultTaxCode"                 CHAR(5) NULL DEFAULT 'BR'
   ,"DefaultNILetter"                CHAR(1) NULL DEFAULT 'A'
   ,"DefaultWeek1Ind"                SMALLINT NULL DEFAULT 1
   ,"BackupDirectory"                CHAR(50) NULL
   ,"CashFriday"                     SMALLINT NULL
   ,"PhotoCaptureFile"               CHAR(50) NULL
   ,"MultiCurrency"                  SMALLINT NULL
   ,"ReservePayrollToAccounts"       SMALLINT NULL
   ,"DefaultVATExempt"               SMALLINT NULL
   ,"InitialApplicantStatus"         CHAR(1) NULL
   ,"HolidayYearStart"               DATE NULL
   ,"colourDesktop"                  INTEGER NULL
   ,"colourCompany"                  INTEGER NULL
   ,"colourPerson"                   INTEGER NULL
   ,"colourEvent"                    INTEGER NULL
   ,"colourVacancy"                  INTEGER NULL
   ,"colourProgress"                 INTEGER NULL
   ,"colourPlacement"                INTEGER NULL
   ,"colourTemp"                     INTEGER NULL
   ,"colourAgency"                   INTEGER NULL
   ,"TempMarginActual"               SMALLINT NULL
   ,"DefaultVacancyClass"            CHAR(20) NULL
   ,"MultiTempInvoice"               SMALLINT NULL
   ,"DiaryResolution"                SMALLINT NULL
   ,"DiaryTaskList"                  SMALLINT NULL
   ,"EmploymentNoteName"             CHAR(20) NULL
   ,"UseAnalysisPeriods"             tinyint NULL
   ,"PayrollCoIDFromTemp"            tinyint NULL
   ,"HomeCurrency"                   SMALLINT NULL
   ,"ClientCodePrefixes"             CHAR(50) NULL
   ,"PayrollCoIDs"                   CHAR(20) NULL
   ,"PrefixPayrollNoWithCoID"        tinyint NULL
   ,"OurRefPrefixes"                 CHAR(50) NULL
   ,"ReserveMiscToAccounts"          tinyint NULL
   ,"AutoAccountCode"                tinyint NULL
   ,"ForceBankScan"                  tinyint NULL
   ,"UseGeneralAvailability"         tinyint NULL
   ,"divisionname"                   CHAR(20) NULL
   ,"pldivisionname"                 CHAR(20) NULL
   ,"HTTPSMS"                        SMALLINT NULL DEFAULT 0
   ,"HTTPSMSRequest"                 CHAR(200) NULL
   ,"LSMETimesheets"                 tinyint NULL
   ,"TimesheetTotalCheckOnlyIfPlan"  tinyint NULL
   ,"TimesheetHoursPaidEqualsCharged" tinyint NULL
   ,"BlockTaxMethodChangesWhenPayrollNoAssig" tinyint NULL
   ,"OverrideTimeSheetDates"         tinyint NULL
   ,"NoNIMask"                       tinyint NULL
   ,"TimesheetNumberPrefix"          CHAR(5) NULL
   ,"UnitsBeforeRateOnTimesheet"     tinyint NULL
   ,"PersonCurrentStates"            CHAR(20) NULL
   ,"TimesheetShowPlacementElements" tinyint NULL
   ,"TheirRefAlwaysRequiredOnTimesheets" tinyint NULL
   ,"AllowVacancyInvoiceAddress"     tinyint NULL
   ,"TimesheetCurrentWeekShiftsOnly" tinyint NULL
   ,"DefaultVacancyTemp"             tinyint NULL
   ,"UseSecondaryAgencies"           tinyint NULL
   ,"Version2"                       tinyint NULL
   ,"SecondaryCascade"               tinyint NULL
   ,"EscalatePopups"                 tinyint NULL
   ,"dblicense"                      long VARCHAR NULL
   ,"SendHolidayPayToLSM"            tinyint NULL
   ,"noOLEblobwrappers"              tinyint NULL
   ,"NominalSegment1LinkToUser"      tinyint NULL
   ,"NominalSegment2LinkToUser"      tinyint NULL
   ,"NominalSegment3LinkToUser"      tinyint NULL
   ,"NominalSegment4LinkToUser"      tinyint NULL
   ,"NominalSegment5LinkToUser"      tinyint NULL
   ,"BlobExternalStorage"            tinyint NULL
   ,"BlobExternalRootFolder"         CHAR(100) NULL
   ,"LastAnalysisBatch"              INTEGER NULL
   ,PRIMARY KEY ("dbid" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."params"."TimeSheetNumberSystem" IS 
	'0:automatic 1:manual 2:none'
GO
 
 
COMMENT ON COLUMN "pears"."params"."InternalClientCode" IS 
	'For internal timesheets'
GO
 
 
COMMENT ON COLUMN "pears"."params"."EmailType" IS 
	'0 MAPI, 1 MAPI with Inbox, 2 OfficeTalk'
GO
 
 
COMMENT ON COLUMN "pears"."params"."PayrollType" IS 
	'0 None, 1 Tempaid, 2 Sage, 9 Other'
GO
 
 
COMMENT ON COLUMN "pears"."params"."EmailFaxAddress" IS 
	'Insert # for the number'
GO
 
 
COMMENT ON COLUMN "pears"."params"."EmailSMSAddress" IS 
	'Insert # for the number'
GO
 
 
COMMENT ON COLUMN "pears"."params"."EmailFaxSubject" IS 
	'Insert # for the number'
GO
 
 
COMMENT ON COLUMN "pears"."params"."EmailSMSSubject" IS 
	'Insert # for the number'
GO
 
 
COMMENT ON COLUMN "pears"."params"."HolidayYearStart" IS 
	'Set to NULL to use individual employment start date'
GO
 
 
COMMENT ON COLUMN "pears"."params"."HomeCurrency" IS 
	'In multi-currency environments, all values will be specified in the HOME currency'
GO
 
 
COMMENT ON COLUMN "pears"."params"."HTTPSMSRequest" IS 
	'Insert # for the number and ~ for the text'
GO
 
 
COMMENT ON TABLE "pears"."params" IS 
	'System parameters. Only one record in table.'
GO