Oracle® Insurance Rules Palette Release 9.3.1.0 E21044_01
The Suspense batch process starts with any insurance company's Document Service area receiving the Check/EFT. 10 or 20 or 30 Checks that are related to each other in some form like same bank, client etc can be combined to form a batch, depending on the insurance company's preference.
One Suspense record is created for each Check of a Suspense Batch through the SuspenseBatchScreen. Each newly added Suspense record through this screen shall be displayed in the Table present above the details section of the Suspense Batch screen and they will be in Pending Status until the batch is completed. A unique Batch number is issued to the batch when it is created. Also, a unique Suspense number is generated when each Suspense record of a batch is created.
Note: This is a Code-driven Screen. If there are no Configuration in the BusinessRule, then the Screen will still be usable with the Fixed Fields that are in place.
| Element/Tag | Definition | Attribute | Element/Attribute Value and Description |
|---|---|---|---|
|
<SuspenseBatchScreen> |
The opening and closing tag of the SuspenseBatch Screen Business Rule. |
|
|
|
Optional element;
|
|
|
|
|
Required element;
|
|
|
|
| Optional element;
Allows configuration of MultiFields in the SuspenseBatch Screen |
|
Required element value;
|
|
|
Yes - Enables the MultiField Business Rule (turns on) and if set to "Yes" Multi Fields should be generated on the SuspenseBatchScreen |
|||
|
No - Defaults and disables the Multifield Business Rule (turns off) and if set to "No" Multi Fields should not be generated on the SuspenseBatchScreen. Note: If this element is not present default is "No". |
|||
| RULE |
Required attribute;
|
||
|
Optional element; Allows configuration of editsand validations. Provides online page error message via Java Script. Limited to the variables available on the page. |
|
|
|
|
<OnLoad> |
Optional element;
|
|
|
|
<OnChange> |
Optional element;
|
|
|
|
<SearchFields> |
Required element;
|
|
|
|
<Field> |
Required / Repeatable element;
|
|
Required element value;
|
|
<Table> |
Required element;
|
|
|
|
<Column> |
Required element; |
WIDTH
ALIGN FORMAT |
Optional attribute;
|
|
<Display> |
Required element;
|
|
|
|
<Name> |
Required element;
|
|
|
|
<Group> |
Required element;
|
|
|
<SuspenseBatchScreen>
<FixedFields>
<Fields>
<Name>CompanyName</Name>
<Display>NewCompany</Display>
</Fields>
</FixedFields>
<Fields>
</Field>
<Field>
<Name>MyRunningTotal</Name>
<Display>My Running Total</Display>
<DataType>Text</DataType>
<Calculated TYPE="SQL" METHOD="FORCE">SELECT SUM(AsSuspense.Amount) FROM AsSuspense WHERE AsSuspense.BatchNumber = '[BatchNumber]' AND AsSuspense.StatusCode != '12'</Calculated>
</Field>
<Field>
<Name>SuspenseFromCompany</Name>
<Display>Suspense From Company</Display>
<ToolTip>Suspense Company</ToolTip>
<DataType>Combo</DataType>
<!--<Disabled>Yes</Disabled>-->
<Query TYPE="FIXED">
<Options>
<Option>
<OptionValue>0</OptionValue>
<OptionText>N/A</OptionText>
</Option>
<Option>
<OptionValue>2</OptionValue>
<OptionText>MONY</OptionText>
</Option>
<Option>
<OptionValue>3</OptionValue>
<OptionText>MLOA</OptionText>
</Option>
<Option>
<OptionValue>4</OptionValue>
<OptionText>LGY</OptionText>
</Option>
<Option>
<OptionValue>5</OptionValue>
<OptionText>CB</OptionText>
</Option>
<Option>
<OptionValue>6</OptionValue>
<OptionText>AS</OptionText>
</Option>
</Options>
</Query>
</Field>
<Field>
<Name>FromPolicyNumber</Name>
<Display>From Contract No</Display>
<DataType>Text</DataType>
<!--<Disabled>Yes</Disabled>-->
<InPutFocus>Yes</InPutFocus>
</Field>
</Fields>
<OnChange>
<Change>
<Name>cmbTypeCode</Name>
<Type>Combo</Type>
<Items>
<Item INDEX="0" NAME="Check">
<TypeCode TYPE="EVAL">document.frmSuspense.cmbSuspenseFromCompany.disabled=true;document.frmSuspense.cmbSuspenseFromCompany.style.backgroundColor='E4E4E4';document.frmSuspense.cmbSuspenseFromCompany.value='0';document.frmSuspense.txtFromPolicyNumber.disabled=true;document.frmSuspense.txtFromPolicyNumber.style.backgroundColor='E4E4E4';document.frmSuspense.txtFromPolicyNumber.value='';</TypeCode>
</Item>
<Item INDEX="1" NAME="EFT">
<TypeCode TYPE="EVAL">document.frmSuspense.cmbSuspenseFromCompany.disabled=true;document.frmSuspense.cmbSuspenseFromCompany.style.backgroundColor='E4E4E4';document.frmSuspense.cmbSuspenseFromCompany.value='0';document.frmSuspense.txtFromPolicyNumber.disabled=true;document.frmSuspense.txtFromPolicyNumber.style.backgroundColor='E4E4E4';document.frmSuspense.txtFromPolicyNumber.value='';</TypeCode>
</Item>
<Item INDEX="2" NAME="InterCompany">
<TypeCode TYPE="EVAL">document.frmSuspense.cmbSuspenseFromCompany.disabled=false;document.frmSuspense.cmbSuspenseFromCompany.style.backgroundColor='FFFFFF';document.frmSuspense.cmbSuspenseFromCompany.value='0';document.frmSuspense.txtFromPolicyNumber.disabled=false;document.frmSuspense.txtFromPolicyNumber.style.backgroundColor='FFFFFF';document.frmSuspense.txtFromPolicyNumber.value='';</TypeCode>
</Item>
</Items>
</Change>
</OnChange>
<Validation ONSAVE="Yes">
<Required>
<Field>Amount</Field>
</Required>
<Expressions>
<Expression MESSAGE="You must enter a Suspense amount"></Expression>
<Expression MESSAGE="You must enter a From Contract Number.">(!((document.frmSuspense.cmbTypeCode.selectedIndex == '2') && !(document.frmSuspense.cmbSuspenseFromCompany.value == '') && (document.frmSuspense.txtFromPolicyNumber.value == '')))</Expression>
<Expression MESSAGE="You must enter a From Contract Number.">(!(document.frmSuspense.txtFromPolicyNumber.value == ''))</Expression>
</Expressions>
</Validation>
<SearchFields>
<Field>SuspenseNumber</Field>
<Field>PolicyNumber</Field>
<Field>EffectiveDate</Field>
<Field>LastName</Field>
<Field>Amount</Field>
</SearchFields>
<Table>
<Column WIDTH="100" ALIGN="LEFT">
<Display>Suspense Number</Display>
<Name>SuspenseNumber</Name>
<Group>Suspense</Group>
</Column>
<Column WIDTH="90" ALIGN="LEFT">
<Display>Policy Number</Display>
<Name>PolicyNumber</Name>
<Group>Suspense</Group>
</Column>
<Column WIDTH="90" ALIGN="LEFT">
<Display>Statutory Company</Display>
<Name>StatutoryCompany</Name>
<Group>SuspenseField</Group>
</Column>
<Column WIDTH="80" ALIGN="LEFT">
<Display>Amount</Display>
<DataType>Money</DataType>
<Name>Amount</Name>
<Group>Suspense</Group>
</Column>
<Column WIDTH="90" ALIGN="LEFT">
<Display>Last Name</Display>
<Name>LastName</Name>
<Group>Suspense</Group>
</Column>
<Column WIDTH="90" ALIGN="LEFT">
<Display>First Name</Display>
<Name>FirstName</Name>
<Group>Suspense</Group>
</Column>
<Column WIDTH="80" ALIGN="LEFT">
<Display>Effective Date</Display>
<Name>EffectiveDate</Name>
<Group>Suspense</Group>
</Column>
<Column WIDTH="80" ALIGN="LEFT">
<Display>Attached Amount</Display>
<Name>AttachedAmount</Name>
<Group>Suspense</Group>
</Column>
<Column WIDTH="50" ALIGN="LEFT">
<Display>Status</Display>
<Name>DisplayStatusCode</Name>
<Group>Suspense</Group>
</Column>
</Table>
</SuspenseBatchScreen>
<SuspenseBatchScreen>
<FixedFields></FixedFields>
<Fields></Fields>
<MultiFields RULE="[MultiFieldBusinessRule]">[Yes|No]</MultiFields>
<Validation></Validation>
<OnLoad></OnLoad>
<OnChange></OnChange>
<SearchFields>
<Field>[Field Name]</Field>
</SearchFields>
<Table>
<Column WIDTH="[Integer]" ALIGN="[LEFT | CENTER | RIGHT]" FORMAT="[TEXT | DATE | CURRENCY]"></Column>
<Display></Display>
<Name></Name>
<Group></Group>
</Table>
</SuspenseBatchScreen>
Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices