Versions Compared

Key

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

Health Level Seven International June 21, 2019

Health Level Seven International® invites you to take part in the early ballot openings for balloting HL7 candidate standards and documents for the upcoming September 2019 ballot cycle. 

The candidate standards and other documents described in this announcement are balloting prior to HL7's September 2019 Working Group Meeting (WGM). Comments received from consensus group members will be addressed at that WGM running May 4-10running September 14-20, 2019 in Montreal (Quebec), CanadaAtlanta GA USA.


Ballot Period Open/Close Dates

Voting for consensus group members in most ballots in this document will open and close on the following dates.  Exceptions for a specific ballot are listed with that ballot description.


Ballot Open Date: Friday, June 21, 2019

Ballot Close Date: Monday, July 22, 2019

Consensus Group Enrollment Period

Consensus Group Enrollment Period is now closed

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

Changes from the initial announcement are identified in the Update to Ballot Announcement for September 2019 Ballot Cycle  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.


The grid below provides the name of the sponsoring and co-sponsoring Work Group(s) announcing the ballot opening for the ballot listed. Those interested in ballots for a certain attribute can sort the grid: by Work Group, or by product family for example, 


SQL
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;column-width:300px;", style="border-bottom:black 1px solid;column-width:250px;", style="border-bottom:black 1px solid;column-width:250px;",
dataSourceHL7 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_document_sdo.ballot_document_sdo_project_ref_id as 'Project ID' --added on February 26, 2019
,rtrim(ballot_documents.ballot_name) as "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
ballot_documents.ballot_rootcode as "Family",

(CASE 
		WHEN cast(ballot_documents.ballot_iteration as varchar(1))='0' then 'Never Balloted'
		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 cast(ballot_documents.ballot_iteration as varchar(1))='0' then ''
		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" 
 --,view_ballot_documents_lastballoted_edited.ballot_cycle_code as 'last ballot date'
,cast(ballot_pool_approval.ballot_project_description AS varchar(MAX)) as "Ballot Description"
, 'Since the last ballot of this material in ' + view_ballot_documents_lastballoted_edited.ballot_cycle_code +
', the following changes have been made: ' + cast(ballot_pool_approval.ballot_changes_since_last  AS varchar(MAX))  as 'Last Balloted'
,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
    full outer JOIN view_ballot_documents_lastballoted_edited -- added february 26 2019 in to correct the view view_ballot_documents_lastballoted listed above
		ON ballot_documents.ballot_document_sdo_id = view_ballot_documents_lastballoted_edited.ballot_document_sdo_id
	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
			inner join ballot_document_sdo on ballot_documents.ballot_document_sdo_id = ballot_document_sdo.ballot_document_sdo_id
	WHERE   (ballot_pool_approval.ballot_pool_submitted_status = 1) and  (ballot_pool_approval.ballot_cycle_id = 550) and (begindate='2019-06-21')
	ORDER BY wg.wg_shortname, ballot_documents.ballot_code --grouping_id




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

For Help, see Balloting Help