HCCA | This Week in Corporate Compliance

Compliance Today

Compliance Today Issue Archive

TWCC

TWCC Archive

TWCC Subscribe

TWCC Unsubscribe

Medicaid Compliance News

HCCA News on Twitter

HCCA Facebook Group

HCCA Facebook Fan Page

HCCA Linkedin

Click to verify BBB accreditation and to see a BBB report.

Print this page

This Week in Corporate Compliance current issue.

This Week in Corporate Compliance, HCCA's email periodical is free to all visitors to our web site who choose to subscribe. Choose one of the links below to see what's new or
Click here to subscribe Click here to unsubscribe

If you have comments or suggestions please send an email to service@hcca-info.org

Debugging Information

ColdFusion Server Standard	7,0,2,142559
Template	/AM/Template.cfm
Time Stamp	20-Jul-10 11:11 AM
Locale	English (US)
User Agent
Remote IP	192.168.110.2
Host Name	192.168.110.2

Execution Time

Total Time	Avg Time	Count	Template
47 ms	47 ms	1	D:\eCMWebsites\hcca\AM\Application.cfm
47 ms	47 ms	1	D:\eCMWebsites\hcca\AM\LoadSessionVariables.cfm
47 ms	47 ms	1	D:\eCMWebsites\hcca\AM\Template.cfm
31 ms	31 ms	1	D:\eCMWebsites\hcca\AM\CM\HTMLDisplay.cfm
31 ms	31 ms	1	D:\eCMWebsites\hcca\AM\TemplateBody.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\ApplicationCustom.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\ApplicationUDFs.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\DetermineHeader.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\OnRequestEnd.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\TemplateSection.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\FooterInclude.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\HeaderInclude.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\TemplateFooter\TemplateFooter.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\TemplateHeader\TemplateHeader.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\TemplateSideNav.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\TemplateTopNav.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\customsource\tscPO\footer.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
94 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

GetSystemVariables (Datasource=iMIS_HCCA, Time=47ms, Records=38) in D:\eCMWebsites\hcca\AM\LoadSessionVariables.cfm @ 11:11:56.056

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

GetHTML (Datasource=iMIS_HCCA, Time=16ms, Records=1) in D:\eCMWebsites\hcca\AM\CM\HTMLDisplay.cfm @ 11:11:56.056

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

Query Parameter Value(s) -

			
			    
	        		
			        Parameter #1(CF_SQL_NUMERIC) = 7952

Stored Procedures

amsp_CMGetPublishedContentID (Datasource=iMIS_HCCA, Time=0ms) in D:\eCMWebsites\hcca\AM\CM\HTMLDisplay.cfm @ 11:11:56.056

parameters

type CFSQLType value variable dbVarName

IN CF_SQL_NUMERIC 7952

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:\eCMWebsites\hcca\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=www.hcca-info.org
HTTP_REFERER=
HTTP_USER_AGENT=
PATH_INFO=/AM/Template.cfm
PATH_TRANSLATED=D:\eCMWebsites\hcca\AM\Template.cfm
QUERY_STRING=Section=TWCC&Template=/CM/HTMLDisplay.cfm&ContentID=7952&FuseFlag=1
REMOTE_ADDR=192.168.110.2
REMOTE_HOST=192.168.110.2
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/AM/Template.cfm
SERVER_NAME=hcca-ww1.hcca.internal
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Client Variables:
cfid=9225510
cftoken=71838833
hitcount=1
lastvisit={ts '2010-07-20 11:11:56'}
pausetrans=0
timecreated={ts '2010-07-20 11:11:56'}
urltoken=CFID=9225510&CFTOKEN=71838833

Cookie Variables:
CFID=9225510
CFTOKEN=71838833

Session Variables:
admin=False
administrator=False
adminsectionlist=
alldynamic=N
bebroadcastemail=Array (0)
bebulkemailauditid=0
bememberid=
browser=Unknown
browserversion=0
cfid=9225510
cftoken=71838833
chapter=
cm=Struct (13)
cmbordercolor=#D1CDBB
cmcurrentfolderid=
cmeditorredirecturl=
cmfolderdisplay=
cmfoldersectiondisplay=
cmnavcontentgroupind=N
cmsavetemplatepath=
cmsectiondisplay=
cmsuperadminflag=
cmsurftoeditcontentid=0
cmsurftoeditreturnurl=
cmtextonlytemplate=False
cmwebsitekey=
committee=
companymaster=false
companymembershipnum=
companyname=
contactid=0
coregistrant=Array (0)
cpinvitegroupmembers=Array (0)
debug=False
emailaddress=
faqflag=
firstname=
fontface=verdana
fontsize=2
geformsubmitted=false
headersize=3
imismemberid=
initialized=True
interestcategorylist=
jbcompany=Struct (0)
jbpreview=Struct (0)
jbsearch=Struct (0)
lastname=
location=Struct (8)
loggedin=0
member=Struct (18)
memberid=0
membershipflag=false
membertype=
message=
ol=Struct (2)
platform=Windows
publicresultsflag=
questiondisplaylimit=
redirect=
redirectfrom=
registrationpage=
rowcolor1=ccffff
rowcolor2=ccffcc
sc=Struct (3)
scadmincomponentcodelist=
screturnmessage=Click here to continue.
securitygrouplist=
sessionid=IMIS_HCCA_9225510_71838833
shoppingcart=Array (0)
staff=Struct (13)
surveydate=
surveyid=0
surveyreporttemplate=
surveyresponse=0
surveyresponseid=0
surveyreviewquestionlist=
surveytakenlist=
surveytype=
sy=Struct (20)
templatepath=/AM/Template.cfm?Section=TWCC
title=
urltoken=CFID=9225510&CFTOKEN=71838833
username=

URL Parameters:
CONTENTID=7952
FUSEFLAG=1
SECTION=TWCC
TEMPLATE=/CM/HTMLDisplay.cfm

Debug Rendering Time: 31 ms