Other Heritage Sites | Blog | Bookstore | About Us | Contact Us 

Advanced Search
Heritage home Issues Where We Stand Experts Press and Media Support Heritage





  ISSUES  > Health Care
 
icon_print
Email This Link
December 3, 2007
SCHIP Bill Increases Illegal Immigrants' Access to Medicaid and Undermines Welfare Reform
WebMemo #1714

Under current law, illegal immigrants are eligible for emergency medical services funded through the Medicaid program but are not eligible for normal benefits through Medicaid or the State Children's Health Insurance Program (SCHIP). In addition, according to the provisions of the 1996 welfare reform law, legal immigrants are not eligible for normal Medicaid and SCHIP benefits for the first five years they reside in the United States.

The Children's Health Insurance Program Reauthorization Act of 2007 (H.R. 3963),passed in the Senate and the House of Representatives,[1] significantly changes the law with respect to both legal and illegal immigrants. H.R. 3963 affects not only SCHIP but also the far larger general Medicaid program. Specifically, the SCHIP reauthorization bill:

  • weakens the evidentiary and document standards governing entry into the Medicaid program, thereby making it easier for illegal immigrants to fraudulently obtain benefits; and
  • overturns the limitations on immigrant use of Medicaid enacted in the 1996 welfare reform law by gutting the administrative procedures used to determine immigrant eligibility, thereby readily permitting immigrants to receive benefits for which they remain legally ineligible.

Problems with the Bill

  1. Increasing Fraud by Illegal Immigrants. Current law requires individuals who claim to be U.S. citizens to provide documentary evidence of citizenship before enrolling in Medicaid.[2] H.R. 3963 bypasses this requirement.[3] Under H.R. 3963, applicants for Medicaid would be required to provide only a name and Social Security number that correspond to a valid identity on file with the Social Security Administration.[4] At the present time, a great many illegal immigrants provide the names and Social Security numbers of real U.S. citizens to obtain work in the United States. Under H.R. 3963, a state agency processing a Medicaid application is merely required to ascertain (after benefits are allocated) whether the name and Social Security number on the application correspond to a valid individual on file with the Social Security Administration. In contrast to existing law, under H.R. 3693, the state agency would not be required to take any steps to determine if the applicant is actually the individual he purports to be, or to determine whether the individual is actually a U.S. citizen. Since many illegal immigrants routinely use "borrowed" Social Security numbers to obtain jobs, it seems likely that many would also use those numbers to fraudulently obtain Medicaid benefits.
  2. Undermining Welfare Reform: Legal Immigrants and Medicaid. The 1996 welfare reform law (the Personal Responsibility and Work Opportunity Reconciliation Act of 1996, or PRWORA) restricts eligibility of legal immigrants to Medicaid, SCHIP, and other means-tested welfare programs during their first five years in the United States.[5] While H.R. 3963 does not explicitly revoke these limitations, it does weaken their administrative enforcement with the probable effect of allowing large numbers of legal immigrants to receive Medicaid benefits prior to the five-year eligibility threshold.

    Under current law, a Medicaid applicant who claims that he is a U.S. citizen must provide documentation proving citizenship.[6] Legal immigrants who are not yet citizens (legal permanent residents) are checked against the Systematic Alien Verification for Entitlement (SAVE) database, which contains information on length of residence and other factors relating to welfare eligibility.[7] H.R. 3963 does away with the requirement to provide documentation of citizenship. Applicants who claim citizenship and possess a valid Social Security number are deemed eligible if they appear to meet the Medicaid income limits.

    The designers of H.R. 3963 appear to believe that all individuals who have Social Security numbers are U.S. citizens and therefore eligible for Medicaid or SCHIP; however, this is not the case. In fact, most lawful non-citizen immigrants (legal permanent residents) have valid Social Security numbers. Under H.R. 3963, a legal permanent resident who falsely asserts he is a citizen and offers his valid Social Security number may be automatically enrolled in Medicaid. The claim of citizenship need not be checked, and eligibility need not be verified by information from the SAVE system. This change would substantially weaken the limitations on immigrant use of welfare enacted in PRWORA.
  3. The Express Lane Application System: Bypassing the SAVE System. H.R. 3963 give states the option of operating an Express Lane application system for enrolling children in Medicaid and SCHIP. This option would go even further than the basic Medicaid application procedures established in H.R. 3963 in undermining the current legal limitations on immigrant use of welfare. The Express Lane process entirely bypasses the SAVE system now used to determine immigrant eligibility for means-tested welfare.[8]

    With the Express Lane, an immigrant child who does not claim to be a citizen but who possesses a valid Social Security number (as many legal permanent resident children do) may be automatically enrolled in Medicaid or SCHIP without having his application checked by the SAVE system.[9] Thus, states may provide Medicaid and SCHIP to legal immigrant children without determining if they are legally entitled to those benefits. H.R. 3963 therefore provides a de facto neutering of the limitations on immigrant use of Medicaid and SCHIP enacted in welfare reform. The Express Lane would allow thousands of legal immigrants to receive Medicaid and SCHIP benefits irrespective of the length of their residence in the United States. H.R. 3963 adds insult to injury by providing that no state may be financially penalized for providing Medicaid or SCHIP benefits to ineligible immigrants through the Express Lane system.[10]

