|
|
| (6 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| {{Reporting Indicators | | {{Reporting Indicators |
| |description='''Transfer Delay''' is the difference between [[Dispo_DtTm]] and [[#Transfer Ready DtTm in use at different times]] in decimal days. | | |description='''Transfer Delay''' is the difference between [[Dispo_DtTm]] and [[#Transfer Ready DtTm in use at different times]] in decimal days. |
| |created_raw=created | | |created_raw=Created |
| |Program=Critical Care | | |Program=Critical Care |
| |indicator_start_date=1999-01-15 | | |indicator_start_date=1999-01-15 |
| Line 7: |
Line 7: |
| |program=Critical Care and Medicine | | |program=Critical Care and Medicine |
| }} | | }} |
|
| |
| There is a similar concept in medicine, [[Transfer Delay (Medicine)]]. | | There is a similar concept in medicine, [[Transfer Delay (Medicine)]]. |
|
| |
|
| Line 25: |
Line 24: |
| === [[Admit DtTm]] or [[Dispo DtTm]] < 2020-10-01 00:00 === | | === [[Admit DtTm]] or [[Dispo DtTm]] < 2020-10-01 00:00 === |
| * Use the DtTm in [[Transfer Ready DtTm field]] | | * Use the DtTm in [[Transfer Ready DtTm field]] |
|
| |
| {{Todo | who = Tina| question =
| |
| * Discussed with Julie that we will actually update these in the data rather than do these updates at reporting time. The query below should do it. Pagasa, could you apply it when you get a chance and update here when done? Thanks! [[User:Ttenbergen|Ttenbergen]] 09:46, 2022 June 29 (CDT)
| |
| ** when I started to make the query to update this I came across TRs that were not on the same date as the dispo_dttm. I can understand why we would change times if the TR is on the Dispo Dt, but it doesn't seem to make sense to change them if they are earlier. So, I just want to make sure that you really would have reported e.g. the following with a changed time.
| |
| :: D_ID Transfer_Ready_DtTm Dispo_DtTm HrsMins new_tr_dttm
| |
| :: GRA_N3-3089 2007-07-31 2007-08-23 15:30:00 00:00:00 2007-07-31 10:00:00
| |
| ::* I only make a substitution if same date with Dispo date. Added that part now. however when I have looked at my current code, I no longer have this substitution. Is it because you have combined the dttm together when we moved to access from Ed's and thus the time became 00:00. how did you handle it when transitioning to ACCESS, those without time - did you make the transfer ready dttm blanks or made time to 00:00 ? --[[User:JMojica|JMojica]] 11:37, 2022 September 21 (CDT)
| |
| **** This is one field in Access now, so leaving them blank isn't an option. So you treated blank and midnight differently? Would anyone reasonably become transfer ready at midnight? No rounds happening then. I guess it's possible. So, really you haven't done this for some time, possibly since we moved form Ed's version? I am also prepared to take this whole thing out of the documentation and not do it at all... [[User:Ttenbergen|Ttenbergen]] 16:20, 2022 September 22 (CDT)
| |
| ***** I agree, let us drop this whole thing out about transfer time missing and do not do any substitution at all when time is missing. --[[User:JMojica|JMojica]] 11:08, 2022 October 12 (CDT)
| |
| ****** Will you stop doing them in SAS as well, then? Otherwise we are back to inconsistent definitions. [[User:Ttenbergen|Ttenbergen]] 11:55, 2022 October 12 (CDT) ****** OK. --[[User:JMojica|JMojica]] 08:53, 2022 October 19 (CDT)
| |
| ***** I removed the sub article ... with missing time. --[[User:JMojica|JMojica]] 16:13, 2023 January 17 (CST)}}
| |
|
| |
| {{DT|
| |
| * There were problems with the query I provided to Pagasa, this one doesn't seem to play nice if pasted as SQL. Waiting for reply from Julie on above before providing update since it might change. [[User:Ttenbergen|Ttenbergen]] 11:04, 2022 September 21 (CDT)
| |
| }}
| |
|
| |
| Query to run if we really want to do this for all records w zero times even if different dates.
| |
| UPDATE L_Log INNER JOIN created_Program ON L_Log.D_ID = created_Program.D_ID SET L_Log.Transfer_Ready_DtTm = [transfer_ready_dttm]+IIf(TimeValue([dispo_dttm])<#12/30/1899 10:0:0#,#12/30/1899 0:1:0#,#12/30/1899 10:0:0#)
| |
| WHERE ((L_Log.Transfer_Ready_DtTm>#1/1/1900#)
| |
| AND ((created_Program.program)="cc")
| |
| AND ((L_Log.Dispo_DtTm) Is Not Null)
| |
| AND ((TimeValue(Nz([transfer_ready_dttm],#1/1/1900#))=#12/30/1899#)=True)
| |
| AND ((DateValue(Nz([dispo_dttm],#1/2/1900#))=DateValue(Nz([transfer_ready_dttm],#1/1/1900#)))=True));
| |
|
| |
|
| === [[Admit DtTm]] or [[Dispo DtTm]] >= 2020-10-01 00:00 === | | === [[Admit DtTm]] or [[Dispo DtTm]] >= 2020-10-01 00:00 === |
| Line 70: |
Line 46: |
| # to HSC IICU/H6, and | | # to HSC IICU/H6, and |
| # to other wards/Home (including nursing home/long term care facility) | | # to other wards/Home (including nursing home/long term care facility) |
| The [[Dispo]] location will be used to define the destination. As per Dr. Garland & Dr. Paunovic. | | {{DJ | |
| | * ''The [[Dispo]] location will be used to define the destination. As per Dr. Garland & Dr. Paunovic. |
| | ** I think we discussed at Task that we will do this differently now... right? |
| | }} |
| | |
| | {{DJ | |
| | * The above is really about stratification, and not the indicator itself. Do you really only use it to stratify delays, or do you also report other indicators such as Length of Stay with it. Even if it is single-use, I think we should probably treat any generated value we use to stratify pretty much as we do Indicators, possibly using the same templates on the wiki. The stratification affects averages and totals, so it needs to be transparent. This is likely a can of worms because there must be much stratification in the reports. [[User:Ttenbergen|Ttenbergen]] 14:50, 7 December 2025 (CST) |
| | |
| | }} |
|
| |
|
| ==SAS Program== | | ==SAS Program== |
| Line 78: |
Line 62: |
|
| |
|
| == Data use == | | == Data use == |
| * [[Transfer Delay (Critical Care)|Transfer Delay]]
| |
| * [[Avoidable Days (Critical Care)]] | | * [[Avoidable Days (Critical Care)]] |
| * [[Beds occupied by transferrable patients (Critical Care)|Beds occupied by transferrable patients]] | | * [[Beds occupied by transferrable patients (Critical Care)|Beds occupied by transferrable patients]] |