View source for Requested TISS changes for the next version

This is the list of requested changes for [[TISS28.accdb]]. For a log of previous changes see [[TISS28.accdb Change Log]].

== Structure ==

== Importer ==

== Editing ==

== Checks ==
{{#ask: [[Category:Data Integrity Checks]] [[DICStatus::ready to implement]] [[Category: TISS28 checks]]
 |?DICSummary=Summary
 |?DICStatus = Status
 |?DICApp = App
 |?Category
 |order=ascending
 |limit=1000
 |format=broadtable
 |link=all
 |class=sortable wikitable smwtable
}}

== Reports ==
{{Discuss | who=Julie | question=What is the intended use of these reports? }}

=== Sums for site/unit ===
*4 views for Aggregation periods required based on '''discharge date''': 
** monthly
** quarterly
** fiscal year (Apr1 - Mar 31)
** calendar year
derived from [[#Data by patient for whole stay]]
*Includes SITE, UNIT, PERIOD, T1_n - T49n, T1_CountDays - T49_CountDays
**where T1_n - T49_n - refer to the number of patients with data
**T1_CountDays - Sum of T1_Days of all patients with data
***...T49_CountDays - Sum of T49_Days of all patients with data

=== Sums for site/unit over range of dates===
*4 views for Aggregation periods required based on '''discharge date''': 
** monthly
** quarterly
** fiscal year (Apr1 - Mar 31)
** calendar year
Derived from [[#Data by Site, Unit and Calendar Date ]]
*Includes SITE, UNIT, PERIOD, T1_n - T49n, T1_TotPtDays - T49_TotPtDays, Sum_DAILY_BED_23HR, Sum_DAILY_BED_COUNT, AVE_BED, Sum_TISS_SCORE, TISS_per_patient_day, TISS_predicted_RN
**where T1_n - T49_n - refer to the number of calendar days 
**T1_TotPtDays - Sum of T1_PtDays over all calendar days 
***...T49_TotPtDays - Sum of T49_PtDays over all calendar days
** SUM_BED23HR = SUM of DAILY_BED_23HR over all calendar days
** SUM_BED = SUM of DAILY_BED Occupied all calendar days
** AVE_BED = Average of DAILY_BED Occupied all calendar days
** SUM_TISS = Sum of SUM_TISS over all calendar days
** TISS_per_patient_day (formula above)
** TISS_predicted_RN (formula above)

===Data by Site, Unit and Calendar Date ===
*Includes SITE, UNIT, CALENDAR_DATE, T1_PtDays - T45_PtDays, T46_PtDays - T49_PtDays,DAILY_BED_23HR, DAILY_BED_COUNT, SUM_TISS_Score, Bottom_TISS_Rank1,Bottom_TISS_Rank2,Bottom_TISS_Rank3,Bottom_TISS_Rank4
**where T1_PtDays = Sum of (T1 * BED_OCCUP) over all patients on that date
*** ... T45_PtDays = Sum of (T45 * BED_OCCUP) over all patients on that date
** T46_PtDays = Sum of T46 over all patients on that date
*** ... T49_PtDays = Sum of T49 over all patients on that date
** DAILY_BED_23HR = Sum of BED_23HR over all patients on that date
** DAILY_BED = Sum of BED_Occup over all patients on that date
** SUM_TISS_Score = Sum of TISS_SCORE over all patients on that date
** Bottom_TISS_Rank1= Lowest TISS_SCORE on that date
** Bottom_TISS_Rank2= Second to the Lowest TISS_SCORE on that date
** Bottom_TISS_Rank3= Third to the Lowest TISS_SCORE on that date
** Bottom_TISS_Rank4= Fourth to the Lowest TISS_SCORE on that date

== Bugs ==

== not sure what to make of these ==
=== Data by Patient and Date ===
*Includes SITE, UNIT, SERIAL, CALENDAR_DATE, T1 - T49, BED_23HR, BED_OCCUP, TISS_SCORE
**CALENDAR_DATE = ITEM_DATE (i.e., date TISS item data was collected from admit date to discharge date)
**T1 - T49 = is individual TISS item scored (1-yes, 0-no)
**BED_23HR = is bed occupied by patient at 2300 hrs (1-yes, 0-no)
**BED_OCCUP = number of hours bed occupied per day (for partial days, e.g., on first and last day of stay, number of hours is calculated as bed/24*100) 
**TISS_SCORE = sum of TISS points for each CALENDAR_DATE (see [[TISS Item List]] for individual TISS item points)
**To determine BED_OCCUP and BED_23HR, the admit date_time and discharge date_time are required

'' NOTE: This view '''can''' be generated even if the patient is not yet discharged''

=== Data by patient for whole stay ===
derived from [[#Data by Patient and Date]]

'' this '''can not''' be generated even if the patient is not yet discharged because it requires a discharge date''
*Includes SITE, UNIT, SERIAL, T1_Days - T45_Days, T46_Days - T49_Days, TISS_SCORE, Day1_TISS, Day2_TISS, Last_TISS
**where T1_Days = Sum of (T1 * BED_OCCUP) over all calendar dates of stay
*** ... T45_Days = Sum of (T45 * BED_OCCUP) over all calendar dates of stay
** T46_Days = Sum of T46 over all calendar dates of stay
*** ... T49_Days = Sum of T49 over all calendar dates of stay
** TISS_SCORE = Sum of TISS_SCORE over all calendar dates of stay
** Day1_TISS = TISS_SCORE on the first day of stay
** Day2_TISS = TISS_SCORE on the second day of stay
** Last_TISS = TISS_SCORE on the last day of stay
** [[LOS]]



[[Category: IT Instructions]]
[[Category: Development Documentation]]
[[Category: TISS28]]