Table Name |
Table Comment |
Table Column Name |
Table Column Comment |
Table Column Datatype |
Table Column Null Option |
ANNOTATION |
This table contains information on annotations that are used with calls or problems. |
ANNOTATION_TYPE |
This column contains the type of annotation that is being used. Currently, only
.wav file annotation is supported. |
NUMBER |
NOT NULL |
ANNOTATION |
This table contains information on annotations that are used with calls or problems. |
CALL_OR_PROB |
This column contains an integer denoting whether this annotation is for a call or
problem. 0 = Call, 1 = Problem. |
NUMBER |
NOT NULL |
ANNOTATION |
This table contains information on annotations that are used with calls or problems. |
CALL_PROB_ID |
This column contains the Call or Problem ID that is associated with this annotation. |
VARCHAR2(15) |
NOT NULL |
ANNOTATION |
This table contains information on annotations that are used with calls or problems. |
FILE_NAME |
This column contains the .wav filename that is used to store this annotation. |
VARCHAR2(80) |
NOT NULL |
ANNOTATION |
This table contains information on annotations that are used with calls or problems. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
ANNOTATION |
This table contains information on annotations that are used with calls or problems. |
USER_ID |
This column contains the User ID that recorded the annotation. |
VARCHAR2(15) |
NOT NULL |
BREACH_RELATIVE_TO |
See common data dictionary. |
AUDIT_TABLE |
|
VARCHAR2(30) |
NOT NULL |
BREACH_RELATIVE_TO |
See common data dictionary. |
DATE_COL_NAME |
|
VARCHAR2(30) |
NOT NULL |
BREACH_RELATIVE_TO |
See common data dictionary. |
KEY_NAME |
|
VARCHAR2(30) |
NOT NULL |
BREACH_RELATIVE_TO |
See common data dictionary. |
RELATION_NAME |
|
VARCHAR2(15) |
NOT NULL |
BREACH_RELATIVE_TO |
See common data dictionary. |
RELATIVE_TO |
|
NUMBER |
NOT NULL |
BREACH_RELATIVE_TO |
See common data dictionary. |
TABLE_NAME |
|
VARCHAR2(30) |
NOT NULL |
BREACH_RELATIVE_TO |
See common data dictionary. |
TIME_COL_NAME |
|
VARCHAR2(30) |
NOT NULL |
CACHE_CONTROL |
This table contains the information to control cache procedures in TPM. |
MODIFY_DATETIME |
This column contains the time the row was inserted into the table. Used to get
only new rows from cache control when performing a diagnostic update. |
NUMBER(38) |
NOT NULL |
CACHE_CONTROL |
This table contains the information to control cache procedures in TPM. |
OP_CODE |
This column contains the operation performed to insert a row into cache_control
(U=update, I=insert, D=delete). |
VARCHAR2(1) |
NOT NULL |
CACHE_CONTROL |
This table contains the information to control cache procedures in TPM. |
TABLE_DATA |
This column contains a concatenated string with relevant data from a diagnostic aid
record. |
VARCHAR2(255) |
NULL |
CACHE_CONTROL |
This table contains the information to control cache procedures in TPM. |
TABLE_KEY |
This column contains the primary key of the diagnostic aid that was altered. |
VARCHAR2(255) |
NOT NULL |
CACHE_CONTROL |
This table contains the information to control cache procedures in TPM. |
TABLE_NAME |
This column contains the name of the table that was changed to trigger an insert into
cache_control. |
VARCHAR2(30) |
NOT NULL |
CALL |
This table contains information for a TPM call. |
CALL_BEGIN_DATE |
This column contains the date on which the call began. |
DATE |
NOT NULL |
CALL |
This table contains information for a TPM call. |
CALL_BEGIN_TIME |
This column contains the time at which the call began. |
VARCHAR2(10) |
NOT NULL |
CALL |
This table contains information for a TPM call. |
CALL_END_DATE |
This column contains the date on which the call ended. |
DATE |
NOT NULL |
CALL |
This table contains information for a TPM call. |
CALL_END_TIME |
This column contains the time at which the call ended. |
VARCHAR2(10) |
NOT NULL |
CALL |
This table contains information for a TPM call. |
CALL_ID |
This column contains a unique identifier assigned by Tivoli Problem Management to the
call. This is a sequential eight-digit number left-padded with 0's. |
VARCHAR2(15) |
NOT NULL |
CALL |
This table contains information for a TPM call. |
CALLER_ID |
This column contains the ID of the person originating the call. |
VARCHAR2(15) |
NULL |
CALL |
This table contains information for a TPM call. |
CALLER_NAME |
|
VARCHAR2(40) |
NULL |
CALL |
This table contains information for a TPM call. |
CALLER_PHONE |
|
VARCHAR2(20) |
NULL |
CALL |
This table contains information for a TPM call. |
CREATOR_APP_ID |
|
VARCHAR2(15) |
NULL |
CALL |
This table contains information for a TPM call. |
FLX_CAL_DATE1 |
This column contains a date field for customization purposes. |
DATE |
NULL |
CALL |
This table contains information for a TPM call. |
FLX_CAL_DATE2 |
This column contains a date field for customization purposes. |
DATE |
NULL |
CALL |
This table contains information for a TPM call. |
FLX_CAL_INT1 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
CALL |
This table contains information for a TPM call. |
FLX_CAL_INT2 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
CALL |
This table contains information for a TPM call. |
FLX_CAL_INT3 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
CALL |
This table contains information for a TPM call. |
FLX_CAL_INT4 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
CALL |
This table contains information for a TPM call. |
FLX_CAL_TIME1 |
This column contains a time field for customization purposes. |
VARCHAR2(10) |
NULL |
CALL |
This table contains information for a TPM call. |
FLX_CAL_TIME2 |
This column contains a time field for customization purposes. |
VARCHAR2(10) |
NULL |
CALL |
This table contains information for a TPM call. |
FLX_CAL_VCHR1 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
CALL |
This table contains information for a TPM call. |
FLX_CAL_VCHR2 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
CALL |
This table contains information for a TPM call. |
FLX_CAL_VCHR3 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
CALL |
This table contains information for a TPM call. |
FLX_CAL_VCHR4 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
CALL |
This table contains information for a TPM call. |
LOCATION_ID |
This column contains the ID of the location originating the call. |
VARCHAR2(15) |
NULL |
CALL |
This table contains information for a TPM call. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
CALL |
This table contains information for a TPM call. |
ORGANIZATION_ID |
|
VARCHAR2(15) |
NULL |
CALL |
This table contains information for a TPM call. |
ORIGINATING_SITE |
|
VARCHAR2(6) |
NULL |
CALL |
This table contains information for a TPM call. |
PEOPLE_ID |
This column contains an identifier of the person associated with the call. |
NUMBER |
NULL |
CALL |
This table contains information for a TPM call. |
USER_ID |
This column contains the ID of the user taking the call. |
VARCHAR2(15) |
NOT NULL |
CALL_CODES |
This table contains information on TPM call codes. |
CALL_CODE |
This column contains the primary key as well as the text that appears in the call code
menu at runtime. |
VARCHAR2(15) |
NOT NULL |
CALL_CODES |
This table contains information on TPM call codes. |
CALL_ONLY |
This column contains a non-zero, indicating that Tivoli Problem Management should not
proceed to problem management when a call of this type is registered. For example,
inquiry calls are usually configured to not generate problem tickets. |
NUMBER |
NOT NULL |
CALL_CODES |
This table contains information on TPM call codes. |
DESCRIPTION |
This column contains a free-form text description explaining the use of the current
call code. |
VARCHAR2(1024) |
NULL |
CALL_CODES |
This table contains information on TPM call codes. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
CAUSE |
This table contains information on causes to be used with TPM problems. |
CAUSE_ID |
This column contains the unique short name of a problem's cause. |
VARCHAR2(25) |
NOT NULL |
CAUSE |
This table contains information on causes to be used with TPM problems. |
DESCRIPTION |
This column contains the description of a problem's cause. |
VARCHAR2(1024) |
NULL |
CAUSE |
This table contains information on causes to be used with TPM problems. |
MODIFY_DATETIME |
This column contains the time the cause was last updated. |
NUMBER |
NOT NULL |
COMPONENT |
See common data dictionary. |
COMPONENT_ID |
|
VARCHAR2(15) |
NOT NULL |
COMPONENT |
See common data dictionary. |
DESCRIPTION |
|
VARCHAR2(1024) |
NULL |
COMPONENT |
See common data dictionary. |
MODIFY_DATETIME |
|
NUMBER |
NOT NULL |
COMPONENT |
See common data dictionary. |
PROBLEM_TYPE |
|
VARCHAR2(15) |
NULL |
COMPONENT |
See common data dictionary. |
SYSTEM_ID |
|
VARCHAR2(15) |
NOT NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
ACTION |
This column contains an optional action (procedure name, executable command string) to
be performed whenever this common problem is activated. |
VARCHAR2(1024) |
NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
AID_ID |
This column contains a system-generated integer which serves as the unique primary
key. |
NUMBER |
NOT NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
AID_TITLE |
This column contains the diagnostic aid title. |
VARCHAR2(80) |
NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
AID_TYPE |
This column contains the type of diagnostic aid this row refers to. The
available diagnostic aid types are "COMMON','ERROR' and
'HOTNEWS'. |
VARCHAR2(25) |
NOT NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
DIAG_NODE |
This column contains a foreign key to the HYPERNODE table, which specifies which
diagnostic node to go to after this diagnostic aid has been applied. |
NUMBER |
NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
EVENT_BEGIN_DATE |
This column contains the date at which this event (specific to HotNews) is to begin. |
DATE |
NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
EVENT_BEGIN_TIME |
This column contains the time at which this event (specific to HotNews) is to begin. |
VARCHAR2(10) |
NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
EVENT_END_DATE |
This column contains the date at which this event (specific to HotNews) is to end. |
DATE |
NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
EVENT_END_TIME |
This column contains the time at which this event (specific to HotNews) is to end. |
VARCHAR2(10) |
NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
IS_GROUP |
This column contains 1 if the current row represents a diagnostic aid group, 0
otherwise. |
NUMBER |
NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
LOCATION_ID |
This column contains a foreign key to the LOCATIONS table, which specifies the
location at which this HotNews event is taking place. |
VARCHAR2(15) |
NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
PARENT_ID |
This column contains the ID of the group (if any) to which the current row belongs.
If this column is not null, it must contain the COMMON_ID of another row for which
the IS_GROUP column is non-zero. |
NUMBER |
NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
SOLUTION_COUNT |
This column contains the number of times this solution has been used to solve a
problem. |
NUMBER |
NULL |
DIAGNOSTIC_AID |
This table contains information for Common Problems, HotNews, and Error Messages. |
SOLUTION_ID |
This column contains a foreign key pointing to a SOLUTIONS table row, which represents
all the description / solution information for this diagnostic aid. |
NUMBER |
NOT NULL |
DICTIONARY |
This table contains words and synonyms for use with TPM diagnostics. |
MUST_BEGIN_WORD |
This column contains a Boolean flag for the ADL DLL that indicates whether to enforce
the beginning of a word. |
NUMBER |
NULL |
DICTIONARY |
This table contains words and synonyms for use with TPM diagnostics. |
MUST_END_WORD |
This column contains a Boolean flag for the ADL DLL that indicates whether to enforce
the end of a word. |
NUMBER |
NULL |
DICTIONARY |
This table contains words and synonyms for use with TPM diagnostics. |
SYNONYM_ID |
This column contains the word_id of the concept with which each record is related.
If the synonym_id equals the word_id then this entry is a concept. |
NUMBER |
NOT NULL |
DICTIONARY |
This table contains words and synonyms for use with TPM diagnostics. |
WORD |
This column contains the actual word as entered by the user. |
VARCHAR2(80) |
NOT NULL |
DICTIONARY |
This table contains words and synonyms for use with TPM diagnostics. |
WORD_ID |
This column contains the unique identifier (integral) for each word. |
NUMBER |
NOT NULL |
DISPATCH |
This table contains information on dispatched calls. |
CALL_ID |
This column contains the ID of the corresponding row in the CALL table. |
VARCHAR2(15) |
NOT NULL |
DISPATCH |
This table contains information on dispatched calls. |
DISPATCH_ID |
This column contains the ID of the user who took the call. |
NUMBER |
NOT NULL |
DISPATCH |
This table contains information on dispatched calls. |
DISPATCH_SITE |
This column contains the site ID that created the dispatch. |
VARCHAR2(6) |
NULL |
DISPATCH |
This table contains information on dispatched calls. |
DISPATCHER_ID |
This column contains the ID of the dispatcher who took the call. |
VARCHAR2(15) |
NOT NULL |
DISPATCH |
This table contains information on dispatched calls. |
GROUP_ID |
This column contains the ID of the group assigned to respond to the call. |
VARCHAR2(15) |
NULL |
DISPATCH |
This table contains information on dispatched calls. |
LINE_NUMBER |
This column contains the line number of the currently holding caller. |
VARCHAR2(15) |
NULL |
DISPATCH |
This table contains information on dispatched calls. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
DISPATCH |
This table contains information on dispatched calls. |
PROBLEM_ID |
This column contains the ID of the corresponding row in the PROBLEMS table. |
VARCHAR2(15) |
NULL |
DISPATCH |
This table contains information on dispatched calls. |
SESSION_ID |
This column contains the ID of the corresponding row in the SESSION table. |
NUMBER |
NOT NULL |
DISPATCH |
This table contains information on dispatched calls. |
TRANSFER_DATE |
This column contains the date on which this call was transferred. |
DATE |
NOT NULL |
DISPATCH |
This table contains information on dispatched calls. |
TRANSFER_DISPATCH |
This column contains an integer flag that specifies whether this row is a Call
Dispatch or Call Transfer. 0 = Call Dispatch, 1 = Call Transfer. |
NUMBER |
NOT NULL |
DISPATCH |
This table contains information on dispatched calls. |
TRANSFER_SITE |
This column contains the site ID to which the dispatch is transferred. |
VARCHAR2(6) |
NULL |
DISPATCH |
This table contains information on dispatched calls. |
TRANSFER_TIME |
This column contains time at which this call was transferred. |
VARCHAR2(10) |
NOT NULL |
DISPATCH |
This table contains information on dispatched calls. |
USER_ID |
This column contains the ID of the user assigned to respond to the call. |
VARCHAR2(15) |
NULL |
EA_TRANSITIONS |
This table contains information on transitions that occur in TPM. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
EA_TRANSITIONS |
This table contains information on transitions that occur in TPM. |
POST_ACTION |
This column contains the action to call after the transition has been completed.
Includes system executables or KML routines. |
VARCHAR2(254) |
NULL |
EA_TRANSITIONS |
This table contains information on transitions that occur in TPM. |
PRE_ACTION |
This column contains the action to call after the transition has been initiated.
Includes system executables or KML routines. |
VARCHAR2(254) |
NULL |
EA_TRANSITIONS |
This table contains information on transitions that occur in TPM. |
TRANSITION_ID |
This column contains the unique identifier for each transition. |
NUMBER |
NOT NULL |
EA_TRANSITIONS |
This table contains information on transitions that occur in TPM. |
TRANSITION_NAME |
This column contains the textual description of the transition. |
VARCHAR2(80) |
NOT NULL |
EACOLUMNS |
This table contains information on TPM columns, sequencing and aliases. |
COLUMN_ID |
This column contains a unique sequencing ID provided by Tivoli Problem Management. |
NUMBER |
NOT NULL |
EACOLUMNS |
This table contains information on TPM columns, sequencing and aliases. |
COLUMN_LABEL |
This column contains the alias of the column. |
VARCHAR2(20) |
NULL |
EACOLUMNS |
This table contains information on TPM columns, sequencing and aliases. |
COLUMN_NAME |
This column contains the name of the physical SQL column to be aliased. |
VARCHAR2(20) |
NULL |
EACOLUMNS |
This table contains information on TPM columns, sequencing and aliases. |
ISTERM |
This column contains non-zero value, indicating the "COLUMN_LABEL' is not
actually the alias name but the name of a global terminology variable whose value is to be
used as the alias. |
NUMBER |
NULL |
EACOLUMNS |
This table contains information on TPM columns, sequencing and aliases. |
TABLE_NAME |
This column contains the table name (if any) for which the alias is to apply. |
VARCHAR2(20) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
ACCESS_HOURS_MF |
This column contains the hours during which there is access to the customer location
Monday through Friday. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
ACCESS_HOURS_SA |
This column contains the hours during which there is access to the customer location
on Saturday. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
ACCESS_HOURS_SU |
This column contains the hours during which there is access to the customer location
on Sunday. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
ACTIVITY_CODE |
This column contains the subcode of the service code. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
ACTUAL_HOURS |
This column contains the actual time spent on the service call in hours and tenths of
hours. Travel time is not included in actual hours. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
AUTH_CODE |
This column contains the customer reference, PO number, and so on. |
VARCHAR2(20) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
AVAILABILITY_TIME |
This column contains the range in which the customer is available, given in the format
nHHMMHHMM, where n is the number of days from 0-6, the first HHMM is the beginning time,
and the second HHMM is the ending time. |
VARCHAR2(9) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
AVAILABLE_FLAG |
0-Customer is available 1-Customer is unavailable. |
VARCHAR2(1) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
BILLABLE_CODE |
This column contains the billable code for the service call. Valid billable codes are
as follows: 1 - potentially billable service; 3 - CE determined billable; 4 - CE
determined not billable |
VARCHAR2(1) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
BRANCH_OFFICE |
This column contains the only valid currently for TSS, used to build TIB record for
call screening data sent in on call record for BoB scheduler. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
CAD_PROBLEM |
This column contains the NSS CAD problem number associated with the service call. |
VARCHAR2(7) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
CALL_TYPE |
This column contains the task call flag. |
VARCHAR2(4) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
CERTIFICATION_1 |
This column contains the certification required to fix the problem. |
VARCHAR2(10) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
CERTIFICATION_2 |
This column contains the certification required to fix the problem. |
VARCHAR2(10) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
COMPLETION_CODE |
This column contains the completion code for the service call. The following are
codes used to determine the status of the service activity performed: C or 1 - activity
complete; A or 4 - other assistance given |
VARCHAR2(1) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
CONTACT_LOCATION |
This column contains the location of the machine that needs service. |
VARCHAR2(20) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
CONTACT_NAME |
This column contains the name of person to be contacted about the service requested.
This name should be used with customer contact location phone number and (optional)
customer contact phone number extension. |
VARCHAR2(17) |
NOT NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
CONTRACT_HOURS_MF |
This column contains the hours during which the contract says service is provided
Monday through Friday. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
CONTRACT_HOURS_SA |
This column contains the hours during which the contract says service is provided on
Saturday. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
CONTRACT_HOURS_SU |
This column contains the hours during which the contract says service is provided on
Sunday. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
CUSTOMER_ID |
This column contains the unique key for identifying ECI customers. |
NUMBER |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
CUSTOMER_PROBLEM |
This column contains the problem number the customer associates with the call.
This is NOT the TPM Problem_ID. |
VARCHAR2(10) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
DATE_RECEIVED |
This column contains the date the call was received from the customer in customer
time. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
DOCUMENT_NUMBER |
This column contains the QSAR document number. |
VARCHAR2(9) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
EMAIL_ADDRESS |
This column contains the e-mail address for IBM Intranet- or Internet-placed calls. |
VARCHAR2(128) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
EMPLOYEE_DIVISION |
This column contains the IBM employee division used for IBM internal Intranet call
placement. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
ENVIRONMENT_TRAIN |
This column contains the customer environment-specific training required to fix the
problem. |
VARCHAR2(12) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
ERROR_CODE |
This column contains the code set by ECI in returned interface records that indicates
the error that caused a rejection or informational return. |
CHAR(18) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
EXPECTED_DURATION |
This column contains the estimated time to fix. |
VARCHAR2(4) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
EXPENSES |
This column contains the CE's expenses with no decimal places. There are
five positions for dollars and two for [cents]. |
VARCHAR2(7) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
EXTENDED_SERIAL |
This column contains the extended serial number for OEM equipment. |
VARCHAR2(20) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
EXTERNAL_CONTRACT |
This column contains the OEM contract. |
VARCHAR2(11) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
FAILING_ELEMENT |
This column contains the Failing Element in a machine. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
FAILURE_ACTION |
This column contains the Failure/Action code. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
FAILURE_CODE |
This column contains the failure code entered on PT by CE. |
VARCHAR2(6) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
FIRST_PART_NUM |
This column contains the first part number used in resolution of the problem. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
FIRST_PART_QTY |
This column contains the quantity of first part numbers used. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
FOURTH_PART_NUM |
This column contains the fourth part number used in resolution of the problem. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
FOURTH_PART_QTY |
This column contains the quantity of fourth part numbers used. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
FUNCTION_CODE_1 |
This column contains the type of activity for a part. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
FUNCTION_CODE_2 |
This column contains the type of activity for a part. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
FUNCTION_CODE_3 |
This column contains the type of activity for a part. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
FUNCTION_CODE_4 |
This column contains the type of activity for a part. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
LOCATION_EXT |
This column contains the phone number extension for the contact location. |
VARCHAR2(5) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
LOCATION_PHONE |
This column contains the phone number at the location of service requested. |
VARCHAR2(10) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
MACHINE_TYPE |
This column contains the machine type that needs service. |
VARCHAR2(11) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
METER_READING |
This column contains the meter reading of serviced equipment. |
VARCHAR2(9) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
MFG_MODEL |
This column contains the description of the manufacturer/model of machine that was
serviced. |
VARCHAR2(19) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
MILEAGE |
This column contains the CE's mileage. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
MODEL |
This column contains the model number of a machine. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
NSS_AREA |
This column contains the area number of the NSS area where the call should reside. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
ON_SITE_PAYMENT |
This column contains the on-site payment required before rendering service. |
VARCHAR2(1) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
ORIGINATING_ID |
This column contains the unique call identifier that a customer uses to track the
service call. |
VARCHAR2(10) |
NOT NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
ORIGINATION_CODE |
This column contains the origination code used to identify the source of the service
call. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
OVERTIME_HOURS |
This column contains overtime hours in hours and tenths of hours. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PART_NUMBER |
This column contains the part number for a failing machine. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PART_NUMBER_1 |
This column contains the part number of the part needed to fix the problem. |
VARCHAR2(12) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PART_NUMBER_2 |
This column contains the part number of the part needed to fix the problem. |
VARCHAR2(12) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PART_NUMBER_3 |
This column contains the part number of the part needed to fix the problem. |
VARCHAR2(12) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PART_NUMBER_4 |
This column contains the part number of the part needed to fix the problem. |
VARCHAR2(12) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PENALTY |
This column indicates whether there is a penalty associated with this contract.
It takes value Y or N. |
VARCHAR2(1) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PLATFORM_TYPE_1 |
This column indicates whether the problem occurs on this type of platform. |
VARCHAR2(10) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PLATFORM_TYPE_2 |
This column indicates whether the problem occurs on this type of platform. |
VARCHAR2(10) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PRIORITY |
This column contains the priority for a call. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PROBABILITY_1 |
This column contains the probability that Part #1 will fix the problem. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PROBABILITY_2 |
This column contains the probability that Part #2 will fix the problem. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PROBABILITY_3 |
This column contains the probability that Part #3 will fix the problem. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PROBABILITY_4 |
This column contains the probability that Part #4 will fix the problem. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PROBLEM_ID |
This column contains the TPM Problem_ID associated with the ECI call. |
VARCHAR2(15) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PROBLEM_SEVERITY |
This column contains the problem severity indicator: Y - when the customer perception
of the problem is major or critical; N - when the customer perception of the problem is
NOT major or critical. |
VARCHAR2(1) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PRODUCT_CODE |
This column contains the product code. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PRODUCT_ERROR |
This column contains the Error Code given by a failing machine. |
VARCHAR2(16) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PRODUCT_LINE_1 |
This column contains the product line of hardware experiencing a problem. |
VARCHAR2(20) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
PRODUCT_LINE_2 |
This column contains the product line of hardware experiencing a problem. |
VARCHAR2(20) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
REFERENCE_AUTH |
This column contains the Customer Reference/Authorization field. |
VARCHAR2(15) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
REJECTED |
This column contains the flag that tells whether the record has been rejected by ECI. |
NUMBER |
NOT NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
RESOLUTION_DESC |
This column contains the description of problem resolution. |
VARCHAR2(70) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SATISFACTION |
This column contains the flag that indicates customer satisfaction with the fix.
This can have the value Y or N. |
VARCHAR2(1) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SECOND_PART_NUM |
This column contains the second part number used in resolution of the problem. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SECOND_PART_QTY |
This column contains the quantity of second part numbers used. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SERIAL_NUMBER |
This column contains the serial number of the machine to be serviced. This field
is conditionally required. For certain machine types, either this field or the
Special Bid Number must be provided. |
VARCHAR2(11) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SERVICE_CALL_TYPE |
This column contains the values as follows: 1 = deferred call (DF); 2 = first shift
call (AM); 3 = first AM call Monday through Friday (FA); 4 = vicinity call (VC). |
VARCHAR2(1) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SERVICE_CODE |
This column contains the type of work performed. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SERVICE_PROBLEM |
This column contains the provider of the service problem number. |
VARCHAR2(10) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SERVICE_RENDERED |
This column contains the service rendered or customer claimed flag. |
VARCHAR2(6) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SERVICE_REP |
This column contains the name of the service representative who will handle the
service call. |
VARCHAR2(15) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SKILL_TYPE_1 |
This column contains the skill type needed. |
VARCHAR2(10) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SKILL_TYPE_2 |
This column contains the skill type needed. |
VARCHAR2(10) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SPECIAL_BID |
This column contains the IBM Special Bid Number for a specific customer service.
This field is conditionally required. For certain machine types, either this
field or the Serial Number must be provided. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SPECIAL_PART |
This column contains the special parts needed flag. This takes the value Y or N. |
VARCHAR2(1) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
STOP_TIME |
This column contains the stop time for activity on the service call in hours and
tenths of hours. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
SYSTEM_TYPE |
This column contains the system type of machine to be serviced. |
VARCHAR2(16) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
TARGET_ARRIVAL |
This column contains the target arrival time, in hours and minutes of the maximum time
that the customer expects to have someone arrive at their location in response to the
service call. |
VARCHAR2(4) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
TERRITORY |
This column contains the territory assigned by IBM's National Service System. The
value for territory is defined by the service call dispatching system and is internally
maintained. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
THIRD_PART_NUM |
This column contains the third part number used in resolution of the problem. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
THIRD_PART_QTY |
This column contains the quantity of third part numbers used. |
VARCHAR2(2) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
TIME_RECEIVED |
This column contains the time the call was received from the customer in customer
time. |
VARCHAR2(6) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
TIME_ZONE |
This column contains one character code for ECI to identify the caller's time zone. |
VARCHAR2(1) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
TRAVEL_HOURS |
Travel hours spent on the service call in hours and tenths of hours. |
VARCHAR2(3) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
TSS_SEGMENT |
This column contains the TSS business segment. |
VARCHAR2(6) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
UPDATE_REQUEST |
This column contains the customer information update request for limited service
brokers only. This takes the following values: Y - when the service broker does not
have customer information in their database. A customer information record is sent
to the service broker if they are authorized for outbound customer record create. N - when
the service broker has customer information in their database. |
VARCHAR2(1) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
USER_IDENTIFIER |
This column contains the employee serial number for IBM internal Intranet-placed
service calls. |
VARCHAR2(8) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
VENDOR_1 |
This column contains the vendor of the hardware component. |
VARCHAR2(10) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
VENDOR_2 |
This column contains the vendor of the hardware component. |
VARCHAR2(10) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
VERIFIED_BY_NAME |
This column contains the name of customer who verified that service was complete. |
VARCHAR2(19) |
NULL |
ECI_CALL |
This table contains the information for handling an ECI call. |
VERIFIED_BY_PHONE |
This column contains the phone number of the customer who verified that service was
complete. |
VARCHAR2(10) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
ACCESS_HOURS_MF |
This column contains the hours during which there is access to the customer location
Monday through Friday. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
ACCESS_HOURS_SA |
This column contains the hours during which there is access to the customer location
on Saturday. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
ACCESS_HOURS_SU |
This column contains the hours during which there is access to the customer location
on Sunday. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
ACTIVITY_CODE |
This column contains the subcode of service cCode. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
ACTUAL_HOURS |
This column contains the actual hours spent on the service call in hours and tenths of
hours. Travel time is not included in actual hours. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
AUTH_CODE |
This column contains the customer reference, PO number, and so on. |
VARCHAR2(20) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
AVAILABILITY_TIME |
This column contains the range in which the customer is available, given in the format
nHHMMHHMM, where n is the number of days from 0-6, the first HHMM is the beginning time,
and the second HHMM is the ending time. |
VARCHAR2(9) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
AVAILABLE_FLAG |
0 - customer is available; 1 - customer is unavailable. |
VARCHAR2(1) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
BILLABLE_CODE |
This column contains the billable code for the service call. Valid billable codes are
as follows: 1 - potentially billable service; 3 - CE determined billable; 4 - CE
determined not billable. |
VARCHAR2(1) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
BRANCH_OFFICE |
This column contains the only valid currently for TSS, used to build TIB record for
call screening data sent in on call record for BoB scheduler. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
CAD_PROBLEM |
This column contains the NSS CAD problem number associated with the service call. |
VARCHAR2(7) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
CALL_TYPE |
This column contains the task call flag. |
VARCHAR2(4) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
CERTIFICATION_1 |
This column contains the certification required to fix the problem. |
VARCHAR2(10) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
CERTIFICATION_2 |
This column contains the certification required to fix the problem. |
VARCHAR2(10) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
COMPLETION_CODE |
This column contains the completion code for the service call. The following are
codes used to determine the status of the service activity performed: C or 1 - activity
complete; A or 4 - other assistance given. |
VARCHAR2(1) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
CONTACT_LOCATION |
This column contains the location of the machine that needs service. |
VARCHAR2(20) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
CONTACT_NAME |
This column contains the name of person to be contacted about the service requested.
This name should be used with customer contact location phone number and (optional)
customer contact phone number extension. |
VARCHAR2(17) |
NOT NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
CONTRACT_HOURS_MF |
This column contains the hours during which the contract says service is provided
Monday through Friday. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
CONTRACT_HOURS_SA |
This column contains the hours during which the contract says service is provided on
Saturday. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
CONTRACT_HOURS_SU |
This column contains the hours during which the contract says service is provided on
Sunday. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
CUSTOMER_ID |
This column contains the unique key for identifying ECI customers. |
NUMBER |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
CUSTOMER_PROBLEM |
This column contains the problem number the customer associates with the call.
This is NOT the TPM Problem_ID. |
VARCHAR2(10) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
DATE_RECEIVED |
This column contains the date the call was received from the customer in customer
time. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
DOCUMENT_NUMBER |
This column contains the QSAR document number. |
VARCHAR2(9) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
EMAIL_ADDRESS |
This column contains the e-mail address for IBM Intranet- or Internet-placed calls. |
VARCHAR2(128) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
EMPLOYEE_DIVISION |
This column contains the IBM employee division used for IBM internal Intranet call
placement. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
ENVIRONMENT_TRAIN |
This column contains the customer environment-specific training required to fix the
problem. |
VARCHAR2(12) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
ERROR_CODE |
This column contains the set in returned interface records that indicates the error
that causes rejection or informational return. |
VARCHAR2(4) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
EXPECTED_DURATION |
This column contains the estimated time to fix. |
VARCHAR2(4) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
EXPENSES |
This column contains the CE's expenses with no decimal places. There are
five positions for dollars and two positions for cents. |
VARCHAR2(7) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
EXTENDED_SERIAL |
This column contains the extended serial number for OEM equipment. |
VARCHAR2(20) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
EXTERNAL_CONTRACT |
This column contains the OEM contract. |
VARCHAR2(11) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
FAILING_ELEMENT |
This column contains the failing element in machine. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
FAILURE_ACTION |
This column contains the Failure/Action code. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
FAILURE_CODE |
This column contains the failure code entered on PT by CE. |
VARCHAR2(6) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
FIRST_PART_NUM |
This column contains the first part number used in resolution of the problem. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
FIRST_PART_QTY |
This column contains the quantity of first part numbers used. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
FOURTH_PART_NUM |
This column contains the fourth part number used in resolution of the problem. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
FOURTH_PART_QTY |
This column contains the quantity of fourth part numbers used. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
FUNCTION_CODE_1 |
This column contains the type of activity for a part. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
FUNCTION_CODE_2 |
This column contains the type of activity for a part. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
FUNCTION_CODE_3 |
This column contains the type of activity for a part. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
FUNCTION_CODE_4 |
This column contains the type of activity for a part. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
LOCATION_EXT |
This column contains the phone number extension for contact location phone number. |
VARCHAR2(5) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
LOCATION_PHONE |
This column contains the phone number at the location of service requested. |
VARCHAR2(10) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
MACHINE_TYPE |
This column contains the machine type that needs service. |
VARCHAR2(11) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
METER_READING |
This column contains the meter reading of serviced equipment. |
VARCHAR2(9) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
MFG_MODEL |
This column contains the description of the manufacturer/model of machine that was
serviced. |
VARCHAR2(19) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
MILEAGE |
This column contains the CE's mileage. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
MODEL |
This column contains the model number of machine. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
NSS_AREA |
This column contains the area number of the NSS area where the call should reside. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
ON_SITE_PAYMENT |
This column contains the on-site payment required before rendering service. |
VARCHAR2(1) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
ORIGINATING_ID |
This column contains the unique call identifier that the customer uses to track the
service call. |
VARCHAR2(10) |
NOT NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
ORIGINATION_CODE |
This column contains the origination code used to identify the source of the service
call. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
OVERTIME_HOURS |
This column contains overtime hours in hours and tenths of hours. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PART_NUMBER |
This column contains the part number for the failing machine. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PART_NUMBER_1 |
This column contains the part number of the part needed to fix the problem. |
VARCHAR2(12) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PART_NUMBER_2 |
This column contains the part number of the part needed to fix the problem. |
VARCHAR2(12) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PART_NUMBER_3 |
This column contains the part number of the part needed to fix the problem. |
VARCHAR2(12) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PART_NUMBER_4 |
This column contains the part number of part needed to fix the problem. |
VARCHAR2(12) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PENALTY |
This column indicates whether there is a penalty associated with this contract.
It takes value Y or N. |
VARCHAR2(1) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PLATFORM_TYPE_1 |
This column indicates whether the problem is occurs on this type of platform. |
VARCHAR2(10) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PLATFORM_TYPE_2 |
This column indicates whether the problem is occurs on this type of platform. |
VARCHAR2(10) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PRIORITY |
This column contains the priority for call. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PROBABILITY_1 |
This column contains the probability that Part #1 will fix the problem. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PROBABILITY_2 |
This column contains the probability that Part #2 will fix the problem. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PROBABILITY_3 |
This column contains the probability that Part #3 will fix the problem. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PROBABILITY_4 |
This column contains the probability that Part #4 will fix the problem. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PROBLEM_ID |
This column contains the TPM Problem_ID associated with the ECI call. |
VARCHAR2(15) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PROBLEM_SEVERITY |
This column contains the problem severity indicator: Y - when the customer perception
of the problem is major or critical; N - when the customer perception of the problem is
NOT major or critical. |
VARCHAR2(1) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PRODUCT_CODE |
This column contains the product code. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PRODUCT_ERROR |
This column contains the error code given by the failing machine. |
VARCHAR2(16) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PRODUCT_LINE_1 |
This column contains the product line of hardware experiencing a problem. |
VARCHAR2(20) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
PRODUCT_LINE_2 |
This column contains the product line of hardware experiencing a problem. |
VARCHAR2(20) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
REFERENCE_AUTH |
This column contains the Customer Reference/Authorization field. |
VARCHAR2(15) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
REJECTED |
This column contains the flag that tells whether the record has been rejected by ECI. |
NUMBER |
NOT NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
RESOLUTION_DESC |
This column contains the description of problem resolution. |
VARCHAR2(70) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SATISFACTION |
This column contains the flag for the customer being satisfied with the fix.
This can have the value Y or N. |
VARCHAR2(1) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SECOND_PART_NUM |
This column contains the second part number used in resolution of the problem. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SECOND_PART_QTY |
This column contains the quantity of second part numbers used. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SERIAL_NUMBER |
This column contains the serial number of the machine to be serviced. This field
is conditionally required. For certain machine types, either this field or the
Special Bid Number must be provided. |
VARCHAR2(11) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SERVICE_CALL_TYPE |
This column contains the values as follows: 1 = deferred call (DF); 2 = first shift
call (AM); 3 = first AM call Monday through Friday (FA); 4 = vicinity call (VC) |
VARCHAR2(1) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SERVICE_CODE |
This column contains the type of work performed. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SERVICE_PROBLEM |
This column contains the provider of service problem number. |
VARCHAR2(10) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SERVICE_RENDERED |
This column contains the service rendered or customer-claimed flag. |
VARCHAR2(6) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SERVICE_REP |
This column contains the name of the service representative who will handle the
service call. |
VARCHAR2(15) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SKILL_TYPE_1 |
This column contains the skill type needed. |
VARCHAR2(10) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SKILL_TYPE_2 |
This column contains the skill type needed. |
VARCHAR2(10) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SPECIAL_BID |
This column contains the IBM Special Bid Number for a specific customer service.
This field is conditionally required. For certain machine types, either this
field or the serial number must be provided. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SPECIAL_PART |
This column contains the special parts needed flag. This takes the value Y or N. |
VARCHAR2(1) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
STOP_TIME |
This column contains the stop time for activity on the service call in hours and
tenths of hours. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
SYSTEM_TYPE |
This column contains the system type of machine to be serviced. |
VARCHAR2(16) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
TARGET_ARRIVAL |
This column contains the target arrival time in hours and minutes of the maximum time
that the customer expects to have someone arrive at their location in response to the
service call. |
VARCHAR2(4) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
TERRITORY |
This column contains the territory assigned by IBM's National Service System. The
value for territory is defined by the service call dispatching system and is internally
maintained. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
THIRD_PART_NUM |
This column contains the third part number used in resolution of the problem. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
THIRD_PART_QTY |
This column contains the quantity of third part numbers used. |
VARCHAR2(2) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
TIME_RECEIVED |
This column contains the time the call was received from the customer in customer
time. |
VARCHAR2(6) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
TIME_ZONE |
This column contains one character code for ECI to identify the caller's time zone. |
VARCHAR2(1) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
TRAVEL_HOURS |
Travel hours spent on the service call in hours and tenths of hours. |
VARCHAR2(3) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
TSS_SEGMENT |
This column contains the TSS business segment. |
VARCHAR2(6) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
UPDATE_REQUEST |
This column contains the customer information update request for limited service
brokers only. This takes the following values: Y-when the service broker does not
have customer information in their database. A customer information record will be
sent to the service broker if they are authorized for outbound customer record create.
N-when the service broker has customer information in their database. |
VARCHAR2(1) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
USER_IDENTIFIER |
This column contains the employee serial number for IBM internal Intranet-placed
service calls. |
VARCHAR2(8) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
VENDOR_1 |
This column contains the vendor of the hardware component. |
VARCHAR2(10) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
VENDOR_2 |
This column contains the vendor of the hardware component. |
VARCHAR2(10) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
VERIFIED_BY_NAME |
This column contains the name of the customer who verified service was completed. |
VARCHAR2(19) |
NULL |
ECI_CALL_ARCH |
This table is for archiving ECI_CALL records. |
VERIFIED_BY_PHONE |
This column contains the phone number of the customer who verified service was
completed. |
VARCHAR2(10) |
NULL |
ECI_COMMENTS |
This table contains comments related to ECI calls |
COMMENTS |
This column contains the new or additional description of the problem requiring
service. |
VARCHAR2(230) |
NOT NULL |
ECI_COMMENTS |
This table contains comments related to ECI calls |
DATE_RECEIVED |
This column contains the date the comments were received in customer time. |
VARCHAR2(8) |
NULL |
ECI_COMMENTS |
This table contains comments related to ECI calls |
ERROR_CODE |
This column contains the error that caused rejection or informational return. |
VARCHAR2(4) |
NULL |
ECI_COMMENTS |
This table contains comments related to ECI calls |
ORIGINATING_ID |
This column contains the unique call identifier that the customer uses to track the
service call. Each set of comments is related to a call, and this indicates the key
of the call. |
VARCHAR2(10) |
NOT NULL |
ECI_COMMENTS |
This table contains comments related to ECI calls |
REJECTED |
This column contains the flag that tells whether a set of comments was rejected by
ECI. |
NUMBER |
NOT NULL |
ECI_COMMENTS |
This table contains comments related to ECI calls |
TIME_RECEIVED |
This column contains the time the comments were received in customer time. |
VARCHAR2(6) |
NULL |
ECI_COMMENTS_ARCH |
This table is used for archiving the ECI_COMMENTS table. |
COMMENTS |
This column contains the new or additional description of the problem requiring
service. |
VARCHAR2(230) |
NOT NULL |
ECI_COMMENTS_ARCH |
This table is used for archiving the ECI_COMMENTS table. |
DATE_RECEIVED |
This column contains the date the comments were received in customer time. |
VARCHAR2(8) |
NULL |
ECI_COMMENTS_ARCH |
This table is used for archiving the ECI_COMMENTS table. |
ERROR_CODE |
This column contains the error that caused rejection or informational return. |
VARCHAR2(4) |
NULL |
ECI_COMMENTS_ARCH |
This table is used for archiving the ECI_COMMENTS table. |
ORIGINATING_ID |
This column contains the unique call identifier that the customer uses to track the
service call. Each set of comments is related to a call, and this indicates the key
of the call. |
VARCHAR2(10) |
NOT NULL |
ECI_COMMENTS_ARCH |
This table is used for archiving the ECI_COMMENTS table. |
REJECTED |
This column contains the flag that tells whether a set of comments was rejected by
ECI. |
NUMBER |
NOT NULL |
ECI_COMMENTS_ARCH |
This table is used for archiving the ECI_COMMENTS table. |
TIME_RECEIVED |
This column contains the time the comments were received in customer time. |
VARCHAR2(6) |
NULL |
ECI_CUSTOMER |
This table contains the information for an ECI customer. |
CUSTOMER_ADDRESS |
This column contains the address of the customer. |
VARCHAR2(17) |
NOT NULL |
ECI_CUSTOMER |
This table contains the information for an ECI customer. |
CUSTOMER_CITY |
This column contains the city of the customer. |
VARCHAR2(8) |
NOT NULL |
ECI_CUSTOMER |
This table contains the information for an ECI customer. |
CUSTOMER_CONTRACT |
This column contains the type of service contract for the customer. |
VARCHAR2(6) |
NULL |
ECI_CUSTOMER |
This table contains the information for an ECI customer. |
CUSTOMER_EXT |
This column contains the phone number extension for customer phone number. |
VARCHAR2(5) |
NULL |
ECI_CUSTOMER |
This table contains the information for an ECI customer. |
CUSTOMER_ID |
This column contains the unique key for ECI customers used by TPM's ECI
integration. |
NUMBER |
NOT NULL |
ECI_CUSTOMER |
This table contains the information for an ECI customer. |
CUSTOMER_NAME |
This column contains the name of the customer. |
VARCHAR2(17) |
NOT NULL |
ECI_CUSTOMER |
This table contains the information for an ECI customer. |
CUSTOMER_PHONE |
This column contains the phone number of the customer requesting service, used to
create a call. |
VARCHAR2(10) |
NOT NULL |
ECI_CUSTOMER |
This table contains the information for an ECI customer. |
CUSTOMER_STATE |
This column contains the state abbreviation of the customer. |
VARCHAR2(2) |
NOT NULL |
ECI_CUSTOMER |
This table contains the information for an ECI customer. |
CUSTOMER_ZIP |
This column contains the zip code of the customer. |
VARCHAR2(9) |
NOT NULL |
ECI_ERROR_DESC |
This table contains ECI error codes and their descriptions. |
ERROR_CODE |
Set by ECI in returned interface records to indicate the error that caused rejection
or informational return. |
VARCHAR2(4) |
NOT NULL |
ECI_ERROR_DESC |
This table contains ECI error codes and their descriptions. |
ERROR_DESC |
This column contains the text description of an error code. |
VARCHAR2(254) |
NOT NULL |
ECI_MESSAGE |
This table contains messages from ECI that are unrelated to any ECI calls. |
MESSAGE |
This column contains messages from ECI that is unrelated to any particular call. |
LONG |
NOT NULL |
ECI_MESSAGE |
This table contains messages from ECI that are unrelated to any ECI calls. |
MESSAGE_ID |
This column contains the unique key used internally by TPM's ECI integration for
ECI messages that are unrelated to any particular call. |
NUMBER |
NOT NULL |
ECI_OUT_QUEUE |
This table contains messages that have been queued to be sent to ECI. |
MESSAGE |
This column contains the string encoded for transmission to ECI. |
LONG |
NOT NULL |
ECI_OUT_QUEUE |
This table contains messages that have been queued to be sent to ECI. |
QUEUE_ID |
This column contains the unique key used internally by TPM's ECI integration for
messages sent to ECI. |
NUMBER |
NOT NULL |
ECI_STATUS |
This table contains information on the status of ECI calls. |
DATE_RECEIVED |
This column contains the date the status was received in customer time. |
VARCHAR2(8) |
NOT NULL |
ECI_STATUS |
This table contains information on the status of ECI calls. |
ERROR_CODE |
This column is set by ECI in returned interface records to indicate the error that
caused rejection or informational return. |
VARCHAR2(4) |
NULL |
ECI_STATUS |
This table contains information on the status of ECI calls. |
ORIGINATING_ID |
This column contains the unique call identifier that the customer uses to track the
service call. Each set of comments is related to a call, and this indicates the key
of the call. |
VARCHAR2(10) |
NOT NULL |
ECI_STATUS |
This table contains information on the status of ECI calls. |
REJECTED |
This column contains the flag that tells whether the comments have been rejected by
ECI. |
NUMBER |
NOT NULL |
ECI_STATUS |
This table contains information on the status of ECI calls. |
STATUS_CODE |
This column contains the status code to apply to a call. |
VARCHAR2(2) |
NOT NULL |
ECI_STATUS |
This table contains information on the status of ECI calls. |
STATUS_DATE |
This column contains the customer status date in customer time. This field is
used to enter a future date to defer a call. For a customer, this is a defer (DF)
status. |
VARCHAR2(8) |
NULL |
ECI_STATUS |
This table contains information on the status of ECI calls. |
STATUS_TIME |
This column contains the customer status time in customer time. This field is
used to enter a future time to defer a call. For a customer, this is a defer (DF)
status. |
VARCHAR2(6) |
NULL |
ECI_STATUS |
This table contains information on the status of ECI calls. |
TIME_RECEIVED |
This column contains the time the status was received in customer time. |
VARCHAR2(6) |
NOT NULL |
ECI_STATUS_ARCH |
This table is used for archiving ECI_STATUS records |
DATE_RECEIVED |
This column contains the date the status was received in customer time. |
VARCHAR2(8) |
NOT NULL |
ECI_STATUS_ARCH |
This table is used for archiving ECI_STATUS records |
ERROR_CODE |
This column is set by ECI in returned interface records to indicate the error that
caused rejection or informational return. |
VARCHAR2(4) |
NULL |
ECI_STATUS_ARCH |
This table is used for archiving ECI_STATUS records |
ORIGINATING_ID |
This column contains the unique call identifier that the customer uses to track the
service call. Each set of comments is related to a call, and this indicates the key
of the call. |
VARCHAR2(10) |
NOT NULL |
ECI_STATUS_ARCH |
This table is used for archiving ECI_STATUS records |
REJECTED |
This column contains the flag that tells whether the comments have been rejected by
ECI. |
NUMBER |
NOT NULL |
ECI_STATUS_ARCH |
This table is used for archiving ECI_STATUS records |
STATUS_CODE |
This column contains the Status Code to apply to call. |
VARCHAR2(2) |
NOT NULL |
ECI_STATUS_ARCH |
This table is used for archiving ECI_STATUS records |
STATUS_DATE |
This column contains the customer status date in customer time. This field is
used to input a future date to defer a call for a reason. For a customer, this would
be a defer (DF) status. |
VARCHAR2(8) |
NULL |
ECI_STATUS_ARCH |
This table is used for archiving ECI_STATUS records |
STATUS_TIME |
This column contains the customer status time in customer time. This field is
used to input a future time to defer a call for a reason. For a customer, this would
be a defer (DF) status. |
VARCHAR2(6) |
NULL |
ECI_STATUS_ARCH |
This table is used for archiving ECI_STATUS records |
TIME_RECEIVED |
This column contains the time the status was received in customer time. |
VARCHAR2(6) |
NOT NULL |
ECI_STATUS_DESC |
This table contains descriptions for ECI status codes. |
STATUS_CODE |
This column contains the status code to apply to a call. |
VARCHAR2(2) |
NOT NULL |
ECI_STATUS_DESC |
This table contains descriptions for ECI status codes. |
STATUS_DESC |
This column contains the text description of a status code. |
VARCHAR2(254) |
NOT NULL |
EMA_ADMINISTRATORS |
This table controls the setup for EMA administrators |
ADMINACTIVE |
This column indicates whether or not the administrator is active or not. |
VARCHAR2(15) |
NULL |
EMA_ADMINISTRATORS |
This table controls the setup for EMA administrators |
ADMINADDRESSTYPE |
This column is no longer used. |
NUMBER |
NULL |
EMA_ADMINISTRATORS |
This table controls the setup for EMA administrators |
ADMINCOMMENT |
This column contains any comments about the administrator. |
VARCHAR2(128) |
NULL |
EMA_ADMINISTRATORS |
This table controls the setup for EMA administrators |
ADMINMAILACCOUNT |
This column contains the e-mail address of the administrator. |
VARCHAR2(128) |
NOT NULL |
EMA_ADMINISTRATORS |
This table controls the setup for EMA administrators |
ADMINMAILADDRESS |
This column is no longer used. |
VARCHAR2(254) |
NULL |
EMA_ADMINISTRATORS |
This table controls the setup for EMA administrators |
SERVERID |
This column contains the server id. |
NUMBER |
NULL |
EMA_ADMINISTRATORS |
This table controls the setup for EMA administrators |
SPAREINT |
This column is no longer used. |
NUMBER |
NULL |
EMA_DIALOG_ATTRIBS |
This table contains information on Tivoli Mail Gateway attributes and their values. |
ATTRIBUTENAME |
This column contains the name of the attribute on the corresponding dialog box. |
VARCHAR2(32) |
NOT NULL |
EMA_DIALOG_ATTRIBS |
This table contains information on Tivoli Mail Gateway attributes and their values. |
ATTRIBUTEVALUE |
This column contains the value of the given attribute. |
VARCHAR2(254) |
NULL |
EMA_DIALOG_ATTRIBS |
This table contains information on Tivoli Mail Gateway attributes and their values. |
DIALOGNAME |
This column contains the name of the dialog box on which this attribute is found. |
VARCHAR2(32) |
NOT NULL |
EMA_DIALOG_ATTRIBS |
This table contains information on Tivoli Mail Gateway attributes and their values. |
EMASERVERGROUP |
This column contains the Tivoli Mail Gateway server group integer. |
NUMBER |
NULL |
EMA_DIALOG_ATTRIBS |
This table contains information on Tivoli Mail Gateway attributes and their values. |
INT1 |
This column is no longer used. |
NUMBER |
NULL |
EMA_DIALOG_ATTRIBS |
This table contains information on Tivoli Mail Gateway attributes and their values. |
INT2 |
This column is no longer used. |
NUMBER |
NULL |
EMA_STATS |
This table contains statistics on EMA command usage. |
EMASERVERGROUP |
This column contains the EMA server group integer. |
NUMBER |
NULL |
EMA_STATS |
This table contains statistics on EMA command usage. |
SPAREINT |
This column is no longer used. |
NUMBER |
NULL |
EMA_STATS |
This table contains statistics on EMA command usage. |
STATISTICNAME |
This column contains the command name the STATISTICVALUE corresponds to. |
VARCHAR2(32) |
NOT NULL |
EMA_STATS |
This table contains statistics on EMA command usage. |
STATISTICVALUE |
This column contains the number of times this command has been used. |
NUMBER |
NULL |
EV_FAILED_NODES |
This table contains one record for each network node with at least one failed
interface. When all failed interfaces in a node are restored to full operation, then
the record for that node is removed from the EV_FAILED_NODES table. |
CALL_ID |
This column contains the ID of the call associated with this failure instance of the
node. |
CHAR(15) |
NULL |
EV_FAILED_NODES |
This table contains one record for each network node with at least one failed
interface. When all failed interfaces in a node are restored to full operation, then
the record for that node is removed from the EV_FAILED_NODES table. |
EXT_PROB_ID |
This column contains the name/number of an external trap or event associated with this
node failure. |
VARCHAR2(40) |
NULL |
EV_FAILED_NODES |
This table contains one record for each network node with at least one failed
interface. When all failed interfaces in a node are restored to full operation, then
the record for that node is removed from the EV_FAILED_NODES table. |
FAULT_IMPACT |
This column contains test descriptions of the impact this node has on the network. |
VARCHAR2(254) |
NULL |
EV_FAILED_NODES |
This table contains one record for each network node with at least one failed
interface. When all failed interfaces in a node are restored to full operation, then
the record for that node is removed from the EV_FAILED_NODES table. |
FAULT_IMPACT_LONG |
This column contains storage for fault impact in cases where the string is
longer than 254 characters. |
LONG |
NULL |
EV_FAILED_NODES |
This table contains one record for each network node with at least one failed
interface. When all failed interfaces in a node are restored to full operation, then
the record for that node is removed from the EV_FAILED_NODES table. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NULL |
EV_FAILED_NODES |
This table contains one record for each network node with at least one failed
interface. When all failed interfaces in a node are restored to full operation, then
the record for that node is removed from the EV_FAILED_NODES table. |
NODE_NAME |
This column contains the name of the node that contains the failing interface. |
VARCHAR2(80) |
NOT NULL |
EV_FAILED_NODES |
This table contains one record for each network node with at least one failed
interface. When all failed interfaces in a node are restored to full operation, then
the record for that node is removed from the EV_FAILED_NODES table. |
PROB_MOD_DATETIME |
This column contains information that tracks the MODIFY_DATETIME column of the PROBLEM
record associated with the EV_FAILED_NODES record so that "callback" procedures
can determine when a modification to the PROBLEM record has occurred. The column is
populated initially when the EV_FAILED_NODES record is created. The MODIFY_DATETIME
column of the PROBLEM record is then read by the EV_CheckForCallback procedure and
compared to the MODIFY_DATETIME column of the PROBLEM record to determine if a
"callback" procedure should be initiated. This column is updated by the
EV_CheckFor Callbk procedure if the MODIFY_DATETIME column of the PROBLEM record has been
updated. |
NUMBER |
NULL |
EV_FAILED_NODES |
This table contains one record for each network node with at least one failed
interface. When all failed interfaces in a node are restored to full operation, then
the record for that node is removed from the EV_FAILED_NODES table. |
PROBLEM_ID |
This column contains the ID of the problem ticket associated with this failure
instance of the node. |
CHAR(15) |
NULL |
EV_FAILED_NODES |
This table contains one record for each network node with at least one failed
interface. When all failed interfaces in a node are restored to full operation, then
the record for that node is removed from the EV_FAILED_NODES table. |
PROBLEM_TIME |
This column contains a timestamp for the time that the last problem ticket was opened
for this node. This value is used to determine if a node's problem ticket
should be compressed. |
NUMBER |
NULL |
EV_FAILED_NODES |
This table contains one record for each network node with at least one failed
interface. When all failed interfaces in a node are restored to full operation, then
the record for that node is removed from the EV_FAILED_NODES table. |
TRAP_COUNT |
This column contains the number of traps received for the node. |
NUMBER |
NULL |
EV_FAILED_NODES |
This table contains one record for each network node with at least one failed
interface. When all failed interfaces in a node are restored to full operation, then
the record for that node is removed from the EV_FAILED_NODES table. |
TRAP_NAME |
This column contains the type/name of trap received by the node. |
VARCHAR2(80) |
NOT NULL |
EV_ICONS |
This table contains information related to the icons that are used with Expert View
Application. |
EV_ICON_ID |
This column contains a unique ID for the icon. |
CHAR(20) |
NOT NULL |
EV_ICONS |
This table contains information related to the icons that are used with Expert View
Application. |
ICON_FILE |
This column contains the name of the .ICO icon file to be displayed if the action is
used on the icon bar. |
VARCHAR2(80) |
NOT NULL |
EV_ICONS |
This table contains information related to the icons that are used with Expert View
Application. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NULL |
EV_ICONS |
This table contains information related to the icons that are used with Expert View
Application. |
TOOL_TIP_TEXT |
This column contains textual description of the icon. |
VARCHAR2(80) |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
AUTO_UPDATE |
This column contains a value indicating whether to send updates to the contact and
location from SNMP. |
NUMBER |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
CONFIG_GROUP_NAME |
This column contains information used as key values to access the EV_PROBLEM_CONFIG
record. If these fields are defined, then an EV_PROBLEM_CONFIG record exists and
defines problem configuration data for this node record. This data overrides data in
EV_SYS_CONFIG when a problem ticket is opened, closed, or updated. |
VARCHAR2(40) |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
CONFIG_OBJECT_NAME |
This column contains information used as key values to access the EV_PROBLEM_CONFIG
record. If these fields are defined, then an EV_PROBLEM_CONFIG record exists and
defines problem configuration data for this node record. This data overrides data in
EV_SYS_CONFIG when a problem ticket is opened, closed, or updated. |
VARCHAR2(40) |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
CREATE_DATETIME |
This column contains a timestamp indicating when the record was created. This is
used for query purposes. |
NUMBER |
NOT NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
ESCALATED |
This column contains a value indicating whether the problem ticket specified in
PROBLEM_ID has already been escalated by TPM Network System Management. |
NUMBER |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
FAULT_IMPACT |
This column describes how a link down event for this node affects the network. |
VARCHAR2(254) |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
FAULT_IMPACT_LONG |
This column contains fault impact information when the description is longer than 254
characters. |
LONG |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
IS_MANAGED_BY_EV |
This column contains information used to track the managed status of a node.
This is only used for NMP interfaces where this field cannot be stored in the NMP
database. |
NUMBER |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
NODE_LOCATION |
This column contains the location of the node. |
VARCHAR2(80) |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
NODE_NAME |
This column contains the IP name of the node. |
VARCHAR2(80) |
NOT NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
NOTIFY_ON_CLOSE |
This column contains a value indicating whether to send TPM notification when TPM
Network System Management closes a problem ticket for this node. |
NUMBER |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
NOTIFY_ON_OPEN |
This column contains a value indicating whether to send TPM notification when TPM
Network System Management opens a problem ticket for this node. |
NUMBER |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
PROBLEM_ID |
This column contains the problem ID of the last problem ticket opened for this node. |
CHAR(15) |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
PROBLEM_TIME |
This column contains a timestamp for the time that the last problem ticket was opened
for this node. This value is used to determine if a node's problem ticket
should be compressed. |
NUMBER |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
SEVERITY |
This column contains the severity to use with problem tickets for this node. |
NUMBER |
NULL |
EV_NODE_INFO |
This table contains one record for each network node that TPM Network System
Management has ever monitored. Records in this table contain all the attributes that
can be specific to a node. |
SYS_CONTACT |
This column contains the contact for the node. |
VARCHAR2(80) |
NULL |
EV_NODE_SOLUTION |
This table contains one record for each link between a network node and a TPM Hot News
solution. This table supports the Network News Links features. When the TPM
Network System Management Gateway Module opens a problem ticket for a node, the
Gateway searches the EV_NODE_SOLUTION table to find any TPM Host News records that should
be activated. When a node comes up, the Gateway again searches the EV_NODE_SOLUTION
table to deactivate any TPM Hot News records associated with the node. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NULL |
EV_NODE_SOLUTION |
his table contains one record for each link between a network node and a TPM Hot News
solution. This table supports the Network News Links features. When the TPM
Network System Management Gateway Module opens a problem ticket for a node, the
Gateway searches the EV_NODE_SOLUTION table to find any TPM Host News records that should
be activated. When a node comes up, the Gateway again searches the EV_NODE_SOLUTION
table to deactivate any TPM Hot News records associated with the node. |
NODE_NAME |
This column contains the IP name of node related to the SOLUTION_ID. |
VARCHAR2(80) |
NOT NULL |
EV_NODE_SOLUTION |
his table contains one record for each link between a network node and a TPM Hot News
solution. This table supports the Network News Links features. When the TPM
Network System Management Gateway Module opens a problem ticket for a node, the
Gateway searches the EV_NODE_SOLUTION table to find any TPM Host News records that should
be activated. When a node comes up, the Gateway again searches the EV_NODE_SOLUTION
table to deactivate any TPM Hot News records associated with the node. |
SOLUTION_ID |
This column contains the ID of Hot News solution record to which NODE_NAME is tied. |
NUMBER |
NOT NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
AUTO_COMPRESS_INTR |
This column contains the problem compression interval. |
NUMBER |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
AUTO_ESCALATE_FREQ |
This column contains the number of times that a problem must occur within
AUTO_COMPRESS_INTR minutes before the problem ticket is escalated. |
NUMBER |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
CALL_CODE |
This column contains call code to use for TPM Network System Management calls. |
CHAR(15) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
CBK_CLOSE_HOST |
This column contains the name of computer system to which a callback notification is
sent when a problem is closed. |
VARCHAR2(80) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
CBK_OPEN_HOST |
This column contains the name of computer system to which a callback notification is
sent when a problem is opened. |
VARCHAR2(80) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
CBK_UPDATE_HOST |
This column contains the name of computer system to which a callback notification is
sent when a problem is updated. |
VARCHAR2(80) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
CLOSE_CODE |
This column contains the problem code to use for a ticket when the node is restored to
service. |
CHAR(15) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
COMPONENT |
This column contains the component for TPM Network System Management problem tickets. |
CHAR(15) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
CONFIG_GROUP_NAME |
This column contains the name of the node or managed object. |
VARCHAR2(40) |
NOT NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
CONFIG_OBJECT_NAME |
This column contains the name of the node or managed object. |
VARCHAR2(40) |
NOT NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
DEFAULT_SEVERITY |
This column contains the severity to be set for newly discovered nodes. |
NUMBER |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
DIAG_HOST |
This column contains the network management platform host on which EVQueryd is
running. This name is used for node status queries. |
VARCHAR2(80) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
EV_DEF_CONTACT |
This column contains the default contact for newly discovered nodes. |
CHAR(15) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
EV_DEF_LOCID |
This column contains the default location for newly discovered nodes. |
CHAR(15) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
EV_PROB_TYPE |
This column contains the default problem type for problem tickets used when System and
Component yield no valid problem type. |
CHAR(15) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
GATE_USERID |
This column contains the TPM user ID to use in problem tickets logged by TPM Network
System Management. |
CHAR(15) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
ITEM |
This column contains the item for TPM Network System Management problem tickets. |
CHAR(15) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
PROBCLS_CALLBK_FN |
This column contains the name of user-specified TSD Script function or remote command
to call when a problem is closed in the TSD System Administration database.
This function's intended purpose is to notify an external problem management
system of changes that occur within TPM for objects that are being managed by the external
system. Problem closures that initiate the calling of the function name stored in this
column may be the result of TPM NSM Commands, or a TPM action, or a TSD action. For such a
problem close callback notification to be initiated, the closed problem must have been
originally opened through the ExpertView Gateway. |
VARCHAR2(255) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
PROBOPEN_CALLBK_FN |
This column contains the name of the user-specified TSD Script function or remote
command to call when a problem is opened through TPM NSM Commands. This function's
intended purpose is to notify an external problem management system of changes that occur
within TPM for objects that are managed by the external system. |
VARCHAR2(255) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
PROBUPD_CALLBK_FN |
This column contains the name of the user-specified TSD Script function or remote
command to call when a problem is updated through TPM NSM Commands. This
function's intended purpose is to notify an external problem management system of
changes that occur within TPM for objects that are managed by the external system. Problem
updates that initiate the calling of the function name stored in this column may be the
result of TPM NSM Commands, or a TPM action, or a TSD action. |
VARCHAR2(255) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
SYSTEM |
This column contains the system for TPM Network System Management problem tickets. |
CHAR(15) |
NULL |
EV_PROBLEM_CONFIG |
This table contains problem configuration data similar to the data found in the
EV_SYSTEM_CONFIG table. The data in EV_PROBLEM_CONFIG is maintained for a specific node or
managed object. The EV_PROBLEM_CONFIG will have zero or more rows. The rows in
this table are optional and exist only when the Gateway Administrator chooses to create a
problem configuration record as an optional step in editing an EV_NODE_INFO record.
When a problem is opened, closed, or updated, a message is received by TPM NSM
Commands, and the EV_PROBLEM_CONFIG table is searched to determine if a configuration
record exists for the node for which a problem action message is received. If an
EV_PROBLEM_CONFIG row is found for the specified node, then any non-NULL columns in the
selected row are used as priority over the same columns from the EV_SYS_CONFIG table. |
TRAP_GROUP_NAME |
This column contains the default trap group name used by problem tickets opened by the
EVTrap command. |
VARCHAR2(80) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
AUTO_COMPRESS_INTR |
This column contains the problem compression interval. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
AUTO_ESCALATE_FREQ |
This column contains the number of times that a problem must occur with
AUTO_COMPRESS_INTR minutes before the problem ticket is escalated. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
BEEPONERR |
This column contains a Boolean flag indicating whether TPM NSM Commands should beep
when error messages are logged. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
CALL_CODE |
This column contains the call code to use for TPM Network System Management calls. |
CHAR(15) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
CBK_CLOSE_HOST |
This column contains the name of the computer system to which a callback notification
is sent when a problem is closed. |
VARCHAR2(80) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
CBK_MIN_INTERVAL |
This column contains a value that is used to determine how frequently the Gateway
should check for changes in problem ticket status that may result in the performing of a
callback function. This value must be a positive integer for callbacks to be checked
and performed. This field also controls whether the status of problem ticket changes is
detected in the Gateway and causes the Gateway to update its EV_FAILED_NODES table. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
CBK_OPEN_HOST |
This column contains the name of the computer system to which a callback notification
is sent when a problem is opened. |
VARCHAR2(80) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
CBK_UPDATE_HOST |
This column contains the name of computer system to which a callback notification is
sent when a problem is updated. |
VARCHAR2(80) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
CLOSE_CODE |
This column contains the problem code to use for a ticket when the node is restored to
service. |
CHAR(15) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
COMPONENT |
This column contains the component for TPM Network System Management problem tickets. |
CHAR(15) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
COUNTER_CACHE_SIZE |
This column contains information used when working with Expert Advisor versions 2.x,
3.0.1 and 3.1.x to determine how many "COUNTER" values to allocate when
accessing the Expert Advisor COUNTERS table. The values retrieved from this table
are used to generate unique values for creating PROBLEM and CALL record ID key values.
Setting this field to a positive integer will result in better performance, as the
COUNTERS table will have to be accessed frequently. However, setting this value to
high can be a wasteful if the Gateway is terminated with a large number of allocated but
unused COUNTER values. When working with Expert Advisor 3.5 and/or DDM the counter caching
function supplied with Expert Advisor is used. In this situation, any value entered
in this field is ignored. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
DEFAULT_SEVERITY |
This column contains default severity to be set for newly discovered nodes. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
DIAG_HOST |
This column contains the network management platform host on which EVQueryd runs.
This name is used for node status queries. |
VARCHAR2(80) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
EA_LOGIN_REQUIRED |
Not used. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
EV_DEF_CONTACT |
This column contains the default contact for newly discovered nodes. |
CHAR(15) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
EV_DEF_LOCID |
This column contains the default location ID for newly discovered nodes. |
CHAR(15) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
EV_PROB_TYPE |
This column contains the default problem type for problem tickets used when System and
Component yield no valid problem type. |
CHAR(15) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
EV_SYS_NAME |
This column contains a unique key for the EV_SYS_CONFIG record. At present,
there is only one instance of the EV_SYS_CONFIG record in the database. |
CHAR(40) |
NOT NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
EVCBK_PARSE_WARN |
This column contains a Boolean flag indicating whether to treat errors in the
specification of callback remote commands as errors or warnings. By default, if an
error is encountered when parsing the callback remote command name, then the callback
remote command name is not accepted. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
EVPRB_ARG_TERMINAT |
This column contains the character that the Gateway looks for to mark the end of data
for a PROBLEM_VIEW column. The column name/data pairs of information are provided on
the command line of the EVProb UNIX command and are interpreted by the Gateway for parsing
into column name data for storage in TPM's PROBLEM_VIEW database.
The default value of the EVPROB_ARG_TERMINATOR character is a semi-colon(;). |
CHAR(1) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
EVPRB_PARSE_WARN |
This column contains a Boolean flag indicating whether to treat errors in the
specification of PROBLEM_VIEW column as fatal errors or only as warnings. By
default, if an incorrect column name is specified to the Gateway through EVProb, the
Gateway rejects the entire "open", "close", and "update"
operation requested by EVProb. By setting this Boolean column to "TRUE",
(by checking this item on the screen checkbox), incorrect column names are ignored and
default data is used for any unspecific or incorrect column names. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
GATE_USERID |
This column contains the TPM ID to use in problem tickets logged by TPM Network System
Management. |
CHAR(15) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
ITEM |
This column contains the item for TPM Network System Management problem tickets. |
CHAR(15) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
LIST_CACHE_ON |
This column contains a Boolean flag indicating whether certain record lists maintained
by the Gateway should be cached in memory. By default, all data is cached in memory
for performance. The record lists cached in the current release include a list of
location ID values that correspond to NMP host names and problem configuration
records, (EV_PROBLEM_CONFIG). If a large number of EV_PROBLEM_CONFIG records exist,
or if memory is scarce, then this flag may be set to FALSE using an SQL command tool. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
LOGALARMTARGET |
This column contains the target for error notification of LOGTOALARM is TRUE. |
CHAR(15) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
LOGFILENAME |
This column contains the file name for error messages if LOGTOFILE is TRUE. |
VARCHAR2(255) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
LOGTOALARM |
This column contains a Boolean flag indicating whether errors should cause a TPM
notification to be sent. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
LOGTOFILE |
This column contains a Boolean flag indicating whether TPM NSM Commands should write
error messages to LOGFILENAME. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
LOGTOWIN |
This column contains a Boolean flag indicating whether error messages should be
written to a scrollable window. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
MAXLOGFILELINES |
This column contains the maximum number of lines in the errorlog file. The file is
cleared when that number of lines are written to it. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
MAXWINLINES |
This column contains the maximum number of lines in the errorlog window. The
window will "scroll" the buffer to maintain the newest line. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
NOTIFY_ON_CLOSE |
This column contains a Boolean flag indicating whether to notify on restore with a
checkbox setting for newly discovered nodes. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
NOTIFY_ON_OPEN |
This column contains a Boolean flag indicating whether to notify on failure with a
checkbox setting for newly discovered nodes. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
PEOPLE_ID_CALLER |
|
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
PROBCLS_CALLBK_FN |
This column contains the name of a user-specified TSD Script function or remote
command to call when a problem is closed in the TPM database. This function's
purpose is to notify an external problem management system of changes that occur within
TPM for objects that are managed by the external system. Problem closures that initiate
the calling of the function named stored in this column may be the result of TPM NSM
Commands, or TPM actions, or TSD actions. For such a problem close callback notification
to be initiated, the close problem must have been originally opened through TPM NSM
Commands. |
VARCHAR2(255) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
PROBOPEN_CALLBK_FN |
This column contains the name of user-specified TSD Script function or remote command
to call when a problem is opened through TPM NSM Commands. This function's purpose is
to notify an external problem management system of changes that occur within TPM for
objects that are being managed by the external system. |
VARCHAR2(255) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
PROBUPD_CALLBK_FN |
This column contains the name of the user-specified TSD Script function or remote
command to call when a problem is updated in the TPM database. This function's
purpose is to notify an external problem management system of changes that occur within
TPM for objects that are being managed by the external system. Problem updates that
initiate the calling of the function name stored in this column may be the result of TPM
NSM Commands, or TPM actions, or TSD actions. For such problem close callback notification
to be initiated, the closed problem must have been originally opened through TPM NSM
Commands. |
VARCHAR2(255) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
SYSTEM |
This column contains the system for TPM Network System Management problem tickets. |
CHAR(15) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
TRAP_GROUP_NAME |
This column contains the system default trap group name used by problem tickets opened
by the EVTrap command. |
VARCHAR2(80) |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
UPDATE_ON_DISCOVER |
This column contains a Boolean field indicating whether to update from the SNMP
checkbox setting for newly discovered nodes. |
NUMBER |
NULL |
EV_SYS_CONFIG |
This table contains the TPM Network System Management configuration. TPM NSM
retrieves one record for this table at start-up to determine configuration values.
If the table contains multiple rows, TPM NSM uses only one row for configuration
values. The row used depends on your DBMS configuration. |
USER_GROUP_TYPE |
This column indicates whether LOGALARMTARGET is a user or a group in TPM. |
NUMBER |
NULL |
EV_TRAP_DEFS |
This table contains the external trap name definitions and associates those trap names
with problem ticket actions. A trap name sent by the EVTrap command to the Gateway
must be defined in the EV_TRAP_DEFS table to successfully open, update or close a problem
ticket. |
INVERSE_TRAP_NAME |
This column contains the name of the trap that performs the opposite problem ticket
action to this trap. Note that many traps can have the same trap name as their
inverse trap name. |
VARCHAR2(80) |
NULL |
EV_TRAP_DEFS |
This table contains the external trap name definitions and associates those trap names
with problem ticket actions. A trap name sent by the EVTrap command to the Gateway
must be defined in the EV_TRAP_DEFS table to successfully open, update or close a problem
ticket. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NULL |
EV_TRAP_DEFS |
This table contains the external trap name definitions and associates those trap names
with problem ticket actions. A trap name sent by the EVTrap command to the Gateway
must be defined in the EV_TRAP_DEFS table to successfully open, update or close a problem
ticket. |
PROBLEM_ACTION |
This column contains the problem ticket action to perform when this defined tap is
received by the Gateway. The valid values are OPEN or CLOSE. If a problem is
already open, and the same trap is subsequently received, then the OPEN action
functions as an update. |
CHAR(15) |
NULL |
EV_TRAP_DEFS |
This table contains the external trap name definitions and associates those trap names
with problem ticket actions. A trap name sent by the EVTrap command to the Gateway
must be defined in the EV_TRAP_DEFS table to successfully open, update or close a problem
ticket. |
TRAP_NAME |
This column contains the name of the trap. |
VARCHAR2(80) |
NOT NULL |
EV_TRAP_GROUPS |
This table contains different trap definitions (as created in the EV_TRAP_DEFS table)
to be grouped together for the purpose of consolidating and minimizing the number of
problem tickets opened by traps sent to the Gateway from EVTrap command. |
GROUP_NAME |
This column contains the name of the trap group. |
VARCHAR2(80) |
NOT NULL |
EV_TRAP_GROUPS |
This table contains different trap definitions (as created in the EV_TRAP_DEFS table)
to be grouped together for the purpose of consolidating and minimizing the number of
problem tickets opened by traps sent to the Gateway from EVTrap command. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NULL |
EV_TRAP_GROUPS |
This table contains different trap definitions (as created in the EV_TRAP_DEFS table)
to be grouped together for the purpose of consolidating and minimizing the number of
problem tickets opened by traps sent to the Gateway from EVTrap command. |
TRAP_NAME |
This column contains the name of the trap belonging to the trap group. |
VARCHAR2(80) |
NOT NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
A_COMPONENT_FLAG |
If 1, component level in SCIM is visible to anonymous users. |
NUMBER |
NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
A_ITEM_FLAG |
If 1, item level in SCIM is visible to anonymous users. |
NUMBER |
NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
A_MODULE_FLAG |
If 1, module level in SCIM is visible to anonymous users. |
NUMBER |
NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
A_SYSTEM_FLAG |
If 1, system level in SCIM is visible to anonymous users. |
NUMBER |
NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
CALL_CODE |
This column contains the default call code to use when submitting a problem. |
VARCHAR2(15) |
NOT NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
COMPONENT_FLAG |
If 1, component level in SCIM is visible to registered users. |
NUMBER |
NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
GROUP_ID |
This column contains the group to which any TPM End-user Web Interface problem that is
created will be transferred. |
VARCHAR2(15) |
NOT NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
ITEM_FLAG |
If 1, item level in SCIM is visible to registered users. |
NUMBER |
NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
LOGIN_SECURITY |
This column indicates whether TPM End-user Web Interface allows anonymous users. |
NUMBER |
NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
MODULE_FLAG |
If 1, module level in SCIM is visible to registered users. |
NUMBER |
NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
NOTIFY |
If 1, contacts are notified upon problem close if they have a notification type set
up. |
NUMBER |
NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
PROBLEM_CODE |
This column contains the default problem code. |
VARCHAR2(15) |
NOT NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
SEVERITY_LEVEL |
This column contains the default severity. |
NUMBER |
NOT NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
SYSTEM_FLAG |
If 1, system level in SCIM is visible to registered users. |
NUMBER |
NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
SYSTEM_ID |
This column contains the default system. |
VARCHAR2(15) |
NOT NULL |
EWEB_CONFIG |
This table contains the information for a TPM End-user Web Interface configuration. |
USER_ID |
This column contains the user to use as the creator of any problem created by TPM
End-user Web Interface . |
VARCHAR2(15) |
NOT NULL |
EWEB_NEW_ACCOUNT |
This table is used for setting up new accounts for TPM End-user Web Interface users. |
A_DIAG_RIGHT |
This column contains the bitmask that determines which diagnostic aids an anonymous
user can use. |
NUMBER |
NULL |
EWEB_NEW_ACCOUNT |
This table is used for setting up new accounts for TPM End-user Web Interface users. |
A_KNOW_RIGHT |
Not used. |
NUMBER |
NULL |
EWEB_NEW_ACCOUNT |
This table is used for setting up new accounts for TPM End-user Web Interface users. |
A_MAX_DIAG |
This column contains the max diagnostics an anonymous user can retrieve at one time. |
NUMBER |
NULL |
EWEB_NEW_ACCOUNT |
This table is used for setting up new accounts for TPM End-user Web Interface users. |
A_UNTIL_REV |
This column determines if a new web user will be anonymous until the user record is
reviewed by an administrator. |
NUMBER |
NULL |
EWEB_NEW_ACCOUNT |
This table is used for setting up new accounts for TPM End-user Web Interface users. |
ACCT_MAX_DIAG |
for an EWEB user that is generated automatically, the default max number of
diagnostics viewable. |
NUMBER |
NULL |
EWEB_NEW_ACCOUNT |
This table is used for setting up new accounts for TPM End-user Web Interface users. |
CREATE_RIGHT |
This column contains the default create problem right for a generated user. |
NUMBER |
NULL |
EWEB_NEW_ACCOUNT |
This table is used for setting up new accounts for TPM End-user Web Interface users. |
DIAG_RIGHT |
This column contains the default diagnostic right for a generated user. |
NUMBER |
NULL |
EWEB_NEW_ACCOUNT |
This table is used for setting up new accounts for TPM End-user Web Interface users. |
EA_LOCATION_ID |
Not used. |
VARCHAR2(15) |
NULL |
EWEB_NEW_ACCOUNT |
This table is used for setting up new accounts for TPM End-user Web Interface users. |
KNOW_RIGHT |
Not used. |
NUMBER |
NULL |
EWEB_NEW_ACCOUNT |
This table is used for setting up new accounts for TPM End-user Web Interface users. |
PREFIX |
Not used. |
VARCHAR2(15) |
NULL |
EWEB_NEW_ACCOUNT |
This table is used for setting up new accounts for TPM End-user Web Interface users. |
UPDATE_RIGHT |
This column contains the default update problem right (My Own, My Organization's,
All) that are associated with this organization. |
NUMBER |
NULL |
EWEB_NEW_ACCOUNT |
This table is used for setting up new accounts for TPM End-user Web Interface users. |
VIEW_RIGHT |
This column contains the view problem right (My Own, My Organization's, All) that
are associated with this organization. |
NUMBER |
NULL |
EWEB_USAGE |
This table contains statistics on TPM End-user Web Interface usage. |
ADL_USAGE |
The number of times ADL has been used by this user. |
NUMBER |
NULL |
EWEB_USAGE |
This table contains statistics on TPM End-user Web Interface usage. |
CP_USAGE |
The number of times Common Problems have been used by this user. |
NUMBER |
NULL |
EWEB_USAGE |
This table contains statistics on TPM End-user Web Interface usage. |
DIAG_USAGE |
The number of times diagnostics has been used by this user. |
NUMBER |
NULL |
EWEB_USAGE |
This table contains statistics on TPM End-user Web Interface usage. |
EM_USAGE |
The number of times error messages has been used by this user. |
NUMBER |
NULL |
EWEB_USAGE |
This table contains statistics on TPM End-user Web Interface usage. |
HN_USAGE |
The number of times hot news has been used by this user. |
NUMBER |
NULL |
EWEB_USAGE |
This table contains statistics on TPM End-user Web Interface usage. |
HT_USAGE |
The number of times hyper trees has been used by this user. |
NUMBER |
NULL |
EWEB_USAGE |
This table contains statistics on TPM End-user Web Interface usage. |
SUBMIT_USAGE |
The number of times submit problem has been used by this user. |
NUMBER |
NULL |
EWEB_USAGE |
This table contains statistics on TPM End-user Web Interface usage. |
UPDATE_USAGE |
The number of times update problem has been used by this user. |
NUMBER |
NULL |
EWEB_USAGE |
This table contains statistics on TPM End-user Web Interface usage. |
VIEW_USAGE |
The number of times view problem has been used by this user. |
NUMBER |
NULL |
EWEB_USAGE |
This table contains statistics on TPM End-user Web Interface usage. |
WEB_ID |
The web_id of the person using EWEB |
VARCHAR2(20) |
NOT NULL |
HOMEPAGES |
This table contains information on home pages and their labels. |
HOME_PAGE |
This column contains a unique, zero-based page ID. |
NUMBER |
NOT NULL |
HOMEPAGES |
This table contains information on home pages and their labels. |
PAGETITLE |
This column contains textual title for this diagnostic page. |
VARCHAR2(40) |
NULL |
HOMESCREEN |
This table contains information on homescreens and their icons. |
BMP |
This column contains the name of a bitmap file containing an icon to be displayed. |
VARCHAR2(40) |
NOT NULL |
HOMESCREEN |
This table contains information on homescreens and their icons. |
DATAVAL |
Not Used |
VARCHAR2(40) |
NULL |
HOMESCREEN |
This table contains information on homescreens and their icons. |
DOQUERY |
Not Used |
NUMBER |
NULL |
HOMESCREEN |
This table contains information on homescreens and their icons. |
HOME_PAGE |
This column contains the name of the bitmap file containing an icon to be displayed. |
NUMBER |
NOT NULL |
HOMESCREEN |
This table contains information on homescreens and their icons. |
OPERATION |
This column contains an operator code indicating what the system is to do when the
icon is selected. |
NUMBER |
NULL |
HOMESCREEN |
This table contains information on homescreens and their icons. |
POS |
This column contains an integer position (zero-based) of the page to which this row
belongs. |
NUMBER |
NOT NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
ACTION |
This column contains a text description of the actions a caller should take to
determine the answer to the question for this node. |
LONG |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
COMPONENT |
This column contains the component to which this node is associated. |
VARCHAR2(15) |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
ENTRY_POINT |
This column contains a Boolean field indicating that the node can be linked or a node
that starts a hypernode. |
NUMBER |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
ENTRY_ROUTINE |
This column contains a routine to be executed upon a user's entry into this node
in Sequential Response mode. "Entry" is defined as that period of time
after the user has selected a response that leads to this node, and before this node is
displayed on the screen. |
VARCHAR2(40) |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
EXIT_ROUTINE |
This column contains a routine to be executed upon a user's exit from this node
in Sequential Response mode. "Exit" is defined as immediately after the
user has selected a response and hit Next (or double-clicked on the response). |
VARCHAR2(40) |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
GOTONODE_ID |
This column contains the secondary links for the trees. For secondary links a
false node is created for which this field contains the node ID of the target of the
secondary link. A primary link is then defined in RESPONSE from the parent node to
this hidden node. A node containing a value in this field is invisible to users of
the system (although in EditTree the user can see it, he/she just can't edit it). |
NUMBER |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
HYPERNODE_ID |
This column contains system generated unique ID for the Node. |
NUMBER |
NOT NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
IS_ROOT |
This column contains a boolean field indicating whether the node is at the top of the
hypertree. |
NUMBER |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
ITEM |
This column contains the item to which this node is associated. |
VARCHAR2(15) |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
MODIFY_USER |
This column contains the user ID of the person who last modified this node. |
VARCHAR2(15) |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
MODULE |
This column contains the module to which this node is associated. |
VARCHAR2(15) |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
MOSTRECENTUSE |
This column contains a time stamp of when this node was last used as a solution. |
NUMBER |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
NODE_IN_PRODUCTION |
This column contains a boolean field indicating whether the node is being used in
production. |
NUMBER |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
NODETITLE |
This column contains the descriptive identifier for the node. Use this as a
human-readable form of an ID. |
VARCHAR2(40) |
NOT NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
PROBLEM_TYPE |
This column contains the problem type to which this node is associated. These
equipment fields are used by the system in the entry point processing, in which an entry
point into the tree is chosen based on the equipment association of the current problem. |
VARCHAR2(15) |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
QUESTN |
This column contains the question that is to be asked of the caller when this node is
reached. |
VARCHAR2(2000) |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
SECURITY |
|
NUMBER |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
SERVICE |
This column contains a service with which this node is associated. |
VARCHAR2(15) |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
SOLUTION_COUNT |
This column contains the number of times that this node has been used as a solution. |
NUMBER |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
SOLUTION_ID |
This column contains the Foreign Key to the SOLUTIONS table which points to the node
solution information. |
NUMBER |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
SOLVED |
This column contains a boolean field indicating whether the nodes information solves
an incident. The solution of a given hyperbranch. The final node of a
hyperbranch. |
NUMBER |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
SYSTEM |
This column contains the system to which this node is associated. |
VARCHAR2(15) |
NULL |
HYPERNODE |
This table contains information on the nodes that are used to create the hypertrees. |
UNUSED_NODE |
This column contains a boolean field indicating whether the node is active or not. |
NUMBER |
NULL |
INVENTORY |
This table contains information on inventory and its associated systems and locations. |
CONTACT_ID |
This column contains the ID of the contact to which this row is assigned. |
VARCHAR2(15) |
NULL |
INVENTORY |
This table contains information on inventory and its associated systems and locations. |
DESCRIPTION |
This column contains a free-form description of the inventory item. |
VARCHAR2(1024) |
NULL |
INVENTORY |
This table contains information on inventory and its associated systems and locations. |
INVENTORY_ID |
This column contains a unique user-supplied ID. |
VARCHAR2(40) |
NOT NULL |
INVENTORY |
This table contains information on inventory and its associated systems and locations. |
LOCATION_ID |
This column contains the location that this inventory item is associated with. |
VARCHAR2(15) |
NOT NULL |
INVENTORY |
This table contains information on inventory and its associated systems and locations. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
INVENTORY |
This table contains information on inventory and its associated systems and locations. |
SYSTEM |
This column contains the ID of the logical system type of this row. |
VARCHAR2(40) |
NOT NULL |
INVENTORY_CONFIG |
This table contains information about inventory items. |
COMPONENT |
This column contains the logical component type. |
VARCHAR2(15) |
NOT NULL |
INVENTORY_CONFIG |
This table contains information about inventory items. |
INVENTORY_ID |
This column contains a unique user-supplied ID that refers to a specific inventory
item. |
VARCHAR2(40) |
NOT NULL |
INVENTORY_CONFIG |
This table contains information about inventory items. |
ITEM |
This column contains the logical item type. |
VARCHAR2(15) |
NULL |
INVENTORY_CONFIG |
This table contains information about inventory items. |
LOCATION_ID |
This column contains the ID of the location with which this inventory item is
associated. |
VARCHAR2(15) |
NOT NULL |
INVENTORY_CONFIG |
This table contains information about inventory items. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
INVENTORY_CONFIG |
This table contains information about inventory items. |
SERIAL_NUMBER |
This column contains the actual serial number. |
VARCHAR2(40) |
NULL |
KEYWORD_MATRIX |
This table contains information on Word / Solution pairings. |
SOLUTION_ID |
This column contains the solution ID with which to relate this Word / Solution
pairing.This column contains the number of times this word has appeared in the description
of a problem which was solved by the record's solution (referenced by the
Solution_ID.) |
NUMBER |
NOT NULL |
KEYWORD_MATRIX |
This table contains information on Word / Solution pairings. |
USAGE_COUNT |
This column contains the number of times this word has appeared in the description of
a problem which was solved by the record's solution ( referenced by the Solution_ID.) |
NUMBER |
NOT NULL |
KEYWORD_MATRIX |
This table contains information on Word / Solution pairings. |
WORD_ID |
This column contains the word ID with which to relate this Word / Solution pairing. |
NUMBER |
NOT NULL |
LOCAL_WORK |
This table contains a record that is created by the remote site when it begins the
transaction. When the transaction is completed, the local site is notified that the
transaction is completed. If the local site cannot be notified, the LOCAL_WORK
record is used to notify the local site at a later time. |
CONTROL_TIME |
This column contains a system-generated timestamp. |
NUMBER |
NULL |
LOCAL_WORK |
This table contains a record that is created by the remote site when it begins the
transaction. When the transaction is completed, the local site is notified that the
transaction is completed. If the local site cannot be notified, the LOCAL_WORK
record is used to notify the local site at a later time. |
FAILURE_CODE |
This column contains the failure code associated with a transaction. |
NUMBER |
NULL |
LOCAL_WORK |
This table contains a record that is created by the remote site when it begins the
transaction. When the transaction is completed, the local site is notified that the
transaction is completed. If the local site cannot be notified, the LOCAL_WORK
record is used to notify the local site at a later time. |
FAILURE_TEXT |
This column contains the text code when a transaction fails. |
VARCHAR2(254) |
NULL |
LOCAL_WORK |
This table contains a record that is created by the remote site when it begins the
transaction. When the transaction is completed, the local site is notified that the
transaction is completed. If the local site cannot be notified, the LOCAL_WORK
record is used to notify the local site at a later time. |
RETURN_SITE |
This column contains the name of the site that initiated the transaction. |
VARCHAR2(32) |
NOT NULL |
LOCAL_WORK |
This table contains a record that is created by the remote site when it begins the
transaction. When the transaction is completed, the local site is notified that the
transaction is completed. If the local site cannot be notified, the LOCAL_WORK
record is used to notify the local site at a later time. |
RW_ID |
This column contains the REMOTE_WORK record identification number. |
NUMBER |
NOT NULL |
LOCAL_WORK |
This table contains a record that is created by the remote site when it begins the
transaction. When the transaction is completed, the local site is notified that the
transaction is completed. If the local site cannot be notified, the LOCAL_WORK
record is used to notify the local site at a later time. |
STATUS |
The current status of the REMOTE_TASKS record. |
VARCHAR2(15) |
NOT NULL |
LOCAL_WORK |
This table contains a record that is created by the remote site when it begins the
transaction. When the transaction is completed, the local site is notified that the
transaction is completed. If the local site cannot be notified, the LOCAL_WORK
record is used to notify the local site at a later time. |
SUCCESS |
This column contains the current state of the REMOTE_TASKS record. |
NUMBER |
NOT NULL |
MAP_ASSIGNMENT |
This table contains the information for mapping one field to another in the data
mapper. |
MAP_ASSIGNMENT_ID |
This column contains the unique identifier for the associated fields to be mapped for
each transaction map. |
NUMBER |
NOT NULL |
MAP_ASSIGNMENT |
This table contains the information for mapping one field to another in the data
mapper. |
MAP_ID |
This column contains the unique integer identifier of the transaction map.
Foreign key to TRANSACTION_MAP table. |
NUMBER |
NOT NULL |
MAP_ASSIGNMENT |
This table contains the information for mapping one field to another in the data
mapper. |
SRC1_FIELD |
This column contains the field belonging to source 1 of the transaction map. |
VARCHAR2(50) |
NOT NULL |
MAP_ASSIGNMENT |
This table contains the information for mapping one field to another in the data
mapper. |
SRC2_FIELD |
This column contains the field belonging to source 2 of the transaction map. |
VARCHAR2(50) |
NOT NULL |
MAP_TRANSLATION |
This table contains the information for assigning map assignments to translations. |
MAP_ASSIGNMENT_ID |
This column contains the identifier of the map assignment record to perform the
translation. Foreign key to MAP_ASSIGNMENT. |
NUMBER |
NOT NULL |
MAP_TRANSLATION |
This table contains the information for assigning map assignments to translations. |
SEQUENCE_NUMBER |
This column contains the number indicating the order in which translations are to
occur for each map assignment. |
NUMBER |
NOT NULL |
MAP_TRANSLATION |
This table contains the information for assigning map assignments to translations. |
SRC_ID |
This column contains the identifier of the destination source used to indicate
direction of the mapping. Foreign key to SOURCE table. |
NUMBER |
NOT NULL |
MAP_TRANSLATION |
This table contains the information for assigning map assignments to translations. |
TRANSLATION_ID |
This column contains the unique integer identifier for the associated table relating
translations to map assignments. Foreign key to TRANSLATIONS table. |
NUMBER |
NOT NULL |
PROB_TRANSFER |
This table contains information on problem transfers. |
GROUP_ID |
This column contains the group to transfer the problem to. |
VARCHAR2(15) |
NULL |
PROB_TRANSFER |
This table contains information on problem transfers. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
PROB_TRANSFER |
This table contains information on problem transfers. |
ORGANIZATION_ID |
This column contains the organization this problem is associated with. |
VARCHAR2(15) |
NULL |
PROB_TRANSFER |
This table contains information on problem transfers. |
PROBLEM_ID |
This column contains the problem id to be transferred. |
VARCHAR2(15) |
NOT NULL |
PROB_TRANSFER |
This table contains information on problem transfers. |
TRANSFER_DATE |
This column contains the date on which the problem was transferred. |
DATE |
NULL |
PROB_TRANSFER |
This table contains information on problem transfers. |
TRANSFER_SITE |
This column contains the site the problem is to be transferred with (used with DDM). |
VARCHAR2(6) |
NULL |
PROB_TRANSFER |
This table contains information on problem transfers. |
TRANSFER_TIME |
This column contains the time at which the problem was transferred. |
VARCHAR2(10) |
NULL |
PROB_TRANSFER |
This table contains information on problem transfers. |
TRANSFERRED_BY |
This column contains the user who transferred the problem. Foreign key to the
USERS table. |
VARCHAR2(15) |
NULL |
PROB_TRANSFER |
This table contains information on problem transfers. |
USER_ID |
This column contains the user to transfer the problem to. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
ACTIVE |
This column contains value to indicate if the solution is currently active. This
allows solution to be disabled when they become outdated. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
AID_TYPE |
This column contains the type of diagnostic aid this row refers to. The
available diagnostic aid types are Common, Error, Hotnews. |
VARCHAR2(25) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
ALT_USERID |
This column contains the .wav file name that is used to store this annotation. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
CALL_CODE |
This column contains the type of call code associated with the session. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
CALL_ID |
This column contains the call ID assigned to the session. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
CALLER_ID |
This column contains the caller ID of the person originating the call. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
CALLER_NAME |
This column contains the full name of the person originating the call. |
VARCHAR2(40) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
CALLER_PHONE |
This column contains the phone number of the person originating the call. |
VARCHAR2(20) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
CAUSE_ID |
This column contains the identifier of the cause of the problem. |
VARCHAR2(25) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
CLOSEPROBLEM |
This column contains a value indicating whether an existing problem record could be
closed. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
CLOSURE_ID |
This column contains a unique system-generated ID. |
NUMBER |
NOT NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
COMPONENT |
This column contains the specific component of the above system causing the problem
(for example, CPU). |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
CONTROL_TIME |
This column contains the control time for retrying the problem closure. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
CREATECALL |
This column contains a value indicating whether a new call record should be generated. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
CREATEPROBLEM |
This column contains a value indicating whether a new problem record should be
generated. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
CREATOR_APP_ID |
This column contains the ID of the application that created the problem. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
DESCRIPTION |
This column contains a free-form textual description of the problem. |
VARCHAR2(2000) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
DIAG_NODE |
This column contains the ID of the current diagnostics node (if any) when a problem is
frozen. When the problem is resumed, the user is taken directly to that node. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
DISPATCH_ID |
This column contains the dispatch ID assigned to the session. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
DONOTIFICATION |
This column contains a value indicating whether to notify the user ID of the person
receiving the transferred incident. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
EXPLODEGROUP |
$ASETYPE=BOOLEAN |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_CAL_DATE1 |
This column contains a date field for customization purposes. |
DATE |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_CAL_DATE2 |
This column contains a date field for customization purposes. |
DATE |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_CAL_INT1 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_CAL_INT2 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_CAL_INT3 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_CAL_INT4 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_CAL_TIME1 |
This column contains a time field for customization purposes. |
VARCHAR2(10) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_CAL_TIME2 |
This column contains a time field for customization purposes. |
VARCHAR2(10) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_CAL_VCHR1 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_CAL_VCHR2 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_CAL_VCHR3 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_CAL_VCHR4 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_PRO_DATE1 |
This column contains a date field for customization purposes. |
DATE |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_PRO_DATE2 |
This column contains a date field for customization purposes. |
DATE |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_PRO_INT1 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_PRO_INT2 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_PRO_INT3 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_PRO_INT4 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_PRO_TIME1 |
This column contains a time field for customization purposes. |
VARCHAR2(10) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_PRO_TIME2 |
This column contains a time field for customization purposes. |
VARCHAR2(10) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_PRO_VCHR1 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_PRO_VCHR2 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_PRO_VCHR3 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
FLX_PRO_VCHR4 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
INVENTORY_ID |
This column contains the inventory ID of the inventory item that is having the
problem. |
VARCHAR2(40) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
ITEM |
This column contains the specific item of the component causing the problem. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
LINE_NUMBER |
This column contains the line number assigned to the dispatch. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
LOCATION_ID |
This column contains the location of the caller that initiated the call / problem. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
MODULE |
This column contains the specific module of the item causing the problem. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
NODE_NAME |
This column contains the failing node that the problem is logged about. |
VARCHAR2(64) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
NOTIFICATION_DATE |
This column contains the date at which the notification is to be sent. |
DATE |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
NOTIFICATION_TIME |
This column contains the time at which the notification is to be sent. |
VARCHAR2(10) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
NOTIFICATION_TYPE |
This column contains the type of notification that is to be used. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
NOTIFY_CONTACT |
This column contains a value to notify the contact ID associated with the incident. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
ORGANIZATION_ID |
This column contains the organization ID of the person that called with the problem. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
OS390_CHANGE |
This column contains the flag that tells an OS/390 dedicated application server to
create an OS/390 change. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
PEOPLE_ID |
This column contains the people ID of the person that is associated with the call. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
PICKUPDISPATCH |
This column indicates the record originated from a dispatch call. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
PROBLEM_CODE |
This column contains the current code for the problem. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
PROBLEM_ID |
This column contains the problem ID assigned to the session. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
PROBLEM_RESULT |
This column contains the current status of an open problem or the resolution for a
closed problem. |
VARCHAR2(1024) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
PROBLEM_TYPE |
This column contains the overall cause of the problem (e.g. hardware, software, etc.) |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
RCV_GROUP_ID |
This column contains the group ID of the person receiving the message. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
RCV_SITE_ID |
This column contains the site ID to receive the problem. |
VARCHAR2(6) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
RCV_USER_ID |
This column contains the user ID of the person receiving the message. |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
SERIAL_NUMBER |
This column contains the serial number of the item having the problem. |
VARCHAR2(40) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
SESSION_BEGIN_DATE |
This column contains the date on which the session began. |
DATE |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
SESSION_BEGIN_TIME |
This column contains the time at which the session began. |
VARCHAR2(10) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
SESSION_END_DATE |
This column contains the date on which the session ended. |
DATE |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
SESSION_END_TIME |
This column contains the time at which the session ended. |
VARCHAR2(10) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
SESSION_ID |
This column contains the session ID assigned to the session. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
SEVERITY |
This column contains the severity level assigned to the session. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
SOLUTION |
This column contains a free-form textual description of the solution to this problem. |
LONG |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
SOLUTION_ID |
This column contains a unique system-generated ID for the solution. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
SOLUTIONMETHOD |
This column contains the type of solution used to resolve the incident. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
SYSTEM |
This column contains the specific system causing the problem (for example,
AS/400). |
VARCHAR2(15) |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
TIME_SPENT |
This column contains the number of seconds spent on the problem. This quantity
represents the sum of all the SESSION records associated with the problem, along with the
sum of all WORK_HISTORY records associated with the problem. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
TRANSACTIONTYPE |
This column contains a value indicating the type of transaction. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
TRANSFERUSER |
This column contains the user ID of the person who transferred the incident. |
NUMBER |
NULL |
PROBLEM_CLOSURE |
This table contains the information needed to process a problem closure. |
USER_ID |
This column contains the ID of the person originating the call. |
VARCHAR2(15) |
NULL |
PROBLEM_CODES |
This table contains the problem codes that are used with TPM problems. |
ACTION_TYPE |
This column contains the type of action to take with this specified problem code. |
NUMBER |
NOT NULL |
PROBLEM_CODES |
This table contains the problem codes that are used with TPM problems. |
DESCRIPTION |
This column contains a longer description of the details of the entry. |
VARCHAR2(1024) |
NULL |
PROBLEM_CODES |
This table contains the problem codes that are used with TPM problems. |
MODIFY_DATETIME |
This column contains a time field for customization purposes. |
NUMBER |
NOT NULL |
PROBLEM_CODES |
This table contains the problem codes that are used with TPM problems. |
PROBLEM_CODE |
This column contains unique problem code ID. |
VARCHAR2(15) |
NOT NULL |
PROBLEM_HISTORY |
This table contains problem history records for TPM problems. |
ENTRY |
This column contains the text entry for the problem history. |
VARCHAR2(254) |
NULL |
PROBLEM_HISTORY |
This table contains problem history records for TPM problems. |
ENTRY_DATE |
This column contains the date on which the problem was transferred. |
DATE |
NOT NULL |
PROBLEM_HISTORY |
This table contains problem history records for TPM problems. |
ENTRY_OVRFLW |
This column contains the overflow text for the ENTRY field. |
LONG |
NULL |
PROBLEM_HISTORY |
This table contains problem history records for TPM problems. |
ENTRY_TIME |
This column contains the time at which the problem was transferred. |
VARCHAR2(10) |
NOT NULL |
PROBLEM_HISTORY |
This table contains problem history records for TPM problems. |
ENTRY_TYPE |
This column contains the type of entry made. |
VARCHAR2(50) |
NOT NULL |
PROBLEM_HISTORY |
This table contains problem history records for TPM problems. |
ENTRY_VALUE |
This column contains the value of the entry. |
VARCHAR2(15) |
NULL |
PROBLEM_HISTORY |
This table contains problem history records for TPM problems. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
PROBLEM_HISTORY |
This table contains problem history records for TPM problems. |
PROBHIST_ID |
This column contains a system-generated unique ID. |
NUMBER |
NOT NULL |
PROBLEM_HISTORY |
This table contains problem history records for TPM problems. |
PROBLEM_ID |
This column contains the ID of the problem with which the entry is associated. |
VARCHAR2(15) |
NOT NULL |
PROBLEM_HISTORY |
This table contains problem history records for TPM problems. |
SITE_ID |
This column contains the site at which the problem history was entered. |
VARCHAR2(6) |
NOT NULL |
PROBLEM_HISTORY |
This table contains problem history records for TPM problems. |
USER_ID |
This column contains the user to which to transfer the problem. |
VARCHAR2(15) |
NOT NULL |
PROBLEM_TYPE |
This table contains the different problem types to be used with TPM problems. |
DESCRIPTION |
This column contains free-form text description of the problem type. |
VARCHAR2(1024) |
NULL |
PROBLEM_TYPE |
This table contains the different problem types to be used with TPM problems. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
PROBLEM_TYPE |
This table contains the different problem types to be used with TPM problems. |
PROBLEM_TYPE_ID |
This column contains a unique ID - also the text which appears in the pick list. |
VARCHAR2(15) |
NOT NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
ACTIVE_WITH |
This column contains the ID of the user (if any) who currently has this problem active
with TPM. |
VARCHAR2(15) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
CAUSE_ID |
This column contains the cause ID. |
VARCHAR2(25) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
CLOSE_DATE |
This column contains the date on which the problem was closed. |
DATE |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
CLOSE_TIME |
This column contains the time at which the problem was closed. |
VARCHAR2(10) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
COMPONENT |
This column contains the specific component of the system causing the problem (for
example, CPU). |
VARCHAR2(15) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
CREATOR_APP_ID |
This column contains the value of the application that created it (TPM. TCM, TAM, and
so on). |
VARCHAR2(15) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
CURRENT_SITE |
This column contains the site the problem currently resides at (for use with DDM). |
VARCHAR2(6) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
DIAG_NODE |
This column contains the ID of the current diagnostics node (if any) stored in
this column when a problem is frozen. When the problem is resumed, the user is taken
directly to that node. |
NUMBER |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FIRST_CALL_ID |
This column contains the first Call ID associated with this problem. Foreign key
to the CALLS table. |
VARCHAR2(15) |
NOT NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FIRST_CONTACT_ID |
This column contains the first contact that initiated the problem. Foreign key
to the CALLERS table. |
VARCHAR2(15) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FIRST_LOCATION_ID |
This column contains the location of the contact that initiated the problem.
Foreign key to the LOCATIONS table. |
VARCHAR2(15) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FIRST_PEOPLE_ID |
This column contains the numeric identifier of the first person who initiated the
problem. |
NUMBER |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FIRST_SESSION_ID |
This column contains the first session ID associated with this problem. |
NUMBER |
NOT NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FLX_PRO_DATE1 |
This column contains a date field for customization purposes. |
DATE |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FLX_PRO_DATE2 |
This column contains a date field for customization purposes. |
DATE |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FLX_PRO_INT1 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FLX_PRO_INT2 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FLX_PRO_INT3 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FLX_PRO_INT4 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FLX_PRO_TIME1 |
This column contains a time field for customization purposes. |
VARCHAR2(10) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FLX_PRO_TIME2 |
This column contains a time field for customization purposes. |
VARCHAR2(10) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FLX_PRO_VCHR1 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FLX_PRO_VCHR2 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FLX_PRO_VCHR3 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
FLX_PRO_VCHR4 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
GROUP_ID |
This column contains the ID of the group to whom the problem is currently assigned. |
VARCHAR2(15) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
ITEM |
This column contains the specific item of the component causing the problem. |
VARCHAR2(15) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
MERGED_INTO |
This column contains the problem_id into which this problem has been merged. |
VARCHAR2(15) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
MODULE |
This column contains the specific module of the above item causing the problem. |
VARCHAR2(15) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
NODE_NAME |
This column contains the node_name (TCP/IP address) of the network node which is
having a problem. This field is automatically populated by TPM Expert System
Management. |
VARCHAR2(64) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
NOTIFY_CONTACT |
This column contains the flag for notifying a contact. |
NUMBER |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
OPEN_DATE |
This column contains the date when this problem was opened. |
DATE |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
OPEN_TIME |
This column contains the time when this problem was opened. |
VARCHAR2(10) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
ORGANIZATION_ID |
This column contains the organization ID for which the problem was created. |
VARCHAR2(15) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
ORIGINATING_SITE |
This column contains the site the problem was created at. |
VARCHAR2(6) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
OS390_CHANGE |
This column contains the flag to determine if this problem is to create an OS/390
change. |
NUMBER |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
OS390_PROB_ID |
This column contains the OS/390 problem ID for this problem. |
VARCHAR2(8) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
PROBLEM_CODE |
This column contains the current code for this problem. Foreign key to the
PROBLEM_CODES table. |
VARCHAR2(15) |
NOT NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
PROBLEM_ID |
This column contains a unique system-generated eight-digit sequence number left-padded
with 0's. |
VARCHAR2(15) |
NOT NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
PROBLEM_RESULT |
This column contains the current status of an open problem or the resolution |
VARCHAR2(1024) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
PROBLEM_TYPE |
This column contains the overall cause of the problem (hardware, software, and so on).
Foreign key to the PROBLEM_TYPES table. |
VARCHAR2(15) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
SEVERITY |
This column contains the current severity level of the problem. |
NUMBER |
NOT NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
SOLUTION_ID |
This column contains the ID of the solution that was used to solve this problem.
Foreign key to the SOLUTIONS table. |
NUMBER |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
SYSTEM |
This column contains the specific system causing the problem (for example, AS/400). |
VARCHAR2(15) |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
TIME_SPENT |
This column contains the number of seconds spent on the problem. This quantity
represents the sum of all the SESION records associated with the problem along with the
sum of all WORK_HISTORY records associated with the problem. |
NUMBER |
NULL |
PROBLEMS |
This table contains the information for a TPM problem. |
USER_ID |
This column contains the ID of the user to whom the problem is currently assigned. |
VARCHAR2(15) |
NULL |
REMOTE_TASKS |
This table contains a record that is created by the local site. A REMOTE_TASKS
record contains the data required to perform a transaction to a remote site. A
REMOTE_TASKS record is created for each site where a particular REMOTE_WORK transaction is
to be performed. |
CONTROL_TIME |
This column contains a system-generated timestamp. |
NUMBER |
NULL |
REMOTE_TASKS |
This table contains a record that is created by the local site. A REMOTE_TASKS
record contains the data required to perform a transaction to a remote site. A
REMOTE_TASKS record is created for each site where a particular REMOTE_WORK transaction is
to be performed. |
LAST_ATTEMPT_DATE |
This column contains the date of the most recent REMOTE_TASKS record retry. |
DATE |
NULL |
REMOTE_TASKS |
This table contains a record that is created by the local site. A REMOTE_TASKS
record contains the data required to perform a transaction to a remote site. A
REMOTE_TASKS record is created for each site where a particular REMOTE_WORK transaction is
to be performed. |
LAST_ATTEMPT_TIME |
This column contains the time of the most recent REMOTE_TASKS record retry. |
VARCHAR2(10) |
NULL |
REMOTE_TASKS |
This table contains a record that is created by the local site. A REMOTE_TASKS
record contains the data required to perform a transaction to a remote site. A
REMOTE_TASKS record is created for each site where a particular REMOTE_WORK transaction is
to be performed. |
RCV_SITE |
This column contains the name of the site that receives the transaction. |
VARCHAR2(6) |
NOT NULL |
REMOTE_TASKS |
This table contains a record that is created by the local site. A REMOTE_TASKS
record contains the data required to perform a transaction to a remote site. A
REMOTE_TASKS record is created for each site where a particular REMOTE_WORK transaction is
to be performed. |
RETRIES |
This column contains the number of times the REMOTE_TASKS record has been tried. |
NUMBER |
NOT NULL |
REMOTE_TASKS |
This table contains a record that is created by the local site. A REMOTE_TASKS
record contains the data required to perform a transaction to a remote site. A
REMOTE_TASKS record is created for each site where a particular REMOTE_WORK transaction is
to be performed. |
RW_ID |
This column contains the REMOTE_WORK record identification number. Foreign key
to REMOTE_WORK table. |
NUMBER |
NOT NULL |
REMOTE_TASKS |
This table contains a record that is created by the local site. A REMOTE_TASKS
record contains the data required to perform a transaction to a remote site. A
REMOTE_TASKS record is created for each site where a particular REMOTE_WORK transaction is
to be performed. |
STATUS |
This column contains the current state of the REMOTE_TASKS record. |
VARCHAR2(15) |
NOT NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
CALL_ID |
This column contains the call ID of the call that constitutes the remote transaction. |
VARCHAR2(15) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
CLIENT_HOST |
This column contains the TCP/IP host which requested the transaction. |
VARCHAR2(32) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
CLIENT_PORT |
This column contains the network port that the client computer monitors for a reply. |
NUMBER |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
CONTROL_TIME |
This column contains a system-generated timestamp. |
NUMBER |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
CURRENT_SITE |
This column contains the name of the site that currently owns the problem. |
VARCHAR2(6) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
EXPLODEGROUP |
This column contains a value that indicates whether to send individuals, who are in a
group, group notifications. |
NUMBER |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
GROUP_ID |
This column contains the ID of a group that is copied to other sites when the remote
transaction involves the addition or deletion of the group ID. |
VARCHAR2(15) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
GROUP_NAME |
This column contains the full name of a group that is copied to other sites when the
remote transaction involves the addition or deletion of the group ID. |
VARCHAR2(40) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
LOCATION_ID |
This column contains the location ID being transferred. |
VARCHAR2(15) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
NOTIFICATION_TYPE |
Not used. |
VARCHAR2(15) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
NOTIFYOWNER |
This column contains information indicating whether the owner at the remote site is
notified of the transfer. |
NUMBER |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
ORGANIZATION_ID |
This column contains the organization ID being transferred. |
VARCHAR2(15) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
PEOPLE_ID |
This column contains the people_id being transferred. |
NUMBER |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
PROBHIST_ID |
The problem history ID of the problem that constitutes the remote transaction. |
NUMBER |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
PROBLEM_CODE |
This column contains the problem code of the problem that constitutes the remote
transaction. |
VARCHAR2(15) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
PROBLEM_ID |
This column contains the problem ID of the problem that constitutes the remote
transaction. |
VARCHAR2(15) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
PROBLEM_RESULT |
This column contains a description of the result of the remote transaction when the
remote transaction involves a problem. |
VARCHAR2(1024) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
RCV_GROUP_ID |
The column contains the ID of the group who receives the remove transactions, such as
call and problem transfers. |
VARCHAR2(15) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
RCV_USER_ID |
The column contains the ID of the user who receives the remote transactions, such as
call and problems transfers. |
VARCHAR2(15) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
REF_RW_ID |
This column contains a REMOTE_WORK identification number needed to complete the
transaction. |
NUMBER |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
RW_ID |
This column contains the REMOTE_WORK record identification number. |
NUMBER |
NOT NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
SESSION_END_DATE |
This column contains the date of the problem transfer to the remote site. |
DATE |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
SESSION_END_TIME |
This column contains the time of the problem transfer to the remote site. |
VARCHAR2(10) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
SESSION_ID |
This column contains the session ID of the call that constitutes the remote
transaction. |
NUMBER |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
SND_USER_ID |
This column contains the ID of the user who initiated the remote transaction. |
VARCHAR2(15) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
SOLUTION_ID |
This column contains the solution_id being transferred. |
NUMBER |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
TRANSACTIONTYPE |
This column contains the transaction type code. |
NUMBER |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
USER_ACTIVE_FLAG |
This column contains the active status of the user ID that is copied to other sites
when the remote transaction involves the addition or deletion of the user. |
NUMBER |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
USER_FULLNAME |
This column contains the full name of the user ID that is copied to other sites when
the remote transaction involves the addition or deletion of the user. |
VARCHAR2(40) |
NULL |
REMOTE_WORK |
This table contains a record that is created by the local site. A REMOTE_WORK
record is associated with at least one REMOTE_TASKS record. A REMOTE_WORK record is
similar to a TPM PROBLEM_CLOSURE record. |
USER_ID |
This column contains the ID of the user that is copied to other sites when the remote
transaction involves the addition or deletion of the user ID. |
VARCHAR2(15) |
NULL |
RESPONSE |
This table contains a list of responses to be used with hypernodes. |
CHILD_HYPERNODE |
This column contains the hypernode ID of the child node. |
NUMBER |
NOT NULL |
RESPONSE |
This table contains a list of responses to be used with hypernodes. |
HYPERNODE_ID |
This column contains the hypernode ID of the parent node. |
NUMBER |
NOT NULL |
RESPONSE |
This table contains a list of responses to be used with hypernodes. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
RESPONSE |
This table contains a list of responses to be used with hypernodes. |
RESPONSE_TEXT |
This column contains the text response displayed in the response list of the parent
node. The user selects this response to go to the child indicated in the
CHILD_HYPERNODE field. |
VARCHAR2(80) |
NULL |
RESPONSE |
This table contains a list of responses to be used with hypernodes. |
USE_COUNT |
This column contains the number of times that a user has selected this response from
the parent's response list. |
NUMBER |
NULL |
SESION |
This table contains information on problem sessions. |
CALL_CODE |
This column contains a code indicating the nature of the session (first call, return
call, inquire, and so on). Foreign key to the CALL_CODES table. |
VARCHAR2(15) |
NOT NULL |
SESION |
This table contains information on problem sessions. |
CALL_ID |
This column contains the ID of the call with which the session is associated. |
VARCHAR2(15) |
NOT NULL |
SESION |
This table contains information on problem sessions. |
COMPONENT |
This column contains the component which the caller thinks is causing the problem. |
VARCHAR2(15) |
NULL |
SESION |
This table contains information on problem sessions. |
DESCRIPTION |
This column contains a free-form description of the caller's problem or concern. |
VARCHAR2(2000) |
NULL |
SESION |
This table contains information on problem sessions. |
INVENTORY_ID |
This column contains the Inventory ID of the inventory item that is having the
problem. |
VARCHAR2(40) |
NULL |
SESION |
This table contains information on problem sessions. |
ITEM |
This column contains the item which the caller thinks is causing the problem. |
VARCHAR2(15) |
NULL |
SESION |
This table contains information on problem sessions. |
LOCATION_ID |
This column contains the location of the caller that initiated the call / problem.
Foreign key to the LOCATIONS table. |
VARCHAR2(15) |
NULL |
SESION |
This table contains information on problem sessions. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
SESION |
This table contains information on problem sessions. |
MODULE |
This column contains the module which the caller thinks is causing the problem. |
VARCHAR2(15) |
NULL |
SESION |
This table contains information on problem sessions. |
PROBLEM_ID |
This column contains the ID of the problem (if any) with which the session was
associated. Note that a given session might either cause the opening of a new
problem or might be related to an already open problem. |
VARCHAR2(15) |
NULL |
SESION |
This table contains information on problem sessions. |
PROBLEM_TYPE |
This column contains the type of problem the caller was having. Foreign key to
the PROBLEMS_TYPES table. |
VARCHAR2(15) |
NULL |
SESION |
This table contains information on problem sessions. |
SERIAL_NUMBER |
This column contains the serial number of the item that is having the problem. |
VARCHAR2(40) |
NULL |
SESION |
This table contains information on problem sessions. |
SESSION_BEGIN_DATE |
This column contains the date at which the session began. |
DATE |
NOT NULL |
SESION |
This table contains information on problem sessions. |
SESSION_BEGIN_TIME |
This column contains the time at which the session began. |
VARCHAR2(10) |
NOT NULL |
SESION |
This table contains information on problem sessions. |
SESSION_END_DATE |
This column contains the date at which the session ended. |
DATE |
NOT NULL |
SESION |
This table contains information on problem sessions. |
SESSION_END_TIME |
This column contains the time at which the session ended. |
VARCHAR2(10) |
NOT NULL |
SESION |
This table contains information on problem sessions. |
SESSION_ID |
This column contains a system-generated sequencing number which always starts at 1 for
the first session of a call and increments for each subsequent session. |
NUMBER |
NOT NULL |
SESION |
This table contains information on problem sessions. |
SEVERITY |
This column contains the severity level of the session. |
NUMBER |
NOT NULL |
SESION |
This table contains information on problem sessions. |
SYSTEM |
This column contains the system which the caller thinks is causing the problem. |
VARCHAR2(15) |
NULL |
SESION |
This table contains information on problem sessions. |
USER_ID |
This column contains the ID of the user handling the session. Foreign key to the
USERS table. |
VARCHAR2(15) |
NOT NULL |
SEVERITY_LEVELS |
This table contains data related to problem severity levels. |
DESCRIPTION |
This column contains a free-form textual description of the severity. |
VARCHAR2(1024) |
NULL |
SEVERITY_LEVELS |
This table contains data related to problem severity levels. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
SEVERITY_LEVELS |
This table contains data related to problem severity levels. |
SEVERITY_LEVEL |
This column contains a unique user-supplied number indicating the severity level. |
NUMBER |
NOT NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
ACTIVE |
This column contains a value to indicate if the solution is currently active.
This allows solutions to be disabled when they become outdated. |
NUMBER |
NOT NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
ADD_DATE |
This column contains date that this solution was added. |
DATE |
NOT NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
ADD_TIME |
This column contains the time when this solution was added. |
VARCHAR2(10) |
NOT NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
ADD_USER_ID |
This column contains the user who added this solution. Foreign key to the USERS
table. |
VARCHAR2(15) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
COMPONENT |
This column contains the component to which this solution applies. |
VARCHAR2(15) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
DESCRIPTION |
This column contains a free-form description of the system. |
VARCHAR2(2000) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
FLX_SOL_DATE1 |
This column contains a date field for customizations purposes. |
DATE |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
FLX_SOL_DATE2 |
This column contains a date field for customizations purposes. |
DATE |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
FLX_SOL_INT1 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
FLX_SOL_INT2 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
FLX_SOL_INT3 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
FLX_SOL_INT4 |
This column contains an integer field for customization purposes. |
NUMBER |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
FLX_SOL_TIME1 |
This column contains a time field for customizations purposes. |
VARCHAR2(10) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
FLX_SOL_TIME2 |
This column contains a time field for customizations purposes. |
VARCHAR2(10) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
FLX_SOL_VCHR1 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
FLX_SOL_VCHR2 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
FLX_SOL_VCHR3 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
FLX_SOL_VCHR4 |
This column contains a 250-character field for customization purposes. |
VARCHAR2(250) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
ITEM |
This column contains the item to which this solution applies. |
VARCHAR2(15) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
LAST_USED_DATE |
This column contains the last date this solution was applied to the solution. |
DATE |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
LAST_USED_TIME |
This column contains the last time this solution was applied to a problem. |
VARCHAR2(10) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
MODULE |
This column contains the module to which this solution applies. |
VARCHAR2(15) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
ORGANIZATION_ID |
This column contains the organization to which the solution belongs. |
NUMBER |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
PROBLEM_ID |
This column defines a problem to attach new calls if this solution is activated.
This solution acts as an open problem when this column is defined. |
VARCHAR2(15) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
PROBLEM_TYPE |
This column contains the problem_type associated with this solution (for example,
HARDWARE, SOFTWARE). |
VARCHAR2(15) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
SECURITY |
This column contains the flag to determine which TPM End-user Web Interface users have
access. |
NUMBER |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
SEND_DATETIME |
This column contains the date the solution was transferred to other sites. |
NUMBER |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
SEVERITY |
This column contains the severity level that is associated with this solution. |
NUMBER |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
SOLUTION |
This column contains a free-form textual description of the solution to this problem. |
LONG |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
SOLUTION_ID |
This column contains a unique system-generated ID. |
NUMBER |
NOT NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
SYSTEM |
This column contains the system to which this solution applies. |
VARCHAR2(15) |
NULL |
SOLUTIONS |
This table contains solutions to be used with TPM. |
USAGE_COUNT |
This column contains the number of times this solution has been applied to a problem. |
NUMBER |
NOT NULL |
TRANSACTION_MAP |
This table contains the information used to create a data map between two different
tables on two different data sources. |
DESCRIPTION |
This column contains the freeform description for the transaction data map. |
VARCHAR2(254) |
NULL |
TRANSACTION_MAP |
This table contains the information used to create a data map between two different
tables on two different data sources. |
MAP_ID |
This column contains the unique integer identifier for the transaction data map. |
NUMBER |
NOT NULL |
TRANSACTION_MAP |
This table contains the information used to create a data map between two different
tables on two different data sources. |
MAP_NAME |
This column contains the name of the transaction data map. |
VARCHAR2(50) |
NOT NULL |
TRANSACTION_MAP |
This table contains the information used to create a data map between two different
tables on two different data sources. |
SRC1_DATAVIEW |
This column contains the data view or table name to map for source 1. |
VARCHAR2(50) |
NOT NULL |
TRANSACTION_MAP |
This table contains the information used to create a data map between two different
tables on two different data sources. |
SRC1_ID |
This column contains the integer identifier for the source 1 data mapping source, used
to tie SITE_ID and API callout action to this map. Foreign key to SOURCE table. |
NUMBER |
NOT NULL |
TRANSACTION_MAP |
This table contains the information used to create a data map between two different
tables on two different data sources. |
SRC2_DATAVIEW |
This column contains the data view or table name to map for source 1. |
VARCHAR2(50) |
NOT NULL |
TRANSACTION_MAP |
This table contains the information used to create a data map between two different
tables on two different data sources. |
SRC2_ID |
This column contains the integer identifier for the source 2 data mapping source, used
to tie SITE_ID and API callout action to this map. Foreign key to SOURCE table. |
NUMBER |
NOT NULL |
TRANSACTION_MAP |
This table contains the information used to create a data map between two different
tables on two different data sources. |
TRANSACTION_TYPE |
This column contains the integer transaction identifier used to indicate transactions
such as Create Problem. |
NUMBER |
NOT NULL |
TRANSFORM_ACTIONS |
This table contains the information to be used when transforming data between two
different data sources. |
DESCRIPTION |
This column contains the description of the transform action. |
VARCHAR2(254) |
NULL |
TRANSFORM_ACTIONS |
This table contains the information to be used when transforming data between two
different data sources. |
MODIFY_DATETIME |
This column contains the date and time the record was last updated. |
NUMBER |
NOT NULL |
TRANSFORM_ACTIONS |
This table contains the information to be used when transforming data between two
different data sources. |
T_ACTION |
This column contains the action to call when performing transformation. Format -
FILENAME:ROUTINE. |
VARCHAR2(80) |
NOT NULL |
TRANSFORM_ACTIONS |
This table contains the information to be used when transforming data between two
different data sources. |
T_ACTION_ID |
This column contains the unique identifier of this transaction. |
NUMBER |
NOT NULL |
TRANSFORM_ACTIONS |
This table contains the information to be used when transforming data between two
different data sources. |
T_ACTION_NAME |
This column contains the name of the action used in transforming data between two
different sources. |
VARCHAR2(50) |
NOT NULL |
TRANSLATIONS |
This table contains the information to be used when doing translations for unlike data
from one source to another. |
ARGUMENTS |
Arguments to be passed to the transform action which is used for this translation. |
VARCHAR2(254) |
NULL |
TRANSLATIONS |
This table contains the information to be used when doing translations for unlike data
from one source to another. |
DESCRIPTION |
This column contains the description of this translation. |
VARCHAR2(254) |
NULL |
TRANSLATIONS |
This table contains the information to be used when doing translations for unlike data
from one source to another. |
T_ACTION_ID |
This column contains the transaction identifier of the transform action being
performed in this translation. Foreign key to TRANSFORM_ACTIONS. |
NUMBER |
NOT NULL |
TRANSLATIONS |
This table contains the information to be used when doing translations for unlike data
from one source to another. |
TRANSLATION_ID |
This column contains the unique integer identifier of this translation. |
NUMBER |
NOT NULL |
TRANSLATIONS |
This table contains the information to be used when doing translations for unlike data
from one source to another. |
TRANSLATION_NAME |
This column contains the name of a translation used to translate unlike data from one
source to another. |
VARCHAR2(50) |
NOT NULL |
USER_DDVIEWS |
This table contains the information to be used when calling data views for specific
users. |
CONTEXT |
This column contains the string defining the place where this view is used. This
allows a user to have a different set of views when viewing different types of data (Work
with problems has different viewers defined than Work with Changes). |
VARCHAR2(50) |
NOT NULL |
USER_DDVIEWS |
This table contains the information to be used when calling data views for specific
users. |
USER_ID |
This column contains the unique user_id for this view. |
VARCHAR2(15) |
NOT NULL |
USER_DDVIEWS |
This table contains the information to be used when calling data views for specific
users. |
VIEWID |
This column contains the unique identifier of view. |
NUMBER |
NOT NULL |
WORK_HISTORY |
This table contains information on work history that is associated with a problem. |
DESC_OVRFLW |
This column contains the overflow for the description of the work history entry if it
is longer than 254 characters. |
LONG |
NULL |
WORK_HISTORY |
This table contains information on work history that is associated with a problem. |
DESCRIPTION |
This column contains a free-form description of the work performed. |
VARCHAR2(254) |
NULL |
WORK_HISTORY |
This table contains information on work history that is associated with a problem. |
MODIFY_DATETIME |
This column contains the date and time the record was last modified. |
NUMBER |
NOT NULL |
WORK_HISTORY |
This table contains information on work history that is associated with a problem. |
PROBLEM_ID |
This column contains the ID of the problem with which the entry is associated. |
VARCHAR2(15) |
NOT NULL |
WORK_HISTORY |
This table contains information on work history that is associated with a problem. |
SITE_ID |
|
VARCHAR2(6) |
NOT NULL |
WORK_HISTORY |
This table contains information on work history that is associated with a problem. |
USER_ID |
This column contains the ID of the user adding the entry. |
VARCHAR2(15) |
NOT NULL |
WORK_HISTORY |
This table contains information on work history that is associated with a problem. |
WORK_BEGIN_DATE |
This column contains the date at which the unit of work began. |
DATE |
NOT NULL |
WORK_HISTORY |
This table contains information on work history that is associated with a problem. |
WORK_BEGIN_TIME |
This column contains the time at which the unit of work began. |
VARCHAR2(10) |
NOT NULL |
WORK_HISTORY |
This table contains information on work history that is associated with a problem. |
WORK_END_DATE |
This column contains the date at which the unit of work ended. |
DATE |
NOT NULL |
WORK_HISTORY |
This table contains information on work history that is associated with a problem. |
WORK_END_TIME |
This column contains the time at which the unit of work ended. |
VARCHAR2(10) |
NOT NULL |
WORK_HISTORY |
This table contains information on work history that is associated with a problem. |
WORK_ID |
This column contains a unique system-generated sequencing ID. |
NUMBER |
NOT NULL |