Automatic updation of transaction [message #83752] |
Sun, 07 December 2003 06:19 |
Rahman
Messages: 40 Registered: July 2003
|
Member |
|
|
hi friend!
help me please!
i 've a problem:-
In emergency dept.Patients admission are going on but Patient's Discharge should automatically be done after 24 hrs. of admission.
e.g. MRN, DtAdmit, TimeAdmit, DtDsch, TimeDsch .......etc columns are in a table.
when patients are admitted then value of MRN,DtAdmit, TimeAdmit etc are entired but i've to write the program to automatic updation of DtDsch, TimeDsch columns of a relavant patient after 24 hrs. of their Admission (based on DtAdmit, TimeAdmit).
anybody kindly help me.
warm regards
rahman
|
|
|
Re: Automatic updation of transaction [message #83969 is a reply to message #83752] |
Sun, 11 January 2004 18:16 |
prashant
Messages: 122 Registered: September 2000
|
Senior Member |
|
|
u need not update the time automatically just use formulas wherever u want to calc the discharge time.
U can calc and put the discharge time on admission only and in reports just chk the time using the sysdate fnc
|
|
|
|