Table of Contents



pears.TempCustomJobRate

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

Description

Temporary table used in Estimating shifts revenue

Columns

Column Type Null Default Comment
GroupID char(20) NOT NULL
TempPayBandID char(20) NOT NULL
PayRate double NULL
ChargeRate double NULL
StartDate date NULL
EndDate date NULL
Grade char(4) NULL
Filter1 char(4) NULL
Filter2 char(4) NULL
Filter3 char(4) NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
TempCustomJobRateGroup Index GroupID

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TempCustomJobRate"
-- Table comment: Temporary table used in Estimating shifts revenue
-- Statement count: 3
 
CREATE GLOBAL TEMPORARY TABLE "pears"."TempCustomJobRate" (
    "GroupID"                        CHAR(20) NOT NULL
   ,"TempPayBandID"                  CHAR(20) NOT NULL
   ,"PayRate"                        DOUBLE NULL
   ,"ChargeRate"                     DOUBLE NULL
   ,"StartDate"                      DATE NULL
   ,"EndDate"                        DATE NULL
   ,"Grade"                          CHAR(4) NULL
   ,"Filter1"                        CHAR(4) NULL
   ,"Filter2"                        CHAR(4) NULL
   ,"Filter3"                        CHAR(4) NULL
) ON COMMIT PRESERVE ROWS
GO
 
 
COMMENT ON TABLE "pears"."TempCustomJobRate" IS 
	'Temporary table used in Estimating shifts revenue'
GO
 
 
CREATE INDEX "TempCustomJobRateGroup" ON "pears"."TempCustomJobRate"
    ( "GroupID" )
GO