We are trying to rationalize the status of forms to facilitate communication between sites and the data center. Would like to have the form status default to...
You will have to change the default at the database level, in the definition of the Event_Header table (the column is called COMPLETED, a lousy name in ...
Sorry - easy enough to put a default on this at the table level, but where do I find the choice list itself? I would like to relabel the choices. - Mike...
We use the word "incomplete" to mean a form that can never be completed (because, for example, some parameters in it are based on a blood draw, and the sample...
Prakash - We now have two studies up and a new problem has arisen that is related to the one solved with your code below. Namely, patients who are in OTHER...
The current version of the code accommodates this situation. If you log in as a user restricted to a particular site,. you will see only patients for that...
I don't believe this is correct. When I log in as a person restricted to a specific site, I do only see patients in a study from that site. But when I then...
Let me try this out and make the necessary fix and send them back to you. Prakash _____ From: trialdb@yahoogroups.com [mailto:trialdb@yahoogroups.com] On...
Having a minor problem. Want different ARMS to have different set of forms, etc., and have gone into the Access client and assigned things apparently...
This is one area where we have the Access piece all working, but the Web part is lagging behind. The code that shows up different forms for different events is...
I have been asked to followup on the status of the following issues that were posed a while back. 1. NCI lab toxicities integration (specifically referring to...
I have been asked to followup on the status of the following issues that were posed a while back. 1. NCI lab toxicities integration (specifically referring to...
Sounds good, on the first issue, I remember you telling me that the CTC's were available, I would like them to import, but I misspoke, I was meaning for the...
We did not have CTC v3 originally in the vocab metadata, but we have it now. I have just posted a zipped MDB file, TrialDB_vocab.zip, in the development folder...
Are you running the chm file on a Win 2003 server? Should work just fine on XP. Prakash _____ From: trialdb@yahoogroups.com [mailto:trialdb@yahoogroups.com] On...
I just figured out a nice little trick. If we can get these hide_pat_groups codes that Tom developed down, using the default value option in SQL, I set it so...
nice ... From: mikejonathan77 To: trialdb@yahoogroups.com Sent: Thursday, May 04, 2006 9:38 AM Subject: [trialdb] SQL Schema Summary One of my programmers...
Definitely needed, can it be linked from the eroom site? _____ From: trialdb@yahoogroups.com [mailto:trialdb@yahoogroups.com] On Behalf Of Cynthia Sent:...
Thanks a lot, the anomalies section is very useful. Prakash _____ From: trialdb@yahoogroups.com [mailto:trialdb@yahoogroups.com] On Behalf Of mikejonathan77 ...
Matt, I have added the link to the eRoom site. It is called "Schema Analysis for SQL Server". Mihai -- http://www.cs.utah.edu/~mvirtosu ... Definitely needed,...
Prakash, just noticed a glitch. When adding a patient, if you click save and proceed to enroll, and then on the enrollment page choose to go back to clinical...
Matt - This is a variation of a problem we have had. The demographic information is actually saved, I think. Try to enter the same patient - or any patient...
This is what I thought as well, but I searched thoroughly for the patient, even in the tables, with no info at all. I will look again, just tobe sure. Thanks ...
We are noticing that there are very few triggers in the SQL Server schema but quite a number in the Oracle schema. Is there a historical basis (e.g. were old...
Most of the triggers have to deal with autonumbers. Oracle does not support these in the intuitive way that SQL Server does with Identity columns. You have to...
Has there been consideration of how TrialDB in the future will or won't relate to the caBIG initiative? Given the history of TrialDB with cancer trials, I...