Tables: T

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

pears.tag - User defined field definitions (Questionnaires)
pears.tagchoice - Choices for picklist responses to User Defined fields
pears.TagCompliance - Used for tag with expiry dates - set sms/email messages
pears.TagPersonExpiryStatus
pears.tagvalue - Values for user defined fields
pears.TempAccordNIReCharge - Used in Invoice (switch dependent) to groups accord requests per document
pears.TempAccordNIReChargeLine - Used in Invoice (switch dependent) to groups accord requests per document
pears.tempaidcompany - Next time sheet number for each TempAid payroll company.
pears.TempCustomJobRate - Temporary table used in Estimating shifts revenue
pears.tempdesk - Temp Desk settings.
pears.TempdeskAccess
pears.TempDeskAgencyPoolMember - Way of linking companies or secondary agency companies with desks.
pears.TempdeskAllowed
pears.TempHoliday - A way of recording branch holidays - not used
pears.TempHolidayScheme - Records making up the TempHolidayPayScheme. Each entry represents a line in the display calculation. Used in conjunction with the dedicated function - TempHolidayCalc()
pears.TempInbox
pears.TempJobRate - Contains the pay & charge rates for individual vacancies and placements. This is the source of the rates used when a timesheet is created. First any rates for the Placement itself are looked for. If not found then the Vacancy is checked.
pears.TempJobRateMaster - Detail line records with rates for each band for Temp Rate Schemes.
pears.TempJobType - Header records for Temp Rate Schemes. Detail lines for each constituent band are in TempJobRateMaster.
pears.TemplateGroupTemplate - Used in master roster and vacancy limits
pears.templatestore - Word document template details. Actual templates are in the BlobStore with Class 'T'.
pears.templatestoredivision - Allows template store to be limited by division
pears.templatestorestaff - This table stores favourite templates that appear at top of lists
pears.TempMatchCandidate - Temporary table used in skill / availability matching
pears.TempMatchPlan - Temporary table used in skill / availability matching
pears.TempMatchPlanCandidate - Temporary table used in skill / availability matching
pears.TempMatchShift - Temporary table used in skill / availability matching
pears.TempPayBand - Details of the available pay bands.
pears.TempPoolMember - Link between candidates and TempDesks.
pears.TempPriceList - Headers for available Price Lists.
pears.TempProvTimeSheet - Headers for provisional timesheets.
pears.TempProvTimeSheetHistory - History for provisional timesheets.
pears.TempProvTimeSheetLine - Detail lines for Provisional timesheets.
pears.TempProvTimeSheetShift - Links Shift records to a Provisional Timesheet
pears.TempRateMarginAudit
pears.TempRateScript - Contains the code of each Rate Script - used to process shifts into rates.
pears.TempScriptGenRates - Used during the processing of Rates
pears.TempSecAgencyVacRateScheme - Links Seceondary Agency Rate Schemes to Vacancies.
pears.TempShift - Individual shift details - once booked / worked / billed / paid etc. Also availability.
pears.TempShiftAdd - When shifts are added they are temporary placed here and then when they are finished they are moved back.
pears.TempShiftCancelReason - User defined shift cancellation reason with settings for action required.
pears.TempShiftCancelReasonDept
pears.TempShiftInvoice
pears.TempShiftOrderReason - User defined reasons for why shift is requested.
pears.TempShiftOrderReasonDepartment - Link between Departments and Shift Order Reasons. Reasons with no record are availabe to all Departments.
pears.TempShiftPlan - Shift requirements. Linked to TempShift when booked / worked / billed / paid etc.
pears.TempShiftPlanAuthorise - Record of (customer) authorisation of individual TempShiftPlan records.
pears.TempShiftProgress - Progress of candidates put forward for TempShiftPlan.
pears.TempShiftProgressHistory - History of Progress of candidates put forward for TempShiftPlan.
pears.TempShiftTemplate - Definitions of Shift Templates - allowing quick creation of shifts with all necessary timing - grade - skill etc information. Templates remain linked to the created shift.
pears.TempShiftTemplateAllowed - Controls whether a particular Shift Template is allowed for an individual Vacancy. If no record for a given Vacancy all Shift Templates for the vacancy Department are allowed.
pears.TempShiftType - List of defined shift types. Used in descriptions and rate processing.
pears.TempShiftUnavailableReason - User defined list of reasons why candidate is unavailable for a shift. Also link to resultant AWR implication.
pears.TempSubsidy - Details of subsidies (advances) paid to temps.
pears.TempTimeSheet - Timesheet headers.
pears.TempTimeSheetCancellation - Holds records of Timesheet Cancellations - works in conjunction with code in the TempTimesheetCancel and TempTimesheetComplete functions.
pears.TempTimeSheetLine - Time sheet detail lines.
pears.terminology - non standard
pears.TimesheetApprovalLink
pears.TimesheetCancelReason - Lookup of user defined reasons why Timesheet cancelled
pears.TimesheetSignature
pears.TimesheetUnlinkedImage
pears.tmp_blob_import
pears.TmpNewEmployment
pears.Town - List of Towns used to speed address entry
pears.Trengo
pears.TrengoMessage
pears.TrengoParameters
pears.TrengoSent
pears.TrengoTicket
pears.TSImage - Used in the processing of Timesheet Images
pears.TSInbox - Used in the processing of Timesheet Images
pears.TSQueryHistory - Record of changes to Timesheet Queries
pears.TSQueryLog - Timesheet Queries - current state of each Query (log is an inaccurate description)
pears.TSQueryReasons - Lookup of Timesheet Query Reasons
pears.TTBroadbean - Temporary table. Used to assemble Vacancy details when posting of Vacancies to Broadbean
pears.TTBroadbeanBoardsToPostTo - Temporary table. Used to assemble Job Board list during posting of Vacancies to Broadbean