Table of Contents



pears.HolidayPayYear

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

Description

Used in Configuring the Holiday Pay System.

Columns

Column Type Null Default Comment
Notes long varchar NULL
HolidayPayYearID char(20) NOT NULL
HolidayPayYearDescription char(50) NOT NULL
FirstWeekToEarn integer NOT NULL
LastWeekToEarn integer NOT NULL
FirstWeekToPay integer NOT NULL
LastWeekToPay integer NOT NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
EarnWeeks Index FirstWeekToEarn, LastWeekToEarn
PayWeeks Index FirstWeekToPay, LastWeekToPay

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."HolidayPayYear"
-- Table comment: Used in Configuring the Holiday Pay System.
-- Statement count: 4
 
CREATE TABLE "pears"."HolidayPayYear" (
    "Notes"                          long VARCHAR NULL
   ,"HolidayPayYearID"               CHAR(20) NOT NULL
   ,"HolidayPayYearDescription"      CHAR(50) NOT NULL
   ,"FirstWeekToEarn"                INTEGER NOT NULL
   ,"LastWeekToEarn"                 INTEGER NOT NULL
   ,"FirstWeekToPay"                 INTEGER NOT NULL
   ,"LastWeekToPay"                  INTEGER NOT NULL
   ,PRIMARY KEY ("HolidayPayYearID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."HolidayPayYear" IS 
	'Used in Configuring the Holiday Pay System.'
GO
 
 
CREATE INDEX "EarnWeeks" ON "pears"."HolidayPayYear"
    ( "FirstWeekToEarn","LastWeekToEarn" )
GO
 
 
CREATE INDEX "PayWeeks" ON "pears"."HolidayPayYear"
    ( "FirstWeekToPay","LastWeekToPay" )
GO