Reducing Fraud and Misuse of Taxpayer Funds

Proper government policy should ensure that individuals receiving benefits under Medicaid, SCHIP, and other means-tested welfare programs are, in fact, legally eligible for assistance. In order to accomplish this, four standards should be maintained in the application process:

  1. Applicants claiming citizenship should provide documentation in accordance with section 1903 (x) of current law.
  2. Applicants claiming citizenship or legal permanent residence should (where applicable) provide their name, Social Security number, and date and place of birth; this information should be cross-referenced against the Social Security Administration database.
  3. Eligibility of non-citizens should be determined using data from the SAVE system.
  4. Income should be verified through the Income and Eligibility Verification System (IEVS).

In general, fraud could be reduced within the welfare system through the expeditious implementation of the REAL ID Act of 2005.

Conclusion

H.R. 3963 fails to adequately prevent abuse of taxpayer funds. It increases opportunities for illegal immigrants to obtain Medicaid benefits and for legal immigrants to enroll in SCHIP or Medicaid before living in the U.S. the requisite five years. As such, the legislation is a significant step backward in efforts to prevent welfare fraud. Members of Congress should go back to the drawing board and craft a reauthorization proposal that includes safeguards to protect taxpayers and to ensure that welfare payments go only to those who are legally eligible.

Robert E. Rector is Senior Research Fellow in Domestic Policy Studies at The Heritage Foundation.



[2]Section 1903 (i) (22) and section 1903 (x) of the Social Security Act (42 U.S.C. 1936a) require documentary evidence of citizenship from Medicaid applicants. Regulations concerning documentary evidence of citizenship and the Medicaid program are found in "Medicaid Program: Citizenship Documentation requirements" (CMS 2257-IFC) (71 FR 39214).

[3]Section 211 (a) (1) of H.R. 3693 effectively bypasses the current law provisions concerning documentary evidence of citizenship by amending section 1902(a) (46) and section 1903 (i) (22) of current law to make adherence to the evidentiary provisions of section 1903 (x) of current law a state option.

[4]See section 211(a) (1) of H.R.3693.

[5]Section 403 of the Personal Responsibility and Work Opportunity Reconciliation Act of 21996, public law 104-193 (42 U.S.C. 1641).

[6]See section 1903 (x) of the Social Security Act.

[7]Current law governing Medicaid enrollment requires verification of immigration status by the Immigration and Naturalization Service through the use of the SAVE system. See section 1137 (d) of the Social Security Act (42 U.S.C. 1320 b-7(d)).

