Calendar | For Your Patients | PHA Main Site | Contact Us | About Us | Not a registered user? Sign up here.

Courses Quicksearch

Search Now!

Courses

Understanding Pulmonary Hypertension: From the Micro Level to the Global Impact

Ghazwan Butrous


Sebastien Bonnet

Mourad Toporsian

0 comments
Leave a Comment

Course ID: 2220

The Global Spectrum of Pulmonary Hypertension and its Forgotten Impact on the Developing World

Ghazwan Butrous, MB, ChB, PhD
Managing Director
Pulmonary Vascular Research Institute
Canterbury, United Kingdom

Learning Objectives

  1. Discuss the scope of the pulmonary vascular diseases worldwide and in particular the developing world.
  2. Evaluate the difference in the presentation and management of pulmonary vascular diseases between the developed and developing world.
  3. Discuss the steps to increase awareness and the international collaboration to support patients in the developing world with pulmonary hypertension.

Understanding the Molecular Origin of Pulmonary Hypertension: Role of MicroRNAs

Sebastien Bonnet, PhD
Associate Professor of Medicine
Laval University
Quebec City, Canada

Learning Objectives

  1. Describe the mechanism of pulmonary artery remodeling 
  2. Describe the underlying disorders of miR-204 down regulation in PAH
  3. Discuss the putative role of miRNA in PAH treatment

Pathogenesis of Pulmonary Arterial Hypertension: Clues from the Animal Models of Hereditary Hemorrhagic Telangiectasia

Mourad Toporsian, PhD
Instructor in Medicine
Harvard Medical School
Beth Israel Deaconess Medical Center
Boston, Mass.

Learning Objectives

  1. Describe the clinical signs and symptoms of Hereditary Hemorrhagic Telangiectasia (HHT) and the genes mutated in this disease
  2. Recall that some HHT patients can present with PAH and define how HHT and PAH share common defects in genes and signaling pathways
  3. Discuss how changes in Endoglin and ALK-1-dependent cell signaling can spontaneously cause PAH in mice
  4. Discuss potential therapeutic targets in the treatment of PAH

Release Date

29 May 2013

Expiration Date

29 May 2015 

Accreditation and Credit Designation

This activity has been planned and implemented in accordance with the essential Areas and Policies of the Accreditation Council for Continuing Medical Education (ACCME) through the joint sponsorship of ProCE, Inc., the National Association of Managed Care Physicians (NAMCP), and the Pulmonary Hypertension Association (PHA). The NAMCP is accredited by the ACCME to provide continuing medical education (CME) to physicians. The NAMCP designates this enduring material for a maximum of 3.0 AMA PRA Category 1 Credit(s)™. Physicians should only claim credit commensurate with the extent of their participation in the activity.

Instructions for Earning Credit

This activity is a self-study program. Upon entering the activity, participants should read the text, examine any images and/or multimedia features, and review the content presented within all of the links provided. Once the course has been reviewed in its entirety, participants will be asked to complete a post-test and evaluation online. Participants must receive a test score of 100% in order to proceed to the course evaluation; the post-test can be repeated until all questions are answered correctly. All evaluation questions must be completed in order to receive a certificate of credit. If needed, participants may save their answers and complete the course at a later date. Saved courses can be found on the "My Activities" page, accessed via "My Account" at the top of the page.

Faculty Disclosures

It is the policy of ProCE to require the disclosure of the existence of any significant financial interest or any other relationship a faculty member or a sponsor has with the manufacturer of any commercial product(s) discussed in an educational presentation.

Ghazwan Butrous, MB, ChB, PhD, indicates that he has served as a consultant or as part of a speaker bureau for Novartis and Bayer and is a stock shareholder with Pfizer.

Mourad Toporsian, PhD, indicates that he has no significant financial interest or any other relationship to disclose.

Sebastien Bonnet, PhD, indicates that he has no significant financial interest or any other relationship to disclose.

Disclaimer

The opinions expressed in this program should not be construed as those of the CE provider. The information and views are those of the faculty through clinical practice and knowledge of the professional literature. Portions of this program may include the use of drugs for unlabeled indications. Use of drugs outside of labeling should be considered experimental and participants are advised to consult prescribing information and professional literature.

No portion of this activity may be reproduced without the expressed written consent of PHA.

Estimated Time to Complete This Activity

3 hours

Privacy Policy

For information about the PHA's privacy policy, visit http://www.phassociation.org/privacy.asp.

This activity is made possible through unrestricted educational grants from Actelion, Gilead, United Therapeutics and Bayer.

©2013 Pulmonary Hypertension Association, 801 Roeder Road, Suite 1000, Silver Spring, MD 21910.








Debugging Information
BlueDragon .NET 7,1,1,18433
Template /Courses/Course.cfm
Time stamp 21-Aug-14 02:00 P
Locale English (United States)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.196.204.15
Host Name 54.196.204.15

Execution

Total TimeAvg TimeCountTemplate
1469 ms 1469 ms 1 d:/inetpub/pha/phaonlineuniv-org/htdocs/Courses/Course.cfm
969 ms 242 ms 4 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm
391 ms 391 ms 1 D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/footer.cfm
250 ms 250 ms 1 D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/Social.cfm
235 ms 235 ms 1 d:/inetpub/rdcommon/cmscore/CustomTags/CMSDBapi/ActivityLogCreate.cfm
203 ms 101 ms 2 D:/inetpub/pha/pha-cms-plus-com/misc/Custom/CustomTags/GetAuthorPhotos.cfm
94 ms 94 ms 1 D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/relatedResources.cfm
78 ms 78 ms 1 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetRecommendedContentItems.cfm
62 ms 62 ms 1 D:/inetpub/pha/pha-cms-plus-com/misc/Custom/CustomTags/GetCourseInfo.cfm
31 ms 31 ms 1 D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/QuickSearchCourses.cfm
31 ms 31 ms 1 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/ContentReviews.cfm
31 ms 15 ms 2 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/Search/SEO.cfm
16 ms 16 ms 1 D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/header.cfm
16 ms 16 ms 1 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/RandomizeQuery.cfm
16 ms 16 ms 1 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/RelatedContent.cfm
0 ms 0 ms 1 D:/inetpub/pha/pha-cms-plus-com/misc/Custom/CustomTags/SSO/BBNCInbound.cfm
0 ms 0 ms 1 D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/Comments.cfm
0 ms 0 ms 1 D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/NavVars.cfm
0 ms 0 ms 1 D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/PageTools.cfm
0 ms 0 ms 1 D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/SecNav.cfm
0 ms 0 ms 1 D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/breadcrumbs.cfm
0 ms 0 ms 1 D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/google.cfm
0 ms 0 ms 1 D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/mainnav.cfm
0 ms 0 ms 1 D:/inetpub/pha/phaonlineuniv-org/misc/custom/initialize.cfm
0 ms 0 ms 2 d:/BlueDragon.NET/config/component.cfc
0 ms 0 ms 4 d:/BlueDragon.NET/customtags/RDTAGS/RDCleanQueryTerm.cfm
0 ms 0 ms 1 d:/BlueDragon.NET/customtags/RDTAGS/RDGlobal.cfm
0 ms 0 ms 1 d:/BlueDragon.NET/customtags/RDTAGS/RDRequestFilter.cfm
0 ms 0 ms 1 d:/inetpub/pha/phaonlineuniv-org/htdocs/Application.cfm
0 ms 0 ms 2 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/ContentDetailMetaData.cfm
0 ms 0 ms 2 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/FavoriteAdd.cfm
0 ms 0 ms 1 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetCookieDomain.cfm
0 ms 0 ms 8 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetNavigationItems.cfm
0 ms 0 ms 1 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/LoadPassport.cfm
0 ms 0 ms 2 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/PageHeader.cfm
0 ms 0 ms 2 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/PageTitle.cfm
0 ms 0 ms 1 d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/RandomizeIndex.cfm
0 ms 0 ms 1 d:/inetpub/rdcommon/cmscore/_permissions.cfm
0 ms 0 ms 59 d:/inetpub/rdcommon/cmscore/application.cfm
0 ms 0 ms 1 d:/inetpub/rdcommon/cmscore/applications/common/CMSIncludes-app/_jQuery.cfm
0 ms 0 ms 1 d:/inetpub/rdcommon/cmscore/applications/common/roaming-app/Verify.cfm
0 ms 0 ms 1 d:/inetpub/rdcommon/cmscore/customTags/CMSapp/Authenticate.cfm
0 ms 0 ms 4 d:/inetpub/rdcommon/cmscore/customTags/CMSapp/CookieManagement.cfc
1469 ms STARTUP, PARSING, COMPILING, LOADING & SHUTDOWN
1469 ms TOTAL EXECUTION TIME

red = over 250 ms average execution time


SQL Queries

getFields
(Datasource=RDCMS-PHA-CORE, Time=15ms, Records=6) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:16

select F.FieldID, F.Maximum, F.GroupNum, F.FieldName, F.FieldType,
T.ContentItemField
from CM_Fields F
join CM_FieldTypes T on F.FieldType = T.FieldType
where F.TemplateID in (5035)
order by F.GroupNum, F.DisplayOrder

