Student Data Extract by Attribute

Overview

Student Data Extract by Attribute program, located in the Basis Jobs Menu, creates a comma/quote delimited text file with a record for each student who meets the selection criteria. The selection criteria include term code, student attribute code and CRN. The program produces an extract file of demographic and academic data. The data is intended to be loaded into a spreadsheet, and the first row in the extract file contains descriptive column headings.

The program selects all students who have an effective student record for the term code parameter, have an effective student attribute for the term code parameter and attribute parameter, have not graduated prior to the term code parameter in the program on their current student record and are enrolled in the CRN parameter for the parameter term. If "%" is supplied in the CRN parameter the program will select all students who meet the other selection criteria and have been enrolled at any time since 8 terms prior to the parameter term or the parameter term itself.

Accessing the Report

You may access the Report using Direct Access or the Reports menu. When you select the Section Tally report, the Process Submissions Control form (GJAPCTL) will display so that you may enter the parameters required to run the report.

Accessing the Report Using Direct Access

Running the Report

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

Key Block (Page 1 - Block 1):

The Key block specifies which report you are running. It will be pre-populated with the Student DATA Extract report (FAC_EXTR_BY_ATTR).

Enter the following information:

Process: Process will be pre-populated with the report. If it is blank or has the wrong report, enter FAC_EXTR_BY_ATTR.

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.

Choose Block/Next from the menu bar to move to the Printer Control block or use the mouse to click into the block.

Printer Control Block (Page 1 - Block 2):

The Printer Control block 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 report to print. Choose Help/List from the menu bar for valid printer codes. If you do not see your department print queue listed, call our Faculty & Staff Help Desk for assistance. If you would like to review this report online, enter DATABASE in the printer field.

Special Print: Leave the value blank.

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, your report 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 report to run at a later time, enter the time in military format (i.e., 23:00 for 11:00 PM).

Choose Block/Next from the menu bar to move to the Parameter Values block or use the mouse to click into the block.

Parameter Values Block (Page 1 - Block 3):

The Parameter Values block displays a list of parameters used to create the report. 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 block. 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: Enter the 6 digit term code and press [Enter]. If you are unsure of the correct term code, you may look it up in Banner using the Term Code Validation Form (STVTERM).

Attribute Code: Enter the student attribute code and press [Enter]. If you are unsure of the correct code for your attribute, you may look it up in Banner using the Student Attribute Validation Form (STVATTS).

CRN: Enter the CRN (% - All) and press [Enter]. If you are unsure of the correct CRN for your course/section, you may look it up in Banner using the Schedule Section Query Form (SSASECQ).

Use the vertical scrollbar or down and up arrow keys to cursor through the records. After entering your parameter values, choose Block/Next from the menu bar to move to the Submission block or use the mouse to click into the block.

Submission Block (Page 1 - Block 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.

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.

Choose File/Save from the menu bar to submit your job. The report should print or be available online within a few minutes.