﻿<?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="AgencyUnitProcessExport">
    <property name="Name" value="Agency_UnitProcess">
    </property>
    <property name="Queries">
      <dictionary key-type="System.String" value-type="System.String">
        <entry key="UnitProcesses" value="SELECT
	                                          eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                          eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                          up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                          up.PROC_DESC AS UNIT_PROC_DESC,
	                                          up.E_SRC_CLASS_CD As SRC_CLASS_CD,
	                                          sc.SHORT_NAME AS SRC_CLASS_NAME,
                                             up.FINAL_EMIS_YEAR,
	                                          up.PROC_CMNT AS UNIT_PROC_CMNT
                                          FROM
	                                          M_UNIT_PROC up
	                                          INNER JOIN M_EMIS_UNIT eu ON up.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_SRC_CLASS sc ON up.E_SRC_CLASS_CD = sc.E_SRC_CLASS_CD	
                                          WHERE
	                                          ar.AGN_RPT_ID = :reportId --current report being reported on
                                          ORDER BY
	                                          eu.EMIS_UNIT_IDEN ASC,
	                                          up.UNIT_PROC_IDEN ASC	
	                                          " />
        <entry key="ControlApproach" value="SELECT
	                                            eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                            eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                            up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                            up.PROC_DESC AS UNIT_PROC_DESC,
	                                            upca.CTRL_APCH_DESC AS CTRL_APCH_DESC,
	                                            upca.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,
	                                            upcd.SEQ_NUM AS CTRL_DEVC_SEQ_NUM
                                            FROM
	                                            M_UNIT_PROC_CTRL_APCH upca 
	                                            INNER JOIN M_UNIT_PROC up ON upca.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                            INNER JOIN M_EMIS_UNIT eu ON up.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_UNIT_PROC_CTRL_DEVC upcd ON upca.UNIT_PROC_CTRL_APCH_ID = upcd.UNIT_PROC_CTRL_APCH_ID
	                                            LEFT JOIN M_CTRL_DEVC cd ON upcd.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,
	                                            up.UNIT_PROC_IDEN ASC,
	                                            upcd.SEQ_NUM ASC
																	                                             " />
        <entry key="ReleasePointApportionment" value="SELECT
	                                                      eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                                      eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                                      up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                                      up.PROC_DESC AS UNIT_PROC_DESC,
	                                                      rp.REL_PT_IDEN AS REL_PT_IDEN,
	                                                      rp.REL_PT_DESC AS REL_PT_DESC,
	                                                      uprp.AVG_PCT_EMIS AS AVG_PCT_EMIS
                                                      FROM
	                                                      M_UNIT_PROC_REL_PT uprp
	                                                      INNER JOIN M_REL_PT rp ON uprp.REL_PT_ID = rp.REL_PT_ID
	                                                      INNER JOIN M_UNIT_PROC up ON uprp.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                                      INNER JOIN M_EMIS_UNIT eu ON up.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,
	                                                      up.UNIT_PROC_IDEN ASC,
	                                                      rp.REL_PT_IDEN ASC
																	                                             " />
        <entry key="RegulatoryPrograms" value="SELECT
	                                              eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                              eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                              up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                              up.PROC_DESC AS UNIT_PROC_DESC,
	                                              pgm.REG_PGM_DESC AS REG_PGM_DESC
                                              FROM
	                                              M_UNIT_PROC_REG_PGM uprp
	                                              INNER JOIN M_UNIT_PROC up ON uprp.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                              INNER JOIN M_EMIS_UNIT eu ON up.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 uprp.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,
	                                              up.UNIT_PROC_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,
	                                                  up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                                  up.PROC_DESC AS UNIT_PROC_DESC,
	                                                  cf.FLD_LABEL AS FLD_NAME,
	                                                  cfv.CSTM_FLD_VAL AS FLD_VALUE
                                                  FROM
	                                                  M_UNIT_PROC_CSTM_FLD_VAL cfv 
	                                                  INNER JOIN A_CSTM_FLD cf ON cfv.A_CSTM_FLD_ID = cf.A_CSTM_FLD_ID
	                                                  INNER JOIN M_UNIT_PROC up ON cfv.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                                  INNER JOIN M_EMIS_UNIT eu ON up.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,
	                                                  up.UNIT_PROC_IDEN ASC,
	                                                  cf.FLD_LABEL ASC" />
      </dictionary>
    </property>
  </object>
  <object type="Sleis.Export.ExportGroup" name="MasterUnitProcessExport">
    <property name="Name" value="Master_UnitProcess">
    </property>
    <property name="Queries">
      <dictionary key-type="System.String" value-type="System.String">
        <entry key="UnitProcesses" value="SELECT
	                                          eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                          eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                          up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                          up.PROC_DESC AS UNIT_PROC_DESC,
	                                          up.E_SRC_CLASS_CD As SRC_CLASS_CD,
	                                          sc.SHORT_NAME AS SRC_CLASS_NAME,
                                             up.FINAL_EMIS_YEAR
                                          FROM
	                                          M_UNIT_PROC up
	                                          INNER JOIN M_EMIS_UNIT eu ON up.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_SRC_CLASS sc ON up.E_SRC_CLASS_CD = sc.E_SRC_CLASS_CD	
                                          WHERE
	                                          fs.FAC_SITE_ID = :facilityId --current facility
	                                          AND fs.FAC_SITE_MSTR_IND = 1
                                          ORDER BY
	                                          eu.EMIS_UNIT_IDEN ASC,
	                                          up.UNIT_PROC_IDEN ASC
	                                          " />
        <entry key="ControlApproach" value="SELECT
	                                            eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                            eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                            up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                            up.PROC_DESC AS UNIT_PROC_DESC,
	                                            upca.CTRL_APCH_DESC AS CTRL_APCH_DESC,
	                                            upca.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,
	                                            upcd.SEQ_NUM AS CTRL_DEVC_SEQ_NUM
                                            FROM
	                                            M_UNIT_PROC_CTRL_APCH upca 
	                                            INNER JOIN M_UNIT_PROC up ON upca.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                            INNER JOIN M_EMIS_UNIT eu ON up.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_UNIT_PROC_CTRL_DEVC upcd ON upca.UNIT_PROC_CTRL_APCH_ID = upcd.UNIT_PROC_CTRL_APCH_ID
	                                            LEFT JOIN M_CTRL_DEVC cd ON upcd.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,
	                                            up.UNIT_PROC_IDEN ASC,
	                                            upcd.SEQ_NUM ASC
																	                                             " />
        <entry key="ReleasePointApportionment" value="SELECT
	                                                      eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                                      eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                                      up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                                      up.PROC_DESC AS UNIT_PROC_DESC,
	                                                      rp.REL_PT_IDEN AS REL_PT_IDEN,
	                                                      rp.REL_PT_DESC AS REL_PT_DESC,
	                                                      uprp.AVG_PCT_EMIS AS AVG_PCT_EMIS
                                                      FROM
	                                                      M_UNIT_PROC_REL_PT uprp
	                                                      INNER JOIN M_REL_PT rp ON uprp.REL_PT_ID = rp.REL_PT_ID
	                                                      INNER JOIN M_UNIT_PROC up ON uprp.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                                      INNER JOIN M_EMIS_UNIT eu ON up.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,
	                                                      up.UNIT_PROC_IDEN ASC,
	                                                      rp.REL_PT_IDEN ASC
																	                                             " />
        <entry key="RegulatoryPrograms" value="SELECT
	                                              eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                              eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                              up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                              up.PROC_DESC AS UNIT_PROC_DESC,
	                                              pgm.REG_PGM_DESC AS REG_PGM_DESC
                                              FROM
	                                              M_UNIT_PROC_REG_PGM uprp
	                                              INNER JOIN M_UNIT_PROC up ON uprp.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                              INNER JOIN M_EMIS_UNIT eu ON up.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 uprp.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,
	                                              up.UNIT_PROC_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,
	                                                  up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                                  up.PROC_DESC AS UNIT_PROC_DESC,
	                                                  cf.FLD_LABEL AS FLD_NAME,
	                                                  cfv.CSTM_FLD_VAL AS FLD_VALUE
                                                  FROM
	                                                  M_UNIT_PROC_CSTM_FLD_VAL cfv 
	                                                  INNER JOIN A_CSTM_FLD cf ON cfv.A_CSTM_FLD_ID = cf.A_CSTM_FLD_ID
	                                                  INNER JOIN M_UNIT_PROC up ON cfv.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                                  INNER JOIN M_EMIS_UNIT eu ON up.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,
	                                                  up.UNIT_PROC_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,
	                                        up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                        up.PROC_DESC AS UNIT_PROC_DESC,
	                                        upi.UNIT_PROC_IDEN AS ALT_UNIT_PROC_IDEN,
	                                        upi.A_PROG_SYS_CD AS ALT_UNIT_PROC_IDEN_SYS_CD,
	                                        upi.EFF_DATE AS ALT_UNIT_PROC_IDEN_EFF_DATE
                                        FROM
	                                        M_UNIT_PROC_IDEN upi
	                                        INNER JOIN M_UNIT_PROC up ON upi.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                        INNER JOIN M_EMIS_UNIT eu ON up.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,
	                                      up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                      up.PROC_DESC AS UNIT_PROC_DESC,
	                                      upc.CMNT_TXT,
	                                      CASE 
		                                      WHEN upc.CMNT_BY_USER_ID IS NULL THEN 'Agency Editor'
		                                      ELSE s.USER_FULL_NAME
	                                      END AS CMNT_BY,
	                                      upc.CMNT_DATE AS CMNT_DATE
                                      FROM
	                                      M_UNIT_PROC_CMNT upc
	                                      INNER JOIN M_UNIT_PROC up ON upc.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                      INNER JOIN M_EMIS_UNIT eu ON up.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 upc.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="PublicUnitProcessExport">
    <property name="Name" value="Public_UnitProcess">
    </property>
    <property name="Queries">
      <dictionary key-type="System.String" value-type="System.String">
        <entry key="UnitProcesses" value="SELECT
	                                          eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                          eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                          up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                          up.PROC_DESC AS UNIT_PROC_DESC,
	                                          up.E_SRC_CLASS_CD As SRC_CLASS_CD,
	                                          sc.SHORT_NAME AS SRC_CLASS_NAME,
                                             up.FINAL_EMIS_YEAR,
	                                          up.PROC_CMNT AS UNIT_PROC_CMNT
                                          FROM
	                                          P_UNIT_PROC up
	                                          INNER JOIN P_EMIS_UNIT eu ON up.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_SRC_CLASS sc ON up.E_SRC_CLASS_CD = sc.E_SRC_CLASS_CD	
                                          WHERE
	                                          ar.AGN_RPT_ID = :reportId --current report being reported on
                                          ORDER BY
	                                          eu.EMIS_UNIT_IDEN ASC,
	                                          up.UNIT_PROC_IDEN ASC
	                                          " />
        <entry key="ControlApproach" value="SELECT
	                                            eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                            eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                            up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                            up.PROC_DESC AS UNIT_PROC_DESC,
	                                            upca.CTRL_APCH_DESC AS CTRL_APCH_DESC,
	                                            upca.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,
	                                            upcd.SEQ_NUM AS CTRL_DEVC_SEQ_NUM
                                            FROM
	                                            P_UNIT_PROC_CTRL_APCH upca 
	                                            INNER JOIN P_UNIT_PROC up ON upca.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                            INNER JOIN P_EMIS_UNIT eu ON up.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_UNIT_PROC_CTRL_DEVC upcd ON upca.UNIT_PROC_CTRL_APCH_ID = upcd.UNIT_PROC_CTRL_APCH_ID
	                                            LEFT JOIN P_CTRL_DEVC cd ON upcd.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,
	                                            up.UNIT_PROC_IDEN ASC,
	                                            upcd.SEQ_NUM ASC " />
        <entry key="ReleasePointApportionment" value="SELECT
	                                                      eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                                      eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                                      up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                                      up.PROC_DESC AS UNIT_PROC_DESC,
	                                                      rp.REL_PT_IDEN AS REL_PT_IDEN,
	                                                      rp.REL_PT_DESC AS REL_PT_DESC,
	                                                      uprp.AVG_PCT_EMIS AS AVG_PCT_EMIS
                                                      FROM
	                                                      P_UNIT_PROC_REL_PT uprp
	                                                      INNER JOIN P_REL_PT rp ON uprp.REL_PT_ID = rp.REL_PT_ID
	                                                      INNER JOIN P_UNIT_PROC up ON uprp.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                                      INNER JOIN P_EMIS_UNIT eu ON up.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,
	                                                      up.UNIT_PROC_IDEN ASC,
	                                                      rp.REL_PT_IDEN ASC
																	                                             " />
        <entry key="RegulatoryPrograms" value="SELECT
	                                              eu.EMIS_UNIT_IDEN AS EMIS_UNIT_IDEN,
	                                              eu.UNIT_DESC AS EMIS_UNIT_DESC,
	                                              up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                              up.PROC_DESC AS UNIT_PROC_DESC,
	                                              pgm.REG_PGM_DESC AS REG_PGM_DESC
                                              FROM
	                                              P_UNIT_PROC_REG_PGM uprp
	                                              INNER JOIN P_UNIT_PROC up ON uprp.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                              INNER JOIN P_EMIS_UNIT eu ON up.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 uprp.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,
	                                              up.UNIT_PROC_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,
	                                                  up.UNIT_PROC_IDEN AS UNIT_PROC_IDEN,
	                                                  up.PROC_DESC AS UNIT_PROC_DESC,
	                                                  cf.FLD_LABEL AS FLD_NAME,
	                                                  cfv.CSTM_FLD_VAL AS FLD_VALUE
                                                  FROM
	                                                  P_UNIT_PROC_CSTM_FLD_VAL cfv 
	                                                  INNER JOIN A_CSTM_FLD cf ON cfv.A_CSTM_FLD_ID = cf.A_CSTM_FLD_ID
	                                                  INNER JOIN P_UNIT_PROC up ON cfv.UNIT_PROC_ID = up.UNIT_PROC_ID
	                                                  INNER JOIN P_EMIS_UNIT eu ON up.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,
	                                                  up.UNIT_PROC_IDEN ASC,
	                                                  cf.FLD_LABEL ASC" />
      </dictionary>
    </property>
  </object>
</objects>