getContentItemIDs
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:16

select CI.EntityID as ContentItemID, CI.TemplateID
from CM_ContentItems CI
join Entities E on CI.EntityID = E.EntityID
where E.isActive = 1
and CI.TemplateID in (5035)
and CI.EditableProduct = 0
AND CI.DatePublished is not null
AND ( CI.ReleaseDate is null or DateDiff(d,CI.ReleaseDate,getdate()) >= 0 )
AND ( CI.ExpireDate is null or DateDiff(d,getdate(),CI.ExpireDate) > 0 )
AND CI.DateArchived is null
and CI.ItemNumber = ?
and CI.LoginRequired = 0
and (
-- permissions are overridden
CI.VisibilityException is not null
-- or there are no restrictions
or (CI.ItemNumber not in (select ItemNumber from CM_AccessGroups) and
CI.ItemNumber not in (select ItemNumber from CM_MemberTypes)
)
)
order by CI.ItemNumber

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 1845

getCIFullInfo
(Datasource=RDCMS-PHA-CORE, Time=234ms, Records=8) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:17

select
E.EntityID as ContentItemID, E.DateCreated, E.LastModified, E.LastVerified, E.ExternalPK,
CI.ItemNumber, CI.TemplateID,
CI.DatePublished, CI.ReleaseDate, CI.ExpireDate, CI.DateArchived, isNull(CI.ReleaseDate,CI.DatePublished) AS EffectivePublishDate,
CI.LoginRequired, CI.VisibilityException, CI.VisibilityRestriction,
CI.SearchBrowse, CI.DefaultPrice, CI.ProductNumber, CI.HandlingCharge,
CI.ShipWeightPounds, CI.ShipWeightOunces, CI.ShippingCharge,
CI.EventStart, CI.EventEnd, CI.EventLocation, CI.EventAgenda,
CI.RegistrationBegins, CI.RegistrationDeadline, CI.MaxRegistrants,
R.ResourceName, R.Abstract, hitcount,
F.FieldID, ISNULL(F.GroupNum,1) as GroupNum,
F.FieldName, F.FieldType, F.Maximum,
CIF.ContentItemFieldID, ISNULL(CIF.RepNum,1) as RepNum,
CIF.FldString, CIF.FldText, CIF.FldInt, CIF.FldDate, CIF.FldDecimal,
dbo.GetName(CI.TemplateID) as ContentTemplate,
dbo.GetPreferredDisplayPage(CI.ItemNumber, ?, ?) as PreferredDisplayPage,
dbo.hasContentAccess(CI.ItemNumber, ?, ?) as HasAccess,
CASE when CT.TemplateType = 'Event' then dbo.ClassIsFull(CI.ItemNumber) else 0 END as ClassIsFull
from CM_ContentItems CI
join Entities E on CI.EntityID = E.EntityID and E.EntityType = 'Resource'
join Resources R on CI.EntityID = R.EntityID and R.ResourceType = 'ContentItem'
join CM_ContentTemplates CT on CI.TemplateID = CT.EntityID
left join CM_Fields F on CI.TemplateID = F.TemplateID
left join CM_ContentItemFields CIF on CI.EntityID = CIF.ContentItemID and F.FieldID = CIF.FieldID
where CI.EntityID in (10682)
order by CI.ItemNumber, GroupNum, RepNum, F.FieldID

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 840
Parameter #2 Type: CF_SQL_VARCHAR Value: production
Parameter #3 Type: CF_SQL_INTEGER Value:
Parameter #4 Type: CF_SQL_VARCHAR Value:

getContentItems
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=0) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:17

select cast(null as int) as TemplateID,
cast(null as varchar(200)) as ContentTemplate,
cast(null as int) as ContentItemID,
cast(null as varchar(40)) as ExternalPK,
cast(null as int) as ItemNumber,
cast(null as varchar(200)) as ResourceName,
cast(null as varchar(2000)) as Abstract,
cast(null as int) as hitcount,
cast(null as datetime) as DatePublished,
cast(null as datetime) as ReleaseDate,
cast(null as datetime) as ExpireDate,
cast(null as datetime) as DateArchived,
cast(null as datetime) as EffectivePublishDate,
cast(null as datetime) as DateCreated,
cast(null as datetime) as LastModified,
cast(null as datetime) as LastVerified,
cast(null as money) as DefaultPrice,
cast(null as varchar(50)) as ProductNumber,
cast(null as int) as ShipWeightPounds,
cast(null as int) as ShipWeightOunces,
cast(null as money) as ShippingCharge,
cast(null as money) as HandlingCharge,
cast(null as datetime) as EventStart,
cast(null as datetime) as EventEnd,
cast(null as varchar(200)) as EventLocation,
cast(null as text) as EventAgenda,
cast(null as int) as MaxRegistrants,
cast(null as datetime) as RegistrationBegins,
cast(null as datetime) as RegistrationDeadline,
cast(0 as bit) as ClassIsFull,
cast(null as varchar(500)) as PreferredDisplayPage,
cast(0 as bit) as LoginRequired,
cast(null as varchar(20)) as VisibilityException,
cast(null as varchar(20)) as VisibilityRestriction,
cast(1 as bit) as HasAccess,
cast(1 as bit) as SearchBrowse
, cast(null as int) as [ClassID]
, cast(null as text) as [Description]
, cast(null as varchar(500)) as [CourseImage]
, cast(null as varchar(300)) as [CourseImage_ImageAltText]
, cast(null as int) as [Featured]
, cast(null as int) as Group5Reps
, cast(null as varchar(100)) as [Author1]
, cast(null as int) as [Author1_PersonID]
, cast(null as varchar(20)) as [Author1_FirstName]
, cast(null as varchar(50)) as [Author1_LastName]
, cast(null as varchar(100)) as [Author2]
, cast(null as int) as [Author2_PersonID]
, cast(null as varchar(20)) as [Author2_FirstName]
, cast(null as varchar(50)) as [Author2_LastName]
, cast(null as varchar(100)) as [Author3]
, cast(null as int) as [Author3_PersonID]
, cast(null as varchar(20)) as [Author3_FirstName]
, cast(null as varchar(50)) as [Author3_LastName]
, cast(null as varchar(50)) as [Specialty]
, cast(null as int) as [Specialty_DisplayOrder]
where 0 = 1

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:17

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 19886

qryPerson
(Datasource=RDCMS-PHA-CORE, Time=15ms, Records=1, Cached Query) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:17

select FirstName, LastName
from CN_People
where EntityID = 7762

qryPerson
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=1, Cached Query) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:17

select FirstName, LastName
from CN_People
where EntityID = 7767

qryPerson
(Datasource=RDCMS-PHA-CORE, Time=31ms, Records=1, Cached Query) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:17

select FirstName, LastName
from CN_People
where EntityID = 7770

getListValue
(Datasource=RDCMS-PHA-CORE, Time=0ms, Records=1, Cached Query) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:17

select DisplayText, DisplayOrder
from CM_ListItems
where ListItemID = 4126

qryMetaData
(Datasource=RDCMS-PHA-CORE, Time=31ms, Records=14) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/Search/SEO.cfm @ 14:00:17

SELECT MD.MetaData
FROM MD_EntityProfiles EP
INNER JOIN MD_MetaData MD on MD.MetadataID = EP.MetaDataID
WHERE EP.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 10682

qryEDCourses
(Datasource=EDDIR-CONTENT, Time=62ms, Records=1) in D:/inetpub/pha/pha-cms-plus-com/misc/Custom/CustomTags/GetCourseInfo.cfm @ 14:00:17

SELECT COU.Credits, COU.CreditType, CLA.ClassID
FROM Entities E
INNER JOIN Courses COU ON E.EntityID = COU.EntityID
INNER JOIN Classes CLA ON COU.EntityID = CLA.CourseEntityID
WHERE E.InstallationID = ?
AND CLA.ClassID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 25
Parameter #2 Type: CF_SQL_INTEGER Value: 2220

qryLearningGroups
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=7) in D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/QuickSearchCourses.cfm @ 14:00:17

SELECT MD.MetadataID, MD.Metadata
FROM MD_MetadataCollections C
INNER JOIN MD_MetadataStructure S ON C.RootMetadataID = S.AncestorMetadataID
INNER JOIN MD_Metadata MD ON S.ChildMetadataID = MD.MetadataID
WHERE C.CollectionName = 'Learning Groups'
ORDER BY S.DisplayOrder

qryCreditTypes
(Datasource=RDCMS-PHA-CORE, Time=0ms, Records=4) in D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/QuickSearchCourses.cfm @ 14:00:17

SELECT LI.ListItemID, LI.DisplayText
FROM Resources R
INNER JOIN CM_ListItems LI ON R.EntityID = LI.ListID
WHERE R.ResourceName = 'Course Credit Type'
AND LI.isActive = 1
ORDER BY LI.DisplayOrder

