Planning Your Descriptive Flexfield
When you are planning your flexfields, you should consider the following questions and their corresponding decisions:
Do you want to capture information that is not otherwise captured by the form? If yes, you define this descriptive flexfield. If no, you need not define this descriptive flexfield at all.
Do you want to capture the same information every time, regardless of what other data appears in the form? If yes, you need to define global segments.
Do you want to capture certain information sometimes, depending on what other data appears in the form? If yes, you need to define context-sensitive segments.
If you want context-sensitive segments, do you want to have the form automatically determine which descriptive flexfield structure to display based on the value of a field somewhere on the form? If yes, you need to define a reference field (note that some descriptive flexfields do not provide reference fields).
If you want context-sensitive segments, do you want to have the user determine which descriptive flexfield structure to display by choosing a value in a field inside the pop-up window? If yes, you need to define a context field.
How do you want to break down reporting on your descriptive flexfield data? If you want to report on your data by certain criteria or sub-entities, such as account number or project or region, you may want to consider making that sub-entity a distinct segment, rather than combining it with another sub-entity, so that you can categorize and report on smaller discrete units of information.
How often does your organization change? This would affect how you set up your values. For example, if you disable old cost centers and enable new ones frequently, you would "use up" cost center values quickly. You would therefore want to use a larger maximum size for your cost center value set so that you can have more available values (for example, you have 999 available values for a 3-character value set instead of 100 available values for a 2-character value set).
Do you want to require a value for each segment?
See:
Overview of Setting Up Flexfields
You should decide on the number, order and length of your segments for each structure. You must also choose how to validate each segment.
See:
Values and Value Sets
Descriptive Flexfield Structure Planning Diagrams
See Also
Descriptive Flexfield Concepts
How Segments Use Underlying Columns
Different Arrangements of Segments