Advanced Search

Hospitals & Health Systems Practice Groups Home Resources   Member Briefings   Newsletters   Advisory Opinions   Email Alerts   Teleconferences   Luncheons   HLN Feature Articles   Listserve Task Forces & Affinity Groups Upcoming Projects Leadership Volunteer Contact PG Staff                           Hospitals and Health Systems The Hospitals and Health Systems Practice Group addresses the legal, financial, and operational issues raised by healthcare business strategies and transactions from the perspective of hospitals and health systems, including those involving other nonprofit, for-profit, public, and private hospitals and health systems, physicians and physician organizations, ancillary services providers, for-profit affiliates, financial institutions and authorities, pharmaceutical and medical products manufacturers and vendors, and managed care organizations. See a sample of the Hospitals and Health Systems Rx newsletter, one of the products you will receive as a Practice Group member! To become a member of the Hospitals and Health Systems Practice Group today, click on the Enroll link below. Related Files Sample Newsletter (PDF File) Related Links Join our Listserve Enroll in this Practice Group Upcoming Projects Firms/Employers with largest representation in Practice Groups   ADR Service | Teleconferences | In-Person Programs Career Center | Bookstore | Sitemap | Contact Us | Login/Logout | Home

© 2008 American Health Lawyers Association   Privacy Policy  Copyright and Legal Information Suite 600, 1025 Connecticut Avenue NW   Washington, DC 20036-5405    Phone: (202) 833-1100   Fax: (202) 833-1105

GetSystemVariables (Records=83, Time=0ms)
SQL = 
SELECT a.*

    FROM System_Variable a

   WHERE VariableTypeCode = 'E'

SavedBakset (Records=0, Time=0ms)
SQL = 
SELECT a.*, 

           b.EtailerID,

           b.SKU,

           b.TaxableFlag,

           b.UnitPrice AS NewPrice,

           b.MemberPrice AS NewMemberPrice,

           b.QuantityEditableFlag,

           b.ShippingWeight,

           b.ShipFlag,

           b.FormatID,

           c.StockStatusDesc AS StockStatus,

           NULL AS SpecialPriceID

      FROM Basket_Save a, Product b, Stock_Status_Ref c

     WHERE a.ProductID = b.ProductID

       AND b.StockStatusCode = c.StockStatusCode

       AND 1=0

CheckMembersOnlyFlag (Records=1, Time=0ms)
SQL = 
SELECT MembersOnlyFlag FROM Content WHERE ContentID = 57745

GetContentInfo (Records=1, Time=0ms)
SQL = 
SELECT a.Keywords,

               a.Description,

               a.ShowInTemplateFlag,

               a.OpenInNewWindowFlag,

               a.SuppressBannersFlag,

               b.ContentID AS HTMLContentID,

               b.Title,

               b.Body,

               c.TemplatePath,

               c.Name,

               c.NavContentGroupInd,

               (SELECT count(*)

                  FROM Content_File y

                 WHERE y.ContentID = 57745) AS FileCount,

               (SELECT count(*)

                  FROM Content_Link z

                 WHERE z.ContentID = 57745) AS LinkCount

         FROM Nav_Menu c, Content a LEFT OUTER JOIN Content_HTML b

           ON a.ContentID = b.ContentID

        WHERE a.ContentID = 57745

          AND c.NavMenuID = a.NavMenuID

GetFiles (Records=1, Time=16ms)
SQL = 
SELECT a.ContentFileID,

                 a.FileName,

                 a.SourceLocation,

                 a.PublishLocation,

                 a.Description,

                 b.MimeType,

                 b.FileTypeCode,

                 b.FileTypeDesc,

                 c.OpenInNewWindowFlag

            FROM Content_File a,

                 File_Type_Ref b, 

								 Content c 

           WHERE a.ContentID = 57745

             AND a.FileTypeCode = b.FileTypeCode

						 AND a.ContentID = c.ContentID

						ORDER by a.SortOrder

GetLinks (Records=4, Time=0ms)
SQL = 
SELECT a.*

            FROM Content_Link a, Content b 

           WHERE a.ContentID = 57745

					   AND a.ContentID = b.ContentID

						 ORDER by b.UserDefinedDate1 Desc, a.SortOrder

109 milliseconds

URL Parameters:

CONTENTID=57745
FUSEFLAG=1
FUSEPREVIEW=False
SECTION=Resources6
TEMPLATE=/ContentManagement/ContentDisplay.cfm

CGI Variables:

AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Users\AHLA_PROD\WWW\Template.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_HOST=www.healthlawyers.org
HTTP_REFERER=http://www.healthlawyers.org/
HTTP_USER_AGENT=ColdFusion
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/Template.cfm
PATH_TRANSLATED=D:\Users\AHLA_PROD\WWW\Template.cfm
QUERY_STRING=Section=Resources6&Template=/ContentManagement/ContentDisplay.cfm&ContentID=57745&FuseFlag=1
REMOTE_ADDR=65.245.209.32
REMOTE_HOST=65.245.209.32
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Template.cfm
SERVER_NAME=www.healthlawyers.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=ISAPI