Withholding Codes and Database Structure
Withholding codes can be added and modified through the Rules Palette Admin Explorer tab. Open the Rules Palette Admin Explorer tab and double-click on the Code Names folder. Scroll down to the AsCodeWithholdingTypes folder. Open the folder and check-out the XML file. Add and modify code values from this file.
Withholding Code Names File in Admin Explorer Tab
Database Structure
The following is an explanation of the tables that make up the withholding database structure.
AsWithholding Table
WithholdingGUID: Unique GUID that identifies a withholding record that was written.
TypeCode: Code for the level and type of withholding record. Codes from AsCodeWithholdingType.
RelatedGUID: This GUID links to either AsPlan, AsClient, AsPolicy or AsActivity. Relevant type codes are Plan, Client, Policy and Activity corresponding to the value of the related GUID .
AsWithholdingField Table
WithholdingGUID: The GUID from AsWithholding is used to associate dynamic field values with the correct Withholding record.
FieldName: Name of the dynamic field.
FieldTypeCode: Type code of the dynamic field from AsCodeField.
DateValue: If field is a date value it will be stored here, if not null will be stored.
TextValue: If field is a text value it will be stored here, if not null will be stored.
IntValue: If field is an integer value it will be stored here, if not null will be stored.
FloatValue: If field is a float value it will be stored here, if not null will be stored.
CurrencyCode: The currency code to assign money.
OptionTextFlag:
OptionText:
Copyright © 2009, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices