Become an HCCA MemberLoginSite MapSearchContact HCCAHome Page
   
HCCAnet | HCCA's Social Network
Member Center
About HCCA
Shop Online
Events
Sponsorship Opportunities
Compliance Publications
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
Compliance Resources
CHC Certification
CHRC Certification
CHPC Certification
CHC-F Certification
Health Care Compliance Job Board


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

 

Print this page


Unsubscribe from This Week in Corporate Compliance

At the bottom of each email from HCCA there is a link to unsubscribe. Just click that link an you will be removed from the list. Or use the links below.

If you have trouble unsubscribing please email service@hcca-info.org.



Related Links
Unsubscribe from TWCC
Modify your subscription


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
219 ms 219 ms 1 top level D:\eCMWebsites\hcca\AM\Template.cfm
203 ms 203 ms 1 D:\eCMWebsites\hcca\AM\CM\ContentDisplay.cfm
203 ms 203 ms 1 D:\eCMWebsites\hcca\AM\TemplateBody.cfm
47 ms 47 ms 1 D:\eCMWebsites\hcca\AM\Application.cfm
47 ms 47 ms 1 D:\eCMWebsites\hcca\AM\LoadSessionVariables.cfm
16 ms 16 ms 1 D:\eCMWebsites\hcca\AM\DetermineHeader.cfm
16 ms 16 ms 1 D:\eCMWebsites\hcca\AM\TemplateSection.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\OnRequestEnd.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
266 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:57.057
  SELECT a.*
    FROM System_Variable a
   WHERE VariableTypeCode = 'E'
CheckMembersOnlyFlag (Datasource=iMIS_HCCA, Time=15ms, Records=1) in D:\eCMWebsites\hcca\AM\CM\ContentDisplay.cfm @ 11:11:57.057
      SELECT MembersOnlyFlag FROM Content WHERE ContentID = ?
    
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 8023

GetContentInfo (Datasource=iMIS_HCCA, Time=16ms, Records=1) in D:\eCMWebsites\hcca\AM\CM\ContentDisplay.cfm @ 11:11:57.057
        SELECT a.Keywords,
               a.Description,
               a.ShowInTemplateFlag,
               a.OpenInNewWindowFlag,
               a.SuppressBannersFlag,
               b.ContentID AS HTMLContentID,
               b.Title,
               b.Body,
               c.TemplatePath,
               c.Name,
               c.NavContentGroupInd,
               (SELECT COUNT(*) FROM Content_File WHERE ContentID = ?) AS FileCount,
               (SELECT COUNT(*) FROM Content_Link WHERE ContentID = ?) AS LinkCount,
               d.RelatedFilesTitle,
               d.RelatedLinksTitle
         FROM Nav_Menu c LEFT OUTER JOIN Website d
           ON c.WebsiteKey = d.WebsiteKey, Content a LEFT OUTER JOIN Content_HTML b
           ON a.ContentID = b.ContentID
        WHERE a.ContentID = ?
          AND c.NavMenuID = a.NavMenuID
      
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 8023
Parameter #2(CF_SQL_NUMERIC) = 8023
Parameter #3(CF_SQL_NUMERIC) = 8023

GetLinks (Datasource=iMIS_HCCA, Time=125ms, Records=2) in D:\eCMWebsites\hcca\AM\CM\ContentDisplay.cfm @ 11:11:57.057
          SELECT a.*
            FROM Content_Link a, Content b 
           WHERE a.ContentID = ?
					   AND a.ContentID = b.ContentID
						 ORDER by b.UserDefinedDate1 Desc, a.SortOrder
           
        
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 8023


Stored Procedures

amsp_CMGetPublishedContentID (Datasource=iMIS_HCCA, Time=0ms) in D:\eCMWebsites\hcca\AM\CM\ContentDisplay.cfm @ 11:11:57.057
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_NUMERIC  8023    
 OUT  CF_SQL_NUMERIC    l_PublishedContentID = l_PublishedContentID  
 IN  CF_SQL_NUMERIC  1    
    
resultsets
nameresultset


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_Unsubscribe&Template=/CM/ContentDisplay.cfm&ContentID=8023&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=9225513
cftoken=13650690
hitcount=1
lastvisit={ts '2010-07-20 11:11:57'}
pausetrans=0
timecreated={ts '2010-07-20 11:11:57'}
urltoken=CFID=9225513&CFTOKEN=13650690
Cookie Variables:
CFID=9225513
CFTOKEN=13650690
Session Variables:
admin=False
administrator=False
adminsectionlist=
alldynamic=N
bebroadcastemail=Array (0)
bebulkemailauditid=0
bememberid=
browser=Unknown
browserversion=0
cfid=9225513
cftoken=13650690
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_9225513_13650690
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_Unsubscribe
title=
urltoken=CFID=9225513&CFTOKEN=13650690
username=
URL Parameters:
CONTENTID=8023
FUSEFLAG=1
SECTION=TWCC_Unsubscribe
TEMPLATE=/CM/ContentDisplay.cfm
Debug Rendering Time: 31 ms