--------------------------------------------------------
--  DDL for Table DT827_CONDENSED
--------------------------------------------------------
	CREATE TABLE DT827_CONDENSED (
	  DENSITYRATIO NUMERIC(2,0) NOT NULL, 
	  PROJECTLEVEL NUMERIC(2,0) NOT NULL, 
	  MAINPROJECT VARCHAR(18), 
	  PARENTPROJECT VARCHAR(18), 
	  PARENTTASK VARCHAR(18), 
	  PROJECTID VARCHAR(18) NOT NULL, 
	  REPORTID VARCHAR(10) NOT NULL, 
	  TASK VARCHAR(18) NOT NULL, 
	  TRESOURCE VARCHAR(20) NOT NULL, 
	  TIMESLICE DATETIME2 NOT NULL, 
	  PC FLOAT DEFAULT 0 NOT NULL, -- Planned Costs
	  PC_BL FLOAT DEFAULT 0 NOT NULL, -- Planned Costs from the BaseLine
	  AC FLOAT DEFAULT 0 NOT NULL, -- Actual Costs
	  RC FLOAT DEFAULT 0 NOT NULL, -- Remaining Costs
	  TC FLOAT DEFAULT 0 NOT NULL, -- Total Costs
	  PE FLOAT DEFAULT 0 NOT NULL, -- Planned Effort
	  PE_BL FLOAT DEFAULT 0 NOT NULL, -- Planned Effort from the BaseLine
	  AE FLOAT DEFAULT 0 NOT NULL, -- Actual Effort
	  RE FLOAT DEFAULT 0 NOT NULL, -- Remaining Effort
	  PR FLOAT DEFAULT 0 NOT NULL, -- Planned Revenues
	  PR_BL FLOAT DEFAULT 0 NOT NULL, -- Planned Revenues from the BaseLine
	  AR FLOAT DEFAULT 0 NOT NULL, -- Actual Revenues
	  RR FLOAT DEFAULT 0 NOT NULL, -- Remaining Revenues
	  CML_PC FLOAT DEFAULT 0 NOT NULL,  -- Cumulated Planned Costs
	  CML_PC_BL FLOAT DEFAULT 0 NOT NULL, -- Cumulated Planned Costs from the BaseLine
	  CML_AC FLOAT DEFAULT 0 NOT NULL, -- Cumulated Actual Costs
	  CML_RC FLOAT DEFAULT 0 NOT NULL, -- Cumulated Remaining Costs
	  CML_TC FLOAT DEFAULT 0 NOT NULL, -- Cumulated Total Costs 
	  CML_PE FLOAT DEFAULT 0 NOT NULL, -- Cumulated Planned Effort 
	  CML_PE_BL FLOAT DEFAULT 0 NOT NULL, -- Cumulated Planned Effort from the BaseLine
	  CML_AE FLOAT DEFAULT 0 NOT NULL, -- Cumulated Actual Effort
	  CML_RE FLOAT DEFAULT 0 NOT NULL, -- Cumulated Remaining Effort
	  CML_PR FLOAT DEFAULT 0 NOT NULL, -- Cumulated Planned Revenues
	  CML_PR_BL FLOAT DEFAULT 0 NOT NULL, -- Cumulated Planned Revenues from the BaseLine
	  CML_AR FLOAT DEFAULT 0 NOT NULL, -- Cumulated Actual Revenues
	  CML_RR FLOAT DEFAULT 0 NOT NULL, -- Cumulated Remaining Revenues
	  PROGRESS FLOAT DEFAULT 0 NOT NULL, -- Progression of work
	  EV FLOAT DEFAULT 0 NOT NULL, -- Earned Value
	  SV FLOAT DEFAULT 0 NOT NULL, -- Schedule Variance
	  CV FLOAT DEFAULT 0 NOT NULL, -- Cost Variance
	  SPI FLOAT DEFAULT 0 NOT NULL, -- Schedule Performance Index
	  CPI FLOAT DEFAULT 0 NOT NULL  -- Cost Performance Index
	 );
	--------------------------------------------------------
	--  DDL for PK
	--------------------------------------------------------
	ALTER TABLE DT827_CONDENSED ADD CONSTRAINT PIDDT827_CONDENSED PRIMARY KEY (PROJECTID,REPORTID,TASK,TRESOURCE,TIMESLICE);