[8]H.R. 3963 allows states to bypass the Immigration and Naturalization Service and the Systematic Alien Verification for Entitlement (SAVE) system; section 203(a) of H.R. 3963 explicitly states that states may use the Express Lane application process to determine Medicaid eligibility "notwithstanding" section 1137 (d) of existing law, which requires verification of immigrant status by the Immigration and Naturalization Service through the Systematic Alien Verification for Entitlement (SAVE) system.

[9]In the normal Medicaid and SCHIP application process created by H.R. 3963, an immigrant application must claim citizenship in order to bypass the SAVE system. Under the Express Lane system, the Immigration and Naturalization Service and the SAVE system may be bypassed even if the applicant does not claim citizenship.

[10]See subparagraph E (i) and (iii) under Express Lane Option of section 203 of H.R. 3963.

 
 
Links
A webcast of the Better Health Care Together forum featuring Stuart Butler, Ph.D.
A webcast by the Kaiser Family Foundation featuring Stuart Butler, Ph.D.
A webcast of the National Federation of Independent Business Health Reform Forum featuring Stuart Butler, Ph.D.
A webcast of the National Federation of Independent Business Health Reform Forum featuring Robert Moffit.

Contact An Expert
MEDIA INFORMATION LINE:
Phone: 202.675.1761
Fax: 202.544.6979

Sign up for Morning Bell Email

 


Debugging Information
ColdFusion Server Enterprise 7,0,2,142559
Template /Research/HealthCare/wm1714.cfm
Time Stamp 05-Jul-08 12:02 AM
Locale English (US)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 10.10.41.254
Host Name 10.10.41.254


Execution Time

