-- Create table create table AGGOUTPUTHEADER ( UIDAGGOUTPUTHEADER NUMBER(19) not null, SAVERECORDER VARCHAR2(128) not null, SAVECHANNEL NUMBER(6) not null, QSECODE VARCHAR2(64), UIDBILLDETERMINANT NUMBER(19) not null, UIDSETLPOINT NUMBER(19), RESOURCEID VARCHAR2(64), GENSITECODE VARCHAR2(64), NOIECODE VARCHAR2(64), PGCCODE VARCHAR2(64), TDSPCODE VARCHAR2(64), UIDRESOURCE NUMBER(19), UFEZONECODE VARCHAR2(64), LSTIME DATE ); -- Create table comment COMMENT ON TABLE AGGOUTPUTHEADER is 'Defined PARENT table containing business level attributes for the data aggregation output records that are necessary inputs for settlement calculations. This is an approved settlements data set.'; comment on column AGGOUTPUTHEADER.UIDAGGOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the AGGOUTPUTHEADER data record.'; comment on column AGGOUTPUTHEADER.SAVERECORDER is 'The concatenated attributes of the AGGOUTPUTHEADER.'; comment on column AGGOUTPUTHEADER.SAVECHANNEL is 'ERCOT settlement systems number relational to the number of times an operating day is settled.'; comment on column AGGOUTPUTHEADER.QSECODE is 'The ERCOT settlement systems code associated to a QSE.'; comment on column AGGOUTPUTHEADER.UIDBILLDETERMINANT is 'The ERCOT settlement systems unique identifier for the BILLDETERMINANT data record.'; comment on column AGGOUTPUTHEADER.UIDSETLPOINT is 'The ERCOT settlement systems unique identifier for the SETTLEMENTPOINT data record.'; comment on column AGGOUTPUTHEADER.RESOURCEID is 'The ERCOT unique identifier for an ERCOT Polled Settlement meter location.'; comment on column AGGOUTPUTHEADER.GENSITECODE is 'The ERCOT settlement systems code associated to a GENERATORSITE.'; comment on column AGGOUTPUTHEADER.NOIECODE is 'The ERCOT settlement systems code associated to a NOIE.'; comment on column AGGOUTPUTHEADER.PGCCODE is 'The ERCOT settlement systems code associated to a PGC.'; comment on column AGGOUTPUTHEADER.TDSPCODE is 'The ERCOT settlement systems code associated to a TDSP.'; comment on column AGGOUTPUTHEADER.UIDRESOURCE is 'The ERCOT settlement systems unique identifier for the RESOURCE data record. The RESOURCE is either a generator, combined cycle plant or combined cycle configuration.'; comment on column AGGOUTPUTHEADER.UFEZONECODE is 'The ERCOT settlement systems code associated to a UFEZONE.'; comment on column AGGOUTPUTHEADER.LSTIME is 'The data record timestamp.'; -- Create table create table AGGOUTPUTINTERVAL ( UIDAGGOUTPUTINTERVAL NUMBER(19) not null, UIDAGGOUTPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UIDSTATEMENTSCHED NUMBER(19) not null, CALCGROUP NUMBER(10) not null, SPI NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, DSTPARTICIPANT CHAR(1) not null, ORIGIN CHAR(1), CHNLCUTTIMESTAMP DATE, TZSTDNAME VARCHAR2(32), TOTAL FLOAT not null, MAXIMUM FLOAT not null, MINIMUM FLOAT not null, INTERVALCOUNT NUMBER(10) not null, INT001 NUMBER, INT002 NUMBER, INT003 NUMBER, INT004 NUMBER, INT005 NUMBER, INT006 NUMBER, INT007 NUMBER, INT008 NUMBER, INT009 NUMBER, INT010 NUMBER, INT011 NUMBER, INT012 NUMBER, INT013 NUMBER, INT014 NUMBER, INT015 NUMBER, INT016 NUMBER, INT017 NUMBER, INT018 NUMBER, INT019 NUMBER, INT020 NUMBER, INT021 NUMBER, INT022 NUMBER, INT023 NUMBER, INT024 NUMBER, INT025 NUMBER, INT026 NUMBER, INT027 NUMBER, INT028 NUMBER, INT029 NUMBER, INT030 NUMBER, INT031 NUMBER, INT032 NUMBER, INT033 NUMBER, INT034 NUMBER, INT035 NUMBER, INT036 NUMBER, INT037 NUMBER, INT038 NUMBER, INT039 NUMBER, INT040 NUMBER, INT041 NUMBER, INT042 NUMBER, INT043 NUMBER, INT044 NUMBER, INT045 NUMBER, INT046 NUMBER, INT047 NUMBER, INT048 NUMBER, INT049 NUMBER, INT050 NUMBER, INT051 NUMBER, INT052 NUMBER, INT053 NUMBER, INT054 NUMBER, INT055 NUMBER, INT056 NUMBER, INT057 NUMBER, INT058 NUMBER, INT059 NUMBER, INT060 NUMBER, INT061 NUMBER, INT062 NUMBER, INT063 NUMBER, INT064 NUMBER, INT065 NUMBER, INT066 NUMBER, INT067 NUMBER, INT068 NUMBER, INT069 NUMBER, INT070 NUMBER, INT071 NUMBER, INT072 NUMBER, INT073 NUMBER, INT074 NUMBER, INT075 NUMBER, INT076 NUMBER, INT077 NUMBER, INT078 NUMBER, INT079 NUMBER, INT080 NUMBER, INT081 NUMBER, INT082 NUMBER, INT083 NUMBER, INT084 NUMBER, INT085 NUMBER, INT086 NUMBER, INT087 NUMBER, INT088 NUMBER, INT089 NUMBER, INT090 NUMBER, INT091 NUMBER, INT092 NUMBER, INT093 NUMBER, INT094 NUMBER, INT095 NUMBER, INT096 NUMBER, INT097 NUMBER, INT098 NUMBER, INT099 NUMBER, INT100 NUMBER, LSTIME DATE ); -- Create table comment COMMENT ON TABLE AGGOUTPUTINTERVAL is 'Defined INTERVAL table containing both the interval data and data level attributes for the data aggregation output records that are necessary inputs for settlement calculations. This is an approved settlements data set'; comment on column AGGOUTPUTINTERVAL.UIDAGGOUTPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the AGGOUTPUTINTERVAL data record.'; comment on column AGGOUTPUTINTERVAL.UIDAGGOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the AGGOUTPUTHEADER data record.'; comment on column AGGOUTPUTINTERVAL.STARTTIME is 'The starttime the data represents.'; comment on column AGGOUTPUTINTERVAL.STOPTIME is 'The stoptime the data represents through.'; comment on column AGGOUTPUTINTERVAL.UIDSTATEMENTSCHED is 'The ERCOT settlement systems unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; comment on column AGGOUTPUTINTERVAL.CALCGROUP is 'The ERCOT settlement systems internal value used to tie related values to a specific business process calculation.'; comment on column AGGOUTPUTINTERVAL.SPI is 'Seconds per interval.'; comment on column AGGOUTPUTINTERVAL.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column AGGOUTPUTINTERVAL.DSTPARTICIPANT is 'Attribute indicating if the intervals recorded participate in DST adjustments and if the intervals will reflect the time change during DST.'; comment on column AGGOUTPUTINTERVAL.ORIGIN is 'C=Calculated.'; comment on column AGGOUTPUTINTERVAL.TOTAL is 'Total sum of all interval values found within the data record.'; comment on column AGGOUTPUTINTERVAL.MAXIMUM is 'Maximum interval value found within the data record.'; comment on column AGGOUTPUTINTERVAL.MINIMUM is 'Minimum interval value found within the data record.'; comment on column AGGOUTPUTINTERVAL.INTERVALCOUNT is 'Number of intervals found within the data record.'; comment on column AGGOUTPUTINTERVAL.INT001 is 'The parsed value for the first interval.'; comment on column AGGOUTPUTINTERVAL.INT002 is 'The parsed value for the second interval.'; comment on column AGGOUTPUTINTERVAL.INT003 is 'The parsed value for the third interval.'; comment on column AGGOUTPUTINTERVAL.INT004 is 'The parsed value for the fourth interval.'; comment on column AGGOUTPUTINTERVAL.INT005 is 'The parsed value for the fifth interval.'; comment on column AGGOUTPUTINTERVAL.INT006 is 'The parsed value for the 6th interval.'; comment on column AGGOUTPUTINTERVAL.INT007 is 'The parsed value for the 7th interval.'; comment on column AGGOUTPUTINTERVAL.INT008 is 'The parsed value for the 8th interval.'; comment on column AGGOUTPUTINTERVAL.INT009 is 'The parsed value for the 9th interval.'; comment on column AGGOUTPUTINTERVAL.INT010 is 'The parsed value for the 10th interval.'; comment on column AGGOUTPUTINTERVAL.INT011 is 'The parsed value for the 11th interval.'; comment on column AGGOUTPUTINTERVAL.INT012 is 'The parsed value for the 12th interval.'; comment on column AGGOUTPUTINTERVAL.INT013 is 'The parsed value for the 13th interval.'; comment on column AGGOUTPUTINTERVAL.INT014 is 'The parsed value for the 14th interval.'; comment on column AGGOUTPUTINTERVAL.INT015 is 'The parsed value for the 15th interval.'; comment on column AGGOUTPUTINTERVAL.INT016 is 'The parsed value for the 16th interval.'; comment on column AGGOUTPUTINTERVAL.INT017 is 'The parsed value for the 17th interval.'; comment on column AGGOUTPUTINTERVAL.INT018 is 'The parsed value for the 18th interval.'; comment on column AGGOUTPUTINTERVAL.INT019 is 'The parsed value for the 19th interval.'; comment on column AGGOUTPUTINTERVAL.INT020 is 'The parsed value for the 20th interval.'; comment on column AGGOUTPUTINTERVAL.INT021 is 'The parsed value for the 21th interval.'; comment on column AGGOUTPUTINTERVAL.INT022 is 'The parsed value for the 22th interval.'; comment on column AGGOUTPUTINTERVAL.INT023 is 'The parsed value for the 23th interval.'; comment on column AGGOUTPUTINTERVAL.INT024 is 'The parsed value for the 24th interval.'; comment on column AGGOUTPUTINTERVAL.INT025 is 'The parsed value for the 25th interval.'; comment on column AGGOUTPUTINTERVAL.INT026 is 'The parsed value for the 26th interval.'; comment on column AGGOUTPUTINTERVAL.INT027 is 'The parsed value for the 27th interval.'; comment on column AGGOUTPUTINTERVAL.INT028 is 'The parsed value for the 28th interval.'; comment on column AGGOUTPUTINTERVAL.INT029 is 'The parsed value for the 29th interval.'; comment on column AGGOUTPUTINTERVAL.INT030 is 'The parsed value for the 30th interval.'; comment on column AGGOUTPUTINTERVAL.INT031 is 'The parsed value for the 31th interval.'; comment on column AGGOUTPUTINTERVAL.INT032 is 'The parsed value for the 32th interval.'; comment on column AGGOUTPUTINTERVAL.INT033 is 'The parsed value for the 33th interval.'; comment on column AGGOUTPUTINTERVAL.INT034 is 'The parsed value for the 34th interval.'; comment on column AGGOUTPUTINTERVAL.INT035 is 'The parsed value for the 35th interval.'; comment on column AGGOUTPUTINTERVAL.INT036 is 'The parsed value for the 36th interval.'; comment on column AGGOUTPUTINTERVAL.INT037 is 'The parsed value for the 37th interval.'; comment on column AGGOUTPUTINTERVAL.INT038 is 'The parsed value for the 38th interval.'; comment on column AGGOUTPUTINTERVAL.INT039 is 'The parsed value for the 39th interval.'; comment on column AGGOUTPUTINTERVAL.INT040 is 'The parsed value for the 40th interval.'; comment on column AGGOUTPUTINTERVAL.INT041 is 'The parsed value for the 41th interval.'; comment on column AGGOUTPUTINTERVAL.INT042 is 'The parsed value for the 42th interval.'; comment on column AGGOUTPUTINTERVAL.INT043 is 'The parsed value for the 43th interval.'; comment on column AGGOUTPUTINTERVAL.INT044 is 'The parsed value for the 44th interval.'; comment on column AGGOUTPUTINTERVAL.INT045 is 'The parsed value for the 45th interval.'; comment on column AGGOUTPUTINTERVAL.INT046 is 'The parsed value for the 46th interval.'; comment on column AGGOUTPUTINTERVAL.INT047 is 'The parsed value for the 47th interval.'; comment on column AGGOUTPUTINTERVAL.INT048 is 'The parsed value for the 48th interval.'; comment on column AGGOUTPUTINTERVAL.INT049 is 'The parsed value for the 49th interval.'; comment on column AGGOUTPUTINTERVAL.INT050 is 'The parsed value for the 50th interval.'; comment on column AGGOUTPUTINTERVAL.INT051 is 'The parsed value for the 51th interval.'; comment on column AGGOUTPUTINTERVAL.INT052 is 'The parsed value for the 52th interval.'; comment on column AGGOUTPUTINTERVAL.INT053 is 'The parsed value for the 53th interval.'; comment on column AGGOUTPUTINTERVAL.INT054 is 'The parsed value for the 54th interval.'; comment on column AGGOUTPUTINTERVAL.INT055 is 'The parsed value for the 55th interval.'; comment on column AGGOUTPUTINTERVAL.INT056 is 'The parsed value for the 56th interval.'; comment on column AGGOUTPUTINTERVAL.INT057 is 'The parsed value for the 57th interval.'; comment on column AGGOUTPUTINTERVAL.INT058 is 'The parsed value for the 58th interval.'; comment on column AGGOUTPUTINTERVAL.INT059 is 'The parsed value for the 59th interval.'; comment on column AGGOUTPUTINTERVAL.INT060 is 'The parsed value for the 60th interval.'; comment on column AGGOUTPUTINTERVAL.INT061 is 'The parsed value for the 61th interval.'; comment on column AGGOUTPUTINTERVAL.INT062 is 'The parsed value for the 62th interval.'; comment on column AGGOUTPUTINTERVAL.INT063 is 'The parsed value for the 63th interval.'; comment on column AGGOUTPUTINTERVAL.INT064 is 'The parsed value for the 64th interval.'; comment on column AGGOUTPUTINTERVAL.INT065 is 'The parsed value for the 65th interval.'; comment on column AGGOUTPUTINTERVAL.INT066 is 'The parsed value for the 66th interval.'; comment on column AGGOUTPUTINTERVAL.INT067 is 'The parsed value for the 67th interval.'; comment on column AGGOUTPUTINTERVAL.INT068 is 'The parsed value for the 68th interval.'; comment on column AGGOUTPUTINTERVAL.INT069 is 'The parsed value for the 69th interval.'; comment on column AGGOUTPUTINTERVAL.INT070 is 'The parsed value for the 70th interval.'; comment on column AGGOUTPUTINTERVAL.INT071 is 'The parsed value for the 71th interval.'; comment on column AGGOUTPUTINTERVAL.INT072 is 'The parsed value for the 72th interval.'; comment on column AGGOUTPUTINTERVAL.INT073 is 'The parsed value for the 73th interval.'; comment on column AGGOUTPUTINTERVAL.INT074 is 'The parsed value for the 74th interval.'; comment on column AGGOUTPUTINTERVAL.INT075 is 'The parsed value for the 75th interval.'; comment on column AGGOUTPUTINTERVAL.INT076 is 'The parsed value for the 76th interval.'; comment on column AGGOUTPUTINTERVAL.INT077 is 'The parsed value for the 77th interval.'; comment on column AGGOUTPUTINTERVAL.INT078 is 'The parsed value for the 78th interval.'; comment on column AGGOUTPUTINTERVAL.INT079 is 'The parsed value for the 79th interval.'; comment on column AGGOUTPUTINTERVAL.INT080 is 'The parsed value for the 80th interval.'; comment on column AGGOUTPUTINTERVAL.INT081 is 'The parsed value for the 81th interval.'; comment on column AGGOUTPUTINTERVAL.INT082 is 'The parsed value for the 82th interval.'; comment on column AGGOUTPUTINTERVAL.INT083 is 'The parsed value for the 83th interval.'; comment on column AGGOUTPUTINTERVAL.INT084 is 'The parsed value for the 84th interval.'; comment on column AGGOUTPUTINTERVAL.INT085 is 'The parsed value for the 85th interval.'; comment on column AGGOUTPUTINTERVAL.INT086 is 'The parsed value for the 86th interval.'; comment on column AGGOUTPUTINTERVAL.INT087 is 'The parsed value for the 87th interval.'; comment on column AGGOUTPUTINTERVAL.INT088 is 'The parsed value for the 88th interval.'; comment on column AGGOUTPUTINTERVAL.INT089 is 'The parsed value for the 89th interval.'; comment on column AGGOUTPUTINTERVAL.INT090 is 'The parsed value for the 90th interval.'; comment on column AGGOUTPUTINTERVAL.INT091 is 'The parsed value for the 91th interval.'; comment on column AGGOUTPUTINTERVAL.INT092 is 'The parsed value for the 92th interval.'; comment on column AGGOUTPUTINTERVAL.INT093 is 'The parsed value for the 93th interval.'; comment on column AGGOUTPUTINTERVAL.INT094 is 'The parsed value for the 94th interval.'; comment on column AGGOUTPUTINTERVAL.INT095 is 'The parsed value for the 95th interval.'; comment on column AGGOUTPUTINTERVAL.INT096 is 'The parsed value for the 96th interval.'; comment on column AGGOUTPUTINTERVAL.INT097 is 'The parsed value for the 97th interval.'; comment on column AGGOUTPUTINTERVAL.INT098 is 'The parsed value for the 98th interval.'; comment on column AGGOUTPUTINTERVAL.INT099 is 'The parsed value for the 99th interval.'; comment on column AGGOUTPUTINTERVAL.INT100 is 'The parsed value for the 100th interval.'; comment on column AGGOUTPUTINTERVAL.LSTIME is 'The data record timestamp.'; -- Create table create table AGGOUTPUTSCALAR ( UIDAGGOUTPUTSCALAR NUMBER(19) not null, UIDAGGOUTPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UIDSTATEMENTSCHED NUMBER(19), CALCGROUP NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, STRINGVALUE VARCHAR2(64) not null, VALUE FLOAT not null, LSTIME DATE, UIDINVOICESCHEDULE NUMBER(19) ); -- Create table comment COMMENT ON TABLE AGGOUTPUTSCALAR is 'Defined SCALAR table containing non- interval (i.e. daily or monthly) data for the data aggregation output records that are necessary inputs for settlement calculations. This is an approved settlements data set.'; comment on column AGGOUTPUTSCALAR.UIDAGGOUTPUTSCALAR is 'The ERCOT settlement systems unique identifier for the AGGOUTPUTSCALAR data record.'; comment on column AGGOUTPUTSCALAR.UIDAGGOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the AGGOUTPUTHEADER data record.'; comment on column AGGOUTPUTSCALAR.STARTTIME is 'The starttime the data represents.'; comment on column AGGOUTPUTSCALAR.STOPTIME is 'The stoptime the data represents through.'; comment on column AGGOUTPUTSCALAR.UIDSTATEMENTSCHED is 'The unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; comment on column AGGOUTPUTSCALAR.CALCGROUP is 'The ERCOT settlement systems internal value used to tie related values to a specific business process calculation.'; comment on column AGGOUTPUTSCALAR.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column AGGOUTPUTSCALAR.STRINGVALUE is 'Character string value.'; comment on column AGGOUTPUTSCALAR.VALUE is 'Numeric data value.'; comment on column AGGOUTPUTSCALAR.LSTIME is 'The data record timestamp.'; comment on column AGGOUTPUTSCALAR.UIDINVOICESCHEDULE is 'Unique identifier for the INVOICESCHED data record for ERCOT internal use to manage the invoice run and approval process.'; create table CCTELEMETERSTATUS ( CSTTRANSITIONTIME DATE not null, DSTADJHOUR VARCHAR2(2), GENCODE VARCHAR2(64) not null, LSTIME DATE default SYSDATE, QSECODE VARCHAR2(64) not null, STATUS NUMBER(10) not null, TRANSITIONTIME DATE not null, UIDCONFIGURATION NUMBER(19) ); -- Create table create table CRROUTPUTHEADER ( UIDCRROUTPUTHEADER NUMBER(19) not null, SAVERECORDER VARCHAR2(128) not null, SAVECHANNEL NUMBER(6) not null, UIDBILLDETERMINANT NUMBER(5) not null, QSECODE VARCHAR2(64), CRRACCTHLDRCODE NUMBER(19), CMZONECODE VARCHAR2(64), UIDSOURCESETLPOINT NUMBER(19), UIDSINKSETLPOINT NUMBER(19), UIDFLOWGATE NUMBER(19), UIDELEMENT NUMBER(19), UIDCRRAUCTION NUMBER(19), UIDRESOURCE NUMBER(19), LSTIME DATE, MKTCONSTRAINTCODE NUMBER(19) ); -- Create table comment COMMENT ON TABLE CRROUTPUTHEADER is 'Defined PARENT table containing business level attributes for the calculated resulting CRR values produced during settlements. This is an approved settlements data set.'; comment on column CRROUTPUTHEADER.UIDCRROUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the CRROUTPUTHEADER data record.'; comment on column CRROUTPUTHEADER.SAVERECORDER is 'The concatenated attributes of the CRROUTPUTHEADER.'; comment on column CRROUTPUTHEADER.SAVECHANNEL is 'ERCOT settlement systems number relational to the number of times an operating day is settled.'; comment on column CRROUTPUTHEADER.UIDBILLDETERMINANT is 'The ERCOT settlement systems unique identifier for the BILLDETERMINANT data record.'; comment on column CRROUTPUTHEADER.QSECODE is 'The ERCOT settlement systems code associated to a QSE.'; comment on column CRROUTPUTHEADER.CRRACCTHLDRCODE is 'The ERCOT settlement systems code associated to a CRRAH.'; comment on column CRROUTPUTHEADER.CMZONECODE is 'The ERCOT settlement systems unique identifier for the CMZONE data record.'; comment on column CRROUTPUTHEADER.UIDSOURCESETLPOINT is 'The ERCOT settlement systems unique identifier for the SOURCESETLPOINT data record.'; comment on column CRROUTPUTHEADER.UIDSINKSETLPOINT is 'The ERCOT settlement systems unique identifier for the SINKSETLPOINT data record.'; comment on column CRROUTPUTHEADER.UIDFLOWGATE is 'The ERCOT settlement systems unique identifier for the FLOWGATE data record.'; comment on column CRROUTPUTHEADER.UIDELEMENT is 'The ERCOT settlement systems unique identifier for the ELEMENT data record.'; comment on column CRROUTPUTHEADER.UIDCRRAUCTION is 'The ERCOT settlement systems unique identifier for the CRRAUCTION data record.'; comment on column CRROUTPUTHEADER.UIDRESOURCE is 'The ERCOT settlement systems unique identifier for the RESOURCE data record. The RESOURCE is either a generator, combined cycle plant or combined cycle configuration.'; comment on column CRROUTPUTHEADER.LSTIME is 'The data record timestamp.'; comment on column CRROUTPUTHEADER.MKTCONSTRAINTCODE is 'The ERCOT settlement systems code associated to a MKTCONSTRAINT.'; -- Create table create table CRROUTPUTINTERVAL ( UIDCRROUTPUTINTERVAL NUMBER(19) not null, UIDCRROUTPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UIDSTATEMENTSCHED NUMBER(19) not null, CALCGROUP NUMBER(10) not null, SPI NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, DSTPARTICIPANT CHAR(1) not null, ORIGIN CHAR(1), CHNLCUTTIMESTAMP DATE, TZSTDNAME VARCHAR2(32), TOTAL FLOAT not null, MAXIMUM FLOAT not null, MINIMUM FLOAT not null, INTERVALCOUNT NUMBER(10) not null, INT001 NUMBER, INT002 NUMBER, INT003 NUMBER, INT004 NUMBER, INT005 NUMBER, INT006 NUMBER, INT007 NUMBER, INT008 NUMBER, INT009 NUMBER, INT010 NUMBER, INT011 NUMBER, INT012 NUMBER, INT013 NUMBER, INT014 NUMBER, INT015 NUMBER, INT016 NUMBER, INT017 NUMBER, INT018 NUMBER, INT019 NUMBER, INT020 NUMBER, INT021 NUMBER, INT022 NUMBER, INT023 NUMBER, INT024 NUMBER, INT025 NUMBER, INT026 NUMBER, INT027 NUMBER, INT028 NUMBER, INT029 NUMBER, INT030 NUMBER, INT031 NUMBER, INT032 NUMBER, INT033 NUMBER, INT034 NUMBER, INT035 NUMBER, INT036 NUMBER, INT037 NUMBER, INT038 NUMBER, INT039 NUMBER, INT040 NUMBER, INT041 NUMBER, INT042 NUMBER, INT043 NUMBER, INT044 NUMBER, INT045 NUMBER, INT046 NUMBER, INT047 NUMBER, INT048 NUMBER, INT049 NUMBER, INT050 NUMBER, INT051 NUMBER, INT052 NUMBER, INT053 NUMBER, INT054 NUMBER, INT055 NUMBER, INT056 NUMBER, INT057 NUMBER, INT058 NUMBER, INT059 NUMBER, INT060 NUMBER, INT061 NUMBER, INT062 NUMBER, INT063 NUMBER, INT064 NUMBER, INT065 NUMBER, INT066 NUMBER, INT067 NUMBER, INT068 NUMBER, INT069 NUMBER, INT070 NUMBER, INT071 NUMBER, INT072 NUMBER, INT073 NUMBER, INT074 NUMBER, INT075 NUMBER, INT076 NUMBER, INT077 NUMBER, INT078 NUMBER, INT079 NUMBER, INT080 NUMBER, INT081 NUMBER, INT082 NUMBER, INT083 NUMBER, INT084 NUMBER, INT085 NUMBER, INT086 NUMBER, INT087 NUMBER, INT088 NUMBER, INT089 NUMBER, INT090 NUMBER, INT091 NUMBER, INT092 NUMBER, INT093 NUMBER, INT094 NUMBER, INT095 NUMBER, INT096 NUMBER, INT097 NUMBER, INT098 NUMBER, INT099 NUMBER, INT100 NUMBER, LSTIME DATE ); -- Create table comment COMMENT ON TABLE CRROUTPUTINTERVAL is 'Defined INTERVAL table containing both the interval data and data level attributes for the calculated results for DAM and RTM CRR settlements. This is an approved settlements data set'; comment on column CRROUTPUTINTERVAL.UIDCRROUTPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the CRROUTPUTINTERVAL data record.'; comment on column CRROUTPUTINTERVAL.UIDCRROUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the CRROUTPUTHEADER data record.'; comment on column CRROUTPUTINTERVAL.STARTTIME is 'The starttime the data represents.'; comment on column CRROUTPUTINTERVAL.STOPTIME is 'The stoptime the data represents through.'; comment on column CRROUTPUTINTERVAL.UIDSTATEMENTSCHED is 'The unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; comment on column CRROUTPUTINTERVAL.CALCGROUP is 'The ERCOT settlement systems internal value used to tie related values to a specific business process calculation.'; comment on column CRROUTPUTINTERVAL.SPI is 'Seconds per interval.'; comment on column CRROUTPUTINTERVAL.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column CRROUTPUTINTERVAL.DSTPARTICIPANT is 'Attribute indicating if the intervals recorded participate in DST adjustments and if the intervals will reflect the time change during DST.'; comment on column CRROUTPUTINTERVAL.ORIGIN is 'C=Calculated.'; comment on column CRROUTPUTINTERVAL.TOTAL is 'Total sum of all interval values found within the data record.'; comment on column CRROUTPUTINTERVAL.MAXIMUM is 'Maximum interval value found within the data record.'; comment on column CRROUTPUTINTERVAL.MINIMUM is 'Minimum interval value found within the data record.'; comment on column CRROUTPUTINTERVAL.INTERVALCOUNT is 'Number of intervals found within the data record.'; comment on column CRROUTPUTINTERVAL.INT001 is 'The parsed value for the first interval.'; comment on column CRROUTPUTINTERVAL.INT002 is 'The parsed value for the second interval.'; comment on column CRROUTPUTINTERVAL.INT003 is 'The parsed value for the third interval.'; comment on column CRROUTPUTINTERVAL.INT004 is 'The parsed value for the fourth interval.'; comment on column CRROUTPUTINTERVAL.INT005 is 'The parsed value for the fifth interval.'; comment on column CRROUTPUTINTERVAL.INT006 is 'The parsed value for the 6th interval.'; comment on column CRROUTPUTINTERVAL.INT007 is 'The parsed value for the 7th interval.'; comment on column CRROUTPUTINTERVAL.INT008 is 'The parsed value for the 8th interval.'; comment on column CRROUTPUTINTERVAL.INT009 is 'The parsed value for the 9th interval.'; comment on column CRROUTPUTINTERVAL.INT010 is 'The parsed value for the 10th interval.'; comment on column CRROUTPUTINTERVAL.INT011 is 'The parsed value for the 11th interval.'; comment on column CRROUTPUTINTERVAL.INT012 is 'The parsed value for the 12th interval.'; comment on column CRROUTPUTINTERVAL.INT013 is 'The parsed value for the 13th interval.'; comment on column CRROUTPUTINTERVAL.INT014 is 'The parsed value for the 14th interval.'; comment on column CRROUTPUTINTERVAL.INT015 is 'The parsed value for the 15th interval.'; comment on column CRROUTPUTINTERVAL.INT016 is 'The parsed value for the 16th interval.'; comment on column CRROUTPUTINTERVAL.INT017 is 'The parsed value for the 17th interval.'; comment on column CRROUTPUTINTERVAL.INT018 is 'The parsed value for the 18th interval.'; comment on column CRROUTPUTINTERVAL.INT019 is 'The parsed value for the 19th interval.'; comment on column CRROUTPUTINTERVAL.INT020 is 'The parsed value for the 20th interval.'; comment on column CRROUTPUTINTERVAL.INT021 is 'The parsed value for the 21th interval.'; comment on column CRROUTPUTINTERVAL.INT022 is 'The parsed value for the 22th interval.'; comment on column CRROUTPUTINTERVAL.INT023 is 'The parsed value for the 23th interval.'; comment on column CRROUTPUTINTERVAL.INT024 is 'The parsed value for the 24th interval.'; comment on column CRROUTPUTINTERVAL.INT025 is 'The parsed value for the 25th interval.'; comment on column CRROUTPUTINTERVAL.INT026 is 'The parsed value for the 26th interval.'; comment on column CRROUTPUTINTERVAL.INT027 is 'The parsed value for the 27th interval.'; comment on column CRROUTPUTINTERVAL.INT028 is 'The parsed value for the 28th interval.'; comment on column CRROUTPUTINTERVAL.INT029 is 'The parsed value for the 29th interval.'; comment on column CRROUTPUTINTERVAL.INT030 is 'The parsed value for the 30th interval.'; comment on column CRROUTPUTINTERVAL.INT031 is 'The parsed value for the 31th interval.'; comment on column CRROUTPUTINTERVAL.INT032 is 'The parsed value for the 32th interval.'; comment on column CRROUTPUTINTERVAL.INT033 is 'The parsed value for the 33th interval.'; comment on column CRROUTPUTINTERVAL.INT034 is 'The parsed value for the 34th interval.'; comment on column CRROUTPUTINTERVAL.INT035 is 'The parsed value for the 35th interval.'; comment on column CRROUTPUTINTERVAL.INT036 is 'The parsed value for the 36th interval.'; comment on column CRROUTPUTINTERVAL.INT037 is 'The parsed value for the 37th interval.'; comment on column CRROUTPUTINTERVAL.INT038 is 'The parsed value for the 38th interval.'; comment on column CRROUTPUTINTERVAL.INT039 is 'The parsed value for the 39th interval.'; comment on column CRROUTPUTINTERVAL.INT040 is 'The parsed value for the 40th interval.'; comment on column CRROUTPUTINTERVAL.INT041 is 'The parsed value for the 41th interval.'; comment on column CRROUTPUTINTERVAL.INT042 is 'The parsed value for the 42th interval.'; comment on column CRROUTPUTINTERVAL.INT043 is 'The parsed value for the 43th interval.'; comment on column CRROUTPUTINTERVAL.INT044 is 'The parsed value for the 44th interval.'; comment on column CRROUTPUTINTERVAL.INT045 is 'The parsed value for the 45th interval.'; comment on column CRROUTPUTINTERVAL.INT046 is 'The parsed value for the 46th interval.'; comment on column CRROUTPUTINTERVAL.INT047 is 'The parsed value for the 47th interval.'; comment on column CRROUTPUTINTERVAL.INT048 is 'The parsed value for the 48th interval.'; comment on column CRROUTPUTINTERVAL.INT049 is 'The parsed value for the 49th interval.'; comment on column CRROUTPUTINTERVAL.INT050 is 'The parsed value for the 50th interval.'; comment on column CRROUTPUTINTERVAL.INT051 is 'The parsed value for the 51th interval.'; comment on column CRROUTPUTINTERVAL.INT052 is 'The parsed value for the 52th interval.'; comment on column CRROUTPUTINTERVAL.INT053 is 'The parsed value for the 53th interval.'; comment on column CRROUTPUTINTERVAL.INT054 is 'The parsed value for the 54th interval.'; comment on column CRROUTPUTINTERVAL.INT055 is 'The parsed value for the 55th interval.'; comment on column CRROUTPUTINTERVAL.INT056 is 'The parsed value for the 56th interval.'; comment on column CRROUTPUTINTERVAL.INT057 is 'The parsed value for the 57th interval.'; comment on column CRROUTPUTINTERVAL.INT058 is 'The parsed value for the 58th interval.'; comment on column CRROUTPUTINTERVAL.INT059 is 'The parsed value for the 59th interval.'; comment on column CRROUTPUTINTERVAL.INT060 is 'The parsed value for the 60th interval.'; comment on column CRROUTPUTINTERVAL.INT061 is 'The parsed value for the 61th interval.'; comment on column CRROUTPUTINTERVAL.INT062 is 'The parsed value for the 62th interval.'; comment on column CRROUTPUTINTERVAL.INT063 is 'The parsed value for the 63th interval.'; comment on column CRROUTPUTINTERVAL.INT064 is 'The parsed value for the 64th interval.'; comment on column CRROUTPUTINTERVAL.INT065 is 'The parsed value for the 65th interval.'; comment on column CRROUTPUTINTERVAL.INT066 is 'The parsed value for the 66th interval.'; comment on column CRROUTPUTINTERVAL.INT067 is 'The parsed value for the 67th interval.'; comment on column CRROUTPUTINTERVAL.INT068 is 'The parsed value for the 68th interval.'; comment on column CRROUTPUTINTERVAL.INT069 is 'The parsed value for the 69th interval.'; comment on column CRROUTPUTINTERVAL.INT070 is 'The parsed value for the 70th interval.'; comment on column CRROUTPUTINTERVAL.INT071 is 'The parsed value for the 71th interval.'; comment on column CRROUTPUTINTERVAL.INT072 is 'The parsed value for the 72th interval.'; comment on column CRROUTPUTINTERVAL.INT073 is 'The parsed value for the 73th interval.'; comment on column CRROUTPUTINTERVAL.INT074 is 'The parsed value for the 74th interval.'; comment on column CRROUTPUTINTERVAL.INT075 is 'The parsed value for the 75th interval.'; comment on column CRROUTPUTINTERVAL.INT076 is 'The parsed value for the 76th interval.'; comment on column CRROUTPUTINTERVAL.INT077 is 'The parsed value for the 77th interval.'; comment on column CRROUTPUTINTERVAL.INT078 is 'The parsed value for the 78th interval.'; comment on column CRROUTPUTINTERVAL.INT079 is 'The parsed value for the 79th interval.'; comment on column CRROUTPUTINTERVAL.INT080 is 'The parsed value for the 80th interval.'; comment on column CRROUTPUTINTERVAL.INT081 is 'The parsed value for the 81th interval.'; comment on column CRROUTPUTINTERVAL.INT082 is 'The parsed value for the 82th interval.'; comment on column CRROUTPUTINTERVAL.INT083 is 'The parsed value for the 83th interval.'; comment on column CRROUTPUTINTERVAL.INT084 is 'The parsed value for the 84th interval.'; comment on column CRROUTPUTINTERVAL.INT085 is 'The parsed value for the 85th interval.'; comment on column CRROUTPUTINTERVAL.INT086 is 'The parsed value for the 86th interval.'; comment on column CRROUTPUTINTERVAL.INT087 is 'The parsed value for the 87th interval.'; comment on column CRROUTPUTINTERVAL.INT088 is 'The parsed value for the 88th interval.'; comment on column CRROUTPUTINTERVAL.INT089 is 'The parsed value for the 89th interval.'; comment on column CRROUTPUTINTERVAL.INT090 is 'The parsed value for the 90th interval.'; comment on column CRROUTPUTINTERVAL.INT091 is 'The parsed value for the 91th interval.'; comment on column CRROUTPUTINTERVAL.INT092 is 'The parsed value for the 92th interval.'; comment on column CRROUTPUTINTERVAL.INT093 is 'The parsed value for the 93th interval.'; comment on column CRROUTPUTINTERVAL.INT094 is 'The parsed value for the 94th interval.'; comment on column CRROUTPUTINTERVAL.INT095 is 'The parsed value for the 95th interval.'; comment on column CRROUTPUTINTERVAL.INT096 is 'The parsed value for the 96th interval.'; comment on column CRROUTPUTINTERVAL.INT097 is 'The parsed value for the 97th interval.'; comment on column CRROUTPUTINTERVAL.INT098 is 'The parsed value for the 98th interval.'; comment on column CRROUTPUTINTERVAL.INT099 is 'The parsed value for the 99th interval.'; comment on column CRROUTPUTINTERVAL.INT100 is 'The parsed value for the 100th interval.'; comment on column CRROUTPUTINTERVAL.LSTIME is 'The data record timestamp.'; -- Create table create table CRROUTPUTSCALAR ( UIDCRROUTPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UIDSTATEMENTSCHED NUMBER(19), CALCGROUP NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, STRINGVALUE VARCHAR2(64), VALUE FLOAT, INVOICEID VARCHAR2(64), UIDINVOICESCHEDULE NUMBER(19), UIDCRROUTPUTSCALAR NUMBER(19) not null, LSTIME DATE ); -- Create table comment COMMENT ON TABLE CRROUTPUTSCALAR is 'Defined SCALAR table containing non-interval (i.e. daily or monthly) data for the calculated results for CARD and monthly Balancing Account Invoice settlements. This is an approved settlements data set'; comment on column CRROUTPUTSCALAR.UIDCRROUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the CRROUTPUTHEADER data record.'; comment on column CRROUTPUTSCALAR.STARTTIME is 'The starttime the data represents.'; comment on column CRROUTPUTSCALAR.STOPTIME is 'The stoptime the data represents through.'; comment on column CRROUTPUTSCALAR.UIDSTATEMENTSCHED is 'The unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; comment on column CRROUTPUTSCALAR.CALCGROUP is 'The ERCOT settlement systems internal value used to tie related values to a specific business process calculation.'; comment on column CRROUTPUTSCALAR.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column CRROUTPUTSCALAR.STRINGVALUE is 'Character string value.'; comment on column CRROUTPUTSCALAR.VALUE is 'Numeric data value.'; comment on column CRROUTPUTSCALAR.INVOICEID is 'Joins to the invoice schedule table to associate the data with a specific CRR invoice.'; comment on column CRROUTPUTSCALAR.UIDINVOICESCHEDULE is 'Unique identifier for the INVOICESCHED data record for ERCOT internal use to manage the invoice run and approval process.'; comment on column CRROUTPUTSCALAR.UIDCRROUTPUTSCALAR is 'The ERCOT settlement systems unique identifier for the CRROUTPUTSCALAR data record.'; comment on column CRROUTPUTSCALAR.LSTIME is 'The data record timestamp.'; -- Create table create table DAIOUTPUTHEADER (UIDDAIOUTPUTHEADER NUMBER(19) not null, SAVERECORDER VARCHAR2(128) not null, SAVECHANNEL NUMBER(6) not null, UIDBILLDETERMINANT NUMBER(5) not null, QSECODE VARCHAR2(64), REPCODE VARCHAR2(64), PROFILECODE VARCHAR2(64), LOSSCODE VARCHAR2(64), UFEZONECODE VARCHAR2(64), UIDSETLPOINT NUMBER(19), TDSPCODE VARCHAR2(64), UIDRESOURCE NUMBER(19), PGCCODE VARCHAR2(64), RESOURCEID VARCHAR2(64), METHOD VARCHAR2(8), GENSITECODE VARCHAR2(64), NOIECODE VARCHAR2(64), LSTIME DATE, PROFILETYPECODE VARCHAR2(64), WEATHERZONECODE VARCHAR2(64), METERTYPE VARCHAR2(4), WEATHERSENSITIVITY VARCHAR2(3), TOUTYPE VARCHAR2(64) ); -- Create table comment COMMENT ON TABLE DAIOUTPUTHEADER is 'Defined PARENT table containing business level attributes for the data aggregation summarized data that does not feed into the settlement process.'; comment on column DAIOUTPUTHEADER.UIDDAIOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the DAIOUTPUTHEADER data record.'; comment on column DAIOUTPUTHEADER.SAVERECORDER is 'The concatenated attributes of the DAIOUTPUTHEADER.'; comment on column DAIOUTPUTHEADER.SAVECHANNEL is 'ERCOT settlement systems number relational to the number of times an operating day is settled.'; comment on column DAIOUTPUTHEADER.UIDBILLDETERMINANT is 'The ERCOT settlement systems unique identifier for the BILLDETERMINANT data record.'; comment on column DAIOUTPUTHEADER.QSECODE is 'The ERCOT settlement systems code associated to a QSE.'; comment on column DAIOUTPUTHEADER.REPCODE is 'The ERCOT settlement systems code associated to a REP.'; comment on column DAIOUTPUTHEADER.PROFILECODE is 'The ERCOT settlement systems code associated to a PROFILECLASS.'; comment on column DAIOUTPUTHEADER.LOSSCODE is 'The ERCOT settlement systems code associated to a LOSSCLASS.'; comment on column DAIOUTPUTHEADER.UFEZONECODE is 'The ERCOT settlement systems code associated to a UFEZONE.'; comment on column DAIOUTPUTHEADER.UIDSETLPOINT is 'The ERCOT settlement systems unique identifier for the SETTLEMENTPOINT data record.'; comment on column DAIOUTPUTHEADER.TDSPCODE is 'The ERCOT settlement systems code associated to a TDSP.'; comment on column DAIOUTPUTHEADER.UIDRESOURCE is 'The ERCOT settlement systems unique identifier for the RESOURCE data record.'; comment on column DAIOUTPUTHEADER.PGCCODE is 'The ERCOT settlement systems code associated to a PGC.'; comment on column DAIOUTPUTHEADER.RESOURCEID is 'The Unique ID for an ERCOT Polled Settlement meter that describes the pricing location at a bus.'; comment on column DAIOUTPUTHEADER.METHOD is 'The ERCOT settlement systems code assigned to the data record based on the type of usage that was used during the data aggregation process. The type of usage is defined as Actual, Estimated, and Default, which is paired with other usage attributes (i.e. IDR, NIDR, DCTIE, NOIE, etc.).'; comment on column DAIOUTPUTHEADER.GENSITECODE is 'The ERCOT settlement systems code associated to a GENERATORSITE.'; comment on column DAIOUTPUTHEADER.NOIECODE is 'The ERCOT settlement systems code associated to a NOIE.'; comment on column DAIOUTPUTHEADER.LSTIME is 'The data record timestamp.'; comment on column DAIOUTPUTHEADER.PROFILETYPECODE is 'The ERCOT settlement systems code associated to a PROFILETYPE.'; comment on column DAIOUTPUTHEADER.WEATHERZONECODE is 'The ERCOT settlement systems code associated to a WEATHERZONE.'; comment on column DAIOUTPUTHEADER.METERTYPE is 'Specifies an interval data or non-interval data meter type.'; comment on column DAIOUTPUTHEADER.WEATHERSENSITIVITY is 'Specifies weather sensitivity.'; comment on column DAIOUTPUTHEADER.TOUTYPE is 'Specifies Time Of Use code assignment for the TOU schedules or NOTOU.'; -- Create table create table DAIOUTPUTINTERVAL ( UIDDAIOUTPUTINTERVAL NUMBER(19) not null, UIDDAIOUTPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UIDSTATEMENTSCHED NUMBER(19) not null, CALCGROUP NUMBER(10) not null, SPI NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, DSTPARTICIPANT CHAR(1) not null, ORIGIN CHAR(1), CHNLCUTTIMESTAMP DATE, TZSTDNAME VARCHAR2(32), TOTAL FLOAT not null, MAXIMUM FLOAT not null, MINIMUM FLOAT not null, INTERVALCOUNT NUMBER(10) not null, INT001 NUMBER, INT002 NUMBER, INT003 NUMBER, INT004 NUMBER, INT005 NUMBER, INT006 NUMBER, INT007 NUMBER, INT008 NUMBER, INT009 NUMBER, INT010 NUMBER, INT011 NUMBER, INT012 NUMBER, INT013 NUMBER, INT014 NUMBER, INT015 NUMBER, INT016 NUMBER, INT017 NUMBER, INT018 NUMBER, INT019 NUMBER, INT020 NUMBER, INT021 NUMBER, INT022 NUMBER, INT023 NUMBER, INT024 NUMBER, INT025 NUMBER, INT026 NUMBER, INT027 NUMBER, INT028 NUMBER, INT029 NUMBER, INT030 NUMBER, INT031 NUMBER, INT032 NUMBER, INT033 NUMBER, INT034 NUMBER, INT035 NUMBER, INT036 NUMBER, INT037 NUMBER, INT038 NUMBER, INT039 NUMBER, INT040 NUMBER, INT041 NUMBER, INT042 NUMBER, INT043 NUMBER, INT044 NUMBER, INT045 NUMBER, INT046 NUMBER, INT047 NUMBER, INT048 NUMBER, INT049 NUMBER, INT050 NUMBER, INT051 NUMBER, INT052 NUMBER, INT053 NUMBER, INT054 NUMBER, INT055 NUMBER, INT056 NUMBER, INT057 NUMBER, INT058 NUMBER, INT059 NUMBER, INT060 NUMBER, INT061 NUMBER, INT062 NUMBER, INT063 NUMBER, INT064 NUMBER, INT065 NUMBER, INT066 NUMBER, INT067 NUMBER, INT068 NUMBER, INT069 NUMBER, INT070 NUMBER, INT071 NUMBER, INT072 NUMBER, INT073 NUMBER, INT074 NUMBER, INT075 NUMBER, INT076 NUMBER, INT077 NUMBER, INT078 NUMBER, INT079 NUMBER, INT080 NUMBER, INT081 NUMBER, INT082 NUMBER, INT083 NUMBER, INT084 NUMBER, INT085 NUMBER, INT086 NUMBER, INT087 NUMBER, INT088 NUMBER, INT089 NUMBER, INT090 NUMBER, INT091 NUMBER, INT092 NUMBER, INT093 NUMBER, INT094 NUMBER, INT095 NUMBER, INT096 NUMBER, INT097 NUMBER, INT098 NUMBER, INT099 NUMBER, INT100 NUMBER, LSTIME DATE ); COMMENT ON TABLE DAIOUTPUTINTERVAL is 'Defined INTERVAL table containing both: the interval data and data level attributes; for data aggregation summarized data that does not feed into the settlement process.'; comment on column DAIOUTPUTINTERVAL.UIDDAIOUTPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the DAIOUTPUTINTERVAL data record.'; comment on column DAIOUTPUTINTERVAL.UIDDAIOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the DAIOUTPUTHEADER data record.'; comment on column DAIOUTPUTINTERVAL.STARTTIME is 'The starttime the data represents.'; comment on column DAIOUTPUTINTERVAL.STOPTIME is 'The stoptime the data represents through.'; comment on column DAIOUTPUTINTERVAL.UIDSTATEMENTSCHED is 'The unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; comment on column DAIOUTPUTINTERVAL.CALCGROUP is 'The ERCOT settlement systems internal value used to tie related values to a specific business process calculation.'; comment on column DAIOUTPUTINTERVAL.SPI is 'Seconds per interval.'; comment on column DAIOUTPUTINTERVAL.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column DAIOUTPUTINTERVAL.DSTPARTICIPANT is 'The ERCOT identifier that indicates if a record is affected by DST.'; comment on column DAIOUTPUTINTERVAL.ORIGIN is 'C=Calculated.'; comment on column DAIOUTPUTINTERVAL.TOTAL is 'Total of all intervals in data record.'; comment on column DAIOUTPUTINTERVAL.MAXIMUM is 'Maximum interval value found within the data record.'; comment on column DAIOUTPUTINTERVAL.MINIMUM is 'Minimum interval value found within the data record.'; comment on column DAIOUTPUTINTERVAL.INTERVALCOUNT is 'Number of intervals found within the data record.'; comment on column DAIOUTPUTINTERVAL.INT001 is 'The parsed value for the first interval.'; comment on column DAIOUTPUTINTERVAL.INT002 is 'The parsed value for the second interval.'; comment on column DAIOUTPUTINTERVAL.INT003 is 'The parsed value for the third interval.'; comment on column DAIOUTPUTINTERVAL.INT004 is 'The parsed value for the fourth interval.'; comment on column DAIOUTPUTINTERVAL.INT005 is 'The parsed value for the fifth interval.'; comment on column DAIOUTPUTINTERVAL.INT006 is 'The parsed value for the 6th interval.'; comment on column DAIOUTPUTINTERVAL.INT007 is 'The parsed value for the 7th interval.'; comment on column DAIOUTPUTINTERVAL.INT008 is 'The parsed value for the 8th interval.'; comment on column DAIOUTPUTINTERVAL.INT009 is 'The parsed value for the 9th interval.'; comment on column DAIOUTPUTINTERVAL.INT010 is 'The parsed value for the 10th interval.'; comment on column DAIOUTPUTINTERVAL.INT011 is 'The parsed value for the 11th interval.'; comment on column DAIOUTPUTINTERVAL.INT012 is 'The parsed value for the 12th interval.'; comment on column DAIOUTPUTINTERVAL.INT013 is 'The parsed value for the 13th interval.'; comment on column DAIOUTPUTINTERVAL.INT014 is 'The parsed value for the 14th interval.'; comment on column DAIOUTPUTINTERVAL.INT015 is 'The parsed value for the 15th interval.'; comment on column DAIOUTPUTINTERVAL.INT016 is 'The parsed value for the 16th interval.'; comment on column DAIOUTPUTINTERVAL.INT017 is 'The parsed value for the 17th interval.'; comment on column DAIOUTPUTINTERVAL.INT018 is 'The parsed value for the 18th interval.'; comment on column DAIOUTPUTINTERVAL.INT019 is 'The parsed value for the 19th interval.'; comment on column DAIOUTPUTINTERVAL.INT020 is 'The parsed value for the 20th interval.'; comment on column DAIOUTPUTINTERVAL.INT021 is 'The parsed value for the 21th interval.'; comment on column DAIOUTPUTINTERVAL.INT022 is 'The parsed value for the 22th interval.'; comment on column DAIOUTPUTINTERVAL.INT023 is 'The parsed value for the 23th interval.'; comment on column DAIOUTPUTINTERVAL.INT024 is 'The parsed value for the 24th interval.'; comment on column DAIOUTPUTINTERVAL.INT025 is 'The parsed value for the 25th interval.'; comment on column DAIOUTPUTINTERVAL.INT026 is 'The parsed value for the 26th interval.'; comment on column DAIOUTPUTINTERVAL.INT027 is 'The parsed value for the 27th interval.'; comment on column DAIOUTPUTINTERVAL.INT028 is 'The parsed value for the 28th interval.'; comment on column DAIOUTPUTINTERVAL.INT029 is 'The parsed value for the 29th interval.'; comment on column DAIOUTPUTINTERVAL.INT030 is 'The parsed value for the 30th interval.'; comment on column DAIOUTPUTINTERVAL.INT031 is 'The parsed value for the 31th interval.'; comment on column DAIOUTPUTINTERVAL.INT032 is 'The parsed value for the 32th interval.'; comment on column DAIOUTPUTINTERVAL.INT033 is 'The parsed value for the 33th interval.'; comment on column DAIOUTPUTINTERVAL.INT034 is 'The parsed value for the 34th interval.'; comment on column DAIOUTPUTINTERVAL.INT035 is 'The parsed value for the 35th interval.'; comment on column DAIOUTPUTINTERVAL.INT036 is 'The parsed value for the 36th interval.'; comment on column DAIOUTPUTINTERVAL.INT037 is 'The parsed value for the 37th interval.'; comment on column DAIOUTPUTINTERVAL.INT038 is 'The parsed value for the 38th interval.'; comment on column DAIOUTPUTINTERVAL.INT039 is 'The parsed value for the 39th interval.'; comment on column DAIOUTPUTINTERVAL.INT040 is 'The parsed value for the 40th interval.'; comment on column DAIOUTPUTINTERVAL.INT041 is 'The parsed value for the 41th interval.'; comment on column DAIOUTPUTINTERVAL.INT042 is 'The parsed value for the 42th interval.'; comment on column DAIOUTPUTINTERVAL.INT043 is 'The parsed value for the 43th interval.'; comment on column DAIOUTPUTINTERVAL.INT044 is 'The parsed value for the 44th interval.'; comment on column DAIOUTPUTINTERVAL.INT045 is 'The parsed value for the 45th interval.'; comment on column DAIOUTPUTINTERVAL.INT046 is 'The parsed value for the 46th interval.'; comment on column DAIOUTPUTINTERVAL.INT047 is 'The parsed value for the 47th interval.'; comment on column DAIOUTPUTINTERVAL.INT048 is 'The parsed value for the 48th interval.'; comment on column DAIOUTPUTINTERVAL.INT049 is 'The parsed value for the 49th interval.'; comment on column DAIOUTPUTINTERVAL.INT050 is 'The parsed value for the 50th interval.'; comment on column DAIOUTPUTINTERVAL.INT051 is 'The parsed value for the 51th interval.'; comment on column DAIOUTPUTINTERVAL.INT052 is 'The parsed value for the 52th interval.'; comment on column DAIOUTPUTINTERVAL.INT053 is 'The parsed value for the 53th interval.'; comment on column DAIOUTPUTINTERVAL.INT054 is 'The parsed value for the 54th interval.'; comment on column DAIOUTPUTINTERVAL.INT055 is 'The parsed value for the 55th interval.'; comment on column DAIOUTPUTINTERVAL.INT056 is 'The parsed value for the 56th interval.'; comment on column DAIOUTPUTINTERVAL.INT057 is 'The parsed value for the 57th interval.'; comment on column DAIOUTPUTINTERVAL.INT058 is 'The parsed value for the 58th interval.'; comment on column DAIOUTPUTINTERVAL.INT059 is 'The parsed value for the 59th interval.'; comment on column DAIOUTPUTINTERVAL.INT060 is 'The parsed value for the 60th interval.'; comment on column DAIOUTPUTINTERVAL.INT061 is 'The parsed value for the 61th interval.'; comment on column DAIOUTPUTINTERVAL.INT062 is 'The parsed value for the 62th interval.'; comment on column DAIOUTPUTINTERVAL.INT063 is 'The parsed value for the 63th interval.'; comment on column DAIOUTPUTINTERVAL.INT064 is 'The parsed value for the 64th interval.'; comment on column DAIOUTPUTINTERVAL.INT065 is 'The parsed value for the 65th interval.'; comment on column DAIOUTPUTINTERVAL.INT066 is 'The parsed value for the 66th interval.'; comment on column DAIOUTPUTINTERVAL.INT067 is 'The parsed value for the 67th interval.'; comment on column DAIOUTPUTINTERVAL.INT068 is 'The parsed value for the 68th interval.'; comment on column DAIOUTPUTINTERVAL.INT069 is 'The parsed value for the 69th interval.'; comment on column DAIOUTPUTINTERVAL.INT070 is 'The parsed value for the 70th interval.'; comment on column DAIOUTPUTINTERVAL.INT071 is 'The parsed value for the 71th interval.'; comment on column DAIOUTPUTINTERVAL.INT072 is 'The parsed value for the 72th interval.'; comment on column DAIOUTPUTINTERVAL.INT073 is 'The parsed value for the 73th interval.'; comment on column DAIOUTPUTINTERVAL.INT074 is 'The parsed value for the 74th interval.'; comment on column DAIOUTPUTINTERVAL.INT075 is 'The parsed value for the 75th interval.'; comment on column DAIOUTPUTINTERVAL.INT076 is 'The parsed value for the 76th interval.'; comment on column DAIOUTPUTINTERVAL.INT077 is 'The parsed value for the 77th interval.'; comment on column DAIOUTPUTINTERVAL.INT078 is 'The parsed value for the 78th interval.'; comment on column DAIOUTPUTINTERVAL.INT079 is 'The parsed value for the 79th interval.'; comment on column DAIOUTPUTINTERVAL.INT080 is 'The parsed value for the 80th interval.'; comment on column DAIOUTPUTINTERVAL.INT081 is 'The parsed value for the 81th interval.'; comment on column DAIOUTPUTINTERVAL.INT082 is 'The parsed value for the 82th interval.'; comment on column DAIOUTPUTINTERVAL.INT083 is 'The parsed value for the 83th interval.'; comment on column DAIOUTPUTINTERVAL.INT084 is 'The parsed value for the 84th interval.'; comment on column DAIOUTPUTINTERVAL.INT085 is 'The parsed value for the 85th interval.'; comment on column DAIOUTPUTINTERVAL.INT086 is 'The parsed value for the 86th interval.'; comment on column DAIOUTPUTINTERVAL.INT087 is 'The parsed value for the 87th interval.'; comment on column DAIOUTPUTINTERVAL.INT088 is 'The parsed value for the 88th interval.'; comment on column DAIOUTPUTINTERVAL.INT089 is 'The parsed value for the 89th interval.'; comment on column DAIOUTPUTINTERVAL.INT090 is 'The parsed value for the 90th interval.'; comment on column DAIOUTPUTINTERVAL.INT091 is 'The parsed value for the 91th interval.'; comment on column DAIOUTPUTINTERVAL.INT092 is 'The parsed value for the 92th interval.'; comment on column DAIOUTPUTINTERVAL.INT093 is 'The parsed value for the 93th interval.'; comment on column DAIOUTPUTINTERVAL.INT094 is 'The parsed value for the 94th interval.'; comment on column DAIOUTPUTINTERVAL.INT095 is 'The parsed value for the 95th interval.'; comment on column DAIOUTPUTINTERVAL.INT096 is 'The parsed value for the 96th interval.'; comment on column DAIOUTPUTINTERVAL.INT097 is 'The parsed value for the 97th interval.'; comment on column DAIOUTPUTINTERVAL.INT098 is 'The parsed value for the 98th interval.'; comment on column DAIOUTPUTINTERVAL.INT099 is 'The parsed value for the 99th interval.'; comment on column DAIOUTPUTINTERVAL.INT100 is 'The parsed value for the 100th interval.'; comment on column DAIOUTPUTINTERVAL.LSTIME is 'The data record timestamp.'; -- Create table create table DAMOUTPUTHEADER ( UIDDAMOUTPUTHEADER NUMBER(19) not null, SAVERECORDER VARCHAR2(128) not null, SAVECHANNEL NUMBER(6) not null, UIDBILLDETERMINANT NUMBER(5) not null, UIDMARKET NUMBER(19), QSECODE VARCHAR2(64), UIDSETLPOINT NUMBER(19), UIDSOURCESETLPOINT NUMBER(19), UIDSINKSETLPOINT NUMBER(19), UIDASMARKET NUMBER(19), UIDRESOURCE NUMBER(19), LSTIME DATE ); -- Create table comment COMMENT ON TABLE DAMOUTPUTHEADER is 'Defined PARENT table containing business level attributes for the results for DAM settlements (excluding CRR settlement). This is an approved settlements data set.'; comment on column DAMOUTPUTHEADER.UIDDAMOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the DAMOUTPUTHEADER data record.'; comment on column DAMOUTPUTHEADER.SAVERECORDER is 'The concatenated attributes of the DAMOUTPUTHEADER.'; comment on column DAMOUTPUTHEADER.SAVECHANNEL is 'ERCOT settlement systems number relational to the number of times an operating day is settled.'; comment on column DAMOUTPUTHEADER.UIDBILLDETERMINANT is 'The ERCOT settlement systems unique identifier for the BILLDETERMINANT data record.'; comment on column DAMOUTPUTHEADER.UIDMARKET is 'The ERCOT settlement systems unique identifier for the MARKET data record.'; comment on column DAMOUTPUTHEADER.QSECODE is 'The ERCOT settlement systems code associated to a QSE.'; comment on column DAMOUTPUTHEADER.UIDSETLPOINT is 'The ERCOT settlement systems unique identifier for the SETTLEMENTPOINT data record.'; comment on column DAMOUTPUTHEADER.UIDSOURCESETLPOINT is 'The ERCOT settlement systems unique identifier for the SOURCESETLPOINT data record.'; comment on column DAMOUTPUTHEADER.UIDSINKSETLPOINT is 'The ERCOT settlement systems unique identifier for the SINKSETLPOINT data record.'; comment on column DAMOUTPUTHEADER.UIDASMARKET is 'The ERCOT settlement systems unique identifier for the ASMARKET data record.'; comment on column DAMOUTPUTHEADER.UIDRESOURCE is 'The ERCOT settlement systems unique identifier for the RESOURCE data record.'; comment on column DAMOUTPUTHEADER.LSTIME is 'The data record timestamp.'; -- Create table create table DAMOUTPUTINTERVAL ( UIDDAMOUTPUTINTERVAL NUMBER(19) not null, UIDDAMOUTPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UIDSTATEMENTSCHED NUMBER(19) not null, CALCGROUP NUMBER(10) not null, SPI NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, DSTPARTICIPANT CHAR(1) not null, ORIGIN CHAR(1), CHNLCUTTIMESTAMP DATE, TZSTDNAME VARCHAR2(32), TOTAL FLOAT not null, MAXIMUM FLOAT not null, MINIMUM FLOAT not null, INTERVALCOUNT NUMBER(10) not null, INT001 NUMBER, INT002 NUMBER, INT003 NUMBER, INT004 NUMBER, INT005 NUMBER, INT006 NUMBER, INT007 NUMBER, INT008 NUMBER, INT009 NUMBER, INT010 NUMBER, INT011 NUMBER, INT012 NUMBER, INT013 NUMBER, INT014 NUMBER, INT015 NUMBER, INT016 NUMBER, INT017 NUMBER, INT018 NUMBER, INT019 NUMBER, INT020 NUMBER, INT021 NUMBER, INT022 NUMBER, INT023 NUMBER, INT024 NUMBER, INT025 NUMBER, INT026 NUMBER, INT027 NUMBER, INT028 NUMBER, INT029 NUMBER, INT030 NUMBER, INT031 NUMBER, INT032 NUMBER, INT033 NUMBER, INT034 NUMBER, INT035 NUMBER, INT036 NUMBER, INT037 NUMBER, INT038 NUMBER, INT039 NUMBER, INT040 NUMBER, INT041 NUMBER, INT042 NUMBER, INT043 NUMBER, INT044 NUMBER, INT045 NUMBER, INT046 NUMBER, INT047 NUMBER, INT048 NUMBER, INT049 NUMBER, INT050 NUMBER, INT051 NUMBER, INT052 NUMBER, INT053 NUMBER, INT054 NUMBER, INT055 NUMBER, INT056 NUMBER, INT057 NUMBER, INT058 NUMBER, INT059 NUMBER, INT060 NUMBER, INT061 NUMBER, INT062 NUMBER, INT063 NUMBER, INT064 NUMBER, INT065 NUMBER, INT066 NUMBER, INT067 NUMBER, INT068 NUMBER, INT069 NUMBER, INT070 NUMBER, INT071 NUMBER, INT072 NUMBER, INT073 NUMBER, INT074 NUMBER, INT075 NUMBER, INT076 NUMBER, INT077 NUMBER, INT078 NUMBER, INT079 NUMBER, INT080 NUMBER, INT081 NUMBER, INT082 NUMBER, INT083 NUMBER, INT084 NUMBER, INT085 NUMBER, INT086 NUMBER, INT087 NUMBER, INT088 NUMBER, INT089 NUMBER, INT090 NUMBER, INT091 NUMBER, INT092 NUMBER, INT093 NUMBER, INT094 NUMBER, INT095 NUMBER, INT096 NUMBER, INT097 NUMBER, INT098 NUMBER, INT099 NUMBER, INT100 NUMBER, LSTIME DATE ); -- Create table comment COMMENT ON TABLE DAMOUTPUTINTERVAL is 'Defined INTERVAL table containing both the interval data and data level attributes for the calculated results for DAM settlements. This is an approved settlements data set'; comment on column DAMOUTPUTINTERVAL.UIDDAMOUTPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the DAMOUTPUTINTERVAL data record.'; comment on column DAMOUTPUTINTERVAL.UIDDAMOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the DAMOUTPUTHEADER data record.'; comment on column DAMOUTPUTINTERVAL.STARTTIME is 'The starttime the data represents.'; comment on column DAMOUTPUTINTERVAL.STOPTIME is 'The stoptime the data represents through.'; comment on column DAMOUTPUTINTERVAL.UIDSTATEMENTSCHED is 'The unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; comment on column DAMOUTPUTINTERVAL.CALCGROUP is 'The ERCOT settlement systems internal value used to tie related values to a specific business process calculation.'; comment on column DAMOUTPUTINTERVAL.SPI is 'Seconds per interval.'; comment on column DAMOUTPUTINTERVAL.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column DAMOUTPUTINTERVAL.DSTPARTICIPANT is 'The ERCOT identifier that indicates if a record is affected by DST.'; comment on column DAMOUTPUTINTERVAL.ORIGIN is 'C=Calculated.'; comment on column DAMOUTPUTINTERVAL.TOTAL is 'Total of all intervals in data record.'; comment on column DAMOUTPUTINTERVAL.MAXIMUM is 'Maximum interval value found within the data record.'; comment on column DAMOUTPUTINTERVAL.MINIMUM is 'Minimum interval value found within the data record.'; comment on column DAMOUTPUTINTERVAL.INTERVALCOUNT is 'Number of intervals found within the data record.'; comment on column DAMOUTPUTINTERVAL.INT001 is 'The parsed value for the first interval.'; comment on column DAMOUTPUTINTERVAL.INT002 is 'The parsed value for the second interval.'; comment on column DAMOUTPUTINTERVAL.INT003 is 'The parsed value for the third interval.'; comment on column DAMOUTPUTINTERVAL.INT004 is 'The parsed value for the fourth interval.'; comment on column DAMOUTPUTINTERVAL.INT005 is 'The parsed value for the fifth interval.'; comment on column DAMOUTPUTINTERVAL.INT006 is 'The parsed value for the 6th interval.'; comment on column DAMOUTPUTINTERVAL.INT007 is 'The parsed value for the 7th interval.'; comment on column DAMOUTPUTINTERVAL.INT008 is 'The parsed value for the 8th interval.'; comment on column DAMOUTPUTINTERVAL.INT009 is 'The parsed value for the 9th interval.'; comment on column DAMOUTPUTINTERVAL.INT010 is 'The parsed value for the 10th interval.'; comment on column DAMOUTPUTINTERVAL.INT011 is 'The parsed value for the 11th interval.'; comment on column DAMOUTPUTINTERVAL.INT012 is 'The parsed value for the 12th interval.'; comment on column DAMOUTPUTINTERVAL.INT013 is 'The parsed value for the 13th interval.'; comment on column DAMOUTPUTINTERVAL.INT014 is 'The parsed value for the 14th interval.'; comment on column DAMOUTPUTINTERVAL.INT015 is 'The parsed value for the 15th interval.'; comment on column DAMOUTPUTINTERVAL.INT016 is 'The parsed value for the 16th interval.'; comment on column DAMOUTPUTINTERVAL.INT017 is 'The parsed value for the 17th interval.'; comment on column DAMOUTPUTINTERVAL.INT018 is 'The parsed value for the 18th interval.'; comment on column DAMOUTPUTINTERVAL.INT019 is 'The parsed value for the 19th interval.'; comment on column DAMOUTPUTINTERVAL.INT020 is 'The parsed value for the 20th interval.'; comment on column DAMOUTPUTINTERVAL.INT021 is 'The parsed value for the 21th interval.'; comment on column DAMOUTPUTINTERVAL.INT022 is 'The parsed value for the 22th interval.'; comment on column DAMOUTPUTINTERVAL.INT023 is 'The parsed value for the 23th interval.'; comment on column DAMOUTPUTINTERVAL.INT024 is 'The parsed value for the 24th interval.'; comment on column DAMOUTPUTINTERVAL.INT025 is 'The parsed value for the 25th interval.'; comment on column DAMOUTPUTINTERVAL.INT026 is 'The parsed value for the 26th interval.'; comment on column DAMOUTPUTINTERVAL.INT027 is 'The parsed value for the 27th interval.'; comment on column DAMOUTPUTINTERVAL.INT028 is 'The parsed value for the 28th interval.'; comment on column DAMOUTPUTINTERVAL.INT029 is 'The parsed value for the 29th interval.'; comment on column DAMOUTPUTINTERVAL.INT030 is 'The parsed value for the 30th interval.'; comment on column DAMOUTPUTINTERVAL.INT031 is 'The parsed value for the 31th interval.'; comment on column DAMOUTPUTINTERVAL.INT032 is 'The parsed value for the 32th interval.'; comment on column DAMOUTPUTINTERVAL.INT033 is 'The parsed value for the 33th interval.'; comment on column DAMOUTPUTINTERVAL.INT034 is 'The parsed value for the 34th interval.'; comment on column DAMOUTPUTINTERVAL.INT035 is 'The parsed value for the 35th interval.'; comment on column DAMOUTPUTINTERVAL.INT036 is 'The parsed value for the 36th interval.'; comment on column DAMOUTPUTINTERVAL.INT037 is 'The parsed value for the 37th interval.'; comment on column DAMOUTPUTINTERVAL.INT038 is 'The parsed value for the 38th interval.'; comment on column DAMOUTPUTINTERVAL.INT039 is 'The parsed value for the 39th interval.'; comment on column DAMOUTPUTINTERVAL.INT040 is 'The parsed value for the 40th interval.'; comment on column DAMOUTPUTINTERVAL.INT041 is 'The parsed value for the 41th interval.'; comment on column DAMOUTPUTINTERVAL.INT042 is 'The parsed value for the 42th interval.'; comment on column DAMOUTPUTINTERVAL.INT043 is 'The parsed value for the 43th interval.'; comment on column DAMOUTPUTINTERVAL.INT044 is 'The parsed value for the 44th interval.'; comment on column DAMOUTPUTINTERVAL.INT045 is 'The parsed value for the 45th interval.'; comment on column DAMOUTPUTINTERVAL.INT046 is 'The parsed value for the 46th interval.'; comment on column DAMOUTPUTINTERVAL.INT047 is 'The parsed value for the 47th interval.'; comment on column DAMOUTPUTINTERVAL.INT048 is 'The parsed value for the 48th interval.'; comment on column DAMOUTPUTINTERVAL.INT049 is 'The parsed value for the 49th interval.'; comment on column DAMOUTPUTINTERVAL.INT050 is 'The parsed value for the 50th interval.'; comment on column DAMOUTPUTINTERVAL.INT051 is 'The parsed value for the 51th interval.'; comment on column DAMOUTPUTINTERVAL.INT052 is 'The parsed value for the 52th interval.'; comment on column DAMOUTPUTINTERVAL.INT053 is 'The parsed value for the 53th interval.'; comment on column DAMOUTPUTINTERVAL.INT054 is 'The parsed value for the 54th interval.'; comment on column DAMOUTPUTINTERVAL.INT055 is 'The parsed value for the 55th interval.'; comment on column DAMOUTPUTINTERVAL.INT056 is 'The parsed value for the 56th interval.'; comment on column DAMOUTPUTINTERVAL.INT057 is 'The parsed value for the 57th interval.'; comment on column DAMOUTPUTINTERVAL.INT058 is 'The parsed value for the 58th interval.'; comment on column DAMOUTPUTINTERVAL.INT059 is 'The parsed value for the 59th interval.'; comment on column DAMOUTPUTINTERVAL.INT060 is 'The parsed value for the 60th interval.'; comment on column DAMOUTPUTINTERVAL.INT061 is 'The parsed value for the 61th interval.'; comment on column DAMOUTPUTINTERVAL.INT062 is 'The parsed value for the 62th interval.'; comment on column DAMOUTPUTINTERVAL.INT063 is 'The parsed value for the 63th interval.'; comment on column DAMOUTPUTINTERVAL.INT064 is 'The parsed value for the 64th interval.'; comment on column DAMOUTPUTINTERVAL.INT065 is 'The parsed value for the 65th interval.'; comment on column DAMOUTPUTINTERVAL.INT066 is 'The parsed value for the 66th interval.'; comment on column DAMOUTPUTINTERVAL.INT067 is 'The parsed value for the 67th interval.'; comment on column DAMOUTPUTINTERVAL.INT068 is 'The parsed value for the 68th interval.'; comment on column DAMOUTPUTINTERVAL.INT069 is 'The parsed value for the 69th interval.'; comment on column DAMOUTPUTINTERVAL.INT070 is 'The parsed value for the 70th interval.'; comment on column DAMOUTPUTINTERVAL.INT071 is 'The parsed value for the 71th interval.'; comment on column DAMOUTPUTINTERVAL.INT072 is 'The parsed value for the 72th interval.'; comment on column DAMOUTPUTINTERVAL.INT073 is 'The parsed value for the 73th interval.'; comment on column DAMOUTPUTINTERVAL.INT074 is 'The parsed value for the 74th interval.'; comment on column DAMOUTPUTINTERVAL.INT075 is 'The parsed value for the 75th interval.'; comment on column DAMOUTPUTINTERVAL.INT076 is 'The parsed value for the 76th interval.'; comment on column DAMOUTPUTINTERVAL.INT077 is 'The parsed value for the 77th interval.'; comment on column DAMOUTPUTINTERVAL.INT078 is 'The parsed value for the 78th interval.'; comment on column DAMOUTPUTINTERVAL.INT079 is 'The parsed value for the 79th interval.'; comment on column DAMOUTPUTINTERVAL.INT080 is 'The parsed value for the 80th interval.'; comment on column DAMOUTPUTINTERVAL.INT081 is 'The parsed value for the 81th interval.'; comment on column DAMOUTPUTINTERVAL.INT082 is 'The parsed value for the 82th interval.'; comment on column DAMOUTPUTINTERVAL.INT083 is 'The parsed value for the 83th interval.'; comment on column DAMOUTPUTINTERVAL.INT084 is 'The parsed value for the 84th interval.'; comment on column DAMOUTPUTINTERVAL.INT085 is 'The parsed value for the 85th interval.'; comment on column DAMOUTPUTINTERVAL.INT086 is 'The parsed value for the 86th interval.'; comment on column DAMOUTPUTINTERVAL.INT087 is 'The parsed value for the 87th interval.'; comment on column DAMOUTPUTINTERVAL.INT088 is 'The parsed value for the 88th interval.'; comment on column DAMOUTPUTINTERVAL.INT089 is 'The parsed value for the 89th interval.'; comment on column DAMOUTPUTINTERVAL.INT090 is 'The parsed value for the 90th interval.'; comment on column DAMOUTPUTINTERVAL.INT091 is 'The parsed value for the 91th interval.'; comment on column DAMOUTPUTINTERVAL.INT092 is 'The parsed value for the 92th interval.'; comment on column DAMOUTPUTINTERVAL.INT093 is 'The parsed value for the 93th interval.'; comment on column DAMOUTPUTINTERVAL.INT094 is 'The parsed value for the 94th interval.'; comment on column DAMOUTPUTINTERVAL.INT095 is 'The parsed value for the 95th interval.'; comment on column DAMOUTPUTINTERVAL.INT096 is 'The parsed value for the 96th interval.'; comment on column DAMOUTPUTINTERVAL.INT097 is 'The parsed value for the 97th interval.'; comment on column DAMOUTPUTINTERVAL.INT098 is 'The parsed value for the 98th interval.'; comment on column DAMOUTPUTINTERVAL.INT099 is 'The parsed value for the 99th interval.'; comment on column DAMOUTPUTINTERVAL.INT100 is 'The parsed value for the 100th interval.'; comment on column DAMOUTPUTINTERVAL.LSTIME is 'The data record timestamp.'; -- Create table create table LLSOUTPUTHEADER ( UIDLLSOUTPUTHEADER NUMBER(19) not null, UIDBILLDETERMINANT NUMBER(5) not null, QSECODE VARCHAR2(64) not null, REPCODE VARCHAR2(64) not null , UIDSETLPOINT NUMBER(19) not null, UFEZONECODE VARCHAR2(64) not null, PROFILECODE VARCHAR2(64) not null, LOSSCODE VARCHAR2(64) not null, TDSPCODE VARCHAR2(64) not null, METHOD VARCHAR2(8) not null, LSTIME DATE, SAVERECORDER VARCHAR2(128), SAVECHANNEL NUMBER(6) ); -- Create table comment COMMENT ON TABLE LLSOUTPUTHEADER is 'Defined PARENT table containing business level attributes for the data aggregation load data at its most granular level. This is an approved settlements data set.'; comment on column LLSOUTPUTHEADER.UIDLLSOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the LLSOUTPUTHEADER data record.'; comment on column LLSOUTPUTHEADER.UIDBILLDETERMINANT is 'The ERCOT settlement systems unique identifier for the BILLDETERMINANT data record.'; comment on column LLSOUTPUTHEADER.QSECODE is 'The ERCOT settlement systems code associated to a QSE.'; comment on column LLSOUTPUTHEADER.REPCODE is 'The ERCOT settlement systems code associated to a REP.'; comment on column LLSOUTPUTHEADER.UIDSETLPOINT is 'The ERCOT settlement systems unique identifier for the SETTLEMENTPOINT data record.'; comment on column LLSOUTPUTHEADER.UFEZONECODE is 'The ERCOT settlement systems unique identifier for the UFEZONE data record.'; comment on column LLSOUTPUTHEADER.PROFILECODE is 'The ERCOT settlement systems code associated to a PROFILECLASS.'; comment on column LLSOUTPUTHEADER.LOSSCODE is 'The ERCOT settlement systems code associated to a LOSSCLASS.'; comment on column LLSOUTPUTHEADER.TDSPCODE is 'The ERCOT settlement systems code associated to a TDSP.'; comment on column LLSOUTPUTHEADER.METHOD is 'The ERCOT settlement systems code assigned to the data record based on the type of usage that was used during the data aggregation process. The type of usage is defined as Actual, Estimated, and Default, which is paired with other usage attributes (i.e. IDR, NIDR, DCTIE, NOIE, etc.).'; comment on column LLSOUTPUTHEADER.LSTIME is 'The data record timestamp.'; comment on column LLSOUTPUTHEADER.SAVERECORDER is 'The concatenated attributes of the LLSOUTPUTHEADER.'; comment on column LLSOUTPUTHEADER.SAVECHANNEL is 'ERCOT settlement systems number relational to the number of times an operating day is settled.'; -- Create table create table LLSOUTPUTINTERVAL ( UIDLLSOUTPUTINTERVAL NUMBER(19) not null, UIDLLSOUTPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UIDSTATEMENTSCHED NUMBER(19) not null, CALCGROUP NUMBER(10) not null, SPI NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, DSTPARTICIPANT CHAR(1) not null, ORIGIN CHAR(1), CHNLCUTTIMESTAMP DATE, TZSTDNAME VARCHAR2(32), TOTAL FLOAT not null, MAXIMUM FLOAT not null, MINIMUM FLOAT not null, INTERVALCOUNT NUMBER(10) not null, INT001 NUMBER, INT002 NUMBER, INT003 NUMBER, INT004 NUMBER, INT005 NUMBER, INT006 NUMBER, INT007 NUMBER, INT008 NUMBER, INT009 NUMBER, INT010 NUMBER, INT011 NUMBER, INT012 NUMBER, INT013 NUMBER, INT014 NUMBER, INT015 NUMBER, INT016 NUMBER, INT017 NUMBER, INT018 NUMBER, INT019 NUMBER, INT020 NUMBER, INT021 NUMBER, INT022 NUMBER, INT023 NUMBER, INT024 NUMBER, INT025 NUMBER, INT026 NUMBER, INT027 NUMBER, INT028 NUMBER, INT029 NUMBER, INT030 NUMBER, INT031 NUMBER, INT032 NUMBER, INT033 NUMBER, INT034 NUMBER, INT035 NUMBER, INT036 NUMBER, INT037 NUMBER, INT038 NUMBER, INT039 NUMBER, INT040 NUMBER, INT041 NUMBER, INT042 NUMBER, INT043 NUMBER, INT044 NUMBER, INT045 NUMBER, INT046 NUMBER, INT047 NUMBER, INT048 NUMBER, INT049 NUMBER, INT050 NUMBER, INT051 NUMBER, INT052 NUMBER, INT053 NUMBER, INT054 NUMBER, INT055 NUMBER, INT056 NUMBER, INT057 NUMBER, INT058 NUMBER, INT059 NUMBER, INT060 NUMBER, INT061 NUMBER, INT062 NUMBER, INT063 NUMBER, INT064 NUMBER, INT065 NUMBER, INT066 NUMBER, INT067 NUMBER, INT068 NUMBER, INT069 NUMBER, INT070 NUMBER, INT071 NUMBER, INT072 NUMBER, INT073 NUMBER, INT074 NUMBER, INT075 NUMBER, INT076 NUMBER, INT077 NUMBER, INT078 NUMBER, INT079 NUMBER, INT080 NUMBER, INT081 NUMBER, INT082 NUMBER, INT083 NUMBER, INT084 NUMBER, INT085 NUMBER, INT086 NUMBER, INT087 NUMBER, INT088 NUMBER, INT089 NUMBER, INT090 NUMBER, INT091 NUMBER, INT092 NUMBER, INT093 NUMBER, INT094 NUMBER, INT095 NUMBER, INT096 NUMBER, INT097 NUMBER, INT098 NUMBER, INT099 NUMBER, INT100 NUMBER, LSTIME DATE ); -- Create table comment COMMENT ON TABLE LLSOUTPUTINTERVAL is 'Defined INTERVAL table containing both: the interval data and data level attributes for the data aggregation load data at its most granular level. This is an approved settlements data set '; comment on column LLSOUTPUTINTERVAL.UIDLLSOUTPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the LLSOUTPUTINTERVAL data record.'; comment on column LLSOUTPUTINTERVAL.UIDLLSOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the LLSOUTPUTHEADER data record.'; comment on column LLSOUTPUTINTERVAL.STARTTIME is 'The starttime the data represents.'; comment on column LLSOUTPUTINTERVAL.STOPTIME is 'The stoptime the data represents through.'; comment on column LLSOUTPUTINTERVAL.UIDSTATEMENTSCHED is 'The unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; comment on column LLSOUTPUTINTERVAL.CALCGROUP is 'The ERCOT settlement systems internal value used to tie related values to a specific business process calculation.'; comment on column LLSOUTPUTINTERVAL.SPI is 'Seconds per interval.'; comment on column LLSOUTPUTINTERVAL.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column LLSOUTPUTINTERVAL.DSTPARTICIPANT is 'The ERCOT identifier that indicates if a record is affected by DST.'; comment on column LLSOUTPUTINTERVAL.ORIGIN is 'C=Calculated.'; comment on column LLSOUTPUTINTERVAL.TOTAL is 'Total of all intervals in data record.'; comment on column LLSOUTPUTINTERVAL.MAXIMUM is 'Maximum interval value found within the data record.'; comment on column LLSOUTPUTINTERVAL.MINIMUM is 'Minimum interval value found within the data record.'; comment on column LLSOUTPUTINTERVAL.INTERVALCOUNT is 'Number of intervals found within the data record.'; comment on column LLSOUTPUTINTERVAL.INT001 is 'The parsed value for the first interval.'; comment on column LLSOUTPUTINTERVAL.INT002 is 'The parsed value for the second interval.'; comment on column LLSOUTPUTINTERVAL.INT003 is 'The parsed value for the third interval.'; comment on column LLSOUTPUTINTERVAL.INT004 is 'The parsed value for the fourth interval.'; comment on column LLSOUTPUTINTERVAL.INT005 is 'The parsed value for the fifth interval.'; comment on column LLSOUTPUTINTERVAL.INT006 is 'The parsed value for the 6th interval.'; comment on column LLSOUTPUTINTERVAL.INT007 is 'The parsed value for the 7th interval.'; comment on column LLSOUTPUTINTERVAL.INT008 is 'The parsed value for the 8th interval.'; comment on column LLSOUTPUTINTERVAL.INT009 is 'The parsed value for the 9th interval.'; comment on column LLSOUTPUTINTERVAL.INT010 is 'The parsed value for the 10th interval.'; comment on column LLSOUTPUTINTERVAL.INT011 is 'The parsed value for the 11th interval.'; comment on column LLSOUTPUTINTERVAL.INT012 is 'The parsed value for the 12th interval.'; comment on column LLSOUTPUTINTERVAL.INT013 is 'The parsed value for the 13th interval.'; comment on column LLSOUTPUTINTERVAL.INT014 is 'The parsed value for the 14th interval.'; comment on column LLSOUTPUTINTERVAL.INT015 is 'The parsed value for the 15th interval.'; comment on column LLSOUTPUTINTERVAL.INT016 is 'The parsed value for the 16th interval.'; comment on column LLSOUTPUTINTERVAL.INT017 is 'The parsed value for the 17th interval.'; comment on column LLSOUTPUTINTERVAL.INT018 is 'The parsed value for the 18th interval.'; comment on column LLSOUTPUTINTERVAL.INT019 is 'The parsed value for the 19th interval.'; comment on column LLSOUTPUTINTERVAL.INT020 is 'The parsed value for the 20th interval.'; comment on column LLSOUTPUTINTERVAL.INT021 is 'The parsed value for the 21th interval.'; comment on column LLSOUTPUTINTERVAL.INT022 is 'The parsed value for the 22th interval.'; comment on column LLSOUTPUTINTERVAL.INT023 is 'The parsed value for the 23th interval.'; comment on column LLSOUTPUTINTERVAL.INT024 is 'The parsed value for the 24th interval.'; comment on column LLSOUTPUTINTERVAL.INT025 is 'The parsed value for the 25th interval.'; comment on column LLSOUTPUTINTERVAL.INT026 is 'The parsed value for the 26th interval.'; comment on column LLSOUTPUTINTERVAL.INT027 is 'The parsed value for the 27th interval.'; comment on column LLSOUTPUTINTERVAL.INT028 is 'The parsed value for the 28th interval.'; comment on column LLSOUTPUTINTERVAL.INT029 is 'The parsed value for the 29th interval.'; comment on column LLSOUTPUTINTERVAL.INT030 is 'The parsed value for the 30th interval.'; comment on column LLSOUTPUTINTERVAL.INT031 is 'The parsed value for the 31th interval.'; comment on column LLSOUTPUTINTERVAL.INT032 is 'The parsed value for the 32th interval.'; comment on column LLSOUTPUTINTERVAL.INT033 is 'The parsed value for the 33th interval.'; comment on column LLSOUTPUTINTERVAL.INT034 is 'The parsed value for the 34th interval.'; comment on column LLSOUTPUTINTERVAL.INT035 is 'The parsed value for the 35th interval.'; comment on column LLSOUTPUTINTERVAL.INT036 is 'The parsed value for the 36th interval.'; comment on column LLSOUTPUTINTERVAL.INT037 is 'The parsed value for the 37th interval.'; comment on column LLSOUTPUTINTERVAL.INT038 is 'The parsed value for the 38th interval.'; comment on column LLSOUTPUTINTERVAL.INT039 is 'The parsed value for the 39th interval.'; comment on column LLSOUTPUTINTERVAL.INT040 is 'The parsed value for the 40th interval.'; comment on column LLSOUTPUTINTERVAL.INT041 is 'The parsed value for the 41th interval.'; comment on column LLSOUTPUTINTERVAL.INT042 is 'The parsed value for the 42th interval.'; comment on column LLSOUTPUTINTERVAL.INT043 is 'The parsed value for the 43th interval.'; comment on column LLSOUTPUTINTERVAL.INT044 is 'The parsed value for the 44th interval.'; comment on column LLSOUTPUTINTERVAL.INT045 is 'The parsed value for the 45th interval.'; comment on column LLSOUTPUTINTERVAL.INT046 is 'The parsed value for the 46th interval.'; comment on column LLSOUTPUTINTERVAL.INT047 is 'The parsed value for the 47th interval.'; comment on column LLSOUTPUTINTERVAL.INT048 is 'The parsed value for the 48th interval.'; comment on column LLSOUTPUTINTERVAL.INT049 is 'The parsed value for the 49th interval.'; comment on column LLSOUTPUTINTERVAL.INT050 is 'The parsed value for the 50th interval.'; comment on column LLSOUTPUTINTERVAL.INT051 is 'The parsed value for the 51th interval.'; comment on column LLSOUTPUTINTERVAL.INT052 is 'The parsed value for the 52th interval.'; comment on column LLSOUTPUTINTERVAL.INT053 is 'The parsed value for the 53th interval.'; comment on column LLSOUTPUTINTERVAL.INT054 is 'The parsed value for the 54th interval.'; comment on column LLSOUTPUTINTERVAL.INT055 is 'The parsed value for the 55th interval.'; comment on column LLSOUTPUTINTERVAL.INT056 is 'The parsed value for the 56th interval.'; comment on column LLSOUTPUTINTERVAL.INT057 is 'The parsed value for the 57th interval.'; comment on column LLSOUTPUTINTERVAL.INT058 is 'The parsed value for the 58th interval.'; comment on column LLSOUTPUTINTERVAL.INT059 is 'The parsed value for the 59th interval.'; comment on column LLSOUTPUTINTERVAL.INT060 is 'The parsed value for the 60th interval.'; comment on column LLSOUTPUTINTERVAL.INT061 is 'The parsed value for the 61th interval.'; comment on column LLSOUTPUTINTERVAL.INT062 is 'The parsed value for the 62th interval.'; comment on column LLSOUTPUTINTERVAL.INT063 is 'The parsed value for the 63th interval.'; comment on column LLSOUTPUTINTERVAL.INT064 is 'The parsed value for the 64th interval.'; comment on column LLSOUTPUTINTERVAL.INT065 is 'The parsed value for the 65th interval.'; comment on column LLSOUTPUTINTERVAL.INT066 is 'The parsed value for the 66th interval.'; comment on column LLSOUTPUTINTERVAL.INT067 is 'The parsed value for the 67th interval.'; comment on column LLSOUTPUTINTERVAL.INT068 is 'The parsed value for the 68th interval.'; comment on column LLSOUTPUTINTERVAL.INT069 is 'The parsed value for the 69th interval.'; comment on column LLSOUTPUTINTERVAL.INT070 is 'The parsed value for the 70th interval.'; comment on column LLSOUTPUTINTERVAL.INT071 is 'The parsed value for the 71th interval.'; comment on column LLSOUTPUTINTERVAL.INT072 is 'The parsed value for the 72th interval.'; comment on column LLSOUTPUTINTERVAL.INT073 is 'The parsed value for the 73th interval.'; comment on column LLSOUTPUTINTERVAL.INT074 is 'The parsed value for the 74th interval.'; comment on column LLSOUTPUTINTERVAL.INT075 is 'The parsed value for the 75th interval.'; comment on column LLSOUTPUTINTERVAL.INT076 is 'The parsed value for the 76th interval.'; comment on column LLSOUTPUTINTERVAL.INT077 is 'The parsed value for the 77th interval.'; comment on column LLSOUTPUTINTERVAL.INT078 is 'The parsed value for the 78th interval.'; comment on column LLSOUTPUTINTERVAL.INT079 is 'The parsed value for the 79th interval.'; comment on column LLSOUTPUTINTERVAL.INT080 is 'The parsed value for the 80th interval.'; comment on column LLSOUTPUTINTERVAL.INT081 is 'The parsed value for the 81th interval.'; comment on column LLSOUTPUTINTERVAL.INT082 is 'The parsed value for the 82th interval.'; comment on column LLSOUTPUTINTERVAL.INT083 is 'The parsed value for the 83th interval.'; comment on column LLSOUTPUTINTERVAL.INT084 is 'The parsed value for the 84th interval.'; comment on column LLSOUTPUTINTERVAL.INT085 is 'The parsed value for the 85th interval.'; comment on column LLSOUTPUTINTERVAL.INT086 is 'The parsed value for the 86th interval.'; comment on column LLSOUTPUTINTERVAL.INT087 is 'The parsed value for the 87th interval.'; comment on column LLSOUTPUTINTERVAL.INT088 is 'The parsed value for the 88th interval.'; comment on column LLSOUTPUTINTERVAL.INT089 is 'The parsed value for the 89th interval.'; comment on column LLSOUTPUTINTERVAL.INT090 is 'The parsed value for the 90th interval.'; comment on column LLSOUTPUTINTERVAL.INT091 is 'The parsed value for the 91th interval.'; comment on column LLSOUTPUTINTERVAL.INT092 is 'The parsed value for the 92th interval.'; comment on column LLSOUTPUTINTERVAL.INT093 is 'The parsed value for the 93th interval.'; comment on column LLSOUTPUTINTERVAL.INT094 is 'The parsed value for the 94th interval.'; comment on column LLSOUTPUTINTERVAL.INT095 is 'The parsed value for the 95th interval.'; comment on column LLSOUTPUTINTERVAL.INT096 is 'The parsed value for the 96th interval.'; comment on column LLSOUTPUTINTERVAL.INT097 is 'The parsed value for the 97th interval.'; comment on column LLSOUTPUTINTERVAL.INT098 is 'The parsed value for the 98th interval.'; comment on column LLSOUTPUTINTERVAL.INT099 is 'The parsed value for the 99th interval.'; comment on column LLSOUTPUTINTERVAL.INT100 is 'The parsed value for the 100th interval.'; comment on column LLSOUTPUTINTERVAL.LSTIME is 'The data record timestamp.'; -- Create table create table MKTINPUTHEADER ( UIDMKTINPUTHEADER NUMBER(19) not null, SAVERECORDER VARCHAR2(128) not null, SAVECHANNEL NUMBER(6) not null, UIDBILLDETERMINANT NUMBER(5) not null, UIDMARKET NUMBER(19) not null, QSECODE VARCHAR2(64), UIDSETLPOINT NUMBER(19), UIDSOURCESETLPOINT NUMBER(19), UIDSINKSETLPOINT NUMBER(19), RUCID NUMBER(3), CRRACCTHLDRCODE NUMBER(19), STARTTYPE NUMBER(10), UIDFLOWGATE NUMBER(19), UIDELEMENT NUMBER(19), MKTCONSTRAINTCODE NUMBER(19), UIDASMARKET NUMBER(19), UIDRESOURCE NUMBER(19), LSTIME DATE, RESOURCEID VARCHAR2(64), TDSPCODE VARCHAR2(64), LOSSCODE VARCHAR2(64), CRRID VARCHAR2(12), CRROFFERID VARCHAR2(12) ); -- Create table comment COMMENT ON TABLE MKTINPUTHEADER is 'Define PARENT table containing business level attributes for Operating Day market input data used in the data aggregation and settlement processes; this includes data received from the MMS, EMS, and CRR systems. This is an approved settlements data set'; comment on column MKTINPUTHEADER.UIDMKTINPUTHEADER is 'The ERCOT settlement systems unique identifier for the MKTINTPUTHEADER data record.'; comment on column MKTINPUTHEADER.SAVERECORDER is 'The concatenated attributes of the MKTINPUTHEADER.'; comment on column MKTINPUTHEADER.SAVECHANNEL is 'All market inputs have a SAVECHANNEL=1 and are re-used in each operating day settlement.'; comment on column MKTINPUTHEADER.UIDBILLDETERMINANT is 'The ERCOT settlement systems unique identifier for the BILLDETERMINANT data record.'; comment on column MKTINPUTHEADER.UIDMARKET is 'The ERCOT settlement systems unique identifier for the MARKET data record.'; comment on column MKTINPUTHEADER.QSECODE is 'The ERCOT settlement systems code associated to a QSE.'; comment on column MKTINPUTHEADER.UIDSETLPOINT is 'The ERCOT settlement systems unique identifier for the SETTLEMENTPOINT data record.'; comment on column MKTINPUTHEADER.UIDSOURCESETLPOINT is 'The ERCOT settlement systems unique identifier for the SOURCESETLPOINT data record.'; comment on column MKTINPUTHEADER.UIDSINKSETLPOINT is 'The ERCOT settlement systems unique identifier for the SINKSETLPOINT data record.'; comment on column MKTINPUTHEADER.RUCID is 'The ERCOT identifier for the RUC process ID for which the RUC data applies.'; comment on column MKTINPUTHEADER.CRRACCTHLDRCODE is 'The ERCOT settlement systems unique identifier for the CRRACCTHLDR data record.'; comment on column MKTINPUTHEADER.STARTTYPE is 'This field contains values for the categories by which startup costs are provided in a Three-Part Supply Offer.'; comment on column MKTINPUTHEADER.UIDFLOWGATE is 'The ERCOT settlement systems unique identifier for the FLOWGATE data record.'; comment on column MKTINPUTHEADER.UIDELEMENT is 'The ERCOT settlement systems unique identifier for the ELEMENT data record.'; comment on column MKTINPUTHEADER.MKTCONSTRAINTCODE is 'The ERCOT settlement systems unique identifier for the MKTCONSTRAINT data record.'; comment on column MKTINPUTHEADER.UIDASMARKET is 'The ERCOT settlement systems unique identifier for the ASMARKET data record.'; comment on column MKTINPUTHEADER.UIDRESOURCE is 'The ERCOT settlement systems unique identifier for the RESOURCE data record.'; comment on column MKTINPUTHEADER.LSTIME is 'The data record timestamp.'; comment on column MKTINPUTHEADER.RESOURCEID is 'The ERCOT unique identifier for an ERCOT Polled Settlement meter location.'; comment on column MKTINPUTHEADER.TDSPCODE is 'The ERCOT settlement systems code associated to a TDSP.'; comment on column MKTINPUTHEADER.LOSSCODE is 'The ERCOT settlement systems code associated to a LOSSCLASS.'; -- Create table create table MKTINPUTINTERVAL ( UIDMKTINPUTINTERVAL NUMBER(19) not null, UIDMKTINPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, SPI NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, DSTPARTICIPANT CHAR(1) not null, ORIGIN CHAR(1), CHNLCUTTIMESTAMP DATE, TZSTDNAME VARCHAR2(32), TOTAL FLOAT not null, MAXIMUM FLOAT not null, MINIMUM FLOAT not null, INTERVALCOUNT NUMBER(10) not null, INT001 NUMBER, INT002 NUMBER, INT003 NUMBER, INT004 NUMBER, INT005 NUMBER, INT006 NUMBER, INT007 NUMBER, INT008 NUMBER, INT009 NUMBER, INT010 NUMBER, INT011 NUMBER, INT012 NUMBER, INT013 NUMBER, INT014 NUMBER, INT015 NUMBER, INT016 NUMBER, INT017 NUMBER, INT018 NUMBER, INT019 NUMBER, INT020 NUMBER, INT021 NUMBER, INT022 NUMBER, INT023 NUMBER, INT024 NUMBER, INT025 NUMBER, INT026 NUMBER, INT027 NUMBER, INT028 NUMBER, INT029 NUMBER, INT030 NUMBER, INT031 NUMBER, INT032 NUMBER, INT033 NUMBER, INT034 NUMBER, INT035 NUMBER, INT036 NUMBER, INT037 NUMBER, INT038 NUMBER, INT039 NUMBER, INT040 NUMBER, INT041 NUMBER, INT042 NUMBER, INT043 NUMBER, INT044 NUMBER, INT045 NUMBER, INT046 NUMBER, INT047 NUMBER, INT048 NUMBER, INT049 NUMBER, INT050 NUMBER, INT051 NUMBER, INT052 NUMBER, INT053 NUMBER, INT054 NUMBER, INT055 NUMBER, INT056 NUMBER, INT057 NUMBER, INT058 NUMBER, INT059 NUMBER, INT060 NUMBER, INT061 NUMBER, INT062 NUMBER, INT063 NUMBER, INT064 NUMBER, INT065 NUMBER, INT066 NUMBER, INT067 NUMBER, INT068 NUMBER, INT069 NUMBER, INT070 NUMBER, INT071 NUMBER, INT072 NUMBER, INT073 NUMBER, INT074 NUMBER, INT075 NUMBER, INT076 NUMBER, INT077 NUMBER, INT078 NUMBER, INT079 NUMBER, INT080 NUMBER, INT081 NUMBER, INT082 NUMBER, INT083 NUMBER, INT084 NUMBER, INT085 NUMBER, INT086 NUMBER, INT087 NUMBER, INT088 NUMBER, INT089 NUMBER, INT090 NUMBER, INT091 NUMBER, INT092 NUMBER, INT093 NUMBER, INT094 NUMBER, INT095 NUMBER, INT096 NUMBER, INT097 NUMBER, INT098 NUMBER, INT099 NUMBER, INT100 NUMBER, LSTIME DATE ); -- Create table comment COMMENT ON TABLE MKTINPUTINTERVAL is 'Defined INTERVAL table containing both the interval data and data level attributes for Operating Day interval level market input data used in the data aggregation and settlement processes this includes data received from the MMS, EMS, and CRR systems. This is an approved settlements data set.'; comment on column MKTINPUTINTERVAL.UIDMKTINPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the MKTINTPUTINTERVAL data record.'; comment on column MKTINPUTINTERVAL.UIDMKTINPUTHEADER is 'The ERCOT settlement systems unique identifier for the MKTINTPUTHEADER data record.'; comment on column MKTINPUTINTERVAL.STARTTIME is 'The starttime the data represents.'; comment on column MKTINPUTINTERVAL.STOPTIME is 'The stoptime the data represents through.'; comment on column MKTINPUTINTERVAL.SPI is 'Seconds per interval.'; comment on column MKTINPUTINTERVAL.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column MKTINPUTINTERVAL.DSTPARTICIPANT is 'The ERCOT identifier that indicates if a record is affected by DST.'; comment on column MKTINPUTINTERVAL.ORIGIN is 'C=Calculated.'; comment on column MKTINPUTINTERVAL.TOTAL is 'Total of all intervals in data record.'; comment on column MKTINPUTINTERVAL.MAXIMUM is 'Maximum interval value found within the data record.'; comment on column MKTINPUTINTERVAL.MINIMUM is 'Minimum interval value found within the data record.'; comment on column MKTINPUTINTERVAL.INTERVALCOUNT is 'Number of intervals found within the data record.'; comment on column MKTINPUTINTERVAL.INT001 is 'The parsed value for the first interval.'; comment on column MKTINPUTINTERVAL.INT002 is 'The parsed value for the second interval.'; comment on column MKTINPUTINTERVAL.INT003 is 'The parsed value for the third interval.'; comment on column MKTINPUTINTERVAL.INT004 is 'The parsed value for the fourth interval.'; comment on column MKTINPUTINTERVAL.INT005 is 'The parsed value for the fifth interval.'; comment on column MKTINPUTINTERVAL.INT006 is 'The parsed value for the 6th interval.'; comment on column MKTINPUTINTERVAL.INT007 is 'The parsed value for the 7th interval.'; comment on column MKTINPUTINTERVAL.INT008 is 'The parsed value for the 8th interval.'; comment on column MKTINPUTINTERVAL.INT009 is 'The parsed value for the 9th interval.'; comment on column MKTINPUTINTERVAL.INT010 is 'The parsed value for the 10th interval.'; comment on column MKTINPUTINTERVAL.INT011 is 'The parsed value for the 11th interval.'; comment on column MKTINPUTINTERVAL.INT012 is 'The parsed value for the 12th interval.'; comment on column MKTINPUTINTERVAL.INT013 is 'The parsed value for the 13th interval.'; comment on column MKTINPUTINTERVAL.INT014 is 'The parsed value for the 14th interval.'; comment on column MKTINPUTINTERVAL.INT015 is 'The parsed value for the 15th interval.'; comment on column MKTINPUTINTERVAL.INT016 is 'The parsed value for the 16th interval.'; comment on column MKTINPUTINTERVAL.INT017 is 'The parsed value for the 17th interval.'; comment on column MKTINPUTINTERVAL.INT018 is 'The parsed value for the 18th interval.'; comment on column MKTINPUTINTERVAL.INT019 is 'The parsed value for the 19th interval.'; comment on column MKTINPUTINTERVAL.INT020 is 'The parsed value for the 20th interval.'; comment on column MKTINPUTINTERVAL.INT021 is 'The parsed value for the 21th interval.'; comment on column MKTINPUTINTERVAL.INT022 is 'The parsed value for the 22th interval.'; comment on column MKTINPUTINTERVAL.INT023 is 'The parsed value for the 23th interval.'; comment on column MKTINPUTINTERVAL.INT024 is 'The parsed value for the 24th interval.'; comment on column MKTINPUTINTERVAL.INT025 is 'The parsed value for the 25th interval.'; comment on column MKTINPUTINTERVAL.INT026 is 'The parsed value for the 26th interval.'; comment on column MKTINPUTINTERVAL.INT027 is 'The parsed value for the 27th interval.'; comment on column MKTINPUTINTERVAL.INT028 is 'The parsed value for the 28th interval.'; comment on column MKTINPUTINTERVAL.INT029 is 'The parsed value for the 29th interval.'; comment on column MKTINPUTINTERVAL.INT030 is 'The parsed value for the 30th interval.'; comment on column MKTINPUTINTERVAL.INT031 is 'The parsed value for the 31th interval.'; comment on column MKTINPUTINTERVAL.INT032 is 'The parsed value for the 32th interval.'; comment on column MKTINPUTINTERVAL.INT033 is 'The parsed value for the 33th interval.'; comment on column MKTINPUTINTERVAL.INT034 is 'The parsed value for the 34th interval.'; comment on column MKTINPUTINTERVAL.INT035 is 'The parsed value for the 35th interval.'; comment on column MKTINPUTINTERVAL.INT036 is 'The parsed value for the 36th interval.'; comment on column MKTINPUTINTERVAL.INT037 is 'The parsed value for the 37th interval.'; comment on column MKTINPUTINTERVAL.INT038 is 'The parsed value for the 38th interval.'; comment on column MKTINPUTINTERVAL.INT039 is 'The parsed value for the 39th interval.'; comment on column MKTINPUTINTERVAL.INT040 is 'The parsed value for the 40th interval.'; comment on column MKTINPUTINTERVAL.INT041 is 'The parsed value for the 41th interval.'; comment on column MKTINPUTINTERVAL.INT042 is 'The parsed value for the 42th interval.'; comment on column MKTINPUTINTERVAL.INT043 is 'The parsed value for the 43th interval.'; comment on column MKTINPUTINTERVAL.INT044 is 'The parsed value for the 44th interval.'; comment on column MKTINPUTINTERVAL.INT045 is 'The parsed value for the 45th interval.'; comment on column MKTINPUTINTERVAL.INT046 is 'The parsed value for the 46th interval.'; comment on column MKTINPUTINTERVAL.INT047 is 'The parsed value for the 47th interval.'; comment on column MKTINPUTINTERVAL.INT048 is 'The parsed value for the 48th interval.'; comment on column MKTINPUTINTERVAL.INT049 is 'The parsed value for the 49th interval.'; comment on column MKTINPUTINTERVAL.INT050 is 'The parsed value for the 50th interval.'; comment on column MKTINPUTINTERVAL.INT051 is 'The parsed value for the 51th interval.'; comment on column MKTINPUTINTERVAL.INT052 is 'The parsed value for the 52th interval.'; comment on column MKTINPUTINTERVAL.INT053 is 'The parsed value for the 53th interval.'; comment on column MKTINPUTINTERVAL.INT054 is 'The parsed value for the 54th interval.'; comment on column MKTINPUTINTERVAL.INT055 is 'The parsed value for the 55th interval.'; comment on column MKTINPUTINTERVAL.INT056 is 'The parsed value for the 56th interval.'; comment on column MKTINPUTINTERVAL.INT057 is 'The parsed value for the 57th interval.'; comment on column MKTINPUTINTERVAL.INT058 is 'The parsed value for the 58th interval.'; comment on column MKTINPUTINTERVAL.INT059 is 'The parsed value for the 59th interval.'; comment on column MKTINPUTINTERVAL.INT060 is 'The parsed value for the 60th interval.'; comment on column MKTINPUTINTERVAL.INT061 is 'The parsed value for the 61th interval.'; comment on column MKTINPUTINTERVAL.INT062 is 'The parsed value for the 62th interval.'; comment on column MKTINPUTINTERVAL.INT063 is 'The parsed value for the 63th interval.'; comment on column MKTINPUTINTERVAL.INT064 is 'The parsed value for the 64th interval.'; comment on column MKTINPUTINTERVAL.INT065 is 'The parsed value for the 65th interval.'; comment on column MKTINPUTINTERVAL.INT066 is 'The parsed value for the 66th interval.'; comment on column MKTINPUTINTERVAL.INT067 is 'The parsed value for the 67th interval.'; comment on column MKTINPUTINTERVAL.INT068 is 'The parsed value for the 68th interval.'; comment on column MKTINPUTINTERVAL.INT069 is 'The parsed value for the 69th interval.'; comment on column MKTINPUTINTERVAL.INT070 is 'The parsed value for the 70th interval.'; comment on column MKTINPUTINTERVAL.INT071 is 'The parsed value for the 71th interval.'; comment on column MKTINPUTINTERVAL.INT072 is 'The parsed value for the 72th interval.'; comment on column MKTINPUTINTERVAL.INT073 is 'The parsed value for the 73th interval.'; comment on column MKTINPUTINTERVAL.INT074 is 'The parsed value for the 74th interval.'; comment on column MKTINPUTINTERVAL.INT075 is 'The parsed value for the 75th interval.'; comment on column MKTINPUTINTERVAL.INT076 is 'The parsed value for the 76th interval.'; comment on column MKTINPUTINTERVAL.INT077 is 'The parsed value for the 77th interval.'; comment on column MKTINPUTINTERVAL.INT078 is 'The parsed value for the 78th interval.'; comment on column MKTINPUTINTERVAL.INT079 is 'The parsed value for the 79th interval.'; comment on column MKTINPUTINTERVAL.INT080 is 'The parsed value for the 80th interval.'; comment on column MKTINPUTINTERVAL.INT081 is 'The parsed value for the 81th interval.'; comment on column MKTINPUTINTERVAL.INT082 is 'The parsed value for the 82th interval.'; comment on column MKTINPUTINTERVAL.INT083 is 'The parsed value for the 83th interval.'; comment on column MKTINPUTINTERVAL.INT084 is 'The parsed value for the 84th interval.'; comment on column MKTINPUTINTERVAL.INT085 is 'The parsed value for the 85th interval.'; comment on column MKTINPUTINTERVAL.INT086 is 'The parsed value for the 86th interval.'; comment on column MKTINPUTINTERVAL.INT087 is 'The parsed value for the 87th interval.'; comment on column MKTINPUTINTERVAL.INT088 is 'The parsed value for the 88th interval.'; comment on column MKTINPUTINTERVAL.INT089 is 'The parsed value for the 89th interval.'; comment on column MKTINPUTINTERVAL.INT090 is 'The parsed value for the 90th interval.'; comment on column MKTINPUTINTERVAL.INT091 is 'The parsed value for the 91th interval.'; comment on column MKTINPUTINTERVAL.INT092 is 'The parsed value for the 92th interval.'; comment on column MKTINPUTINTERVAL.INT093 is 'The parsed value for the 93th interval.'; comment on column MKTINPUTINTERVAL.INT094 is 'The parsed value for the 94th interval.'; comment on column MKTINPUTINTERVAL.INT095 is 'The parsed value for the 95th interval.'; comment on column MKTINPUTINTERVAL.INT096 is 'The parsed value for the 96th interval.'; comment on column MKTINPUTINTERVAL.INT097 is 'The parsed value for the 97th interval.'; comment on column MKTINPUTINTERVAL.INT098 is 'The parsed value for the 98th interval.'; comment on column MKTINPUTINTERVAL.INT099 is 'The parsed value for the 99th interval.'; comment on column MKTINPUTINTERVAL.INT100 is 'The parsed value for the 100th interval.'; comment on column MKTINPUTINTERVAL.LSTIME is 'The data record timestamp.'; -- Create table create table MKTINPUTSCALAR ( UIDMKTINPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UOMCODE VARCHAR2(64) not null, STRINGVALUE VARCHAR2(64), VALUE FLOAT, UIDMKTINPUTSCALAR NUMBER(19) not null, LSTIME DATE, CRRID VARCHAR2(12), CRROFFERID VARCHAR2(12) ); -- Create table comment COMMENT ON TABLE MKTINPUTSCALAR is ' Defined SCALAR table containing non- interval (i.e. daily or monthly) data used in the data aggregation and settlement processes; this includes data received from the MMS, EMS, and CRR systems. This is an approved settlements data set.'; comment on column MKTINPUTSCALAR.UIDMKTINPUTHEADER is 'The ERCOT settlement systems unique identifier for the MKTINTPUTHEADER data record.'; comment on column MKTINPUTSCALAR.STARTTIME is 'The starttime the data represents.'; comment on column MKTINPUTSCALAR.STOPTIME is 'The stoptime the data represents through.'; comment on column MKTINPUTSCALAR.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column MKTINPUTSCALAR.STRINGVALUE is 'Character value associated with the bill determinant.'; comment on column MKTINPUTSCALAR.VALUE is ' Numeric value associated with the bill determinant.'; comment on column MKTINPUTSCALAR.UIDMKTINPUTSCALAR is 'The ERCOT settlement systems unique identifier for the MKTINPUYSCALAR data record.'; comment on column MKTINPUTSCALAR.LSTIME is 'The data record timestamp.'; -- Create table create table MKTINPUTSTATUS ( UIDMKTINPUTINTERVAL NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, STATUS001 VARCHAR2(10), STATUS002 VARCHAR2(10), STATUS003 VARCHAR2(10), STATUS004 VARCHAR2(10), STATUS005 VARCHAR2(10), STATUS006 VARCHAR2(10), STATUS007 VARCHAR2(10), STATUS008 VARCHAR2(10), STATUS009 VARCHAR2(10), STATUS010 VARCHAR2(10), STATUS011 VARCHAR2(10), STATUS012 VARCHAR2(10), STATUS013 VARCHAR2(10), STATUS014 VARCHAR2(10), STATUS015 VARCHAR2(10), STATUS016 VARCHAR2(10), STATUS017 VARCHAR2(10), STATUS018 VARCHAR2(10), STATUS019 VARCHAR2(10), STATUS020 VARCHAR2(10), STATUS021 VARCHAR2(10), STATUS022 VARCHAR2(10), STATUS023 VARCHAR2(10), STATUS024 VARCHAR2(10), STATUS025 VARCHAR2(10), STATUS026 VARCHAR2(10), STATUS027 VARCHAR2(10), STATUS028 VARCHAR2(10), STATUS029 VARCHAR2(10), STATUS030 VARCHAR2(10), STATUS031 VARCHAR2(10), STATUS032 VARCHAR2(10), STATUS033 VARCHAR2(10), STATUS034 VARCHAR2(10), STATUS035 VARCHAR2(10), STATUS036 VARCHAR2(10), STATUS037 VARCHAR2(10), STATUS038 VARCHAR2(10), STATUS039 VARCHAR2(10), STATUS040 VARCHAR2(10), STATUS041 VARCHAR2(10), STATUS042 VARCHAR2(10), STATUS043 VARCHAR2(10), STATUS044 VARCHAR2(10), STATUS045 VARCHAR2(10), STATUS046 VARCHAR2(10), STATUS047 VARCHAR2(10), STATUS048 VARCHAR2(10), STATUS049 VARCHAR2(10), STATUS050 VARCHAR2(10), STATUS051 VARCHAR2(10), STATUS052 VARCHAR2(10), STATUS053 VARCHAR2(10), STATUS054 VARCHAR2(10), STATUS055 VARCHAR2(10), STATUS056 VARCHAR2(10), STATUS057 VARCHAR2(10), STATUS058 VARCHAR2(10), STATUS059 VARCHAR2(10), STATUS060 VARCHAR2(10), STATUS061 VARCHAR2(10), STATUS062 VARCHAR2(10), STATUS063 VARCHAR2(10), STATUS064 VARCHAR2(10), STATUS065 VARCHAR2(10), STATUS066 VARCHAR2(10), STATUS067 VARCHAR2(10), STATUS068 VARCHAR2(10), STATUS069 VARCHAR2(10), STATUS070 VARCHAR2(10), STATUS071 VARCHAR2(10), STATUS072 VARCHAR2(10), STATUS073 VARCHAR2(10), STATUS074 VARCHAR2(10), STATUS075 VARCHAR2(10), STATUS076 VARCHAR2(10), STATUS077 VARCHAR2(10), STATUS078 VARCHAR2(10), STATUS079 VARCHAR2(10), STATUS080 VARCHAR2(10), STATUS081 VARCHAR2(10), STATUS082 VARCHAR2(10), STATUS083 VARCHAR2(10), STATUS084 VARCHAR2(10), STATUS085 VARCHAR2(10), STATUS086 VARCHAR2(10), STATUS087 VARCHAR2(10), STATUS088 VARCHAR2(10), STATUS089 VARCHAR2(10), STATUS090 VARCHAR2(10), STATUS091 VARCHAR2(10), STATUS092 VARCHAR2(10), STATUS093 VARCHAR2(10), STATUS094 VARCHAR2(10), STATUS095 VARCHAR2(10), STATUS096 VARCHAR2(10), STATUS097 VARCHAR2(10), STATUS098 VARCHAR2(10), STATUS099 VARCHAR2(10), STATUS100 VARCHAR2(10) ); -- Create table comment COMMENT ON TABLE MKTINPUTSTATUS is ' Defined INTERVAL STATUS table contains the status of each interval provided in the INTERVAL table. STATUS = ''7'' is used to designate an interval where partial missing data was used in the calculation of the resulting value. STATUS = ''9'' is used to designate a NULL (missing) interval value. This is an approved settlements data set.'; comment on column MKTINPUTSTATUS.UIDMKTINPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the MKTINTPUTINTERVAL data record.'; comment on column MKTINPUTSTATUS.STARTTIME is 'The starttime the data represents.'; comment on column MKTINPUTSTATUS.STOPTIME is 'The stoptime the data represents through.'; comment on column MKTINPUTSTATUS.STATUS001 is 'The parsed value for the first status.'; comment on column MKTINPUTSTATUS.STATUS002 is 'The parsed value for the second status.'; comment on column MKTINPUTSTATUS.STATUS003 is 'The parsed value for the third status.'; comment on column MKTINPUTSTATUS.STATUS004 is 'The parsed value for the fourth status.'; comment on column MKTINPUTSTATUS.STATUS005 is 'The parsed value for the fifth status.'; comment on column MKTINPUTSTATUS.STATUS006 is 'The parsed value for the 6th status.'; comment on column MKTINPUTSTATUS.STATUS007 is 'The parsed value for the 7th status.'; comment on column MKTINPUTSTATUS.STATUS008 is 'The parsed value for the 8th status.'; comment on column MKTINPUTSTATUS.STATUS009 is 'The parsed value for the 9th status.'; comment on column MKTINPUTSTATUS.STATUS010 is 'The parsed value for the 10th status.'; comment on column MKTINPUTSTATUS.STATUS011 is 'The parsed value for the 11th status.'; comment on column MKTINPUTSTATUS.STATUS012 is 'The parsed value for the 12th status.'; comment on column MKTINPUTSTATUS.STATUS013 is 'The parsed value for the 13th status.'; comment on column MKTINPUTSTATUS.STATUS014 is 'The parsed value for the 14th status.'; comment on column MKTINPUTSTATUS.STATUS015 is 'The parsed value for the 15th status.'; comment on column MKTINPUTSTATUS.STATUS016 is 'The parsed value for the 16th status.'; comment on column MKTINPUTSTATUS.STATUS017 is 'The parsed value for the 17th status.'; comment on column MKTINPUTSTATUS.STATUS018 is 'The parsed value for the 18th status.'; comment on column MKTINPUTSTATUS.STATUS019 is 'The parsed value for the 19th status.'; comment on column MKTINPUTSTATUS.STATUS020 is 'The parsed value for the 20th status.'; comment on column MKTINPUTSTATUS.STATUS021 is 'The parsed value for the 21th status.'; comment on column MKTINPUTSTATUS.STATUS022 is 'The parsed value for the 22th status.'; comment on column MKTINPUTSTATUS.STATUS023 is 'The parsed value for the 23th status.'; comment on column MKTINPUTSTATUS.STATUS024 is 'The parsed value for the 24th status.'; comment on column MKTINPUTSTATUS.STATUS025 is 'The parsed value for the 25th status.'; comment on column MKTINPUTSTATUS.STATUS026 is 'The parsed value for the 26th status.'; comment on column MKTINPUTSTATUS.STATUS027 is 'The parsed value for the 27th status.'; comment on column MKTINPUTSTATUS.STATUS028 is 'The parsed value for the 28th status.'; comment on column MKTINPUTSTATUS.STATUS029 is 'The parsed value for the 29th status.'; comment on column MKTINPUTSTATUS.STATUS030 is 'The parsed value for the 30th status.'; comment on column MKTINPUTSTATUS.STATUS031 is 'The parsed value for the 31th status.'; comment on column MKTINPUTSTATUS.STATUS032 is 'The parsed value for the 32th status.'; comment on column MKTINPUTSTATUS.STATUS033 is 'The parsed value for the 33th status.'; comment on column MKTINPUTSTATUS.STATUS034 is 'The parsed value for the 34th status.'; comment on column MKTINPUTSTATUS.STATUS035 is 'The parsed value for the 35th status.'; comment on column MKTINPUTSTATUS.STATUS036 is 'The parsed value for the 36th status.'; comment on column MKTINPUTSTATUS.STATUS037 is 'The parsed value for the 37th status.'; comment on column MKTINPUTSTATUS.STATUS038 is 'The parsed value for the 38th status.'; comment on column MKTINPUTSTATUS.STATUS039 is 'The parsed value for the 39th status.'; comment on column MKTINPUTSTATUS.STATUS040 is 'The parsed value for the 40th status.'; comment on column MKTINPUTSTATUS.STATUS041 is 'The parsed value for the 41th status.'; comment on column MKTINPUTSTATUS.STATUS042 is 'The parsed value for the 42th status.'; comment on column MKTINPUTSTATUS.STATUS043 is 'The parsed value for the 43th status.'; comment on column MKTINPUTSTATUS.STATUS044 is 'The parsed value for the 44th status.'; comment on column MKTINPUTSTATUS.STATUS045 is 'The parsed value for the 45th status.'; comment on column MKTINPUTSTATUS.STATUS046 is 'The parsed value for the 46th status.'; comment on column MKTINPUTSTATUS.STATUS047 is 'The parsed value for the 47th status.'; comment on column MKTINPUTSTATUS.STATUS048 is 'The parsed value for the 48th status.'; comment on column MKTINPUTSTATUS.STATUS049 is 'The parsed value for the 49th status.'; comment on column MKTINPUTSTATUS.STATUS050 is 'The parsed value for the 50th status.'; comment on column MKTINPUTSTATUS.STATUS051 is 'The parsed value for the 51th status.'; comment on column MKTINPUTSTATUS.STATUS052 is 'The parsed value for the 52th status.'; comment on column MKTINPUTSTATUS.STATUS053 is 'The parsed value for the 53th status.'; comment on column MKTINPUTSTATUS.STATUS054 is 'The parsed value for the 54th status.'; comment on column MKTINPUTSTATUS.STATUS055 is 'The parsed value for the 55th status.'; comment on column MKTINPUTSTATUS.STATUS056 is 'The parsed value for the 56th status.'; comment on column MKTINPUTSTATUS.STATUS057 is 'The parsed value for the 57th status.'; comment on column MKTINPUTSTATUS.STATUS058 is 'The parsed value for the 58th status.'; comment on column MKTINPUTSTATUS.STATUS059 is 'The parsed value for the 59th status.'; comment on column MKTINPUTSTATUS.STATUS060 is 'The parsed value for the 60th status.'; comment on column MKTINPUTSTATUS.STATUS061 is 'The parsed value for the 61th status.'; comment on column MKTINPUTSTATUS.STATUS062 is 'The parsed value for the 62th status.'; comment on column MKTINPUTSTATUS.STATUS063 is 'The parsed value for the 63th status.'; comment on column MKTINPUTSTATUS.STATUS064 is 'The parsed value for the 64th status.'; comment on column MKTINPUTSTATUS.STATUS065 is 'The parsed value for the 65th status.'; comment on column MKTINPUTSTATUS.STATUS066 is 'The parsed value for the 66th status.'; comment on column MKTINPUTSTATUS.STATUS067 is 'The parsed value for the 67th status.'; comment on column MKTINPUTSTATUS.STATUS068 is 'The parsed value for the 68th status.'; comment on column MKTINPUTSTATUS.STATUS069 is 'The parsed value for the 69th status.'; comment on column MKTINPUTSTATUS.STATUS070 is 'The parsed value for the 70th status.'; comment on column MKTINPUTSTATUS.STATUS071 is 'The parsed value for the 71th status.'; comment on column MKTINPUTSTATUS.STATUS072 is 'The parsed value for the 72th status.'; comment on column MKTINPUTSTATUS.STATUS073 is 'The parsed value for the 73th status.'; comment on column MKTINPUTSTATUS.STATUS074 is 'The parsed value for the 74th status.'; comment on column MKTINPUTSTATUS.STATUS075 is 'The parsed value for the 75th status.'; comment on column MKTINPUTSTATUS.STATUS076 is 'The parsed value for the 76th status.'; comment on column MKTINPUTSTATUS.STATUS077 is 'The parsed value for the 77th status.'; comment on column MKTINPUTSTATUS.STATUS078 is 'The parsed value for the 78th status.'; comment on column MKTINPUTSTATUS.STATUS079 is 'The parsed value for the 79th status.'; comment on column MKTINPUTSTATUS.STATUS080 is 'The parsed value for the 80th status.'; comment on column MKTINPUTSTATUS.STATUS081 is 'The parsed value for the 81th status.'; comment on column MKTINPUTSTATUS.STATUS082 is 'The parsed value for the 82th status.'; comment on column MKTINPUTSTATUS.STATUS083 is 'The parsed value for the 83th status.'; comment on column MKTINPUTSTATUS.STATUS084 is 'The parsed value for the 84th status.'; comment on column MKTINPUTSTATUS.STATUS085 is 'The parsed value for the 85th status.'; comment on column MKTINPUTSTATUS.STATUS086 is 'The parsed value for the 86th status.'; comment on column MKTINPUTSTATUS.STATUS087 is 'The parsed value for the 87th status.'; comment on column MKTINPUTSTATUS.STATUS088 is 'The parsed value for the 88th status.'; comment on column MKTINPUTSTATUS.STATUS089 is 'The parsed value for the 89th status.'; comment on column MKTINPUTSTATUS.STATUS090 is 'The parsed value for the 90th status.'; comment on column MKTINPUTSTATUS.STATUS091 is 'The parsed value for the 91th status.'; comment on column MKTINPUTSTATUS.STATUS092 is 'The parsed value for the 92th status.'; comment on column MKTINPUTSTATUS.STATUS093 is 'The parsed value for the 93th status.'; comment on column MKTINPUTSTATUS.STATUS094 is 'The parsed value for the 94th status.'; comment on column MKTINPUTSTATUS.STATUS095 is 'The parsed value for the 95th status.'; comment on column MKTINPUTSTATUS.STATUS096 is 'The parsed value for the 96th status.'; comment on column MKTINPUTSTATUS.STATUS097 is 'The parsed value for the 97th status.'; comment on column MKTINPUTSTATUS.STATUS098 is 'The parsed value for the 98th status.'; comment on column MKTINPUTSTATUS.STATUS099 is 'The parsed value for the 99th status.'; comment on column MKTINPUTSTATUS.STATUS100 is 'The parsed value for the 100th status.'; -- Create table create table PREPROCESSHEADER ( UIDPREPROCHEADER NUMBER(19) not null, SAVERECORDER VARCHAR2(128) not null, SAVECHANNEL NUMBER(6) not null, UIDBILLDETERMINANT NUMBER(5) not null, QSECODE VARCHAR2(64), UIDSETLPOINT NUMBER(19), STARTTYPE NUMBER(10), RUCID NUMBER(3), UIDRESOURCE NUMBER(19), OFFERCURVEID NUMBER(10), LSTIME DATE ); -- Create table comment COMMENT ON TABLE PREPROCESSHEADER is 'Defined PARENT table containing business level attributes for the Eligibility decisions for RUC and AIEC processes, used for both DAM and RTM settlements. This is an approved settlements data set.'; comment on column PREPROCESSHEADER.UIDPREPROCHEADER is 'The ERCOT settlement systems unique identifier for the PREPROCHEADER data record.'; comment on column PREPROCESSHEADER.SAVERECORDER is 'The concatenated attributes of the PROPROCHEADER.'; comment on column PREPROCESSHEADER.SAVECHANNEL is 'ERCOT settlement systems number relational to the number of times an operating day is settled.'; comment on column PREPROCESSHEADER.UIDBILLDETERMINANT is 'The ERCOT settlement systems unique identifier for the BILLDETERMINANT data record.'; comment on column PREPROCESSHEADER.QSECODE is 'The ERCOT settlement systems code associated to a QSE.'; comment on column PREPROCESSHEADER.UIDSETLPOINT is 'The ERCOT settlement systems unique identifier for the SETTLEMENTPOINT data record.'; comment on column PREPROCESSHEADER.STARTTYPE is 'This field contains values for the categories by which startup costs are provided in a Three-Part Supply Offer.'; comment on column PREPROCESSHEADER.RUCID is 'The ERCOT identifier for the RUC process ID.'; comment on column PREPROCESSHEADER.UIDRESOURCE is 'The ERCOT settlement systems unique identifier for the RESOURCE data record.'; comment on column PREPROCESSHEADER.OFFERCURVEID is 'An ERCOT settlement systems identifier to indicate which point on the offer curve the record applies to.'; comment on column PREPROCESSHEADER.LSTIME is 'The data record timestamp.'; -- Create table create table PREPROCESSINTERVAL ( UIDPREPROCINTVAL NUMBER(19) not null, UIDPREPROCHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UIDSTATEMENTSCHED NUMBER(19) not null, CALCGROUP NUMBER(10) not null, SPI NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, DSTPARTICIPANT CHAR(1) not null, ORIGIN CHAR(1), CHNLCUTTIMESTAMP DATE, TZSTDNAME VARCHAR2(32), TOTAL FLOAT not null, MAXIMUM FLOAT not null, MINIMUM FLOAT not null, INTERVALCOUNT NUMBER(10) not null, INT001 NUMBER, INT002 NUMBER, INT003 NUMBER, INT004 NUMBER, INT005 NUMBER, INT006 NUMBER, INT007 NUMBER, INT008 NUMBER, INT009 NUMBER, INT010 NUMBER, INT011 NUMBER, INT012 NUMBER, INT013 NUMBER, INT014 NUMBER, INT015 NUMBER, INT016 NUMBER, INT017 NUMBER, INT018 NUMBER, INT019 NUMBER, INT020 NUMBER, INT021 NUMBER, INT022 NUMBER, INT023 NUMBER, INT024 NUMBER, INT025 NUMBER, INT026 NUMBER, INT027 NUMBER, INT028 NUMBER, INT029 NUMBER, INT030 NUMBER, INT031 NUMBER, INT032 NUMBER, INT033 NUMBER, INT034 NUMBER, INT035 NUMBER, INT036 NUMBER, INT037 NUMBER, INT038 NUMBER, INT039 NUMBER, INT040 NUMBER, INT041 NUMBER, INT042 NUMBER, INT043 NUMBER, INT044 NUMBER, INT045 NUMBER, INT046 NUMBER, INT047 NUMBER, INT048 NUMBER, INT049 NUMBER, INT050 NUMBER, INT051 NUMBER, INT052 NUMBER, INT053 NUMBER, INT054 NUMBER, INT055 NUMBER, INT056 NUMBER, INT057 NUMBER, INT058 NUMBER, INT059 NUMBER, INT060 NUMBER, INT061 NUMBER, INT062 NUMBER, INT063 NUMBER, INT064 NUMBER, INT065 NUMBER, INT066 NUMBER, INT067 NUMBER, INT068 NUMBER, INT069 NUMBER, INT070 NUMBER, INT071 NUMBER, INT072 NUMBER, INT073 NUMBER, INT074 NUMBER, INT075 NUMBER, INT076 NUMBER, INT077 NUMBER, INT078 NUMBER, INT079 NUMBER, INT080 NUMBER, INT081 NUMBER, INT082 NUMBER, INT083 NUMBER, INT084 NUMBER, INT085 NUMBER, INT086 NUMBER, INT087 NUMBER, INT088 NUMBER, INT089 NUMBER, INT090 NUMBER, INT091 NUMBER, INT092 NUMBER, INT093 NUMBER, INT094 NUMBER, INT095 NUMBER, INT096 NUMBER, INT097 NUMBER, INT098 NUMBER, INT099 NUMBER, INT100 NUMBER, LSTIME DATE ); -- Create table comment COMMENT ON TABLE PREPROCESSINTERVAL is 'Defined INTERVAL table containing both: the interval data and data level attributes for the Eligibility for RUC and AIEC processes, used for both DAM and RTM settlements. The ERCOT enhanced interval data table for settlement preprocessor data.'; comment on column PREPROCESSINTERVAL.UIDPREPROCINTVAL is 'The ERCOT settlement systems unique identifier for the PREPROCINTERVAL data record.'; comment on column PREPROCESSINTERVAL.UIDPREPROCHEADER is 'The ERCOT settlement systems unique identifier for the PREPROCHEADER data record.'; comment on column PREPROCESSINTERVAL.STARTTIME is 'The starttime the data represents.'; comment on column PREPROCESSINTERVAL.STOPTIME is 'The stoptime the data represents through.'; comment on column PREPROCESSINTERVAL.UIDSTATEMENTSCHED is 'The unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; comment on column PREPROCESSINTERVAL.CALCGROUP is 'The ERCOT settlement systems internal value used to tie related values to a specific business process calculation.'; comment on column PREPROCESSINTERVAL.SPI is 'Seconds per interval.'; comment on column PREPROCESSINTERVAL.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column PREPROCESSINTERVAL.DSTPARTICIPANT is 'The ERCOT identifier that indicates if a record is affected by DST.'; comment on column PREPROCESSINTERVAL.ORIGIN is 'C=Calculated.'; comment on column PREPROCESSINTERVAL.TOTAL is 'Total of all intervals in data record.'; comment on column PREPROCESSINTERVAL.MAXIMUM is 'Maximum interval value found within the data record.'; comment on column PREPROCESSINTERVAL.MINIMUM is 'Minimum interval value found within the data record.'; comment on column PREPROCESSINTERVAL.INTERVALCOUNT is 'Number of intervals found within the data record.'; comment on column PREPROCESSINTERVAL.INT001 is 'The parsed value for the first interval.'; comment on column PREPROCESSINTERVAL.INT002 is 'The parsed value for the second interval.'; comment on column PREPROCESSINTERVAL.INT003 is 'The parsed value for the third interval.'; comment on column PREPROCESSINTERVAL.INT004 is 'The parsed value for the fourth interval.'; comment on column PREPROCESSINTERVAL.INT005 is 'The parsed value for the fifth interval.'; comment on column PREPROCESSINTERVAL.INT006 is 'The parsed value for the 6th interval.'; comment on column PREPROCESSINTERVAL.INT007 is 'The parsed value for the 7th interval.'; comment on column PREPROCESSINTERVAL.INT008 is 'The parsed value for the 8th interval.'; comment on column PREPROCESSINTERVAL.INT009 is 'The parsed value for the 9th interval.'; comment on column PREPROCESSINTERVAL.INT010 is 'The parsed value for the 10th interval.'; comment on column PREPROCESSINTERVAL.INT011 is 'The parsed value for the 11th interval.'; comment on column PREPROCESSINTERVAL.INT012 is 'The parsed value for the 12th interval.'; comment on column PREPROCESSINTERVAL.INT013 is 'The parsed value for the 13th interval.'; comment on column PREPROCESSINTERVAL.INT014 is 'The parsed value for the 14th interval.'; comment on column PREPROCESSINTERVAL.INT015 is 'The parsed value for the 15th interval.'; comment on column PREPROCESSINTERVAL.INT016 is 'The parsed value for the 16th interval.'; comment on column PREPROCESSINTERVAL.INT017 is 'The parsed value for the 17th interval.'; comment on column PREPROCESSINTERVAL.INT018 is 'The parsed value for the 18th interval.'; comment on column PREPROCESSINTERVAL.INT019 is 'The parsed value for the 19th interval.'; comment on column PREPROCESSINTERVAL.INT020 is 'The parsed value for the 20th interval.'; comment on column PREPROCESSINTERVAL.INT021 is 'The parsed value for the 21th interval.'; comment on column PREPROCESSINTERVAL.INT022 is 'The parsed value for the 22th interval.'; comment on column PREPROCESSINTERVAL.INT023 is 'The parsed value for the 23th interval.'; comment on column PREPROCESSINTERVAL.INT024 is 'The parsed value for the 24th interval.'; comment on column PREPROCESSINTERVAL.INT025 is 'The parsed value for the 25th interval.'; comment on column PREPROCESSINTERVAL.INT026 is 'The parsed value for the 26th interval.'; comment on column PREPROCESSINTERVAL.INT027 is 'The parsed value for the 27th interval.'; comment on column PREPROCESSINTERVAL.INT028 is 'The parsed value for the 28th interval.'; comment on column PREPROCESSINTERVAL.INT029 is 'The parsed value for the 29th interval.'; comment on column PREPROCESSINTERVAL.INT030 is 'The parsed value for the 30th interval.'; comment on column PREPROCESSINTERVAL.INT031 is 'The parsed value for the 31th interval.'; comment on column PREPROCESSINTERVAL.INT032 is 'The parsed value for the 32th interval.'; comment on column PREPROCESSINTERVAL.INT033 is 'The parsed value for the 33th interval.'; comment on column PREPROCESSINTERVAL.INT034 is 'The parsed value for the 34th interval.'; comment on column PREPROCESSINTERVAL.INT035 is 'The parsed value for the 35th interval.'; comment on column PREPROCESSINTERVAL.INT036 is 'The parsed value for the 36th interval.'; comment on column PREPROCESSINTERVAL.INT037 is 'The parsed value for the 37th interval.'; comment on column PREPROCESSINTERVAL.INT038 is 'The parsed value for the 38th interval.'; comment on column PREPROCESSINTERVAL.INT039 is 'The parsed value for the 39th interval.'; comment on column PREPROCESSINTERVAL.INT040 is 'The parsed value for the 40th interval.'; comment on column PREPROCESSINTERVAL.INT041 is 'The parsed value for the 41th interval.'; comment on column PREPROCESSINTERVAL.INT042 is 'The parsed value for the 42th interval.'; comment on column PREPROCESSINTERVAL.INT043 is 'The parsed value for the 43th interval.'; comment on column PREPROCESSINTERVAL.INT044 is 'The parsed value for the 44th interval.'; comment on column PREPROCESSINTERVAL.INT045 is 'The parsed value for the 45th interval.'; comment on column PREPROCESSINTERVAL.INT046 is 'The parsed value for the 46th interval.'; comment on column PREPROCESSINTERVAL.INT047 is 'The parsed value for the 47th interval.'; comment on column PREPROCESSINTERVAL.INT048 is 'The parsed value for the 48th interval.'; comment on column PREPROCESSINTERVAL.INT049 is 'The parsed value for the 49th interval.'; comment on column PREPROCESSINTERVAL.INT050 is 'The parsed value for the 50th interval.'; comment on column PREPROCESSINTERVAL.INT051 is 'The parsed value for the 51th interval.'; comment on column PREPROCESSINTERVAL.INT052 is 'The parsed value for the 52th interval.'; comment on column PREPROCESSINTERVAL.INT053 is 'The parsed value for the 53th interval.'; comment on column PREPROCESSINTERVAL.INT054 is 'The parsed value for the 54th interval.'; comment on column PREPROCESSINTERVAL.INT055 is 'The parsed value for the 55th interval.'; comment on column PREPROCESSINTERVAL.INT056 is 'The parsed value for the 56th interval.'; comment on column PREPROCESSINTERVAL.INT057 is 'The parsed value for the 57th interval.'; comment on column PREPROCESSINTERVAL.INT058 is 'The parsed value for the 58th interval.'; comment on column PREPROCESSINTERVAL.INT059 is 'The parsed value for the 59th interval.'; comment on column PREPROCESSINTERVAL.INT060 is 'The parsed value for the 60th interval.'; comment on column PREPROCESSINTERVAL.INT061 is 'The parsed value for the 61th interval.'; comment on column PREPROCESSINTERVAL.INT062 is 'The parsed value for the 62th interval.'; comment on column PREPROCESSINTERVAL.INT063 is 'The parsed value for the 63th interval.'; comment on column PREPROCESSINTERVAL.INT064 is 'The parsed value for the 64th interval.'; comment on column PREPROCESSINTERVAL.INT065 is 'The parsed value for the 65th interval.'; comment on column PREPROCESSINTERVAL.INT066 is 'The parsed value for the 66th interval.'; comment on column PREPROCESSINTERVAL.INT067 is 'The parsed value for the 67th interval.'; comment on column PREPROCESSINTERVAL.INT068 is 'The parsed value for the 68th interval.'; comment on column PREPROCESSINTERVAL.INT069 is 'The parsed value for the 69th interval.'; comment on column PREPROCESSINTERVAL.INT070 is 'The parsed value for the 70th interval.'; comment on column PREPROCESSINTERVAL.INT071 is 'The parsed value for the 71th interval.'; comment on column PREPROCESSINTERVAL.INT072 is 'The parsed value for the 72th interval.'; comment on column PREPROCESSINTERVAL.INT073 is 'The parsed value for the 73th interval.'; comment on column PREPROCESSINTERVAL.INT074 is 'The parsed value for the 74th interval.'; comment on column PREPROCESSINTERVAL.INT075 is 'The parsed value for the 75th interval.'; comment on column PREPROCESSINTERVAL.INT076 is 'The parsed value for the 76th interval.'; comment on column PREPROCESSINTERVAL.INT077 is 'The parsed value for the 77th interval.'; comment on column PREPROCESSINTERVAL.INT078 is 'The parsed value for the 78th interval.'; comment on column PREPROCESSINTERVAL.INT079 is 'The parsed value for the 79th interval.'; comment on column PREPROCESSINTERVAL.INT080 is 'The parsed value for the 80th interval.'; comment on column PREPROCESSINTERVAL.INT081 is 'The parsed value for the 81th interval.'; comment on column PREPROCESSINTERVAL.INT082 is 'The parsed value for the 82th interval.'; comment on column PREPROCESSINTERVAL.INT083 is 'The parsed value for the 83th interval.'; comment on column PREPROCESSINTERVAL.INT084 is 'The parsed value for the 84th interval.'; comment on column PREPROCESSINTERVAL.INT085 is 'The parsed value for the 85th interval.'; comment on column PREPROCESSINTERVAL.INT086 is 'The parsed value for the 86th interval.'; comment on column PREPROCESSINTERVAL.INT087 is 'The parsed value for the 87th interval.'; comment on column PREPROCESSINTERVAL.INT088 is 'The parsed value for the 88th interval.'; comment on column PREPROCESSINTERVAL.INT089 is 'The parsed value for the 89th interval.'; comment on column PREPROCESSINTERVAL.INT090 is 'The parsed value for the 90th interval.'; comment on column PREPROCESSINTERVAL.INT091 is 'The parsed value for the 91th interval.'; comment on column PREPROCESSINTERVAL.INT092 is 'The parsed value for the 92th interval.'; comment on column PREPROCESSINTERVAL.INT093 is 'The parsed value for the 93th interval.'; comment on column PREPROCESSINTERVAL.INT094 is 'The parsed value for the 94th interval.'; comment on column PREPROCESSINTERVAL.INT095 is 'The parsed value for the 95th interval.'; comment on column PREPROCESSINTERVAL.INT096 is 'The parsed value for the 96th interval.'; comment on column PREPROCESSINTERVAL.INT097 is 'The parsed value for the 97th interval.'; comment on column PREPROCESSINTERVAL.INT098 is 'The parsed value for the 98th interval.'; comment on column PREPROCESSINTERVAL.INT099 is 'The parsed value for the 99th interval.'; comment on column PREPROCESSINTERVAL.INT100 is 'The parsed value for the 100th interval.'; comment on column PREPROCESSINTERVAL.LSTIME is 'The data record timestamp.'; -- Create table create table PREPROCESSSTATUS ( UIDPREPROCINTVAL NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, STATUS001 VARCHAR2(10), STATUS002 VARCHAR2(10), STATUS003 VARCHAR2(10), STATUS004 VARCHAR2(10), STATUS005 VARCHAR2(10), STATUS006 VARCHAR2(10), STATUS007 VARCHAR2(10), STATUS008 VARCHAR2(10), STATUS009 VARCHAR2(10), STATUS010 VARCHAR2(10), STATUS011 VARCHAR2(10), STATUS012 VARCHAR2(10), STATUS013 VARCHAR2(10), STATUS014 VARCHAR2(10), STATUS015 VARCHAR2(10), STATUS016 VARCHAR2(10), STATUS017 VARCHAR2(10), STATUS018 VARCHAR2(10), STATUS019 VARCHAR2(10), STATUS020 VARCHAR2(10), STATUS021 VARCHAR2(10), STATUS022 VARCHAR2(10), STATUS023 VARCHAR2(10), STATUS024 VARCHAR2(10), STATUS025 VARCHAR2(10), STATUS026 VARCHAR2(10), STATUS027 VARCHAR2(10), STATUS028 VARCHAR2(10), STATUS029 VARCHAR2(10), STATUS030 VARCHAR2(10), STATUS031 VARCHAR2(10), STATUS032 VARCHAR2(10), STATUS033 VARCHAR2(10), STATUS034 VARCHAR2(10), STATUS035 VARCHAR2(10), STATUS036 VARCHAR2(10), STATUS037 VARCHAR2(10), STATUS038 VARCHAR2(10), STATUS039 VARCHAR2(10), STATUS040 VARCHAR2(10), STATUS041 VARCHAR2(10), STATUS042 VARCHAR2(10), STATUS043 VARCHAR2(10), STATUS044 VARCHAR2(10), STATUS045 VARCHAR2(10), STATUS046 VARCHAR2(10), STATUS047 VARCHAR2(10), STATUS048 VARCHAR2(10), STATUS049 VARCHAR2(10), STATUS050 VARCHAR2(10), STATUS051 VARCHAR2(10), STATUS052 VARCHAR2(10), STATUS053 VARCHAR2(10), STATUS054 VARCHAR2(10), STATUS055 VARCHAR2(10), STATUS056 VARCHAR2(10), STATUS057 VARCHAR2(10), STATUS058 VARCHAR2(10), STATUS059 VARCHAR2(10), STATUS060 VARCHAR2(10), STATUS061 VARCHAR2(10), STATUS062 VARCHAR2(10), STATUS063 VARCHAR2(10), STATUS064 VARCHAR2(10), STATUS065 VARCHAR2(10), STATUS066 VARCHAR2(10), STATUS067 VARCHAR2(10), STATUS068 VARCHAR2(10), STATUS069 VARCHAR2(10), STATUS070 VARCHAR2(10), STATUS071 VARCHAR2(10), STATUS072 VARCHAR2(10), STATUS073 VARCHAR2(10), STATUS074 VARCHAR2(10), STATUS075 VARCHAR2(10), STATUS076 VARCHAR2(10), STATUS077 VARCHAR2(10), STATUS078 VARCHAR2(10), STATUS079 VARCHAR2(10), STATUS080 VARCHAR2(10), STATUS081 VARCHAR2(10), STATUS082 VARCHAR2(10), STATUS083 VARCHAR2(10), STATUS084 VARCHAR2(10), STATUS085 VARCHAR2(10), STATUS086 VARCHAR2(10), STATUS087 VARCHAR2(10), STATUS088 VARCHAR2(10), STATUS089 VARCHAR2(10), STATUS090 VARCHAR2(10), STATUS091 VARCHAR2(10), STATUS092 VARCHAR2(10), STATUS093 VARCHAR2(10), STATUS094 VARCHAR2(10), STATUS095 VARCHAR2(10), STATUS096 VARCHAR2(10), STATUS097 VARCHAR2(10), STATUS098 VARCHAR2(10), STATUS099 VARCHAR2(10), STATUS100 VARCHAR2(10) ); -- Create table comment COMMENT ON TABLE PREPROCESSSTATUS is ' Defined INTERVAL STATUS table contains the status of each interval provided in the INTERVAL table. STATUS = ''7'' is used to designate an interval where partial missing data was used in the calculation of the resulting value. STATUS = ''9'' is used to designate a NULL (missing) interval value. This is an approved settlements data set.'; comment on column PREPROCESSSTATUS.UIDPREPROCINTVAL is 'The ERCOT settlement systems unique identifier for the PREPROCINTERVAL data record.'; comment on column PREPROCESSSTATUS.STARTTIME is 'The starttime the data represents.'; comment on column PREPROCESSSTATUS.STOPTIME is 'The stoptime the data represents through.'; comment on column PREPROCESSSTATUS.STATUS001 is 'The parsed value for the first status.'; comment on column PREPROCESSSTATUS.STATUS002 is 'The parsed value for the second status.'; comment on column PREPROCESSSTATUS.STATUS003 is 'The parsed value for the third status.'; comment on column PREPROCESSSTATUS.STATUS004 is 'The parsed value for the fourth status.'; comment on column PREPROCESSSTATUS.STATUS005 is 'The parsed value for the fifth status.'; comment on column PREPROCESSSTATUS.STATUS006 is 'The parsed value for the 6th status.'; comment on column PREPROCESSSTATUS.STATUS007 is 'The parsed value for the 7th status.'; comment on column PREPROCESSSTATUS.STATUS008 is 'The parsed value for the 8th status.'; comment on column PREPROCESSSTATUS.STATUS009 is 'The parsed value for the 9th status.'; comment on column PREPROCESSSTATUS.STATUS010 is 'The parsed value for the 10th status.'; comment on column PREPROCESSSTATUS.STATUS011 is 'The parsed value for the 11th status.'; comment on column PREPROCESSSTATUS.STATUS012 is 'The parsed value for the 12th status.'; comment on column PREPROCESSSTATUS.STATUS013 is 'The parsed value for the 13th status.'; comment on column PREPROCESSSTATUS.STATUS014 is 'The parsed value for the 14th status.'; comment on column PREPROCESSSTATUS.STATUS015 is 'The parsed value for the 15th status.'; comment on column PREPROCESSSTATUS.STATUS016 is 'The parsed value for the 16th status.'; comment on column PREPROCESSSTATUS.STATUS017 is 'The parsed value for the 17th status.'; comment on column PREPROCESSSTATUS.STATUS018 is 'The parsed value for the 18th status.'; comment on column PREPROCESSSTATUS.STATUS019 is 'The parsed value for the 19th status.'; comment on column PREPROCESSSTATUS.STATUS020 is 'The parsed value for the 20th status.'; comment on column PREPROCESSSTATUS.STATUS021 is 'The parsed value for the 21th status.'; comment on column PREPROCESSSTATUS.STATUS022 is 'The parsed value for the 22th status.'; comment on column PREPROCESSSTATUS.STATUS023 is 'The parsed value for the 23th status.'; comment on column PREPROCESSSTATUS.STATUS024 is 'The parsed value for the 24th status.'; comment on column PREPROCESSSTATUS.STATUS025 is 'The parsed value for the 25th status.'; comment on column PREPROCESSSTATUS.STATUS026 is 'The parsed value for the 26th status.'; comment on column PREPROCESSSTATUS.STATUS027 is 'The parsed value for the 27th status.'; comment on column PREPROCESSSTATUS.STATUS028 is 'The parsed value for the 28th status.'; comment on column PREPROCESSSTATUS.STATUS029 is 'The parsed value for the 29th status.'; comment on column PREPROCESSSTATUS.STATUS030 is 'The parsed value for the 30th status.'; comment on column PREPROCESSSTATUS.STATUS031 is 'The parsed value for the 31th status.'; comment on column PREPROCESSSTATUS.STATUS032 is 'The parsed value for the 32th status.'; comment on column PREPROCESSSTATUS.STATUS033 is 'The parsed value for the 33th status.'; comment on column PREPROCESSSTATUS.STATUS034 is 'The parsed value for the 34th status.'; comment on column PREPROCESSSTATUS.STATUS035 is 'The parsed value for the 35th status.'; comment on column PREPROCESSSTATUS.STATUS036 is 'The parsed value for the 36th status.'; comment on column PREPROCESSSTATUS.STATUS037 is 'The parsed value for the 37th status.'; comment on column PREPROCESSSTATUS.STATUS038 is 'The parsed value for the 38th status.'; comment on column PREPROCESSSTATUS.STATUS039 is 'The parsed value for the 39th status.'; comment on column PREPROCESSSTATUS.STATUS040 is 'The parsed value for the 40th status.'; comment on column PREPROCESSSTATUS.STATUS041 is 'The parsed value for the 41th status.'; comment on column PREPROCESSSTATUS.STATUS042 is 'The parsed value for the 42th status.'; comment on column PREPROCESSSTATUS.STATUS043 is 'The parsed value for the 43th status.'; comment on column PREPROCESSSTATUS.STATUS044 is 'The parsed value for the 44th status.'; comment on column PREPROCESSSTATUS.STATUS045 is 'The parsed value for the 45th status.'; comment on column PREPROCESSSTATUS.STATUS046 is 'The parsed value for the 46th status.'; comment on column PREPROCESSSTATUS.STATUS047 is 'The parsed value for the 47th status.'; comment on column PREPROCESSSTATUS.STATUS048 is 'The parsed value for the 48th status.'; comment on column PREPROCESSSTATUS.STATUS049 is 'The parsed value for the 49th status.'; comment on column PREPROCESSSTATUS.STATUS050 is 'The parsed value for the 50th status.'; comment on column PREPROCESSSTATUS.STATUS051 is 'The parsed value for the 51th status.'; comment on column PREPROCESSSTATUS.STATUS052 is 'The parsed value for the 52th status.'; comment on column PREPROCESSSTATUS.STATUS053 is 'The parsed value for the 53th status.'; comment on column PREPROCESSSTATUS.STATUS054 is 'The parsed value for the 54th status.'; comment on column PREPROCESSSTATUS.STATUS055 is 'The parsed value for the 55th status.'; comment on column PREPROCESSSTATUS.STATUS056 is 'The parsed value for the 56th status.'; comment on column PREPROCESSSTATUS.STATUS057 is 'The parsed value for the 57th status.'; comment on column PREPROCESSSTATUS.STATUS058 is 'The parsed value for the 58th status.'; comment on column PREPROCESSSTATUS.STATUS059 is 'The parsed value for the 59th status.'; comment on column PREPROCESSSTATUS.STATUS060 is 'The parsed value for the 60th status.'; comment on column PREPROCESSSTATUS.STATUS061 is 'The parsed value for the 61th status.'; comment on column PREPROCESSSTATUS.STATUS062 is 'The parsed value for the 62th status.'; comment on column PREPROCESSSTATUS.STATUS063 is 'The parsed value for the 63th status.'; comment on column PREPROCESSSTATUS.STATUS064 is 'The parsed value for the 64th status.'; comment on column PREPROCESSSTATUS.STATUS065 is 'The parsed value for the 65th status.'; comment on column PREPROCESSSTATUS.STATUS066 is 'The parsed value for the 66th status.'; comment on column PREPROCESSSTATUS.STATUS067 is 'The parsed value for the 67th status.'; comment on column PREPROCESSSTATUS.STATUS068 is 'The parsed value for the 68th status.'; comment on column PREPROCESSSTATUS.STATUS069 is 'The parsed value for the 69th status.'; comment on column PREPROCESSSTATUS.STATUS070 is 'The parsed value for the 70th status.'; comment on column PREPROCESSSTATUS.STATUS071 is 'The parsed value for the 71th status.'; comment on column PREPROCESSSTATUS.STATUS072 is 'The parsed value for the 72th status.'; comment on column PREPROCESSSTATUS.STATUS073 is 'The parsed value for the 73th status.'; comment on column PREPROCESSSTATUS.STATUS074 is 'The parsed value for the 74th status.'; comment on column PREPROCESSSTATUS.STATUS075 is 'The parsed value for the 75th status.'; comment on column PREPROCESSSTATUS.STATUS076 is 'The parsed value for the 76th status.'; comment on column PREPROCESSSTATUS.STATUS077 is 'The parsed value for the 77th status.'; comment on column PREPROCESSSTATUS.STATUS078 is 'The parsed value for the 78th status.'; comment on column PREPROCESSSTATUS.STATUS079 is 'The parsed value for the 79th status.'; comment on column PREPROCESSSTATUS.STATUS080 is 'The parsed value for the 80th status.'; comment on column PREPROCESSSTATUS.STATUS081 is 'The parsed value for the 81th status.'; comment on column PREPROCESSSTATUS.STATUS082 is 'The parsed value for the 82th status.'; comment on column PREPROCESSSTATUS.STATUS083 is 'The parsed value for the 83th status.'; comment on column PREPROCESSSTATUS.STATUS084 is 'The parsed value for the 84th status.'; comment on column PREPROCESSSTATUS.STATUS085 is 'The parsed value for the 85th status.'; comment on column PREPROCESSSTATUS.STATUS086 is 'The parsed value for the 86th status.'; comment on column PREPROCESSSTATUS.STATUS087 is 'The parsed value for the 87th status.'; comment on column PREPROCESSSTATUS.STATUS088 is 'The parsed value for the 88th status.'; comment on column PREPROCESSSTATUS.STATUS089 is 'The parsed value for the 89th status.'; comment on column PREPROCESSSTATUS.STATUS090 is 'The parsed value for the 90th status.'; comment on column PREPROCESSSTATUS.STATUS091 is 'The parsed value for the 91th status.'; comment on column PREPROCESSSTATUS.STATUS092 is 'The parsed value for the 92th status.'; comment on column PREPROCESSSTATUS.STATUS093 is 'The parsed value for the 93th status.'; comment on column PREPROCESSSTATUS.STATUS094 is 'The parsed value for the 94th status.'; comment on column PREPROCESSSTATUS.STATUS095 is 'The parsed value for the 95th status.'; comment on column PREPROCESSSTATUS.STATUS096 is 'The parsed value for the 96th status.'; comment on column PREPROCESSSTATUS.STATUS097 is 'The parsed value for the 97th status.'; comment on column PREPROCESSSTATUS.STATUS098 is 'The parsed value for the 98th status.'; comment on column PREPROCESSSTATUS.STATUS099 is 'The parsed value for the 99th status.'; comment on column PREPROCESSSTATUS.STATUS100 is 'The parsed value for the 100th status.'; -- Create table CREATE TABLE RTMOUTPUTHEADER ( UIDRTMOUTPUTHEADER NUMBER(19) NOT NULL, SAVERECORDER VARCHAR2(128) NOT NULL, SAVECHANNEL NUMBER(6) NOT NULL, UIDBILLDETERMINANT NUMBER(5) NOT NULL, QSECODE VARCHAR2(64), UIDSETLPOINT NUMBER(19), UIDSOURCESETLPOINT NUMBER(19), UIDSINKSETLPOINT NUMBER(19), UIDASMARKET NUMBER(19), UIDRESOURCE NUMBER(19), LSTIME DATE ); -- Create table comment COMMENT ON TABLE RTMOUTPUTHEADER is 'Defined PARENT table containing business level attributes for the calculated results for RTM settlements (excluding CRR and RUC settlement.) This is an approved settlements data set.'; comment on column RTMOUTPUTHEADER.UIDRTMOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the RTMOUTPUTHEADER data record.'; comment on column RTMOUTPUTHEADER.SAVERECORDER is 'The concatenated attributes of the RTMOUTPUTHEADER.'; comment on column RTMOUTPUTHEADER.SAVECHANNEL is 'ERCOT settlement systems number relational to the number of times an operating day is settled.'; comment on column RTMOUTPUTHEADER.UIDBILLDETERMINANT is 'The ERCOT settlement systems unique identifier for the BILLDETERMINANT data record.'; comment on column RTMOUTPUTHEADER.QSECODE is 'The ERCOT settlement systems code associated to a QSE.'; comment on column RTMOUTPUTHEADER.UIDSETLPOINT is 'The ERCOT settlement systems unique identifier for the SETTLEMENTPOINT data record.'; comment on column RTMOUTPUTHEADER.UIDSOURCESETLPOINT is 'The ERCOT settlement systems unique identifier for the SOURCESETLPOINT data record.'; comment on column RTMOUTPUTHEADER.UIDSINKSETLPOINT is 'The ERCOT settlement systems unique identifier for the SINKSETLPOINT data record.'; comment on column RTMOUTPUTHEADER.UIDASMARKET is 'The ERCOT settlement systems unique identifier for the ASMARKET data record.'; comment on column RTMOUTPUTHEADER.UIDRESOURCE is 'The ERCOT settlement systems unique identifier for the RESOURCE data record.'; comment on column RTMOUTPUTHEADER.LSTIME is 'The data record timestamp.'; -- Create table create table RTMOUTPUTINTERVAL ( UIDRTMOUTPUTINTERVAL NUMBER(19) not null, UIDRTMOUTPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UIDSTATEMENTSCHED NUMBER(19) not null, CALCGROUP NUMBER(10) not null, SPI NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, DSTPARTICIPANT CHAR(1) not null, ORIGIN CHAR(1), CHNLCUTTIMESTAMP DATE, TZSTDNAME VARCHAR2(32), TOTAL FLOAT not null, MAXIMUM FLOAT not null, MINIMUM FLOAT not null, INTERVALCOUNT NUMBER(10) not null, INT001 NUMBER, INT002 NUMBER, INT003 NUMBER, INT004 NUMBER, INT005 NUMBER, INT006 NUMBER, INT007 NUMBER, INT008 NUMBER, INT009 NUMBER, INT010 NUMBER, INT011 NUMBER, INT012 NUMBER, INT013 NUMBER, INT014 NUMBER, INT015 NUMBER, INT016 NUMBER, INT017 NUMBER, INT018 NUMBER, INT019 NUMBER, INT020 NUMBER, INT021 NUMBER, INT022 NUMBER, INT023 NUMBER, INT024 NUMBER, INT025 NUMBER, INT026 NUMBER, INT027 NUMBER, INT028 NUMBER, INT029 NUMBER, INT030 NUMBER, INT031 NUMBER, INT032 NUMBER, INT033 NUMBER, INT034 NUMBER, INT035 NUMBER, INT036 NUMBER, INT037 NUMBER, INT038 NUMBER, INT039 NUMBER, INT040 NUMBER, INT041 NUMBER, INT042 NUMBER, INT043 NUMBER, INT044 NUMBER, INT045 NUMBER, INT046 NUMBER, INT047 NUMBER, INT048 NUMBER, INT049 NUMBER, INT050 NUMBER, INT051 NUMBER, INT052 NUMBER, INT053 NUMBER, INT054 NUMBER, INT055 NUMBER, INT056 NUMBER, INT057 NUMBER, INT058 NUMBER, INT059 NUMBER, INT060 NUMBER, INT061 NUMBER, INT062 NUMBER, INT063 NUMBER, INT064 NUMBER, INT065 NUMBER, INT066 NUMBER, INT067 NUMBER, INT068 NUMBER, INT069 NUMBER, INT070 NUMBER, INT071 NUMBER, INT072 NUMBER, INT073 NUMBER, INT074 NUMBER, INT075 NUMBER, INT076 NUMBER, INT077 NUMBER, INT078 NUMBER, INT079 NUMBER, INT080 NUMBER, INT081 NUMBER, INT082 NUMBER, INT083 NUMBER, INT084 NUMBER, INT085 NUMBER, INT086 NUMBER, INT087 NUMBER, INT088 NUMBER, INT089 NUMBER, INT090 NUMBER, INT091 NUMBER, INT092 NUMBER, INT093 NUMBER, INT094 NUMBER, INT095 NUMBER, INT096 NUMBER, INT097 NUMBER, INT098 NUMBER, INT099 NUMBER, INT100 NUMBER, LSTIME DATE ); -- Create table comment COMMENT ON TABLE RTMOUTPUTINTERVAL is 'Defined INTERVAL table containing both: the interval data and data level attributes; for the calculated results for RTM settlements (excluding CRR and RUC settlement.) This is an approved settlements data set. '; comment on column RTMOUTPUTINTERVAL.UIDRTMOUTPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the RTMOUTPUTINTERVAL data record.'; comment on column RTMOUTPUTINTERVAL.UIDRTMOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the RTMOUTPUTHEADER data record.'; comment on column RTMOUTPUTINTERVAL.STARTTIME is 'The starttime the data represents.'; comment on column RTMOUTPUTINTERVAL.STOPTIME is 'The stoptime the data represents through.'; comment on column RTMOUTPUTINTERVAL.UIDSTATEMENTSCHED is 'The unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; comment on column RTMOUTPUTINTERVAL.CALCGROUP is 'The ERCOT settlement systems internal value used to tie related values to a specific business process calculation.'; comment on column RTMOUTPUTINTERVAL.SPI is 'Seconds per interval.'; comment on column RTMOUTPUTINTERVAL.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column RTMOUTPUTINTERVAL.DSTPARTICIPANT is 'The ERCOT identifier that indicates if a record is affected by DST.'; comment on column RTMOUTPUTINTERVAL.ORIGIN is 'C=Calculated.'; comment on column RTMOUTPUTINTERVAL.TOTAL is 'Total of all intervals in data record.'; comment on column RTMOUTPUTINTERVAL.MAXIMUM is 'Maximum interval value found within the data record.'; comment on column RTMOUTPUTINTERVAL.MINIMUM is 'Minimum interval value found within the data record.'; comment on column RTMOUTPUTINTERVAL.INTERVALCOUNT is 'Number of intervals found within the data record.'; comment on column RTMOUTPUTINTERVAL.INT001 is 'The parsed value for the first interval.'; comment on column RTMOUTPUTINTERVAL.INT002 is 'The parsed value for the second interval.'; comment on column RTMOUTPUTINTERVAL.INT003 is 'The parsed value for the third interval.'; comment on column RTMOUTPUTINTERVAL.INT004 is 'The parsed value for the fourth interval.'; comment on column RTMOUTPUTINTERVAL.INT005 is 'The parsed value for the fifth interval.'; comment on column RTMOUTPUTINTERVAL.INT006 is 'The parsed value for the 6th interval.'; comment on column RTMOUTPUTINTERVAL.INT007 is 'The parsed value for the 7th interval.'; comment on column RTMOUTPUTINTERVAL.INT008 is 'The parsed value for the 8th interval.'; comment on column RTMOUTPUTINTERVAL.INT009 is 'The parsed value for the 9th interval.'; comment on column RTMOUTPUTINTERVAL.INT010 is 'The parsed value for the 10th interval.'; comment on column RTMOUTPUTINTERVAL.INT011 is 'The parsed value for the 11th interval.'; comment on column RTMOUTPUTINTERVAL.INT012 is 'The parsed value for the 12th interval.'; comment on column RTMOUTPUTINTERVAL.INT013 is 'The parsed value for the 13th interval.'; comment on column RTMOUTPUTINTERVAL.INT014 is 'The parsed value for the 14th interval.'; comment on column RTMOUTPUTINTERVAL.INT015 is 'The parsed value for the 15th interval.'; comment on column RTMOUTPUTINTERVAL.INT016 is 'The parsed value for the 16th interval.'; comment on column RTMOUTPUTINTERVAL.INT017 is 'The parsed value for the 17th interval.'; comment on column RTMOUTPUTINTERVAL.INT018 is 'The parsed value for the 18th interval.'; comment on column RTMOUTPUTINTERVAL.INT019 is 'The parsed value for the 19th interval.'; comment on column RTMOUTPUTINTERVAL.INT020 is 'The parsed value for the 20th interval.'; comment on column RTMOUTPUTINTERVAL.INT021 is 'The parsed value for the 21th interval.'; comment on column RTMOUTPUTINTERVAL.INT022 is 'The parsed value for the 22th interval.'; comment on column RTMOUTPUTINTERVAL.INT023 is 'The parsed value for the 23th interval.'; comment on column RTMOUTPUTINTERVAL.INT024 is 'The parsed value for the 24th interval.'; comment on column RTMOUTPUTINTERVAL.INT025 is 'The parsed value for the 25th interval.'; comment on column RTMOUTPUTINTERVAL.INT026 is 'The parsed value for the 26th interval.'; comment on column RTMOUTPUTINTERVAL.INT027 is 'The parsed value for the 27th interval.'; comment on column RTMOUTPUTINTERVAL.INT028 is 'The parsed value for the 28th interval.'; comment on column RTMOUTPUTINTERVAL.INT029 is 'The parsed value for the 29th interval.'; comment on column RTMOUTPUTINTERVAL.INT030 is 'The parsed value for the 30th interval.'; comment on column RTMOUTPUTINTERVAL.INT031 is 'The parsed value for the 31th interval.'; comment on column RTMOUTPUTINTERVAL.INT032 is 'The parsed value for the 32th interval.'; comment on column RTMOUTPUTINTERVAL.INT033 is 'The parsed value for the 33th interval.'; comment on column RTMOUTPUTINTERVAL.INT034 is 'The parsed value for the 34th interval.'; comment on column RTMOUTPUTINTERVAL.INT035 is 'The parsed value for the 35th interval.'; comment on column RTMOUTPUTINTERVAL.INT036 is 'The parsed value for the 36th interval.'; comment on column RTMOUTPUTINTERVAL.INT037 is 'The parsed value for the 37th interval.'; comment on column RTMOUTPUTINTERVAL.INT038 is 'The parsed value for the 38th interval.'; comment on column RTMOUTPUTINTERVAL.INT039 is 'The parsed value for the 39th interval.'; comment on column RTMOUTPUTINTERVAL.INT040 is 'The parsed value for the 40th interval.'; comment on column RTMOUTPUTINTERVAL.INT041 is 'The parsed value for the 41th interval.'; comment on column RTMOUTPUTINTERVAL.INT042 is 'The parsed value for the 42th interval.'; comment on column RTMOUTPUTINTERVAL.INT043 is 'The parsed value for the 43th interval.'; comment on column RTMOUTPUTINTERVAL.INT044 is 'The parsed value for the 44th interval.'; comment on column RTMOUTPUTINTERVAL.INT045 is 'The parsed value for the 45th interval.'; comment on column RTMOUTPUTINTERVAL.INT046 is 'The parsed value for the 46th interval.'; comment on column RTMOUTPUTINTERVAL.INT047 is 'The parsed value for the 47th interval.'; comment on column RTMOUTPUTINTERVAL.INT048 is 'The parsed value for the 48th interval.'; comment on column RTMOUTPUTINTERVAL.INT049 is 'The parsed value for the 49th interval.'; comment on column RTMOUTPUTINTERVAL.INT050 is 'The parsed value for the 50th interval.'; comment on column RTMOUTPUTINTERVAL.INT051 is 'The parsed value for the 51th interval.'; comment on column RTMOUTPUTINTERVAL.INT052 is 'The parsed value for the 52th interval.'; comment on column RTMOUTPUTINTERVAL.INT053 is 'The parsed value for the 53th interval.'; comment on column RTMOUTPUTINTERVAL.INT054 is 'The parsed value for the 54th interval.'; comment on column RTMOUTPUTINTERVAL.INT055 is 'The parsed value for the 55th interval.'; comment on column RTMOUTPUTINTERVAL.INT056 is 'The parsed value for the 56th interval.'; comment on column RTMOUTPUTINTERVAL.INT057 is 'The parsed value for the 57th interval.'; comment on column RTMOUTPUTINTERVAL.INT058 is 'The parsed value for the 58th interval.'; comment on column RTMOUTPUTINTERVAL.INT059 is 'The parsed value for the 59th interval.'; comment on column RTMOUTPUTINTERVAL.INT060 is 'The parsed value for the 60th interval.'; comment on column RTMOUTPUTINTERVAL.INT061 is 'The parsed value for the 61th interval.'; comment on column RTMOUTPUTINTERVAL.INT062 is 'The parsed value for the 62th interval.'; comment on column RTMOUTPUTINTERVAL.INT063 is 'The parsed value for the 63th interval.'; comment on column RTMOUTPUTINTERVAL.INT064 is 'The parsed value for the 64th interval.'; comment on column RTMOUTPUTINTERVAL.INT065 is 'The parsed value for the 65th interval.'; comment on column RTMOUTPUTINTERVAL.INT066 is 'The parsed value for the 66th interval.'; comment on column RTMOUTPUTINTERVAL.INT067 is 'The parsed value for the 67th interval.'; comment on column RTMOUTPUTINTERVAL.INT068 is 'The parsed value for the 68th interval.'; comment on column RTMOUTPUTINTERVAL.INT069 is 'The parsed value for the 69th interval.'; comment on column RTMOUTPUTINTERVAL.INT070 is 'The parsed value for the 70th interval.'; comment on column RTMOUTPUTINTERVAL.INT071 is 'The parsed value for the 71th interval.'; comment on column RTMOUTPUTINTERVAL.INT072 is 'The parsed value for the 72th interval.'; comment on column RTMOUTPUTINTERVAL.INT073 is 'The parsed value for the 73th interval.'; comment on column RTMOUTPUTINTERVAL.INT074 is 'The parsed value for the 74th interval.'; comment on column RTMOUTPUTINTERVAL.INT075 is 'The parsed value for the 75th interval.'; comment on column RTMOUTPUTINTERVAL.INT076 is 'The parsed value for the 76th interval.'; comment on column RTMOUTPUTINTERVAL.INT077 is 'The parsed value for the 77th interval.'; comment on column RTMOUTPUTINTERVAL.INT078 is 'The parsed value for the 78th interval.'; comment on column RTMOUTPUTINTERVAL.INT079 is 'The parsed value for the 79th interval.'; comment on column RTMOUTPUTINTERVAL.INT080 is 'The parsed value for the 80th interval.'; comment on column RTMOUTPUTINTERVAL.INT081 is 'The parsed value for the 81th interval.'; comment on column RTMOUTPUTINTERVAL.INT082 is 'The parsed value for the 82th interval.'; comment on column RTMOUTPUTINTERVAL.INT083 is 'The parsed value for the 83th interval.'; comment on column RTMOUTPUTINTERVAL.INT084 is 'The parsed value for the 84th interval.'; comment on column RTMOUTPUTINTERVAL.INT085 is 'The parsed value for the 85th interval.'; comment on column RTMOUTPUTINTERVAL.INT086 is 'The parsed value for the 86th interval.'; comment on column RTMOUTPUTINTERVAL.INT087 is 'The parsed value for the 87th interval.'; comment on column RTMOUTPUTINTERVAL.INT088 is 'The parsed value for the 88th interval.'; comment on column RTMOUTPUTINTERVAL.INT089 is 'The parsed value for the 89th interval.'; comment on column RTMOUTPUTINTERVAL.INT090 is 'The parsed value for the 90th interval.'; comment on column RTMOUTPUTINTERVAL.INT091 is 'The parsed value for the 91th interval.'; comment on column RTMOUTPUTINTERVAL.INT092 is 'The parsed value for the 92th interval.'; comment on column RTMOUTPUTINTERVAL.INT093 is 'The parsed value for the 93th interval.'; comment on column RTMOUTPUTINTERVAL.INT094 is 'The parsed value for the 94th interval.'; comment on column RTMOUTPUTINTERVAL.INT095 is 'The parsed value for the 95th interval.'; comment on column RTMOUTPUTINTERVAL.INT096 is 'The parsed value for the 96th interval.'; comment on column RTMOUTPUTINTERVAL.INT097 is 'The parsed value for the 97th interval.'; comment on column RTMOUTPUTINTERVAL.INT098 is 'The parsed value for the 98th interval.'; comment on column RTMOUTPUTINTERVAL.INT099 is 'The parsed value for the 99th interval.'; comment on column RTMOUTPUTINTERVAL.INT100 is 'The parsed value for the 100th interval.'; comment on column RTMOUTPUTINTERVAL.LSTIME is 'The data record timestamp.'; -- Create table create table RTMOUTPUTSCALAR ( UIDRTMOUTPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UIDSTATEMENTSCHED NUMBER(19) not null, CALCGROUP NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, STRINGVALUE VARCHAR2(64), VALUE FLOAT, UIDRTMOUTPUTSCALAR NUMBER(19) not null, LSTIME DATE ); -- Create table comment COMMENT ON TABLE RTMOUTPUTSCALAR is 'Defined SCALAR table containing non- interval (i.e. daily or monthly) data for the calculated results for RTM settlements (excluding CRR and RUC settlement.) This is an approved settlements data set.'; comment on column RTMOUTPUTSCALAR.UIDRTMOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the RTMOUTPUTHEADER data record.'; comment on column RTMOUTPUTSCALAR.STARTTIME is 'The starttime the data represents.'; comment on column RTMOUTPUTSCALAR.STOPTIME is 'The stoptime the data represents through.'; comment on column RTMOUTPUTSCALAR.UIDSTATEMENTSCHED is 'The unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; comment on column RTMOUTPUTSCALAR.CALCGROUP is 'The ERCOT settlement systems internal value used to tie related values to a specific business process calculation.'; comment on column RTMOUTPUTSCALAR.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column RTMOUTPUTSCALAR.STRINGVALUE is 'Character value associated with the bill determinant.'; comment on column RTMOUTPUTSCALAR.VALUE is 'Numeric value associated with the bill determinant.'; comment on column RTMOUTPUTSCALAR.UIDRTMOUTPUTSCALAR is 'The ERCOT settlement systems unique identifier for the RTMOUTPUTSCALAR data record.'; comment on column RTMOUTPUTSCALAR.LSTIME is 'The data record timestamp.'; -- Create table create table RTMOUTPUTSTATUS ( UIDRTMOUTPUTINTERVAL NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, STATUS001 VARCHAR2(10), STATUS002 VARCHAR2(10), STATUS003 VARCHAR2(10), STATUS004 VARCHAR2(10), STATUS005 VARCHAR2(10), STATUS006 VARCHAR2(10), STATUS007 VARCHAR2(10), STATUS008 VARCHAR2(10), STATUS009 VARCHAR2(10), STATUS010 VARCHAR2(10), STATUS011 VARCHAR2(10), STATUS012 VARCHAR2(10), STATUS013 VARCHAR2(10), STATUS014 VARCHAR2(10), STATUS015 VARCHAR2(10), STATUS016 VARCHAR2(10), STATUS017 VARCHAR2(10), STATUS018 VARCHAR2(10), STATUS019 VARCHAR2(10), STATUS020 VARCHAR2(10), STATUS021 VARCHAR2(10), STATUS022 VARCHAR2(10), STATUS023 VARCHAR2(10), STATUS024 VARCHAR2(10), STATUS025 VARCHAR2(10), STATUS026 VARCHAR2(10), STATUS027 VARCHAR2(10), STATUS028 VARCHAR2(10), STATUS029 VARCHAR2(10), STATUS030 VARCHAR2(10), STATUS031 VARCHAR2(10), STATUS032 VARCHAR2(10), STATUS033 VARCHAR2(10), STATUS034 VARCHAR2(10), STATUS035 VARCHAR2(10), STATUS036 VARCHAR2(10), STATUS037 VARCHAR2(10), STATUS038 VARCHAR2(10), STATUS039 VARCHAR2(10), STATUS040 VARCHAR2(10), STATUS041 VARCHAR2(10), STATUS042 VARCHAR2(10), STATUS043 VARCHAR2(10), STATUS044 VARCHAR2(10), STATUS045 VARCHAR2(10), STATUS046 VARCHAR2(10), STATUS047 VARCHAR2(10), STATUS048 VARCHAR2(10), STATUS049 VARCHAR2(10), STATUS050 VARCHAR2(10), STATUS051 VARCHAR2(10), STATUS052 VARCHAR2(10), STATUS053 VARCHAR2(10), STATUS054 VARCHAR2(10), STATUS055 VARCHAR2(10), STATUS056 VARCHAR2(10), STATUS057 VARCHAR2(10), STATUS058 VARCHAR2(10), STATUS059 VARCHAR2(10), STATUS060 VARCHAR2(10), STATUS061 VARCHAR2(10), STATUS062 VARCHAR2(10), STATUS063 VARCHAR2(10), STATUS064 VARCHAR2(10), STATUS065 VARCHAR2(10), STATUS066 VARCHAR2(10), STATUS067 VARCHAR2(10), STATUS068 VARCHAR2(10), STATUS069 VARCHAR2(10), STATUS070 VARCHAR2(10), STATUS071 VARCHAR2(10), STATUS072 VARCHAR2(10), STATUS073 VARCHAR2(10), STATUS074 VARCHAR2(10), STATUS075 VARCHAR2(10), STATUS076 VARCHAR2(10), STATUS077 VARCHAR2(10), STATUS078 VARCHAR2(10), STATUS079 VARCHAR2(10), STATUS080 VARCHAR2(10), STATUS081 VARCHAR2(10), STATUS082 VARCHAR2(10), STATUS083 VARCHAR2(10), STATUS084 VARCHAR2(10), STATUS085 VARCHAR2(10), STATUS086 VARCHAR2(10), STATUS087 VARCHAR2(10), STATUS088 VARCHAR2(10), STATUS089 VARCHAR2(10), STATUS090 VARCHAR2(10), STATUS091 VARCHAR2(10), STATUS092 VARCHAR2(10), STATUS093 VARCHAR2(10), STATUS094 VARCHAR2(10), STATUS095 VARCHAR2(10), STATUS096 VARCHAR2(10), STATUS097 VARCHAR2(10), STATUS098 VARCHAR2(10), STATUS099 VARCHAR2(10), STATUS100 VARCHAR2(10) ); -- Create table comment COMMENT ON TABLE RTMOUTPUTSTATUS is ' Defined INTERVAL STATUS table contains the status of each interval provided in the INTERVAL table. STATUS = ''7'' is used to designate an interval where partial missing data was used in the calculation of the resulting value. STATUS = ''9'' is used to designate a NULL (missing) interval value. This is an approved settlements data set.'; comment on column RTMOUTPUTSTATUS.UIDRTMOUTPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the RTMOUTPUTINTERVAL data record.'; comment on column RTMOUTPUTSTATUS.STARTTIME is 'The starttime the data represents.'; comment on column RTMOUTPUTSTATUS.STOPTIME is 'The stoptime the data represents through.'; comment on column RTMOUTPUTSTATUS.STATUS001 is 'The parsed value for the first status.'; comment on column RTMOUTPUTSTATUS.STATUS002 is 'The parsed value for the second status.'; comment on column RTMOUTPUTSTATUS.STATUS003 is 'The parsed value for the third status.'; comment on column RTMOUTPUTSTATUS.STATUS004 is 'The parsed value for the fourth status.'; comment on column RTMOUTPUTSTATUS.STATUS005 is 'The parsed value for the fifth status.'; comment on column RTMOUTPUTSTATUS.STATUS006 is 'The parsed value for the 6th status.'; comment on column RTMOUTPUTSTATUS.STATUS007 is 'The parsed value for the 7th status.'; comment on column RTMOUTPUTSTATUS.STATUS008 is 'The parsed value for the 8th status.'; comment on column RTMOUTPUTSTATUS.STATUS009 is 'The parsed value for the 9th status.'; comment on column RTMOUTPUTSTATUS.STATUS010 is 'The parsed value for the 10th status.'; comment on column RTMOUTPUTSTATUS.STATUS011 is 'The parsed value for the 11th status.'; comment on column RTMOUTPUTSTATUS.STATUS012 is 'The parsed value for the 12th status.'; comment on column RTMOUTPUTSTATUS.STATUS013 is 'The parsed value for the 13th status.'; comment on column RTMOUTPUTSTATUS.STATUS014 is 'The parsed value for the 14th status.'; comment on column RTMOUTPUTSTATUS.STATUS015 is 'The parsed value for the 15th status.'; comment on column RTMOUTPUTSTATUS.STATUS016 is 'The parsed value for the 16th status.'; comment on column RTMOUTPUTSTATUS.STATUS017 is 'The parsed value for the 17th status.'; comment on column RTMOUTPUTSTATUS.STATUS018 is 'The parsed value for the 18th status.'; comment on column RTMOUTPUTSTATUS.STATUS019 is 'The parsed value for the 19th status.'; comment on column RTMOUTPUTSTATUS.STATUS020 is 'The parsed value for the 20th status.'; comment on column RTMOUTPUTSTATUS.STATUS021 is 'The parsed value for the 21th status.'; comment on column RTMOUTPUTSTATUS.STATUS022 is 'The parsed value for the 22th status.'; comment on column RTMOUTPUTSTATUS.STATUS023 is 'The parsed value for the 23th status.'; comment on column RTMOUTPUTSTATUS.STATUS024 is 'The parsed value for the 24th status.'; comment on column RTMOUTPUTSTATUS.STATUS025 is 'The parsed value for the 25th status.'; comment on column RTMOUTPUTSTATUS.STATUS026 is 'The parsed value for the 26th status.'; comment on column RTMOUTPUTSTATUS.STATUS027 is 'The parsed value for the 27th status.'; comment on column RTMOUTPUTSTATUS.STATUS028 is 'The parsed value for the 28th status.'; comment on column RTMOUTPUTSTATUS.STATUS029 is 'The parsed value for the 29th status.'; comment on column RTMOUTPUTSTATUS.STATUS030 is 'The parsed value for the 30th status.'; comment on column RTMOUTPUTSTATUS.STATUS031 is 'The parsed value for the 31th status.'; comment on column RTMOUTPUTSTATUS.STATUS032 is 'The parsed value for the 32th status.'; comment on column RTMOUTPUTSTATUS.STATUS033 is 'The parsed value for the 33th status.'; comment on column RTMOUTPUTSTATUS.STATUS034 is 'The parsed value for the 34th status.'; comment on column RTMOUTPUTSTATUS.STATUS035 is 'The parsed value for the 35th status.'; comment on column RTMOUTPUTSTATUS.STATUS036 is 'The parsed value for the 36th status.'; comment on column RTMOUTPUTSTATUS.STATUS037 is 'The parsed value for the 37th status.'; comment on column RTMOUTPUTSTATUS.STATUS038 is 'The parsed value for the 38th status.'; comment on column RTMOUTPUTSTATUS.STATUS039 is 'The parsed value for the 39th status.'; comment on column RTMOUTPUTSTATUS.STATUS040 is 'The parsed value for the 40th status.'; comment on column RTMOUTPUTSTATUS.STATUS041 is 'The parsed value for the 41th status.'; comment on column RTMOUTPUTSTATUS.STATUS042 is 'The parsed value for the 42th status.'; comment on column RTMOUTPUTSTATUS.STATUS043 is 'The parsed value for the 43th status.'; comment on column RTMOUTPUTSTATUS.STATUS044 is 'The parsed value for the 44th status.'; comment on column RTMOUTPUTSTATUS.STATUS045 is 'The parsed value for the 45th status.'; comment on column RTMOUTPUTSTATUS.STATUS046 is 'The parsed value for the 46th status.'; comment on column RTMOUTPUTSTATUS.STATUS047 is 'The parsed value for the 47th status.'; comment on column RTMOUTPUTSTATUS.STATUS048 is 'The parsed value for the 48th status.'; comment on column RTMOUTPUTSTATUS.STATUS049 is 'The parsed value for the 49th status.'; comment on column RTMOUTPUTSTATUS.STATUS050 is 'The parsed value for the 50th status.'; comment on column RTMOUTPUTSTATUS.STATUS051 is 'The parsed value for the 51th status.'; comment on column RTMOUTPUTSTATUS.STATUS052 is 'The parsed value for the 52th status.'; comment on column RTMOUTPUTSTATUS.STATUS053 is 'The parsed value for the 53th status.'; comment on column RTMOUTPUTSTATUS.STATUS054 is 'The parsed value for the 54th status.'; comment on column RTMOUTPUTSTATUS.STATUS055 is 'The parsed value for the 55th status.'; comment on column RTMOUTPUTSTATUS.STATUS056 is 'The parsed value for the 56th status.'; comment on column RTMOUTPUTSTATUS.STATUS057 is 'The parsed value for the 57th status.'; comment on column RTMOUTPUTSTATUS.STATUS058 is 'The parsed value for the 58th status.'; comment on column RTMOUTPUTSTATUS.STATUS059 is 'The parsed value for the 59th status.'; comment on column RTMOUTPUTSTATUS.STATUS060 is 'The parsed value for the 60th status.'; comment on column RTMOUTPUTSTATUS.STATUS061 is 'The parsed value for the 61th status.'; comment on column RTMOUTPUTSTATUS.STATUS062 is 'The parsed value for the 62th status.'; comment on column RTMOUTPUTSTATUS.STATUS063 is 'The parsed value for the 63th status.'; comment on column RTMOUTPUTSTATUS.STATUS064 is 'The parsed value for the 64th status.'; comment on column RTMOUTPUTSTATUS.STATUS065 is 'The parsed value for the 65th status.'; comment on column RTMOUTPUTSTATUS.STATUS066 is 'The parsed value for the 66th status.'; comment on column RTMOUTPUTSTATUS.STATUS067 is 'The parsed value for the 67th status.'; comment on column RTMOUTPUTSTATUS.STATUS068 is 'The parsed value for the 68th status.'; comment on column RTMOUTPUTSTATUS.STATUS069 is 'The parsed value for the 69th status.'; comment on column RTMOUTPUTSTATUS.STATUS070 is 'The parsed value for the 70th status.'; comment on column RTMOUTPUTSTATUS.STATUS071 is 'The parsed value for the 71th status.'; comment on column RTMOUTPUTSTATUS.STATUS072 is 'The parsed value for the 72th status.'; comment on column RTMOUTPUTSTATUS.STATUS073 is 'The parsed value for the 73th status.'; comment on column RTMOUTPUTSTATUS.STATUS074 is 'The parsed value for the 74th status.'; comment on column RTMOUTPUTSTATUS.STATUS075 is 'The parsed value for the 75th status.'; comment on column RTMOUTPUTSTATUS.STATUS076 is 'The parsed value for the 76th status.'; comment on column RTMOUTPUTSTATUS.STATUS077 is 'The parsed value for the 77th status.'; comment on column RTMOUTPUTSTATUS.STATUS078 is 'The parsed value for the 78th status.'; comment on column RTMOUTPUTSTATUS.STATUS079 is 'The parsed value for the 79th status.'; comment on column RTMOUTPUTSTATUS.STATUS080 is 'The parsed value for the 80th status.'; comment on column RTMOUTPUTSTATUS.STATUS081 is 'The parsed value for the 81th status.'; comment on column RTMOUTPUTSTATUS.STATUS082 is 'The parsed value for the 82th status.'; comment on column RTMOUTPUTSTATUS.STATUS083 is 'The parsed value for the 83th status.'; comment on column RTMOUTPUTSTATUS.STATUS084 is 'The parsed value for the 84th status.'; comment on column RTMOUTPUTSTATUS.STATUS085 is 'The parsed value for the 85th status.'; comment on column RTMOUTPUTSTATUS.STATUS086 is 'The parsed value for the 86th status.'; comment on column RTMOUTPUTSTATUS.STATUS087 is 'The parsed value for the 87th status.'; comment on column RTMOUTPUTSTATUS.STATUS088 is 'The parsed value for the 88th status.'; comment on column RTMOUTPUTSTATUS.STATUS089 is 'The parsed value for the 89th status.'; comment on column RTMOUTPUTSTATUS.STATUS090 is 'The parsed value for the 90th status.'; comment on column RTMOUTPUTSTATUS.STATUS091 is 'The parsed value for the 91th status.'; comment on column RTMOUTPUTSTATUS.STATUS092 is 'The parsed value for the 92th status.'; comment on column RTMOUTPUTSTATUS.STATUS093 is 'The parsed value for the 93th status.'; comment on column RTMOUTPUTSTATUS.STATUS094 is 'The parsed value for the 94th status.'; comment on column RTMOUTPUTSTATUS.STATUS095 is 'The parsed value for the 95th status.'; comment on column RTMOUTPUTSTATUS.STATUS096 is 'The parsed value for the 96th status.'; comment on column RTMOUTPUTSTATUS.STATUS097 is 'The parsed value for the 97th status.'; comment on column RTMOUTPUTSTATUS.STATUS098 is 'The parsed value for the 98th status.'; comment on column RTMOUTPUTSTATUS.STATUS099 is 'The parsed value for the 99th status.'; comment on column RTMOUTPUTSTATUS.STATUS100 is 'The parsed value for the 100th status.'; -- Create table create table RUCOUTPUTHEADER ( UIDRUCOUTPUTHEADER NUMBER(19) NOT NULL, SAVERECORDER VARCHAR2(128) NOT NULL, SAVECHANNEL NUMBER(6) NOT NULL, UIDBILLDETERMINANT NUMBER(5) NOT NULL, QSECODE VARCHAR2(64), UIDSETLPOINT NUMBER(19), STARTTYPE NUMBER(10), RUCID NUMBER(3), UIDRESOURCE NUMBER(19), LSTIME DATE ); -- Create table comment COMMENT ON TABLE RUCOUTPUTHEADER is 'Defined PARENT table containing business level attributes for the calculated results for RUC settlements. This is an approved settlements data set'; comment on column RUCOUTPUTHEADER.UIDRUCOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the RUCOUTPUTHEADER data record.'; comment on column RUCOUTPUTHEADER.SAVERECORDER is 'RUCOUTPUTHEADER.'; comment on column RUCOUTPUTHEADER.SAVECHANNEL is 'ERCOT settlement systems number relational to the number of times an operating day is settled.'; comment on column RUCOUTPUTHEADER.UIDBILLDETERMINANT is 'The ERCOT settlement systems unique identifier for the BILLDETERMINANT data record.'; comment on column RUCOUTPUTHEADER.QSECODE is 'The ERCOT settlement systems code associated to a QSE.'; comment on column RUCOUTPUTHEADER.UIDSETLPOINT is 'The ERCOT settlement systems unique identifier for the SETTLEMENTPOINT data record.'; comment on column RUCOUTPUTHEADER.STARTTYPE is 'This field contains values for the categories by which startup costs are provided in a Three-Part Supply Offer.'; comment on column RUCOUTPUTHEADER.RUCID is 'The ERCOT identifier for the RUC process and date for which the RUC applies.'; comment on column RUCOUTPUTHEADER.UIDRESOURCE is 'The ERCOT settlement systems unique identifier for the RESOURCE data record.'; comment on column RUCOUTPUTHEADER.LSTIME is 'The data record timestamp.'; -- Create table create table RUCOUTPUTINTERVAL ( UIDRUCOUTPUTINTERVAL NUMBER(19) not null, UIDRUCOUTPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UIDSTATEMENTSCHED NUMBER(19) not null, CALCGROUP NUMBER(10) not null, SPI NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, DSTPARTICIPANT CHAR(1) not null, ORIGIN CHAR(1), CHNLCUTTIMESTAMP DATE, TZSTDNAME VARCHAR2(32), TOTAL FLOAT not null, MAXIMUM FLOAT not null, MINIMUM FLOAT not null, INTERVALCOUNT NUMBER(10) not null, INT001 NUMBER, INT002 NUMBER, INT003 NUMBER, INT004 NUMBER, INT005 NUMBER, INT006 NUMBER, INT007 NUMBER, INT008 NUMBER, INT009 NUMBER, INT010 NUMBER, INT011 NUMBER, INT012 NUMBER, INT013 NUMBER, INT014 NUMBER, INT015 NUMBER, INT016 NUMBER, INT017 NUMBER, INT018 NUMBER, INT019 NUMBER, INT020 NUMBER, INT021 NUMBER, INT022 NUMBER, INT023 NUMBER, INT024 NUMBER, INT025 NUMBER, INT026 NUMBER, INT027 NUMBER, INT028 NUMBER, INT029 NUMBER, INT030 NUMBER, INT031 NUMBER, INT032 NUMBER, INT033 NUMBER, INT034 NUMBER, INT035 NUMBER, INT036 NUMBER, INT037 NUMBER, INT038 NUMBER, INT039 NUMBER, INT040 NUMBER, INT041 NUMBER, INT042 NUMBER, INT043 NUMBER, INT044 NUMBER, INT045 NUMBER, INT046 NUMBER, INT047 NUMBER, INT048 NUMBER, INT049 NUMBER, INT050 NUMBER, INT051 NUMBER, INT052 NUMBER, INT053 NUMBER, INT054 NUMBER, INT055 NUMBER, INT056 NUMBER, INT057 NUMBER, INT058 NUMBER, INT059 NUMBER, INT060 NUMBER, INT061 NUMBER, INT062 NUMBER, INT063 NUMBER, INT064 NUMBER, INT065 NUMBER, INT066 NUMBER, INT067 NUMBER, INT068 NUMBER, INT069 NUMBER, INT070 NUMBER, INT071 NUMBER, INT072 NUMBER, INT073 NUMBER, INT074 NUMBER, INT075 NUMBER, INT076 NUMBER, INT077 NUMBER, INT078 NUMBER, INT079 NUMBER, INT080 NUMBER, INT081 NUMBER, INT082 NUMBER, INT083 NUMBER, INT084 NUMBER, INT085 NUMBER, INT086 NUMBER, INT087 NUMBER, INT088 NUMBER, INT089 NUMBER, INT090 NUMBER, INT091 NUMBER, INT092 NUMBER, INT093 NUMBER, INT094 NUMBER, INT095 NUMBER, INT096 NUMBER, INT097 NUMBER, INT098 NUMBER, INT099 NUMBER, INT100 NUMBER, LSTIME DATE ); -- Create table comment COMMENT ON TABLE RUCOUTPUTINTERVAL is 'Defined INTERVAL table containing both: the interval data and data level attributes; for the calculated results for RUC settlements. This is an approved settlements data set.'; comment on column RUCOUTPUTINTERVAL.UIDRUCOUTPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the RUCOUTPUTINTERVAL data record.'; comment on column RUCOUTPUTINTERVAL.UIDRUCOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the RUCOUTPUTHEADER data record.'; comment on column RUCOUTPUTINTERVAL.STARTTIME is 'The starttime the data represents.'; comment on column RUCOUTPUTINTERVAL.STOPTIME is 'The stoptime the data represents through.'; comment on column RUCOUTPUTINTERVAL.UIDSTATEMENTSCHED is 'The unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; comment on column RUCOUTPUTINTERVAL.CALCGROUP is 'The ERCOT settlement systems internal value used to tie related values to a specific business process calculation.'; comment on column RUCOUTPUTINTERVAL.SPI is 'Seconds per interval.'; comment on column RUCOUTPUTINTERVAL.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column RUCOUTPUTINTERVAL.DSTPARTICIPANT is 'The ERCOT identifier that indicates if a record is affected by DST.'; comment on column RUCOUTPUTINTERVAL.ORIGIN is 'C=Calculated.'; comment on column RUCOUTPUTINTERVAL.TOTAL is 'Total of all intervals in data record.'; comment on column RUCOUTPUTINTERVAL.MAXIMUM is 'Maximum interval value found within the data record.'; comment on column RUCOUTPUTINTERVAL.MINIMUM is 'Minimum interval value found within the data record.'; comment on column RUCOUTPUTINTERVAL.INTERVALCOUNT is 'Number of intervals found within the data record.'; comment on column RUCOUTPUTINTERVAL.INT001 is 'The parsed value for the first interval.'; comment on column RUCOUTPUTINTERVAL.INT002 is 'The parsed value for the second interval.'; comment on column RUCOUTPUTINTERVAL.INT003 is 'The parsed value for the third interval.'; comment on column RUCOUTPUTINTERVAL.INT004 is 'The parsed value for the fourth interval.'; comment on column RUCOUTPUTINTERVAL.INT005 is 'The parsed value for the fifth interval.'; comment on column RUCOUTPUTINTERVAL.INT006 is 'The parsed value for the 6th interval.'; comment on column RUCOUTPUTINTERVAL.INT007 is 'The parsed value for the 7th interval.'; comment on column RUCOUTPUTINTERVAL.INT008 is 'The parsed value for the 8th interval.'; comment on column RUCOUTPUTINTERVAL.INT009 is 'The parsed value for the 9th interval.'; comment on column RUCOUTPUTINTERVAL.INT010 is 'The parsed value for the 10th interval.'; comment on column RUCOUTPUTINTERVAL.INT011 is 'The parsed value for the 11th interval.'; comment on column RUCOUTPUTINTERVAL.INT012 is 'The parsed value for the 12th interval.'; comment on column RUCOUTPUTINTERVAL.INT013 is 'The parsed value for the 13th interval.'; comment on column RUCOUTPUTINTERVAL.INT014 is 'The parsed value for the 14th interval.'; comment on column RUCOUTPUTINTERVAL.INT015 is 'The parsed value for the 15th interval.'; comment on column RUCOUTPUTINTERVAL.INT016 is 'The parsed value for the 16th interval.'; comment on column RUCOUTPUTINTERVAL.INT017 is 'The parsed value for the 17th interval.'; comment on column RUCOUTPUTINTERVAL.INT018 is 'The parsed value for the 18th interval.'; comment on column RUCOUTPUTINTERVAL.INT019 is 'The parsed value for the 19th interval.'; comment on column RUCOUTPUTINTERVAL.INT020 is 'The parsed value for the 20th interval.'; comment on column RUCOUTPUTINTERVAL.INT021 is 'The parsed value for the 21th interval.'; comment on column RUCOUTPUTINTERVAL.INT022 is 'The parsed value for the 22th interval.'; comment on column RUCOUTPUTINTERVAL.INT023 is 'The parsed value for the 23th interval.'; comment on column RUCOUTPUTINTERVAL.INT024 is 'The parsed value for the 24th interval.'; comment on column RUCOUTPUTINTERVAL.INT025 is 'The parsed value for the 25th interval.'; comment on column RUCOUTPUTINTERVAL.INT026 is 'The parsed value for the 26th interval.'; comment on column RUCOUTPUTINTERVAL.INT027 is 'The parsed value for the 27th interval.'; comment on column RUCOUTPUTINTERVAL.INT028 is 'The parsed value for the 28th interval.'; comment on column RUCOUTPUTINTERVAL.INT029 is 'The parsed value for the 29th interval.'; comment on column RUCOUTPUTINTERVAL.INT030 is 'The parsed value for the 30th interval.'; comment on column RUCOUTPUTINTERVAL.INT031 is 'The parsed value for the 31th interval.'; comment on column RUCOUTPUTINTERVAL.INT032 is 'The parsed value for the 32th interval.'; comment on column RUCOUTPUTINTERVAL.INT033 is 'The parsed value for the 33th interval.'; comment on column RUCOUTPUTINTERVAL.INT034 is 'The parsed value for the 34th interval.'; comment on column RUCOUTPUTINTERVAL.INT035 is 'The parsed value for the 35th interval.'; comment on column RUCOUTPUTINTERVAL.INT036 is 'The parsed value for the 36th interval.'; comment on column RUCOUTPUTINTERVAL.INT037 is 'The parsed value for the 37th interval.'; comment on column RUCOUTPUTINTERVAL.INT038 is 'The parsed value for the 38th interval.'; comment on column RUCOUTPUTINTERVAL.INT039 is 'The parsed value for the 39th interval.'; comment on column RUCOUTPUTINTERVAL.INT040 is 'The parsed value for the 40th interval.'; comment on column RUCOUTPUTINTERVAL.INT041 is 'The parsed value for the 41th interval.'; comment on column RUCOUTPUTINTERVAL.INT042 is 'The parsed value for the 42th interval.'; comment on column RUCOUTPUTINTERVAL.INT043 is 'The parsed value for the 43th interval.'; comment on column RUCOUTPUTINTERVAL.INT044 is 'The parsed value for the 44th interval.'; comment on column RUCOUTPUTINTERVAL.INT045 is 'The parsed value for the 45th interval.'; comment on column RUCOUTPUTINTERVAL.INT046 is 'The parsed value for the 46th interval.'; comment on column RUCOUTPUTINTERVAL.INT047 is 'The parsed value for the 47th interval.'; comment on column RUCOUTPUTINTERVAL.INT048 is 'The parsed value for the 48th interval.'; comment on column RUCOUTPUTINTERVAL.INT049 is 'The parsed value for the 49th interval.'; comment on column RUCOUTPUTINTERVAL.INT050 is 'The parsed value for the 50th interval.'; comment on column RUCOUTPUTINTERVAL.INT051 is 'The parsed value for the 51th interval.'; comment on column RUCOUTPUTINTERVAL.INT052 is 'The parsed value for the 52th interval.'; comment on column RUCOUTPUTINTERVAL.INT053 is 'The parsed value for the 53th interval.'; comment on column RUCOUTPUTINTERVAL.INT054 is 'The parsed value for the 54th interval.'; comment on column RUCOUTPUTINTERVAL.INT055 is 'The parsed value for the 55th interval.'; comment on column RUCOUTPUTINTERVAL.INT056 is 'The parsed value for the 56th interval.'; comment on column RUCOUTPUTINTERVAL.INT057 is 'The parsed value for the 57th interval.'; comment on column RUCOUTPUTINTERVAL.INT058 is 'The parsed value for the 58th interval.'; comment on column RUCOUTPUTINTERVAL.INT059 is 'The parsed value for the 59th interval.'; comment on column RUCOUTPUTINTERVAL.INT060 is 'The parsed value for the 60th interval.'; comment on column RUCOUTPUTINTERVAL.INT061 is 'The parsed value for the 61th interval.'; comment on column RUCOUTPUTINTERVAL.INT062 is 'The parsed value for the 62th interval.'; comment on column RUCOUTPUTINTERVAL.INT063 is 'The parsed value for the 63th interval.'; comment on column RUCOUTPUTINTERVAL.INT064 is 'The parsed value for the 64th interval.'; comment on column RUCOUTPUTINTERVAL.INT065 is 'The parsed value for the 65th interval.'; comment on column RUCOUTPUTINTERVAL.INT066 is 'The parsed value for the 66th interval.'; comment on column RUCOUTPUTINTERVAL.INT067 is 'The parsed value for the 67th interval.'; comment on column RUCOUTPUTINTERVAL.INT068 is 'The parsed value for the 68th interval.'; comment on column RUCOUTPUTINTERVAL.INT069 is 'The parsed value for the 69th interval.'; comment on column RUCOUTPUTINTERVAL.INT070 is 'The parsed value for the 70th interval.'; comment on column RUCOUTPUTINTERVAL.INT071 is 'The parsed value for the 71th interval.'; comment on column RUCOUTPUTINTERVAL.INT072 is 'The parsed value for the 72th interval.'; comment on column RUCOUTPUTINTERVAL.INT073 is 'The parsed value for the 73th interval.'; comment on column RUCOUTPUTINTERVAL.INT074 is 'The parsed value for the 74th interval.'; comment on column RUCOUTPUTINTERVAL.INT075 is 'The parsed value for the 75th interval.'; comment on column RUCOUTPUTINTERVAL.INT076 is 'The parsed value for the 76th interval.'; comment on column RUCOUTPUTINTERVAL.INT077 is 'The parsed value for the 77th interval.'; comment on column RUCOUTPUTINTERVAL.INT078 is 'The parsed value for the 78th interval.'; comment on column RUCOUTPUTINTERVAL.INT079 is 'The parsed value for the 79th interval.'; comment on column RUCOUTPUTINTERVAL.INT080 is 'The parsed value for the 80th interval.'; comment on column RUCOUTPUTINTERVAL.INT081 is 'The parsed value for the 81th interval.'; comment on column RUCOUTPUTINTERVAL.INT082 is 'The parsed value for the 82th interval.'; comment on column RUCOUTPUTINTERVAL.INT083 is 'The parsed value for the 83th interval.'; comment on column RUCOUTPUTINTERVAL.INT084 is 'The parsed value for the 84th interval.'; comment on column RUCOUTPUTINTERVAL.INT085 is 'The parsed value for the 85th interval.'; comment on column RUCOUTPUTINTERVAL.INT086 is 'The parsed value for the 86th interval.'; comment on column RUCOUTPUTINTERVAL.INT087 is 'The parsed value for the 87th interval.'; comment on column RUCOUTPUTINTERVAL.INT088 is 'The parsed value for the 88th interval.'; comment on column RUCOUTPUTINTERVAL.INT089 is 'The parsed value for the 89th interval.'; comment on column RUCOUTPUTINTERVAL.INT090 is 'The parsed value for the 90th interval.'; comment on column RUCOUTPUTINTERVAL.INT091 is 'The parsed value for the 91th interval.'; comment on column RUCOUTPUTINTERVAL.INT092 is 'The parsed value for the 92th interval.'; comment on column RUCOUTPUTINTERVAL.INT093 is 'The parsed value for the 93th interval.'; comment on column RUCOUTPUTINTERVAL.INT094 is 'The parsed value for the 94th interval.'; comment on column RUCOUTPUTINTERVAL.INT095 is 'The parsed value for the 95th interval.'; comment on column RUCOUTPUTINTERVAL.INT096 is 'The parsed value for the 96th interval.'; comment on column RUCOUTPUTINTERVAL.INT097 is 'The parsed value for the 97th interval.'; comment on column RUCOUTPUTINTERVAL.INT098 is 'The parsed value for the 98th interval.'; comment on column RUCOUTPUTINTERVAL.INT099 is 'The parsed value for the 99th interval.'; comment on column RUCOUTPUTINTERVAL.INT100 is 'The parsed value for the 100th interval.'; comment on column RUCOUTPUTINTERVAL.LSTIME is 'The data record timestamp.'; -- Create table create table RUCOUTPUTSCALAR ( UIDRUCOUTPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UIDSTATEMENTSCHED NUMBER(19) not null, CALCGROUP NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, STRINGVALUE VARCHAR2(64), VALUE FLOAT, UIDRUCOUTPUTSCALAR NUMBER(19) not null, LSTIME DATE ); -- Create table comment COMMENT ON TABLE RUCOUTPUTSCALAR is 'Defined SCALAR table containing non- interval (i.e. daily or monthly) data for the calculated results for RUC settlements. This is an approved settlements data set '; comment on column RUCOUTPUTSCALAR.UIDRUCOUTPUTHEADER is 'The ERCOT settlement systems unique identifier for the RUCOUTPUTHEADER data record.'; comment on column RUCOUTPUTSCALAR.STARTTIME is 'The starttime the data represents.'; comment on column RUCOUTPUTSCALAR.STOPTIME is 'The stoptime the data represents through.'; comment on column RUCOUTPUTSCALAR.UIDSTATEMENTSCHED is 'The unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; comment on column RUCOUTPUTSCALAR.CALCGROUP is 'The ERCOT settlement systems internal value used to tie related values to a specific business process calculation.'; comment on column RUCOUTPUTSCALAR.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column RUCOUTPUTSCALAR.STRINGVALUE is ' Value used for calculation.'; comment on column RUCOUTPUTSCALAR.VALUE is 'Value used for calculation.'; comment on column RUCOUTPUTSCALAR.UIDRUCOUTPUTSCALAR is 'The ERCOT settlement systems unique identifier for the RUCOUTPUTSCALAR data record '; comment on column RUCOUTPUTSCALAR.LSTIME is 'The data record timestamp.'; -- Create table create table RUCOUTPUTSTATUS ( UIDRUCOUTPUTINTERVAL NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, STATUS001 VARCHAR2(10), STATUS002 VARCHAR2(10), STATUS003 VARCHAR2(10), STATUS004 VARCHAR2(10), STATUS005 VARCHAR2(10), STATUS006 VARCHAR2(10), STATUS007 VARCHAR2(10), STATUS008 VARCHAR2(10), STATUS009 VARCHAR2(10), STATUS010 VARCHAR2(10), STATUS011 VARCHAR2(10), STATUS012 VARCHAR2(10), STATUS013 VARCHAR2(10), STATUS014 VARCHAR2(10), STATUS015 VARCHAR2(10), STATUS016 VARCHAR2(10), STATUS017 VARCHAR2(10), STATUS018 VARCHAR2(10), STATUS019 VARCHAR2(10), STATUS020 VARCHAR2(10), STATUS021 VARCHAR2(10), STATUS022 VARCHAR2(10), STATUS023 VARCHAR2(10), STATUS024 VARCHAR2(10), STATUS025 VARCHAR2(10), STATUS026 VARCHAR2(10), STATUS027 VARCHAR2(10), STATUS028 VARCHAR2(10), STATUS029 VARCHAR2(10), STATUS030 VARCHAR2(10), STATUS031 VARCHAR2(10), STATUS032 VARCHAR2(10), STATUS033 VARCHAR2(10), STATUS034 VARCHAR2(10), STATUS035 VARCHAR2(10), STATUS036 VARCHAR2(10), STATUS037 VARCHAR2(10), STATUS038 VARCHAR2(10), STATUS039 VARCHAR2(10), STATUS040 VARCHAR2(10), STATUS041 VARCHAR2(10), STATUS042 VARCHAR2(10), STATUS043 VARCHAR2(10), STATUS044 VARCHAR2(10), STATUS045 VARCHAR2(10), STATUS046 VARCHAR2(10), STATUS047 VARCHAR2(10), STATUS048 VARCHAR2(10), STATUS049 VARCHAR2(10), STATUS050 VARCHAR2(10), STATUS051 VARCHAR2(10), STATUS052 VARCHAR2(10), STATUS053 VARCHAR2(10), STATUS054 VARCHAR2(10), STATUS055 VARCHAR2(10), STATUS056 VARCHAR2(10), STATUS057 VARCHAR2(10), STATUS058 VARCHAR2(10), STATUS059 VARCHAR2(10), STATUS060 VARCHAR2(10), STATUS061 VARCHAR2(10), STATUS062 VARCHAR2(10), STATUS063 VARCHAR2(10), STATUS064 VARCHAR2(10), STATUS065 VARCHAR2(10), STATUS066 VARCHAR2(10), STATUS067 VARCHAR2(10), STATUS068 VARCHAR2(10), STATUS069 VARCHAR2(10), STATUS070 VARCHAR2(10), STATUS071 VARCHAR2(10), STATUS072 VARCHAR2(10), STATUS073 VARCHAR2(10), STATUS074 VARCHAR2(10), STATUS075 VARCHAR2(10), STATUS076 VARCHAR2(10), STATUS077 VARCHAR2(10), STATUS078 VARCHAR2(10), STATUS079 VARCHAR2(10), STATUS080 VARCHAR2(10), STATUS081 VARCHAR2(10), STATUS082 VARCHAR2(10), STATUS083 VARCHAR2(10), STATUS084 VARCHAR2(10), STATUS085 VARCHAR2(10), STATUS086 VARCHAR2(10), STATUS087 VARCHAR2(10), STATUS088 VARCHAR2(10), STATUS089 VARCHAR2(10), STATUS090 VARCHAR2(10), STATUS091 VARCHAR2(10), STATUS092 VARCHAR2(10), STATUS093 VARCHAR2(10), STATUS094 VARCHAR2(10), STATUS095 VARCHAR2(10), STATUS096 VARCHAR2(10), STATUS097 VARCHAR2(10), STATUS098 VARCHAR2(10), STATUS099 VARCHAR2(10), STATUS100 VARCHAR2(10) ); -- Create table comment COMMENT ON TABLE RUCOUTPUTSTATUS is ' Defined INTERVAL STATUS table contains the status of each interval provided in the INTERVAL table. STATUS = ''7'' is used to designate an interval where partial missing data was used in the calculation of the resulting value. STATUS = ''9'' is used to designate a NULL (missing) interval value. This is an approved settlements data set.'; comment on column RUCOUTPUTSTATUS.UIDRUCOUTPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the RUCOUTPUTINTERVAL data record.'; comment on column RUCOUTPUTSTATUS.STARTTIME is 'The starttime the data represents.'; comment on column RUCOUTPUTSTATUS.STOPTIME is 'The stoptime the data represents through.'; comment on column RUCOUTPUTSTATUS.STATUS001 is 'The parsed value for the first status.'; comment on column RUCOUTPUTSTATUS.STATUS002 is 'The parsed value for the second status.'; comment on column RUCOUTPUTSTATUS.STATUS003 is 'The parsed value for the third status.'; comment on column RUCOUTPUTSTATUS.STATUS004 is 'The parsed value for the fourth status.'; comment on column RUCOUTPUTSTATUS.STATUS005 is 'The parsed value for the fifth status.'; comment on column RUCOUTPUTSTATUS.STATUS006 is 'The parsed value for the 6th status.'; comment on column RUCOUTPUTSTATUS.STATUS007 is 'The parsed value for the 7th status.'; comment on column RUCOUTPUTSTATUS.STATUS008 is 'The parsed value for the 8th status.'; comment on column RUCOUTPUTSTATUS.STATUS009 is 'The parsed value for the 9th status.'; comment on column RUCOUTPUTSTATUS.STATUS010 is 'The parsed value for the 10th status.'; comment on column RUCOUTPUTSTATUS.STATUS011 is 'The parsed value for the 11th status.'; comment on column RUCOUTPUTSTATUS.STATUS012 is 'The parsed value for the 12th status.'; comment on column RUCOUTPUTSTATUS.STATUS013 is 'The parsed value for the 13th status.'; comment on column RUCOUTPUTSTATUS.STATUS014 is 'The parsed value for the 14th status.'; comment on column RUCOUTPUTSTATUS.STATUS015 is 'The parsed value for the 15th status.'; comment on column RUCOUTPUTSTATUS.STATUS016 is 'The parsed value for the 16th status.'; comment on column RUCOUTPUTSTATUS.STATUS017 is 'The parsed value for the 17th status.'; comment on column RUCOUTPUTSTATUS.STATUS018 is 'The parsed value for the 18th status.'; comment on column RUCOUTPUTSTATUS.STATUS019 is 'The parsed value for the 19th status.'; comment on column RUCOUTPUTSTATUS.STATUS020 is 'The parsed value for the 20th status.'; comment on column RUCOUTPUTSTATUS.STATUS021 is 'The parsed value for the 21th status.'; comment on column RUCOUTPUTSTATUS.STATUS022 is 'The parsed value for the 22th status.'; comment on column RUCOUTPUTSTATUS.STATUS023 is 'The parsed value for the 23th status.'; comment on column RUCOUTPUTSTATUS.STATUS024 is 'The parsed value for the 24th status.'; comment on column RUCOUTPUTSTATUS.STATUS025 is 'The parsed value for the 25th status.'; comment on column RUCOUTPUTSTATUS.STATUS026 is 'The parsed value for the 26th status.'; comment on column RUCOUTPUTSTATUS.STATUS027 is 'The parsed value for the 27th status.'; comment on column RUCOUTPUTSTATUS.STATUS028 is 'The parsed value for the 28th status.'; comment on column RUCOUTPUTSTATUS.STATUS029 is 'The parsed value for the 29th status.'; comment on column RUCOUTPUTSTATUS.STATUS030 is 'The parsed value for the 30th status.'; comment on column RUCOUTPUTSTATUS.STATUS031 is 'The parsed value for the 31th status.'; comment on column RUCOUTPUTSTATUS.STATUS032 is 'The parsed value for the 32th status.'; comment on column RUCOUTPUTSTATUS.STATUS033 is 'The parsed value for the 33th status.'; comment on column RUCOUTPUTSTATUS.STATUS034 is 'The parsed value for the 34th status.'; comment on column RUCOUTPUTSTATUS.STATUS035 is 'The parsed value for the 35th status.'; comment on column RUCOUTPUTSTATUS.STATUS036 is 'The parsed value for the 36th status.'; comment on column RUCOUTPUTSTATUS.STATUS037 is 'The parsed value for the 37th status.'; comment on column RUCOUTPUTSTATUS.STATUS038 is 'The parsed value for the 38th status.'; comment on column RUCOUTPUTSTATUS.STATUS039 is 'The parsed value for the 39th status.'; comment on column RUCOUTPUTSTATUS.STATUS040 is 'The parsed value for the 40th status.'; comment on column RUCOUTPUTSTATUS.STATUS041 is 'The parsed value for the 41th status.'; comment on column RUCOUTPUTSTATUS.STATUS042 is 'The parsed value for the 42th status.'; comment on column RUCOUTPUTSTATUS.STATUS043 is 'The parsed value for the 43th status.'; comment on column RUCOUTPUTSTATUS.STATUS044 is 'The parsed value for the 44th status.'; comment on column RUCOUTPUTSTATUS.STATUS045 is 'The parsed value for the 45th status.'; comment on column RUCOUTPUTSTATUS.STATUS046 is 'The parsed value for the 46th status.'; comment on column RUCOUTPUTSTATUS.STATUS047 is 'The parsed value for the 47th status.'; comment on column RUCOUTPUTSTATUS.STATUS048 is 'The parsed value for the 48th status.'; comment on column RUCOUTPUTSTATUS.STATUS049 is 'The parsed value for the 49th status.'; comment on column RUCOUTPUTSTATUS.STATUS050 is 'The parsed value for the 50th status.'; comment on column RUCOUTPUTSTATUS.STATUS051 is 'The parsed value for the 51th status.'; comment on column RUCOUTPUTSTATUS.STATUS052 is 'The parsed value for the 52th status.'; comment on column RUCOUTPUTSTATUS.STATUS053 is 'The parsed value for the 53th status.'; comment on column RUCOUTPUTSTATUS.STATUS054 is 'The parsed value for the 54th status.'; comment on column RUCOUTPUTSTATUS.STATUS055 is 'The parsed value for the 55th status.'; comment on column RUCOUTPUTSTATUS.STATUS056 is 'The parsed value for the 56th status.'; comment on column RUCOUTPUTSTATUS.STATUS057 is 'The parsed value for the 57th status.'; comment on column RUCOUTPUTSTATUS.STATUS058 is 'The parsed value for the 58th status.'; comment on column RUCOUTPUTSTATUS.STATUS059 is 'The parsed value for the 59th status.'; comment on column RUCOUTPUTSTATUS.STATUS060 is 'The parsed value for the 60th status.'; comment on column RUCOUTPUTSTATUS.STATUS061 is 'The parsed value for the 61th status.'; comment on column RUCOUTPUTSTATUS.STATUS062 is 'The parsed value for the 62th status.'; comment on column RUCOUTPUTSTATUS.STATUS063 is 'The parsed value for the 63th status.'; comment on column RUCOUTPUTSTATUS.STATUS064 is 'The parsed value for the 64th status.'; comment on column RUCOUTPUTSTATUS.STATUS065 is 'The parsed value for the 65th status.'; comment on column RUCOUTPUTSTATUS.STATUS066 is 'The parsed value for the 66th status.'; comment on column RUCOUTPUTSTATUS.STATUS067 is 'The parsed value for the 67th status.'; comment on column RUCOUTPUTSTATUS.STATUS068 is 'The parsed value for the 68th status.'; comment on column RUCOUTPUTSTATUS.STATUS069 is 'The parsed value for the 69th status.'; comment on column RUCOUTPUTSTATUS.STATUS070 is 'The parsed value for the 70th status.'; comment on column RUCOUTPUTSTATUS.STATUS071 is 'The parsed value for the 71th status.'; comment on column RUCOUTPUTSTATUS.STATUS072 is 'The parsed value for the 72th status.'; comment on column RUCOUTPUTSTATUS.STATUS073 is 'The parsed value for the 73th status.'; comment on column RUCOUTPUTSTATUS.STATUS074 is 'The parsed value for the 74th status.'; comment on column RUCOUTPUTSTATUS.STATUS075 is 'The parsed value for the 75th status.'; comment on column RUCOUTPUTSTATUS.STATUS076 is 'The parsed value for the 76th status.'; comment on column RUCOUTPUTSTATUS.STATUS077 is 'The parsed value for the 77th status.'; comment on column RUCOUTPUTSTATUS.STATUS078 is 'The parsed value for the 78th status.'; comment on column RUCOUTPUTSTATUS.STATUS079 is 'The parsed value for the 79th status.'; comment on column RUCOUTPUTSTATUS.STATUS080 is 'The parsed value for the 80th status.'; comment on column RUCOUTPUTSTATUS.STATUS081 is 'The parsed value for the 81th status.'; comment on column RUCOUTPUTSTATUS.STATUS082 is 'The parsed value for the 82th status.'; comment on column RUCOUTPUTSTATUS.STATUS083 is 'The parsed value for the 83th status.'; comment on column RUCOUTPUTSTATUS.STATUS084 is 'The parsed value for the 84th status.'; comment on column RUCOUTPUTSTATUS.STATUS085 is 'The parsed value for the 85th status.'; comment on column RUCOUTPUTSTATUS.STATUS086 is 'The parsed value for the 86th status.'; comment on column RUCOUTPUTSTATUS.STATUS087 is 'The parsed value for the 87th status.'; comment on column RUCOUTPUTSTATUS.STATUS088 is 'The parsed value for the 88th status.'; comment on column RUCOUTPUTSTATUS.STATUS089 is 'The parsed value for the 89th status.'; comment on column RUCOUTPUTSTATUS.STATUS090 is 'The parsed value for the 90th status.'; comment on column RUCOUTPUTSTATUS.STATUS091 is 'The parsed value for the 91th status.'; comment on column RUCOUTPUTSTATUS.STATUS092 is 'The parsed value for the 92th status.'; comment on column RUCOUTPUTSTATUS.STATUS093 is 'The parsed value for the 93th status.'; comment on column RUCOUTPUTSTATUS.STATUS094 is 'The parsed value for the 94th status.'; comment on column RUCOUTPUTSTATUS.STATUS095 is 'The parsed value for the 95th status.'; comment on column RUCOUTPUTSTATUS.STATUS096 is 'The parsed value for the 96th status.'; comment on column RUCOUTPUTSTATUS.STATUS097 is 'The parsed value for the 97th status.'; comment on column RUCOUTPUTSTATUS.STATUS098 is 'The parsed value for the 98th status.'; comment on column RUCOUTPUTSTATUS.STATUS099 is 'The parsed value for the 99th status.'; comment on column RUCOUTPUTSTATUS.STATUS100 is 'The parsed value for the 100th status.'; -- Create table create table SID_MKTINPUTHEADER ( UIDMKTINPUTHEADER NUMBER(19) not null, SAVERECORDER VARCHAR2(128) not null, SAVECHANNEL NUMBER(6) not null, UIDBILLDETERMINANT NUMBER(5) not null, UIDMARKET NUMBER(19) not null, QSECODE VARCHAR2(64), UIDSETLPOINT NUMBER(19), UIDSOURCESETLPOINT NUMBER(19), UIDSINKSETLPOINT NUMBER(19), RUCID NUMBER(3), CRRACCTHLDRCODE NUMBER(19), STARTTYPE NUMBER(10), UIDFLOWGATE NUMBER(19), UIDELEMENT NUMBER(19), MKTCONSTRAINTCODE NUMBER(19), UIDASMARKET NUMBER(19), UIDRESOURCE NUMBER(19), LSTIME DATE, RESOURCEID VARCHAR2(64), TDSPCODE VARCHAR2(64), LOSSCODE VARCHAR2(64), CRRID VARCHAR2(12), CRROFFERID VARCHAR2(12) ); -- Create table comment COMMENT ON TABLE SID_MKTINPUTHEADER is 'Contains Operating Day market input data that is UNAPPROVED settlements data provided for market analysis and forecasting; this includes data received from the MMS, EMS, and CRR systems.'; comment on column SID_MKTINPUTHEADER.UIDMKTINPUTHEADER is 'The ERCOT settlement systems unique identifier for the MKTINPUTHEADER data record.'; comment on column SID_MKTINPUTHEADER.SAVERECORDER is 'The concatenated attributes of the MKTINPUTHEADER.'; comment on column SID_MKTINPUTHEADER.SAVECHANNEL is 'All market inputs have a SAVECHANNEL=''1'' and are re-used in each operating day settlement.'; comment on column SID_MKTINPUTHEADER.UIDBILLDETERMINANT is 'The ERCOT settlement systems unique identifier for the BILLDETERMINANT data record.'; comment on column SID_MKTINPUTHEADER.UIDMARKET is 'The ERCOT settlement systems unique identifier for the MARKET data record.'; comment on column SID_MKTINPUTHEADER.QSECODE is 'The ERCOT settlement systems code associated to a QSE.'; comment on column SID_MKTINPUTHEADER.UIDSETLPOINT is 'The ERCOT settlement systems unique identifier for the SETTLEMENTPOINT data record.'; comment on column SID_MKTINPUTHEADER.UIDSOURCESETLPOINT is 'The ERCOT settlement systems unique identifier for the SOURCESETLPOINT data record.'; comment on column SID_MKTINPUTHEADER.UIDSINKSETLPOINT is 'The ERCOT settlement systems unique identifier for the SINKSETLPOINT data record.'; comment on column SID_MKTINPUTHEADER.RUCID is 'The ERCOT identifier for the RUC process and date for which the RUC applies.'; comment on column SID_MKTINPUTHEADER.CRRACCTHLDRCODE is 'The ERCOT settlement systems unique identifier for the CRRACCTHLDR data record.'; comment on column SID_MKTINPUTHEADER.STARTTYPE is 'This field contains values for the categories by which startup costs are provided in a Three-Part Supply Offer.'; comment on column SID_MKTINPUTHEADER.UIDFLOWGATE is 'The ERCOT settlement systems unique identifier for the FLOWGATE data record.'; comment on column SID_MKTINPUTHEADER.UIDELEMENT is 'The ERCOT settlement systems unique identifier for the ELEMENT data record.'; comment on column SID_MKTINPUTHEADER.MKTCONSTRAINTCODE is 'The ERCOT settlement systems unique identifier for the MKTCONSTRAINT data record.'; comment on column SID_MKTINPUTHEADER.UIDASMARKET is 'The ERCOT settlement systems unique identifier for the ASMARKET data record.'; comment on column SID_MKTINPUTHEADER.UIDRESOURCE is 'The ERCOT settlement systems unique identifier for the RESOURCE data record. The RESOURCE is either a generator, combined cycle plant or combined cycle configuration.'; comment on column SID_MKTINPUTHEADER.LSTIME is 'The data record timestamp.'; comment on column SID_MKTINPUTHEADER.RESOURCEID is 'The ERCOT unique identifier for an ERCOT Polled Settlement meter location.'; comment on column SID_MKTINPUTHEADER.TDSPCODE is 'The ERCOT settlement systems code associated to a TDSP.'; comment on column SID_MKTINPUTHEADER.LOSSCODE is 'The ERCOT settlement systems code associated to a LOSSCLASS.'; -- Create table create table SID_MKTINPUTINTERVAL ( UIDMKTINPUTINTERVAL NUMBER(19) not null, UIDMKTINPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, SPI NUMBER(10) not null, UOMCODE VARCHAR2(64) not null, DSTPARTICIPANT CHAR(1) not null, ORIGIN CHAR(1), CHNLCUTTIMESTAMP DATE, TZSTDNAME VARCHAR2(32), TOTAL FLOAT not null, MAXIMUM FLOAT not null, MINIMUM FLOAT not null, INTERVALCOUNT NUMBER(10) not null, INT001 NUMBER, INT002 NUMBER, INT003 NUMBER, INT004 NUMBER, INT005 NUMBER, INT006 NUMBER, INT007 NUMBER, INT008 NUMBER, INT009 NUMBER, INT010 NUMBER, INT011 NUMBER, INT012 NUMBER, INT013 NUMBER, INT014 NUMBER, INT015 NUMBER, INT016 NUMBER, INT017 NUMBER, INT018 NUMBER, INT019 NUMBER, INT020 NUMBER, INT021 NUMBER, INT022 NUMBER, INT023 NUMBER, INT024 NUMBER, INT025 NUMBER, INT026 NUMBER, INT027 NUMBER, INT028 NUMBER, INT029 NUMBER, INT030 NUMBER, INT031 NUMBER, INT032 NUMBER, INT033 NUMBER, INT034 NUMBER, INT035 NUMBER, INT036 NUMBER, INT037 NUMBER, INT038 NUMBER, INT039 NUMBER, INT040 NUMBER, INT041 NUMBER, INT042 NUMBER, INT043 NUMBER, INT044 NUMBER, INT045 NUMBER, INT046 NUMBER, INT047 NUMBER, INT048 NUMBER, INT049 NUMBER, INT050 NUMBER, INT051 NUMBER, INT052 NUMBER, INT053 NUMBER, INT054 NUMBER, INT055 NUMBER, INT056 NUMBER, INT057 NUMBER, INT058 NUMBER, INT059 NUMBER, INT060 NUMBER, INT061 NUMBER, INT062 NUMBER, INT063 NUMBER, INT064 NUMBER, INT065 NUMBER, INT066 NUMBER, INT067 NUMBER, INT068 NUMBER, INT069 NUMBER, INT070 NUMBER, INT071 NUMBER, INT072 NUMBER, INT073 NUMBER, INT074 NUMBER, INT075 NUMBER, INT076 NUMBER, INT077 NUMBER, INT078 NUMBER, INT079 NUMBER, INT080 NUMBER, INT081 NUMBER, INT082 NUMBER, INT083 NUMBER, INT084 NUMBER, INT085 NUMBER, INT086 NUMBER, INT087 NUMBER, INT088 NUMBER, INT089 NUMBER, INT090 NUMBER, INT091 NUMBER, INT092 NUMBER, INT093 NUMBER, INT094 NUMBER, INT095 NUMBER, INT096 NUMBER, INT097 NUMBER, INT098 NUMBER, INT099 NUMBER, INT100 NUMBER, LSTIME DATE ); -- Create table comment COMMENT ON TABLE SID_MKTINPUTINTERVAL is 'Contains Operating Day market input interval level data that is UNAPPROVED settlements data provided for market analysis and forecasting; this includes data received from the MMS, EMS, and CRR systems.'; comment on column SID_MKTINPUTINTERVAL.UIDMKTINPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the MKTINPUTINTERVAL data record.'; comment on column SID_MKTINPUTINTERVAL.UIDMKTINPUTHEADER is 'The ERCOT settlement systems unique identifier for the MKTINPUTHEADER data record.'; comment on column SID_MKTINPUTINTERVAL.STARTTIME is 'The starttime the data represents.'; comment on column SID_MKTINPUTINTERVAL.STOPTIME is 'The stoptime the data represents through.'; comment on column SID_MKTINPUTINTERVAL.SPI is 'Seconds per interval.'; comment on column SID_MKTINPUTINTERVAL.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column SID_MKTINPUTINTERVAL.DSTPARTICIPANT is 'The ERCOT identifier that indicates if a record is affected by DST.'; comment on column SID_MKTINPUTINTERVAL.ORIGIN is 'C=Calculated.'; comment on column SID_MKTINPUTINTERVAL.TOTAL is 'Total of all intervals in data record.'; comment on column SID_MKTINPUTINTERVAL.MAXIMUM is 'Maximum interval value found within the data record.'; comment on column SID_MKTINPUTINTERVAL.MINIMUM is 'Minimum interval value found within the data record.'; comment on column SID_MKTINPUTINTERVAL.INTERVALCOUNT is 'Number of intervals found within the data record.'; comment on column SID_MKTINPUTINTERVAL.INT001 is 'The parsed value for the first interval.'; comment on column SID_MKTINPUTINTERVAL.INT002 is 'The parsed value for the second interval.'; comment on column SID_MKTINPUTINTERVAL.INT003 is 'The parsed value for the third interval.'; comment on column SID_MKTINPUTINTERVAL.INT004 is 'The parsed value for the fourth interval.'; comment on column SID_MKTINPUTINTERVAL.INT005 is 'The parsed value for the fifth interval.'; comment on column SID_MKTINPUTINTERVAL.INT006 is 'The parsed value for the 6th interval.'; comment on column SID_MKTINPUTINTERVAL.INT007 is 'The parsed value for the 7th interval.'; comment on column SID_MKTINPUTINTERVAL.INT008 is 'The parsed value for the 8th interval.'; comment on column SID_MKTINPUTINTERVAL.INT009 is 'The parsed value for the 9th interval.'; comment on column SID_MKTINPUTINTERVAL.INT010 is 'The parsed value for the 10th interval.'; comment on column SID_MKTINPUTINTERVAL.INT011 is 'The parsed value for the 11th interval.'; comment on column SID_MKTINPUTINTERVAL.INT012 is 'The parsed value for the 12th interval.'; comment on column SID_MKTINPUTINTERVAL.INT013 is 'The parsed value for the 13th interval.'; comment on column SID_MKTINPUTINTERVAL.INT014 is 'The parsed value for the 14th interval.'; comment on column SID_MKTINPUTINTERVAL.INT015 is 'The parsed value for the 15th interval.'; comment on column SID_MKTINPUTINTERVAL.INT016 is 'The parsed value for the 16th interval.'; comment on column SID_MKTINPUTINTERVAL.INT017 is 'The parsed value for the 17th interval.'; comment on column SID_MKTINPUTINTERVAL.INT018 is 'The parsed value for the 18th interval.'; comment on column SID_MKTINPUTINTERVAL.INT019 is 'The parsed value for the 19th interval.'; comment on column SID_MKTINPUTINTERVAL.INT020 is 'The parsed value for the 20th interval.'; comment on column SID_MKTINPUTINTERVAL.INT021 is 'The parsed value for the 21th interval.'; comment on column SID_MKTINPUTINTERVAL.INT022 is 'The parsed value for the 22th interval.'; comment on column SID_MKTINPUTINTERVAL.INT023 is 'The parsed value for the 23th interval.'; comment on column SID_MKTINPUTINTERVAL.INT024 is 'The parsed value for the 24th interval.'; comment on column SID_MKTINPUTINTERVAL.INT025 is 'The parsed value for the 25th interval.'; comment on column SID_MKTINPUTINTERVAL.INT026 is 'The parsed value for the 26th interval.'; comment on column SID_MKTINPUTINTERVAL.INT027 is 'The parsed value for the 27th interval.'; comment on column SID_MKTINPUTINTERVAL.INT028 is 'The parsed value for the 28th interval.'; comment on column SID_MKTINPUTINTERVAL.INT029 is 'The parsed value for the 29th interval.'; comment on column SID_MKTINPUTINTERVAL.INT030 is 'The parsed value for the 30th interval.'; comment on column SID_MKTINPUTINTERVAL.INT031 is 'The parsed value for the 31th interval.'; comment on column SID_MKTINPUTINTERVAL.INT032 is 'The parsed value for the 32th interval.'; comment on column SID_MKTINPUTINTERVAL.INT033 is 'The parsed value for the 33th interval.'; comment on column SID_MKTINPUTINTERVAL.INT034 is 'The parsed value for the 34th interval.'; comment on column SID_MKTINPUTINTERVAL.INT035 is 'The parsed value for the 35th interval.'; comment on column SID_MKTINPUTINTERVAL.INT036 is 'The parsed value for the 36th interval.'; comment on column SID_MKTINPUTINTERVAL.INT037 is 'The parsed value for the 37th interval.'; comment on column SID_MKTINPUTINTERVAL.INT038 is 'The parsed value for the 38th interval.'; comment on column SID_MKTINPUTINTERVAL.INT039 is 'The parsed value for the 39th interval.'; comment on column SID_MKTINPUTINTERVAL.INT040 is 'The parsed value for the 40th interval.'; comment on column SID_MKTINPUTINTERVAL.INT041 is 'The parsed value for the 41th interval.'; comment on column SID_MKTINPUTINTERVAL.INT042 is 'The parsed value for the 42th interval.'; comment on column SID_MKTINPUTINTERVAL.INT043 is 'The parsed value for the 43th interval.'; comment on column SID_MKTINPUTINTERVAL.INT044 is 'The parsed value for the 44th interval.'; comment on column SID_MKTINPUTINTERVAL.INT045 is 'The parsed value for the 45th interval.'; comment on column SID_MKTINPUTINTERVAL.INT046 is 'The parsed value for the 46th interval.'; comment on column SID_MKTINPUTINTERVAL.INT047 is 'The parsed value for the 47th interval.'; comment on column SID_MKTINPUTINTERVAL.INT048 is 'The parsed value for the 48th interval.'; comment on column SID_MKTINPUTINTERVAL.INT049 is 'The parsed value for the 49th interval.'; comment on column SID_MKTINPUTINTERVAL.INT050 is 'The parsed value for the 50th interval.'; comment on column SID_MKTINPUTINTERVAL.INT051 is 'The parsed value for the 51th interval.'; comment on column SID_MKTINPUTINTERVAL.INT052 is 'The parsed value for the 52th interval.'; comment on column SID_MKTINPUTINTERVAL.INT053 is 'The parsed value for the 53th interval.'; comment on column SID_MKTINPUTINTERVAL.INT054 is 'The parsed value for the 54th interval.'; comment on column SID_MKTINPUTINTERVAL.INT055 is 'The parsed value for the 55th interval.'; comment on column SID_MKTINPUTINTERVAL.INT056 is 'The parsed value for the 56th interval.'; comment on column SID_MKTINPUTINTERVAL.INT057 is 'The parsed value for the 57th interval.'; comment on column SID_MKTINPUTINTERVAL.INT058 is 'The parsed value for the 58th interval.'; comment on column SID_MKTINPUTINTERVAL.INT059 is 'The parsed value for the 59th interval.'; comment on column SID_MKTINPUTINTERVAL.INT060 is 'The parsed value for the 60th interval.'; comment on column SID_MKTINPUTINTERVAL.INT061 is 'The parsed value for the 61th interval.'; comment on column SID_MKTINPUTINTERVAL.INT062 is 'The parsed value for the 62th interval.'; comment on column SID_MKTINPUTINTERVAL.INT063 is 'The parsed value for the 63th interval.'; comment on column SID_MKTINPUTINTERVAL.INT064 is 'The parsed value for the 64th interval.'; comment on column SID_MKTINPUTINTERVAL.INT065 is 'The parsed value for the 65th interval.'; comment on column SID_MKTINPUTINTERVAL.INT066 is 'The parsed value for the 66th interval.'; comment on column SID_MKTINPUTINTERVAL.INT067 is 'The parsed value for the 67th interval.'; comment on column SID_MKTINPUTINTERVAL.INT068 is 'The parsed value for the 68th interval.'; comment on column SID_MKTINPUTINTERVAL.INT069 is 'The parsed value for the 69th interval.'; comment on column SID_MKTINPUTINTERVAL.INT070 is 'The parsed value for the 70th interval.'; comment on column SID_MKTINPUTINTERVAL.INT071 is 'The parsed value for the 71th interval.'; comment on column SID_MKTINPUTINTERVAL.INT072 is 'The parsed value for the 72th interval.'; comment on column SID_MKTINPUTINTERVAL.INT073 is 'The parsed value for the 73th interval.'; comment on column SID_MKTINPUTINTERVAL.INT074 is 'The parsed value for the 74th interval.'; comment on column SID_MKTINPUTINTERVAL.INT075 is 'The parsed value for the 75th interval.'; comment on column SID_MKTINPUTINTERVAL.INT076 is 'The parsed value for the 76th interval.'; comment on column SID_MKTINPUTINTERVAL.INT077 is 'The parsed value for the 77th interval.'; comment on column SID_MKTINPUTINTERVAL.INT078 is 'The parsed value for the 78th interval.'; comment on column SID_MKTINPUTINTERVAL.INT079 is 'The parsed value for the 79th interval.'; comment on column SID_MKTINPUTINTERVAL.INT080 is 'The parsed value for the 80th interval.'; comment on column SID_MKTINPUTINTERVAL.INT081 is 'The parsed value for the 81th interval.'; comment on column SID_MKTINPUTINTERVAL.INT082 is 'The parsed value for the 82th interval.'; comment on column SID_MKTINPUTINTERVAL.INT083 is 'The parsed value for the 83th interval.'; comment on column SID_MKTINPUTINTERVAL.INT084 is 'The parsed value for the 84th interval.'; comment on column SID_MKTINPUTINTERVAL.INT085 is 'The parsed value for the 85th interval.'; comment on column SID_MKTINPUTINTERVAL.INT086 is 'The parsed value for the 86th interval.'; comment on column SID_MKTINPUTINTERVAL.INT087 is 'The parsed value for the 87th interval.'; comment on column SID_MKTINPUTINTERVAL.INT088 is 'The parsed value for the 88th interval.'; comment on column SID_MKTINPUTINTERVAL.INT089 is 'The parsed value for the 89th interval.'; comment on column SID_MKTINPUTINTERVAL.INT090 is 'The parsed value for the 90th interval.'; comment on column SID_MKTINPUTINTERVAL.INT091 is 'The parsed value for the 91th interval.'; comment on column SID_MKTINPUTINTERVAL.INT092 is 'The parsed value for the 92th interval.'; comment on column SID_MKTINPUTINTERVAL.INT093 is 'The parsed value for the 93th interval.'; comment on column SID_MKTINPUTINTERVAL.INT094 is 'The parsed value for the 94th interval.'; comment on column SID_MKTINPUTINTERVAL.INT095 is 'The parsed value for the 95th interval.'; comment on column SID_MKTINPUTINTERVAL.INT096 is 'The parsed value for the 96th interval.'; comment on column SID_MKTINPUTINTERVAL.INT097 is 'The parsed value for the 97th interval.'; comment on column SID_MKTINPUTINTERVAL.INT098 is 'The parsed value for the 98th interval.'; comment on column SID_MKTINPUTINTERVAL.INT099 is 'The parsed value for the 99th interval.'; comment on column SID_MKTINPUTINTERVAL.INT100 is 'The parsed value for the 100th interval.'; comment on column SID_MKTINPUTINTERVAL.LSTIME is 'The data record timestamp.'; -- Create table create table SID_MKTINPUTSCALAR ( UIDMKTINPUTHEADER NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, UOMCODE VARCHAR2(64) not null, STRINGVALUE VARCHAR2(64), VALUE FLOAT, UIDMKTINPUTSCALAR NUMBER(19) not null, LSTIME DATE ); -- Create table comment COMMENT ON TABLE SID_MKTINPUTSCALAR is 'Contains Operating Day market input non-interval data that is UNAPPROVED settlements data provided for market analysis and forecasting; this includes data received from the MMS, EMS, and CRR systems '; comment on column SID_MKTINPUTSCALAR.UIDMKTINPUTHEADER is 'The ERCOT settlement systems unique identifier for the MKTINPUTHEADER data record.'; comment on column SID_MKTINPUTSCALAR.STARTTIME is 'The starttime the data represents.'; comment on column SID_MKTINPUTSCALAR.STOPTIME is 'The stoptime the data represents through.'; comment on column SID_MKTINPUTSCALAR.UOMCODE is 'The ERCOT settlement systems unique identifier for the UOM data record.'; comment on column SID_MKTINPUTSCALAR.STRINGVALUE is ' Character value associated with the bill determinant.'; comment on column SID_MKTINPUTSCALAR.VALUE is 'Numeric value associated with the bill determinant.'; comment on column SID_MKTINPUTSCALAR.UIDMKTINPUTSCALAR is 'The ERCOT settlement systems unique identifier for the MKTINPUTSCALAR data record.'; comment on column SID_MKTINPUTSCALAR.LSTIME is 'The data record timestamp.'; -- Create table create table SID_MKTINPUTSTATUS ( UIDMKTINPUTINTERVAL NUMBER(19) not null, STARTTIME DATE not null, STOPTIME DATE not null, STATUS001 VARCHAR2(10), STATUS002 VARCHAR2(10), STATUS003 VARCHAR2(10), STATUS004 VARCHAR2(10), STATUS005 VARCHAR2(10), STATUS006 VARCHAR2(10), STATUS007 VARCHAR2(10), STATUS008 VARCHAR2(10), STATUS009 VARCHAR2(10), STATUS010 VARCHAR2(10), STATUS011 VARCHAR2(10), STATUS012 VARCHAR2(10), STATUS013 VARCHAR2(10), STATUS014 VARCHAR2(10), STATUS015 VARCHAR2(10), STATUS016 VARCHAR2(10), STATUS017 VARCHAR2(10), STATUS018 VARCHAR2(10), STATUS019 VARCHAR2(10), STATUS020 VARCHAR2(10), STATUS021 VARCHAR2(10), STATUS022 VARCHAR2(10), STATUS023 VARCHAR2(10), STATUS024 VARCHAR2(10), STATUS025 VARCHAR2(10), STATUS026 VARCHAR2(10), STATUS027 VARCHAR2(10), STATUS028 VARCHAR2(10), STATUS029 VARCHAR2(10), STATUS030 VARCHAR2(10), STATUS031 VARCHAR2(10), STATUS032 VARCHAR2(10), STATUS033 VARCHAR2(10), STATUS034 VARCHAR2(10), STATUS035 VARCHAR2(10), STATUS036 VARCHAR2(10), STATUS037 VARCHAR2(10), STATUS038 VARCHAR2(10), STATUS039 VARCHAR2(10), STATUS040 VARCHAR2(10), STATUS041 VARCHAR2(10), STATUS042 VARCHAR2(10), STATUS043 VARCHAR2(10), STATUS044 VARCHAR2(10), STATUS045 VARCHAR2(10), STATUS046 VARCHAR2(10), STATUS047 VARCHAR2(10), STATUS048 VARCHAR2(10), STATUS049 VARCHAR2(10), STATUS050 VARCHAR2(10), STATUS051 VARCHAR2(10), STATUS052 VARCHAR2(10), STATUS053 VARCHAR2(10), STATUS054 VARCHAR2(10), STATUS055 VARCHAR2(10), STATUS056 VARCHAR2(10), STATUS057 VARCHAR2(10), STATUS058 VARCHAR2(10), STATUS059 VARCHAR2(10), STATUS060 VARCHAR2(10), STATUS061 VARCHAR2(10), STATUS062 VARCHAR2(10), STATUS063 VARCHAR2(10), STATUS064 VARCHAR2(10), STATUS065 VARCHAR2(10), STATUS066 VARCHAR2(10), STATUS067 VARCHAR2(10), STATUS068 VARCHAR2(10), STATUS069 VARCHAR2(10), STATUS070 VARCHAR2(10), STATUS071 VARCHAR2(10), STATUS072 VARCHAR2(10), STATUS073 VARCHAR2(10), STATUS074 VARCHAR2(10), STATUS075 VARCHAR2(10), STATUS076 VARCHAR2(10), STATUS077 VARCHAR2(10), STATUS078 VARCHAR2(10), STATUS079 VARCHAR2(10), STATUS080 VARCHAR2(10), STATUS081 VARCHAR2(10), STATUS082 VARCHAR2(10), STATUS083 VARCHAR2(10), STATUS084 VARCHAR2(10), STATUS085 VARCHAR2(10), STATUS086 VARCHAR2(10), STATUS087 VARCHAR2(10), STATUS088 VARCHAR2(10), STATUS089 VARCHAR2(10), STATUS090 VARCHAR2(10), STATUS091 VARCHAR2(10), STATUS092 VARCHAR2(10), STATUS093 VARCHAR2(10), STATUS094 VARCHAR2(10), STATUS095 VARCHAR2(10), STATUS096 VARCHAR2(10), STATUS097 VARCHAR2(10), STATUS098 VARCHAR2(10), STATUS099 VARCHAR2(10), STATUS100 VARCHAR2(10) ); -- Create table comment COMMENT ON TABLE SID_MKTINPUTSTATUS is ' Defined INTERVAL STATUS table contains the status of each interval provided in the INTERVAL table. STATUS = ''7'' is used to designate an interval where partial missing data was used in the calculation of the resulting value. STATUS = ''9'' is used to designate a NULL (missing) interval value. This is an approved settlements data set.'; comment on column SID_MKTINPUTSTATUS.UIDMKTINPUTINTERVAL is 'The ERCOT settlement systems unique identifier for the MKTINPUTINTERVAL data record.'; comment on column SID_MKTINPUTSTATUS.STARTTIME is 'The starttime the data represents.'; comment on column SID_MKTINPUTSTATUS.STOPTIME is 'The stoptime the data represents through.'; comment on column SID_MKTINPUTSTATUS.STATUS001 is 'The parsed value for the first status.'; comment on column SID_MKTINPUTSTATUS.STATUS002 is 'The parsed value for the second status.'; comment on column SID_MKTINPUTSTATUS.STATUS003 is 'The parsed value for the third status.'; comment on column SID_MKTINPUTSTATUS.STATUS004 is 'The parsed value for the fourth status.'; comment on column SID_MKTINPUTSTATUS.STATUS005 is 'The parsed value for the fifth status.'; comment on column SID_MKTINPUTSTATUS.STATUS006 is 'The parsed value for the 6th status.'; comment on column SID_MKTINPUTSTATUS.STATUS007 is 'The parsed value for the 7th status.'; comment on column SID_MKTINPUTSTATUS.STATUS008 is 'The parsed value for the 8th status.'; comment on column SID_MKTINPUTSTATUS.STATUS009 is 'The parsed value for the 9th status.'; comment on column SID_MKTINPUTSTATUS.STATUS010 is 'The parsed value for the 10th status.'; comment on column SID_MKTINPUTSTATUS.STATUS011 is 'The parsed value for the 11th status.'; comment on column SID_MKTINPUTSTATUS.STATUS012 is 'The parsed value for the 12th status.'; comment on column SID_MKTINPUTSTATUS.STATUS013 is 'The parsed value for the 13th status.'; comment on column SID_MKTINPUTSTATUS.STATUS014 is 'The parsed value for the 14th status.'; comment on column SID_MKTINPUTSTATUS.STATUS015 is 'The parsed value for the 15th status.'; comment on column SID_MKTINPUTSTATUS.STATUS016 is 'The parsed value for the 16th status.'; comment on column SID_MKTINPUTSTATUS.STATUS017 is 'The parsed value for the 17th status.'; comment on column SID_MKTINPUTSTATUS.STATUS018 is 'The parsed value for the 18th status.'; comment on column SID_MKTINPUTSTATUS.STATUS019 is 'The parsed value for the 19th status.'; comment on column SID_MKTINPUTSTATUS.STATUS020 is 'The parsed value for the 20th status.'; comment on column SID_MKTINPUTSTATUS.STATUS021 is 'The parsed value for the 21th status.'; comment on column SID_MKTINPUTSTATUS.STATUS022 is 'The parsed value for the 22th status.'; comment on column SID_MKTINPUTSTATUS.STATUS023 is 'The parsed value for the 23th status.'; comment on column SID_MKTINPUTSTATUS.STATUS024 is 'The parsed value for the 24th status.'; comment on column SID_MKTINPUTSTATUS.STATUS025 is 'The parsed value for the 25th status.'; comment on column SID_MKTINPUTSTATUS.STATUS026 is 'The parsed value for the 26th status.'; comment on column SID_MKTINPUTSTATUS.STATUS027 is 'The parsed value for the 27th status.'; comment on column SID_MKTINPUTSTATUS.STATUS028 is 'The parsed value for the 28th status.'; comment on column SID_MKTINPUTSTATUS.STATUS029 is 'The parsed value for the 29th status.'; comment on column SID_MKTINPUTSTATUS.STATUS030 is 'The parsed value for the 30th status.'; comment on column SID_MKTINPUTSTATUS.STATUS031 is 'The parsed value for the 31th status.'; comment on column SID_MKTINPUTSTATUS.STATUS032 is 'The parsed value for the 32th status.'; comment on column SID_MKTINPUTSTATUS.STATUS033 is 'The parsed value for the 33th status.'; comment on column SID_MKTINPUTSTATUS.STATUS034 is 'The parsed value for the 34th status.'; comment on column SID_MKTINPUTSTATUS.STATUS035 is 'The parsed value for the 35th status.'; comment on column SID_MKTINPUTSTATUS.STATUS036 is 'The parsed value for the 36th status.'; comment on column SID_MKTINPUTSTATUS.STATUS037 is 'The parsed value for the 37th status.'; comment on column SID_MKTINPUTSTATUS.STATUS038 is 'The parsed value for the 38th status.'; comment on column SID_MKTINPUTSTATUS.STATUS039 is 'The parsed value for the 39th status.'; comment on column SID_MKTINPUTSTATUS.STATUS040 is 'The parsed value for the 40th status.'; comment on column SID_MKTINPUTSTATUS.STATUS041 is 'The parsed value for the 41th status.'; comment on column SID_MKTINPUTSTATUS.STATUS042 is 'The parsed value for the 42th status.'; comment on column SID_MKTINPUTSTATUS.STATUS043 is 'The parsed value for the 43th status.'; comment on column SID_MKTINPUTSTATUS.STATUS044 is 'The parsed value for the 44th status.'; comment on column SID_MKTINPUTSTATUS.STATUS045 is 'The parsed value for the 45th status.'; comment on column SID_MKTINPUTSTATUS.STATUS046 is 'The parsed value for the 46th status.'; comment on column SID_MKTINPUTSTATUS.STATUS047 is 'The parsed value for the 47th status.'; comment on column SID_MKTINPUTSTATUS.STATUS048 is 'The parsed value for the 48th status.'; comment on column SID_MKTINPUTSTATUS.STATUS049 is 'The parsed value for the 49th status.'; comment on column SID_MKTINPUTSTATUS.STATUS050 is 'The parsed value for the 50th status.'; comment on column SID_MKTINPUTSTATUS.STATUS051 is 'The parsed value for the 51th status.'; comment on column SID_MKTINPUTSTATUS.STATUS052 is 'The parsed value for the 52th status.'; comment on column SID_MKTINPUTSTATUS.STATUS053 is 'The parsed value for the 53th status.'; comment on column SID_MKTINPUTSTATUS.STATUS054 is 'The parsed value for the 54th status.'; comment on column SID_MKTINPUTSTATUS.STATUS055 is 'The parsed value for the 55th status.'; comment on column SID_MKTINPUTSTATUS.STATUS056 is 'The parsed value for the 56th status.'; comment on column SID_MKTINPUTSTATUS.STATUS057 is 'The parsed value for the 57th status.'; comment on column SID_MKTINPUTSTATUS.STATUS058 is 'The parsed value for the 58th status.'; comment on column SID_MKTINPUTSTATUS.STATUS059 is 'The parsed value for the 59th status.'; comment on column SID_MKTINPUTSTATUS.STATUS060 is 'The parsed value for the 60th status.'; comment on column SID_MKTINPUTSTATUS.STATUS061 is 'The parsed value for the 61th status.'; comment on column SID_MKTINPUTSTATUS.STATUS062 is 'The parsed value for the 62th status.'; comment on column SID_MKTINPUTSTATUS.STATUS063 is 'The parsed value for the 63th status.'; comment on column SID_MKTINPUTSTATUS.STATUS064 is 'The parsed value for the 64th status.'; comment on column SID_MKTINPUTSTATUS.STATUS065 is 'The parsed value for the 65th status.'; comment on column SID_MKTINPUTSTATUS.STATUS066 is 'The parsed value for the 66th status.'; comment on column SID_MKTINPUTSTATUS.STATUS067 is 'The parsed value for the 67th status.'; comment on column SID_MKTINPUTSTATUS.STATUS068 is 'The parsed value for the 68th status.'; comment on column SID_MKTINPUTSTATUS.STATUS069 is 'The parsed value for the 69th status.'; comment on column SID_MKTINPUTSTATUS.STATUS070 is 'The parsed value for the 70th status.'; comment on column SID_MKTINPUTSTATUS.STATUS071 is 'The parsed value for the 71th status.'; comment on column SID_MKTINPUTSTATUS.STATUS072 is 'The parsed value for the 72th status.'; comment on column SID_MKTINPUTSTATUS.STATUS073 is 'The parsed value for the 73th status.'; comment on column SID_MKTINPUTSTATUS.STATUS074 is 'The parsed value for the 74th status.'; comment on column SID_MKTINPUTSTATUS.STATUS075 is 'The parsed value for the 75th status.'; comment on column SID_MKTINPUTSTATUS.STATUS076 is 'The parsed value for the 76th status.'; comment on column SID_MKTINPUTSTATUS.STATUS077 is 'The parsed value for the 77th status.'; comment on column SID_MKTINPUTSTATUS.STATUS078 is 'The parsed value for the 78th status.'; comment on column SID_MKTINPUTSTATUS.STATUS079 is 'The parsed value for the 79th status.'; comment on column SID_MKTINPUTSTATUS.STATUS080 is 'The parsed value for the 80th status.'; comment on column SID_MKTINPUTSTATUS.STATUS081 is 'The parsed value for the 81th status.'; comment on column SID_MKTINPUTSTATUS.STATUS082 is 'The parsed value for the 82th status.'; comment on column SID_MKTINPUTSTATUS.STATUS083 is 'The parsed value for the 83th status.'; comment on column SID_MKTINPUTSTATUS.STATUS084 is 'The parsed value for the 84th status.'; comment on column SID_MKTINPUTSTATUS.STATUS085 is 'The parsed value for the 85th status.'; comment on column SID_MKTINPUTSTATUS.STATUS086 is 'The parsed value for the 86th status.'; comment on column SID_MKTINPUTSTATUS.STATUS087 is 'The parsed value for the 87th status.'; comment on column SID_MKTINPUTSTATUS.STATUS088 is 'The parsed value for the 88th status.'; comment on column SID_MKTINPUTSTATUS.STATUS089 is 'The parsed value for the 89th status.'; comment on column SID_MKTINPUTSTATUS.STATUS090 is 'The parsed value for the 90th status.'; comment on column SID_MKTINPUTSTATUS.STATUS091 is 'The parsed value for the 91th status.'; comment on column SID_MKTINPUTSTATUS.STATUS092 is 'The parsed value for the 92th status.'; comment on column SID_MKTINPUTSTATUS.STATUS093 is 'The parsed value for the 93th status.'; comment on column SID_MKTINPUTSTATUS.STATUS094 is 'The parsed value for the 94th status.'; comment on column SID_MKTINPUTSTATUS.STATUS095 is 'The parsed value for the 95th status.'; comment on column SID_MKTINPUTSTATUS.STATUS096 is 'The parsed value for the 96th status.'; comment on column SID_MKTINPUTSTATUS.STATUS097 is 'The parsed value for the 97th status.'; comment on column SID_MKTINPUTSTATUS.STATUS098 is 'The parsed value for the 98th status.'; comment on column SID_MKTINPUTSTATUS.STATUS099 is 'The parsed value for the 99th status.'; comment on column SID_MKTINPUTSTATUS.STATUS100 is 'The parsed value for the 100th status.'; -- Create table create table TELEMETERRESSTATUS ( QSECODE VARCHAR2(64) not null, TRANSITIONTIME DATE not null, STATUS NUMBER(1) not null, UIDRESOURCE NUMBER(19) not null, LSTIME DATE, DSTADJHOUR VARCHAR2(8), CSTTRANSITIONTIME DATE ); -- Create table comment COMMENT ON TABLE TELEMETERRESSTATUS is 'Table that provides the telemetered resource status for each resource based on when that resource comes online, "ON", or goes offline, "OFF". '; comment on column TELEMETERRESSTATUS.QSECODE is 'The ERCOT settlement systems code associated to a QSE.'; comment on column TELEMETERRESSTATUS.TRANSITIONTIME is '.The time at which the Resource transitioned from one resource status to another, as indicated by telemetry'; comment on column TELEMETERRESSTATUS.STATUS is 'Indicates if the resources telemetered status is considered to be in an offline state or an online state. STATUS value of 1 indicates "ONLINE" and STATUS value of 0 indicates "OFFLINE"'; comment on column TELEMETERRESSTATUS.UIDRESOURCE is 'The ERCOT settlement systems unique identifier for the RESOURCE data record.'; comment on column TELEMETERRESSTATUS.LSTIME is 'The data record timestamp.'; comment on column TELEMETERRESSTATUS.DSTADJHOUR is 'Indicates if the transition occurred during the DST repeat hour.'; comment on column TELEMETERRESSTATUS.CSTTRANSITIONTIME is 'TRANSITIONTIME converted to CST'; -- Create table create table CCTRANSITION ( AFTEROFFER FLOAT(52) , AFTERPROCESS VARCHAR2(64), AFTERUIDCONFIG NUMBER(19), BEFOREOFFER FLOAT(52), BEFOREPROCESS VARCHAR2(64), BEFOREUIDCONFIG NUMBER(19), DAMCONTIG NUMBER(10), GENCODE VARCHAR2(64) NOT NULL, INTERVAL NUMBER(10), LSTIME DATE, QSECODE VARCHAR2(64) NOT NULL, TRANSITIONTIME DATE NOT NULL, UIDSTATEMENTSCHED NUMBER(19) NOT NULL ); COMMENT ON TABLE CCTRANSITION is 'Table identifies when the CC Train transitioned from a DAM/SELF/RUC commitment in one configuration to a RUC commitment in a different configuration'; comment on column CCTRANSITION.AFTEROFFER is 'The start up offer associated with the after configuration that is eligible for a start up transition payment'; comment on column CCTRANSITION.AFTERPROCESS is 'The process that committed the after configuration that is eligible for a start up transition payment'; comment on column CCTRANSITION.AFTERUIDCONFIG is 'Unique identifier for the after configuration that is eligible for a start up transition payment'; comment on column CCTRANSITION.BEFOREOFFER is 'The start up offer associated with the before configuration that is eligible for a start up transition payment'; comment on column CCTRANSITION.BEFOREPROCESS is 'The process that committed the before configuration that is eligible for a start up transition payment'; comment on column CCTRANSITION.BEFOREUIDCONFIG is 'Unique identifier for the before configuration that is eligible for a start up transition payment'; comment on column CCTRANSITION.DAMCONTIG is 'Is the transition contiguous to a DAM commitment? Yes or No'; comment on column CCTRANSITION.GENCODE is 'The ERCOT settlement systems code associated to a GENERATOR.'; comment on column CCTRANSITION.INTERVAL is 'The hourly interval that the eligible tranisition occurred'; comment on column CCTRANSITION.LSTIME is 'The data record timestamp.'; comment on column CCTRANSITION.QSECODE is 'The ERCOT settlement systems code associated to a QSE.'; comment on column CCTRANSITION.TRANSITIONTIME is 'The time that the telemetered value changed from one status to another'; comment on column CCTRANSITION.UIDSTATEMENTSCHED is 'The unique identifier for the STATEMENTSCHED data record for ERCOT internal use to manage the settlement run and approval process.'; --create table CREATE TABLE SID_VERIFIABLECOSTS ( UIDVERIFIABLECOSTS NUMBER(19,0), UIDBILLDETERMINANT NUMBER(5,0), QSECODE VARCHAR2(64), UIDRESOURCE NUMBER(19,0), STARTTYPE NUMBER(10,0), STARTTIME DATE, STOPTIME DATE, STRINGVALUE VARCHAR2(64), VALUE FLOAT(52), LSTIME DATE ); COMMENT ON TABLE SID_VERIFIABLECOSTS is 'Verifiable cost table associated with approved Resource Startup and operations at Minimum Energy'; comment on column SID_VERIFIABLECOSTS.UIDVERIFIABLECOSTS is 'System assigned number for QSE/Resource with approved Verifiable Costs'; comment on column SID_VERIFIABLECOSTS.UIDBILLDETERMINANT is 'Approved Verifiable Costs for the following bill determinants: AFCRS, GASPERSU, OILPERSU, SFPERSU, VOMS, VFCLSL, GASPERME, OILPERME, SFPERME, VOMLSL, GASPEROL, OILPEROL, SFPEROL'; comment on column SID_VERIFIABLECOSTS.QSECODE is 'QSE code of the QSE with approved Verifiable Costs'; comment on column SID_VERIFIABLECOSTS.UIDRESOURCE is 'Resource code for the Resource with approved Verifiable Costs'; comment on column SID_VERIFIABLECOSTS.STARTTYPE is 'One of the following: Hot: 1, Intermediate: 2, or Cold: 3'; comment on column SID_VERIFIABLECOSTS.STARTTIME is 'The effective date of the approved Verfiable Costs'; comment on column SID_VERIFIABLECOSTS.STOPTIME is 'The last effective date of the approved Verfiable Costs'; comment on column SID_VERIFIABLECOSTS.STRINGVALUE is 'null'; comment on column SID_VERIFIABLECOSTS.VALUE is 'Approved Verifiable Cost value'; comment on column SID_VERIFIABLECOSTS.LSTIME is 'The data record timestamp'; --Create table CREATE TABLE SID_VCHEATRATECURVE ( UIDRESOURCE NUMBER(19,0), STARTTIME DATE, STOPTIME DATE, NUMHRPOINTS NUMBER(4,0), HRATEBP1 NUMBER(8,2), HRATESLP1 NUMBER(8,2), HRATEBP2 NUMBER(8,2), HRATESLP2 NUMBER(8,2), HRATEBP3 NUMBER(8,2), HRATESLP3 NUMBER(8,2), HRATEBP4 NUMBER(8,2), HRATESLP4 NUMBER(8,2), HRATEBP5 NUMBER(8,2), HRATESLP5 NUMBER(8,2), HRATEBP6 NUMBER(8,2), HRATESLP6 NUMBER(8,2), HRATEBP7 NUMBER(8,2), HRATESLP7 NUMBER(8,2), HRATEBP8 NUMBER(8,2), HRATESLP8 NUMBER(8,2), HRATEBP9 NUMBER(8,2), HRATESLP9 NUMBER(8,2), HRATEBP10 NUMBER(8,2), HRATESLP10 NUMBER(8,2), NUMOMPOINTS NUMBER(4,0), OMBP1 NUMBER(8,2), OMSLP1 NUMBER(8,2), OMBP2 NUMBER(8,2), OMSLP2 NUMBER(8,2), OMBP3 NUMBER(8,2), OMSLP3 NUMBER(8,2), OMBP4 NUMBER(8,2), OMSLP4 NUMBER(8,2), OMBP5 NUMBER(8,2), OMSLP5 NUMBER(8,2), OMBP6 NUMBER(8,2), OMSLP6 NUMBER(8,2), OMBP7 NUMBER(8,2), OMSLP7 NUMBER(8,2), OMBP8 NUMBER(8,2), OMSLP8 NUMBER(8,2), OMBP9 NUMBER(8,2), OMSLP9 NUMBER(8,2), OMBP10 NUMBER(8,2), OMSLP10 NUMBER(8,2), LSTIME DATE ); COMMENT ON TABLE SID_VCHEATRATECURVE is 'Approved incremental heat rates and variable O&M above LSL'; comment on column SID_VCHEATRATECURVE.UIDRESOURCE is 'Resource code for the Resource with approved Verifiable Costs'; comment on column SID_VCHEATRATECURVE.STARTTIME is 'The effective date of the approved Verifiable Costs Heat Rate Curve and/or O&M above LSL'; comment on column SID_VCHEATRATECURVE.STOPTIME is 'The last effective date of the approved Verifiable Costs Heat Rate Curve and/or O&M above LSL'; comment on column SID_VCHEATRATECURVE.NUMHRPOINTS is 'The number of points on the approved Heat Rate Curve'; comment on column SID_VCHEATRATECURVE.HRATEBP1 is 'MW point of first Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATESLP1 is 'Incremental Heat Rate of the first Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATEBP2 is 'MW point of second Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATESLP2 is 'Incremental Heat Rate of the second Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATEBP3 is 'MW point of third Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATESLP3 is 'Incremental Heat Rate of the third Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATEBP4 is 'MW point of fourth Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATESLP4 is 'Incremental Heat Rate of the fourth Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATEBP5 is 'MW point of fifth Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATESLP5 is 'Incremental Heat Rate of the fifth Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATEBP6 is 'MW point of sixth Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATESLP6 is 'Incremental Heat Rate of the sixth Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATEBP7 is 'MW point of seventh Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATESLP7 is 'Incremental Heat Rate of the seventh Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATEBP8 is 'MW point of eighth Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATESLP8 is 'Incremental Heat Rate of the eighth Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATEBP9 is 'MW point of ninth Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATESLP9 is 'Incremental Heat Rate of the ninth Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATEBP10 is 'MW point of tenth Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.HRATESLP10 is 'Incremental Heat Rate of the tenth Heat Rate Curve output level'; comment on column SID_VCHEATRATECURVE.NUMOMPOINTS is 'Number of points on the O&M curve'; comment on column SID_VCHEATRATECURVE.OMBP1 is 'MW point of first O&M Curve output level'; comment on column SID_VCHEATRATECURVE.OMSLP1 is 'O&M value above LSL'; comment on column SID_VCHEATRATECURVE.OMBP2 is 'MW point of second O&M Curve output level'; comment on column SID_VCHEATRATECURVE.OMSLP2 is 'O&M value above LSL'; comment on column SID_VCHEATRATECURVE.OMBP3 is 'MW point of third O&M Curve output level'; comment on column SID_VCHEATRATECURVE.OMSLP3 is 'O&M value above LSL'; comment on column SID_VCHEATRATECURVE.OMBP4 is 'MW point of fourth O&M Curve output level'; comment on column SID_VCHEATRATECURVE.OMSLP4 is 'O&M value above LSL'; comment on column SID_VCHEATRATECURVE.OMBP5 is 'MW point of fifth O&M Curve output level'; comment on column SID_VCHEATRATECURVE.OMSLP5 is 'O&M value above LSL'; comment on column SID_VCHEATRATECURVE.OMBP6 is 'MW point of sixth O&M Curve output level'; comment on column SID_VCHEATRATECURVE.OMSLP6 is 'O&M value above LSL'; comment on column SID_VCHEATRATECURVE.OMBP7 is 'MW point of seventh O&M Curve output level'; comment on column SID_VCHEATRATECURVE.OMSLP7 is 'O&M value above LSL'; comment on column SID_VCHEATRATECURVE.OMBP8 is 'MW point of eighth O&M Curve output level'; comment on column SID_VCHEATRATECURVE.OMSLP8 is 'O&M value above LSL'; comment on column SID_VCHEATRATECURVE.OMBP9 is 'MW point of ninth O&M Curve output level'; comment on column SID_VCHEATRATECURVE.OMSLP9 is 'O&M value above LSL'; comment on column SID_VCHEATRATECURVE.OMBP10 is 'MW point of tenth O&M Curve output level'; comment on column SID_VCHEATRATECURVE.OMSLP10 is 'O&M value above LSL'; comment on column SID_VCHEATRATECURVE.LSTIME is 'The data record timestamp'; -- Create/Recreate primary, unique and foreign key constraints alter table AGGOUTPUTHEADER add constraint PK_AGGOUTHD primary key (UIDAGGOUTPUTHEADER); alter table AGGOUTPUTINTERVAL add constraint PK_AGGOUTIN primary key (UIDAGGOUTPUTINTERVAL); alter table AGGOUTPUTINTERVAL add constraint FK_AGGOUTIN_AGGOUTHD foreign key (UIDAGGOUTPUTHEADER) references AGGOUTPUTHEADER (UIDAGGOUTPUTHEADER) on delete cascade; alter table AGGOUTPUTSCALAR add constraint PK_AGGOUTSC primary key (UIDAGGOUTPUTSCALAR); alter table AGGOUTPUTSCALAR add constraint FK_AGGOUTSC_AGGOUTHD foreign key (UIDAGGOUTPUTHEADER) references AGGOUTPUTHEADER (UIDAGGOUTPUTHEADER) on delete cascade; -- Create/Recreate primary, unique and foreign key constraints alter table CCTELEMETERSTATUS add constraint PK_CCTELST primary key (QSECODE, GENCODE, CSTTRANSITIONTIME); -- alter table CRROUTPUTHEADER add constraint PK_CRROUTHD primary key (UIDCRROUTPUTHEADER); alter table CRROUTPUTINTERVAL add constraint PK_CRROUTIN primary key (UIDCRROUTPUTINTERVAL); alter table CRROUTPUTINTERVAL add constraint FK_CRROUTIN_CRROUTHD foreign key (UIDCRROUTPUTHEADER) references CRROUTPUTHEADER (UIDCRROUTPUTHEADER) on delete cascade; alter table CRROUTPUTSCALAR add constraint PK_CRROUTSC primary key (UIDCRROUTPUTSCALAR); alter table CRROUTPUTSCALAR add constraint FK_CRROUTSC_CRROUTHD foreign key (UIDCRROUTPUTHEADER) references CRROUTPUTHEADER (UIDCRROUTPUTHEADER) on delete cascade; -- alter table DAMOUTPUTHEADER add constraint PK_DAOUTHDR primary key (UIDDAMOUTPUTHEADER); alter table DAMOUTPUTINTERVAL add constraint PK_DAMOUTIN primary key (UIDDAMOUTPUTINTERVAL); alter table DAMOUTPUTINTERVAL add constraint FK_DAMOUTIN_DAOUTHDR foreign key (UIDDAMOUTPUTHEADER) references DAMOUTPUTHEADER (UIDDAMOUTPUTHEADER) on delete cascade; -- alter table MKTINPUTHEADER add constraint PK_MKTINHDR primary key (UIDMKTINPUTHEADER); alter table MKTINPUTINTERVAL add constraint PK_MKTININT primary key (UIDMKTINPUTINTERVAL); alter table MKTINPUTINTERVAL add constraint FK_MKTININT_MKTINHDR foreign key (UIDMKTINPUTHEADER) references MKTINPUTHEADER (UIDMKTINPUTHEADER) on delete cascade; alter table MKTINPUTSCALAR add constraint PK_MKTINSC primary key (UIDMKTINPUTSCALAR); alter table MKTINPUTSCALAR add constraint FK_MKTINSC_MKTINHDR foreign key (UIDMKTINPUTHEADER) references MKTINPUTHEADER (UIDMKTINPUTHEADER) on delete cascade; alter table MKTINPUTSTATUS add constraint FK_MKTINSTTS_MKTININT foreign key (UIDMKTINPUTINTERVAL) references MKTINPUTINTERVAL (UIDMKTINPUTINTERVAL) on delete cascade; -- alter table PREPROCESSHEADER add constraint PK_PRPROCHD primary key (UIDPREPROCHEADER); alter table PREPROCESSINTERVAL add constraint PK_PRPROCIN primary key (UIDPREPROCINTVAL); alter table PREPROCESSINTERVAL add constraint FK_PRPROCIN_PRPROCHD foreign key (UIDPREPROCHEADER) references PREPROCESSHEADER (UIDPREPROCHEADER) on delete cascade; alter table PREPROCESSSTATUS add constraint FK_PRPROCSTTS_PRPROCIN foreign key (UIDPREPROCINTVAL) references PREPROCESSINTERVAL (UIDPREPROCINTVAL) on delete cascade; -- alter table RTMOUTPUTHEADER add constraint PK_RTMOUHDR primary key (UIDRTMOUTPUTHEADER); alter table RTMOUTPUTINTERVAL add constraint PK_RTMOUTIN primary key (UIDRTMOUTPUTINTERVAL); alter table RTMOUTPUTINTERVAL add constraint FK_RTMOUTIN_RTMOUHDR foreign key (UIDRTMOUTPUTHEADER) references RTMOUTPUTHEADER (UIDRTMOUTPUTHEADER) on delete cascade; alter table RTMOUTPUTSCALAR add constraint PK_RTMOUTSC primary key (UIDRTMOUTPUTSCALAR); alter table RTMOUTPUTSCALAR add constraint FK_RTMOUTSC_RTMOUHDR foreign key (UIDRTMOUTPUTHEADER) references RTMOUTPUTHEADER (UIDRTMOUTPUTHEADER) on delete cascade; alter table RTMOUTPUTSTATUS add constraint FK_RTMOUTSTTS_RTMOUTIN foreign key (UIDRTMOUTPUTINTERVAL) references RTMOUTPUTINTERVAL (UIDRTMOUTPUTINTERVAL) on delete cascade; -- alter table RUCOUTPUTHEADER add constraint PK_RUCOUTHD primary key (UIDRUCOUTPUTHEADER); alter table RUCOUTPUTINTERVAL add constraint PK_RUCOUTIN primary key (UIDRUCOUTPUTINTERVAL); alter table RUCOUTPUTINTERVAL add constraint FK_RUCOUTIN_RUCOUTHD foreign key (UIDRUCOUTPUTHEADER) references RUCOUTPUTHEADER (UIDRUCOUTPUTHEADER) on delete cascade; alter table RUCOUTPUTSCALAR add constraint PK_RUCOUTSC primary key (UIDRUCOUTPUTSCALAR); alter table RUCOUTPUTSCALAR add constraint FK_RUCOUTSC_RUCOUTHD foreign key (UIDRUCOUTPUTHEADER) references RUCOUTPUTHEADER (UIDRUCOUTPUTHEADER) on delete cascade; alter table RUCOUTPUTSTATUS add constraint FK_RUCOUTSTTS_RUCOUTINT foreign key (UIDRUCOUTPUTINTERVAL) references RUCOUTPUTINTERVAL (UIDRUCOUTPUTINTERVAL) on delete cascade; -- alter table LLSOUTPUTHEADER add constraint PK_LLSOUTHD primary key (UIDLLSOUTPUTHEADER); alter table LLSOUTPUTINTERVAL add constraint PK_LLSOUTIN primary key (UIDLLSOUTPUTINTERVAL); alter table LLSOUTPUTINTERVAL add constraint FK_LLSOUTIN_LLSOUTHD foreign key (UIDLLSOUTPUTHEADER) references LLSOUTPUTHEADER (UIDLLSOUTPUTHEADER) on delete cascade; -- alter table SID_MKTINPUTHEADER add constraint PK_MKTINHDR_SID primary key (UIDMKTINPUTHEADER); alter table SID_MKTINPUTINTERVAL add constraint PK_MKTININT_SID primary key (UIDMKTINPUTINTERVAL); alter table SID_MKTINPUTINTERVAL add constraint FK_MKTININT_MKTINHDR_SID foreign key (UIDMKTINPUTHEADER) references SID_MKTINPUTHEADER (UIDMKTINPUTHEADER) on delete cascade; -- alter table SID_MKTINPUTSCALAR add constraint PK_MKTINSC_SID primary key (UIDMKTINPUTSCALAR); alter table SID_MKTINPUTSCALAR add constraint FK_MKTINSC_MKTINHDR_SID foreign key (UIDMKTINPUTHEADER) references SID_MKTINPUTHEADER (UIDMKTINPUTHEADER) on delete cascade; alter table SID_MKTINPUTSTATUS add constraint FK_MKTINSTTS_MKTININT_SID foreign key (UIDMKTINPUTINTERVAL) references SID_MKTINPUTINTERVAL (UIDMKTINPUTINTERVAL) on delete cascade; -- alter table DAIOUTPUTHEADER add constraint PK_DAIOUTHD primary key (UIDDAIOUTPUTHEADER); alter table DAIOUTPUTINTERVAL add constraint PK_DAIOUTIN primary key (UIDDAIOUTPUTINTERVAL); alter table DAIOUTPUTINTERVAL add constraint FK_DAIOUTIN_DAIOUTHD foreign key (UIDDAIOUTPUTHEADER) references DAIOUTPUTHEADER (UIDDAIOUTPUTHEADER) on delete cascade; -- alter table TELEMETERRESSTATUS add constraint PK_TELRESST primary key (QSECODE, UIDRESOURCE, TRANSITIONTIME); alter table CCTRANSITION add constraint PK_CCTRSTN primary key (GENCODE, TRANSITIONTIME, UIDSTATEMENTSCHED);