Automatic Diagnostics Repository Schema
ADR_CONTROL
Name Type NULL?
----------------------------- --------------- -----------
ADRID number
SHORTP_POLICY number
LONGP_POLICY number
LAST_MOD_TIME timestamp
LAST_AUTOPRG_TIME timestamp
LAST_MANUPRG_TIME timestamp
ADRDIR_VERSION number
ADRSCHM_VERSION number
ADRSCHMV_SUMMARY number
ADRALERT_VERSION number
CREATE_TIME timestamp
ADR_INVALIDATION
Name Type NULL?
----------------------------- --------------- -----------
COMPID number
VALID number
AMS_XACTION
Name Type NULL?
----------------------------- --------------- -----------
FLAGS number
DDE_USER_ACTION_DEF
Name Type NULL?
----------------------------- --------------- -----------
ACTION_NAME text(31)
COMPONENT_NAME text(31)
DRIVER text(31)
COMMAND text(129)
DESCRIPTION text(129)
DETAILED_DESCRIPTION text(513)
ACTION_TYPE number
RESULT_TYPE number
NUM_PARAMETERS number
DDE_USER_ACTION_PARAMETER_DEF
Name Type NULL?
----------------------------- --------------- -----------
ACTION_NAME text(31)
PARAMETER_NAME text(31)
POSITION number
DESCRIPTION text(129)
DEFAULT text(256)
FLAGS number
DDE_USER_ACTION_PARAMETER
Name Type NULL?
----------------------------- --------------- -----------
INCIDENT_ID number
ACTION_NAME text(31)
PARAMETER_NAME text(31)
INVOCATION_ID number
POSITION number
PARAMETER_VALUE text(256)
DDE_USER_ACTION
Name Type NULL?
----------------------------- --------------- -----------
INCIDENT_ID number
ACTION_NAME text(31)
INVOCATION_ID number
STATUS number
ACTION_SOURCE number
INVOCATION_TIME timestamp
FINISH_TIME timestamp
DDE_USER_INCIDENT_ACTION_MAP
Name Type NULL?
----------------------------- --------------- -----------
TYPE_NAME text(31)
ACTION_NAME text(31)
DDE_USER_INCIDENT_TYPE
Name Type NULL?
----------------------------- --------------- -----------
TYPE_NAME text(31)
DESCRIPTION text(129)
EM_DIAG_JOB
Name Type NULL?
----------------------------- --------------- -----------
JOB_SEQ number
JOB_ID text(80)
EXECUTION_ID text(70)
JOB_NAME text(70)
JOB_DESCRIPTION text(256)
COMMAND_LINE text(256)
USER_NAME text(40)
STATUS number
OUTPUT text(1024)
EM_TARGET_INFO
Name Type NULL?
----------------------------- --------------- -----------
TARGETINFO_ID number
COMPOSITE_TARGET_NAME text(256)
COMPOSITE_TARGET_TYPE text(70)
COMPOSITE_TARGET_GUID text(70)
MEMBER_TARGET_NAME text(256)
MEMBER_TARGET_TYPE text(70)
MEMBER_TARGET_GUID text(70)
MEMBER_TARGET_EMD_URL text(1024)
EM_USER_ACTIVITY
Name Type NULL?
----------------------------- --------------- -----------
ACTIVITY_ID number
ACTIVITY_TYPE number
PARENT_TYPE number
PARENT_ID number
DETAIL text(200)
USER_NAME text(40)
JOB_ID text(80)
TIME_ENTERED timestamp
HM_FDG_SET
Name Type NULL?
----------------------------- --------------- -----------
FDG_SET_ID number
FDG_ID number
FLAGS number
CREATE_TIME timestamp
HM_FINDING
Name Type NULL?
----------------------------- --------------- -----------
FDG_ID number
RUN_ID number
PFDG_ID number
NAME text(31)
NAME_ID number
CLSNAME text(31)
CLSNAME_ID number
CREATE_TIME timestamp
MODIFIED_TIME timestamp
TYPE number
STATUS number
PRIORITY number
FLAGS number
CHILD_COUNT number
MSG_GRPID number
NUM_MSG number
DAMAGE_MSGGRP_ID number
NUM_DAMAGE_MSG number
HASH_CODE number
VERSION number
CLOSE_REASON number
INSTANCE_NUMBER number
SPARE_UB8 number
HM_INFO
Name Type NULL?
----------------------------- --------------- -----------
INFO_ID number
NAME text(31)
VALUE text(512)
TYPE number
FLAGS number
HM_MESSAGE
Name Type NULL?
----------------------------- --------------- -----------
OBJID number
MSGID number
SEQNO number
FLAGS number
MSGNO number
ARG1 text(512)
ARG2 text(512)
ARG3 text(512)
ARG4 text(512)
ARG5 text(512)
HM_RECOMMENDATION
Name Type NULL?
----------------------------- --------------- -----------
RECOMMENDATION_ID number
FDG_ID number
RUN_ID number
NAME text(31)
NAME_ID number
TYPE number
FLAGS number
RANK number
CREATE_TIME timestamp
END_TIME timestamp
STATUS number
EST_REPAIR_TIME number
ACT_REPAIR_TIME number
DATA_LOSS_TIME number
MSG_GRPID number
NUM_MSG number
REPAIR_SCRIPT bfile
HM_RUN
Name Type NULL?
----------------------------- --------------- -----------
RUN_ID number
RUN_NAME text(31)
CHECK_NAME text(31)
NAME_ID number
MODE number
START_TIME timestamp
RESUME_TIME timestamp
END_TIME timestamp
MODIFIED_TIME timestamp
TIMEOUT number
FLAGS number
STATUS number
SRC_INCIDENT_ID number
NUM_INCIDENTS number
ERR_NUMBER number
REPORT_FILE bfile
INC_METER_CONFIG
Name Type NULL?
----------------------------- --------------- -----------
CFG_ID number
TRANSIENT_INCIDENT_LIFE_TIME number
FLAGS number
CRITICAL_FACTOR number
WARNING_FACTOR number
WEIGHT_FACTOR number
MODIFICATION_TIME timestamp
PRODUCT_STARTUP_TIME timestamp
INC_METER_IMPT_DEF
Name Type NULL?
----------------------------- --------------- -----------
IMPACT_ID number
IMPACT_NAME text(128)
IMPACT_SCOPE number
IMPACT_SEVERITY number
IMPACT_DESC text(512)
IMPACT_FLAGS number
INC_METER_INFO
Name Type NULL?
----------------------------- --------------- -----------
INCIDENT_ID number
FLAGS number
CREATE_TIME timestamp
IMPACT1 number
IMPACT2 number
IMPACT3 number
IMPACT4 number
PROBLEM_ID number
SEVERITY number
INC_METER_PK_IMPTS
Name Type NULL?
----------------------------- --------------- -----------
PROBLEM_KEY text(550)
IMPACT1 number
IMPACT2 number
IMPACT3 number
IMPACT4 number
FLAGS number
INC_METER_SUMMARY
Name Type NULL?
----------------------------- --------------- -----------
SUMMARY_ID number
SEVERITY_INDEX number
CRITICAL_INCIDENTS number
WARNING_INCIDENTS number
NUM_INCIDENTS_LASTHOUR number
FLAGS number
CREATE_TIME timestamp
OLDEST_TRANSIENT_INC_CTIME timestamp
OLDEST_PERSISTENT_INC_CTIME timestamp
LATEST_INC_CTIME timestamp
INCCKEY
Name Type NULL?
----------------------------- --------------- -----------
INCIDENT_ID number
FLAGS number
KEY_NAME text(64)
KEY_VALUE text(526)
INCIDENT_FILE
Name Type NULL?
----------------------------- --------------- -----------
INCIDENT_ID number
OWNER_ID number
BFILE bfile
FLAGS number
INCIDENT
Name Type NULL?
----------------------------- --------------- -----------
INCIDENT_ID number
PROBLEM_ID number
CREATE_TIME timestamp
CLOSE_TIME timestamp
STATUS number
FLAGS number
FLOOD_CONTROLLED number
ERROR_FACILITY text(10)
ERROR_NUMBER number
ERROR_ARG1 text(64)
ERROR_ARG2 text(64)
ERROR_ARG3 text(64)
ERROR_ARG4 text(64)
ERROR_ARG5 text(64)
ERROR_ARG6 text(64)
ERROR_ARG7 text(64)
ERROR_ARG8 text(64)
SIGNALLING_COMPONENT text(64)
SIGNALLING_SUBCOMPONENT text(64)
SUSPECT_COMPONENT text(64)
SUSPECT_SUBCOMPONENT text(64)
ECID text(64)
IMPACT number
ERROR_ARG9 text(64)
ERROR_ARG10 text(64)
ERROR_ARG11 text(64)
ERROR_ARG12 text(64)
IPS_CONFIGURATION
Name Type NULL?
----------------------------- --------------- -----------
PARAMETER_ID number
UNIT number
VALUE number
DEFAULT_VALUE number
NAME text(32)
DESCRIPTION text(201)
MINIMUM number
MAXIMUM number
FLAGS number
IPS_FILE_COPY_LOG
Name Type NULL?
----------------------------- --------------- -----------
FILE_ID number
OPERATION number
OPERATION_TIME timestamp
EXTERNAL_FILE text(1025)
PACKAGE_ID number
INCIDENT_ID number
IPS_FILE_METADATA
Name Type NULL?
----------------------------- --------------- -----------
FILE_ID number
BFILE bfile
SOURCE number
FLAGS number
INCIDENT_ID number
IPS_PACKAGE_FILE
Name Type NULL?
----------------------------- --------------- -----------
PACKAGE_ID number
FILE_ID number
LAST_SEQUENCE number
EXCLUDE number
IPS_PACKAGE_HISTORY
Name Type NULL?
----------------------------- --------------- -----------
PACKAGE_ID number
SEQUENCE number
MODE number
STATUS number
ARCHIVE_TIME timestamp
UPLOAD_TIME timestamp
PHYSICAL_FILE text(1025)
BASE_SEQUENCE number
FLAGS number
IPS_PACKAGE_INCIDENT
Name Type NULL?
----------------------------- --------------- -----------
PACKAGE_ID number
PROBLEM_ID number
INCIDENT_ID number
TYPE number
EXCLUDE number
IPS_PACKAGE_UNPACK_HISTORY
Name Type NULL?
----------------------------- --------------- -----------
PACKAGE_ID number
SEQUENCE number
MODE number
ARCHIVE_TIME timestamp
FORCE number
FLAGS number
IPS_PACKAGE
Name Type NULL?
----------------------------- --------------- -----------
PACKAGE_ID number
FLAGS number
STATUS number
CREATION_TIME timestamp
LAST_SEQUENCE number
LAST_COMPLETE_SEQUENCE number
PROBLEM_ID number
NAME text(101)
DESCRIPTION text(301)
CORRELATION_LEVEL number
DRIVING_INCIDENT number
BEGIN_TIME timestamp
END_TIME timestamp
UPDATE_TIME timestamp
LAST_BASE_SEQUENCE number
IPS_REMOTE_PACKAGE
Name Type NULL?
----------------------------- --------------- -----------
PACKAGE_ID number
CORRELATED_ID number
REMOTE_HOME text(444)
REMOTE_TARGET text(71)
TARGET_TYPE text(71)
PICKLEERR
Name Type NULL?
----------------------------- --------------- -----------
FILE_NAME bfile
ERROR_CREATION timestamp
SECTION text(64)
ELEMENT text(64)
DESCRIPTION text(64)
ARG1 number
ARG2 number
PROBLEM
Name Type NULL?
----------------------------- --------------- -----------
PROBLEM_ID number
PROBLEM_KEY text(550)
FIRST_INCIDENT number
FIRSTINC_TIME timestamp
LAST_INCIDENT number
LASTINC_TIME timestamp
IMPACT1 number
IMPACT2 number
IMPACT3 number
IMPACT4 number
SERVICE_REQUEST text(64)
BUG_NUMBER text(64)
SWEEPERR
Name Type NULL?
----------------------------- --------------- -----------
INCIDENT_ID number
SWEEP_TIME timestamp
TOP_ERROR1 number
TOP_ERROR2 number
DESCRIPTION text(64)
VIEW
Name Type NULL?
----------------------------- --------------- -----------
OBJ_ID number
NAME text(64)
TEXT text(3800)
CREATION_TIME timestamp
SCOPE number
VERSION number
VIEWCOL
Name Type NULL?
----------------------------- --------------- -----------
OBJ_ID number
ORDER_ID number
NAME text(64)