The Basic Properties of a record are defined in the following table:
Property | Description |
---|---|
Name | Specifies the name of this record. Attention: The field name must be a valid node
name.
|
Type | Optional:
Specifies the record type used as a basis for the record. The Type list
is only active if the selected record node does not contain any children
and a record type has been created. A record cannot inherit fields
or subrecords from a record type if the record contains children. Attention: Selecting a new type might reset some of the existing
properties of the record with the new settings.
|
Reset | Resets properties that have been set locally for this record to the values for the selected type. Reset is only active if a record type has been selected from the Type list. |
Structure |
|
Record Identifier | Specifies the unique string that identifies this record. Record identifiers are called segment IDs in X.12 message standards such as EDI or HL7, and typically begin each record. |
Record ID Starting Position | Specifies the character position where the record ID begins after the end of the previous record. The default is 0, which places the record ID at the beginning of the record. |
Minimum Occurrences | Specifies the minimum number of repetitions for this record. The default is 1, which means the record is required. Specify 0 if this record is optional. WARNING: When specifying the optional property for a record, be careful not to create an ambiguous grammar for the Flat File Schema. For more information, see Specifying Optional Fields and Records. |
Maximum Occurrences | Controls repetitions of the single record. Select one of the following options: Unbounded - Specifies this record can repeat any number of times. Range - Specify the maximum number of repetitions for this record. The actual occurrences in a specific message can be less than or equal to this limit. NOTE: Multiple occurrences are only allowed when the parent node has specified |
Child delimiters
The Child property defines the character that delimits children of the record. This character is commonly called the record delimiter, segment delimiter, or line delimiter.
Specify the type of child delimiter by selecting one type from the three options listed in the following table:
Option | Definition |
---|---|
Character | Specifies the character for the child delimiter.
If the Character option is selected for the Child
Delimiter, you must enter a single character using one
of the following actions:
|
Line End | Specifies that the child delimiter is the end of the line, either a LF (line feed) or CRLF (carriage return, line feed). If the children are delimited with just a CR (carriage return), select the Character option and specify a CR (carriage return) character as the delimiter. The Integration Appliance accepts both line end characters (LF and CRLF) when parsing data. When writing data, the character used for line ends is determined by the Write Line Ends As CRLF property. |
Dynamic Position | Specifies that the character used as the child
delimiter is defined dynamically within the data. Dynamic delimiters
must show at a specific position within the first record of the data,
such as in EDI or HL7 data. How the character is used by the Integration
Appliance depends if the Flat File data is incoming or outgoing:
|
Write Default | Specifies the character that should be used
as the child delimiter when the Integration Appliance writes outgoing
data in the Write Flat File activity. In addition,
the specified character is written at the specified position of the
first record in the outgoing data. The character specified in this
field is not used when incoming Flat File data is read in the Read
Flat File activity. In the Write Default text
field of the pane, enter a single character using one of the following
actions:
|
Select the Include Trailing Delimiters for Empty Data check box to specify that delimiters for empty optional children must be present at the end of the record or field when the Integration Appliance writes outgoing Flat File data in the Write Flat File activity.
Clear this checkbox, if delimiters for empty optional children might be omitted.
This check box does not affect how the Integration Appliance reads incoming data because when reading data the Integration Appliance accepts either the absence or presence of delimiters with empty data.
Position | Definition |
---|---|
After | Specifies that the child delimiter marks the
end of a child, including the last child in the data. After is the most common position for record delimiters. |
Before | Specifies that the child delimiter indicates the beginning of a child. The end of the last child is marked by the delimiter of the parent. |
In between | Specifies that delimiters are placed between children but do not show at either the beginning of the first child nor the end of the last child. |
Position | Definition |
---|---|
Character | Specifies the character for the repeat delimiter.
If the Character option is selected for the Repeat
Delimiter, you must enter a single character using one
of the following actions:
|
Line End | Specifies that the repeat delimiter is the end of the line, either a LF (line feed) or CRLF (carriage return, line feed). If the children are delimited with just a CR (carriage return), select the Character option and specify a CR (carriage return) character as the delimiter. The Integration Appliance accepts both line end characters (LF and CRLF) when parsing data. When writing data, the character used for line ends is determined by the Write Line Ends As CRLFproperty. |
Dynamic Position | Specifies that the character used as the repeat
delimiter is defined dynamically within the data. Dynamic delimiters
must show at a specific position within the first record of the data,
such as in EDI or HL7 data. How the character is used by the Integration
Appliance depends if the Flat File data is incoming or outgoing:
|
Write Default | Specifies the character that should be used
as the repeat delimiter when the Integration Appliance writes outgoing
data in the Write Flat File activity. In addition,
the specified character is written at the specified position of the
first record in the outgoing data. The character specified in this
field is not used when incoming Flat File data is read in the Read
Flat File activity. In the Write Default text
field of the pane, enter a single character using one of the following
actions:
|