Update Definition Window

The Update Definition window can be used to add or edit your update type and code combinations as defined in the Maintain Table Values window. However, there are a number of update types that J1 Desktop modules depend on for certain processes, which are outlined below.

Registration

The NSC codes should not be deleted because the system must have them to create the NSC data needed for reporting purposes UNLESS your school does NOT do NSC reporting (the Make Use of NSC Functionality checkbox is cleared in the Registration Configuration window).

Update Type

Update Code

Process

User Defined

Updates Classification on the STUD_TERM_SUM_DIVE table

User Defined

Updates Academic Standing (Honors) on the STUD_TERM_SUM_DIVE table

NSC

NS1

Updates FICE Code on the NSLC_STUDENT_MAST table

NSC

NS2

Updates Branch Code on the NSLC_STUDENT_MAST table

NSC

NS4

Updates Foreign Student column on the NSLC_STUDENT_MAST table

NSC

NS5

The National Student Clearinghouse no longer uses the Grad Level Indicator. They now use the Clearinghouse Class Code to get this information.

NSC

NS6

Updates Data Block Indicator on the NSLC_STUDENT_MAST table

NSC

NS7

Updates FERPA Block Indication on the NSC_DEG_VERIF_DETAIL table

NSC

NS8

Updates Financial Obligation Block on the NSC_DEG_VERIF_DETAIL table

NSC

NS9

Used by the Populate Transmittal process to calculate the Clearinghouse Class Code using any available table/column you wish

NSC

NS10

Used by the Populate Transmittal process for validation of the Good Student flag

NSC

NS11

Used by NSCL_STUDENT_MAST.NSL_ETHNIC_RACE

OPE

OPE ID Assignment

Used to assign this OPE ID when a new Degree History record is created; also used to update all existing Degree History records

User Defined

Updates Academic Standing (Probation) on the STUD_TERM_SUM_DIVE table

PCP

User Defined

Validates if Non-course Prerequisites, Corequisites, and Prohibited Courses are met

PFD

User Defined

Updates PT/FT Status on Student Term Summary by Division (if you select the Use Rules Based Update for PT/FT Definition checkbox in the Registration Configuration window)

PFN

User Defined

Updates PT/FT Status on NSC Registration Transaction (if you select the Use Rules Based Update for PT/FT Definition checkbox in the Registration Configuration window)

PFS

User Defined

Updates PT/FT Status on Student Term Summary (if you select the Use Rules Based Update for PT/FT Definition checkbox in the Registration Configuration window)

Financial Aid Manager

Jenzabar strongly recommends that an Update Type of SAP be used when developing your Calculate Satisfactory Progress rules. Calculating Satisfactory Progress requires three steps with each step depending on the values determined in the previous steps. Therefore, It is strongly recommended that the following three update codes be defined:

Update Type

Update Code

Process

SAP

SAP1

Rule Assignment on SAP History

SAP

SAP2

Calculate Current Progress (Pass/Fail) on SAP History

SAP

SAP3

Update Final Progress on SAP History

Self-Service Payment Plans

Update Type

Update Code

Process

PMT

PAYPLANS

Payment Plans Assignment

Columns

The following columns are available for you to define update types and codes:

How To

1. Open the Update Definition window.

2. Right-click and select the Add Row option.

3. Right-click in the Update Type column and select the Maintenance Screen option (the Maintain Table Values window will be displayed for the update_type column).

4. Right-click and select the Add Row option.

5. Enter a table value (up to 3 characters) and a table description.

6. Save.

1. Open the Maintain Table Values window.

2. Choose Column Name of update_type.

3. Choose Add Row or Insert Row from the right-click menu or the Options menu.

4. Enter the required information to create the data row.

5. Save.

1. From any Update Type column in any window, chose Maintenance Screen from the right-click menu.

2. The Maintain Table Values window opens with the Column Name of update_type.

3. Choose Add Row or Insert Row from the right-click menu.

4. Enter the required information to create the data row.

5. Save.

6. This new update type will now be available from the Update Definition window, and you can choose the appropriate characteristics to further identify the code. However, the available list displayed in the Target Table drop-down list includes all valid tables in the system. The available list displayed in the Target Column drop-down list will be filtered according to the columns that are available for the target table that has been selected.

1. Open the Update Definition window.

2. Right-click and select the Add Row option.

3. Select an Update Type.

4. Enter the new Update Code (up to 10 characters) and a code Description.

5. Select the appropriate Process Type.

6. Select the appropriate Target Table and Target Column. Only the Update process type requires a Target Table and Target Column, which is available from the drop-down lists.

7. Save.

8. In the Update Definition User Access window, grant access to the appropriate groups for this new Update Code (or Update Type/Update Code combination).