CREATE TABLE "SESTAT_BS_TEL_RESSUM_L" 
   (	
   	"SE_EXECUTION_TIME" 	DATE,
   	"SE_EXECUTION_TIME_DST"	VARCHAR2(1),
   	"BUS_NUMBER" 		NUMBER(10,0),
   	"STATION_NAME" 		VARCHAR2(8), 
	"RESIDUAL_SUM" 		NUMBER, 
	"THRESHOLD_MW" 		NUMBER, 
	"KV_LEVEL"		VARCHAR2(4)
   );

COMMENT ON COLUMN "SESTAT_BS_TEL_RESSUM_L"."BUS_NUMBER" IS 'Bus Number';
COMMENT ON COLUMN "SESTAT_BS_TEL_RESSUM_L"."KV_LEVEL" IS 'kV level of the equipment';
COMMENT ON COLUMN "SESTAT_BS_TEL_RESSUM_L"."RESIDUAL_SUM" IS 'Bus residual sum (ABS(Algebraic sum of flows around the bus))';
COMMENT ON COLUMN "SESTAT_BS_TEL_RESSUM_L"."SE_EXECUTION_TIME" IS 'Begin Time of this SE execution';
COMMENT ON COLUMN "SESTAT_BS_TEL_RESSUM_L"."SE_EXECUTION_TIME_DST" IS 'Daylight saving time indicator';
COMMENT ON COLUMN "SESTAT_BS_TEL_RESSUM_L"."STATION_NAME" IS 'Station Name of the equipment';
COMMENT ON COLUMN "SESTAT_BS_TEL_RESSUM_L"."THRESHOLD_MW" IS 'Threshold MW (Larger of a config % of Maximum rating and a config MW)';
COMMENT ON TABLE "SESTAT_BS_TEL_RESSUM_L"  IS 'Bus MW Residual Summary';

--===============================================

CREATE TABLE "SESTAT_PF_MWRES_L" 
   (	
   	"RTCA_EXECUTION_TIME" 	DATE,
   	"RTCA_EXECUTION_TIME_DST"	VARCHAR2(1),
	"EQUIP_NAME" 		VARCHAR2(14), 
	"STATION_NAME" 		VARCHAR2(8), 
	"EQUIP_TYPE" 		VARCHAR2(2), 
	"EMERGENCY_RATING" 	NUMBER, 
	"MW_RESIDUAL" 		NUMBER, 
	"MW_THRESHOLD" 		NUMBER,
	"KV_LEVEL" 		VARCHAR2(4)
   );
   
COMMENT ON COLUMN "SESTAT_PF_MWRES_L"."EMERGENCY_RATING" IS 'Line/Trf Emergency Rating';
COMMENT ON COLUMN "SESTAT_PF_MWRES_L"."EQUIP_NAME" IS 'Equipment name IS ';
COMMENT ON COLUMN "SESTAT_PF_MWRES_L"."EQUIP_TYPE" IS 'Equipment Type (Line/Transformer)';
COMMENT ON COLUMN "SESTAT_PF_MWRES_L"."KV_LEVEL" IS 'kV level of the equipment';
COMMENT ON COLUMN "SESTAT_PF_MWRES_L"."STATION_NAME" IS 'Station Name of the equipment where the measurement is located';
COMMENT ON COLUMN "SESTAT_PF_MWRES_L"."MW_RESIDUAL" IS 'MW Absolute Residual (ABS(Estimate - Pre-Contingency Power Flow))';
COMMENT ON COLUMN "SESTAT_PF_MWRES_L"."MW_THRESHOLD" IS 'Threshold MW (Larger of a config % of Emergency rating and a config MW)';
COMMENT ON COLUMN "SESTAT_PF_MWRES_L"."RTCA_EXECUTION_TIME" IS 'RTCA Execution Time';
COMMENT ON COLUMN "SESTAT_PF_MWRES_L"."RTCA_EXECUTION_TIME_DST" IS 'Daylight saving time indicator';
COMMENT ON TABLE "SESTAT_PF_MWRES_L"  IS 'SE Vs Pre-Contingency PF MW Residual Summary';

--=============================================

CREATE TABLE "SESTAT_TEL_MWRES_L" 
   (	
   	"SE_EXECUTION_TIME"	DATE,
   	"SE_EXECUTION_TIME_DST" VARCHAR2(1),
   	"EQUIP_NAME" 		VARCHAR2(14),
   	"STATION_NAME" 		VARCHAR2(8),
   	"EQUIP_TYPE" 		VARCHAR2(2),
   	"EMERGENCY_RATING" 	NUMBER, 
	"MW_RESIDUAL" 		NUMBER, 
	"MW_THRESHOLD" 		NUMBER,
	"KV_LEVEL" 		VARCHAR2(4) 
   );
   
   
