Dialog Box Reference for Flexible Fields
Flexible fields are extra, unused fields defined in certain tables of the Tivoli Problem Management (TPM) database. With flexible fields, you can:
You can add new text boxes to view or edit flexible field data in certain dialog boxes.
flexible fields provide two important benefits:
TPM has flexible fields in the following database tables:
Each table contains the following types of flexible fields:
The flexible fields in a particular database table are designed to work with a specific group of dialog boxes in TPM. Some dialog boxes may not be able to use flexible fields in certain database tables.
Additionally, there may be other constraints for using flexible fields. For example, some flexible fields are read only in certain dialog boxes and read-write in other dialog boxes. A table is provided later in this chapter so that you can identify the dialog boxes where flexible fields are available.
This section describes the table, field name, and data type for each flexible field.
Note: If you want to be able to use a flexible field to inquire for or search for records, you can improve system performance by creating an index on that flexible field column.
Table Name | Flexible Field Name | Data Type |
CALL | FLX_CAL_DATE1 | DATE |
FLX_CAL_DATE2 | DATE | |
FLX_CAL_INT1 | INTEGER | |
FLX_CAL_INT2 | INTEGER | |
FLX_CAL_INT3 | INTEGER | |
FLX_CAL_INT4 | INTEGER | |
FLX_CAL_TIME1 | TIME | |
FLX_CAL_TIME2 | TIME | |
FLX_CAL_VCHR1 | VARCHAR2() | |
FLX_CAL_VCHR2 | VARCHAR2(250) | |
FLX_CAL_VCHR3 | VARCHAR2(250) | |
FLX_CAL_VCHR4 | VARCHAR2(250) | |
CONTACTS | FLX_CON_DATE1 | DATE |
FLX_CON_DATE2 | DATE | |
FLX_CON_INT1 | INTEGER | |
FLX_CON_INT2 | INTEGER | |
FLX_CON_INT3 | INTEGER | |
FLX_CON_INT4 | INTEGER | |
FLX_CON_TIME1 | TIME | |
FLX_CON_TIME2 | TIME | |
FLX_CON_VCHR1 | VARCHAR2(250) | |
FLX_CON_VCHR2 | VARCHAR2(250) | |
FLX_CON_VCHR3 | VARCHAR2(250) | |
FLX_CON_VCHR4 | VARCHAR2(250) | |
LOCATION | FLX_LOC_DATE1 | DATE |
FLX_LOC_DATE2 | DATE | |
FLX_LOC_INT1 | INTEGER | |
FLX_LOC_INT2 | INTEGER | |
FLX_LOC_INT3 | INTEGER | |
FLX_LOC_INT4 | INTEGER | |
FLX_LOC_TIME1 | TIME | |
FLX_LOC_TIME2 | TIME | |
FLX_LOC_VCHR1 | VARCHAR2(250) | |
FLX_LOC_VCHR2 | VARCHAR2(250) | |
FLX_LOC_VCHR3 | VARCHAR2(250) | |
FLX_LOC_VCHR4 | VARCHAR2(250) | |
PROBLEMS | FLX_PRO_DATE1 | DATE |
FLX_PRO_DATE2 | DATE | |
FLX_PRO_INT1 | INTEGER | |
FLX_PRO_INT2 | INTEGER | |
FLX_PRO_INT3 | INTEGER | |
FLX_PRO_INT4 | INTEGER | |
FLX_PRO_TIME1 | TIME | |
FLX_PRO_TIME2 | TIME | |
FLX_PRO_VCHR1 | VARCHAR2(250) | |
FLX_PRO_VCHR2 | VARCHAR2(250) | |
FLX_PRO_VCHR3 | VARCHAR2(250) | |
FLX_PRO_VCHR4 | VARCHAR2(250) | |
SOLUTIONS | FLX_SOL_DATE1 | DATE |
FLX_SOL_DATE2 | DATE | |
FLX_SOL_INT1 | INTEGER | |
FLX_SOL_INT2 | INTEGER | |
FLX_SOL_INT3 | INTEGER | |
FLX_SOL_INT4 | INTEGER | |
FLX_SOL_TIME1 | TIME | |
FLX_SOL_TIME2 | TIME | |
FLX_SOL_VCHR1 | VARCHAR2(250) | |
FLX_SOL_VCHR2 | VARCHAR2(250) | |
FLX_SOL_VCHR3 | VARCHAR2(250) | |
FLX_SOL_VCHR4 | VARCHAR2(250) | |
USERS | FLX_USR_DATE1 | DATE |
FLX_USR_DATE2 | DATE | |
FLX_USR_INT1 | INTEGER | |
FLX_USR_INT2 | INTEGER | |
FLX_USR_INT3 | INTEGER | |
FLX_USR_INT4 | INTEGER | |
FLX_USR_TIME1 | TIME | |
FLX_USR_VCHR1 | VARCHAR2(250) | |
FLX_USR_VCHR2 | VARCHAR2(250) | |
FLX_USR_VCHR3 | VARCHAR2(250) | |
FLX_USR_VCHR4 | VARCHAR2(250) |
The following table describes the types of flexible fields you can use in each dialog
box.
Dialog Box Name | Dialog File Name (DF File) | Dialog Box Name in the DF File | Types of flexible fields Available |
Call History | |||
Call History Inquiry dialog box | callhist.df | CALL_HISTORY_INQUIRY | CALL (read only) CONTACTS (read only) LOCATION (read only) |
View Call Record dialog box | callhist.df | VIEWCALLFORM | CALL (read only) CONTACTS (read only) LOCATION (read only) |
Call Registration | |||
Call Registration dialog box - Call Registration tab | calls.df | REGISTERCALL | CALL (read-write) PROBLEMS (read-write) CONTACTS (read only) LOCATION (read only) |
Call Registration dialog box - Problem History tab (You can add flexible fields only to the table.) | calls.df | PROBLEMLIST | CALL (read only) PROBLEMS (read only) |
Call Registration Dispatch dialog box | calls.df | DISPATCHCALL | CONTACTS (read only) LOCATION (read only) |
Contacts | |||
Work with Contacts dialog box (You can add flexible fields only to the table.) | contacts.df |
WORKWITHCONTACTS | CONTACTS (read only) |
Contacts Inquiry dialog box | contacts.df | CONTACT_INQUIRY | CONTACTS (query only) |
Add Contact Record dialog box Edit Contact Record dialog box |
contacts.df | CONTACTFORM | CONTACTS (read-write) |
View Contact Record dialog box | contacts.df | CONTACTFORM | CONTACTS (read only) |
Locations | |||
Work with Locations dialog box (You can add flexible fields only to the table.) | location.df | WORKWITHLOCATIONS | LOCATION (read only) |
Location Inquiry dialog box | location.df |
LOCATION_INQUIRY |
LOCATION (query only) |
Add Location dialog box Edit Location dialog box |
location.df | LOCATIONFORM | LOCATION (read-write) |
View Location dialog box | location.df | LOCATIONFORM | LOCATION (read only) |
Problem Transfers | |||
Work with Problem Transfer dialog box - Status tab | problems.df | VIEWPROBSTATUSFORM | CALL (read only) PROBLEMS (read only) |
Work with Problem Transfer dialog box - Initial tab | problems.df | VIEWPROBCALLFORM | CALL (read only) PROBLEMS (read only) |
Problems | |||
Work with Problems dialog box (You can add flexible fields only to the table.) | problems.df | WORKWITHPROBLEMS | PROBLEMS (read only) |
Problem Inquiry dialog box | problems.df | PROBLEM_INQUIRY | PROBLEMS (query only) |
Edit Problem Status dialog box - Problem tab | resume.df |
EDITPROBFORM | PROBLEMS (read-write) |
Edit Problem Status dialog box - Calls tab | resume.df | WORKWITHCALLS | CALL (read only) CONTACTS (read only) LOCATION (read only) |
Attach Call dialog box (You can add flexible fields only to the table.) | problems.df | REGISTERPROBLEM | CALL (read-write) CONTACTS (read only) LOCATION (read only) |
Solutions | |||
Work with Solution dialog box (You can add flexible fields only to the table.) | solution.df | WORKWITHSOLUTION | SOLUTIONS (read only) |
Solutions Inquiry dialog box | solution.df | SOLUTIONS_INQUIRY | SOLUTIONS (query only) |
Add Solution dialog box Edit Solution dialog box |
solution.df |
SOLUTIONSFORM | SOLUTIONS (read-write) |
View Solution dialog box | solution.df | VIEWSOLUTIONFORM | SOLUTIONS (read only) |
Activate Solution dialog box | solution.df | ACTIVATEFORM | SOLUTIONS (read only) |
Users | |||
Work with Active Users dialog box (You can add flexible fields only to the table.) | users.df | WORKWITHUSERS | USERS (read only) |
User Inquiry dialog box | users.df | USER_INQUIRY | USERS (query only) |
Add User dialog box Edit User dialog box |
users.df | USERFORM | USERS (read-write) |
View User dialog box | users.df | USERFORM | USERS (read only) |