Total Time Avg Time Count Template
1953 ms 244 ms 8 D:\websites\commonspot\cache\cached-render.cfm
1281 ms 1281 ms 1 D:\websites\heritage.org\Research\HealthCare\wm1714.cfm
1265 ms 1265 ms 1 D:\websites\commonspot\master-render.cfm
1265 ms 1265 ms 1 D:\websites\commonspot\master.cfm
1218 ms 1218 ms 1 D:\websites\commonspot\render-page-meat.cfm
1218 ms 1218 ms 1 D:\websites\commonspot\render-page.cfm
1171 ms 1171 ms 1 D:\websites\heritage.org\templates\template-basepage.cfm
780 ms 87 ms 9 D:\websites\commonspot\utilities\ct-render-element.cfm
766 ms 383 ms 2 D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm
749 ms 125 ms 6 D:\websites\commonspot\utilities\ct-render-named-element.cfm
453 ms 453 ms 1 D:\websites\heritage.org\templates\RHBoxesRD06.cfm
406 ms 406 ms 1 D:\websites\commonspot\controls\customcf\cpe-customcf.cfm
390 ms 390 ms 1 D:\websites\heritage.org\templates\RHBoxesRD06-new.cfm
109 ms 27 ms 4 D:\websites\commonspot\controls\layout\cpe-layout.cfm
64 ms 11 ms 6 D:\websites\commonspot\utilities\cp-cffile.cfm
63 ms 32 ms 2 D:\websites\commonspot\controls\textblock\cpe-textblock.cfm
63 ms 63 ms 1 D:\websites\heritage.org\customcf\MetaData_ResearchPaperOutputDupFix-RD06.cfm
48 ms 16 ms 3 D:\websites\commonspot\utilities\cp-cffile-charset.cfm
46 ms 7 ms 7 D:\websites\commonspot\controls\control-setup.cfm
32 ms 16 ms 2 D:\websites\commonspot\controls\upfront-generic.cfm
31 ms 31 ms 1 D:\websites\commonspot\controls\layout\render-cell.cfm
31 ms 8 ms 4 D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm
31 ms 16 ms 2 D:\websites\commonspot\utilities\newwindow-js.cfm
16 ms 16 ms 1 D:\websites\commonspot\controls\dhtmlmenu\cpe-menu.cfm
16 ms 16 ms 1 D:\websites\commonspot\controls\dhtmlmenu\menu-get-data.cfm
16 ms 8 ms 2 D:\websites\commonspot\controls\textblock\tb-default-params.cfm
16 ms 8 ms 2 D:\websites\commonspot\controls\textblock\tb-standard-render.cfm
16 ms 16 ms 1 D:\websites\commonspot\tb-param-upfront-queries.cfm
16 ms 8 ms 2 D:\websites\commonspot\utilities\ct-render-text.cfm
16 ms 2 ms 8 D:\websites\commonspot\utilities\handle-cache-flags.cfm
16 ms 16 ms 1 D:\websites\commonspot\utilities\load-template-stub.cfm
15 ms 0 ms 35 D:\websites\commonspot\controls\set-caller-vars.cfm
15 ms 15 ms 1 D:\websites\commonspot\render-head.cfm
15 ms 8 ms 2 D:\websites\commonspot\tb-data-upfront-queries.cfm
0 ms 0 ms 1 D:\websites\commonspot\approve\ct-render-approval-icon-subitems.cfm
0 ms 0 ms 2 D:\websites\commonspot\approve\ct-render-approval-icon.cfm
0 ms 0 ms 4 D:\websites\commonspot\controls\ct-include-once.cfm
0 ms 0 ms 2 D:\websites\commonspot\controls\default-mode.cfm
0 ms 0 ms 4 D:\websites\commonspot\controls\layout\layout-rowcol-actions.cfm
0 ms 0 ms 1 D:\websites\commonspot\controls\layout\layout-setcellvars.cfm
0 ms 0 ms 1 D:\websites\commonspot\controls\layout\layout-settablevars.cfm
0 ms 0 ms 1 D:\websites\commonspot\generate-usage-stats.cfm
0 ms 0 ms 1 D:\websites\commonspot\menu\core-js.cfm
0 ms 0 ms 1 D:\websites\commonspot\menu_ie_style.cfm
0 ms 0 ms 1 D:\websites\commonspot\metadata\build-struct.cfm
0 ms 0 ms 1 D:\websites\commonspot\metadata\init-cache.cfm
0 ms 0 ms 1 D:\websites\commonspot\pagemode\newpagemodeui.cfm
0 ms 0 ms 1 D:\websites\commonspot\pagemode\pagemodeui.cfm
0 ms 0 ms 1 D:\websites\commonspot\render-body-tag.cfm
0 ms 0 ms 1 D:\websites\commonspot\render-metatags.cfm
0 ms 0 ms 7 D:\websites\commonspot\security\security-control.cfm
0 ms 0 ms 1 D:\websites\commonspot\security\security-detail-queries.cfm
0 ms 0 ms 1 D:\websites\commonspot\security\security-page.cfm
0 ms 0 ms 1 D:\websites\commonspot\security\session-user-approvals.cfm
0 ms 0 ms 1 D:\websites\commonspot\set-page-vars.cfm
0 ms 0 ms 1 D:\websites\commonspot\site-application.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\core-application-meat.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\handle-head-request.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\handle-request-timeout.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\session-first-global.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\session-first-site.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\site-application-meat.cfm
0 ms 0 ms 1 D:\websites\commonspot\static\do-replacements.cfm
0 ms 0 ms 1 D:\websites\commonspot\static\get-feature-enabled.cfm
0 ms 0 ms 1 D:\websites\commonspot\static\replacement-wrapper.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\build-pagedata.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\build-user-struct.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\cp-cfwddx.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\cp-setencoding.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\ct-limit-inheritance.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\ct-render-edit-icon-subitem.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\ct-render-edit-icon.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\define-upfront-vars.cfm
0 ms 0 ms 3 D:\websites\commonspot\utilities\edit-mode-get-valid.cfm
0 ms 0 ms 6 D:\websites\commonspot\utilities\handle-in-list.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\newwindow-js-meat.cfm
0 ms 0 ms 8 D:\websites\commonspot\utilities\validate-date-string.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\validation\render-info.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\verify-stub-data.cfm
0 ms 0 ms 1 D:\websites\heritage.org\Research\HealthCare\Application.cfm
0 ms 0 ms 1 D:\websites\heritage.org\Research\template-ResearchPaper.cfm
0 ms 0 ms 1 D:\websites\heritage.org\cache\s19-n1031-p213024-c0-t0-mr-blame.cache
0 ms 0 ms 1 D:\websites\heritage.org\cache\s19-n1031-p213024-c131131-t1-mr-blame.cache
0 ms 0 ms 1 D:\websites\heritage.org\cache\temp635139-s19-n1031-p213024-c130947-t26-mr-blame.cache
0 ms 0 ms 1 D:\websites\heritage.org\custom-application.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\Header_AutodiscoveryLinks.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\box-special-HealthCare.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\box-standard-additional-resources.cfm
0 ms 0 ms 2 D:\websites\heritage.org\customcf\RD06\box-standard-media-contacts.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\box-standard-policywire-signup.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\box-standard-products-displayad.cfm
0 ms 0 ms 2 D:\websites\heritage.org\customcf\RD06\box-standard-rtcol-videos.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\box-standard-xml.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\left-nav-display-ads.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\searchform-header-greyblue.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\LHNavRD06.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\basepagefooter980.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\basepageheader980.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\pagetitles-RD06.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\template-basepage.head
0 ms 0 ms 1 D:\websites\heritage.org\ui\redesign\nav\ResearchNav.cfm
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1297 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

