IP Find Admitted Patients For IP Patient Safety

Description

Developer Description

Find admitted and HOV patients based on location information criteria .

Key Assumptions

Exclude patients? Yes
Department excluded (none)
Hospital excluded

System Description

Find admitted patients based on location information criteria.

Terms

Transaction term

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

Net A/R

term Approved

Transactions posted to a hospital account that is not being serviced by a bad debt agency or internal payment plan.... 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	IP Find Admitted Patients For IP Patient Safety
Report Type	Source Radar Dashboard
Last Modified	10/26/2019 ·
Documentation Last Modified	06/16/2019 ·
Report Author
Report Requester
Operational Owner
Visible in Search	Yes
Epic Identifier	ABC 23
Atlas Id	23
Estimated Run Frequency	Yearly
Fragility Rating	Low
Maintenance Schedule	Yearly
Organizational Value Rating	Critical
Fragility Tags	New Application Diagnosis Code ClarityREF Dependencies Regulatory Changes

Queries

Query #1 |

select t.name table_name, t.object_id, c.name column_name,c.column_id, i.name index_name, i.type, i.type_desc from sys.tables t, sys.columns c, sys.indexes i, sys.index_columns ic where t.object_id=c.object_id and c.object_id=i.object_id and ic.index_id=i.index_id and ic.column_id=c.column_id and t.name=tutorials;

Query #2 |

select lpad( ,level*3, )||ename name,SYS_CONNECT_BY_PATH(ename,/) bossfrom Employee_Mconnect by prior employee_id = manager_idstart with manager_id is null;

Query #3 |

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 #4 |

select t.name table_name, t.object_id, c.name column_name,c.column_id, i.name index_name, i.type, i.type_desc from sys.tables t, sys.columns c, sys.indexes i, sys.index_columns ic where t.object_id=c.object_id and c.object_id=i.object_id and ic.index_id=i.index_id and ic.column_id=c.column_id and t.name=tutorials;

Relationships

Reports included in this report.

IP Find Admitted Patients For IP Source Radar Dashboard Component

Find admitted and HOV patients based on location information criteria.... read more

Reports that include this report.

Radiology SMR RW Report

Pulls in Radiology SMR for a specified date range Logic: Pull in all imaging procedures for this facility Add in lab requisitions Add charges forl ab * Patien... read more

IP Find Admitted Patients For IP Patient Safety

Description

Developer Description

Key Assumptions

System Description

Terms

Profile

-

-

-s

Profile

-

-

-s

Profile

-

-

-s

Details

Relationships

Reports included in this report.

Profile

-

-

-s

Reports that include this report.

Profile

-

-

-s

Profile

-

-

-s