Previous  Next          Contents  Index  Navigation  Glossary  Library

Collection Element Types

Collection element types can be used to sort and group collection elements. There are three predefined collection element types. The first two, attribute and variable, apply to product qualities such as color, taste, size, passed/failed. The third, reference information, refers to common objects within Oracle Applications.

Attribute Collection Elements

Attributes collection elements often represent the outcome of a process, such as a pass/fail result, and often have a limited list of acceptable values.

Attribute Collection Elements List of Values
color blue
yellow
red
defect broken lead
cracked chassis
component failure
disposition scrap
rework
down-grade
Table 1 - 2. Examples of Attribute Collection Elements

Variable Collection Elements

Variable collection elements often represent numeric measurements; for example, size, viscosity, and temperature and often have a range of acceptable values, or specification limits expressed as preferred values with an acceptable degree of tolerance.

Variable Collection Elements Specification Limits
shaft diameter 3.25 cm. + 0.05 cm.
acidity 6.55 + 0.05
temperature 980F + 20
Table 1 - 3. Examples of Variable Collection Elements

Reference Information Collection Elements

Some collection elements reference database objects defined in other Oracle Applications. These collection elements are known as reference information collection elements. See: Reference Information Collection Elements.

See Also

Defining Collection Element Types

         Previous  Next          Contents  Index  Navigation  Glossary  Library