nagasudhirpulla/psp_meas_api_notes.md

## psp_meas_api_notes.md

      
    Raw
  

              psp_meas_api_notes.md
            
          
    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