Coordinator Reports

Description

Developer Description

Contains links to a number of reports intended for use by the Coordinator as well as surveyors.

System Description

This report is meant for the coordinator.

Terms

Charge

term Approved

Transaction posted to a hospital account for services provided.... read more

Transaction term

Transactions posted to a hospital account that moves the balance owed to an external agency to work the account.... read more

Unavailable Bed

term Approved

Unavailable Beds are defined as the number of unavailable beds at a given point in time, adjusted based on Staffing or Licensing levels. Staffed Beds are checke... read more

Details

System Name	Coordinator Reports
Report Type	SSRS Report
Last Modified	07/23/2019 ·
Documentation Last Modified	07/13/2019 ·
Report Author
Report Requester
Operational Owner
Visible in Search	Yes
Epic Identifier	ABC 30
Atlas Id	30
Estimated Run Frequency	Weekly
Fragility Rating	High
Maintenance Schedule	Yearly
Organizational Value Rating	Critical
Fragility Tags	Diagnosis Code New Application Batches

Queries

Query #1 |

WITH OrgTree (DepartmentID, DepartmentName, ParentID, Tree)AS(   SELECT DepartmentID, DepartmentName, ParentID , 0 AS Tree    FROM MyDepartment   WHERE ParentID IS NULL   UNION ALL   SELECT MyDepartment.DepartmentID, MyDepartment.DepartmentName, MyDepartment.ParentID , OrgTree.Tree + 1   FROM MyDepartment   JOIN OrgTree ON MyDepartment.ParentID = OrgTree.DepartmentID) SELECT * FROM OrgTree ORDER BY Tree

Query #2 |

select c.*, FIRST_VALUE(c.name) OVER (ORDER BY c.price ASC) AS FirstValue_Asc from courses c order by c.price; select c.*, FIRST_VALUE(c.name) OVER (ORDER BY c.price DESC) AS FirstValue_Desc from courses c where c.price < 100 and exists (select * from register_course rc where rc.course_id=c.id) order by c.price;

Query #3 |

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

Relationships

Reports included in this report.

Restraint and Alarm Usage Crystal Report

Restraints and Alarms shows the numbers of residents admitted to a long-term care facility who have received restraints or used alarms in the last seven days. ... read more

Coordinator Reports

Description

Developer Description

System Description

Terms

Profile

-

-

-s

Profile

-

-

-s

Profile

-

-

-s

Details

Relationships

Reports included in this report.

Profile

-

-

-s

Profile

-

-

-s