qrySpecialty
(Datasource=RDCMS-PHA-CORE, Time=15ms, Records=50) in D:/inetpub/pha/phaonlineuniv-org/htdocs/includes/QuickSearchCourses.cfm @ 14:00:17

SELECT LI.ListItemID, LI.DisplayText
FROM Resources R
INNER JOIN CM_ListItems LI ON R.EntityID = LI.ListID
WHERE R.ResourceName = 'Specialty'
AND LI.isActive = 1
ORDER BY LI.DisplayOrder

qryTemplate
(Datasource=RDCMS-PHA-CORE, Time=0ms, Records=4) in D:/inetpub/pha/pha-cms-plus-com/misc/Custom/CustomTags/GetAuthorPhotos.cfm @ 14:00:17

SELECT TemplateID, GroupNum
FROM CM_Fields
WHERE FieldName = 'Author'
AND FieldType = 'Person'
AND Maximum > 1

qryPhotos
(Datasource=RDCMS-PHA-CORE, Time=110ms, Records=352) in D:/inetpub/pha/pha-cms-plus-com/misc/Custom/CustomTags/GetAuthorPhotos.cfm @ 14:00:17

SELECT DISTINCT P.EntityID, IMG.URLPath
FROM CM_Fields F
INNER JOIN CM_ContentItemFields CIF ON F.FieldID = CIF.FieldID
INNER JOIN CN_People P ON CIF.FldInt = P.EntityID
INNER JOIN FM_Files IMG ON P.Photo = IMG.EntityID
WHERE F.FieldName = 'Author'
AND F.FieldType = 'Person'

qryTemplate
(Datasource=RDCMS-PHA-CORE, Time=15ms, Records=4) in D:/inetpub/pha/pha-cms-plus-com/misc/Custom/CustomTags/GetAuthorPhotos.cfm @ 14:00:17

SELECT TemplateID, GroupNum
FROM CM_Fields
WHERE FieldName = 'Author'
AND FieldType = 'Person'
AND Maximum > 1

qryPhotos
(Datasource=RDCMS-PHA-CORE, Time=78ms, Records=352) in D:/inetpub/pha/pha-cms-plus-com/misc/Custom/CustomTags/GetAuthorPhotos.cfm @ 14:00:17

SELECT DISTINCT P.EntityID, IMG.URLPath
FROM CM_Fields F
INNER JOIN CM_ContentItemFields CIF ON F.FieldID = CIF.FieldID
INNER JOIN CN_People P ON CIF.FldInt = P.EntityID
INNER JOIN FM_Files IMG ON P.Photo = IMG.EntityID
WHERE F.FieldName = 'Author'
AND F.FieldType = 'Person'

qryReviews
(Datasource=RDCMS-PHA-CORE, Time=31ms, Records=0) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/ContentReviews.cfm @ 14:00:17

SELECT TOP 5
P.EntityID, P.FirstName, P.LastName, P.NickName, R.Rating, R.Review, R.Review as ReviewRaw, R.ReviewDate, E.ExternalPK, R.ShowAsAnonymous
FROM CN_People P
INNER JOIN Entities E on E.EntityID = P.EntityID
INNER JOIN ES_Rating R ON P.EntityID = R.PersonID
WHERE
ItemNumber = 1845
AND R.Review is not null
ORDER BY R.ReviewDate DESC

qryGetItemEntityID
(Datasource=RDCMS-PHA-CORE, Time=0ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetRecommendedContentItems.cfm @ 14:00:17

SELECT dbo.GetContentItemID(?) as EntityID

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 1845

qryCI
(Datasource=RDCMS-PHA-CORE, Time=78ms, Records=5) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetRecommendedContentItems.cfm @ 14:00:18

SELECT
TOP 5
R.ResourceName,
FRR1.Relevance, CI.ItemNumber,
S.RootURL + PT.URLFTPPath + '?ItemNumber=' + cast(CI.ItemNumber as varchar) as PreferredDisplayPage
FROM Entities E
INNER JOIN Resources R ON E.EntityID = R.EntityID
INNER JOIN CM_ContentItems CI ON R.EntityID = CI.EntityID
INNER JOIN dbo.FindRelevantResources(?, ?) FRR1 ON E.EntityID = FRR1.EntityID
INNER JOIN CM_PreferredDisplay PD ON CI.ItemNumber = PD.ItemNumber
INNER JOIN PT_PresentationTemplates PT
ON PT.EntityID = dbo.GetPresentationTemplateID(PD.TemplateNumber)
AND PD.SiteID = PT.SiteID
INNER JOIN SM_Sites S ON PD.SiteID = S.SiteID
WHERE E.IsActive = 1
AND S.SiteID = ?
AND S.SiteType = ?
AND CI.TemplateID IN (?,?,?,?,?)
AND CI.EditableProduct = 0
AND CI.DatePublished IS NOT NULL
AND ( CI.ReleaseDate IS NULL OR DateDiff(d,ReleaseDate,getdate()) >= 0 )
AND ( CI.ExpireDate IS NULL OR DateDiff(d,getdate(),ExpireDate) > 0 )
AND CI.DateArchived IS NULL
AND CI.LoginRequired = 0
AND (
-- permissions are overridden
CI.VisibilityException is not null
-- or there are no restrictions
OR (CI.ItemNumber not in (select ItemNumber from CM_AccessGroups) and
CI.ItemNumber not in (select ItemNumber from CM_MemberTypes)
)
)
ORDER BY FRR1.Relevance DESC, CI.DatePublished DESC

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 10682
Parameter #2 Type: CF_SQL_REAL Value: 0
Parameter #3 Type: CF_SQL_INTEGER Value: 840
Parameter #4 Type: CF_SQL_VARCHAR Value: production
Parameter #5 Type: CF_SQL_INTEGER Value: 5035, 3254, 5038, 3576, 6321

getRelatedContent
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=0) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/RelatedContent.cfm @ 14:00:18

select RC.ParentItemNumber AS ItemNumber, RC.ChildItemNumber AS ContentItemNumber,
RC.ChildEntityID AS EntityID, RC.RelatedContentID,
COALESCE(CIR.ResourceName, FR.ResourceName) As ResourceName,
COALESCE(CIR.ResourceType, FR.ResourceType) As ResourceType,
COALESCE(CIR.Abstract, FR.Abstract) As Abstract,
FOL.Secure As SecureFile, F.EntityID As FileID, F.UrlPath, F.FileExt, F.FileSize,
dbo.GetPreferredDisplayPage(RC.ChildItemNumber,840,?) AS PDP
from CM_RelatedContent RC
left join CM_ContentItems CI ON (RC.ChildItemNumber = CI.ItemNumber AND CI.DateArchived IS NULL AND CI.DatePublished IS NOT NULL)
left join FM_Files F ON RC.ChildEntityID = F.EntityID
left join SM_Folders FOL ON F.FolderID = FOL.EntityID
left join Resources CIR ON CIR.EntityID = CI.EntityID
left join Resources FR ON FR.EntityID = F.EntityID
where ParentItemNumber = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_VARCHAR Value: production
Parameter #2 Type: CF_SQL_INTEGER Value: 1845

getFields
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=3) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select F.FieldID, F.Maximum, F.GroupNum, F.FieldName, F.FieldType,
T.ContentItemField
from CM_Fields F
join CM_FieldTypes T on F.FieldType = T.FieldType
where F.TemplateID in (6330)
order by F.GroupNum, F.DisplayOrder

getContentItemIDs
(Datasource=RDCMS-PHA-CORE, Time=0ms, Records=18) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select CI.EntityID as ContentItemID, CI.TemplateID
from CM_ContentItems CI
join Entities E on CI.EntityID = E.EntityID
where E.isActive = 1
and CI.TemplateID in (6330)
and CI.EditableProduct = 0
AND CI.DatePublished is not null
AND ( CI.ReleaseDate is null or DateDiff(d,CI.ReleaseDate,getdate()) >= 0 )
AND ( CI.ExpireDate is null or DateDiff(d,getdate(),CI.ExpireDate) > 0 )
AND CI.DateArchived is null
and CI.LoginRequired = 0
and (
-- permissions are overridden
CI.VisibilityException is not null
-- or there are no restrictions
or (CI.ItemNumber not in (select ItemNumber from CM_AccessGroups) and
CI.ItemNumber not in (select ItemNumber from CM_MemberTypes)
)
)
order by CI.ItemNumber

