|
Oracle® Rules Palette Release 9.1.0.0.0 E15811-01 |
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.
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.
