eResearch / ITS Documentation

eRAM: Record a Missing Cage or Animal on an Animal Treatment Report (ATR)

Overview This document details the process used by ATR/EMR Staff with an ATR Veterinary role to record a missing cage or animal on an Animal Treatment Report (ATR) in eRAM.

eRAM: Record a New Animal Treatment Report (ATR) Visit

Overview This document details the process used by ATR/EMR Staff with an ATR Veterinary role to pick up and record a new visit on an Animal Treatment Report (ATR) in eRAM. Important This activity should only be used when an entire new visit is being recorded. To edit the same visit, use the Update Current ATR Visit activity.

eRAM: Reformatting Cells for Custom Search Reports in Excel

Overview When exporting some Custom Search Reports as an Excel spreadsheet, you may find it necessary to reformat cells that don’t correctly separate data with a delimiter (e.g., a comma, semicolon or colon). This procedure demonstrates how to reformat data in these cells to include a delimiter. The following formula can be used to reformat cell data with a delimiter: =SUBSTITUTE(SUBSTITUTE(E2,CHAR(13),””),CHAR(10),”,”)

eRAM: Request Breeding Sheets

Breeding Sheets are used to track animals that were bred in a lab. PIs/Lab Personnel can request Breeding Sheets from an approved protocol’s workspace.

eRAM: Request or Maintain ABSL 2 Exemptions

Overview For procedures with Human Derived substances, ABSL 2 housing is required unless an exemption is approved for ABSL 1. Exemptions are granted at the individual substance level; see the U-M Guidance for Animals Administered Human-Derived Substances page for further explanation.

eRAM: Request Quick Cards

Overview Quick Cards are used for tracking animals that were not bred or ordered. PIs/Lab Personnel will usually request Quick Cards from an active USE form workspace (other than Shipping Form – Export). Quick Cards can also be requested from an approved protocol’s workspace.

eRAM: Request USDA Information

Overview Animal Care and Use Office (ACUO) RCAs can submit a USDA Information Request for PI/Lab Personnel to complete on a protocols that are in a state of Approved, Canceled, Expired, or Suspended. The PI/Lab Personnel will get an email alerting them to take action.

eResearch