pears.TempShiftTemplate

Definitions of Shift Templates - allowing quick creation of shifts with all necessary timing - grade - skill etc information. Templates remain linked to the created shift.

• TempShiftTemplateID

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TempShiftTemplate"
-- Table comment: Definitions of Shift Templates - allowing quick creation of shifts with all necessary timing - grade - skill etc information. Templates remain linked to the created shift.
-- Statement count: 14
 
CREATE TABLE "pears"."TempShiftTemplate" (
    "TempShiftTemplateID"            CHAR(20) NOT NULL
   ,"DepartmentID"                   CHAR(2) NULL
   ,"ClientTempShiftCode"            CHAR(12) NULL
   ,"TagLocation"                    CHAR(1) NULL
   ,"TagID"                          CHAR(3) NULL
   ,"TagChoiceID"                    CHAR(4) NULL
   ,"EssentialSkillGradeID"          CHAR(4) NULL
   ,"Description"                    CHAR(50) NOT NULL
   ,"TimeFrom"                       TIME NULL
   ,"TimeTo"                         TIME NULL
   ,"Moveable"                       SMALLINT NULL DEFAULT 0
   ,"Minutes"                        SMALLINT NULL
   ,"BreakMinutes"                   SMALLINT NULL
   ,"ReferenceRequired"              CHAR(1) NULL
   ,"ClientMustConfirm"              SMALLINT NULL DEFAULT 0
   ,"GradeTagID"                     CHAR(3) NULL
   ,"TempMustConfirm"                SMALLINT NULL DEFAULT 0
   ,"TempShiftTypeID"                CHAR(2) NULL
   ,"AnalysisCode"                   CHAR(20) NULL
   ,"RecoveryHours"                  SMALLINT NULL DEFAULT 0
   ,"ShiftOrderReasonRequired"       SMALLINT NULL DEFAULT 0
   ,"Defunct"                        SMALLINT NULL
   ,"SortOrder"                      SMALLINT NULL
   ,"ComplianceDomainID"             CHAR(20) NULL
   ,PRIMARY KEY ("TempShiftTemplateID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."TempShiftTemplate"."ClientTempShiftCode" IS 
	'Allows standard shifts to be customised for clients or groups'
GO
 
 
COMMENT ON COLUMN "pears"."TempShiftTemplate"."TagLocation" IS 
	'Essential skill in P General Questionnaire A Departmental Questionnaire'
GO
 
 
COMMENT ON COLUMN "pears"."TempShiftTemplate"."TagID" IS 
	'For the essential skill'
GO
 
 
COMMENT ON COLUMN "pears"."TempShiftTemplate"."TagChoiceID" IS 
	'For the essential skill'
GO
 
 
COMMENT ON COLUMN "pears"."TempShiftTemplate"."EssentialSkillGradeID" IS 
	'Either grade choice from TagID or choice from GradeTagID'
GO
 
 
COMMENT ON COLUMN "pears"."TempShiftTemplate"."Minutes" IS 
	'Fill if shorter spell within the timespan'
GO
 
 
COMMENT ON COLUMN "pears"."TempShiftTemplate"."ReferenceRequired" IS 
	'on <E>ntry, <C>onfirmation, <T>imesheet entry. Blank for not required'
GO
 
 
COMMENT ON COLUMN "pears"."TempShiftTemplate"."GradeTagID" IS 
	'If essential skill is NOT graded list'
GO
 
 
COMMENT ON COLUMN "pears"."TempShiftTemplate"."ShiftOrderReasonRequired" IS 
	'Will prompt for order reason on new shifts'
GO
 
 
COMMENT ON TABLE "pears"."TempShiftTemplate" IS 
	'Definitions of Shift Templates - allowing quick creation of shifts with all necessary timing - grade - skill etc information. Templates remain linked to the created shift.'
GO
 
 
ALTER TABLE "pears"."TempShiftTemplate"
    ADD FOREIGN KEY "department" ("DepartmentID" ASC)
    REFERENCES "pears"."Department" ("departmentid")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."TempShiftTemplate"
    ADD FOREIGN KEY "TempShiftType" ("TempShiftTypeID" ASC)
    REFERENCES "pears"."TempShiftType" ("TempShiftTypeID")
GO
 
 
ALTER TABLE "pears"."TempShiftTemplate"
    ADD FOREIGN KEY "ComplianceDomain" ("ComplianceDomainID" ASC)
    REFERENCES "pears"."ComplianceDomain" ("ComplianceDomainID")
    ON DELETE SET NULL
GO