====== pears.params ======
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
===== Description =====
System parameters. Only one record in table.
===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **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 | 0 | |
| positioninaddr | smallint | NULL | 0 | |
| deptinaddr | smallint | NULL | 0 | |
| autoappnumber | smallint | NULL | 0 | |
| nextappnumber | integer | NULL | | |
| disallowcontactedits | smallint | NULL | 0 | |
| editcontactdays | smallint | NULL | 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 | 0 | |
| autovacnumber | smallint | NULL | 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 | 0 | |
| nextplacnumber | integer | NULL | | |
| autopayrollnumber | smallint | NULL | 0 | |
| TimeSheetNumberSystem | smallint | NULL | 0 | 0:automatic 1:manual 2:none |
| 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 | 0 | |
| P45UnassignPayrollNumber | smallint | NULL | 0 | |
| InternalClientCode | char(12) | NULL | | For internal timesheets |
| AppNumberOnGrid | smallint | NULL | 0 | |
| EmailType | smallint | NULL | 1 | 0 MAPI, 1 MAPI with Inbox, 2 OfficeTalk |
| PayrollType | smallint | NULL | 0 | 0 None, 1 Tempaid, 2 Sage, 9 Other |
| BACSWeeklyPAYEOnly | smallint | NULL | 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 | 0 | |
| EmailSMS | smallint | NULL | 0 | |
| EmailRTF | smallint | NULL | 0 | |
| EmailWordSaveDoc | smallint | NULL | 0 | |
| EmailFaxAddress | char(50) | NULL | | Insert # for the number |
| EmailSMSAddress | char(50) | NULL | | Insert # for the number |
| EmailFaxSubject | char(50) | NULL | | Insert # for the number |
| EmailSMSSubject | char(50) | NULL | | Insert # for the number |
| 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 | 0 | |
| AllowPlainTextFax | smallint | NULL | 0 | |
| EmailStayLoggedIn | smallint | NULL | 0 | |
| DialPrefix | char(30) | NULL | | |
| DefaultTaxCode | char(5) | NULL | 'BR' | |
| DefaultNILetter | char(1) | NULL | 'A' | |
| DefaultWeek1Ind | smallint | NULL | 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 | | Set to NULL to use individual employment start date |
| 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 | | In multi-currency environments, all values will be specified in the HOME currency |
| 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 | 0 | |
| HTTPSMSRequest | char(200) | NULL | | Insert # for the number and ~ for the text |
| 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
===== Foreign Keys =====
* No outgoing foreign keys found.
===== Referenced By =====
* No incoming foreign keys found.
===== Indexes =====
* No indexes found.
===== Triggers =====
* No triggers found.
===== Original SQL =====
-- 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