Administrative Users Schema URLs Description
Committees Members ESH Admins
Committee Members
committee Data Entry
App
Dependencies List of FESHCom committee members and all subcommittees plus their members. Contains workflow for membership appointments, renewals and expirations.
DOE Logs and Routine Items ESH Admins esh_admin Data Entry
Calendar
Dependencies Used by the ESH Admin staff as a reminder to perform certain routine tasks.
ES&H Manuals & Draft Reviews ESH Admins
Manual Authors
drafts Data Entry
Drafts
Dependencies A list of all manuals. Contains workflow to reminder responsible persons to review the manuals for necessary updates. Also includes CS-related manuals such as Computer Security and Computer policies.
Event Scheduler ESH Admins event Data Entry
Online App
Dependencies Used to schedule blood drives, eyewear appointments, flu shoots and any ad-hoc appointments.
Frequently Asked Questions   faq Data Entry
Report
Dependencies list of FAWs with a standard response. Grouped by category.
Job Functions   www_user Data Entry
Report
Dependencies A list of ESH-type jobs functions with a contact information.
MSDS ESH Hygienist msds Data Entry
Report
Dependencies A list of all MSDS onsite. Searchable with scanned copies of the actual data sheet.
Mailing Lists   www_user App Dependencies allows a person to subscribe to an ESH mailing list without knowing the command syntax of the list server.
Oracle Forms Developers www_user Data Entry
App
Dependencies
Purchase Requisitions ESH Staff mms App Dependencies records and prints a paper requisition.
Questionnaires ESH Staff qaire Data Entry Dependencies generic routine to develop ad-hock questionnaires.
Self Assessment Documentation System (SADS) ESH Management www_user Data Entry
Report
Dependencies metadata on self assessments.
Leave Requests ESH Staff www_user App Dependencies Form generates email to supervisors for leave. If business leave is requested, data is captured and section head is included in the workflow. Note: you must be in the ESH organization chart for the App to work; otherwise, a blank screen is displayed.
Application Privilege Assignment & Maintenance ESH Admins app_privs App Dependencies infrastructure used in all PL/SQL web applications that require authorization.
 
ESHTRK Users Schema URLs Description
Organization Chart ESH Admins
D/S/C ESH Personnel
eshtrk Data Entry
App
Dependencies Oracle forms data entry screen.
frESHTRK D/S/C ESH Personnel eshtrk App Dependencies End-user data entry form. Users enter reviews, findings, responsible parties, etc.
iTrack   eshtrk App Dependencies Management (non-ESH) audits, finding, responsibilities, etc.
Location Chart CS Staff eshtrk Data Entry
App
Dependencies Oracle forms data entry screen.
 
Environmental Protection Users Schema URLs Description
Chemical Waste ESH Environmental Protection wsttrk Data Entry Dependencies Oracle data entry form.
Cooling Water Discharge ESH Environmental Protection cw_discharge Data Entry
App
Dependencies Oracle forms data entry screens and PL/SQL reports.
Excess Chemicals List ESH Environmental Protection www_user Data Entry
App
Dependencies safety officers post excess items, which is then sent to an email distribution list with the goal of reuse of chemical.
Rad. Waste ESH Environmental Protection radwaste Data Entry
Dependencies Oracle forms data entry screens.
Samples ESH Environmental Protection samples Data Entry
App
Dependencies Oracle forms data entry screens.
Weather Statistics ESH Environmental Protection weather Data Entry
App
Dependencies statistic and archives gathered from the onsite weather data collection system.
 
Experiments Users Schema URLs Description
Experiment Database Directorate experiment Data Entry
App
Dependencies Oracle forms data entry screens and online reports.
 

Fire Department

Users Schema URLs Description
Daily Logs BSS Fire Department fd_run Data Entry
App
Dependencies Oracle forms data entry screens and PL/SQL reports
Fermilab Run Reports BSS Fire Department fd_run Data Entry
App
Dependencies online reports of Fire Department "runs." (anytime a vehicle is dispatched.)
 