COMMENT ON COLUMN "SESTAT_TEL_MWRES_L"."EMERGENCY_RATING" IS 'Line/Trf Emergency Rating';
COMMENT ON COLUMN "SESTAT_TEL_MWRES_L"."EQUIP_NAME" IS 'Equipment name IS ';
COMMENT ON COLUMN "SESTAT_TEL_MWRES_L"."EQUIP_TYPE" IS 'Equipment Type (Line/Transformer)';
COMMENT ON COLUMN "SESTAT_TEL_MWRES_L"."KV_LEVEL" IS 'kV level of the equipment';
COMMENT ON COLUMN "SESTAT_TEL_MWRES_L"."MW_RESIDUAL" IS 'MW Absolute Residual (ABS(Measurement - Estimate))';
COMMENT ON COLUMN "SESTAT_TEL_MWRES_L"."MW_THRESHOLD" IS 'Threshold MW (Larger of a config % of Emergency rating and a config MW)';
COMMENT ON COLUMN "SESTAT_TEL_MWRES_L"."SE_EXECUTION_TIME" IS 'Begin Time of this SE execution';
COMMENT ON COLUMN "SESTAT_TEL_MWRES_L"."SE_EXECUTION_TIME_DST" IS 'Daylight saving time indicator';
COMMENT ON COLUMN "SESTAT_TEL_MWRES_L"."STATION_NAME" IS 'Station Name of the equipment where the measurement is located';
COMMENT ON TABLE "SESTAT_TEL_MWRES_L"  IS 'SE Vs Telemetry MW Residual Summary';


--===============================================

CREATE TABLE "SESTAT_TEL_KVRES_L" 
   (	 
	"SE_EXECUTION_TIME" 	DATE,
	"SE_EXECUTION_TIME_DST" VARCHAR2(1),
	"BUS_NUMBER" 		NUMBER(10,0),
	"STATION_NAME" 		VARCHAR2(8), 
	"KV_RESIDUAL" 		NUMBER, 
	"KV_THRESHOLD" 		NUMBER,
	"KV_LEVEL" 		VARCHAR2(4)	 
   );
   
COMMENT ON COLUMN "SESTAT_TEL_KVRES_L"."BUS_NUMBER" IS 'Bus Number';
COMMENT ON COLUMN "SESTAT_TEL_KVRES_L"."KV_LEVEL" IS 'kV level of the equipment';
COMMENT ON COLUMN "SESTAT_TEL_KVRES_L"."KV_RESIDUAL" IS 'kV Absolute Residual (ABS(Measurement - Estimate))';
COMMENT ON COLUMN "SESTAT_TEL_KVRES_L"."KV_THRESHOLD" IS 'Threshold kV (A config % of telemetered bus voltage)';
COMMENT ON COLUMN "SESTAT_TEL_KVRES_L"."SE_EXECUTION_TIME" IS 'Begin Time of this SE execution';
COMMENT ON COLUMN "SESTAT_TEL_KVRES_L"."SE_EXECUTION_TIME_DST" IS 'Daylight saving time indicator';
COMMENT ON COLUMN "SESTAT_TEL_KVRES_L"."STATION_NAME" IS 'Station Name of the equipment IS ';
COMMENT ON TABLE "SESTAT_TEL_KVRES_L"  IS 'SE Vs Telemetry kV Residual Summary';

--===============================================

CREATE TABLE "D_EQUIP_OWNER" 
   (	
   	"OWNER_NAME" 		VARCHAR2(8),
   	"STATION_NAME" 		VARCHAR2(8),
   	"EQUIP_TYPE" 		VARCHAR2(14), 
	"EQUIP_NAME" 		VARCHAR2(14), 
	"VOLTAGE_LEVEL" 	NUMBER, 
	"CRITICAL_BUS_FLAG" 	VARCHAR2(1), 
	"MAJOR_TRANS_ELE_FLAG" 	VARCHAR2(1), 
	"HIST_CONGESTED_ELE_FLAG" VARCHAR2(1), 
	"EFFECTIVE_FROM" 	DATE, 
	"EFFECTIVE_TO" 		DATE 
   );

COMMENT ON TABLE D_EQUIP_OWNER is 'This table is a type 2 Dimension table for the SE  Data Mart. The data in this table contains the attributes of an equipment including name, type, voltage level, station name and  owner for a given period of time.';
COMMENT ON COLUMN D_EQUIP_OWNER.EQUIP_TYPE is 'Equipment Type';
COMMENT ON COLUMN D_EQUIP_OWNER.EQUIP_NAME is 'Equipment Name';
COMMENT ON COLUMN D_EQUIP_OWNER.VOLTAGE_LEVEL is 'Voltage Level of the Equipment';
COMMENT ON COLUMN D_EQUIP_OWNER.OWNER_NAME is 'Owner Name of the equipment';
COMMENT ON COLUMN D_EQUIP_OWNER.STATION_NAME is 'Station Name';
COMMENT ON COLUMN D_EQUIP_OWNER.CRITICAL_BUS_FLAG is 'Critical Bus Flag';
COMMENT ON COLUMN D_EQUIP_OWNER.MAJOR_TRANS_ELE_FLAG is 'Major Transmission Element Flag';
COMMENT ON COLUMN D_EQUIP_OWNER.HIST_CONGESTED_ELE_FLAG is 'Historically congested Element Flag';
COMMENT ON COLUMN D_EQUIP_OWNER.EFFECTIVE_FROM is 'Identifies the date when this record should be considered effective';
COMMENT ON COLUMN D_EQUIP_OWNER.EFFECTIVE_TO is 'Identifies the date when this record should be considered expired (default 12/31/4712)';

