﻿<?xml version="1.0"?>
<objects xmlns="http://www.springframework.net"
				 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
				 xmlns:quartz="http://www.opensymphony.com/quartz/JobSchedulingData"
				 xsi:schemaLocation="http://www.springframework.net http://www.springframework.net/xsd/spring-objects.xsd" >
  <object type="Sleis.Export.ExportGroup" name="AgencyEmissionUnitExport">
    <property name="Name" value="Agency_EmissionUnit">
    </property>
    <property name="Queries">
      <dictionary key-type="System.String" value-type="System.String">
        <entry key="EmissionUnits" value="SELECT
	                                          eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                          eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                          eut.UNIT_TYPE_DESC AS EMIS_UNIT_TYPE_DESC,
	                                          eus.UNIT_STAT_DESC AS EMIS_UNIT_STATUS,
	                                          eu.UNIT_STAT_CD_DATE AS EMIS_UNIT_STATUS_DATE,
	                                          eu.UNIT_OPER_DATE AS EMIS_UNIT_OPER_DATE,
	                                          eu.UNIT_DSGN_CAP As EMIS_UNIT_DSGN_CAP,
	                                          dcu.UNIT_DSGN_CAP_UOM_DESC As EMIS_UNIT_DSGN_CAP_UOM,
	                                          eu.UNIT_CMNT As EMIS_UNIT_CMNT
                                          FROM
	                                          M_EMIS_UNIT eu 
	                                          INNER JOIN M_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
	                                          INNER JOIN M_AGN_RPT ar ON fs.AGN_RPT_ID = ar.AGN_RPT_ID
	
	                                          INNER JOIN E_UNIT_STAT eus ON eu.E_UNIT_STAT_CD = eus.E_UNIT_STAT_CD
	                                          LEFT JOIN E_UNIT_TYPE eut ON eu.E_UNIT_TYPE_CD = eut.E_UNIT_TYPE_CD
	
	                                          LEFT JOIN E_UNIT_DSGN_CAP_UOM dcu ON eu.E_UNIT_DSGN_CAP_UOM_CD = dcu.E_UNIT_DSGN_CAP_UOM_CD
                                          WHERE
	                                          ar.AGN_RPT_ID = :reportId --current report being reported on
                                          ORDER BY
	                                          eu.EMIS_UNIT_IDEN ASC
	                                          " />
        <entry key="ControlApproach" value="SELECT
	                                            eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                            eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                            euca.CTRL_APCH_DESC AS CTRL_APCH_DESC,
	                                            euca.PCT_CTRL_APCH_CAP_EFCY AS PCT_CTRL_APCH_CAP_EFCY,
	                                            cd.CTRL_DEVC_IDEN AS CTRL_DEVC_IDEN,
	                                            cd.CTRL_DEVC_DESC AS CTRL_DEVC_DESC,
	                                            eucd.SEQ_NUM AS CTRL_DEVC_SEQ_NUM
                                            FROM
	                                            M_EMIS_UNIT_CTRL_APCH euca 
	                                            INNER JOIN M_EMIS_UNIT eu ON euca.EMIS_UNIT_ID = eu.EMIS_UNIT_ID
	                                            INNER JOIN M_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
	                                            INNER JOIN M_AGN_RPT ar ON fs.AGN_RPT_ID = ar.AGN_RPT_ID
	
	                                            LEFT JOIN M_EMIS_UNIT_CTRL_DEVC eucd ON euca.EMIS_UNIT_CTRL_APCH_ID = eucd.EMIS_UNIT_CTRL_APCH_ID
	                                            LEFT JOIN M_CTRL_DEVC cd ON eucd.CTRL_DEVC_ID = cd.CTRL_DEVC_ID
                                            WHERE
	                                            ar.AGN_RPT_ID = :reportId --current report being reported on
                                            ORDER BY
	                                            eu.EMIS_UNIT_IDEN ASC,
	                                            eucd.SEQ_NUM ASC
																	 " />
      <entry key="RegulatoryPrograms" value="SELECT
	                                              eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                              eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                              pgm.REG_PGM_DESC AS REG_PGM_DESC
                                              FROM
	                                              M_EMIS_UNIT_REG_PGM eurp
	                                              INNER JOIN M_EMIS_UNIT eu ON eurp.EMIS_UNIT_ID = eu.EMIS_UNIT_ID
	                                              INNER JOIN M_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
	                                              INNER JOIN M_AGN_RPT ar ON fs.AGN_RPT_ID = ar.AGN_RPT_ID
	
	                                              INNER JOIN E_REG_PGM pgm ON eurp.E_REG_PGM_CD = pgm.E_REG_PGM_CD
                                              WHERE
	                                              ar.AGN_RPT_ID = :reportId --current report being reported on
                                              ORDER BY
	                                              eu.EMIS_UNIT_IDEN ASC,
	                                              pgm.REG_PGM_DESC ASC	" />
        <entry key="AdditionalInformation" value="SELECT
	                                                  eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                                  eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                                  cf.FLD_LABEL AS FLD_NAME,
	                                                  cfv.CSTM_FLD_VAL AS FLD_VALUE
                                                  FROM
	                                                  M_EMIS_UNIT_CSTM_FLD_VAL cfv 
	                                                  INNER JOIN A_CSTM_FLD cf ON cfv.A_CSTM_FLD_ID = cf.A_CSTM_FLD_ID
	                                                  INNER JOIN M_EMIS_UNIT eu ON cfv.EMIS_UNIT_ID = eu.EMIS_UNIT_ID
	                                                  INNER JOIN M_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
	                                                  INNER JOIN M_AGN_RPT ar ON fs.AGN_RPT_ID = ar.AGN_RPT_ID
                                                  WHERE
	                                                  ar.AGN_RPT_ID = :reportId --current report being reported on
                                                  ORDER BY
	                                                  eu.EMIS_UNIT_IDEN ASC,
	                                                  cf.FLD_LABEL ASC" />
      </dictionary>
    </property>
  </object>
  <object type="Sleis.Export.ExportGroup" name="MasterEmissionUnitExport">
    <property name="Name" value="Master_EmissionUnit">
    </property>
    <property name="Queries">
      <dictionary key-type="System.String" value-type="System.String">
        <entry key="EmissionUnits" value="SELECT
	                                          eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                          eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                          eut.UNIT_TYPE_DESC AS EMIS_UNIT_TYPE_DESC,
	                                          eus.UNIT_STAT_DESC AS EMIS_UNIT_STATUS,
	                                          eu.UNIT_STAT_CD_DATE AS EMIS_UNIT_STATUS_DATE,
	                                          eu.UNIT_OPER_DATE AS EMIS_UNIT_OPER_DATE,
	                                          eu.UNIT_DSGN_CAP As EMIS_UNIT_DSGN_CAP,
	                                          dcu.UNIT_DSGN_CAP_UOM_DESC As EMIS_UNIT_DSGN_CAP_UOM
                                          FROM
	                                          M_EMIS_UNIT eu 
	                                          INNER JOIN M_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
	
	                                          INNER JOIN E_UNIT_STAT eus ON eu.E_UNIT_STAT_CD = eus.E_UNIT_STAT_CD
	                                          LEFT JOIN E_UNIT_TYPE eut ON eu.E_UNIT_TYPE_CD = eut.E_UNIT_TYPE_CD
	
	                                          LEFT JOIN E_UNIT_DSGN_CAP_UOM dcu ON eu.E_UNIT_DSGN_CAP_UOM_CD = dcu.E_UNIT_DSGN_CAP_UOM_CD
                                          WHERE
	                                          fs.FAC_SITE_ID = :facilityId --current facility
	                                          AND fs.FAC_SITE_MSTR_IND = 1
                                          ORDER BY
	                                          eu.EMIS_UNIT_IDEN ASC
	                                          " />
        <entry key="ControlApproach" value="SELECT
	                                            eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                            eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                            euca.CTRL_APCH_DESC AS CTRL_APCH_DESC,
	                                            euca.PCT_CTRL_APCH_CAP_EFCY AS PCT_CTRL_APCH_CAP_EFCY,
	                                            cd.CTRL_DEVC_IDEN AS CTRL_DEVC_IDEN,
	                                            cd.CTRL_DEVC_DESC AS CTRL_DEVC_DESC,
	                                            eucd.SEQ_NUM AS CTRL_DEVC_SEQ_NUM
                                            FROM
	                                            M_EMIS_UNIT_CTRL_APCH euca 
	                                            INNER JOIN M_EMIS_UNIT eu ON euca.EMIS_UNIT_ID = eu.EMIS_UNIT_ID
	                                            INNER JOIN M_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
	
	                                            LEFT JOIN M_EMIS_UNIT_CTRL_DEVC eucd ON euca.EMIS_UNIT_CTRL_APCH_ID = eucd.EMIS_UNIT_CTRL_APCH_ID
	                                            LEFT JOIN M_CTRL_DEVC cd ON eucd.CTRL_DEVC_ID = cd.CTRL_DEVC_ID
                                            WHERE
	                                            fs.FAC_SITE_ID = :facilityId --current facility
	                                            AND fs.FAC_SITE_MSTR_IND = 1
                                            ORDER BY
	                                            eu.EMIS_UNIT_IDEN ASC,
	                                            eucd.SEQ_NUM ASC
																	 " />
        <entry key="RegulatoryPrograms" value="SELECT
	                                                eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                                eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                                pgm.REG_PGM_DESC AS REG_PGM_DESC
                                                FROM
	                                                M_EMIS_UNIT_REG_PGM eurp
	                                                INNER JOIN M_EMIS_UNIT eu ON eurp.EMIS_UNIT_ID = eu.EMIS_UNIT_ID
	                                                INNER JOIN M_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
	
	                                                INNER JOIN E_REG_PGM pgm ON eurp.E_REG_PGM_CD = pgm.E_REG_PGM_CD
                                                WHERE
	                                                fs.FAC_SITE_ID = :facilityId --current facility
	                                                AND fs.FAC_SITE_MSTR_IND = 1
                                                ORDER BY
	                                                eu.EMIS_UNIT_IDEN ASC,
	                                                pgm.REG_PGM_DESC ASC	
	
                                                " />
        <entry key="AdditionalInformation" value="SELECT
	                                                  eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                                  eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                                  cf.FLD_LABEL AS FLD_NAME,
	                                                  cfv.CSTM_FLD_VAL AS FLD_VALUE
                                                  FROM
	                                                  M_EMIS_UNIT_CSTM_FLD_VAL cfv 
	                                                  INNER JOIN A_CSTM_FLD cf ON cfv.A_CSTM_FLD_ID = cf.A_CSTM_FLD_ID
	                                                  INNER JOIN M_EMIS_UNIT eu ON cfv.EMIS_UNIT_ID = eu.EMIS_UNIT_ID
	                                                  INNER JOIN M_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
                                                  WHERE
	                                                  fs.FAC_SITE_ID = :facilityId --current facility
	                                                  AND fs.FAC_SITE_MSTR_IND = 1
                                                  ORDER BY
	                                                  eu.EMIS_UNIT_IDEN ASC,
	                                                  cf.FLD_LABEL ASC
	
                                                  " />
        <entry key="Identifiers" value="SELECT
	                                        eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                        eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                        eui.EMIS_UNIT_IDEN AS ALT_EMIS_UNIT_IDEN,
	                                        eui.A_PROG_SYS_CD AS ALT_EMIS_UNIT_IDEN_SYS_CD,
	                                        eui.EFF_DATE AS ALT_EMIS_UNIT_IDEN_EFF_DATE
                                        FROM
	                                        M_EMIS_UNIT_IDEN eui
	                                        INNER JOIN M_EMIS_UNIT eu ON eui.EMIS_UNIT_ID = eu.EMIS_UNIT_ID
	                                        INNER JOIN M_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
                                        WHERE
	                                        fs.FAC_SITE_ID = :facilityId --current facility
	                                        AND fs.FAC_SITE_MSTR_IND = 1
                                        ORDER BY
	                                        eu.EMIS_UNIT_IDEN ASC
	
                                                  " />
        <entry key="Comments" value="SELECT
	                                    eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                    eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                    euc.CMNT_TXT,
	                                    CASE 
		                                    WHEN euc.CMNT_BY_USER_ID IS NULL THEN 'Agency Editor'
		                                    ELSE s.USER_FULL_NAME
	                                    END AS CMNT_BY,
	                                    euc.CMNT_DATE AS CMNT_DATE
                                    FROM
	                                    M_EMIS_UNIT_CMNT euc
	                                    INNER JOIN M_EMIS_UNIT eu ON euc.EMIS_UNIT_ID = eu.EMIS_UNIT_ID
	                                    INNER JOIN M_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
	
	                                    LEFT JOIN SEC_USER s ON euc.CMNT_BY_USER_ID = s.SEC_USER_ID
                                    WHERE
	                                    fs.FAC_SITE_ID = :facilityId --current facility
	                                    AND fs.FAC_SITE_MSTR_IND = 1
                                    ORDER BY
	                                    eu.EMIS_UNIT_IDEN ASC
                                                                                      " />
        
      </dictionary>
    </property>
  </object>
  <object type="Sleis.Export.ExportGroup" name="PublicEmissionUnitExport">
    <property name="Name" value="Public_EmissionUnit">
    </property>
    <property name="Queries">
      <dictionary key-type="System.String" value-type="System.String">
        <entry key="EmissionUnits" value="SELECT
	                                          eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                          eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                          eut.UNIT_TYPE_DESC AS EMIS_UNIT_TYPE_DESC,
	                                          eus.UNIT_STAT_DESC AS EMIS_UNIT_STATUS,
	                                          eu.UNIT_STAT_CD_DATE AS EMIS_UNIT_STATUS_DATE,
	                                          eu.UNIT_OPER_DATE AS EMIS_UNIT_OPER_DATE,
	                                          eu.UNIT_DSGN_CAP As EMIS_UNIT_DSGN_CAP,
	                                          dcu.UNIT_DSGN_CAP_UOM_DESC As EMIS_UNIT_DSGN_CAP_UOM,
	                                          eu.UNIT_CMNT As EMIS_UNIT_CMNT
                                          FROM
	                                          P_EMIS_UNIT eu 
	                                          INNER JOIN P_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
	                                          INNER JOIN P_FAC_EMIS_RPT fer ON fs.FAC_EMIS_RPT_ID = fer.FAC_EMIS_RPT_ID
	                                          INNER JOIN M_AGN_RPT ar ON fer.AGN_RPT_ID = ar.AGN_RPT_ID
	
	                                          INNER JOIN E_UNIT_STAT eus ON eu.E_UNIT_STAT_CD = eus.E_UNIT_STAT_CD
	                                          INNER JOIN E_UNIT_TYPE eut ON eu.E_UNIT_TYPE_CD = eut.E_UNIT_TYPE_CD
	
	                                          LEFT JOIN E_UNIT_DSGN_CAP_UOM dcu ON eu.E_UNIT_DSGN_CAP_UOM_CD = dcu.E_UNIT_DSGN_CAP_UOM_CD
                                          WHERE
	                                          ar.AGN_RPT_ID = :reportId --current report being reported on
                                          ORDER BY
	                                          eu.EMIS_UNIT_IDEN ASC
	                                          " />
        <entry key="ControlApproach" value="SELECT
	                                            eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                            eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                            euca.CTRL_APCH_DESC AS CTRL_APCH_DESC,
	                                            euca.PCT_CTRL_APCH_CAP_EFCY AS PCT_CTRL_APCH_CAP_EFCY,
	                                            cd.CTRL_DEVC_IDEN AS CTRL_DEVC_IDEN,
	                                            cd.CTRL_DEVC_DESC AS CTRL_DEVC_DESC,
	                                            eucd.SEQ_NUM AS CTRL_DEVC_SEQ_NUM
                                            FROM
	                                            P_EMIS_UNIT_CTRL_APCH euca 
	                                            INNER JOIN P_EMIS_UNIT eu ON euca.EMIS_UNIT_ID = eu.EMIS_UNIT_ID
	                                            INNER JOIN P_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
	                                            INNER JOIN P_FAC_EMIS_RPT fer ON fs.FAC_EMIS_RPT_ID = fer.FAC_EMIS_RPT_ID
	                                            INNER JOIN M_AGN_RPT ar ON fer.AGN_RPT_ID = ar.AGN_RPT_ID
	
	                                            LEFT JOIN P_EMIS_UNIT_CTRL_DEVC eucd ON euca.EMIS_UNIT_CTRL_APCH_ID = eucd.EMIS_UNIT_CTRL_APCH_ID
	                                            LEFT JOIN P_CTRL_DEVC cd ON eucd.CTRL_DEVC_ID = cd.CTRL_DEVC_ID
                                            WHERE
	                                            ar.AGN_RPT_ID = :reportId --current report being reported on
                                            ORDER BY
	                                            eu.EMIS_UNIT_IDEN ASC,
	                                            eucd.SEQ_NUM ASC

																	 " />
        <entry key="RegulatoryPrograms" value="SELECT
	                                                eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                                eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                                pgm.REG_PGM_DESC AS REG_PGM_DESC
                                                FROM
	                                                P_EMIS_UNIT_REG_PGM eurp
	                                                INNER JOIN P_EMIS_UNIT eu ON eurp.EMIS_UNIT_ID = eu.EMIS_UNIT_ID
	                                                INNER JOIN P_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
	                                                INNER JOIN P_FAC_EMIS_RPT fer ON fs.FAC_EMIS_RPT_ID = fer.FAC_EMIS_RPT_ID
	                                                INNER JOIN M_AGN_RPT ar ON fer.AGN_RPT_ID = ar.AGN_RPT_ID
	
	                                                INNER JOIN E_REG_PGM pgm ON eurp.E_REG_PGM_CD = pgm.E_REG_PGM_CD
                                                WHERE
	                                                ar.AGN_RPT_ID = :reportId --current report being reported on
                                                ORDER BY
	                                                eu.EMIS_UNIT_IDEN ASC,
	                                                pgm.REG_PGM_DESC ASC		" />
        <entry key="AdditionalInformation" value="SELECT
	                                                  eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                                  eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                                  cf.FLD_LABEL AS FLD_NAME,
	                                                  cfv.CSTM_FLD_VAL AS FLD_VALUE
                                                  FROM
	                                                  P_EMIS_UNIT_CSTM_FLD_VAL cfv 
	                                                  INNER JOIN A_CSTM_FLD cf ON cfv.A_CSTM_FLD_ID = cf.A_CSTM_FLD_ID
	                                                  INNER JOIN P_EMIS_UNIT eu ON cfv.EMIS_UNIT_ID = eu.EMIS_UNIT_ID
	                                                  INNER JOIN P_FAC_SITE fs ON eu.FAC_SITE_ID = fs.FAC_SITE_ID
	                                                  INNER JOIN P_FAC_EMIS_RPT fer ON fs.FAC_EMIS_RPT_ID = fer.FAC_EMIS_RPT_ID
	                                                  INNER JOIN M_AGN_RPT ar ON fer.AGN_RPT_ID = ar.AGN_RPT_ID
                                                  WHERE
	                                                  ar.AGN_RPT_ID = :reportId --current report being reported on
                                                  ORDER BY
	                                                  eu.EMIS_UNIT_IDEN ASC,
	                                                  cf.FLD_LABEL ASC" />
      </dictionary>
    </property>
  </object>
</objects>
