USTUR Database
The USTUR Database System
The database system was designed to provide a centralized electronic file for data on USTUR registrants in support of analytical and administrative data services. It provides a main database system for storing all data and retrieving large volumes of different data from various tables.
Access, a commercial database engine software, provides the infrastructure of the USTUR database system with the ability to import and export data in several different formats for mathematical and statistical analyses. The system was built with structure designs that are easy to understand and extend. Although the design is somewhat complex, it was also developed to be user friendly. The database system includes several important features, including write-protection, data security, and easy query and report generation.
Periodically, the Access software is updated to the most current version to ensure data sharing capability with other software. Currently, the database files are stored in Microsoft Access 2000.
Security
Among the Registries foremost concerns is the privacy of our registrants and the integrity of our data. For this reason, the database system was designed and programmed to be highly secure, with three levels of security: the network, database, and file access authorizations. Users must have access to all three levels to have exclusive rights to the data.
The first level, network security, requires a user to enter a valid password to proceed and logon to the network. The user can share his or her own files with anyone that has the same access authorization. Passwords are only given to Registries staff.
The second level, database security, requires an additional password for access to the database system. Individual passwords are issued to USTUR staff for accessing the data.
The final level is the administrative access right, which is an exclusive right to the database file. This authorization allows the user the capability to change, edit, add or delete data from the database. A password is assigned to each specific person who is responsible for the integrity of each specific database table.
These security measures are designed to protect the files from potential damage to data or misuse by unauthorized personnel. They are also designed to protect and insure the personal identity and privacy of the registrants.
Database files (Administrative Database)
Personal registrant information such as address, age, date of birth, etc., is stored in the Administrative database (Admin). Each registrant is assigned a unique, impersonal identification number (Case No.). To protect the privacy of these individuals, all other database tables are linked to Admin by case numbers and contain only data. Currently, only two Registries personnel have access to alter data in the Admin database.
The database tables are identified as follows:
Admin
The Admin database (Form) contains personal information about each registrant such as name, age, sex, worksite and contact information. Additionally, the status of the registrant also included e.g. whether he or she is inactive, or deceased. The renewal date indicates when each registrant is to be renewed. Each registrant is renewed for a period of 5 years.
Medical
The Medical database (Form) contains the abstracted medical, occupational, and personal history records provided by the registrant.
Rad Chem
The Rad Chem database (Form) contains the results of radiochemical analyses for the samples of deceased registrants.
Health Physics
The Health-Physics database (Form) contains the health physics records of each registrant provided by the worksite.
Clinical
The Clinical database (Form) contains the results of clinical tests performed for each registrant while they were alive.
Cause of Death
The Cause of Death database (Form) (Online Database) contains the autopsy and related pathology information for deceased registrants.
NHRTR
The NHRTR database (Form) contains a list of the preserved samples available for each case.
Solution
The Solution database (Form) contains a list of the tissue solutions available for each case.
The sample case shown in the forms above, Case #2000, is a ficticious case for illustration purposes only.
Secondary content using h2 tag.
Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Life is good at WSU.
Secondary content can be almost anything. If you are not using this region delete all the content that is in between the div tags with the id ="additional".
A unique richness of students, faculty, location, activities, and organizations creates a full, lively student life at the University. This section gives you the insider's view on student life and a sampling of the opportunities here.
"Glimpses." Students talk about life at WSU
These brief posts are written by WSU students to give you a personal look through their window on campus life.