Revision history for database
Additions:
~- Not Contacted (used for issue organizations only)
Talk to your supervisor if you think there needs to be a new status.
**When entering information in Contact/Notes, always be sure to date and initial the entry.**
For example: 5/11/07 talked to Linda: e-mailing ratings (you initials)
**Filtering Data**
The dropdown boxes at the top of each column filter the information by whatever you select. They will be very useful for finding and organizing information. Once a filter is selected, all other filters will only apply to the information already on the screen. To apply a different filter to all organizations, you will need to change the selection of the first to //All//.
If you are the first one to use the database after a session has ended, be sure that it is updated for the new session.
Talk to your supervisor if you think there needs to be a new status.
**When entering information in Contact/Notes, always be sure to date and initial the entry.**
For example: 5/11/07 talked to Linda: e-mailing ratings (you initials)
**Filtering Data**
The dropdown boxes at the top of each column filter the information by whatever you select. They will be very useful for finding and organizing information. Once a filter is selected, all other filters will only apply to the information already on the screen. To apply a different filter to all organizations, you will need to change the selection of the first to //All//.
If you are the first one to use the database after a session has ended, be sure that it is updated for the new session.
Deletions:
Additions:
~- Have No Rating This Year (this is different that an Inactive organization because they may produce ratings the following year)
~- New Rating Complete (the most recent rating has passed through the checking process and is posted on the web)
~- Rating in Office (we have received the rating and its either waiting to be entered or in the checking process)
~- Problem Rating (The problem should be indicated in the notes column. If appropriate, the group type should be changed to Inactive.)
~- Not Contacted (used for issue org
~- New Rating Complete (the most recent rating has passed through the checking process and is posted on the web)
~- Rating in Office (we have received the rating and its either waiting to be entered or in the checking process)
~- Problem Rating (The problem should be indicated in the notes column. If appropriate, the group type should be changed to Inactive.)
~- Not Contacted (used for issue org
Deletions:
Additions:
The progress of the ratings program is tracked in an Excel database located in the Research share drive in the Ratings folder. The database is shared and can be viewed by more than one person at a time. Be careful not to overwrite someone else's work and always keep the database up to date.
**Type** refers to whether the organization currently produces ratings. //Active// organizations do, //Inactive// organizations do not (at last contact). //New// means the organization was contacted, but we were unable to ascertain whether or not they produced ratings. //501c3// means the organization is a registered non-profit organization and is thus limited in its involvement in politics. //Issue Org// means the organization came from our database of issue organizations and has not been contacted.
**Status** refers to the current state of the organization or rating. This column must be kept up to date in order to produce an accurate weekly report. Only use the following phrases in this column:
~- Contacting
~- Have No Rating This Year (this is different that an
**Type** refers to whether the organization currently produces ratings. //Active// organizations do, //Inactive// organizations do not (at last contact). //New// means the organization was contacted, but we were unable to ascertain whether or not they produced ratings. //501c3// means the organization is a registered non-profit organization and is thus limited in its involvement in politics. //Issue Org// means the organization came from our database of issue organizations and has not been contacted.
**Status** refers to the current state of the organization or rating. This column must be kept up to date in order to produce an accurate weekly report. Only use the following phrases in this column:
~- Contacting
~- Have No Rating This Year (this is different that an
