<cfquery name="ViewVital" datasource="#Application.DataSrc#">
    SELECT Distinct Description FROM #Request.prefix_db_agency#.pWoundsVitals 
    WHERE Assmt_ID = '#url.Assmt_ID#'
    AND Status = 0
    AND VitalOrWound ='vital'
	AND Description <> ''
</cfquery>

<cfset viewVitalList = ValueList(ViewVital.description)>	
 <cfquery datasource="#Application.DataSrc#" name="GetVitals">
	SELECT Distinct Description,Item_ID,Required
	FROM   #Request.prefix_db_lookup#.pValue_Lookup
	WHERE Description <> 'wound'
	AND Description NOT IN (<cfqueryparam value="#viewVitalList#"  cfsqltype="CF_SQL_VARCHAR" list="yes">)
</cfquery>
<cfoutput query="GetVitals">
	<label>
		<input type="radio" name="description" value="#Description#" onClick="getVitalDesc(this.value);" />#Description# *
		<cfif Required EQ '*'><span style="font-weight:bold;color:red;">*</span></cfif> 
	</label>
</cfoutput>