Request.PageData.PageParams (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\commonspot\render-page-meat.cfm @ 00:02:39.039
				SELECT *
				  FROM Param_Page
				 WHERE (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
				   AND VersionState=2
	 		 ORDER BY PageID DESC
			
FormData (Datasource=commonspot-heritage.org, Time=0ms, Records=18) in D:\websites\commonspot\metadata\build-struct.cfm @ 00:02:39.039
	SELECT Data_FieldValue.FieldValue,FormInputControl.FieldName,FormInputControl.type,FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE Data_FieldValue.PageID = ?
		AND Data_FieldValue.FieldID = FormInputControl.ID
		AND Data_FieldValue.FormID = FormControl.ID
		AND FormInputControl.ID = FormInputControlMap.FieldID
		AND FormControl.ID = FormInputControlMap.FormID
		AND FormControl.ID = FormControlMap.FormID
		AND (
				((FormControlMap.ClassConstant = 4)
			
				AND (FormControlMap.ClassID IN (1,3,19)) 
			)
	
			OR ((FormControlMap.ClassConstant = 1) AND ( (FormControlMap.ClassID IN (1,2,7,1031)) ))
	
			OR ((FormControlMap.ClassConstant = 2) AND (FormControlMap.ClassID = ?))
	
			 )
 ORDER BY FormControl.ID, FormInputControl.ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 213024
Parameter #2(CF_SQL_INTEGER) = 15

rsAuthor (Datasource=Authors, Time=0ms, Records=1) in D:\websites\heritage.org\templates\template-basepage.head @ 00:02:39.039
			select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
			tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
			WHERE SitePagesID = 213024
			ORDER BY SortOrder
		
CheckInheritance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\utilities\ct-limit-inheritance.cfm @ 00:02:39.039
   SELECT PageID,VersionState,AuthorID
     FROM Data_Menu_Items
    WHERE ControlID=?
		AND (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

request.pageDHTMLMenus (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\dhtmlmenu\menu-get-data.cfm @ 00:02:39.039
		SELECT *
		FROM Param_WDDX
		WHERE (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
			AND ElementTypeID = ?
			AND ControlID > 0
		ORDER BY ControlID, PageID DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 47

request.pageDHTMLItems (Datasource=commonspot-heritage.org, Time=16ms, Records=0) in D:\websites\commonspot\controls\upfront-generic.cfm @ 00:02:39.039
	SELECT *
	  FROM Data_Menu_Items
	 WHERE (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, ItemPos,VersionID DESC 
FindMaxVersions (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\upfront-generic.cfm @ 00:02:39.039
		SELECT PageID,ControlID,ItemID,Max(VersionID) AS MaxVersion
		  FROM Data_Menu_Items
		 WHERE (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) 
	 GROUP BY PageID,ControlID,ItemID
	
rsSubsiteName (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\ui\redesign\nav\ResearchNav.cfm @ 00:02:39.039
				SELECT SitePages.Title
				  FROM SubSites,SitePages
				 WHERE SubSites.ID = 19
					AND SubSites.SecurityPageID = SitePages.ID
			
Request.CtrlInstUpFront (Datasource=commonspot-heritage.org, Time=16ms, Records=373) in D:\websites\commonspot\controls\control-setup.cfm @ 00:02:39.039
			SELECT ControlID,ControlName
			  FROM ControlInstance
			 WHERE (PageID IN (1,2,7,1031,213024)) 
		 ORDER BY PageID DESC
		
ReadRestrictions (Datasource=commonspot-heritage.org, Time=15ms, Records=0) in D:\websites\commonspot\utilities\ct-render-element.cfm @ 00:02:39.039
			SELECT DISTINCT ControlID
			  FROM ItemSecurity
			 WHERE ((PageID = ? AND ApplyTo=0)
						OR ( (PageID IN (1,2,7,1031,213024)) 
							AND ApplyTo = 1))
			   AND ControlID <> 0
			   AND pRead=0
				AND pAuthor=0
				AND pEdit=0
				AND pDesign=0
				AND pApprove=0
				AND pAdmin=0
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 213024

Request.PageData.Restrictions (Datasource=commonspot-heritage.org, Time=0ms, Records=30) in D:\websites\commonspot\security\security-detail-queries.cfm @ 00:02:39.039
			SELECT *
			  FROM RestrictedSecurity
			 WHERE PageID IN (1031,7,2,1) 
SecureElements (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\security\security-detail-queries.cfm @ 00:02:39.039
		SELECT DISTINCT ControlID
		  FROM ItemSecurity
		 WHERE
			(
				((ApplyTo=?)
					AND (PageID=?))
				OR
				((ApplyTo=?)
					AND (PageID IN (1031,7,2,1)))
			)
			AND ControlID<>0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 213024
Parameter #3(CF_SQL_INTEGER) = 1

Request.PageData.ExplicitSecurity (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\security\security-detail-queries.cfm @ 00:02:39.039
			SELECT ControlID,
					 Max(pRead) AS maxRead,
					 Max(pAuthor) AS maxAuthor,
					 Max(pEdit) AS maxEdit,
					 Max(pDesign) AS maxDesign,
					 Max(pStyle) AS maxStyle,
					 Max(pAdmin) AS maxAdmin,
					 Max(pApprove) AS maxApprove
			  FROM ItemSecurity
			 WHERE ( (UserGroupID = ?) )
		      AND
				(
					((ApplyTo=?)
						AND (PageID=?))
					OR
					((ApplyTo=?)
						AND (PageID IN (1031,7,2,1)))
				)
				AND ControlID<>0
		 GROUP BY ControlID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 213024
Parameter #4(CF_SQL_INTEGER) = 1

CheckInheritanceForCurrentRecs (Datasource=commonspot-heritage.org, Time=16ms, Records=0) in D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm @ 00:02:39.039
	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 83726

GetTableValues (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 00:02:39.039
	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 83726

GetCells (Datasource=commonspot-heritage.org, Time=15ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 00:02:39.039
	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=213024 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 83726

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 00:02:39.039
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 213024
Parameter #6(CF_SQL_INTEGER) = 83726
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

rsAuthor (Datasource=Authors, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\MetaData_ResearchPaperOutputDupFix-RD06.cfm @ 00:02:39.039
		select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
		tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
		WHERE SitePagesID = 213024
		ORDER BY SortOrder
	
Request.TBUpfrontParam (Datasource=commonspot-heritage.org, Time=16ms, Records=21) in D:\websites\commonspot\tb-param-upfront-queries.cfm @ 00:02:39.039
		
		SELECT *
		  FROM Param_TextBlock
		 WHERE (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 ORDER BY ControlID, PageID Desc, VersionID Desc 
Request.TBUpfront (Datasource=commonspot-heritage.org, Time=15ms, Records=13) in D:\websites\commonspot\tb-data-upfront-queries.cfm @ 00:02:39.039
			
			SELECT *
			  FROM Data_TextBlock
			 WHERE (pageID IN (1,2,7,1031,213024)) 
			 	AND versionState = 2
		 ORDER BY ControlID, PageID Desc, VersionID Desc 
UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 00:02:39.039
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 213024
Parameter #6(CF_SQL_INTEGER) = 48266
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritanceForCurrentRecs (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm @ 00:02:39.039
	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

GetTableValues (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 00:02:39.039
	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

GetCells (Datasource=commonspot-heritage.org, Time=16ms, Records=1) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 00:02:39.039
	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=7 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

GetCellData (Datasource=commonspot-heritage.org, Time=16ms, Records=2) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 00:02:39.039
			SELECT *
			  FROM Data_LayoutCell
			 WHERE ControlID = ?
				AND (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
				AND (VersionState = 2)
		 ORDER BY ItemID, PageID DESC, VersionID DESC
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 00:02:39.039
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 213024
Parameter #6(CF_SQL_INTEGER) = 2172
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 00:02:39.039
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 213024
Parameter #6(CF_SQL_INTEGER) = 2
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritanceForCurrentRecs (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm @ 00:02:39.039
	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 88325

GetTableValues (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 00:02:39.039
	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 88325

GetCells (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 00:02:39.039
	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=213024 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 88325

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=16ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 00:02:39.039
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 213024
Parameter #6(CF_SQL_INTEGER) = 88325
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

rsPapers (Datasource=commonspot-heritage.org, Time=437ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
				SELECT TOP 3 SitePages.*, DocCategories.Category, data_fieldvalue.Fieldvalue
				FROM DocCategories As DocCategories, SitePages As SitePages,
					data_fieldvalue as data_fieldvalue, forminputcontrol as forminputcontrol
				WHERE (DocCategories.ID = SitePages.CategoryID) 
					AND (SitePages.ApprovalStatus=0 AND SitePages.AudienceID=0 
					AND sitePages.subSiteID <> 0 AND SitePages.PageSetID = 0) 
					AND (SitePages.PageType IN (0,5) AND Uploaded=0) 
					AND SitePages.PageType NOT IN (4,9) 
					AND ( ( SitePages.ID in 
						(select pageID from Data_FieldValue As Data_FieldValue where Data_FieldValue.fieldID = 6858 and Data_FieldValue.formID = 6855 
							and Data_FieldValue.VersionState >= 2 
						) and ( SitePages.SubSiteID in (19) and ((SitePages.CategoryID not in (8)) OR (SitePages.CategoryID = 0)) ) 
						or SitePages.ID in 
						(select pageID from Data_FieldValue As Data_FieldValue where 
						(Data_FieldValue.fieldID = 45868 or data_fieldvalue.fieldid = 51999)
						and Data_FieldValue.formID = 6855 
						and Data_FieldValue.VersionState >= 2 AND ((Data_FieldValue.fieldValue LIKE '%HealthCare%') 
						OR (Data_FieldValue.fieldValue LIKE '%Health Care%'))) 
						) ) 
					AND ((SitePages.IsPublic > 0) ) AND (SitePages.PublicReleaseDate <= '2008-07-05 12:02:39') AND (SitePages.ID <> 96544) AND 
					(SitePages.ExpDate >= '2008-07-05 12:02:39' OR SitePages.ExpDate IS NULL) 
					AND sitepages.id = data_fieldvalue.pageid
					AND data_fieldvalue.fieldid = forminputcontrol.id
					and forminputcontrol.fieldname = 'FIC_Date'
					and sitepages.filename not like '%es.cfm'
				ORDER BY fieldvalue desc 

			
rsPaperDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 252911
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							
rsAuthor (Datasource=Authors, Time=0ms, Records=2) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
								select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
								tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
								WHERE SitePagesID = 252911
								ORDER BY SortOrder
							
rsPaperDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 249750
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							
rsSubsite (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
									SELECT SubSiteURL FROM SubSites WHERE ID = 8 
rsAuthor (Datasource=Authors, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
								select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
								tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
								WHERE SitePagesID = 249750
								ORDER BY SortOrder
							
rsPaperDetails (Datasource=commonspot-heritage.org, Time=16ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 250584
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							
rsAuthor (Datasource=Authors, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
								select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
								tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
								WHERE SitePagesID = 250584
								ORDER BY SortOrder
							
Request.customCFUpfront (Datasource=commonspot-heritage.org, Time=16ms, Records=9) in D:\websites\commonspot\controls\upfront-generic.cfm @ 00:02:40.040
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=213024 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 
rsPapers (Datasource=commonspot-heritage.org, Time=297ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
				SELECT TOP 3 SitePages.*, DocCategories.Category, data_fieldvalue.Fieldvalue
				FROM DocCategories As DocCategories, SitePages As SitePages,
					data_fieldvalue as data_fieldvalue, forminputcontrol as forminputcontrol
				WHERE (DocCategories.ID = SitePages.CategoryID) 
					AND (SitePages.ApprovalStatus=0 AND SitePages.AudienceID=0 
					AND sitePages.subSiteID <> 0 AND SitePages.PageSetID = 0) 
					AND (SitePages.PageType IN (0,5) AND Uploaded=0) 
					AND SitePages.PageType NOT IN (4,9) 
					AND ( ( SitePages.ID in 
						(select pageID from Data_FieldValue As Data_FieldValue where Data_FieldValue.fieldID = 6858 and Data_FieldValue.formID = 6855 
							and Data_FieldValue.VersionState >= 2 
						) and ( SitePages.SubSiteID in (19) and ((SitePages.CategoryID not in (8)) OR (SitePages.CategoryID = 0)) ) 
						or SitePages.ID in 
						(select pageID from Data_FieldValue As Data_FieldValue where 
						(Data_FieldValue.fieldID = 45868 or data_fieldvalue.fieldid = 51999)
						and Data_FieldValue.formID = 6855 
						and Data_FieldValue.VersionState >= 2 AND ((Data_FieldValue.fieldValue LIKE '%HealthCare%') 
						OR (Data_FieldValue.fieldValue LIKE '%Health Care%'))) 
						) ) 
					AND ((SitePages.IsPublic > 0) ) AND (SitePages.PublicReleaseDate <= '2008-07-05 12:02:40') AND (SitePages.ID <> 96544) AND 
					(SitePages.ExpDate >= '2008-07-05 12:02:40' OR SitePages.ExpDate IS NULL) 
					AND sitepages.id = data_fieldvalue.pageid
					AND data_fieldvalue.fieldid = forminputcontrol.id
					and forminputcontrol.fieldname = 'FIC_Date'
					and sitepages.filename not like '%es.cfm'
				ORDER BY fieldvalue desc 

			
rsPaperDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 252911
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							
rsAuthor (Datasource=Authors, Time=0ms, Records=2) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
								select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
								tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
								WHERE SitePagesID = 252911
								ORDER BY SortOrder
							
rsPaperDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 249750
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							
rsSubsite (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
									SELECT SubSiteURL FROM SubSites WHERE ID = 8 
rsAuthor (Datasource=Authors, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
								select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
								tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
								WHERE SitePagesID = 249750
								ORDER BY SortOrder
							
rsPaperDetails (Datasource=commonspot-heritage.org, Time=16ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040
								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 250584
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							
rsAuthor (Datasource=Authors, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 00:02:40.040