Sample data for Training Records and Requirements Database ========================================================== (last modified by J. Repa 3/1/2002) **** Table: EHS_FUNCTION **** SQL command for getting data from EHS database: select function_id, function_name, function_description, qualifier_type, sequence_no from ehs_function; FUNCTION_ID FUNCTION_NAME FUNCTION_DESCRIPTION QUAL SEQUENCE_NO ----------- -------------------------- ------------------------------------------ ---- ----------- 1 WORKS IN FACILITY Works in MIT lab or other facility FACI 10 2 USES CHEMICALS Uses chemicals FACI 20 3 USES BLOOD OR BODY FLUIDS Uses blood or body fluids FACI 30 4 USES INFECTIOUS AGENTS Uses infectious agents FACI 40 5 SPILLS COFFEE Spills coffee on various things FACI 50 150 USES IRRADIATOR Uses the irradiator FACI 70 151 RUNS X-RAY MACHINE Operates an X-ray machine FACI 80 152 USES SELECT AGENTS Uses select biological agents FACI 45 153 USES RADIOACTIVE MATERIALS Works with or around radioactive materials FACI 60 154 WORKS WITH LASERS Works around class III or IV lasers FACI 90 **** Table: DLC **** SQL command for getting data from EHS database: select dept_id, dept_code, dept_name, has_child from dept; DEPT_ID DEPT_CODE DEPT_NAME HAS_CHILD ---------- --------------- -------------------------------------------------- --------- 101 D_ACAD ACADEMIC SERVICES 102 D_ADM ADMISSIONS 103 D_AEROAST Aeronautics and Astronautics 104 D_AILAB ARTIFICIAL INTELLIGENCE LABORATORY 105 D_ALUM ALUMNI ASSOCIATION 106 D_AMPS ACADEMIC MEDIA PRODUCTION SERVICES 107 D_ANTHRO ANTHROPOLOGY 108 D_ARCH Architecture 109 D_ARCHAE ARCHAEOLOGY P066100 110 D_ARTS OFFICE OF THE ARTS 111 D_ATH ATHLETICS 112 D_AUDIT AUDIT DIVISION 113 D_AVS AUDIOVISUAL SERVICES 114 D_B&CS BRAIN & COGNITIVE SCIENCES 115 D_BATES BATES ACCELERATOR 116 D_BEH Bioengineering & Environmental Health Sciences 117 D_BIOLOGY Biology 118 D_BPEC BIOTECHNOLOGY PROCESS ENGINEERING CENTER 119 D_CAC CAMPUS ACTIVITIES COMPLEX 120 D_CAES CENTER FOR ADVANCED EDUCATIONAL SERVICES 121 D_CAO CONTROLLERS ACCOUNTING OFFICE 122 D_CAVS CENTER FOR ADVANCED VISUAL STUDIES 123 D_CBE CENTER FOR BIOMEDICAL ENGINEERING P166000 124 D_CCR CANCER RESEARCH CENTER 125 D_CEE CIVIL & ENVIRONMENTAL ENGINEERING 126 D_CEHS Center for Environmental Health Sciences 127 D_CFELLOWS Central Fellowships 128 D_CHANCELLOR CHANCELLOR'S OFFICE P401500 129 D_CHAPLAINS CHAPLAINS 130 D_CHEM CHEMISTRY 131 D_CHEME CHEMICAL ENGINEERING P062000 132 D_CIPD CENTER FOR INNOVATION IN PRODUCT DEVELOPMENT 133 D_CIS CENTER FOR INTERNATIONAL STUDIES 134 D_CL&M CENTER FOR LEARNING & MEMORY 135 D_CLINRES Clinical Research Center 136 D_CMI CAMBRIDGE-MIT INSTITUTE 137 D_CMSE Center for Materials Science & Engineering 138 D_COMPMED Division of Comparative Medicine 139 D_CONCOURSE CONCOURSE 140 D_CONFLICTMGMT DISCIPLINE AND CONFLICT MANAGEMENT P441800 141 D_COPYTECH COPY TECHNOLOGY CENTER 142 D_CPSE Council on Primary and Secondary Education P401814 143 D_CRE CENTER FOR REAL ESTATE 144 D_CREDITUNION CREDIT UNION P872000 145 D_CSPA CAREER SERV & PRE-PROF ADVISING 146 D_CSR CENTER FOR SPACE RESEARCH 147 D_CSS COUNSELING & SUPPORT SERVICES 148 D_CTPID Ctr for Tech, Policy, & Industrial Dev 149 D_CTS CENTER FOR TRANSPORTATION STUDIES 150 D_DEANARCH DEAN OF ARCHITECTURE 151 D_DEANGRAD Dean of the Grad School Office 152 D_DEANSCI DEAN OF SCIENCE 153 D_DHSOE SCHOOL OF ENGINEERING DEPARTMENT HEADS 154 D_DHSS DEAN OF HUMANITIES & SOCIAL SCIENCES 155 D_DMSE DEPT MATERIAL SCIENCE AND ENGINEERING P066000 156 D_DOE DEAN OF ENGINEERING 157 D_DSL:HQ DSL HQ 158 D_DUE:HQ DUE HQ 159 D_DUSP URBAN STUDIES & PLANNING 160 D_EAPS EARTH, ATMOSPHERIC & PLANETARY SCIENCES 161 D_ECO ECONOMICS 162 D_ECSEL ECSEL 163 D_EECS Electrical Engineering & Computer Science 164 D_EIP ENGINEERING INTERNSHIP PROGRAM 165 D_EMS ENVIRONMENTAL MEDICAL SERVICE P495090 166 D_ENDICOTT ENDICOTT HOUSE 167 D_ENGSYS ENGINEERING SYSTEMS DIVISION 168 D_ENTSRVCS Enterprise Services 169 D_ENVMGMT ENVIRONMENTAL MANAGEMENT P405800 170 D_ESG EXPERIMENTAL STUDY GROUP 171 D_EXECVP EXECUTIVE VICE PRESIDENT'S OFFICE 172 D_FACILITIES DEPARTMENT OF FACILITIES 173 D_FLL FOREIGN LANGUAGES & LITERATURE 174 D_FSS FINANCIAL SYSTEMS SERVICES 175 D_HAYSTACK Haystack Observatory 176 D_HISTORY HISTORY 177 D_HR PERSONNEL OFFICE 178 D_HST Harvard-MIT Health Sciences & Technology 179 D_ICAMPUS PROJECT I-CAMPUS P068400 180 D_INSURANCE OFFICE OF INSURANCE P404500 181 D_IPC INDUSTRIAL PERFORMANCE CENTER 182 D_IPCOUNSEL INTELLECTUAL PROPERTY COUNSEL P416000 183 D_ISP INTEGRATED STUDIES PROGRAM 184 D_L&P LINGUISTICS & PHILOSOPHY 185 D_LCS LABORATORY FOR COMPUTER SCIENCE 186 D_LEES LAB FOR ELECTROMAGNETIC & ELECTRICAL SYSTEMS 187 D_LEMELSON LEMELSON-MIT PROJECT P060020 188 D_LFEE LAB FOR ENERGY AND THE ENVIRONMENT P320000 189 D_LFM LEADERS FOR MANUFACTURING 190 D_LFO LINCOLN FISCAL OFFICE 191 D_LIBRARIES Libraries 192 D_LIDS LABORATORY FOR INFORMATION & DECISION SYSTEMS 193 D_LIT LITERATURE 194 D_LMP LABORATORY FOR MANUFACTURING PRODUCTIVITY 195 D_LNS LABORATORY FOR NUCLEAR SCIENCE 196 D_LVA LIST VISUAL ARTS CENTER 197 D_MAGLAB Francis Bitter Magnet Laboratory 198 D_MAS MEDIA ARTS & SCIENCES PROGRAM 199 D_MATHS MATHEMATICS 200 D_MCGOVERN MCGOVERN INSTITUTE FOR BRAIN RESEARCH 201 D_MECHE MECHANICAL ENGINEERING 202 D_MEDIA MEDIA LAB 203 D_MEDICAL MIT MEDICAL DEPARTMENT 204 D_MITCARD MIT CARD OFFICE 205 D_MITES MINORITY INTRO TO ENGINEERING & SCIENCE PROGRAM 206 D_MPC MATERIALS PROCESSING CENTER 207 D_MTA MUSIC & THEATER ARTS 208 D_MTL MICROSYSTEMS TECHNOLOGY LABORATORY 209 D_MUSEUM MIT MUSEUM 210 D_NRL NUCLEAR REACTOR LABORATORY 211 D_NUCENG NUCLEAR ENGINEERING 212 D_OBFP OFFICE OF BUDGET & FINANCIAL PLANNING 213 D_OCEAN OCEAN ENGINEERING 214 D_OME OFFICE OF MINORITY EDUCATION 215 D_ORC OPERATIONS RESEARCH CENTER 216 D_OSP OFFICE OF SPONSORED PROGRAMS 217 D_PARKING PARKING & TRANSPORTATION P405900 218 D_PHYSICS PHYSICS 219 D_PIW DEAN OF ENGINEERING PROGRAM IN WRITING 220 D_PLAN PLANNING OFFICE 221 D_POLICE CAMPUS POLICE 222 D_POLSCI POLITICAL SCIENCE 223 D_PRESHOUSE PRESIDENT'S HOUSE 224 D_PRESIDENT OFFICE OF PRESIDENT / CHAIRMAN P401000 225 D_PRESS MIT PRESS 226 D_PROCURE PROCUREMENT OFFICE 227 D_PROFINST PROFESSIONAL INSTITUTE 228 D_PROPERTY PROPERTY OFFICE 229 D_PROVOST PROVOST'S OFFICE 230 D_PSFC PLASMA SCIENCES & FUSION CENTER 231 D_PWHS PRG WRITING & HUMANISTIC STUDIES P093800 232 D_REG REGISTRAR 233 D_RESDEV Vice President for Resource Development 234 D_RLE Research Lab of Electronics 235 D_RLSLP RESIDENTIAL LIFE & STUDENT LIFE PROGRAMS 236 D_ROTC_AERO ROTC AEROSPACE STUDIES 237 D_ROTC_MIL ROTC MILITARY SCIENCE 238 D_ROTC_NAVAL ROTC NAVAL SCIENCE 239 D_SAFETY SAFETY OFFICE 240 D_SDM SYSTEMS DESIGN & MANAGEMENT 241 D_SEAGRANT SEA GRANT PROGRAM 242 D_SENIOR SENIOR COUNSEL P405700 243 D_SFS STUDENT FINANCIAL SERVICES 244 D_SLOAN SLOAN SCHOOL OF MANAGEMENT 245 D_SMA SINGAPORE/MIT ALLIANCE 246 D_SPEC SPECTROSCOPY LABORATORY 247 D_SSIT STUDENT SERVICES INFORMATION TECHNOLOGY 248 D_STS PROGRAM IN SCIENCE, TECHNOLOGY & SOCIETY 249 D_STUDACT STUDENT ACTIVITIES 250 D_TDP TECHNOLOGY & DEVELOPMENT PROGRAM 251 D_TECHREVIEW TECHNOLOGY REVIEW 252 D_TLL TEACHING AND LEARNING LAB 253 D_TLO Techology Licensing Office 254 D_TPP TECHNOLOGY & POLICY PROGRAM 255 D_TREASURER TREASURER'S OFFICE 256 D_VPFIN VICE PRESIDENT FOR FINANCE 257 D_VPIS VICE PRESIDENT FOR INFORMATION SYSTEMS 258 D_VPRESOFF OFFICE OF THE VICE PRESIDENT OF RESEARCH 259 D_WALLACE WALLACE OBSERVATORY 260 D_WHIT WHITAKER COLLEGE 261 D_UPOP Undergrad Practice Op Prog 262 D_OCW Open CourseWare 273 D_ALL All departments Y 274 D_ASO ADMINISTRATIVE SERVICES ORGANIZATION Y 275 D_CENTRAL CENTRAL OFFICES Y 276 D_DSL DEAN FOR STUDENT LIFE Y 277 D_DUE DEAN FOR UNDERGRADUATE EDUCATION Y 278 D_SCHOOL_ARCH SCHOOL OF ARCHITECTURE & PLANNING Y 279 D_SCHOOL_ENG SCHOOL OF ENGINEERING Y 280 D_SCHOOL_HUM SCHOOL OF HUMANITIES & SOCIAL SCIENCE Y 281 D_SCHOOL_SCI SCHOOL OF SCIENCE Y 282 D_VPRES VP Research & Dean of the Graduate School Y **** Table: FACILITY **** SQL command for getting data from EHS database: select lab_id, lab_code, lab_name, supervisor, supervisor_mit_id, dept_id, ft.facility_type_name, supervisor_kerbname from lab l, facility_type ft where dept_id = 257 and ft.facility_type_id = l.facility_type_id order by lab_id; SUPER SUPER- VISOR VISOR LAB_ID LAB_CODE LAB_NAME SUPERVISOR MIT_ID DEPT_ID FACILITY_TYPE_NAME KERBNAME ------ ---------- --------------------- -------------------- ---------- ------- ------------------ -------- 103 L_VPIS01 W91 Terminal Room ROACH, ROGER A 900022804 257 Laboratory Suite RAR 104 L_VPIS02 N42 Integration Lab SHARARI, MOHAMMAD 900025847 257 Laboratory Suite SHARARI 138 L_VPIS03 W91 Machine Room LAMBERT, DAVID F 900019189 257 Laboratory Suite LAMBERT 159 L_VPIS04 VS1 Lab 2 DOBROVIC, JAMES A 900023096 257 Machine Shop JAD 160 L_VPIS05 OKI Corral THORNE, SCOTT 900007708 257 Laboratory Suite THORNE 236 L_VPIS123 Jim Bruce 10-219 BRUCE, JAMES D 900026402 257 Laboratory Suite JDB 237 L_VPIS124 Jim Bruce 10-256 BRUCE, JAMES D 900026402 257 Laboratory Suite JDB 2072 L_VPIS08 JJV's watchmaker room VENEZIAN, JONATHAN J 900042795 257 Laboratory Suite JJV **** Table: HAZARD_TYPE **** SQL command for getting data from EHS database: select hazard_id, hazard_name from hazard_type; HAZARD_ID HAZARD_NAME ---------- ------------------------ 1 Chemical 2 Large volume oil 3 Blood or body fluids 4 Infectious agents 5 Select agents 6 Radioactive materials 7 Irradiator 8 Generation of X-rays 9 Class III or IV laser 10 High voltage 11 Noise > 85 dB **** Table: REGISTERED_PERSON **** **** Table: PERSON_ROLE **** SQL command for getting data from EHS database: select function_id, 'FACI', l.lab_code, kerberos_name, modified_by, modified_date, 'N' from ehs_role r, lab l where l.lab_id = r.qualifier_id order by function_id, kerberos_name, lab_code; QUAL KERBEROS MODIFIED MODIFIED SELF FUNCTION_ID TYPE QUALIFIER_CODE NAME BY DATE REPORTED ----------- ---- --------------- -------- -------- --------- -------- 1 FACI L_PSFC01 $5A5ZEXC MFULTON 28-JAN-02 N 1 FACI L_VPIS03 FRANX REPA 03-OCT-01 N 1 FACI L_VPIS01 JAD REPA 02-OCT-01 N 1 FACI L_VPIS02 LAMBERT REPA 09-NOV-01 N 1 FACI L_VPIS02 SBJONES REPA 09-NOV-01 N 1 FACI L_VPIS04 TARTAG REPA 22-FEB-02 N 1 FACI L_VPIS08 TARTAG REPA 01-MAR-02 N 1 FACI L_VPIS01 VANNI REPA 02-OCT-01 N 2 FACI L_CL&M01 JELEVIN TIKI 16-NOV-01 N 2 FACI L_VPIS05 MMCGRATH REPA 11-OCT-01 N 2 FACI L_VPIS01 VANNI REPA 03-OCT-01 N 4 FACI L_VPIS05 THORNE REPA 03-OCT-01 N 5 FACI L_VPIS06 CURTISJT REPA 31-JAN-02 N 5 FACI L_VPIS02 MCA REPA 02-OCT-01 N 5 FACI L_VPIS05 MCA REPA 03-OCT-01 N 151 FACI L_VPIS04 MMULLETT REPA 11-OCT-01 N 153 FACI L_VPIS06 CURTISJT REPA 31-JAN-02 N 153 FACI L_VPIS01 JAD REPA 14-FEB-02 N **** Table: PERSON_PLACE **** **** Table: CERTIFICATION_TYPE **** CERT_ID CERT_SHORT_NAME CERT_NAME ------- --------------- -------------------------------------------------- 100 Use of chem. Proper use of chemicals 101 D_CHEM chem. Proper use of chemicals within Dept. of Chemistry 250 Laser use Safe use of class III or IV lasers 880 X-ray safety Proper procedures while Working around X-rays **** Table: WHO_NEEDS_CERT_RULE **** CERT_ID OBJECT_TYPE OBJECT_ID ------- ----------- --------- 100 F 2 100 H 1 101 D 130 250 F 154 880 H 8 **** Table: CERT_TYPE_PRIORITY **** HIGH_PRIO_CERT_ID LOW_PRIO_CERT_ID ----------------- ---------------- 101 100 **** Table: GETTING_CERT_RULE **** CERT_ID OPTION_SET COURSE_EQUIV_ID ------- ----------- --------------- 100 1 1001 100 1 2001 100 2 1002 100 2 2001 101 1 1002 101 1 2001 250 1 3001 250 1 9100 880 1 8010 **** Table: COURSE_OTHER_EQUIV **** COURSE_EQUIV_ID SHORT_NAME LONG_NAME --------------- ----------------- ----------- 1001 Chem Hygiene Chemical Hygiene Training 1002 Special Chem Hyg Dept. of Chemistry special Chemical Hygiene Training 2001 Chem Spills Spill Prevention and Containment 3001 Laser Safety Safe Use of Lasers 8010 X-ray Safety Safely working with and around X-rays 9100 Special Eye Exam Eye Exam Prerequisite for Use of Lasers **** Table: COURSE_OPTION **** COURSE_ COURSE_ EXTERNAL_ COURSE_ OPTION_ID OPTION_TYPE COURSE_OPTION_NAME SHORT_NAME COURSE_CODE EQUIV_ID EXPIRE_DAYS --------- ----------- --------------------------------------- ------------- ----------- -------- ----------- 1001 W Web-based Chemical Hygiene Training Web Chem Hyg NETCAST001 1001 730 1001 L Classroom Chemical Hygiene Training Live Chem Hyg MIT543 1001 730 1002 L Dept. of Chem Chemical Hygiene Training Spec Chem Hyg MIT544 1002 365 2001 W Web: Spill prevention & containment Web SP&C NETCAST002 2001 730 2001 L Classroom: Spill prev. & containment Live SP&C MIT602 2001 730 3001 W Web-based Laser Safety Web Laser NETCAST004 3001 730 3001 L Classroom Laser Safety Live Laser MIT722 3001 730 8010 W Web-based X-ray Safety Web X-ray NETCAST005 8010 365 8010 L Classroom X-ray Safety Live X-ray MIT888 8010 365 9100 O Eye Exam Pre-req. for using lasers Med eye exam N/A 9100 365 **** Table: COMPLETED_COURSE **** **** Table: UNCOMPLETED_COURSE **** **** Table: PERSON_CERT ****