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