pears.HolidayPayYear

Used in Configuring the Holiday Pay System.

• HolidayPayYearID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No triggers found.

-- 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