This is used to add the it to dashboards.
Transaction posted to a hospital account for services provided.... read more
Transactions posted to a hospital account that moves the balance owed to an external agency to work the account.... read more
Transactions posted to a hospital account that is not being serviced by a bad debt agency or internal payment plan.... read more
Surgical cases designated as Orthopedic based on their service line classification in the OR.... read more
A hospital account that was ever placed into an Observation base class. Discharge base class is ignored meaning patients who were later converted to inpatient a... read more
Queries
IF OBJECT_ID (MyDepartment,U) IS NOT NULL DROP TABLE MyDepartment;GO SET ANSI_NULLS ONGO SET QUOTED_IDENTIFIER ONGO CREATE TABLE [dbo].[MyDepartment]( [DepartmentID] [smallint] NOT NULL, [DepartmentName] [nvarchar](30) NOT NULL, [ParentID] [nvarchar](40) NULL, CONSTRAINT [PK_DepartmentID] PRIMARY KEY CLUSTERED ( [DepartmentID] ASC ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] GO
Requester: President Obama Operational User: President Trump ##ME1559 Dashboard component HB Monthly Financial Summary which displays the report Monthly Fina... read more
This report will display all bypassed warnings by an registrar. Only specific workqueues are checked. There are 8 affected rules that are excluded. ... read more
