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.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.TempDeskAgencyPoolMember - Way of linking companies or secondary agency companies with desks.
- 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.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.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.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.TimesheetCancelReason - Lookup of user defined reasons why Timesheet cancelled
- pears.Town - List of Towns used to speed address entry
- 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
127.0.0.1