Value Sets Fusion

Value set is nothing but List of Values with validations.. Value sets when attached to a segment in DFF ,controls and validates the data that can be entered into that segment.

Value set types available in Fusion :

Table : The valid values exist in a table column, use a table value set to specify the list of values.

A table–validated value set provides a predefined list of values like an independent set, but its values are stored in an application table. You define which table you want to use, along with a WHERE cause to limit the values you want to use for your set. Typically, you use a table–validated set when you have a table whose values are already maintained in an application table (for example, a table of vendor names maintained by a Define Vendors form). Table validation also provides some advanced features such as allowing a segment to depend upon multiple prior segments in the same structure.

Independent : Use an independent value set to specify a custom set of valid values.

Dependent : Use a dependent value set when the available values in the list and the meaning of a given value depend on which independent value was selected for a prior custom attribute.

For example the valid holidays depend on which country you are in.

Subset : Use a subset value set when you want to use a subset of values from an existing independent value set.

 For example, if you have an independent value set for the days of the week, a weekend subset can be composed of its entries for Saturday and Sunday.

Format only : Use a format-only value set when you want to allow end users to enter any value so long as that value conforms to formatting rules.

For example, if you specify a maximum length of 3 and numeric-only, then end users can enter 456, but not 4567 not 45A.

None: This type allows users to enter any value as long as the value meets value set formatting rules. As this value set is not validated, a segment using this value set does not provide list of values. 

Ex: If the value set does not allow alphabetic characters, we cannot enter “ABC” but can enter “123”.

Special & pair:

Special and pair value sets provide a mechanism to allow a”FLEXFIELD–within–a–FLEXFIELD”. These value sets are primarily used for Standard Request Submission parameters. You do not generally use these value sets for normal FLEXFIELD segments. Special and Pair value sets use special validation routines you define. For example, you can define validation routines to provide another FLEXFIELD as a value set for a single segment or to provide a range FLEXFIELD as a value set for a pair of segments.

Translation dependent and translation independent:

A Translatable Independent value set is similar to Independent value set in that it provides a predefined list of values for a segment. However, a translated value can be used. A Translatable Dependent value set is similar to Dependent value set in that the available values in the list and the meaning of a given value depend on which independent value was selected in a prior segment of the FLEXFIELD structure. However, a translated value can be used. FLEXFIELD Value Security cannot be used with Translatable Independent or Translatable Dependent value sets. For format validation, translatable value sets must use the format type Char. The maximum size must be no greater than 150. The Number Only option and the Right–justify and Zero–Fill Numbers option cannot be used with translatable value sets. Range FLEXFIELDs cannot use Translatable Independent or Translatable Dependent value sets.