getCIFullInfo
(Datasource=RDCMS-PHA-CORE, Time=15ms, Records=54) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select
E.EntityID as ContentItemID, E.DateCreated, E.LastModified, E.LastVerified, E.ExternalPK,
CI.ItemNumber, CI.TemplateID,
CI.DatePublished, CI.ReleaseDate, CI.ExpireDate, CI.DateArchived, isNull(CI.ReleaseDate,CI.DatePublished) AS EffectivePublishDate,
CI.LoginRequired, CI.VisibilityException, CI.VisibilityRestriction,
CI.SearchBrowse, CI.DefaultPrice, CI.ProductNumber, CI.HandlingCharge,
CI.ShipWeightPounds, CI.ShipWeightOunces, CI.ShippingCharge,
CI.EventStart, CI.EventEnd, CI.EventLocation, CI.EventAgenda,
CI.RegistrationBegins, CI.RegistrationDeadline, CI.MaxRegistrants,
R.ResourceName, R.Abstract, hitcount,
F.FieldID, ISNULL(F.GroupNum,1) as GroupNum,
F.FieldName, F.FieldType, F.Maximum,
CIF.ContentItemFieldID, ISNULL(CIF.RepNum,1) as RepNum,
CIF.FldString, CIF.FldText, CIF.FldInt, CIF.FldDate, CIF.FldDecimal,
dbo.GetName(CI.TemplateID) as ContentTemplate,
dbo.GetPreferredDisplayPage(CI.ItemNumber, ?, ?) as PreferredDisplayPage,
dbo.hasContentAccess(CI.ItemNumber, ?, ?) as HasAccess,
CASE when CT.TemplateType = 'Event' then dbo.ClassIsFull(CI.ItemNumber) else 0 END as ClassIsFull
from CM_ContentItems CI
join Entities E on CI.EntityID = E.EntityID and E.EntityType = 'Resource'
join Resources R on CI.EntityID = R.EntityID and R.ResourceType = 'ContentItem'
join CM_ContentTemplates CT on CI.TemplateID = CT.EntityID
left join CM_Fields F on CI.TemplateID = F.TemplateID
left join CM_ContentItemFields CIF on CI.EntityID = CIF.ContentItemID and F.FieldID = CIF.FieldID
where CI.EntityID in (6522,6523,6524,8524,8526,8528,8530,8540,8542,8544,8546,8549,8551,8553,8555,8557,8559,8562)
order by CI.ItemNumber, GroupNum, RepNum, F.FieldID

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 840
Parameter #2 Type: CF_SQL_VARCHAR Value: production
Parameter #3 Type: CF_SQL_INTEGER Value:
Parameter #4 Type: CF_SQL_VARCHAR Value:

getContentItems
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=0) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select cast(null as int) as TemplateID,
cast(null as varchar(200)) as ContentTemplate,
cast(null as int) as ContentItemID,
cast(null as varchar(40)) as ExternalPK,
cast(null as int) as ItemNumber,
cast(null as varchar(200)) as ResourceName,
cast(null as varchar(2000)) as Abstract,
cast(null as int) as hitcount,
cast(null as datetime) as DatePublished,
cast(null as datetime) as ReleaseDate,
cast(null as datetime) as ExpireDate,
cast(null as datetime) as DateArchived,
cast(null as datetime) as EffectivePublishDate,
cast(null as datetime) as DateCreated,
cast(null as datetime) as LastModified,
cast(null as datetime) as LastVerified,
cast(null as money) as DefaultPrice,
cast(null as varchar(50)) as ProductNumber,
cast(null as int) as ShipWeightPounds,
cast(null as int) as ShipWeightOunces,
cast(null as money) as ShippingCharge,
cast(null as money) as HandlingCharge,
cast(null as datetime) as EventStart,
cast(null as datetime) as EventEnd,
cast(null as varchar(200)) as EventLocation,
cast(null as text) as EventAgenda,
cast(null as int) as MaxRegistrants,
cast(null as datetime) as RegistrationBegins,
cast(null as datetime) as RegistrationDeadline,
cast(0 as bit) as ClassIsFull,
cast(null as varchar(500)) as PreferredDisplayPage,
cast(0 as bit) as LoginRequired,
cast(null as varchar(20)) as VisibilityException,
cast(null as varchar(20)) as VisibilityRestriction,
cast(1 as bit) as HasAccess,
cast(1 as bit) as SearchBrowse
, cast(null as varchar(500)) as [DoctorImage]
, cast(null as varchar(300)) as [DoctorImage_ImageAltText]
, cast(null as text) as [DoctorInfo]
, cast(null as varchar(500)) as [DoctorName]
where 0 = 1

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=15ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 5062

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=32ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 5081

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=15ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 5079

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8523

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8525

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=15ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8527

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=31ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8529

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=0ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8539

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=32ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8541

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=0ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8543

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=31ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8545

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8547

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=31ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8550

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=15ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8552

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=0ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8554

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8556

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=16ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8558

getFileInfo
(Datasource=RDCMS-PHA-CORE, Time=31ms, Records=1) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/GetContentItems.cfm @ 14:00:18

select R.ResourceName, F.URLPath, F.ImageAltText, F.isImage, FLD.Secure
from Resources R
join FM_Files F ON R.EntityID = F.EntityID
join SM_Folders FLD ON F.FolderID = FLD.EntityID
where R.EntityID = ?

Query Parameter value(s):
Parameter #1 Type: CF_SQL_INTEGER Value: 8561

Stored Procedures

ActivityLogCreate (Datasource=RDCMS-PHA-Core, Time=235ms) in d:/inetpub/rdcommon/cmscore/CustomTags/CMSDBapi/ActivityLogCreate.cfm @ 14:00:17

parameters
typeCFSQLTypevaluevariable
INCF_SQL_VARCHARPHAONLINEUNIV_507_69BCADD6-AD43-4DDA-97CD2478D78FF048  
INCF_SQL_INTEGER3497  
INCF_SQL_INTEGER10682  
INCF_SQL_INTEGER1845  
INCF_SQL_VARCHARBrowse  

resultsets
nameresultset


Exceptions

[14:00:16] MissingInclude Exception in : d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/LoadPassport.cfm Line: 184

General Runtime Error; The file /CMSClientCode/PHA_cms_plus_com/misc/Custom/CustomTags/LoadPassportEmpty.cfm could not be located

[14:00:17] MissingInclude Exception in : d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/Search/SEO.cfm Line: 33

General Runtime Error; The file /CMSClientCode/PHA_cms_plus_com/misc/Custom/CustomTags/SEO.cfm could not be located

[14:00:17] MissingInclude Exception in : d:/inetpub/rdcommon/cmscore/CustomTags/CMSapp/ContentDetailMetaData.cfm Line: 35

General Runtime Error; The file /CMSClientCode/PHA_cms_plus_com/misc/Custom/CustomTags/ContentDetailMetaData.cfm could not be located

[14:00:17] MissingInclude Exception in : d:/inetpub/pha/phaonlineuniv-org/htdocs/Courses/Course.cfm Line: 2

General Runtime Error; The file /CMSClientCode/PHA_cms_plus_com/misc/Custom/CustomTags/ContentDetail.cfm could not be located


Scope Variables

application

