Each measurement is given an Id and queries are assigned to them Queries will have placeholders for time range Measurement Id will not have spaces
| id | name | query_string | date_type |
|---|---|---|---|
| 1 | WR_DAY_PEAK_DEMAND | select date_key, peak_demand_met from REPORTING_UAT.regional_availability_demand where date_key between {start_time} and {end_time} order by date_key | date_key |
| 2 | WR_DAY_PEAK_SHORTAGE | select date_key, peak_shortage from REPORTING_UAT.regional_availability_demand where date_key between {start_time} and {end_time} order by date_key | date_key |
| 3 | WR_DAY_PEAK_REQUIREMENT | select date_key, peak_requirement from REPORTING_UAT.regional_availability_demand where date_key between {start_time} and {end_time} order by date_key | date_key |
| 4 | WR_DAY_PEAK_FREQ | select date_key, peak_freq from REPORTING_UAT.regional_availability_demand where date_key between {start_time} and {end_time} order by date_key | date_key |
| 5 | WR_DAY_OFF_PEAK_DEMAND | select date_key, off_peak_demand_met from REPORTING_UAT.regional_availability_demand where date_key between {start_time} and {end_time} order by date_key | date_key |
| 6 | WR_DAY_OFF_PEAK_SHORTAGE | select date_key, off_peak_shortage from REPORTING_UAT.regional_availability_demand where date_key between {start_time} and {end_time} order by date_key | date_key |
| 7 | WR_DAY_OFF_PEAK_REQUIREMENT | select date_key, off_peak_requirement from REPORTING_UAT.regional_availability_demand where date_key between {start_time} and {end_time} order by date_key | date_key |
| 8 | WR_DAY_OFF_PEAK_FREQ | select date_key, off_peak_freq from REPORTING_UAT.regional_availability_demand where date_key between {start_time} and {end_time} order by date_key | date_key |
| 9 | WR_DAY_DEMAND_MET_MU | select date_key, day_energy_demand_met from REPORTING_UAT.regional_availability_demand where date_key between {start_time} and {end_time} order by date_key | date_key |
| 10 | WR_DAY_SHORTAGE_MU | select date_key, day_energy_shortage from REPORTING_UAT.regional_availability_demand where date_key between {start_time} and {end_time} order by date_key | date_key |
| 11 | WR_DAY_MAX_DEMAND | select date_key, max_demand from REPORTING_UAT.state_demand_requirement where state_name='WR' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 12 | WR_DAY_SHORTAGE_AT_MAX_DEMAND | select date_key, max_demand_shortage from REPORTING_UAT.state_demand_requirement where state_name='WR' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 13 | WR_DAY_REQUIREMENT_AT_MAX_DEMAND | select date_key, max_demand_requirement from REPORTING_UAT.state_demand_requirement where state_name='WR' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 14 | WR_DAY_DEMAND_AT_MAX_REQUIREMENT | select date_key, demand_met_max_requirement from REPORTING_UAT.state_demand_requirement where state_name='WR' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 15 | WR_DAY_SHORTAGE_AT_MAX_REQUIREMENT | select date_key, max_requirement_shortage from REPORTING_UAT.state_demand_requirement where state_name='WR' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 16 | WR_DAY_MAX_REQUIREMENT | select date_key, max_requirement from REPORTING_UAT.state_demand_requirement where state_name='WR' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 17 | DNH_DAY_MAX_DEMAND | select date_key, max_demand from REPORTING_UAT.state_demand_requirement where state_name='DNH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 18 | DNH_DAY_SHORTAGE_AT_MAX_DEMAND | select date_key, max_demand_shortage from REPORTING_UAT.state_demand_requirement where state_name='DNH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 19 | DNH_DAY_REQUIREMENT_AT_MAX_DEMAND | select date_key, max_demand_requirement from REPORTING_UAT.state_demand_requirement where state_name='DNH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 20 | DNH_DAY_DEMAND_AT_MAX_REQUIREMENT | select date_key, demand_met_max_requirement from REPORTING_UAT.state_demand_requirement where state_name='DNH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 21 | DNH_DAY_SHORTAGE_AT_MAX_REQUIREMENT | select date_key, max_requirement_shortage from REPORTING_UAT.state_demand_requirement where state_name='DNH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 22 | DNH_DAY_MAX_REQUIREMENT | select date_key, max_requirement from REPORTING_UAT.state_demand_requirement where state_name='DNH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 23 | DD_DAY_MAX_DEMAND | select date_key, max_demand from REPORTING_UAT.state_demand_requirement where state_name='DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 24 | DD_DAY_SHORTAGE_AT_MAX_DEMAND | select date_key, max_demand_shortage from REPORTING_UAT.state_demand_requirement where state_name='DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 25 | DD_DAY_REQUIREMENT_AT_MAX_DEMAND | select date_key, max_demand_requirement from REPORTING_UAT.state_demand_requirement where state_name='DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 26 | DD_DAY_DEMAND_AT_MAX_REQUIREMENT | select date_key, demand_met_max_requirement from REPORTING_UAT.state_demand_requirement where state_name='DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 27 | DD_DAY_SHORTAGE_AT_MAX_REQUIREMENT | select date_key, max_requirement_shortage from REPORTING_UAT.state_demand_requirement where state_name='DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 28 | DD_DAY_MAX_REQUIREMENT | select date_key, max_requirement from REPORTING_UAT.state_demand_requirement where state_name='DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 29 | ESIL_DAY_MAX_DEMAND | select date_key, max_demand from REPORTING_UAT.state_demand_requirement where state_name='ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 30 | ESIL_DAY_SHORTAGE_AT_MAX_DEMAND | select date_key, max_demand_shortage from REPORTING_UAT.state_demand_requirement where state_name='ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 31 | ESIL_DAY_REQUIREMENT_AT_MAX_DEMAND | select date_key, max_demand_requirement from REPORTING_UAT.state_demand_requirement where state_name='ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 32 | ESIL_DAY_DEMAND_AT_MAX_REQUIREMENT | select date_key, demand_met_max_requirement from REPORTING_UAT.state_demand_requirement where state_name='ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 33 | ESIL_DAY_SHORTAGE_AT_MAX_REQUIREMENT | select date_key, max_requirement_shortage from REPORTING_UAT.state_demand_requirement where state_name='ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 34 | ESIL_DAY_MAX_REQUIREMENT | select date_key, max_requirement from REPORTING_UAT.state_demand_requirement where state_name='ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 35 | GUJARAT_DAY_MAX_DEMAND | select date_key, max_demand from REPORTING_UAT.state_demand_requirement where state_name='GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 36 | GUJARAT_DAY_SHORTAGE_AT_MAX_DEMAND | select date_key, max_demand_shortage from REPORTING_UAT.state_demand_requirement where state_name='GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 37 | GUJARAT_DAY_REQUIREMENT_AT_MAX_DEMAND | select date_key, max_demand_requirement from REPORTING_UAT.state_demand_requirement where state_name='GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 38 | GUJARAT_DAY_DEMAND_AT_MAX_REQUIREMENT | select date_key, demand_met_max_requirement from REPORTING_UAT.state_demand_requirement where state_name='GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 39 | GUJARAT_DAY_SHORTAGE_AT_MAX_REQUIREMENT | select date_key, max_requirement_shortage from REPORTING_UAT.state_demand_requirement where state_name='GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 40 | GUJARAT_DAY_MAX_REQUIREMENT | select date_key, max_requirement from REPORTING_UAT.state_demand_requirement where state_name='GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 41 | GOA_DAY_MAX_DEMAND | select date_key, max_demand from REPORTING_UAT.state_demand_requirement where state_name='GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 42 | GOA_DAY_SHORTAGE_AT_MAX_DEMAND | select date_key, max_demand_shortage from REPORTING_UAT.state_demand_requirement where state_name='GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 43 | GOA_DAY_REQUIREMENT_AT_MAX_DEMAND | select date_key, max_demand_requirement from REPORTING_UAT.state_demand_requirement where state_name='GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 44 | GOA_DAY_DEMAND_AT_MAX_REQUIREMENT | select date_key, demand_met_max_requirement from REPORTING_UAT.state_demand_requirement where state_name='GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 45 | GOA_DAY_SHORTAGE_AT_MAX_REQUIREMENT | select date_key, max_requirement_shortage from REPORTING_UAT.state_demand_requirement where state_name='GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 46 | GOA_DAY_MAX_REQUIREMENT | select date_key, max_requirement from REPORTING_UAT.state_demand_requirement where state_name='GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 47 | CHHATISGARH_DAY_MAX_DEMAND | select date_key, max_demand from REPORTING_UAT.state_demand_requirement where state_name='CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 48 | CHHATISGARH_DAY_SHORTAGE_AT_MAX_DEMAND | select date_key, max_demand_shortage from REPORTING_UAT.state_demand_requirement where state_name='CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 49 | CHHATISGARH_DAY_REQUIREMENT_AT_MAX_DEMAND | select date_key, max_demand_requirement from REPORTING_UAT.state_demand_requirement where state_name='CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 50 | CHHATISGARH_DAY_DEMAND_AT_MAX_REQUIREMENT | select date_key, demand_met_max_requirement from REPORTING_UAT.state_demand_requirement where state_name='CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 51 | CHHATISGARH_DAY_SHORTAGE_AT_MAX_REQUIREMENT | select date_key, max_requirement_shortage from REPORTING_UAT.state_demand_requirement where state_name='CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 52 | CHHATISGARH_DAY_MAX_REQUIREMENT | select date_key, max_requirement from REPORTING_UAT.state_demand_requirement where state_name='CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 53 | MAH_DAY_MAX_DEMAND | select date_key, max_demand from REPORTING_UAT.state_demand_requirement where state_name='MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 54 | MAH_DAY_SHORTAGE_AT_MAX_DEMAND | select date_key, max_demand_shortage from REPORTING_UAT.state_demand_requirement where state_name='MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 55 | MAH_DAY_REQUIREMENT_AT_MAX_DEMAND | select date_key, max_demand_requirement from REPORTING_UAT.state_demand_requirement where state_name='MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 56 | MAH_DAY_DEMAND_AT_MAX_REQUIREMENT | select date_key, demand_met_max_requirement from REPORTING_UAT.state_demand_requirement where state_name='MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 57 | MAH_DAY_SHORTAGE_AT_MAX_REQUIREMENT | select date_key, max_requirement_shortage from REPORTING_UAT.state_demand_requirement where state_name='MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 58 | MAH_DAY_MAX_REQUIREMENT | select date_key, max_requirement from REPORTING_UAT.state_demand_requirement where state_name='MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 59 | MP_DAY_MAX_DEMAND | select date_key, max_demand from REPORTING_UAT.state_demand_requirement where state_name='MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 60 | MP_DAY_SHORTAGE_AT_MAX_DEMAND | select date_key, max_demand_shortage from REPORTING_UAT.state_demand_requirement where state_name='MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 61 | MP_DAY_REQUIREMENT_AT_MAX_DEMAND | select date_key, max_demand_requirement from REPORTING_UAT.state_demand_requirement where state_name='MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 62 | MP_DAY_DEMAND_AT_MAX_REQUIREMENT | select date_key, demand_met_max_requirement from REPORTING_UAT.state_demand_requirement where state_name='MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 63 | MP_DAY_SHORTAGE_AT_MAX_REQUIREMENT | select date_key, max_requirement_shortage from REPORTING_UAT.state_demand_requirement where state_name='MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 64 | MP_DAY_MAX_REQUIREMENT | select date_key, max_requirement from REPORTING_UAT.state_demand_requirement where state_name='MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 65 | GUJARAT_DAY_THERMAL_MU | SELECT date_key, thermal FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 66 | MAH_DAY_THERMAL_MU | SELECT date_key, thermal FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 67 | ESIL_DAY_THERMAL_MU | SELECT date_key, thermal FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 68 | DD_DAY_THERMAL_MU | SELECT date_key, thermal FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 69 | MP_DAY_THERMAL_MU | SELECT date_key, thermal FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 70 | DNH_DAY_THERMAL_MU | SELECT date_key, thermal FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 71 | CHHATISGARH_DAY_THERMAL_MU | SELECT date_key, thermal FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 72 | GOA_DAY_THERMAL_MU | SELECT date_key, thermal FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 73 | GUJARAT_DAY_HYDRO_MU | SELECT date_key, hydro FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 74 | MAH_DAY_HYDRO_MU | SELECT date_key, hydro FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 75 | ESIL_DAY_HYDRO_MU | SELECT date_key, hydro FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 76 | DD_DAY_HYDRO_MU | SELECT date_key, hydro FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 77 | MP_DAY_HYDRO_MU | SELECT date_key, hydro FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 78 | DNH_DAY_HYDRO_MU | SELECT date_key, hydro FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 79 | CHHATISGARH_DAY_HYDRO_MU | SELECT date_key, hydro FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 80 | GOA_DAY_HYDRO_MU | SELECT date_key, hydro FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 81 | GUJARAT_DAY_WIND_MU | SELECT date_key, wind FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 82 | MAH_DAY_WIND_MU | SELECT date_key, wind FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 83 | ESIL_DAY_WIND_MU | SELECT date_key, wind FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 84 | DD_DAY_WIND_MU | SELECT date_key, wind FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 85 | MP_DAY_WIND_MU | SELECT date_key, wind FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 86 | DNH_DAY_WIND_MU | SELECT date_key, wind FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 87 | CHHATISGARH_DAY_WIND_MU | SELECT date_key, wind FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 88 | GOA_DAY_WIND_MU | SELECT date_key, wind FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 89 | GUJARAT_DAY_SOLAR_MU | SELECT date_key, solar FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 90 | MAH_DAY_SOLAR_MU | SELECT date_key, solar FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 91 | ESIL_DAY_SOLAR_MU | SELECT date_key, solar FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 92 | DD_DAY_SOLAR_MU | SELECT date_key, solar FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 93 | MP_DAY_SOLAR_MU | SELECT date_key, solar FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 94 | DNH_DAY_SOLAR_MU | SELECT date_key, solar FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 95 | CHHATISGARH_DAY_SOLAR_MU | SELECT date_key, solar FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 96 | GOA_DAY_SOLAR_MU | SELECT date_key, solar FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 97 | GUJARAT_DAY_OTHER_GEN_MU | SELECT date_key, others FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 98 | MAH_DAY_OTHER_GEN_MU | SELECT date_key, others FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 99 | ESIL_DAY_OTHER_GEN_MU | SELECT date_key, others FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 100 | DD_DAY_OTHER_GEN_MU | SELECT date_key, others FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 101 | MP_DAY_OTHER_GEN_MU | SELECT date_key, others FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 102 | DNH_DAY_OTHER_GEN_MU | SELECT date_key, others FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 103 | CHHATISGARH_DAY_OTHER_GEN_MU | SELECT date_key, others FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 104 | GOA_DAY_OTHER_GEN_MU | SELECT date_key, others FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 105 | GUJARAT_DAY_TOTAL_GEN_MU | SELECT date_key, total FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 106 | MAH_DAY_TOTAL_GEN_MU | SELECT date_key, total FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 107 | ESIL_DAY_TOTAL_GEN_MU | SELECT date_key, total FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 108 | DD_DAY_TOTAL_GEN_MU | SELECT date_key, total FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 109 | MP_DAY_TOTAL_GEN_MU | SELECT date_key, total FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 110 | DNH_DAY_TOTAL_GEN_MU | SELECT date_key, total FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 111 | CHHATISGARH_DAY_TOTAL_GEN_MU | SELECT date_key, total FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 112 | GOA_DAY_TOTAL_GEN_MU | SELECT date_key, total FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 113 | GUJARAT_DAY_SCH_MU | SELECT date_key, drawal_schdule FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 114 | MAH_DAY_SCH_MU | SELECT date_key, drawal_schdule FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 115 | ESIL_DAY_SCH_MU | SELECT date_key, drawal_schdule FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 116 | DD_DAY_SCH_MU | SELECT date_key, drawal_schdule FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 117 | MP_DAY_SCH_MU | SELECT date_key, drawal_schdule FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 118 | DNH_DAY_SCH_MU | SELECT date_key, drawal_schdule FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 119 | CHHATISGARH_DAY_SCH_MU | SELECT date_key, drawal_schdule FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 120 | GOA_DAY_SCH_MU | SELECT date_key, drawal_schdule FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 121 | GUJARAT_DAY_DRAWAL_MU | SELECT date_key, actual_drawal FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 122 | MAH_DAY_DRAWAL_MU | SELECT date_key, actual_drawal FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 123 | ESIL_DAY_DRAWAL_MU | SELECT date_key, actual_drawal FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 124 | DD_DAY_DRAWAL_MU | SELECT date_key, actual_drawal FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 125 | MP_DAY_DRAWAL_MU | SELECT date_key, actual_drawal FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 126 | DNH_DAY_DRAWAL_MU | SELECT date_key, actual_drawal FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 127 | CHHATISGARH_DAY_DRAWAL_MU | SELECT date_key, actual_drawal FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 128 | GOA_DAY_DRAWAL_MU | SELECT date_key, actual_drawal FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 129 | GUJARAT_DAY_UI_MU | SELECT date_key, ui FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 130 | MAH_DAY_UI_MU | SELECT date_key, ui FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 131 | ESIL_DAY_UI_MU | SELECT date_key, ui FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 132 | DD_DAY_UI_MU | SELECT date_key, ui FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 133 | MP_DAY_UI_MU | SELECT date_key, ui FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 134 | DNH_DAY_UI_MU | SELECT date_key, ui FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 135 | CHHATISGARH_DAY_UI_MU | SELECT date_key, ui FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 136 | GOA_DAY_UI_MU | SELECT date_key, ui FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 137 | GUJARAT_DAY_AVAILABILITY_MU | SELECT date_key, availability FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 138 | MAH_DAY_AVAILABILITY_MU | SELECT date_key, availability FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 139 | ESIL_DAY_AVAILABILITY_MU | SELECT date_key, availability FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 140 | DD_DAY_AVAILABILITY_MU | SELECT date_key, availability FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 141 | MP_DAY_AVAILABILITY_MU | SELECT date_key, availability FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 142 | DNH_DAY_AVAILABILITY_MU | SELECT date_key, availability FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 143 | CHHATISGARH_DAY_AVAILABILITY_MU | SELECT date_key, availability FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 144 | GOA_DAY_AVAILABILITY_MU | SELECT date_key, availability FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 145 | GUJARAT_DAY_REQUIREMENT_MU | SELECT date_key, requirement FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 146 | MAH_DAY_REQUIREMENT_MU | SELECT date_key, requirement FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 147 | ESIL_DAY_REQUIREMENT_MU | SELECT date_key, requirement FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 148 | DD_DAY_REQUIREMENT_MU | SELECT date_key, requirement FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 149 | MP_DAY_REQUIREMENT_MU | SELECT date_key, requirement FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 150 | DNH_DAY_REQUIREMENT_MU | SELECT date_key, requirement FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 151 | CHHATISGARH_DAY_REQUIREMENT_MU | SELECT date_key, requirement FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 152 | GOA_DAY_REQUIREMENT_MU | SELECT date_key, requirement FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 153 | GUJARAT_DAY_SHORTAGE_MU | SELECT date_key, shortage FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 154 | MAH_DAY_SHORTAGE_MU | SELECT date_key, shortage FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 155 | ESIL_DAY_SHORTAGE_MU | SELECT date_key, shortage FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 156 | DD_DAY_SHORTAGE_MU | SELECT date_key, shortage FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 157 | MP_DAY_SHORTAGE_MU | SELECT date_key, shortage FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 158 | DNH_DAY_SHORTAGE_MU | SELECT date_key, shortage FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 159 | CHHATISGARH_DAY_SHORTAGE_MU | SELECT date_key, shortage FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 160 | GOA_DAY_SHORTAGE_MU | SELECT date_key, shortage FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 161 | GUJARAT_DAY_CONSUMPTION_MU | SELECT date_key, consumption FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 162 | MAH_DAY_CONSUMPTION_MU | SELECT date_key, consumption FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 163 | ESIL_DAY_CONSUMPTION_MU | SELECT date_key, consumption FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 164 | DD_DAY_CONSUMPTION_MU | SELECT date_key, consumption FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 165 | MP_DAY_CONSUMPTION_MU | SELECT date_key, consumption FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 166 | DNH_DAY_CONSUMPTION_MU | SELECT date_key, consumption FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 167 | CHHATISGARH_DAY_CONSUMPTION_MU | SELECT date_key, consumption FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 168 | GOA_DAY_CONSUMPTION_MU | SELECT date_key, consumption FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 169 | GUJARAT_DAY_RENEWABLE_GEN_MU | SELECT date_key, renewable FROM REPORTING_UAT.state_load_details where state_name = 'GUJARAT' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 170 | MAH_DAY_RENEWABLE_GEN_MU | SELECT date_key, renewable FROM REPORTING_UAT.state_load_details where state_name = 'MAHARASHTRA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 171 | ESIL_DAY_RENEWABLE_GEN_MU | SELECT date_key, renewable FROM REPORTING_UAT.state_load_details where state_name = 'ESIL' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 172 | DD_DAY_RENEWABLE_GEN_MU | SELECT date_key, renewable FROM REPORTING_UAT.state_load_details where state_name = 'DAMAN AND DIU' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 173 | MP_DAY_RENEWABLE_GEN_MU | SELECT date_key, renewable FROM REPORTING_UAT.state_load_details where state_name = 'MADHYA PRADESH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 174 | DNH_DAY_RENEWABLE_GEN_MU | SELECT date_key, renewable FROM REPORTING_UAT.state_load_details where state_name = 'DADRA AND NAGAR HAVELI' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 175 | CHHATISGARH_DAY_RENEWABLE_GEN_MU | SELECT date_key, renewable FROM REPORTING_UAT.state_load_details where state_name = 'CHHATISGARH' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 176 | GOA_DAY_RENEWABLE_GEN_MU | SELECT date_key, renewable FROM REPORTING_UAT.state_load_details where state_name = 'GOA' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 177 | WR_NR_DAY_ISGS_SCH_MU | SELECT date_key, isgs_schedule FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='NR' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 178 | WR_ER_DAY_ISGS_SCH_MU | SELECT date_key, isgs_schedule FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='ER' and date_key between {start_time} and {end_time} by date_key | date_key |
| 179 | WR_SR_DAY_ISGS_SCH_MU | SELECT date_key, isgs_schedule FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='SR' and date_key between {start_time} and {end_time} by date_key | date_key |
| 180 | WR_NR_DAY_BILATERAL_SCH_MU | SELECT date_key, bilt_schedule FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='NR' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 181 | WR_ER_DAY_BILATERAL_SCH_MU | SELECT date_key, bilt_schedule FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='ER' and date_key between {start_time} and {end_time} by date_key | date_key |
| 182 | WR_SR_DAY_BILATERAL_SCH_MU | SELECT date_key, bilt_schedule FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='SR' and date_key between {start_time} and {end_time} by date_key | date_key |
| 183 | WR_NR_DAY_PX_SCH_MU | SELECT date_key, px_schedule FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='NR' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 184 | WR_ER_DAY_PX_SCH_MU | SELECT date_key, px_schedule FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='ER' and date_key between {start_time} and {end_time} by date_key | date_key |
| 185 | WR_SR_DAY_PX_SCH_MU | SELECT date_key, px_schedule FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='SR' and date_key between {start_time} and {end_time} by date_key | date_key |
| 186 | WR_NR_DAY_IR_SCH_MU | SELECT date_key, total_ir_schedule FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='NR' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 187 | WR_ER_DAY_IR_SCH_MU | SELECT date_key, total_ir_schedule FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='ER' and date_key between {start_time} and {end_time} by date_key | date_key |
| 188 | WR_SR_DAY_IR_SCH_MU | SELECT date_key, total_ir_schedule FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='SR' and date_key between {start_time} and {end_time} by date_key | date_key |
| 189 | WR_NR_DAY_IR_ACTUAL_MU | SELECT date_key, total_ir_actual FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='NR' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 190 | WR_ER_DAY_IR_ACTUAL_MU | SELECT date_key, total_ir_actual FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='ER' and date_key between {start_time} and {end_time} by date_key | date_key |
| 191 | WR_SR_DAY_IR_ACTUAL_MU | SELECT date_key, total_ir_actual FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='SR' and date_key between {start_time} and {end_time} by date_key | date_key |
| 192 | WR_NR_DAY_IR_UI_MU | SELECT date_key, net_ir_ui FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='NR' and date_key between {start_time} and {end_time} order by date_key | date_key |
| 193 | WR_ER_DAY_IR_UI_MU | SELECT date_key, net_ir_ui FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='ER' and date_key between {start_time} and {end_time} by date_key | date_key |
| 194 | WR_SR_DAY_IR_UI_MU | SELECT date_key, net_ir_ui FROM REPORTING_UAT.inter_regional_schedule_actual where from_region_name = 'WR' and to_region_name='SR' and date_key between {start_time} and {end_time} by date_key | date_key |
| 195 | DHARIWAL_CTU_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='dhariwal ctu' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 196 | ESSAR_MAHAN_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='essar(mahan)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 197 | JPL_STG_I_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 198 | BALCO_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='balco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 199 | NSPCL_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='nspcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 200 | KORBA_III_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='korba iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 201 | SIPAT_I_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 202 | VSTPS_I_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 203 | VSTPS_II_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 204 | VSTPS_V_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps v' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 205 | ARINSUN_SOLAR_BARSAITADESH_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='arinsun solar (barsaitadesh)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 206 | MOUDA_II_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 207 | JP_NIGRIE_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='jp nigrie' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 208 | JPL_STG_II_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 209 | KSK_MAHANADI_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='ksk mahanadi' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 210 | SIPAT_II_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 211 | SOLAPUR_STPS_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='solapur stps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 212 | RGPPL_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='rgppl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 213 | ACME_SOLAR_RAMNAGAR_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='acme solar (ramnagar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 214 | JHABUA_POWER_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='jhabua power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 215 | TRN_ENERGY_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='trn energy' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 216 | GADARWARA_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='gadarwara' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 217 | GANDHAR_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='gandhar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 218 | CGPL_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='cgpl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 219 | KWPCL_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='kwpcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 220 | DB_POWER_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='db power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 221 | SASAN_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='sasan' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 222 | SSP_RBPH+CHPH_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph+chph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 223 | VANDANA_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='vandana' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 224 | MB_POWER_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='mb power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 225 | TARAPUR_II_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 226 | GMR_WARORA_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr warora' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 227 | SKS_POWER_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='sks power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 228 | KAPS_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='kaps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 229 | TARAPUR_I_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 230 | VSTPS_IV_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iv' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 231 | LANCO_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='lanco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 232 | RKM_POWER_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='rkm power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 233 | MOUDA_I_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 234 | RENEW_WIND_BHUVAD_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='renew wind (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 235 | ACBIL_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='acbil' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 236 | MAHINDRA_SOLAR_BADWAR_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='mahindra solar (badwar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 237 | GIWEL_II_WIND_VADVA_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-ii wind (vadva)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 238 | DCPP_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='dcpp' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 239 | VSTPS_III_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 240 | OSTRO_WIND_KUTCH_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='ostro wind (kutch)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 241 | IWISL_WIND_DAYAPAR_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='iwisl wind (dayapar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 242 | KSTPS_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='kstps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 243 | KAWAS_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='kawas' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 244 | SSP_RBPH_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 245 | RENEW_SOLAR_BHUVAD_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='renew solar (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 246 | GIWEL_III_WIND_NARANPAR_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-iii wind (naranpar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 247 | GMR_CHHATISGARH_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr chhatisgarh' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 248 | DGEN_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='dgen' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 249 | CS_SOLAR_DAY_SCH_MU | select date_key, day_energy_schdule from reporting_uat.regional_entities_generation where lower(constituent_name)='cs solar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 250 | DHARIWAL_CTU_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='dhariwal ctu' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 251 | ESSAR_MAHAN_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='essar(mahan)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 252 | JPL_STG_I_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 253 | BALCO_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='balco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 254 | NSPCL_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='nspcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 255 | KORBA_III_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='korba iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 256 | SIPAT_I_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 257 | VSTPS_I_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 258 | VSTPS_II_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 259 | VSTPS_V_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps v' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 260 | ARINSUN_SOLAR_BARSAITADESH_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='arinsun solar (barsaitadesh)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 261 | MOUDA_II_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 262 | JP_NIGRIE_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='jp nigrie' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 263 | JPL_STG_II_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 264 | KSK_MAHANADI_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='ksk mahanadi' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 265 | SIPAT_II_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 266 | SOLAPUR_STPS_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='solapur stps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 267 | RGPPL_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='rgppl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 268 | ACME_SOLAR_RAMNAGAR_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='acme solar (ramnagar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 269 | JHABUA_POWER_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='jhabua power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 270 | TRN_ENERGY_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='trn energy' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 271 | GADARWARA_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='gadarwara' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 272 | GANDHAR_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='gandhar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 273 | CGPL_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='cgpl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 274 | KWPCL_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='kwpcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 275 | DB_POWER_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='db power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 276 | SASAN_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='sasan' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 277 | SSP_RBPH+CHPH_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph+chph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 278 | VANDANA_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='vandana' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 279 | MB_POWER_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='mb power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 280 | TARAPUR_II_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 281 | GMR_WARORA_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr warora' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 282 | SKS_POWER_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='sks power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 283 | KAPS_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='kaps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 284 | TARAPUR_I_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 285 | VSTPS_IV_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iv' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 286 | LANCO_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='lanco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 287 | RKM_POWER_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='rkm power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 288 | MOUDA_I_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 289 | RENEW_WIND_BHUVAD_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='renew wind (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 290 | ACBIL_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='acbil' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 291 | MAHINDRA_SOLAR_BADWAR_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='mahindra solar (badwar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 292 | GIWEL_II_WIND_VADVA_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-ii wind (vadva)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 293 | DCPP_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='dcpp' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 294 | VSTPS_III_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 295 | OSTRO_WIND_KUTCH_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='ostro wind (kutch)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 296 | IWISL_WIND_DAYAPAR_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='iwisl wind (dayapar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 297 | KSTPS_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='kstps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 298 | KAWAS_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='kawas' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 299 | SSP_RBPH_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 300 | RENEW_SOLAR_BHUVAD_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='renew solar (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 301 | GIWEL_III_WIND_NARANPAR_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-iii wind (naranpar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 302 | GMR_CHHATISGARH_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr chhatisgarh' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 303 | DGEN_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='dgen' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 304 | CS_SOLAR_DAY_GEN_MU | select date_key, day_energy_actual from reporting_uat.regional_entities_generation where lower(constituent_name)='cs solar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 305 | DHARIWAL_CTU_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='dhariwal ctu' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 306 | ESSAR_MAHAN_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='essar(mahan)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 307 | JPL_STG_I_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 308 | BALCO_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='balco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 309 | NSPCL_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='nspcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 310 | KORBA_III_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='korba iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 311 | SIPAT_I_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 312 | VSTPS_I_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 313 | VSTPS_II_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 314 | VSTPS_V_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps v' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 315 | ARINSUN_SOLAR_BARSAITADESH_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='arinsun solar (barsaitadesh)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 316 | MOUDA_II_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 317 | JP_NIGRIE_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jp nigrie' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 318 | JPL_STG_II_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 319 | KSK_MAHANADI_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ksk mahanadi' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 320 | SIPAT_II_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 321 | SOLAPUR_STPS_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='solapur stps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 322 | RGPPL_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='rgppl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 323 | ACME_SOLAR_RAMNAGAR_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='acme solar (ramnagar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 324 | JHABUA_POWER_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jhabua power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 325 | TRN_ENERGY_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='trn energy' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 326 | GADARWARA_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gadarwara' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 327 | GANDHAR_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gandhar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 328 | CGPL_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='cgpl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 329 | KWPCL_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kwpcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 330 | DB_POWER_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='db power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 331 | SASAN_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sasan' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 332 | SSP_RBPH+CHPH_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph+chph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 333 | VANDANA_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vandana' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 334 | MB_POWER_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mb power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 335 | TARAPUR_II_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 336 | GMR_WARORA_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr warora' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 337 | SKS_POWER_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sks power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 338 | KAPS_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kaps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 339 | TARAPUR_I_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 340 | VSTPS_IV_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iv' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 341 | LANCO_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='lanco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 342 | RKM_POWER_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='rkm power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 343 | MOUDA_I_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 344 | RENEW_WIND_BHUVAD_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='renew wind (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 345 | ACBIL_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='acbil' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 346 | MAHINDRA_SOLAR_BADWAR_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mahindra solar (badwar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 347 | GIWEL_II_WIND_VADVA_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-ii wind (vadva)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 348 | DCPP_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='dcpp' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 349 | VSTPS_III_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 350 | OSTRO_WIND_KUTCH_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ostro wind (kutch)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 351 | IWISL_WIND_DAYAPAR_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='iwisl wind (dayapar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 352 | KSTPS_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kstps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 353 | KAWAS_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kawas' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 354 | SSP_RBPH_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 355 | RENEW_SOLAR_BHUVAD_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='renew solar (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 356 | GIWEL_III_WIND_NARANPAR_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-iii wind (naranpar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 357 | GMR_CHHATISGARH_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr chhatisgarh' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 358 | DGEN_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='dgen' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 359 | CS_SOLAR_DAY_MAX_GEN | select date_key, day_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='cs solar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 360 | DHARIWAL_CTU_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='dhariwal ctu' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 361 | ESSAR_MAHAN_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='essar(mahan)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 362 | JPL_STG_I_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 363 | BALCO_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='balco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 364 | NSPCL_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='nspcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 365 | KORBA_III_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='korba iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 366 | SIPAT_I_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 367 | VSTPS_I_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 368 | VSTPS_II_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 369 | VSTPS_V_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps v' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 370 | ARINSUN_SOLAR_BARSAITADESH_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='arinsun solar (barsaitadesh)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 371 | MOUDA_II_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 372 | JP_NIGRIE_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jp nigrie' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 373 | JPL_STG_II_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 374 | KSK_MAHANADI_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ksk mahanadi' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 375 | SIPAT_II_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 376 | SOLAPUR_STPS_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='solapur stps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 377 | RGPPL_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='rgppl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 378 | ACME_SOLAR_RAMNAGAR_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='acme solar (ramnagar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 379 | JHABUA_POWER_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jhabua power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 380 | TRN_ENERGY_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='trn energy' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 381 | GADARWARA_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gadarwara' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 382 | GANDHAR_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gandhar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 383 | CGPL_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='cgpl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 384 | KWPCL_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kwpcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 385 | DB_POWER_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='db power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 386 | SASAN_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sasan' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 387 | SSP_RBPH+CHPH_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph+chph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 388 | VANDANA_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vandana' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 389 | MB_POWER_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mb power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 390 | TARAPUR_II_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 391 | GMR_WARORA_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr warora' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 392 | SKS_POWER_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sks power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 393 | KAPS_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kaps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 394 | TARAPUR_I_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 395 | VSTPS_IV_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iv' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 396 | LANCO_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='lanco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 397 | RKM_POWER_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='rkm power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 398 | MOUDA_I_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 399 | RENEW_WIND_BHUVAD_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='renew wind (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 400 | ACBIL_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='acbil' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 401 | MAHINDRA_SOLAR_BADWAR_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mahindra solar (badwar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 402 | GIWEL_II_WIND_VADVA_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-ii wind (vadva)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 403 | DCPP_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='dcpp' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 404 | VSTPS_III_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 405 | OSTRO_WIND_KUTCH_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ostro wind (kutch)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 406 | IWISL_WIND_DAYAPAR_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='iwisl wind (dayapar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 407 | KSTPS_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kstps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 408 | KAWAS_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kawas' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 409 | SSP_RBPH_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 410 | RENEW_SOLAR_BHUVAD_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='renew solar (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 411 | GIWEL_III_WIND_NARANPAR_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-iii wind (naranpar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 412 | GMR_CHHATISGARH_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr chhatisgarh' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 413 | DGEN_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='dgen' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 414 | CS_SOLAR_DAY_PEAK_GEN | select date_key, peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='cs solar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 415 | DHARIWAL_CTU_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='dhariwal ctu' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 416 | ESSAR_MAHAN_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='essar(mahan)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 417 | JPL_STG_I_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 418 | BALCO_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='balco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 419 | NSPCL_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='nspcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 420 | KORBA_III_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='korba iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 421 | SIPAT_I_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 422 | VSTPS_I_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 423 | VSTPS_II_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 424 | VSTPS_V_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps v' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 425 | ARINSUN_SOLAR_BARSAITADESH_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='arinsun solar (barsaitadesh)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 426 | MOUDA_II_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 427 | JP_NIGRIE_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jp nigrie' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 428 | JPL_STG_II_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 429 | KSK_MAHANADI_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ksk mahanadi' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 430 | SIPAT_II_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 431 | SOLAPUR_STPS_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='solapur stps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 432 | RGPPL_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='rgppl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 433 | ACME_SOLAR_RAMNAGAR_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='acme solar (ramnagar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 434 | JHABUA_POWER_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jhabua power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 435 | TRN_ENERGY_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='trn energy' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 436 | GADARWARA_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gadarwara' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 437 | GANDHAR_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gandhar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 438 | CGPL_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='cgpl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 439 | KWPCL_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kwpcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 440 | DB_POWER_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='db power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 441 | SASAN_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sasan' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 442 | SSP_RBPH+CHPH_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph+chph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 443 | VANDANA_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vandana' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 444 | MB_POWER_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mb power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 445 | TARAPUR_II_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 446 | GMR_WARORA_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr warora' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 447 | SKS_POWER_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sks power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 448 | KAPS_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kaps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 449 | TARAPUR_I_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 450 | VSTPS_IV_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iv' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 451 | LANCO_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='lanco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 452 | RKM_POWER_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='rkm power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 453 | MOUDA_I_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 454 | RENEW_WIND_BHUVAD_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='renew wind (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 455 | ACBIL_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='acbil' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 456 | MAHINDRA_SOLAR_BADWAR_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mahindra solar (badwar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 457 | GIWEL_II_WIND_VADVA_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-ii wind (vadva)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 458 | DCPP_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='dcpp' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 459 | VSTPS_III_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 460 | OSTRO_WIND_KUTCH_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ostro wind (kutch)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 461 | IWISL_WIND_DAYAPAR_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='iwisl wind (dayapar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 462 | KSTPS_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kstps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 463 | KAWAS_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kawas' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 464 | SSP_RBPH_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 465 | RENEW_SOLAR_BHUVAD_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='renew solar (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 466 | GIWEL_III_WIND_NARANPAR_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-iii wind (naranpar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 467 | GMR_CHHATISGARH_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr chhatisgarh' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 468 | DGEN_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='dgen' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 469 | CS_SOLAR_DAY_OFF_PEAK_GEN | select date_key, off_peak_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='cs solar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 470 | DHARIWAL_CTU_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='dhariwal ctu' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 471 | ESSAR_MAHAN_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='essar(mahan)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 472 | JPL_STG_I_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 473 | BALCO_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='balco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 474 | NSPCL_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='nspcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 475 | KORBA_III_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='korba iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 476 | SIPAT_I_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 477 | VSTPS_I_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 478 | VSTPS_II_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 479 | VSTPS_V_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps v' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 480 | ARINSUN_SOLAR_BARSAITADESH_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='arinsun solar (barsaitadesh)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 481 | MOUDA_II_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 482 | JP_NIGRIE_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jp nigrie' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 483 | JPL_STG_II_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 484 | KSK_MAHANADI_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ksk mahanadi' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 485 | SIPAT_II_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 486 | SOLAPUR_STPS_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='solapur stps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 487 | RGPPL_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='rgppl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 488 | ACME_SOLAR_RAMNAGAR_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='acme solar (ramnagar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 489 | JHABUA_POWER_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='jhabua power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 490 | TRN_ENERGY_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='trn energy' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 491 | GADARWARA_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gadarwara' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 492 | GANDHAR_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gandhar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 493 | CGPL_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='cgpl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 494 | KWPCL_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kwpcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 495 | DB_POWER_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='db power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 496 | SASAN_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sasan' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 497 | SSP_RBPH+CHPH_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph+chph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 498 | VANDANA_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vandana' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 499 | MB_POWER_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mb power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 500 | TARAPUR_II_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 501 | GMR_WARORA_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr warora' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 502 | SKS_POWER_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='sks power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 503 | KAPS_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kaps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 504 | TARAPUR_I_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 505 | VSTPS_IV_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iv' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 506 | LANCO_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='lanco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 507 | RKM_POWER_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='rkm power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 508 | MOUDA_I_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 509 | RENEW_WIND_BHUVAD_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='renew wind (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 510 | ACBIL_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='acbil' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 511 | MAHINDRA_SOLAR_BADWAR_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='mahindra solar (badwar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 512 | GIWEL_II_WIND_VADVA_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-ii wind (vadva)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 513 | DCPP_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='dcpp' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 514 | VSTPS_III_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 515 | OSTRO_WIND_KUTCH_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ostro wind (kutch)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 516 | IWISL_WIND_DAYAPAR_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='iwisl wind (dayapar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 517 | KSTPS_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kstps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 518 | KAWAS_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='kawas' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 519 | SSP_RBPH_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 520 | RENEW_SOLAR_BHUVAD_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='renew solar (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 521 | GIWEL_III_WIND_NARANPAR_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-iii wind (naranpar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 522 | GMR_CHHATISGARH_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr chhatisgarh' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 523 | DGEN_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='dgen' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 524 | CS_SOLAR_DAY_AVG_GEN | select date_key, avg_mw from reporting_uat.regional_entities_generation where lower(constituent_name)='cs solar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 525 | DHARIWAL_CTU_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='dhariwal ctu' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 526 | ESSAR_MAHAN_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='essar(mahan)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 527 | JPL_STG_I_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 528 | BALCO_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='balco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 529 | NSPCL_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='nspcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 530 | KORBA_III_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='korba iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 531 | SIPAT_I_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 532 | VSTPS_I_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 533 | VSTPS_II_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 534 | VSTPS_V_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps v' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 535 | ARINSUN_SOLAR_BARSAITADESH_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='arinsun solar (barsaitadesh)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 536 | MOUDA_II_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 537 | JP_NIGRIE_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='jp nigrie' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 538 | JPL_STG_II_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='jpl stg-ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 539 | KSK_MAHANADI_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='ksk mahanadi' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 540 | SIPAT_II_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='sipat ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 541 | SOLAPUR_STPS_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='solapur stps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 542 | RGPPL_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='rgppl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 543 | ACME_SOLAR_RAMNAGAR_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='acme solar (ramnagar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 544 | JHABUA_POWER_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='jhabua power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 545 | TRN_ENERGY_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='trn energy' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 546 | GADARWARA_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='gadarwara' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 547 | GANDHAR_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='gandhar' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 548 | CGPL_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='cgpl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 549 | KWPCL_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='kwpcl' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 550 | DB_POWER_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='db power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 551 | SASAN_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='sasan' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 552 | SSP_RBPH+CHPH_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph+chph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 553 | VANDANA_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='vandana' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 554 | MB_POWER_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='mb power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 555 | TARAPUR_II_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur ii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 556 | GMR_WARORA_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr warora' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 557 | SKS_POWER_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='sks power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 558 | KAPS_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='kaps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 559 | TARAPUR_I_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='tarapur i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 560 | VSTPS_IV_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iv' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 561 | LANCO_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='lanco' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 562 | RKM_POWER_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='rkm power' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 563 | MOUDA_I_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='mouda i' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 564 | RENEW_WIND_BHUVAD_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='renew wind (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 565 | ACBIL_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='acbil' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 566 | MAHINDRA_SOLAR_BADWAR_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='mahindra solar (badwar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 567 | GIWEL_II_WIND_VADVA_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-ii wind (vadva)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 568 | DCPP_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='dcpp' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 569 | VSTPS_III_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='vstps iii' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 570 | OSTRO_WIND_KUTCH_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='ostro wind (kutch)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 571 | IWISL_WIND_DAYAPAR_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='iwisl wind (dayapar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 572 | KSTPS_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='kstps' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 573 | KAWAS_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='kawas' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 574 | SSP_RBPH_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='ssp(rbph)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 575 | RENEW_SOLAR_BHUVAD_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='renew solar (bhuvad)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 576 | GIWEL_III_WIND_NARANPAR_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='giwel-iii wind (naranpar)' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 577 | GMR_CHHATISGARH_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='gmr chhatisgarh' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 578 | DGEN_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='dgen' and date_key between {start_time} and {to_time} order by date_key | date_key |
| 579 | CS_SOLAR_DAY_INSTALLED_CAPACITY | select date_key, installed_capacity from reporting_uat.regional_entities_generation where lower(constituent_name)='cs solar' and date_key between {start_time} and {to_time} order by date_key | date_key |