MASSMED | Momentum Gaining for Universal Access in Massachusetts - Vital Signs

	Name:
	Password:

Massachusetts Medical Society
860 Winter Street
Waltham MA 02451
(800) 322-2303 or (781) 893-4610
© Copyright 2004

Momentum Gaining for Universal Access in Massachusetts

by Tom Walsh

Unlike many thorny public issues, providing universal access to affordable, high-quality medical care for all Massachusetts citizens enjoys the support of nearly everyone. How to get there, however, remains a very open question.

Despite the fact that the Bay State is one of the best when it comes to health coverage, somewhere between 450,000 and 600,000 Massachusetts citizens are not insured and do not have easy access to health care. "It is unconscionable that people remain uninsured in our state," Alan C. Woodward, M.D., MMS president, told the Society's House of Delegates at its Interim Meeting in November. His remark was greeted with enthusiastic applause.

Proposals Are Percolating
Just before Thanksgiving, Gov. Mitt Romney unveiled his plan. Health Care For All, a prominent advocacy group, has a plan that differs significantly from the governor's. The Blue Cross Blue Shield of Massachusetts (BCBSMA) Foundation expects to unveil a plan this spring, and in November it contributed a major cost-benefit study of the issue. more

Debugging Information

ColdFusion Server Standard	6,1,0,83762
Template	/AM/Template.cfm
Time Stamp	07-Feb-05 04:10 PM
Locale	English (US)
User Agent
Remote IP	172.16.10.163
Host Name	172.16.10.163

Execution Time

Total Time	Avg Time	Count	Template
63 ms	63 ms	1	D:\webfiles\MASSMED\WWW\AM\Template.cfm
32 ms	32 ms	1	D:\webfiles\MASSMED\WWW\AM\CM\HTMLDisplay.cfm
32 ms	32 ms	1	D:\webfiles\MASSMED\WWW\AM\TemplateBody.cfm
16 ms	16 ms	1	D:\webfiles\MASSMED\WWW\AM\Application.cfm
16 ms	16 ms	1	D:\webfiles\MASSMED\WWW\AM\LoadSessionVariables.cfm
16 ms	16 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\TemplateHeader\TemplateHeader.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\ApplicationCustom.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\ApplicationUDFs.cfm
0 ms	0 ms	2	D:\webfiles\MASSMED\WWW\AM\Common\CachedStoredProcTag.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\DetermineHeader.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Ecommerce\BasketSetupTag.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\HierMenu\HierMenuTag.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\TemplateSection.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\FooterInclude.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\HeaderInclude.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\TemplateFooter\TemplateFooter.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\TemplateSideNav.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\TemplateSideNavWithImages.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\TemplateTopNav.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
79 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

GetSystemVariables (Datasource=CFWeb, Time=0ms, Records=90) in D:\webfiles\MassMed\WWW\AM\LoadSessionVariables.cfm @ 16:10:35.035

  SELECT a.*
    FROM System_Variable a
   WHERE VariableTypeCode = 'E'

qSavedBasket (Datasource=CFWeb, Time=0ms, Records=0) in D:\webfiles\MassMed\WWW\AM\Ecommerce\BasketSetupTag.cfm @ 16:10:35.035

    SELECT a.*, 
           b.EtailerID,
           b.SKU,
           b.TaxableFlag,
           b.UnitPrice AS NewPrice,
           b.MemberPrice AS NewMemberPrice,
           b.QuantityEditableFlag,
           c.StockStatusDesc AS StockStatus
      FROM Basket_Save a WITH (NOLOCK),
           Product b WITH (NOLOCK),
           Stock_Status_Ref c WITH (NOLOCK)
     WHERE a.ProductID = b.ProductID
       AND b.StockStatusCode = c.StockStatusCode
       AND 1=0

GetHTML (Datasource=CFWeb, Time=32ms, Records=1) in D:\webfiles\MassMed\WWW\AM\CM\HTMLDisplay.cfm @ 16:10:35.035

    SELECT a.*, b.Keywords, b.Description, b.MembersOnlyFlag
      FROM Content_HTML a, Content b
     WHERE a.ContentID = b.ContentID
       AND a.ContentID = 6555

Stored Procedures

amsp_CMGetPublishedContentID (Datasource=CFWeb, Time=0ms) in D:\webfiles\MassMed\WWW\AM\CM\HTMLDisplay.cfm @ 16:10:35.035

parameters

type CFSQLType value variable dbVarName

IN CF_SQL_NUMERIC 6555

OUT CF_SQL_NUMERIC l_PublishedContentID = l_PublishedContentID

IN CF_SQL_NUMERIC 1

resultsets

