<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output method="html"/>
	<xsl:key name="violation" match="/dataroot/Violationenforcementassignment" use="PWSID"/>
	<xsl:key name="enforcement" match="/dataroot/Enforcementaction" use="PWSID"/>

	<xsl:template match="/">
		<p>
			<table width="100%" border="1">
				<tbody>
					<tr>
						<td><b>Water System Number</b></td>
						<td><b>Violations - Enforcement Actions</b></td>
					</tr>
					<xsl:for-each select="/dataroot/Violationenforcementassignment[generate-id() = generate-id(key('violation', PWSID)[1])]">
						<tr>
							<td>
								<xsl:value-of select="PWSID"/>
							</td>
							<td>
								<p><b>Violations</b></p>

								<table width="100%" border="0">
									<tbody>
										<tr>
											<td>
												<b>VIOID</b>
											</td>
											<td>
												<b>ENFID</b>
											</td>
											<td>
												<b>CREATEDDATE</b>
											</td>
										</tr>
										<xsl:for-each select="key('violation', PWSID)">
											<tr>
												<td>
													<xsl:value-of select="VIOID"/>
												</td>
												<td>
													<xsl:value-of select="ENFID"/>
												</td>
												<td>
													<xsl:value-of select="CREATEDDATE"/>
												</td>
											</tr>
										</xsl:for-each>
									</tbody>
								</table>

								<div/>

								<p><b>Enforcement Actions</b></p>
								<table width="100%" border="0">
									<tbody>
										<tr>
											<td><b>ENFID</b></td>
											<td><b>DATAORIGINCODE</b></td>
											<td><b>ENFDATE</b></td>
											<td><b>ENFACTIONTYPE</b></td>
											<td><b>VALIDITYINDICATOR</b></td>
											<td><b>FIRSTREPORTEDDATE</b></td>
											<td><b>LASTREPORTEDDATE</b></td>
										</tr>

										<xsl:for-each select="key('enforcement', PWSID)">
											<tr>
												<td>
													<xsl:value-of select="ENFID"/>
												</td>
												<td>
													<xsl:value-of select="DATAORIGINCODE"/>
												</td>
												<td>
													<xsl:value-of select="ENFDATE"/>
												</td>
												<td>
													<xsl:value-of select="ENFACTIONTYPE"/>
												</td>
												<td>
													<xsl:value-of select="VALIDITYINDICATOR"/>
												</td>
												<td>
													<xsl:value-of select="FIRSTREPORTEDDATE"/>
												</td>
												<td>
													<xsl:value-of select="LASTREPORTEDDATE"/>
												</td>
											</tr>
										</xsl:for-each>
									</tbody>
								</table>
							</td>
						</tr>
					</xsl:for-each>
				</tbody>
			</table>
		</p>
	</xsl:template>
</xsl:stylesheet><!-- Stylus Studio meta-information - (c) 2004-2005. Progress Software Corporation. All rights reserved.
<metaInformation>
<scenarios ><scenario default="yes" name="Scenario1" userelativepaths="yes" externalpreview="no" url="Violationenforcementassignment.xml" htmlbaseurl="" outputurl="" processortype="internal" useresolver="yes" profilemode="0" profiledepth="" profilelength="" urlprofilexml="" commandline="" additionalpath="" additionalclasspath="" postprocessortype="none" postprocesscommandline="" postprocessadditionalpath="" postprocessgeneratedext="" validateoutput="no" validator="internal" customvalidator=""/></scenarios><MapperMetaTag><MapperInfo srcSchemaPathIsRelative="yes" srcSchemaInterpretAsXML="no" destSchemaPath="" destSchemaRoot="" destSchemaPathIsRelative="yes" destSchemaInterpretAsXML="no"/><MapperBlockPosition></MapperBlockPosition><TemplateContext></TemplateContext><MapperFilter side="source"></MapperFilter></MapperMetaTag>
</metaInformation>
-->