Skip to Content

University Registrar

Data Warehouse Catalog and Schedule Reports

Discover answers to frequently asked questions related to Catalog and Schedule reports.

Frequently Asked Questions

View the New Schedule Coordinator tab on our General Information web page for full details on obtaining access to Data Warehouse.

Google Chrome

Complete these steps once and you won’t have to do it it again.  

  • Log in to Data Warehouse.
  • Click on the Open Menu icon located in the upper left corner of the page.
  • Choose the Content folder, then select the Team Content tab.
  • Click the USC Banner Reporting folder twice.
  • This will allow you to view the USC Banner Reporting folders including content related to the Registrar's Office.
  • Click the Personal Menu icon located in the upper right corner of the web page, then choose the Profile and Settings option.
  • Click on the Settings tab, then choose the Set home as (current view) option.
  • Now every time you log in you will see the USC Banner Reporting menu automatically. 

If you prefer for all reports to run in Excel, follow these steps:

  • Log in to Data Warehouse.

  • Click the Personal Menu icon located in the upper right corner of the web page, then choose the Profile and Settings option.

  • Click on the Settings tab, then change the Report Format dropdown menu to the Excel option.

  • Choose My Preferences.  

  • Set Report Format to Excel.  

  • Click the person icon on the top navigation bar to hide it.

  • Now all reports will run in Excel.

If you prefer for your reports to default to Excel, but want to occasionally choose another format, go to the report you are running (ex. Schedule Details) and click the small blue right arrow. This will provide you with format options.

Remember that the fewer options you choose, the more data you will get.  For example, choose term = 202301, campus = COL, and subject code.  This will guarantee you will get all of your sections for that subject code. 

If you don’t want to wait and watch the report spin (like waiting for water to boil), click Select Delivery Method, then choose Email Report and have it emailed to yourself.  You can edit the subject line so that later you will remember why you ran the report. 

  • When the report opens in Excel, click Enable Editing, then select the entire sheet by clicking the box to the left of column A and above row 1.

  • With the entire sheet selected, click the dropdown arrow to the right of Merge & Center.   Choose Unmerge Cells.

  • If row 1 is blank remove it so that sorting will be easier.  Click  row 1 to select the entire row. Right click in the row and choose Delete.

  • Again, select the entire sheet and sort by anything – perhaps SUBJ, CRSE, SECTION.  This will remove any blank rows you may have from the unmerge step.

  • Deleting Columns vs. Hiding Columns – if you are absolutely certain you won’t need the column, delete it.  If there is a chance you might need it, hide it by selecting the entire column by clicking the alpha character at the top of the column, right click in the column, choose Hide. For example, if you hide column ‘D’ and then find that you need to add it back, click columns C and E, right click in either and choose Unhide.

  • Naming Your File - Use the date in the filename.  For example, filename 2023‐01-19_Sch_Det_ANTH allows you to see exactly what day the report was run and which subject code was included.

  • Additions: If a new section is to be added, give us the info we need in the appropriate columns and type ADD in the CRN field and highlight only the CRN cell in green

  • Changes:  If the section is perfect as it is, remove the row.  We do not need to see sections that we are perfect. If the section needs some tweaking, highlight in yellow the CRN cell and only the cells in which the data is changing. You will also put the correct information in the highlighted cells. This will help us look just where we need to rather than looking for the proverbial needle in a haystack.

  • Cancellations:  If the section is to be canceled, highlight the CRN red.


Challenge the conventional. Create the exceptional. No Limits.