Download This Report into Excel

This report is designed for departments to get information related to PCC's Deletion for Non-Payment (DNP) process. SWRDNPT provides information about students and classes BEFORE the deletion deadline takes effect for each term. It can be run the Tuesday prior to the start of term to identify courses where students are subject to deletion. In contrast, the report SWRDNPS is used to get information about students AFTER the deletion deadline.

When created in "Summary" mode, the report serves as a useful enrollment management tool for deans and department chairs to determine course sections that are at risk of cancellation due to student deletions. It may also be run in "Detail" mode to provide contact information about students who are subject to deletion.

Please note that students who are on the waitlist for classes may also be subject to deletion, so the numbers shown on the completed SWRDNPT report should only be used as an indication of potential enrollment.

Directions:
  1.  From the Banner Main Menu, type SWRDNPT, then press Enter on your keyboard..

  2. Click the Go button.

  3. Click the Next Section  icon. 
    (Or, just click with your mouse in the "Parameter Values" section as shown in the picture below.)
    This will move your curser to the "Parameter Values" section.

 

     4. On the right side (in the "Values" column) type in the information needed to specify the details of your report. Use the following table as a guide for what to type:

Parameter

What to Type

01 Term CodeThe academic Term -- for example, 201203 for Summer 2012.
02 Campus CodeRequired -- The course Campus Code for the campus you want.

1 = Sylvania

2 = Cascade

3 = Rock Creek

4 = SE Campus

(Note: Until Spring 2015, '4' was used to designate the 'Extended Learning Campus', which included SE Campus as well as Workforce and Community Education classes)

W = Workforce and Community Education (from Summer 2015 to the present)

5 = Contract Out of District

6 = Education Services

7 = Tillamook Bay

8 = Columbia Gorge

If you don't want to narrow your report down based on campus, use "%" for all. (Usually the best choice.)

03 Attendance MethodOptional, but recommended -- The Attendance Method code associated with your department's classes  -- for example, N4 for PCC Prep Alternative Programs.

If you don't want to narrow your report down based on Attendance Method, use "%" for all.

04 Organization CodeYour department's Orgn. Code (budget code).

If you don't want to narrow your report down based on Organization Code, use "%" for all.

05 Subject CodeThe Subject Code (like BI for Biology classes). 

If you don't want to narrow your report down based on subject code, use "%" for all.

06 Fund CodeThe Fund Code associated with your department budget.

If you don't want to narrow your report down based on Fund Code, use "%" for all.

07 Program CodeThe Program Code associated with your department budget.

If you don't want to narrow your report down based on Program Code, use "%" for all.

08 Sort OrderThe sort order for the items listed on your report.

O = by Orgn. Code; A = By Attendance Method; S = by course Subject; P = by Program Code.

09 Print Student Detail

Required -- Indicate what you want for your report:

Y = Yes to student detail -- provides a list of students who will be deleted, with G Numbers and Phone Numbers

N = No to student detail -- provides a list of CLASSES that will be affected by student deletions for non-payment, and the estimated financial impact for each class.

10 CRN

Optional -- Indicate the CRN, if you are only running this report for one CRN.

 

11 Student Level NC/CRThe Level Code associated with students enrolled in the classes specified.

NC = non-credit students; CR = credit students.

12 CohortThe Cohort Code, if your program is set up to use these codes.

If you don't want to narrow your report down based on Cohort Code, use "%" for all.

      5. When you are finished completing the above parameters, click the Next  Section icon.

      6. Click the Save button.

              (For more information about saving reports, including saving your parameters for a future time, see the Banner Report Help page.)

      7. Open Report Viewer and view your report.

 


Two files are created for this report. The file name that ends with .csv is the report you will need for downloading. (The report with ".lis" at the end can be viewed and/or printed in Report Viewer.)

 
Downloading This Report into Excel
  1. In Banner Report Viewer, look for the version of the completed report ending with ".csv." Click on the blue dot on the far right of the line:

                                                           

      2. IF you are given the option to "Save As" and save it in a specific location, save it somewhere you will remember (such as your Desktop) with a name you can remember.

      3. Open a blank Excel spreadsheet.

      4. Click on the 'Data' tab.

     5. On the Data tab, look for icons on the upper left that have to do with "getting external data." Click on the "From Text" icon.

    • If you have Word 2007, instead look for the "Get External Data" iconand select "as text."

      6. When prompted, find and select the file you saved earlier (in step 1-2 above).

       The Text Import Wizard will open up.

      7. Press Next.

      8. On step 2 of the Text Import Wizard, you will be asked to specify what character is the "delimiter" of your data. Click the "other" checkbox and type in the carat symbol (^) as a "delimiter."

      9. Click "Finish"

 

          Make sure to SAVE AS an excel workbook.
 

 

Banner Tip:

Create and Save Two Versions of This Report for Future Terms

You can save the parameters you typed for the next time you need to run this report.. In fact, we recommend that you save and name the parameters of this report TWICE -- once in "Detail" mode (Parameter 08 = Y) and another time in "Summary" mode (Parameter 08 = N).

 

Refer to "Three Ways to Save a Banner Report," Option Three for more details.

 

Other Resources