Table of Contents



pears.PayrollYear

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

Description

Details of the start and number of weeks in each payroll year.

Columns

Column Type Null Default Comment
YearNumber smallint NOT NULL
Week1Friday date NOT NULL
NumberOfWeeks smallint NOT NULL 52

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Name Timing Event
UpdatePayrollCalendar after insert,delete,update order 1

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."PayrollYear"
-- Table comment: Details of the start and number of weeks in each payroll year.
-- Statement count: 4
 
CREATE TABLE "pears"."PayrollYear" (
    "YearNumber"                     SMALLINT NOT NULL
   ,"Week1Friday"                    DATE NOT NULL
   ,"NumberOfWeeks"                  SMALLINT NOT NULL DEFAULT 52
   ,PRIMARY KEY ("YearNumber" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."PayrollYear" IS 
	'Details of the start and number of weeks in each payroll year.'
GO
 
 
CREATE TRIGGER "UpdatePayrollCalendar" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."PayrollYear"
FOR each statement
BEGIN
  CALL "pears"."PopulatePayrollCalendar"()
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."PayrollYear"."UpdatePayrollCalendar" IS 
{CREATE TRIGGER UpdatePayrollCalendar 
 after INSERT,DELETE,UPDATE ORDER 1 ON
 pears.PayrollYear
FOR each statement
BEGIN
  CALL pears.PopulatePayrollCalendar()
END
}
GO