Customizing Tivoli Problem Management


Introduction

Available Flexible Fields

Dialog Box Reference for Flexible Fields


Introduction

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:

Flexible Field Types

TPM has flexible fields in the following database tables:

Each table contains the following types of flexible fields:

Flexible Field Availability

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.


Available Flexible Fields

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)

Dialog Box Reference for Flexible Fields

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)