Tables: T [iqx]

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

  * [[database:tables:pears_tag|pears.tag]] - User defined field definitions (Questionnaires)
  * [[database:tables:pears_tagchoice|pears.tagchoice]] - Choices for picklist responses to User Defined fields
  * [[database:tables:pears_tagcompliance|pears.TagCompliance]] - Used for tag with expiry dates - set sms/email messages
  * [[database:tables:pears_tagpersonexpirystatus|pears.TagPersonExpiryStatus]]
  * [[database:tables:pears_tagvalue|pears.tagvalue]] - Values for user defined fields
  * [[database:tables:pears_tempaccordnirecharge|pears.TempAccordNIReCharge]] - Used in Invoice (switch dependent) to groups accord requests per document
  * [[database:tables:pears_tempaccordnirechargeline|pears.TempAccordNIReChargeLine]] - Used in Invoice (switch dependent) to groups accord requests per document
  * [[database:tables:pears_tempaidcompany|pears.tempaidcompany]] - Next time sheet number for each TempAid payroll company.
  * [[database:tables:pears_tempcustomjobrate|pears.TempCustomJobRate]] - Temporary table used in Estimating shifts revenue
  * [[database:tables:pears_tempdesk|pears.tempdesk]] - Temp Desk settings.
  * [[database:tables:pears_tempdeskaccess|pears.TempdeskAccess]]
  * [[database:tables:pears_tempdeskagencypoolmember|pears.TempDeskAgencyPoolMember]] - Way of linking companies or secondary agency companies with desks.
  * [[database:tables:pears_tempdeskallowed|pears.TempdeskAllowed]]
  * [[database:tables:pears_tempholiday|pears.TempHoliday]] - A way of recording branch holidays - not used
  * [[database:tables:pears_tempholidayscheme|pears.TempHolidayScheme]] - Records making up the TempHolidayPayScheme. Each entry represents a line in the display calculation. Used in conjunction with the dedicated function - TempHolidayCalc()
  * [[database:tables:pears_tempinbox|pears.TempInbox]]
  * [[database:tables:pears_tempjobrate|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.
  * [[database:tables:pears_tempjobratemaster|pears.TempJobRateMaster]] - Detail line records with rates for each band for Temp Rate Schemes.
  * [[database:tables:pears_tempjobtype|pears.TempJobType]] - Header records for Temp Rate Schemes. Detail lines for each constituent band are in TempJobRateMaster.
  * [[database:tables:pears_templategrouptemplate|pears.TemplateGroupTemplate]] - Used in master roster and vacancy limits
  * [[database:tables:pears_templatestore|pears.templatestore]] - Word document template details. Actual templates are in the BlobStore with Class 'T'.
  * [[database:tables:pears_templatestoredivision|pears.templatestoredivision]] - Allows template store to be limited by division
  * [[database:tables:pears_templatestorestaff|pears.templatestorestaff]] - This table stores favourite templates that appear at top of lists
  * [[database:tables:pears_tempmatchcandidate|pears.TempMatchCandidate]] - Temporary table used in skill / availability matching
  * [[database:tables:pears_tempmatchplan|pears.TempMatchPlan]] - Temporary table used in skill / availability matching
  * [[database:tables:pears_tempmatchplancandidate|pears.TempMatchPlanCandidate]] - Temporary table used in skill / availability matching
  * [[database:tables:pears_tempmatchshift|pears.TempMatchShift]] - Temporary table used in skill / availability matching
  * [[database:tables:pears_temppayband|pears.TempPayBand]] - Details of the available pay bands.
  * [[database:tables:pears_temppoolmember|pears.TempPoolMember]] - Link between candidates and TempDesks.
  * [[database:tables:pears_temppricelist|pears.TempPriceList]] - Headers for available Price Lists.
  * [[database:tables:pears_tempprovtimesheet|pears.TempProvTimeSheet]] - Headers for provisional timesheets.
  * [[database:tables:pears_tempprovtimesheethistory|pears.TempProvTimeSheetHistory]] - History for provisional timesheets.
  * [[database:tables:pears_tempprovtimesheetline|pears.TempProvTimeSheetLine]] - Detail lines for Provisional timesheets.
  * [[database:tables:pears_tempprovtimesheetshift|pears.TempProvTimeSheetShift]] - Links Shift records to a Provisional Timesheet
  * [[database:tables:pears_tempratemarginaudit|pears.TempRateMarginAudit]]
  * [[database:tables:pears_tempratescript|pears.TempRateScript]] - Contains the code of each Rate Script - used to process shifts into rates.
  * [[database:tables:pears_tempscriptgenrates|pears.TempScriptGenRates]] - Used during the processing of Rates
  * [[database:tables:pears_tempsecagencyvacratescheme|pears.TempSecAgencyVacRateScheme]] - Links Seceondary Agency Rate Schemes to Vacancies.
  * [[database:tables:pears_tempshift|pears.TempShift]] - Individual shift details - once booked / worked / billed / paid etc. Also availability.
  * [[database:tables:pears_tempshiftadd|pears.TempShiftAdd]] - When shifts are added they are temporary placed here and then when they are finished they are moved back.
  * [[database:tables:pears_tempshiftcancelreason|pears.TempShiftCancelReason]] - User defined shift cancellation reason with settings for action required.
  * [[database:tables:pears_tempshiftcancelreasondept|pears.TempShiftCancelReasonDept]]
  * [[database:tables:pears_tempshiftinvoice|pears.TempShiftInvoice]]
  * [[database:tables:pears_tempshiftorderreason|pears.TempShiftOrderReason]] - User defined reasons for why shift is requested.
  * [[database:tables:pears_tempshiftorderreasondepartment|pears.TempShiftOrderReasonDepartment]] - Link between Departments and Shift Order Reasons. Reasons with no record are availabe to all Departments.
  * [[database:tables:pears_tempshiftplan|pears.TempShiftPlan]] - Shift requirements. Linked to TempShift when booked / worked / billed / paid etc.
  * [[database:tables:pears_tempshiftplanauthorise|pears.TempShiftPlanAuthorise]] - Record of (customer) authorisation of individual TempShiftPlan records.
  * [[database:tables:pears_tempshiftprogress|pears.TempShiftProgress]] - Progress of candidates put forward for TempShiftPlan.
  * [[database:tables:pears_tempshiftprogresshistory|pears.TempShiftProgressHistory]] - History of Progress of candidates put forward for TempShiftPlan.
  * [[database:tables:pears_tempshifttemplate|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.
  * [[database:tables:pears_tempshifttemplateallowed|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.
  * [[database:tables:pears_tempshifttype|pears.TempShiftType]] - List of defined shift types. Used in descriptions and rate processing.
  * [[database:tables:pears_tempshiftunavailablereason|pears.TempShiftUnavailableReason]] - User defined list of reasons why candidate is unavailable for a shift. Also link to resultant AWR implication.
  * [[database:tables:pears_tempsubsidy|pears.TempSubsidy]] - Details of subsidies (advances) paid to temps.
  * [[database:tables:pears_temptimesheet|pears.TempTimeSheet]] - Timesheet headers.
  * [[database:tables:pears_temptimesheetcancellation|pears.TempTimeSheetCancellation]] - Holds records of Timesheet Cancellations - works in conjunction with code in the TempTimesheetCancel and TempTimesheetComplete functions.
  * [[database:tables:pears_temptimesheetline|pears.TempTimeSheetLine]] - Time sheet detail lines.
  * [[database:tables:pears_terminology|pears.terminology]] - non standard
  * [[database:tables:pears_timesheetapprovallink|pears.TimesheetApprovalLink]]
  * [[database:tables:pears_timesheetcancelreason|pears.TimesheetCancelReason]] - Lookup of user defined reasons why Timesheet cancelled
  * [[database:tables:pears_timesheetsignature|pears.TimesheetSignature]]
  * [[database:tables:pears_timesheetunlinkedimage|pears.TimesheetUnlinkedImage]]
  * [[database:tables:pears_tmp_blob_import|pears.tmp_blob_import]]
  * [[database:tables:pears_tmpnewemployment|pears.TmpNewEmployment]]
  * [[database:tables:pears_town|pears.Town]] - List of Towns used to speed address entry
  * [[database:tables:pears_trengo|pears.Trengo]]
  * [[database:tables:pears_trengomessage|pears.TrengoMessage]]
  * [[database:tables:pears_trengoparameters|pears.TrengoParameters]]
  * [[database:tables:pears_trengosent|pears.TrengoSent]]
  * [[database:tables:pears_trengoticket|pears.TrengoTicket]]
  * [[database:tables:pears_tsimage|pears.TSImage]] - Used in the processing of Timesheet Images
  * [[database:tables:pears_tsinbox|pears.TSInbox]] - Used in the processing of Timesheet Images
  * [[database:tables:pears_tsqueryhistory|pears.TSQueryHistory]] - Record of changes to Timesheet Queries
  * [[database:tables:pears_tsquerylog|pears.TSQueryLog]] - Timesheet Queries - current state of each Query (log is an inaccurate description)
  * [[database:tables:pears_tsqueryreasons|pears.TSQueryReasons]] - Lookup of Timesheet Query Reasons
  * [[database:tables:pears_ttbroadbean|pears.TTBroadbean]] - Temporary table. Used to assemble Vacancy details when posting of Vacancies to Broadbean
  * [[database:tables:pears_ttbroadbeanboardstopostto|pears.TTBroadbeanBoardsToPostTo]] - Temporary table. Used to assemble Job Board list during posting of Vacancies to Broadbean