Hi All,
I need to create new groups based on some criteria mentioned as below. I am using CR8.5 and SQL Server database.
The database is set as below.
Site is the top order and can have Gyn, Neuro, Cardio and so on.
Under the Site lot of patients are admitted.
Under each pattient there are lot of times like surgery start time. surgery end time, Anesthesia start time, Anes end time, room start time, room end time and so on. Each category like surgery, anes or room they are associated with catid. For example surgery is associated with 1121, anes is associated with 1223 and so on.
Now I nned to create a new site based on the category and their associated times.
This is only for Gyn site. For other site we use the system site only.
Each category may have start time, end time or may not have any time.
First criteria: If the category is Surgery(1121) and if the start time and end time are not null the I need to create a group as GynSurg and only this category should got to this new group. Also if there is no time in any category then these categories should to be associated with GynSurg site.
Second Critera: If the category is Anes(1223) and the start time and end times are not null then this category has to be associated with GynAnes.
Third category: If the category is in Surgery(1121) and Anes(1223) and if bot the categories have statr time and end times then thse two catogaries have to be associated with GynSurg.
If a patient has more categories other than Surgery and Anes then all these categories should be associated with GynSurg site.
If it is confusing please let me know. I can provide more examples.
Thanks in advance.
Pal
I need to create new groups based on some criteria mentioned as below. I am using CR8.5 and SQL Server database.
The database is set as below.
Site is the top order and can have Gyn, Neuro, Cardio and so on.
Under the Site lot of patients are admitted.
Under each pattient there are lot of times like surgery start time. surgery end time, Anesthesia start time, Anes end time, room start time, room end time and so on. Each category like surgery, anes or room they are associated with catid. For example surgery is associated with 1121, anes is associated with 1223 and so on.
Now I nned to create a new site based on the category and their associated times.
This is only for Gyn site. For other site we use the system site only.
Each category may have start time, end time or may not have any time.
First criteria: If the category is Surgery(1121) and if the start time and end time are not null the I need to create a group as GynSurg and only this category should got to this new group. Also if there is no time in any category then these categories should to be associated with GynSurg site.
Second Critera: If the category is Anes(1223) and the start time and end times are not null then this category has to be associated with GynAnes.
Third category: If the category is in Surgery(1121) and Anes(1223) and if bot the categories have statr time and end times then thse two catogaries have to be associated with GynSurg.
If a patient has more categories other than Surgery and Anes then all these categories should be associated with GynSurg site.
If it is confusing please let me know. I can provide more examples.
Thanks in advance.
Pal