Health & Safety Users Schema URLs Description
Audiometric Database ESH Health & Safety
Medical Department
audiometrics Data Entry
App
Dependencies Oracle forms data entry screens and PL/SQL reports
Beryllium Associated Workers ESH Health & Safety
Medical Department
www_user App Dependencies questionnaire to determine if a worker should be part of the beryllium associated workers list.
Confined Spaces ESH Health & Safety hs_systems Data Entry
App
Dependencies Oracle forms data entry screens and PL/SQL reports
Ergonomics ESH Health & Safety ergo App Dependencies PL/SQL data entry and reports
Exhaust Survey ESH Health & Safety hs_systems Data Entry
App
Dependencies Oracle forms data entry screens and PL/SQL reports
Industrial Hygiene Assessment ESH Health & Safety ih_plan Data Entry
App
Dependencies Oracle forms data entry screens and PL/SQL reports
Industrial Hygiene Plan ESH Health & Safety ih_plan Data Entry
App
Dependencies Oracle forms data entry screens and PL/SQL reports
Industrial Hygiene Samples ESH Health & Safety ih_sample Data Entry
App
Dependencies Oracle forms data entry screens and PL/SQL reports
Injury/Illness/CAIRS ESH Health & Safety
D/S/C Accident Investigators
oii & cairs Data Entry
App
Dependencies Oracle forms data entry screens and PL/SQL reports
Laser Database ESH Health & Safety laser Data Entry
App
Dependencies Oracle forms data entry screens and PL/SQL reports
Lessons Learned Upper Management fnal_ll App Dependencies Oracle forms data entry screens and PL/SQL reports
Material Safety Data Sheets ESH Health & Safety
Lab Personnel
msds Data Entry
App
Dependencies Oracle forms data entry screens and PL/SQL reports
Respirators ESH Health & Safety
BSS Fire Department
hs_systems Data Entry
App
Dependencies Oracle forms data entry screens and PL/SQL reports
SSO Information Center Senior Safety Officers oii, eshtrk, train App Dependencies dashboard-type application for SSOs.
Work Permit Notification Form D/S/C ESH Personnel wpnf Data Entry
App
Dependencies Data entry, workflow and tracking of ESH-related work permits.
 
FESHComm Users Schema URLs Description
Home Page Lab Personnel
Upper Management
ESH Management
www_user App Dependencies Main page with links and charts.
Leading/Lagging Indicators Lab Personnel
Upper Management
ESH Management
fnal_indicator App Dependencies Oracle forms data entry screens and PL/SQL reports of various metrics.
 
Medical Users Schema URLs Description
CDL Card Generator Medical Department www_user App Dependencies generates a commercial drivers license form.
Daily Logs Medical Department medical App Dependencies activity logging and reporting.
Document Management Medical Department medical Data Entry
App
Dependencies processes scanned images, records meta data and provides reports.
Note: data entry and document access is restricted to medical personnel via Apache on medical web server.
HRA Appointment Generator Medical Department medical   Dependencies Nightly batch send invitations for Health Risk Assessments (HRAs).
Random Drug Test Generator Medical Department www_user App Dependencies randomly generates a sample of firefighters and persons with CDL for drug screening.
Record Patient Visit Medical Department medical App Dependencies log of HRAs and medical qualifications.
Records Storage Boxes Medical Department   App Dependencies log of offsite storage boxes and their content.
 
Radiation Protection Users Schema URLs Description
Sources Radiation Protection rps_source Data Entry
Reports
Dependencies Oracle forms data entry screens and PL/SQL reports
Uranium Radiation Protection rps_uranium Data Entry
Reports
Dependencies Oracle forms data entry screens and PL/SQL reports
Dosimetry TLDs Radiation Protection exposures Apps Dependencies (a.k.a. TLD, Rad. Badges) online request form
Dosimetry Exposures Radiation Protection exposures Apps Dependencies (a.k.a. TLD, Rad. Badges) quarterly processing of new badges and yearly DOE reporting.
 
Security Department Users Schema URLs Description
Alarm Log Security Department
Fire Technicians
sec_alarm Data Entry Dependencies Oracle PL/SQL daily alarm testing log.
Case Reports Log Security Department security Data Entry Dependencies Oracle forms data entry screens and PL/SQL reports
Daily Logs (Blotter) Security Department security Data Entry Oracle forms data entry screens and PL/SQL reports
Emergency Call List Security Department
Upper Management
D/S Safety Officers
ecl Data Entry Dependencies PL/SQL data entry screens and PL/SQL reports
Incident Database Security Department security Data Entry Dependencies Oracle forms data entry screens and PL/SQL reports
Key & Lock Database Security Department security Data Entry Dependencies Oracle forms data entry screens and PL/SQL reports
Site Access Visitor Request Form Security Department site_access App Dependencies online app to allow users to request visitor badges.
Vehicle Stickers, RF Tags, Secards Security Department security Data Entry Oracle forms data entry screens and PL/SQL reports
Violations (Parking & Moving) Security Department
Upper Management
security Data Entry Dependencies
Dependencies
Oracle forms data entry screens and PL/SQL reports with workflow that sends emails to violators, supervisors, ESH contacts, D/S/C heads and potentially directorate.
 
TRAIN Users Schema URLs Description
Main Application All personnel train Data Entry Dependencies core TRAIN applications consisting of  Oracle forms data entry screens and PL/SQL reports
ITNA All personnel itna Data Entry Dependencies subsystem within TRAIN to set a person's individual training plan based on a questionnaire.
ESH Tests All personnel esh_test App Dependencies online tests that give credit for training courses.