--===============================================

CREATE TABLE SE_EXECUTION_SUMMARY_L
(
	SE_EXECUTION_TIME        DATE,
	SE_EXECUTION_TIME_DST    VARCHAR2(1),
	TOTAL_GENERATION         NUMBER,
	TOTAL_LOAD               NUMBER,
	MAX_ANAGLE_CHANGE        VARCHAR2(16),
	MAX_VOLTAGE_CHANGE       VARCHAR2(16),
	SOLUTION_STATUS          VARCHAR2(16)
)
;
-- Add comments to the table 
COMMENT ON TABLE SE_EXECUTION_SUMMARY_L is 'State Estimator execution summary';
-- Add comments to the columns 
COMMENT ON COLUMN SE_EXECUTION_SUMMARY_L.SE_EXECUTION_TIME is 'Begin time of this SE execution';
COMMENT ON COLUMN SE_EXECUTION_SUMMARY_L.SE_EXECUTION_TIME_DST is 'Daylight saving time indicator';
COMMENT ON COLUMN SE_EXECUTION_SUMMARY_L.SOLUTION_STATUS is 'Status of the Solution';
COMMENT ON COLUMN SE_EXECUTION_SUMMARY_L.TOTAL_GENERATION is 'Total generation in the system based on RTNET';
COMMENT ON COLUMN SE_EXECUTION_SUMMARY_L.TOTAL_LOAD is 'Total load in the system based on RTNET';
COMMENT ON COLUMN SE_EXECUTION_SUMMARY_L.MAX_ANAGLE_CHANGE is 'Bus with maximum voltage angle change';
COMMENT ON COLUMN SE_EXECUTION_SUMMARY_L.MAX_VOLTAGE_CHANGE is 'Bus with maximum delta voltage magnitude change';

--==================================================

CREATE TABLE "RTCA_SYSTEM_SUMMARY_L"
(	
	"RTCA_EXECUTION_TIME" 		DATE, 
	"EXECUTION_CPU_TIME" 		NUMBER, 
	"NUM_VIOL_BRANCH_BASE" 		NUMBER, 
	"NUM_VIOL_VOLTAGE_BASE" 	NUMBER, 
	"NUM_VIOL_BRANCH_CTGS" 		NUMBER, 
	"NUM_VIOL_VOLTAGE_CTGS" 	NUMBER, 
	"NUM_CTG_ACTIVE" 		NUMBER, 
	"NUM_CTG_POT_HARMFUL" 		NUMBER, 
	"NUM_CTG_HARMFUL" 		NUMBER, 
	"NUM_CTG_INCOR_HARMFUL" 	NUMBER, 
	"NUM_CTG_LOCAL_SCREENED" 	NUMBER, 
	"NUM_CTG_WIDE_SCREENED" 	NUMBER, 
	"NUM_CTG_FULL_PROCESSED" 	NUMBER, 
	"NUM_CTG_UNSOLVED" 		NUMBER,
	"RTCA_EXECUTION_TIME_DST" 	VARCHAR2(1)
);

-- Add comments to the table 
COMMENT ON TABLE RTCA_SYSTEM_SUMMARY_L is 'Contingency Analysis Summary on system level';
-- Add comments to the columns 
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."RTCA_EXECUTION_TIME" IS 'Time of the successful completion of CA.';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."EXECUTION_CPU_TIME" IS 'TOTAL CPU SECONDS SPENT IN CA';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."NUM_VIOL_BRANCH_BASE" IS 'Total branch violations in basecase is ';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."NUM_VIOL_VOLTAGE_BASE" IS 'Total voltage violations in basecase is ';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."NUM_VIOL_BRANCH_CTGS" IS 'Total branch violations in contingencies is ';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."NUM_VIOL_VOLTAGE_CTGS" IS 'Total voltage violations in contingencies is ';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."NUM_CTG_ACTIVE" IS 'Number of active contingencies';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."NUM_CTG_POT_HARMFUL" IS 'Number of potentially harmful contingencies';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."NUM_CTG_HARMFUL" IS 'Number of harmful contingencies';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."NUM_CTG_INCOR_HARMFUL" IS 'Number of contingencies incorrectly flagged harmful is ';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."NUM_CTG_LOCAL_SCREENED" IS 'Number of contingencies screened by local is ';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."NUM_CTG_WIDE_SCREENED" IS 'Number of contingencies screened by widespread';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."NUM_CTG_FULL_PROCESSED" IS 'Number of contingencies solved in full processing';
COMMENT ON COLUMN "RTCA_SYSTEM_SUMMARY_L"."NUM_CTG_UNSOLVED" IS 'Number of contingencies unsolved in full processing';