Oracle® Rules Palette Release 9.1.0.0.0 E15811-01

# 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 until you find the AsCodeWithholdingTypes folder. Open the folder and check-out the XML file. You can add and modify code values from this file.

#

#### Database Structure

The following is an explanation of the tables that make up the withholding database structure.

AsWithholding

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 depending on the TypeCode which is the level where the withholding occurred in OIPA.

AsWithholdingField

WithholdingGUID: The GUID from AsWithholding used to associate dynamic fields with the correct Withholding screen.

FieldName: Name of the dynamic field. Used to perform Math and processing.

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.