Input Needed ASAP

1 view
Skip to first unread message

Biren

unread,
May 19, 2005, 11:13:34 AM5/19/05
to South-Asian-Health...@googlegroups.com
Hi All! DEADLINE: 4/22

I have found a programmer who will help us design a database so that we
can work together over the web in review of the articles.

What I need is from those who have done review of literature in the
past(or not), to think about their effort and tell me what the database
needs.

To give you a better idea:
- one or two us will populate (and update weekly) the database by
downloading citations from MEDLINE (it will be automatically downloaded
and updated). Once we do that, it will look like just a citation from
MEDLINE.
- The next step is actually going through the article citations of your
interest and populate other fields (fields 9 and onwards in the table
below) based on your review. You can also decide an article is not
important and click on the "reviewed but not useful" checkbox. you can
also add your thoughts (reviewers comment). You may also populate
"additional keywords."
- each article of importance will be reviewed by two reviewers.

What I want you to do is: take a look at the database fields currently
in my table and tell me what else it needs. Items 1 thru 8 will be
filled from MEDLINE, after 9th field, I need your help. Please tell me
all that is important Think of what information would you want to
know: for example: I think "study type" would be nice to have: So, what
are the various study types? RCT, case report, case-controlled, review
etc.

Please respond to this by monday so that I can talk to the database
designer and get this running You can respond to this email or email
to: South-Asian-Health...@googlegroups.com.

Biren

Database Name: SAHRI_Articles

Fields:

Name of the field Type of field
1 Unique Identifier Number
2 Title Memo field
3 Authors Multiple last names, Memo field
4 Institution Text field
5 Journal Name Text field
6 Key words Text field
7 Abstract memo field
8 Publication Date year
9 Reviewed and not useful CHECKBOX
10 Study Type Drop box (review, RCT, case-control, case
report, editorial_,
11 study design Drop box (retrospective/prospective)
12 study population type in box
13 study n number
14 Additional Keywords text
15 Reviewer 1 comments memo
16 reviewer 1 initials populated by computer(based on login)
17 reviewer 2 comments memo
18 reviewer 2 initials populated by computer (based on login)
19
20

Reply all
Reply to author
Forward
0 new messages