pears.PayrollYear

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

• YearNumber

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

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