pears.ComplianceViewData

Temp Table - Used to construct the Person compliance view.

• ComplianceViewDataID

• 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"."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