In Banner go to GWLADMN
Enter "DATABASE" in the Printer field.
Parameters & Values:
01: Letter Name Click the "Values" button and select the appropriate population.
02: Registration Term Code The term code for the first semester the students are registered
03: Admit From Date The first date from which a student is admitted.
04: Admit To Date The last date in the range from which a student is admitted
05: File Extension CSV
06: Major Enter Major Code or click "Values" and select from the list presented. (only majors beginning with * are valid)
20: Application Term Code The term code for the term the student applied.
21: Update Mail Table N
22: Phone Type Leave Blank (unless a specific phone type is needed)
23: Attribute Code Enter an attribute to limit population or leave blank.
Open Excel on your computer.
Click Open and navigate to your U drive folder
Click on Banjobs in your U drive folder
In the drop down to the right of the File Name field at the bottom of the Open window change
"All Excel Files" to
Select the file named for the letter you chose in parameter 1 (usually ADM_ALL_ADMITS_) followed by the date the report was run in the mmddyy format.
After you click the file a window will appear asking your to "Choose the file type that best describes your data:"
Click the "Delimited" button
Click the "Comma" button
Your data will appear in Excel.