Preserve Banner Data for preservation notice

  1. Run findpidm.shl
    1. Enter PIDM
    2. Enter password for OAKDBA
  2. Copy foundpidm_<PIDM>.sql to SQL Developer.

  3. Add "set echo on linesize 300 pagesize 9999" to top of file.
  4. Run entire file as script.
  5. Save output to \\admnet.oakland.edu\University_Technology_Services\utsdocs\preservation\<name>\<name>_banner_data_preservation.txt