pears.TempShiftAdd

When shifts are added they are temporary placed here and then when they are finished they are moved back.

• TempShiftAddID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TempShiftAdd"
-- Table comment: When shifts are added they are temporary placed here and then when they are finished they are moved back.
-- Statement count: 5
 
CREATE GLOBAL TEMPORARY TABLE "pears"."TempShiftAdd" (
    "TempShiftAddID"                 CHAR(20) NOT NULL
   ,"CompanyID"                      CHAR(20) NULL
   ,"VacancyID"                      CHAR(20) NULL
   ,"TempShiftTemplateID"            CHAR(20) NULL
   ,"EssentialSkill"                 CHAR(15) NULL
   ,"EssentialSkillGradeID"          CHAR(4) NULL
   ,"EssentialSkillChoiceList"       CHAR(100) NULL
   ,"Description"                    CHAR(50) NULL
   ,"TimeFrom"                       TIME NULL
   ,"TimeTo"                         TIME NULL
   ,"BreakMinutes"                   SMALLINT NULL
   ,"ShiftDate"                      DATE NULL
   ,"ReferenceRequired"              CHAR(1) NULL
   ,"ClientMustConfirm"              SMALLINT NULL DEFAULT 0
   ,"TempMustConfirm"                SMALLINT NULL DEFAULT 0
   ,"ReferenceCode"                  CHAR(20) NULL
   ,"OrderedBy"                      CHAR(50) NULL
   ,"TempShiftTypeID"                CHAR(2) NULL
   ,"AnalysisCode"                   CHAR(20) NULL
   ,"Moveable"                       SMALLINT NULL DEFAULT 0
   ,"Minutes"                        SMALLINT NULL
   ,"ManualCascadeDateTime"          SMALLINT NULL
   ,"CascadeDateTime"                TIMESTAMP NULL
   ,"ShiftCount"                     SMALLINT NULL DEFAULT 1
   ,"RecoveryHours"                  SMALLINT NULL DEFAULT 0
   ,"TempShiftOrderReasonID"         CHAR(20) NULL
   ,"ClientNote"                     CHAR(50) NULL
   ,PRIMARY KEY ("TempShiftAddID" ASC) 
) ON COMMIT PRESERVE ROWS
GO
 
 
COMMENT ON COLUMN "pears"."TempShiftAdd"."EssentialSkill" IS 
	'P|A;TagID;TagChoiceID;GradeTagID'
GO
 
 
COMMENT ON COLUMN "pears"."TempShiftAdd"."ReferenceRequired" IS 
	'on <E>ntry, <C>onfirmation, <T>imesheet entry. Blank for not required'
GO
 
 
COMMENT ON COLUMN "pears"."TempShiftAdd"."Minutes" IS 
	'Fill if shorter spell within the timespan'
GO
 
 
COMMENT ON TABLE "pears"."TempShiftAdd" IS 
	'When shifts are added they are temporary placed here and then when they are finished they are moved back.'
GO