Target Table and Column

When defining your set of criteria for an update code, you must select a target table and column to be updated. Valid table codes are stored in the LIST_ALLOWED_TBL table.

·       If you open the Rules Based Update from the Common module, all table codes display in the drop-down list.

·       If you open the Rules Based Update from other modules (Registration, Financial Aid, etc.), table codes associated with processes for that module display in the drop-down list.

Columns available for your selection depend on the table selected.

The following columns were removed from Rules Based Update in a previous version.

·       BIOGRAPH_MASTER.VETERAN

·       BIOGRAPH_MASTER.VETERAN_OF_ARMED_SVCS_BRANCH

·       BIOGRAPH_MASTER.IS_ACTIVE_DUTY_ARMED_SVCS

·       BIOGRAPH_MASTER.ACTIVE_DUTY_ARMED_SVCS_BRANCH

·       CANDIDATE.DEPENDENT_OF_VETERAN

·       CANDIDATE.RECEIVING_VETERANS_BENEFITS

·       STUD_DIV_MAST.VETERANS_ASSOCN_BEN

If you have defined any rules that use these obsolete columns, you will need to update your rules to reference the new Military Service Master corresponding columns. To help you identify any rules that reference these columns, you can use the following sample scripts:

SELECT * FROM update_def WHERE target_table LIKE '%veteran%' OR target_columnLIKE '%veteran%';

SELECT * FROM update_results_rules WHERE rules_table_column like '%veteran%' or rules_value LIKE '%veteran%';

SELECT * FROM update_def WHERE target_table LIKE '%armed%' OR target_columnLIKE '%armed%';

SELECT * FROM update_results_rules WHERE rules_table_column like '%armed%' or rules_value LIKE '%armed%';

 

Target Tables Available from the Common Module

Code

Description

Comment

BIOGRAPH_MASTER

Biograph Master

 

CANDIDACY

Candidacy

 

CANDIDACY

Candidacy Master

 

CANDIDATE

Candidate

 

CANDIDATE

Candidate Master

 

DEGREE_HISTORY

Degree History

 

HIGHEST_TEST_SCORE

Highest Test Score

 

MILITARY_SERVICE_MASTER

Military Service Master

 

NAME_MASTER

Name Master

 

NSC_DEG_VERIF_DETAIL

NSC Degree Verification Detail

 

NSLC_REG_TRANSACT

NSL Reg Transactions

 

NSLC_STUDENT_MAST

NSL Student Master

 

PF_SAP_HIST

Satisfactory Progress History

 

PF_SAP_HIST_UDF

User-Defined Satis Prog Hist

 

STUD_TERM_SUM_DIV

Student Term Summary By Divisn

 

STUDENT_DIV_MAST

Student Division Master

 

STUDENT_MASTER

Student Master

 

STUDENT_MASTER_EXT

Student Master Extension

 

STUDENT_TERM_SUM

Student Term Summary

 

STUDENT_TERM_TABLE

Student Term Table

 

TEST_SCORES

Test Scores

 

TEST_SCORES_DETAIL

Test Scores Detail

 

TRANS_HIST

Transaction History

 

TRANS_HIST_EXT

Transaction History Extension