Administrative Users Schema URLs Description
Committees Members ESH Admins
Committee Members
committee Data Entry
App
CVS 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
CVS 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
CVS 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
CVS Dependencies Used to schedule blood drives, eyewear appointments, flu shoots and any ad-hoc appointments.
Frequently Asked Questions faq Data Entry
Report
CVS Dependencies list of FAWs with a standard response. Grouped by category.
Job Functions www_user Data Entry
Report
CVS Dependencies A list of ESH-type jobs functions with a contact information.
MSDS ESH Hygienist msds Data Entry
Report
CVS Dependencies A list of all MSDS onsite. Searchable with scanned copies of the actual data sheet.
Mailing Lists www_user App CVS 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
CVS Dependencies Meta data of all Oracle Developer forms with links to run the form. Grouped by functional areas.
Purchase Requisitions ESH Staff mms App CVS Dependencies records and prints a paper requisition.
Questionnaires ESH Staff qaire Data Entry CVS Dependencies generic routine to develop ad-hock questionnaires.
Self Assessment Documentation System (SADS) ESH Management www_user Data Entry
Report
CVS Dependencies metadata on self assessments.
Leave Requests ESH Staff www_user App CVS 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 CVS Dependencies infrastructure used in all PL/SQL web applications that require authorization.
 
ESHTRK Users Schema Application CodeDependencies Description
Organization Chart ESH Admins
D/S/C ESH Personnel
eshtrk Data Entry
App
CVS Dependencies Oracle forms data entry screen.
frESHTRK D/S/C ESH Personnel eshtrk App CVS Dependencies End-user data entry form. Users enter reviews, findings, responsible parties, etc.
iTrack   eshtrk App CVS Dependencies Management (non-ESH) audits, finding, responsibilities, etc.
Location Chart CS Staff eshtrk Data Entry
App
CVS Dependencies Oracle forms data entry screen.
 
Environmental Protection Users Schema Application CodeDependencies Description
Chemical Waste ESH Environmental Protection wsttrk Data Entry CVS Dependencies Oracle data entry form.
Cooling Water Discharge ESH Environmental Protection cw_discharge Data Entry
App
CVS Dependencies Oracle forms data entry screens and PL/SQL reports.
Excess Chemicals List ESH Environmental Protection www_user Data Entry
App
CVS 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
CVS Dependencies Oracle forms data entry screens.
Samples ESH Environmental Protection samples Data Entry
App
CVS Dependencies Oracle forms data entry screens.
Weather Statistics ESH Environmental Protection weather Data Entry
App
CVS Dependencies statistic and archives gathered from the onsite weather data collection system.
 
Experiments Users Schema Application CodeDependencies Description
Experiment Database Directorate experiment Data Entry
App
CVS Dependencies Oracle forms data entry screens and online reports.
 

Fire Department

Users Schema Application CodeDependencies Description
Daily Logs BSS Fire Department fd_run Data Entry
App
CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Fermilab Run Reports BSS Fire Department fd_run Data Entry
App
CVS Dependencies online reports of Fire Department "runs." (anytime a vehicle is dispatched.)
 
Health & Safety Users Schema Application CodeDependencies Description
Audiometric Database ESH Health & Safety
Medical Department
audiometrics Data Entry
App
CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Beryllium Associated Workers ESH Health & Safety
Medical Department
www_user App CVS 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
CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Ergonomics ESH Health & Safety ergo App CVS Dependencies PL/SQL data entry and reports
Exhaust Survey ESH Health & Safety hs_systems Data Entry
App
CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Industrial Hygiene Assessment ESH Health & Safety ih_plan Data Entry
App
CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Industrial Hygiene Plan ESH Health & Safety ih_plan Data Entry
App
CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Industrial Hygiene Samples ESH Health & Safety ih_sample Data Entry
App
CVS 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
CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Laser Database ESH Health & Safety laser Data Entry
App
CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Lessons Learned Upper Management fnal_ll App CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Material Safety Data Sheets ESH Health & Safety
Lab Personnel
msds Data Entry
App
CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Respirators ESH Health & Safety
BSS Fire Department
hs_systems Data Entry
App
CVS Dependencies Oracle forms data entry screens and PL/SQL reports
SSO Information Center Senior Safety Officers oii, eshtrk, train App CVS Dependencies dashboard-type application for SSOs.
Work Permit Notification Form D/S/C ESH Personnel wpnf Data Entry
App
CVS Dependencies Data entry, workflow and tracking of ESH-related work permits.
 
FESHComm Users Schema Application CodeDependencies Description
Home Page Lab Personnel
Upper Management
ESH Management
www_user App CVS Dependencies Main page with links and charts.
Leading/Lagging Indicators Lab Personnel
Upper Management
ESH Management
fnal_indicator App CVS Dependencies Oracle forms data entry screens and PL/SQL reports of various metrics.
 
Medical Users Schema Application CodeDependencies Description
CDL Card Generator Medical Department www_user App CVS Dependencies generates a commercial drivers license form.
Daily Logs Medical Department medical App CVS Dependencies activity logging and reporting.
Document Management Medical Department medical Data Entry
App
CVS 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   CVS Dependencies Nightly batch send invitations for Health Risk Assessments (HRAs).
Random Drug Test Generator Medical Department www_user App CVS Dependencies randomly generates a sample of firefighters and persons with CDL for drug screening.
Record Patient Visit Medical Department medical App CVS Dependencies log of HRAs and medical qualifications.
Records Storage Boxes Medical Department   App CVS Dependencies log of offsite storage boxes and their content.
 
Radiation Protection Users Schema Application CodeDependencies Description
Sources Radiation Protection rps_source Data Entry
Reports
CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Uranium Radiation Protection rps_uranium Data Entry
Reports
CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Dosimetry TLDs Radiation Protection exposures Apps CVS Dependencies (a.k.a. TLD, Rad. Badges) online request form
Dosimetry Exposures Radiation Protection exposures Apps CVS Dependencies (a.k.a. TLD, Rad. Badges) quarterly processing of new badges and yearly DOE reporting.
 
Security Department Users Schema Application CodeDependencies Description
Case Reports Log Security Department security Data Entry CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Daily Logs (Blotter) Security Department security Data Entry CVS Oracle forms data entry screens and PL/SQL reports
Emergency Call List Security Department
Upper Management
security Data Entry CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Incident Database Security Department security Data Entry CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Key & Lock Database Security Department security Data Entry CVS Dependencies Oracle forms data entry screens and PL/SQL reports
Site Access Visitor Request Form Security Department site_access App CVS Dependencies online app to allow users to request visitor badges.
Vehicle Stickers, RF Tags, Secards Security Department security Data Entry CVS Oracle forms data entry screens and PL/SQL reports
Violations (Parking & Moving) Security Department
Upper Management
security Data Entry CVS 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 Application CodeDependencies Description
Main Application All personnel train Data Entry CVS Dependencies core TRAIN applications consisting of  Oracle forms data entry screens and PL/SQL reports
ITNA All personnel itna Data Entry CVS Dependencies subsystem within TRAIN to set a person's individual training plan based on a questionnaire.
ESH Tests All personnel esh_test App CVS Dependencies online tests that give credit for training courses.