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