Tivoli Problem Management Data Dictionary

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