Requested TISS changes for the next version

From CCMDB Wiki
Jump to navigationJump to search

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

Reports

StatsLogo.svg

What is the intended use of these reports?

  • SMW


  • Cargo


  • Categories

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