Insert Student Attribute

Overview

The Insert Student Attribute (SOU_INSERT_STUDENT_ATTRIBUTE) job enables authorized users to assign a parameter student attribute to a list of students identified by a text file of student IDs.

Begin by creating a file with your student IDs in position 1-9. Give the file name a “.csv” extension, e.g., myfilename.csv. If you are using Excel, you will need to save the file as a csv file.  Then use the File Upload Utility to upload your file to the “Dat” directory.

Once you have successfully uploaded your file, run the Insert Student Attribute (SOU_INSERT_STUDENT_ATTRIBUTE) job.  The job has 3 parameters:

1. Term Code Effective
2. Student Attribute Code
3. File Name (no extension).  Enter the name of your file without the extension (i.e, “myfilename” not “myfilename.csv”.

You can obtain lists of students with a parameter attribute for a parameter term by running the Students with Attribute (ECP_STUDENTS_WITH_ATTR) program.

---

Accessing the Job Using Search

1. Log into Banner.
2. Start Typing “sou_insert” into the Search box on the main Welcome screen.
3. This will pull up a list of items that have “sou_insert” in the name. Select SOU_INSERT_STUDENT_ATTRIBUTE from the list.

---

Running the Job

To run the job, you first need to set up the required parameters. The Process Submissions Control page (GJAPCTL) is used to enter parameters for jobs.

Key Section (Page 1 – Section 1):

The Key block specifies which report you are running.

Enter the following information:

• Process: Process will be pre-populated. If it is blank or has the wrong job, enter SOU_INSERT_STUDENT_ATTRIBUTE.
• Parameter Set: Enter the name for the set of parameters you wish to use if you have saved a set of parameters previously. Otherwise, leave blank.

Click on the Go button to move to the Printer Control section.

Printer Control Section (Page 1 – Section 2):

The Printer Control section allows you to choose which printer to use, the number of lines to print per page, and the time to submit the job.

Enter the following information:

• Printer: Enter the printer code for where you want the report to print.  Press F9 or click the button with a caption of “…” on the right side of the text box to get a list of valid values.  If you do not see your department print queue listed, call our Faculty & Staff Help Desk for assistance.  If you would like to review the report online, enter DATABASE in the printer field. If you would like to have the report sent to your BannerFiles folder in your personal Box drive, enter SFTP in the printer field.
• Special Print: Leave this field empty.
• Number of Lines: Enter the number of lines per page you wish to print or use the default already entered. Note: If you choose a larger number of lines than will fit on the page, the transcript will not print properly. We recommend this value is left blank.
• Submit Time: Leave the value blank if you wish report to run immediately. If you wish the job to run at a later time, enter the time in military format (i.e., 23:00 for 11:00 PM).

Use the mouse to click into the Parameter Values section.

Parameter Values Section (Page 1 – Section 3):

The Parameter Values section displays a list of parameters used by the job. As you cursor through each parameter, help text about the parameter is displayed underneath the list of parameters at the bottom of the Parameter Values section. Click on the Search icon for the Values field to see a list of valid values if one is available.

Enter the following information:

• Term Code Effective: Enter the term the attribute should be effective.
• Attribute Code: Enter the attribute code to be inserted.
• File Name: Enter the name of your file without the .csv extension, e.g. enter “mystudentids” not “mystudentids.csv.”  The name should not have embedded spaces or special characters other than “_.”

Use the mouse or down and up arrow keys to cursor through the records. After entering your parameter values, use the mouse to click into the Submission Section.

Submission Section (Page 1 – Section 4):

The Submission block allows you to save your parameters for future use and to submit the report.

Enter the following information:

• Save Parameter Set as: If you wish to save the parameters to use again, check this box. Note: We recommend you do not save your parameters for the student schedule report.
• Name: If you have checked the Save Parameter Set as box, enter a name for the parameter set. If you did not check the Save Parameter Set as box, leave Name blank.
• Description: If you have checked the Save Parameter Set as box, enter a description for the parameter set. If you did not check the Save Parameter Set as box, leave Description blank.
• Hold/Submit: Select the Submit radio button.

Click on the Save button in the bottom right corner of the page to submit your job.