Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Health Level Seven International® invites you to take part in the formation of consensus groups for balloting HL7 candidate standards and documents for the upcoming January 2019 ballot cycle. The candidate standards and other documents described in this announcement are expected to ballot prior to HL7's January 2019 Working Group Meeting (WGM). Comments received from consensus group members will be addressed at that WGM running January 12 - 18, 2018 in San Antonio TX USA.

Consensus Group Sign-Up Open Date: Monday, February 25, 2019

Consensus Group Sign-Up Close Date: Thursday, March 28, 2019

Important Note: Consensus group signup closes when ballot voting begins.

Ballot Open Date: Friday, March 29, 2019

Ballot Close Date: Monday, April 29, 2019

Exceptions for a specific ballot are listed with that ballot description.

Please note that the following details about specific items are subject to review by the HL7 Technical Steering Committee:

  • Approval of all projects initiating any ballot item
  • Approval of titles for new candidate and draft standards and other documents
  • Approval of new candidate Standards for Trial Use
  • Approval of ballot level for those items moving to Normative ballot

Any changes from the initial details in this announcement will be identified in the ballot announcement document released when this ballot cycle opens.

All those engaged in balloting should be informed that any subsequent ballot of material previously balloted at the normative level will supersede all previous ballots. Any votes or comments from previous ballots will not count towards the new normative ballot; for any comments to be considered again, voters will need to cast a new ballot with comments.



SQL Query
sortColumn1
allowExporttrue
width100%
columnAttributesstyle="font-weight:bold;border-bottom:black 1px solid;font-style:italic;font-size:14px;", style="border-bottom:black 1px solid;column-width:180px;", style="border-bottom:black 1px solid;", style="border-bottom:black 1px solid;column-width:400px;", style="border-bottom:black 1px solid;column-width:300px;", style="border-bottom:black 1px solid;", style="border-bottom:black 1px solid;", style="border-bottom:black 1px solid;", style="border-bottom:black 1px solid;vertical-align:left:", style="border-bottom:black 1px solid;",
dataSourceHL72 Connection
-- Extract ballot records for announcement and TSC Approval document
use HL72

select rtrim(wg.wg_shortname) as "Work Group"
--, 'and '+ pool_wg.wg_shortname ' Work Group announces the formation of a consensus group for the following item: [Ballot and title pending Technical Steering Committee approval.] |^'
, ballot_documents.ballot_name  
--formatting to add US Realm should not be necessary by this point as the insert and create scripts should catch it
--,	CASE ballot_pool_approval.ballot_realm_uv
--		WHEN 1 then ballot_documents.ballot_name
--		ELSE
--			CASE CHARINDEX('US Realm', ballot_documents.ballot_name) 
--			WHEN  0 THEN ballot_documents.ballot_name + '- US Realm'
--			ELSE ballot_documents.ballot_name
--			END
--	END
+CHAR(10)+CHAR(10)+(case when ballot_pool_approval.ballot_alt_document_name <>''
	then ' Requesting alternate ballot title "' + ballot_pool_approval.ballot_alt_document_name+'" '
	else ''
	end) as "Ballot Name",
ballot_documents.ballot_rootcode as "Family",

(CASE 
		WHEN cast(ballot_documents.ballot_iteration as varchar(1))='1' then '1st '
		WHEN cast(ballot_documents.ballot_iteration as varchar(1))='2' then '2nd '
		WHEN cast(ballot_documents.ballot_iteration as varchar(1))='3' then '3rd '
		ELSE cast(view_last.ballot_iteration as varchar(1)) + 'th '
	END 
	+ CASE 
		WHEN view_last.ballot_standard_level_shortname='Standard for Trial Use                             ' then 'STU Ballot'
		WHEN view_last.ballot_standard_level_shortname='Comment                                            ' then 'Comment-Only Ballot'
		ELSE rtrim(view_last.ballot_standard_level_shortname) + ' Ballot'
END)as "Ballot Iteration" 
 
,cast(ballot_pool_approval.ballot_project_description AS varchar(MAX))+char(10)+char(10)+
+(case 
	when cast (ballot_documents.ballot_iteration as int) > 1 then '  Since the last ballot of this material in '+ 
		view_ballot_documents_lastballoted.ballot_cycle_code + ', the following changes have been made: ' 
		+ cast(ballot_pool_approval.ballot_changes_since_last  AS varchar(MAX))
	else ''
 END) as "Ballot Description"
,ballot_documents.ballot_code as "Unique Ballot ID"
,CONVERT(VARCHAR(10), ballot_documents.signupdate, 111) as "Pool enrollment opens"
,CONVERT(VARCHAR(10), ballot_documents.signupclosedate, 111) as "Pool enrollment closes"
--,CONVERT(VARCHAR(10), ballot_documents.begindate, 111) as "Ballot opens"
--,CONVERT(VARCHAR(10), ballot_documents.enddate, 111) as "Ballot closes"
	FROM         ballot_documents 
	INNER JOIN   wg
		ON ballot_documents.wg_id = wg.wg_id
	--the following inner join is to get the last balloted date
	INNER JOIN view_ballot_documents_lastballoted
		ON ballot_documents.ballot_name = view_ballot_documents_lastballoted.ballot_name
	RIGHT OUTER JOIN      ballot_pool_approval 
		ON ballot_documents.ballot_document_sdo_id = ballot_pool_approval.ballot_document_sdo_id and ballot_documents.ballot_cycle_id=ballot_pool_approval.ballot_cycle_id
		--right outer join  wg_ballot_pool_approval on ballot_pool_approval.ballot_pool_id=wg_ballot_pool_approval.ballot_pool_id
		--	INNER JOIN   wg pool_wg 		ON wg_ballot_pool_approval.wg_id = pool_wg.wg_id
			JOIN  view_ballot_documents_lastballoted view_last on ballot_documents.ballot_document_sdo_id = view_last.ballot_document_sdo_id
	WHERE   (ballot_pool_approval.ballot_pool_submitted_status = 1) and  (ballot_pool_approval.ballot_cycle_id = 549)
	ORDER BY ballot_documents.ballot_code --grouping_id
	
--select * from ballot_documents where ballot_cycle_id=540


--add join on dbo.wg_ballot_pool_approval.wg_id to wg.wg_id for cosponsoring wgs

--select * fROM         ballot_documents 
--	RIGHT OUTER JOIN      ballot_pool_approval 
--		ON ballot_documents.ballot_document_sdo_id = ballot_pool_approval.ballot_document_sdo_id and ballot_documents.ballot_cycle_id=ballot_pool_approval.ballot_cycle_id
--WHERE   (ballot_pool_approval.ballot_pool_submitted_status = 1)  AND  (ballot_pool_approval.ballot_cycle_id = 546)



For more information on ballot procedure, such as general guidelines, and voting, see Ballot Procedures and Guidelines

For Help, see Balloting Help