Table of Contents



pears.TempShiftAdd

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

Description

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

Columns

Column Type Null Default Comment
TempShiftAddID char(20) NOT NULL
CompanyID char(20) NULL
VacancyID char(20) NULL
TempShiftTemplateID char(20) NULL
EssentialSkill char(15) NULL PA;TagID;TagChoiceID;GradeTagID
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 on <E>ntry, <C>onfirmation, <T>imesheet entry. Blank for not required
ClientMustConfirm smallint NULL 0
TempMustConfirm smallint NULL 0
ReferenceCode char(20) NULL
OrderedBy char(50) NULL
TempShiftTypeID char(2) NULL
AnalysisCode char(20) NULL
Moveable smallint NULL 0
Minutes smallint NULL Fill if shorter spell within the timespan
ManualCascadeDateTime smallint NULL
CascadeDateTime timestamp NULL
ShiftCount smallint NULL 1
RecoveryHours smallint NULL 0
TempShiftOrderReasonID char(20) NULL
ClientNote char(50) NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

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