NSC Degree Verification History Window

This window allows you to view and/or edit NSC Degree Verification History records. No records are retrieved until you enter search criteria and/or click the Find button.

Search/Filter By

The Search/Filter By group box allows you to enter or select search/filter criteria to retrieve or filter NSC Degree Verification History records. This Search/Filter By criteria can be used to populate the History Detail tab and also to quickly retrieve historical data on the Reports tab without having to customize reports.

When you enter an ID #, the associated name displays in the text box beside it. This column has the standard ID search options.

This drop-down list is populated with values from the NSC_CONFIG table. All unique values of the FICE and Branch codes are displayed in FFFFFF - BB format.

This drop-down list displays the Degree Period codes and descriptions of all Degree Period codes that are also flagged as NSC Periods.

This drop-down calendar allows you to select a date for this report.

The Clear button removes all values from the search criteria columns, which allows you to enter new search criteria.

The Find button can be used with or without search/filter criteria.

If you enter search/filter criteria values and then click the Find button, all records from the NSC_DEGREE_VERIF_HIST_V view that match the search/filter criteria values are displayed on the History Detail tab.

History Detail Tab

The History Detail tab displays all records that meet the search/filter criteria defined in the Search/Filter By group box. It is populated when you click the Find button.

All data except the SSN is displayed from NSC_DEGREE_VERIF_HIST_V view. The SSN is from the BIOGRAPH_MASTER table. However, if any data is edited on this tab, the following tables will be updated with the new values: NSC_DEGREE_VERIF_HIST, NSC_DEGREE_HISTORY_COL, NSC_DEGREE_HISTORY_STRING, and NSC_DEGREE_HISTORY_VALUE.

You can add, modify, or delete records on this tab. All columns for new records are editable. All columns for existing records are editable with the exception of the following: FICE, Brand, Report Date, Period, and ID#.

Reports Tab

The Reports tab allows you to view reports, customize reports, print reports, or save reports or rows to a different format.

The Report drop-down displays a list of reports from rereports.pbl with name like r_nsc_deg_verification_hist. The Original report, which can be customized, is displayed as a tree-view report with the FICE/Branch as the top level and Periods (with Report Date) as the second level. It then displays student ID, Name, and Major 1 columns as detail.

Checkbox, Button, and Icons

· If you select the Expand All checkbox and click the Preview button, both levels and the detail data are displayed. If you clear the Expand All checkbox, only the top level of data is displayed.

· If you click the Preview button, the report is displayed according to any Search/Filter By criteria you may have entered.

· If you want to print the report, click the Printer icon (

) to open the Printer Setup window.

· If you want to save the report, click the Save As icon (

) to open the Save As window.

How To

1. Open the NSC Degree Verification History window.

This window is only available if you have selected the Make Use of NSC Functionality checkbox on the Registration Configuration window.

2. Enter Search By/Filter criteria to retrieve the appropriate records from the NSC_DEGREE_VERIF_HIST_V view or do not enter criteria to retrieve all records..

3. Click the Find button.

4. The History Detail tab is populated. New records can be entered, and existing records can be edited or deleted.

5. Click the Report tab to view, customize, print, and/or save reports or rows to a different format by using the Search By Filter criteria columns, the Expand All checkbox, the Preview button, and the Printer and Save As icons.