Oracle® Insurance XML Configuration Guide Release 9.4.0.0 E18894_01

# Parts

## Description

This element provides information to create a next identifier.

Parts Element/Attribute Table
Element/Tag | Definition | Attribute | Element/Attribute Value and Description
--- | --- | --- | ---
<Parts> | The opening and closing tag of the Parts section. |  |
<Part> | Required, Repeatable: Definition of a portion of the resulting field value. Source of the value, formatted extract of the source value and truncation of the source value may be defined. |  | A literal value.( Valid with TYPE=”VALUE” only. ) A valid field name. Field must be defined prior to the identifier field.(Valid with TYPE=”FIELD” only.) A sequence’s name, found in the sequence table from which the sequence value will be derived. (Valid with TYPE=”SEQUENCE” only.) A system date, in format defined by FORMAT. (Valid with TYPE = "SYSTEMDATE" ONLY.)
TYPE | Required: Defines the source of the value that is to be concatenated to the field’s value. VALUE- Concatenates a specific literal value to the identifier field’s value. SYSTEMDATE - Concatenates the designated parts of the system date to the identifier fields’ value. FORMAT attribute is required. SEQUENCE -Concatenates a sequence value. FORMAT attribute is required. SEQUENCEDATE attribute is optional. FIELD (Additional attributes, FORMAT, LEFT, RIGHT and MID, may also be used.)
FORMAT | Required: where TYPE="SYSTEMDATE" or TYPE=”SEQUENCE" Optional: where TYPE=”FIELD” Used with SYSTEMDATE, it defines the portion of the system date to concatenate to the field’s value. Used with SEQUENCE or FIELD, it defines the length and padding character. The output is limited to the number of padding characters provided in the attribute’s value. If needed, the padding characters will fill the length to the left of the sequence number or field value without disturbing the desired length of the <Part>’s value. A non-overrideable error is caused when the sequence number or field value has more characters than the desired length. Values applicable for TYPE=”SYSTEMDATE”: YY:Pulls the two right-most digits from the year portion from the date value. YYYY:Pulls the four digit year from the date value. MM:Pulls the two digit month portion from the date value. DD: Pulls the two digit day portion from the date value. YYMM: Pulls the two right-most digits from the year portion from the date value and concatenates the two digit month portion from the date value. This always yields four digits. YYYYMM: Pulls the four digit year from the date value and concatenates the two digit month portion from the date value. This always yields six digits. YYMMDD: Results in a full date with a 2 digit year in year-month-day order. This always yields six digits. Applicable for TYPE=”SEQUENCE” and TYPE=”FIELD": A padding character
LEFT | Positive Integer. Indicates the number of left-most characters of a field’s value that is concatenated to the field’s value. Only relevant if TYPE=FIELD and MID and RIGHT are not set.
RIGHT | Positive Integer. Indicates the number of right-most characters of a field’s value that is concatenated to the field’s value. Only relevant if TYPE=FIELD and RIGHT is not set.
MID | Positive Integer, Positive Integer. Used with TYPE=FIELD. Indicates the starting and ending position of the characters extracted from the source field value that is concatenated to the field’s value. First integer is the starting position for the extract. Second integer is the ending position for the extract. The first position is 1.
SEQUENCEDATE | Optional: Identifies the source of a date value that is used to determine the correct sequence number. The attribute is only applicable with TYPE=”SEQUENCE”. Values include: A valid field name.- It must be defined prior to the identifier field and must be a field data type of Date. SYSTEMDATE- Identifies the source as the system date. EffectiveDate- Identifies the source as an activity’s effective date. This would be available only within a transaction’s definition.

## XML Example

    <Parts>

    <Part TYPE="FIELD" LEFT="1">Prefix</Part>

    <Part TYPE="SEQUENCE" FORMAT="0000000">AsActivity_RBWarrantNumber</Part>

    </Parts>

    <Parts>

    <Part TYPE="SEQUENCE" FORMAT="0000000000">ClientID</Part>

    </Parts>

## XML Schema

    <Parts>

    <Part TYPE="VALUE">[literal]</Part>

    <Part TYPE="SYSTEMDATE" FORMAT="YY|MM|DD|YYYY|YYMM|YYYYMM|YYMMDD|YYYYMMDD"></Part>

    <Part TYPE="FIELD" LEFT="[integer]" FORMAT="[padding characters]">[field name]</Part>

    <Part TYPE="FIELD" RIGHT="[integer]" FORMAT="[padding characters]">[field name]</Part>

    <Part TYPE="FIELD" MID="[integer, integer]" FORMAT="[padding characters]">[field name]</Part>

    <Part TYPE="SEQUENCE" FORMAT="[padding characters]" SEQUENCEDATE="[field name]|SYSTEMDATE|EffectiveDate">[sequence  name]</Part>

    </Parts>

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

Open table of contents