struct
AnonymousEntityID3497
BackofficeURLhttp://PHA.cms-plus.com
Blog
struct
CommentComponentCMSCoreCode.CustomTags.CMSapp.Blog.Comment
BrandingCMSPlus
CMSHomePage/applications/cms/MyTasks.cfm
CMSInstalledComponentsAccessGroup,Account,AdSpace,ApplicationMessage,Blog,Broadcast,Calendar,CalendarEvent,Chapters,CheckInManagement,CMS,CMSRole,ContactPoint,ContentClassification,ContentItem,ContentTemplate,Coupon,CouponTemplate,DatabaseCustomization,DataCollection,Department,DepartmentCode,Discussion,Dues,Event,EventConfiguration,EventTemplate,ExternalData,File,Folder,Group,GroupBuilder,Membership,MembershipTypes,Menu,Navigation,NavigationTemplate,Order,Organization,PaymentBatch,PaymentOptions,Person,Personalization,PresentationTemplate,Product,ProductConfiguration,ProductTemplate,Registrant,ReportBuilder,ReportBuilderConfig,SalesTax,SelectList,ShippingOptions,SiteSearch,StoreConfiguration,Survey,SurveyTemplate,SystemConfiguration,WorkflowTemplate
CMSMenuRoot1
CMSVerityCollectionRDCMS-pha
ClientNamePHA
ClientSpecific/CMSClientCode/PHA_cms_plus_com/misc/Custom/CustomTags
CompletedLinkReportDird:\inetpub\master-cms-plus-com\database\LinkReport
CustomDatabaseNamerdcms-pha-custom
DSNCMSRDCMS-PHA-Core
DSNCMSCustomRDCMS-PHA-Custom
DSNCMSWarehouseRDCMS-PHA-Warehouse
DatabaseNamerdcms-pha-core
DefaultCountryID1
DeveloperEmail[empty string]
DeveloperIP204.153.45.77,204.153.45.84,204.153.46.107,204.153.46.115,204.153.46.116,204.153.46.120,204.153.46.121,204.153.46.132,204.153.46.133,204.153.46.135,204.153.46.141,204.153.46.137,204.153.46.161,204.153.46.162,204.153.46.163,76.174.7.234,204.153.46.131,204.153.46.127
EditorTinyMCE
EditorEncryptKey[empty string]
EditorLicenseKey[empty string]
EditorStylesheet/files/style/content.css
EditorVersion2
Events
struct
RegistrationFieldsBadge Name,Title,Organization,Address,Phone,Fax,E-mail Address,Contact Preference,Special Needs,Dietary Restrictions
FTPAscExtListtxt;htm;html;cfm;cfml;shtm;shtml;css;js;asp;asa
FTPStagingd:\inetpub\PHA\PHA-cms-plus-com\misc\FTPStaging
FileRepositoryPathd:\inetpub\PHA\PHA-files-cms-plus-com\htdocs
FileRepositorySecurePathd:\inetpub\PHA\PHA-files-cms-plus-com\misc\secure
FileRepositoryURL/files
InitializedTrue
InstallationIDF17A688E-468F-4FF9-8B83-A7033B54AB35
Interface
struct
AccessGroups
struct
AppPassword[null]
AppUsername[null]
Hash[empty string]
TargetURL[null]
Authentication
struct
AppPassword[null]
AppUsername[null]
Hash[empty string]
TargetURL[null]
GetPersonInfo
struct
AppPassword[null]
AppUsername[null]
Hash[empty string]
TargetURL[null]
Passport
struct
AppPassword[null]
AppUsername[null]
Hash[empty string]
TargetURL[null]
PasswordRecovery
struct
AppPassword[null]
AppUsername[null]
Hash[empty string]
TargetURL[null]
LastProcessedItemNumber653
MonsterEntityID839
NavQueryCache
struct
06CF6C96BF9E9899656C18FEACE1E739_IDs5121,5174,5137
06CF6C96BF9E9899656C18FEACE1E739_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
0A37BE9175ACF6C6A1EA4F8C3BF4EC22_IDs5137
0A37BE9175ACF6C6A1EA4F8C3BF4EC22_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
0A6C0767E85236848FEC6EC71619089A_IDs5117,5144,5137
0A6C0767E85236848FEC6EC71619089A_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
15D8CAECB77542F0F9EE79C4F59D7A3B_IDs5116,5119,5120,5117,5118,5121,5137
15D8CAECB77542F0F9EE79C4F59D7A3B_query
query [short version]
Query Source:QueryNew()
Records:6
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
1838F9C27D56F6262EFF852B709D6E42_IDs5145,5143,5144,5147,5146,7383,5115
1838F9C27D56F6262EFF852B709D6E42_query
query [short version]
Query Source:QueryNew()
Records:6
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
1CB1BB33CD2F23BFD9809A36A4B2A0D4_IDs17183,15087,15088,5137
1CB1BB33CD2F23BFD9809A36A4B2A0D4_query
query [short version]
Query Source:QueryNew()
Records:3
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
219B7534B024E43D823B05D601E7EEF3_IDs6539,6526
219B7534B024E43D823B05D601E7EEF3_query
query [short version]
Query Source:QueryNew()
Records:1
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
27860BA51A4920594C60F00498A03D7C_IDs5137
27860BA51A4920594C60F00498A03D7C_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
29EEE284582566A3D445C895E3FC4BED_IDs5137
29EEE284582566A3D445C895E3FC4BED_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
2C2DD980979C3957732FBD36B9D3A4AB_IDs5118,5152,5137
2C2DD980979C3957732FBD36B9D3A4AB_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
2C98235230A29210EE80D3C7A753CDDE_IDs5119,26629,5137
2C98235230A29210EE80D3C7A753CDDE_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
2CCC98094303DF3BBFA9D4566CB60BC1_IDs11407,5137
2CCC98094303DF3BBFA9D4566CB60BC1_query
query [short version]
Query Source:QueryNew()
Records:1
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
314642FB857FA83B3F9B5098F70D9776_IDs5137
314642FB857FA83B3F9B5098F70D9776_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
37A9F54114E98BF4FC9795B40AA7FAB9_IDs6528,6526
37A9F54114E98BF4FC9795B40AA7FAB9_query
query [short version]
Query Source:QueryNew()
Records:1
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
3947AF89E0CAC50DC6DB4F8770844D7C_IDs8673,26629,8676,9370,8674,5157,5161,5164,8792,5165,5115
3947AF89E0CAC50DC6DB4F8770844D7C_query
query [short version]
Query Source:QueryNew()
Records:10
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
3CBB0601DC24FBC93E2A2269815ED816_IDs7183,5152,5154,5155,5153,7186,5115
3CBB0601DC24FBC93E2A2269815ED816_query
query [short version]
Query Source:QueryNew()
Records:6
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
3F7B8FDD97AFA14FDC99A2E2BDD33D95_IDs5118,7186,5137
3F7B8FDD97AFA14FDC99A2E2BDD33D95_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
49A6BAC93DDFBF870995E604500F2F9D_IDs5120,5115
49A6BAC93DDFBF870995E604500F2F9D_query
query [short version]
Query Source:QueryNew()
Records:1
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
4E98FA3F291FA076E698912AD1CA5D2B_IDs5117,5146,5137
4E98FA3F291FA076E698912AD1CA5D2B_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
4FCAC0DDEF9717E253CDB248FF20378C_IDs5137
4FCAC0DDEF9717E253CDB248FF20378C_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
50643CAAABC7A04C338B1FF011C0F6B2_IDs0
50643CAAABC7A04C338B1FF011C0F6B2_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
5AEF50450B3561B170B9D24CB8BF898D_IDs5117,5144,6807,5138
5AEF50450B3561B170B9D24CB8BF898D_query
query [short version]
Query Source:QueryNew()
Records:3
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
5D4CDDD300452AEF6532ECF944A4C1EE_IDs5121,5176,5137
5D4CDDD300452AEF6532ECF944A4C1EE_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
6402C34AE0AA4535CC4D362B30B1C34C_IDs5119,8673,5137
6402C34AE0AA4535CC4D362B30B1C34C_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
66E129551B35DF814B675F7557E0FC84_IDs5116,5115
66E129551B35DF814B675F7557E0FC84_query
query [short version]
Query Source:QueryNew()
Records:1
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
6AB131BBB1C311D548D6443D7536A6BA_IDs5137
6AB131BBB1C311D548D6443D7536A6BA_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
6DD19ECF54EB04A437EAD5B28D63D141_IDs5116,8795,5139,5119,8673,26629,8676,9370,8674,5157,5161,5164,8792,5165,5120,5168,7247,5167,5169,7810,5166,5117,5145,5143,5144,5147,5146,7383,5118,7183,5152,5154,5155,5153,7186,5121,7839,5173,5174,5176,5115
6DD19ECF54EB04A437EAD5B28D63D141_query
query [short version]
Query Source:QueryNew()
Records:40
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
6FB9680ED0AB6C93C29F417B43D8797E_IDs5137
6FB9680ED0AB6C93C29F417B43D8797E_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
72664047A9EA5D1850B5F2B0C5CC8DF0_IDs7839,5173,5174,5176,5115
72664047A9EA5D1850B5F2B0C5CC8DF0_query
query [short version]
Query Source:QueryNew()
Records:4
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
743E810C76AE5FC74EF7FB66BD7CBE0D_IDs5117,5145,5137
743E810C76AE5FC74EF7FB66BD7CBE0D_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
7B750DC7A7C4E2986F2FC8720CBB1B7A_IDs5117,7383,5137
7B750DC7A7C4E2986F2FC8720CBB1B7A_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
7F9E72AB87234862B71C2EFC53F6D26D_IDs14711,13339,13338,7516,6544,6545,6546,6547,6548,6549,6550,6551,6552,6553,6554,6555,6556,6557,6807,6808,6809,6810,6811,6812,6813,6822,6823,6824,6828,6827,6821,6820,6819,6818,6826,6817,6825,6815,6814,5137
7F9E72AB87234862B71C2EFC53F6D26D_query
query [short version]
Query Source:QueryNew()
Records:39
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
83B6A12A06D0860388948559412F6E87_IDs5119,5115
83B6A12A06D0860388948559412F6E87_query
query [short version]
Query Source:QueryNew()
Records:1
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
879773A18CBBB2D679814D62FEFEA7A6_IDs5137
879773A18CBBB2D679814D62FEFEA7A6_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
8A1C18C82F0EA99F16EECE386E647EF1_IDs5118,7183,5137
8A1C18C82F0EA99F16EECE386E647EF1_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
8C3B3A6E70404884FDA0E614217E8082_IDs5120,5168,5137
8C3B3A6E70404884FDA0E614217E8082_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
8CC67DCAAD7254E8F7BE861B4BE19E34_IDs5119,8674,5137
8CC67DCAAD7254E8F7BE861B4BE19E34_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
958F4C341AD68321E640A6A2D8B6A9A1_IDs5137
958F4C341AD68321E640A6A2D8B6A9A1_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
9970DE7B13499A81FB057625A719C3C8_IDs5121,5115
9970DE7B13499A81FB057625A719C3C8_query
query [short version]
Query Source:QueryNew()
Records:1
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
9A571C4F2573C068CA7EF2F8C195898C_IDs5137
9A571C4F2573C068CA7EF2F8C195898C_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
9C9FDB4EB209550FCB874D0D21FCA471_IDs5119,9370,5137
9C9FDB4EB209550FCB874D0D21FCA471_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
9FDAD58DE5D997710D2EBC04382AA743_IDs5118,5153,5137
9FDAD58DE5D997710D2EBC04382AA743_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
A102B77855A2DB95EF1E309562321CBB_IDs5119,5161,5137
A102B77855A2DB95EF1E309562321CBB_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
A1A044D9AFFF561FDC5437AA60E3D0E7_IDs6537,6526
A1A044D9AFFF561FDC5437AA60E3D0E7_query
query [short version]
Query Source:QueryNew()
Records:1
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
A3DCF61C98FDD4089C82A465D5313E1D_IDs5137
A3DCF61C98FDD4089C82A465D5313E1D_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
A6D67698B6DE45E0DE4AE6D9B4062770_IDs5118,5154,5137
A6D67698B6DE45E0DE4AE6D9B4062770_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
B5586C5BDDCADF6C0504D4014D9E003E_IDs5119,8676,5137
B5586C5BDDCADF6C0504D4014D9E003E_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
B57A74E9D039315EF8B2A3D7F10AA069_IDs5121,5173,5137
B57A74E9D039315EF8B2A3D7F10AA069_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
BFA0F9DE460446A61D017FF2A4B35193_IDs5121,7839,5137
BFA0F9DE460446A61D017FF2A4B35193_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
C021D7D30EA02A733C7B5AF3C838B433_IDs5137
C021D7D30EA02A733C7B5AF3C838B433_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
C09859489BEEB243F5310D61E780A061_IDs0
C09859489BEEB243F5310D61E780A061_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
C4CBB8836BA6B873ED5764FE1CB1451A_IDs5117,5144,6555,5138
C4CBB8836BA6B873ED5764FE1CB1451A_query
query [short version]
Query Source:QueryNew()
Records:3
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
C996B01CB71DE826760F27CC80C146E2_IDs5137
C996B01CB71DE826760F27CC80C146E2_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
CD2DD12F0DD2FB3C9F3219FB90C90991_IDs5137
CD2DD12F0DD2FB3C9F3219FB90C90991_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
D1FBCF9DC6336E73DACBA99CFC223B73_IDs5137
D1FBCF9DC6336E73DACBA99CFC223B73_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
D5912AE772D2F7AB57B96B0063FF2AD3_IDs5118,5115
D5912AE772D2F7AB57B96B0063FF2AD3_query
query [short version]
Query Source:QueryNew()
Records:1
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
DCC2C5A969AD24A12D0EBECC520C9404_IDs5168,7247,5167,5169,7810,5166,5115
DCC2C5A969AD24A12D0EBECC520C9404_query
query [short version]
Query Source:QueryNew()
Records:6
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
F02F127170B97D4E655C597987292581_IDs5117,5115
F02F127170B97D4E655C597987292581_query
query [short version]
Query Source:QueryNew()
Records:1
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
F2D77E05730001578CFFEED64AFEFAAB_IDs5137
F2D77E05730001578CFFEED64AFEFAAB_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
F4C5E4114635A3A0B36660D949A8A7F2_IDs5117,5147,5137
F4C5E4114635A3A0B36660D949A8A7F2_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
FA26159B11027C6ED2617307A5FC012E_IDs5137
FA26159B11027C6ED2617307A5FC012E_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
FB6E25BEAC852B3BC3C4F19D8D711E4C_IDs5137
FB6E25BEAC852B3BC3C4F19D8D711E4C_query
query [short version]
Query Source:QueryNew()
Records:0
Columns:
FCF1D4BF732F2BEAE631B4C3270982D5_IDs8795,5139,5115
FCF1D4BF732F2BEAE631B4C3270982D5_query
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
FE9901704A204C1D06484E0689D78691_IDs6527,6526
FE9901704A204C1D06484E0689D78691_query
query [short version]
Query Source:QueryNew()
Records:1
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
OrganizationID6561
OrganizationNamePulmonary Hypertension Association
PTPreviewPathd:\inetpub\PHA\PHA-cms-plus-com\htdocs\applications\CMS-app\PTPreviews
PTPreviewURL/applications/Previews
SiteID840
SiteTypeproduction
StoreID1
SupportAddresssupport@cms-plus.com
SystemResources
struct
AccessGroup506
Account3271
AdSpace3473
ApplicationMessage3263
Blog3528
Broadcast3300
CMS3
CMSRole8
Calendar3363
CalendarEvent3364
Chapters3275
CheckInManagement3461
ContactPoint3264
ContentClassification499
ContentItem4
ContentTemplate5
Coupon3298
CouponTemplate3297
DataCollection657
DatabaseCustomization86
Department3270
DepartmentCode3273
DeveloperTools3462
Discussion3463
Dues3276
Event3483
EventConfiguration3265
EventTemplate3482
ExportBatch3280
ExternalData3464
File77
Folder7
Group3465
GroupBuilder3466
Membership3467
MembershipTypes3277
Menu874
Navigation3453
NavigationTemplate3454
Order648
Organization880
PaymentBatch3272
PaymentOptions659
Person10
Personalization68
PresentationTemplate11
Product3296
ProductConfiguration536
ProductTemplate3295
Registrant3267
Report113
ReportBuilder3484
ReportBuilderConfig3485
SalesTax537
SelectList12
ShippingOptions538
SiteSearch559
StoreConfiguration3266
Survey3468
SurveyTemplate3469
SystemConfiguration3274
WorkflowTemplate13
WarehouseDatabaseNamerdcms-pha-warehouse
applicationnamePHAOnlineUniv
localDomainspha.cms-plus.com,*.phaOnlineUniv.org,phaOnlineUniv.org,pha.files.cms-plus.com
roamingDomains[empty string]

cffile

struct [empty]

cfthread

struct [empty]

cgi

struct
AUTH_TYPE[empty string]
AUTH_USER[empty string]
CF_TEMPLATE_PATHd:\inetpub\pha\phaonlineuniv-org\htdocs\Courses\Course.cfm
CONTENT_LENGTH-1
CONTENT_TYPE[empty string]
CONTEXT_PATH[empty string]
GATEWAY_INTERFACE[empty string]
HTTPSoff
HTTP_ACCEPTtext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODINGx-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGEen-us,en-gb,en;q=0.7,*;q=0.3
HTTP_HOSTwww.phaonlineuniv.org
HTTP_USER_AGENTCCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO[empty string]
PATH_TRANSLATEDd:\inetpub\pha\phaonlineuniv-org\htdocs\Courses\Course.cfm
QUERY_STRINGItemNumber=1845
REMOTE_ADDR54.196.204.15
REMOTE_HOST54.196.204.15
REMOTE_IDENT[empty string]
REMOTE_USER[empty string]
REQUEST_METHODGET
SCRIPT_NAME/Courses/Course.cfm
SERVER_NAMEwww.phaonlineuniv.org
SERVER_PORT80
SERVER_PORT_SECURE0
SERVER_PROTOCOLHTTP/1.0
SERVER_SOFTWAREBlueDragon.NET/7.1.1 (Microsoft-IIS/7.5)

client

struct [empty]

cookie

struct
CFID507
CFTOKEN69BCADD6-AD43-4DDA-97CD2478D78FF048

form

struct [empty]

request

struct
commentsinitYES
isbot
function isBot
Arguments:
NameRequiredTypeDefault
user_agentnostring#CGI.http_user_agent#
Return Type:boolean
Roles:
Access:
Output:no
rdcleanqueryterm
function RDCleanQueryTerm
Arguments:
NameRequiredTypeDefault
inputvalueyesstring
ignorenobooleanfalse
Return Type:string
Roles:
Access:
Output:no
rdcms_init_jqueryYES

server

