Table of Contents



pears.ComplianceViewData

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

Description

Temp Table - Used to construct the Person compliance view.

Columns

Column Type Null Default Comment
ComplianceViewDataID char(20) NOT NULL
InstanceID char(20) NULL
StateChangeText long varchar NULL
PlacementAllowedText long varchar NULL
TempshiftAllowedText long varchar NULL
ComplianceText1 long varchar NULL
ComplianceText2 long varchar NULL
PassOrFailOrWarn char(1) NULL
ComplianceColour1 char(20) NULL
ComplianceColour2 char(20) NULL
ComplianceGroup smallint NULL
SortOrder smallint NULL
TagId char(3) NULL
TagLocation char(3) NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."ComplianceViewData"
-- Table comment: Temp Table - Used to construct the Person compliance view.
-- Statement count: 2
 
CREATE GLOBAL TEMPORARY TABLE "pears"."ComplianceViewData" (
    "ComplianceViewDataID"           CHAR(20) NOT NULL
   ,"InstanceID"                     CHAR(20) NULL
   ,"StateChangeText"                long VARCHAR NULL
   ,"PlacementAllowedText"           long VARCHAR NULL
   ,"TempshiftAllowedText"           long VARCHAR NULL
   ,"ComplianceText1"                long VARCHAR NULL
   ,"ComplianceText2"                long VARCHAR NULL
   ,"PassOrFailOrWarn"               CHAR(1) NULL
   ,"ComplianceColour1"              CHAR(20) NULL
   ,"ComplianceColour2"              CHAR(20) NULL
   ,"ComplianceGroup"                SMALLINT NULL
   ,"SortOrder"                      SMALLINT NULL
   ,"TagId"                          CHAR(3) NULL
   ,"TagLocation"                    CHAR(3) NULL
   ,PRIMARY KEY ("ComplianceViewDataID" ASC) 
) ON COMMIT PRESERVE ROWS
GO
 
 
COMMENT ON TABLE "pears"."ComplianceViewData" IS 
	'Temp Table - Used to construct the Person compliance view.'
GO