Table of Contents



pears.VacancyOverrideRateScheme

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

Description

For use by non-maintained function TempCustomRateGenerator() - not otherwise used by IQX

Columns

Column Type Null Default Comment
VacancyOverrideRateSchemeID char(20) NOT NULL
VacancyID char(20) NOT NULL
StartDate date NOT NULL
EndDate date NOT NULL
TempJobTypeID char(20) NOT NULL
UseOriginalChargeRate smallint NOT NULL 0
UseOriginalPayRate smallint NOT NULL 0
StaffID char(20) NOT NULL
WhenEntered timestamp NOT NULL current timestamp
Comments char(250) NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
Staff StaffID pears.staff (staffid) NOT NULL;
Vacancy VacancyID pears.vacancy (vacancyid) NOT NULL; ON DELETE CASCADE
RateScheme TempJobTypeID pears.TempJobType (TempJobTypeID) NOT NULL; ON DELETE CASCADE

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."VacancyOverrideRateScheme"
-- Table comment: For use by non-maintained function TempCustomRateGenerator() - not otherwise used by IQX
-- Statement count: 5
 
CREATE TABLE "pears"."VacancyOverrideRateScheme" (
    "VacancyOverrideRateSchemeID"    CHAR(20) NOT NULL
   ,"VacancyID"                      CHAR(20) NOT NULL
   ,"StartDate"                      DATE NOT NULL
   ,"EndDate"                        DATE NOT NULL
   ,"TempJobTypeID"                  CHAR(20) NOT NULL
   ,"UseOriginalChargeRate"          SMALLINT NOT NULL DEFAULT 0
   ,"UseOriginalPayRate"             SMALLINT NOT NULL DEFAULT 0
   ,"StaffID"                        CHAR(20) NOT NULL
   ,"WhenEntered"                    TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP
   ,"Comments"                       CHAR(250) NULL
   ,PRIMARY KEY ("VacancyOverrideRateSchemeID" ASC) 
   ,CONSTRAINT "CheckDates" CHECK("EndDate" > "StartDate")
)
GO
 
 
COMMENT ON TABLE "pears"."VacancyOverrideRateScheme" IS 
	'For use by non-maintained function TempCustomRateGenerator() - not otherwise used by IQX'
GO
 
 
ALTER TABLE "pears"."VacancyOverrideRateScheme"
    ADD NOT NULL FOREIGN KEY "Staff" ("StaffID" ASC)
    REFERENCES "pears"."staff" ("staffid")
GO
 
 
ALTER TABLE "pears"."VacancyOverrideRateScheme"
    ADD NOT NULL FOREIGN KEY "Vacancy" ("VacancyID" ASC)
    REFERENCES "pears"."vacancy" ("vacancyid")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."VacancyOverrideRateScheme"
    ADD NOT NULL FOREIGN KEY "RateScheme" ("TempJobTypeID" ASC)
    REFERENCES "pears"."TempJobType" ("TempJobTypeID")
    ON DELETE CASCADE
GO