name resultset

Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\webfiles\MASSMED\WWW\AM\Template.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=staging1.massmed.org
HTTP_REFERER=
HTTP_USER_AGENT=
PATH_INFO=/AM/Template.cfm
PATH_TRANSLATED=D:\webfiles\MassMed\WWW\AM\Template.cfm
QUERY_STRING=Section=Home&FUSEFLAG=1&TEMPLATE=/CM/HTMLDisplay.cfm&CONTENTID=6555
REMOTE_ADDR=172.16.10.163
REMOTE_HOST=172.16.10.163
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/AM/Template.cfm
SERVER_NAME=staging1.massmed.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Request Parameters:
defaultsectionurl=http://staging1.massmed.org/
graphicsdirectory=/AM/graphics/home_template/
l_htmlheadcontentinformation=
  
  
  
    
  
  
    
  
  
  
  
  MASSMED | Momentum Gaining for Universal Access in Massachusetts - Vital Signs - Dec 2004/Jan 2005
securewebsiterooturl=http://staging1.massmed.org/
websiteindex=2
websitekey=31cadfd9-b130-44b4-af2e-6603cbcc422b
websitekeyvar=31cadfd9_b130_44b4_af2e_6603cbcc422b
websitename=MASSMED
websiterooturl=http://staging1.massmed.org/

Session Variables:
admin=False
administrator=False
adminmicrositeid=0
adminsectionlist=
alldynamic=N
ba=Struct (1)
bannercompanyid=0
bebroadcastemail=Array (0)
bebulkemailauditid=0
bememberid=
bg=Struct (3)
bgcompanyid=0
bgselectionid=0
bgtransactionmode=
browser=Unknown
browserversion=0
candidateid=0
cc=Struct (4)
cdadministratorid=0
cfid=3524
cftoken=43511791
chapter=
cm=Struct (13)
cmbordercolor=#D1CDBB
cmcurrentfolderid=
cmeditorredirecturl=
cmfolderdisplay=
cmfoldersectiondisplay=
cmnavcontentgroupind=
cmsavetemplatepath=
cmsectiondisplay=
cmsuperadminflag=False
cmsurftoeditcontentid=0
cmsurftoeditreturnurl=
cmtextonlytemplate=False
cmwebsitekey=
committee=
companyid=0
companymaster=false
companymembershipnum=
companyname=
contactid=0
coregistrant=Array (0)
cp=Struct (4)
cpemailattachmentlist=
cpinvitationkey=
cpinvitegroupmembers=Array (0)
cpinvitegroupname=
cpinvitegroupsearchcriteria=
ctchapterid=0
customerid=0
cwadministrator=False
debug=False
ec=Struct (6)
eccheckoutprocessstart=false
eccouponnum=
ecshippingmethod=
ecstoreafcheckoutlink=
ecstoreafcheckoutlinkdesc=
eg=Struct (1)
egsubscribedgrouplist=
emailaddress=
faqflag=
firstname=
fontface=verdana
fontsize=2
geformsubmitted=false
headersize=3
imismemberid=
initialized=True
interestcategorylist=
jb=Struct (8)
jbcompany=Struct (0)
jbcompanyname=
jbcoverlettertext=
jbjobid=0
jbpreview=Struct (0)
jbresumesearchflag=false
jbsearch=Struct (0)
lastname=
location=Struct (8)
loggedin=0
mc=Struct (6)
mccurrentmessage=FALSE
mcfirsttime=True
mcmessagetext=
mcprimaryrecipients=
mcsecondaryrecipients=
mcsubject=
md=Struct (1)
mdsearchcriteria=
member=Struct (18)
memberid=0
membershipflag=false
membertype=
message=
ms=Struct (2)
msinitializeprocess=false
msmicrositeadminlist=
mycommittees=
myinterests=
ol=Struct (5)
pe=Struct (2)
platform=Windows
publicresultsflag=
questiondisplaylimit=
recruiterflag=false
recruiterid=0
redirect=
redirectfrom=
registrationpage=
rowcolor1=FFFFFF
rowcolor2=D1DDEA
savedbasket=Query (0)
sb=Struct (1)
sbpresenterid=0
sc=Struct (4)
scadmincomponentcodelist=
screturnmessage=Click here to continue.
scsecuritygroup=
securitygrouplist=
sessionid=CFUSER_3524_43511791
shoppingcart=Array (0)
staff=Struct (13)
su=Struct (8)
supreviewingsurvey=False
surespondingsurveyid=
sureviewingprocess=false
surveydate=
surveyid=0
surveyreporttemplate=
surveyresponse=0
surveyresponseid=0
surveyreviewquestionlist=
surveytakenlist=
surveytype=
susurveyid=0
susurveyresponseid=0
susurveyreviewquestionlist=
susurveytakenlist=
susurveytype=
sy=Struct (21)
templatepath=/AM/Template.cfm?Section=Home
title=
urltoken=CFID=3524&CFTOKEN=43511791
username=
voucheramount=
voucheramountremain=
voucheramountused=
vouchernumber=

URL Parameters:
CONTENTID=6555
FUSEFLAG=1
SECTION=Home
TEMPLATE=/CM/HTMLDisplay.cfm

Debug Rendering Time: 46 ms