Tables: W [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: W ======
<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_withholdreason|pears.WithHoldReason]]
  * [[database:tables:pears_withholds|pears.WithHolds]] - Stores witholds.  When a worker is blocked from a vacancy or a company
  * [[database:tables:pears_wpkassignedrole|pears.WPKAssignedRole]] - Link between Staff and WPKRoles.
  * [[database:tables:pears_wpkchangetracker|pears.WPKChangeTracker]] - Gives last ClickCount for each WPKChangeTrackerID - used for detecting need to refresh WPK elements.
  * [[database:tables:pears_wpkcustomgridcolumn|pears.WPKCustomGridColumn]] - Woodpecker Custom Column Definitions
  * [[database:tables:pears_wpkcustomgridcolumnnamedselection|pears.WPKCustomGridColumnNamedSelection]] - Woodpecker Custom Column Definitions
  * [[database:tables:pears_wpkcustomgridcolumnprivateselection|pears.WPKCustomGridColumnPrivateSelection]] - Woodpecker Custom Column Definitions
  * [[database:tables:pears_wpkform|pears.WPKForm]] - Woodpecker Form definitions.
  * [[database:tables:pears_wpkglobalswitch|pears.WPKGlobalSwitch]] - Woodpecker Switch definitions.
  * [[database:tables:pears_wpkglobalswitchaltgroup|pears.WPKGlobalSwitchAltGroup]]
  * [[database:tables:pears_wpkglobalswitchgroup|pears.WPKGlobalSwitchGroup]] - Groups of Woodpecker Switches.
  * [[database:tables:pears_wpkglobalswitchsetting|pears.WPKGlobalSwitchSetting]] - Individual values set for Woodpecker Switches.
  * [[database:tables:pears_wpkimage|pears.WPKImage]] - Images (eg icons) Used by Woodpecker Forms.
  * [[database:tables:pears_wpklayout|pears.WPKLayout]] - Woodpecker Layout definitions.
  * [[database:tables:pears_wpklayoutview|pears.WPKLayoutView]] - Links Woodpecker Views to Layouts.
  * [[database:tables:pears_wpklayoutviewstaff|pears.WPKLayoutViewStaff]]
  * [[database:tables:pears_wpklookuptype|pears.WPKLookupType]] - Lookups for WPK types eg ViewItemType etc
  * [[database:tables:pears_wpkmultiselection|pears.WPKMultiSelection]] - Temp Table - used to list records selected on a Woodpecker grid.
  * [[database:tables:pears_wpkpicklist|pears.WPKPickList]] - Woodpecker centrally defined (and therefore cached and re-suable) pick lists. Defined either by SQL or choices listed in WPKPickListChoice.
  * [[database:tables:pears_wpkpicklistchoice|pears.WPKPickListChoice]] - Choices for WPKPickList when not defined in SQL.
  * [[database:tables:pears_wpkrole|pears.WPKRole]] - Woodpecker Role definitions.
  * [[database:tables:pears_wpkview|pears.WPKView]] - Woodpecker View definitions.
  * [[database:tables:pears_wpkviewcanselect|pears.WPKViewCanSelect]]
  * [[database:tables:pears_wpkviewitem|pears.WPKViewItem]] - Woodpecker View Item definitions.