Recruitment software that liberates your business https://iqxusers.co.uk/iqxhelp/ 2026-08-07T22:46:34+00:00 https://iqxusers.co.uk/iqxhelp/ https://iqxusers.co.uk/iqxhelp/lib/exe/fetch.php?media=wiki:logo.png text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:pears_broadbeanfields&rev=1786130660  pears.BroadBeanFields Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Broadbean working table Original SQL create view "pears"."BroadBeanFields"( "VacancyID", "JobType","JobTitle","JobRef","StartDate","Days","Weeks","Months","Duration","Salary_From","Salary_To", "Salary_Per","Salary_Benefits","Skills","Description","BroadBeanLocationID","BroadBeanIndustry" ) as select "Vacancy"."vaca… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:pears_companyinfo&rev=1786130660  pears.companyinfo Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Consolidated address and phone(etc) fields for a Company record Original SQL text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:pears_contactcompany&rev=1786130660  pears.contactcompany Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Gives linked Person and Company names for a Contact Event record Original SQL text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:pears_contacteventdepartmentview&rev=1786130660  pears.ContactEventDepartmentView Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Gives DepartmentID linked to a Contact Event record Original SQL text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:pears_contactperson&rev=1786130660  pears.contactperson Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Gives names of people linked to Contact Event records Original SQL create view "pears"."contactperson"( "contacteventid", "pname","pkeyname","ppersonid" ) as select "contactevent"."contacteventid","person"."name","person"."keyname","person"."personid" from "pears"."contactevent" key left outer join "pears"."person"… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:pears_contactview&rev=1786130660  pears.contactview Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Consolidates a range of information linked to a Contact Event record Original SQL text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:pears_globaldocumentdetail&rev=1786130660  pears.GlobalDocumentDetail Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create view "pears"."GlobalDocumentDetail"( "GlobalDocumentID", "DocID","DocType" ) as select "GlobalDocumentLink"."GlobalDocumentID","isnull"("GlobalDocumentLink"."DivisionID","GlobalDocumentLink"."DepartmentID") as "DocID","ifnull"("GlobalDocumentLink"."DivisionID",'DEPT','DIV') as "DocType" from "pears"."G… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:pears_personinfo&rev=1786130660  pears.personinfo Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description Gives consolidated address and phone etc fields for a Person record Original SQL text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:pears_staffinfo&rev=1786130660  pears.StaffInfo Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description View - Adds Branch - Division etc information to StaffID and name. Original SQL text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:pears_vacancyview&rev=1786130660  pears.VacancyView Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description View - Adds company address and other useful information to Vacancy Original SQL text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:pears_wpkphonetype&rev=1786130660  pears.WPKPhoneType Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Description View - Adds OwnerType to PhoneType table Original SQL create view "pears"."WPKPhoneType" as select "phonetype"."PhoneTypeID","phonetype"."Name",(if "isnull"("phonetype"."company",0) = 1 then 'C' else if "isnull"("phonetype"."contact",0) = 1 then 'E' else 'P' endif endif) as "OwnerType","phonetype"."Sortorder","phonetype"."… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:pears_wpkviewitemview&rev=1786130660  pears.WPKViewItemView Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. Original SQL create view "pears"."WPKViewItemView"( "WPKViewItemID", "WPKViewID","WPKFormID","Name","ItemType","Notes","SortOrder","CanView","CanEdit","Required","DefaultValue","Mask", "ComplexDataUpdateCommand","PickList","CheckValues","Sortable","BackColour","FontColour","Indent","DisplaySize","Descriptor", "DataType","DataLeng… text/html 2026-08-07T19:24:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://iqxusers.co.uk/iqxhelp/doku.php?id=database:views:start&rev=1786130660  Views Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. * pears.BroadBeanFields * pears.companyinfo * pears.contactcompany * pears.ContactEventDepartmentView * pears.contactperson * pears.contactview * pears.GlobalDocumentDetail * pears.personinfo * pears.StaffInfo * pears.VacancyView * pears.WPKPhoneType * pears.WPKViewItemView