struct
bluedragon
struct
edition9
mode2
resourcepathd:\BlueDragon.NET\resources
coldfusion
struct
appserverBlueDragon.NET/7.1.1 (Microsoft-IIS/7.5)
expiration[empty string]
installkit[empty string]
productlevel.NET
productnameBlueDragon
productversion7,1,1,18433
rootdird:\BlueDragon.NET
serialnumber[empty string]
supportedlocalesArabic (Saudi Arabia),Bulgarian (Bulgaria),Catalan (Spain),Chinese (Taiwan),Czech (Czech Republic),Danish (Denmark),German (Germany),Greek (Greece),English (United States),Finnish (Finland),French (France),Hebrew (Israel),Hungarian (Hungary),Icelandic (Iceland),Italian (Italy),Japanese (Japan),Korean (South Korea),Dutch (Netherlands),Norwegian (Bokmål) (Norway),Polish (Poland),Portuguese (Brazil),Romanian (Romania),Russian (Russia),Croatian (Croatia),Slovak (Slovakia),Albanian (Albania),Swedish (Sweden),Turkish (Turkey),Urdu (Islamic Republic of Pakistan),Indonesian (Indonesia),Ukrainian (Ukraine),Belarusian (Belarus),Slovenian (Slovenia),Estonian (Estonia),Latvian (Latvia),Lithuanian (Lithuania),Persian (Iran),Vietnamese (Vietnam),Armenian (Armenia),Azeri (Latin) (Azerbaijan),Basque (Spain),Macedonian (Macedonia),Afrikaans (South Africa),Georgian (Georgia),Faroese (Faroe Islands),Hindi (India),Malay (Malaysia),Kazakh (Kazakhstan),Kyrgyz (Kyrgyzstan),Kiswahili (Kenya),Uzbek (Latin) (Uzbekistan),Tatar (Russia),Punjabi (India),Gujarati (India),Tamil (India),Telugu (India),Kannada (India),Marathi (India),Sanskrit (India),Mongolian (Cyrillic) (Mongolia),Galician (Spain),Konkani (India),Syriac (Syria),Divehi (Maldives),Arabic (Iraq),Chinese (China),German (Switzerland),English (United Kingdom),Spanish (Mexico),French (Belgium),Italian (Switzerland),Dutch (Belgium),Norwegian (Nynorsk) (Norway),Portuguese (Portugal),Serbian (Latin) (Serbia and Montenegro (Former)),Swedish (Finland),Azeri (Cyrillic) (Azerbaijan),Malay (Brunei Darussalam),Uzbek (Cyrillic) (Uzbekistan),Arabic (Egypt),Chinese (Hong Kong),German (Austria),English (Australia),Spanish (Spain),French (Canada),Serbian (Cyrillic) (Serbia and Montenegro (Former)),Arabic (Libya),Chinese (Simplified) (Singapore),German (Luxembourg),English (Canada),Spanish (Guatemala),French (Switzerland),Arabic (Algeria),Chinese (Traditional) (Macao S.A.R.),German (Liechtenstein),English (New Zealand),Spanish (Costa Rica),French (Luxembourg),Arabic (Morocco),English (Ireland),Spanish (Panama),French (Principality of Monaco),Arabic (Tunisia),English (South Africa),Spanish (Dominican Republic),Arabic (Oman),English (Jamaica),Spanish (Venezuela),Arabic (Yemen),English (Caribbean),Spanish (Colombia),Arabic (Syria),English (Belize),Spanish (Peru),Arabic (Jordan),English (Trinidad and Tobago),Spanish (Argentina),Arabic (Lebanon),English (Zimbabwe),Spanish (Ecuador),Arabic (Kuwait),English (Republic of the Philippines),Spanish (Chile),Arabic (United Arab Emirates),Spanish (Uruguay),Arabic (Bahrain),Spanish (Paraguay),Arabic (Qatar),Spanish (Bolivia),Spanish (El Salvador),Spanish (Honduras),Spanish (Nicaragua),Spanish (Puerto Rico),Amharic (Ethiopia),Tamazight (Latin) (Algeria),Inuktitut (Latin) (Canada),Sami (Southern) (Norway),Mongolian (Traditional Mongolian) (People's Republic of China),Scottish Gaelic (United Kingdom),English (Malaysia),Dari (Afghanistan),Bengali (Bangladesh),Wolof (Senegal),Kinyarwanda (Rwanda),K'iche (Guatemala),Yakut (Russia),Alsatian (France),Corsican (France),Occitan (France),Maori (New Zealand),Irish (Ireland),Sami (Northern) (Sweden),Breton (France),Sami (Inari) (Finland),Mohawk (Canada),Mapudungun (Chile),Yi (People's Republic of China),Lower Sorbian (Germany),Igbo (Nigeria),Greenlandic (Greenland),Luxembourgish (Luxembourg),Bashkir (Russia),Sesotho sa Leboa (South Africa),Quechua (Bolivia),Yoruba (Nigeria),Hausa (Latin) (Nigeria),Filipino (Philippines),Pashto (Afghanistan),Frisian (Netherlands),Nepali (Nepal),Sami (Northern) (Norway),Inuktitut (Syllabics) (Canada),Serbian (Latin) (Serbia),Sinhala (Sri Lanka),Serbian (Cyrillic) (Serbia),Lao (Lao P.D.R.),Khmer (Cambodia),Welsh (United Kingdom),Tibetan (People's Republic of China),Sami (Skolt) (Finland),Assamese (India),Malayalam (India),English (India),Oriya (India),Bengali (India),Turkmen (Turkmenistan),Bosnian (Latin) (Bosnia and Herzegovina),Maltese (Malta),Serbian (Cyrillic) (Montenegro),Sami (Northern) (Finland),isiZulu (South Africa),isiXhosa (South Africa),Setswana (South Africa),Upper Sorbian (Germany),Bosnian (Cyrillic) (Bosnia and Herzegovina),Tajik (Cyrillic) (Tajikistan),Serbian (Latin) (Bosnia and Herzegovina),Sami (Lule) (Norway),Romansh (Switzerland),Sami (Lule) (Sweden),Quechua (Ecuador),Quechua (Peru),Croatian (Latin) (Bosnia and Herzegovina),Serbian (Latin) (Montenegro),Sami (Southern) (Sweden),English (Singapore),Uyghur (People's Republic of China),Serbian (Cyrillic) (Bosnia and Herzegovina),Spanish (United States),Dutch (Belgian),French (Canadian),Norwegian (Bokmal),Dutch (Standard),French (Standard),Norwegian (nynorsk),English (Australian),French (Swiss),Portuguese (Brazilian),English (Canadian),German (Austrian),Portuguese (Standard),English (New Zealand),German (Standard),Spanish (Mexican),English (UK),German (Swiss),Spanish (Modern),English (US),Italian (Standard),Spanish (Standard),French (Belgian),Italian (Swiss),Swedish,ar_SA,bg_BG,ca_ES,zh_TW,cs_CZ,da_DK,de_DE,el_GR,en_US,fi_FI,fr_FR,he_IL,hu_HU,is_IS,it_IT,ja_JP,ko_KR,nl_NL,nb_NO,pl_PL,pt_BR,ro_RO,ru_RU,hr_HR,sk_SK,sq_AL,sv_SE,th_TH,tr_TR,ur_PK,id_ID,uk_UA,be_BY,sl_SI,et_EE,lv_LV,lt_LT,fa_IR,vi_VN,hy_AM,az_Latn-AZ,eu_ES,mk_MK,af_ZA,ka_GE,fo_FO,hi_IN,ms_MY,kk_KZ,ky_KG,sw_KE,uz_Latn-UZ,tt_RU,pa_IN,gu_IN,ta_IN,te_IN,kn_IN,mr_IN,sa_IN,mn_MN,gl_ES,kok_IN,syr_SY,dv_MV,ar_IQ,zh_CN,de_CH,en_GB,es_MX,fr_BE,it_CH,nl_BE,nn_NO,pt_PT,sr_Latn-CS,sv_FI,az_Cyrl-AZ,ms_BN,uz_Cyrl-UZ,ar_EG,zh_HK,de_AT,en_AU,es_ES,fr_CA,sr_Cyrl-CS,ar_LY,zh_SG,de_LU,en_CA,es_GT,fr_CH,ar_DZ,zh_MO,de_LI,en_NZ,es_CR,fr_LU,ar_MA,en_IE,es_PA,fr_MC,ar_TN,en_ZA,es_DO,ar_OM,en_JM,es_VE,ar_YE,en_029,es_CO,ar_SY,en_BZ,es_PE,ar_JO,en_TT,es_AR,ar_LB,en_ZW,es_EC,ar_KW,en_PH,es_CL,ar_AE,es_UY,ar_BH,es_PY,ar_QA,es_BO,es_SV,es_HN,es_NI,es_PR,am_ET,tzm_Latn-DZ,iu_Latn-CA,sma_NO,mn_Mong-CN,gd_GB,en_MY,prs_AF,bn_BD,wo_SN,rw_RW,qut_GT,sah_RU,gsw_FR,co_FR,oc_FR,mi_NZ,ga_IE,se_SE,br_FR,smn_FI,moh_CA,arn_CL,ii_CN,dsb_DE,ig_NG,kl_GL,lb_LU,ba_RU,nso_ZA,quz_BO,yo_NG,ha_Latn-NG,fil_PH,ps_AF,fy_NL,ne_NP,se_NO,iu_Cans-CA,sr_Latn-RS,si_LK,sr_Cyrl-RS,lo_LA,km_KH,cy_GB,bo_CN,sms_FI,as_IN,ml_IN,en_IN,or_IN,bn_IN,tk_TM,bs_Latn-BA,mt_MT,sr_Cyrl-ME,se_FI,zu_ZA,xh_ZA,tn_ZA,hsb_DE,bs_Cyrl-BA,tg_Cyrl-TJ,sr_Latn-BA,smj_NO,rm_CH,smj_SE,quz_EC,quz_PE,hr_BA,sr_Latn-ME,sma_SE,en_SG,ug_CN,sr_Cyrl-BA,es_US
os
struct
additionalinformationMicrosoft Corp. 1.1.4
archx64
buildnumber[empty string]
nameWindows Server "Longhorn"
version6.1

session

struct
InitializedTrue
Passport
struct
EmployerID[empty string]
EntityID[empty string]
ExternalPK[empty string]
FirstName[empty string]
LastName[empty string]
MembershipType[empty string]
OrderID[empty string]
OrgName[empty string]
Permissions
struct [empty]
PrimaryRep0
isLoggedIn0
isMember0
isOrg0
cfid507
cftoken69BCADD6-AD43-4DDA-97CD2478D78FF048
sessionidPHAONLINEUNIV_507_69BCADD6-AD43-4DDA-97CD2478D78FF048
urltokenCFID=507&CFTOKEN=69BCADD6-AD43-4DDA-97CD2478D78FF048

url

struct
ITEMNUMBER1845
MNITEMNUMBER[empty string]
QNITEMNUMBER[empty string]
SNITEMNUMBER[empty string]
TNITEMNUMBER[empty string]
UNITEMNUMBER[empty string]

variables

struct
DepthChange2
DisplayDepth2
Exclusionsalpha,dev,dev2,staging,prod,www
GroupLookup
struct
150325
50355
50384
63216
HasChildrenFalse
LastDepth2
MappingExtensionphaonlineuniv_org
MaxLen250
RDCleanQueryTerm
function RDCleanQueryTerm
Arguments:
NameRequiredTypeDefault
inputvalueyesstring
ignorenobooleanfalse
Return Type:string
Roles:
Access:
Output:no
RepNum4
SuppressAuthorsfalse
breadCrumb<a href="/">Home</a>
cfquery.executiontime15
endCrumb[empty string]
getRelatedContent
query [short version]
Query Source:SQL Query
Datasource:RDCMS-PHA-CORE
Query:select RC.ParentItemNumber AS ItemNumber, RC.ChildItemNumber AS ContentItemNumber, RC.ChildEntityID AS EntityID, RC.RelatedContentID, COALESCE(CIR.ResourceName, FR.ResourceName) As ResourceName, COALESCE(CIR.ResourceType, FR.ResourceType) As ResourceType, COALESCE(CIR.Abstract, FR.Abstract) As Abstract, FOL.Secure As SecureFile, F.EntityID As FileID, F.UrlPath, F.FileExt, F.FileSize, dbo.GetPreferredDisplayPage(RC.ChildItemNumber,840,?) AS PDP from CM_RelatedContent RC left join CM_ContentItems CI ON (RC.ChildItemNumber = CI.ItemNumber AND CI.DateArchived IS NULL AND CI.DatePublished IS NOT NULL) left join FM_Files F ON RC.ChildEntityID = F.EntityID left join SM_Folders FOL ON F.FolderID = FOL.EntityID left join Resources CIR ON CIR.EntityID = CI.EntityID left join Resources FR ON FR.EntityID = F.EntityID where ParentItemNumber = ?
Time:16 ms
Records:0
Columns:ItemNumber, ContentItemNumber, EntityID, RelatedContentID, ResourceName, ResourceType, Abstract
SecureFile, FileID, UrlPath, FileExt, FileSize, PDP
getResourceID
function getResourceID
Arguments:
NameRequiredTypeDefault
resourcerequiredany
iCount3
isBot
function isBot
Arguments:
NameRequiredTypeDefault
user_agentnostring#CGI.http_user_agent#
Return Type:boolean
Roles:
Access:
Output:no
isSelectedfalse
mayAdd
function mayAdd
Arguments:
NameRequiredTypeDefault
resourcerequiredany
mayChangeState
function mayChangeState
Arguments:
NameRequiredTypeDefault
resourcerequiredany
mayDelete
function mayDelete
Arguments:
NameRequiredTypeDefault
resourcerequiredany
mayEdit
function mayEdit
Arguments:
NameRequiredTypeDefault
resourcerequiredany
mayView
function mayView
Arguments:
NameRequiredTypeDefault
resourcerequiredany
mnItemNumber531
navItemNumber531
qryAncestors
query [short version]
Query Source:QueryNew()
Records:1
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
qryComments
query [short version]
Query Source:SQL Query
Datasource:RDCMS-PHA-CORE
Query:SELECT TOP 5 P.EntityID, P.FirstName, P.LastName, P.NickName, R.Rating, R.Review, R.Review as ReviewRaw, R.ReviewDate, E.ExternalPK, R.ShowAsAnonymous FROM CN_People P INNER JOIN Entities E on E.EntityID = P.EntityID INNER JOIN ES_Rating R ON P.EntityID = R.PersonID WHERE ItemNumber = 1845 AND R.Review is not null ORDER BY R.ReviewDate DESC
Time:31 ms
Records:0
Columns:EntityID, FirstName, LastName, NickName, Rating, Review, ReviewRaw
ReviewDate, ExternalPK, ShowAsAnonymous
qryContent
query [short version]
Query Source:SQL Query
Datasource:RDCMS-PHA-CORE
Query:SELECT TOP 5 R.ResourceName, FRR1.Relevance, CI.ItemNumber, S.RootURL + PT.URLFTPPath + '?ItemNumber=' + cast(CI.ItemNumber as varchar) as PreferredDisplayPage FROM Entities E INNER JOIN Resources R ON E.EntityID = R.EntityID INNER JOIN CM_ContentItems CI ON R.EntityID = CI.EntityID INNER JOIN dbo.FindRelevantResources(?, ?) FRR1 ON E.EntityID = FRR1.EntityID INNER JOIN CM_PreferredDisplay PD ON CI.ItemNumber = PD.ItemNumber INNER JOIN PT_PresentationTemplates PT ON PT.EntityID = dbo.GetPresentationTemplateID(PD.TemplateNumber) AND PD.SiteID = PT.SiteID INNER JOIN SM_Sites S ON PD.SiteID = S.SiteID WHERE E.IsActive = 1 AND S.SiteID = ? AND S.SiteType = ? AND CI.TemplateID IN (?,?,?,?,?) AND CI.EditableProduct = 0 AND CI.DatePublished IS NOT NULL AND ( CI.ReleaseDate IS NULL OR DateDiff(d,ReleaseDate,getdate()) >= 0 ) AND ( CI.ExpireDate IS NULL OR DateDiff(d,getdate(),ExpireDate) > 0 ) AND CI.DateArchived IS NULL AND CI.LoginRequired = 0 AND ( -- permissions are overridden CI.VisibilityException is not null -- or there are no restrictions OR (CI.ItemNumber not in (select ItemNumber from CM_AccessGroups) and CI.ItemNumber not in (select ItemNumber from CM_MemberTypes) ) ) ORDER BY FRR1.Relevance DESC, CI.DatePublished DESC
Time:78 ms
Records:5
Columns:ResourceName, Relevance, ItemNumber, PreferredDisplayPage
qryCreditTypes
query [short version]
Query Source:SQL Query
Datasource:RDCMS-PHA-CORE
Query:SELECT LI.ListItemID, LI.DisplayText FROM Resources R INNER JOIN CM_ListItems LI ON R.EntityID = LI.ListID WHERE R.ResourceName = 'Course Credit Type' AND LI.isActive = 1 ORDER BY LI.DisplayOrder
Time:0 ms
Records:4
Columns:ListItemID, DisplayText
qryDoctor
query [short version]
Query Source:QueryNew()
Records:18
Columns:abstract, classisfull, contentitemid, contenttemplate, datearchived, datecreated, datepublished
defaultprice, doctorimage, doctorimage_imagealttext, doctorinfo, doctorname, effectivepublishdate
eventagenda, eventend, eventlocation, eventstart, expiredate, externalpk
handlingcharge, hasaccess, hitcount, itemnumber, lastmodified, lastverified
loginrequired, maxregistrants, preferreddisplaypage, productnumber, registrationbegins, registrationdeadline
releasedate, resourcename, searchbrowse, shippingcharge, shipweightounces, shipweightpounds
templateid, visibilityexception, visibilityrestriction
qryFullNav
query [short version]
Query Source:QueryNew()
Records:40
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
qryLearningGroups
query [short version]
Query Source:SQL Query
Datasource:RDCMS-PHA-CORE
Query:SELECT MD.MetadataID, MD.Metadata FROM MD_MetadataCollections C INNER JOIN MD_MetadataStructure S ON C.RootMetadataID = S.AncestorMetadataID INNER JOIN MD_Metadata MD ON S.ChildMetadataID = MD.MetadataID WHERE C.CollectionName = 'Learning Groups' ORDER BY S.DisplayOrder
Time:16 ms
Records:7
Columns:MetadataID, Metadata
qryMainNav
query [short version]
Query Source:QueryNew()
Records:6
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
qrySecondNav
query [short version]
Query Source:QueryNew()
Records:2
Columns:templateid, contenttemplate, contentitemid, externalpk, itemnumber, parentitemnumber, resourcename
abstract, datepublished, releasedate, expiredate, preferreddisplaypage, loginrequired
visibilityexception, visibilityrestriction, hasaccess, depth, targeturl, targetwindow
useurlvariables
qrySpecialty
query [short version]
Query Source:SQL Query
Datasource:RDCMS-PHA-CORE
Query:SELECT LI.ListItemID, LI.DisplayText FROM Resources R INNER JOIN CM_ListItems LI ON R.EntityID = LI.ListID WHERE R.ResourceName = 'Specialty' AND LI.isActive = 1 ORDER BY LI.DisplayOrder
Time:15 ms
Records:50
Columns:ListItemID, DisplayText
referringSite[empty string]
showCrumb1
tmp
struct [empty]
wasSelectedfalse

Debug Rendering Time: 15 ms