Tables: W
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
- pears.WithHolds - Stores witholds. When a worker is blocked from a vacancy or a company
- pears.WPKAssignedRole - Link between Staff and WPKRoles.
- pears.WPKChangeTracker - Gives last ClickCount for each WPKChangeTrackerID - used for detecting need to refresh WPK elements.
- pears.WPKCustomGridColumn - Woodpecker Custom Column Definitions
- pears.WPKCustomGridColumnNamedSelection - Woodpecker Custom Column Definitions
- pears.WPKCustomGridColumnPrivateSelection - Woodpecker Custom Column Definitions
- pears.WPKForm - Woodpecker Form definitions.
- pears.WPKGlobalSwitch - Woodpecker Switch definitions.
- pears.WPKGlobalSwitchGroup - Groups of Woodpecker Switches.
- pears.WPKGlobalSwitchSetting - Individual values set for Woodpecker Switches.
- pears.WPKImage - Images (eg icons) Used by Woodpecker Forms.
- pears.WPKLayout - Woodpecker Layout definitions.
- pears.WPKLayoutView - Links Woodpecker Views to Layouts.
- pears.WPKLookupType - Lookups for WPK types eg ViewItemType etc
- pears.WPKMultiSelection - Temp Table - used to list records selected on a Woodpecker grid.
- pears.WPKPickList - Woodpecker centrally defined (and therefore cached and re-suable) pick lists. Defined either by SQL or choices listed in WPKPickListChoice.
- pears.WPKPickListChoice - Choices for WPKPickList when not defined in SQL.
- pears.WPKRole - Woodpecker Role definitions.
- pears.WPKView - Woodpecker View definitions.
- pears.WPKViewItem - Woodpecker View Item definitions.
127.0.0.1