You are here: Configuration > Withholding > Withholding Codes and Database Structure

Oracle® Insurance Rules Palette 9.4.1.0 E23637_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 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 depending on the TypeCode which is the level where the withholding occurred in OIPA.

AsWithholdingField Table

WithholdingGUID: The GUID from AsWithholding used to associate dynamic field values with the correct Withholding record.

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.

Withholding Database Tables

Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices