PESC Subtest EDI Definitions

Important

Information and features vary according to the roles to which you belong and the permissions associated with those roles. For more information, contact your module manager or your campus support team.

Note

This page is related to electronic transcripts (EDI and XML). If your school generates only paper and/or PDF transcripts, you can ignore this page.

Use this page to manage PESC Subtest EDI definitions. You can make definitions active and inactive, and you can set whether they appear in drop-downs and in what order.

PESC is the Postsecondary Electronic Standards Council, which works at standardizing electronic transcripts. EDI is one of the electronic transcript formats.

Tests and subtests refer to standardized tests such as SAT and ACT.

Desktop Location

You can manage the definitions in Desktop, too, on the PESC Subtest EDI Definition window. Changes you make in Desktop also apply to J1 Web, and vice versa.

Database Location

The definitions are stored on the PESC Subtest EDI Code Definition table (pesc_subtest_edi_code_def).

Where PESC Subtest EDI Definitions Are Used

The definitions are used in the PESC EDI Code drop-down on the Edit Test Elements window in Desktop (and planned for a future release of J1 Web). The selected value is stored on the Test Definition table (test_definition.pesc_subtest_edi_code_def_appid).

Fields

All fields are required.

Test Code: Selected from PESC Test EDI definitions (pesc_test_edi_code_def). The test's code and description appear here.
Code: Up to 5 characters. Code and description appear in drop-downs.
Description: Up to 60 characters. Code and description appear in drop-downs.
Active: Set to Yes by default. An inactive definition can be included in drop-downs or not.
Display in Drop-Down: Always Yes if Active is Yes. If Active is No, you can set this to No. If Active is No but Display in Drop-Down is Yes, the value appears in drop-downs but is marked inactive.

Permissions

Permission to manage PESC Subtest EDI definitions is available in these roles:

Registrar
Registration Module Manager

The permission required is "Can manage PESC subtest EDI definitions".

How To

View PESC Subtest EDI Definitions

From the Registration Administration hub, click Hub options.
Click Manage Definitions, and select PESC subtest EDI definitions. The PESC Subtest EDI Definitions page opens.
To filter the definitions, enter a phrase in the Quick Filters field. To remove a filter, click its Remove icon .
To temporarily sort the definitions, click the heading of the column you want to sort on. Click once for ascending order and again for descending order. The definitions are sorted for this viewing of the page, but the next time you view or refresh the page, it will return to its default sorting.
If the Expand icon is there, click it to see hidden columns.

Manage Drop-Down Display and Priority of Definition

The Edit Order options let you set the order of definitions in drop-down menus and how they are prioritized when used.

In the Edit Order window, change the order using either the Sort By and Order drop-down menus or the drag and drop option.
1. Sort By and Order:
  1. From the Sort By drop-down, select the column you want to sort by.
  2. From the Order drop-down menu, select Ascending or Descending.
2. Drag and drop:
  1. Hold your cursor over the arrow icon on the left side of the row until the cursor changes to a hand icon .
  2. Click and hold while you drag the definition to the new location.
  3. Release the mouse button.
Click Update.

After you click Update, your changes are saved in the following ways:

The definitions are listed in the saved order whenever they appear in drop-down menus (where a user selects from the list of definitions).
If the definitions are used in calculations or rules where priority matters, the definitions are now in your saved order of priority.
The definitions page is now sorted according to your changes.

Create PESC Subtest EDI Definitions

All fields are required. The combination of Test Code, Code, and Description must be unique.

Click the Create definitions button. The Create PESC Subtest EDI Definitions pop-up appears.
Select a Test Code (as defined on the PESC Test EDI Definitions page)
Enter a Code. Up to 5 characters. Code and Description appear in drop-downs.
Enter a Description. Up to 60 characters. Code and Description appear in drop-downs.
Active is set to Yes by default, but you can select No.
Display in Drop-Down: is editable only if Active is set to No.
1. If you set Display in Drop-Down to No, the definition doesn't appear in drop-downs.
2. If Active is No but Display in Drop-Down is Yes, the value appears in drop-downs but is marked inactive.
Click Create and close or Save and create another.

Edit a PESC Subtest EDI Definition

All fields are required. The combination of Test Code, Code, and Description must be unique.

Click the Edit icon on the row of a definition. The Edit PESC Subtest EDI Definition pop-up appears.
You can edit the Description. Up to 60 characters.
In the Active drop-down, you can change from No to Yes or vice versa.
Display in Drop-Down: is editable only if Active is set to No.
1. If you set Display in Drop-Down to No, the definition doesn't appear in drop-downs.
2. If Active is No but Display in Drop-Down is Yes, the value appears in drop-downs but is marked inactive.
Click the Update button.

Delete PESC Subtest EDI Definitions

Select the checkbox next to each definition you want to delete.
Select Delete from the Options drop-down. The Delete Definitions? pop-up opens.
The Delete Definitions? pop-up lists the selected definitions in two categories:
- Ready to Delete: Definitions that can be deleted.
- Unable to Delete: Definitions that can't be deleted, either because they're in use or are protected by the system.
If you decide not to delete one or more of the definitions listed under Ready to Delete, click the Remove icon to remove them from the list.
When you're sure you want to delete all the rows listed under Ready to Delete, click Yes, delete.

Download PESC Subtest EDI Definitions

Download to Excel

Select the checkboxes next to the rows you want to export.
From the Options drop-down, select Download to Excel. The Download to Excel pop-up opens.
Select options for the Excel format and data columns.
sidebar. Download to Excel Options
Workbook Creation Options: This option lets you choose how you want the data to be organized when it's exported. If you are exporting a large number of rows, you may want to separate the data into different worksheets or even workbooks. Once you select this option, the Separate (Sheets or Workbooks) By drop-down becomes available so you can choose the groupings for each worksheet or workbook.
Separate (Sheets or Workbooks) By: This field becomes available when you choose to organize your export into multiple worksheets or workbooks. In general, you'll have the option to separate the data based on the columns. You will only see options for the visible columns.
Notice
For example, if you are exporting a set of definitions, you might choose to organize the data into two workbooks: one for active definitions, and one for inactive definitions. Do this by selecting the "Active" column in this drop-down. All of your rows designated as active will be in one workbook, and the inactive ones in a separate workbook.
Workbook Format: This section lets you set some Excel display options for your data. For more information about each of these features, consult Microsoft Excel help.
Autofit columns: Fits column width to the data so that fields are not truncated.
Turn on filtering: Turns on the AutoFilter feature, which allows you to show only rows that meet your selected criteria.
Freeze Top Row: Your worksheet displays the column title in the first row by default. Selecting this option keeps the top row at the top so that as you scroll down through your data, the column headings remain displayed.
Show totals for numeric columns: This option will include the sum of a column of numbers at the bottom of that column.
Columns to Include: These options are specific to the page you are viewing, so they will vary. You will only see options for columns that you can see on the page. All of the columns are selected by default, but you can deselect any of the columns you don't want to include.
Click Download. Your .xlsx or .zip file is saved in the file location that you have set in your browser settings.

FAQ

Can I define PESC Subtest EDI definitions before creating PESC Test EDI definitions?

No. Create Test EDI definitions first so you can use them when creating PESC Subtest EDI definitions.