You are on page 1of 1

ORDER_ID

SERVICE_ID

VARCHAR(5)

VARCHAR(5)
VARCHAR(100)

A_date_code_ABIMSVC
U1
U1

ORDER_ID
VARCHAR(1)
NUMBER
VARCHAR(4000)
VARCHAR(4000)
NUMBER
NUMBER
VARCHAR(256)
NUMBER
NUMBER
VARCHAR(256)

ORDER_ID
VARCHAR(60)
NUMBER
VARCHAR(1)
VARCHAR(8)
VARCHAR(1)

VARCHAR(5)

VARCHAR(5)
VARCHAR(5)
NUMBER
NUMBER
NUMBER

ORDER_ID
VARCHAR(255)
NUMBER
NUMBER
NUMBER
VARCHAR(4)
VARCHAR(1)

VARCHAR(5)

ORDER_ID
NUMBER
NUMBER
NUMBER
VARCHAR(6)
VARCHAR(45)
VARCHAR(6)
VARCHAR(8)

VARCHAR(5)

ORDER_ID
VARCHAR(20)
NUMBER
VARCHAR(44)
NUMBER
NUMBER
VARCHAR(64)
VARCHAR(8)
VARCHAR(10)
VARCHAR(770)
TEXT

VARCHAR(5)

ORDER_ID
VARCHAR(1)
NUMBER
VARCHAR(8)
VARCHAR(8)
NUMBER
NUMBER
VARCHAR(8)
VARCHAR(8)

VARCHAR(5)

ORDER_ID
VARCHAR(1)
VARCHAR(255)
VARCHAR(255)
NUMBER
NUMBER
NUMBER
VARCHAR(4000)
VARCHAR(255)
VARCHAR(1)

VARCHAR(5)

ORDER_ID
VARCHAR(64)
VARCHAR(4000)
NUMBER
NUMBER
NUMBER

VARCHAR(5)

ORDER_ID
NUMBER
VARCHAR(1)
NUMBER
NUMBER
VARCHAR(128)
VARCHAR(4000)

VARCHAR(5)

ORDER_ID
VARCHAR(16)
NUMBER
NUMBER
NUMBER
VARCHAR(255)
VARCHAR(1)

VARCHAR(5)

ORDER_ID
NUMBER
VARCHAR(1)
NUMBER
NUMBER
VARCHAR(255)
VARCHAR(16)

VARCHAR(5)

DESCRIPTION
REPORT_TYPE
SCOPE

NAME

METRIC

EVT_TIME
EVT_TYPE
NEW_VALUE
OLD_VALUE
ORDER_ID
STATE_DIGITS_NEW_FFU
STATE_DIGITS_OLD_FFU

EVT_NO

I1

I1

I1

ACTIVE NET
VARCHAR(5)

A_date_code_AJOB
ORDER_ID
ADJUST_COND
VARCHAR(1)
APPL_FORM
VARCHAR(30)
APPL_TYPE
VARCHAR(10)
APPL_VER
VARCHAR(10)
APPLICATION
VARCHAR(64)
ASSOCIATED_RBC
VARCHAR(20)
AUTO_ARCHIVE
VARCHAR(1)
AVG_RUNTIME
VARCHAR(6)
AVG_START_TIME
VARCHAR(6)
BIMINFO
VARCHAR(20)
CM_STATUS
VARCHAR(32)
CM_VER
VARCHAR(10)
CMD_LINE
VARCHAR(512)
CONFIRM_FLAG
VARCHAR(1)
CPU_ID
VARCHAR(50)
CPU_TIME
NUMBER
CRITICAL
VARCHAR(1)
CURRENT_RUN
NUMBER
CYCLIC
VARCHAR(1)
CYCLIC_TYPE
VARCHAR(1)
DAYSKEEPINNOTOK
NUMBER
DEF_NODEGROUP
VARCHAR(50)
DELAY
NUMBER
DELETE_FLAG
VARCHAR(1)
DEPEND_SERVICE_IN
VARCHAR(1)
DEPEND_SERVICE_OUT
VARCHAR(1)
DESCRIPTION
VARCHAR(4000)
DOC_LIB
VARCHAR(255)
DOC_MEM
VARCHAR(64)
DSECT_FFU
VARCHAR(100)
DUE_IN
VARCHAR(4)
DUE_OUT
VARCHAR(4)
DUE_OUT_DAYSOFFSET
VARCHAR(3)
ELAPSED
NUMBER
ELAPSED_RUNTIME
NUMBER
EM_STAT_CAL
VARCHAR(30)
EM_STAT_CAL_CTM
VARCHAR(20)
EM_STAT_DETAIL_DATA
VARCHAR(1500)
EM_STAT_PERIOD
VARCHAR(1)
END_TIME
VARCHAR(14)
FAILURE_RC
VARCHAR(5)
FAILURE_RC_PROCSTEP
VARCHAR(8)
FAILURE_RC_STEP
VARCHAR(8)
FROM_CLASS
VARCHAR(1)
FROM_DAYSOFFSET
VARCHAR(3)
FROM_PGMSTEP
VARCHAR(8)
FROM_PROCSTEP
VARCHAR(8)
FROM_TIME
VARCHAR(4)
GROUP_NAME
VARCHAR(64)
GRP_RBA
VARCHAR(6)
HIGHEST_RC
VARCHAR(5)
HIGHEST_RC_MEMNAME
VARCHAR(8)
HIGHEST_RC_PROCSTEP
VARCHAR(8)
HIGHEST_RC_STEP
VARCHAR(8)
IN_SERVICE
VARCHAR(255)
IND_CYCLIC
VARCHAR(1)
INSTREAM_JCL
TEXT
INTERVAL
VARCHAR(6)
INTERVAL_SEQUENCE
VARCHAR(4000)
ISN_
NUMBER
JOB_ID
VARCHAR(17)
JOB_NAME
VARCHAR(64)
JOBRC
VARCHAR(5)
LPAR
VARCHAR(8)
MAX_DAYS
NUMBER
MAX_RERUN
NUMBER
MAX_RUNS
NUMBER
MAX_WAIT
NUMBER
MEM_LIB
VARCHAR(255)
MEMNAME
VARCHAR(64)
MULTY_AGENT
VARCHAR(1)
NEXT_TIME
VARCHAR(14)
NJE
VARCHAR(1)
NJE_NODE
VARCHAR(8)
NODEGROUP
VARCHAR(50)
NODEGROUP_SET_BY
VARCHAR(1)
NR_RECORDS
NUMBER
ODATE
VARCHAR(6)
ORDER_LIB
VARCHAR(44)
ORDER_TABLE
VARCHAR(770)
ORDER_TIME
VARCHAR(14)
OVER_LIB
VARCHAR(255)
OWNER
VARCHAR(30)
PARM
VARCHAR(255)
PREV_ODATE_RERUN_COUNTER NUMBER
PREVENT_NCT2
VARCHAR(1)
PRIORITY
VARCHAR(2)
RBA
VARCHAR(6)
REMOVEATONCE
VARCHAR(1)
REQ_NJE_NODE
VARCHAR(8)
RERUN_COUNTER
NUMBER
RERUN_MEM
VARCHAR(8)
RETEN_DAYS
VARCHAR(3)
RETEN_GEN
VARCHAR(2)
SCHEDULE_ENV
VARCHAR(16)
SEARCH_COUNT
NUMBER
SEQ_CNT
NUMBER
SEQ_CNT_ADDED
NUMBER
SHORT_FFU
VARCHAR(12)
SPECIFIC_TIMES
VARCHAR(4000)
START_TIME
VARCHAR(14)
STAT_CAL
VARCHAR(30)
STAT_PERIOD
VARCHAR(1)
STATE
VARCHAR(40)
STATE_DIGITS
VARCHAR(15)
STATE_MASK
VARCHAR(9)
STATUS
VARCHAR(16)
STD_DEV
VARCHAR(6)
STD_DEV_START_TIME
VARCHAR(11)
STICKY_IND
VARCHAR(1)
SYS_AFFINITY
VARCHAR(5)
SYSDB
VARCHAR(1)
SYSOPT
VARCHAR(16)
TASK_CLASS
VARCHAR(3)
TASK_TYPE
VARCHAR(21)
TIME_REF
VARCHAR(1)
TIME_ZONE
VARCHAR(9)
TO_DAYSOFFSET
VARCHAR(3)
TO_PGMSTEP
VARCHAR(8)
TO_PROCSTEP
VARCHAR(8)
TO_TIME
VARCHAR(4)
TOLERANCE
NUMBER
USE_INSTREAM_JCL
VARCHAR(1)
WORKLOADS
VARCHAR(525)

VARCHAR(5)

A_date_code_ALNKI_C
ORDER_ID
VARCHAR(1)
NUMBER
VARCHAR(64)
VARCHAR(1)

ORDER_ID

VARCHAR(5)

A_date_code_ALNKI_P

HANDLE_RES_NOTOK
ISN_
RESOURCE_
TYPE

VARCHAR(1)
VARCHAR(255)
VARCHAR(1)
NUMBER
VARCHAR(4)
NUMBER
VARCHAR(2)

VARCHAR(5)

A_date_code_ALNKI_Q

AND_OR
CONDITION
IGNORE
ISN_
ODATE
ORDER_
PARENTHESES

ORDER_ID
VARCHAR(1)
VARCHAR(1)
NUMBER
NUMBER
VARCHAR(64)

I1,I2

FK,I1 REPORT_ID

I1
HANDLE_RES_NOTOK
HANDLE_RES_OK
ISN_
QUANT
RESOURCE_

MEASUREMENTS
VARCHAR(100)

VARCHAR(50)
VARCHAR(100)
VARCHAR(50)
VARCHAR(255)
NUMBER
VARCHAR(14)
NUMBER
NUMBER
VARCHAR(100)

VARCHAR(100)

METRIC_DATA

VARCHAR(10)
VARCHAR(20)
VARCHAR(255)
VARCHAR(50)
VARCHAR(30)

NUMBER

NET_REPORT_SRV_DATA
VARCHAR(255)
VARCHAR(50)
VARCHAR(100)

TIMESTMP
VARCHAR(1)
NUMBER
NUMBER
VARCHAR(5)
VARCHAR(15)
VARCHAR(15)

NUMBER

A_date_code_AEVT

DO_NO
FROM_CLASS
IF_NO
ISN_
PARM
SYSOPT

A_date_code_ADO_SYSOUT

DESTINATION
DO_NO
IF_NO
ISN_
MESSAGE
URGENCY

A_date_code_ADO_SHOUT

DO_NO
GLOBAL_IND
IF_NO
ISN_
NAME
VALUE

A_date_code_ADO_SETVAR

ATTR_NAME
ATTR_VALUE
DO_NO
IF_NO
ISN_

A_date_code_ADO_REMEDY

ATTACH_SYSOUT
CC_DESTINATION
DESTINATION
DO_NO
IF_NO
ISN_
MESSAGE
SUBJECT_LINE
URGENCY

A_date_code_ADO_MAIL

CNF_FLAG
DO_NO
FROM_PGMSTEP
FROM_PROCSTEP
IF_NO
ISN_
TO_PGMSTEP
TO_PROCSTEP

A_date_code_ADO_IFRERUN

DATA_CENTER
DO_NO
DSN
IF_NO
ISN_
JOB
ODATE
REMOTE
SCHED_TABLE
VARS_AS_STR

A_date_code_ADO_FORCEJ

DO_NO
IF_NO
ISN_
NEXT_DATE
PARAMETERS
PREV_DATE
RULE_NAME

A_date_code_ADO_CTBRULE

CONDITION
DO_NO
IF_NO
ISN_
ODATE
SIGN

A_date_code_ADO_COND

ACTION
DO_NO
IF_NO
ISN_

ORDER_ID

A_date_code_ADO

ARGUMENTS
ISN_
POSITION
RULE_NAME
TYPE

A_date_code_ACTB_STEP

A_date_code_ACAPTURE
I1
BY_WHAT
COUNT_TO_TAKE
DELIMITER
FUTURE_USE
ISN_
ORDER_
SEARCH_STRING
SKIP_COLUMNS
SKIP_LINES
VARIABLE

I1

I1

I1

I1

I1

I1

I1

I1

I1

I1

I1

I1

PK

PK

FK,I1 NAME

APPL_TYPE
DATA_CENTER
HOSTNAME
NODE_ID
OWNER

VARCHAR(100)
VARCHAR(50)
VARCHAR(100)

METRIC_CONF
PK
COMP_NAME
PK
COMP_TYPE
PK,FK NAME
I3
I2
I4
I5

ADDITIONAL_DATA
COMP_NAME
COMP_TYPE
HOSTNAME
METRIC_DATE_IDX
METRIC_TIME
METRIC_TIME_IDX
PID
VALUE

NUMBER
VARCHAR(1)
NUMBER

NUMBER
NUMBER
NUMBER
NUMBER

VARCHAR(100)
NUMBER
VARCHAR(255)

NET_REPORT_DATA

DAYS_TO_KEEP
ENABLED
INTERVAL_SEC

PK
FNAME
PK
REPORT_ID
PK,FK FVALUE
FUTURE1
FUTURE2
FUTURE3
JOBS

I1

ORDER_ID
VARCHAR(255)
NUMBER
VARCHAR(4)
VARCHAR(1)

VARCHAR(5)

A_date_code_ALNKO_P
CONDITION
ISN_
ODATE
SIGN

VARCHAR(5)
NUMBER

A_date_code_ANET_RUNINFO

VARCHAR(14)
VARCHAR(16)
VARCHAR(14)

ORDER_ID
NUMBER
VARCHAR(255)

VARCHAR(5)

VARCHAR(5)
VARCHAR(1)
VARCHAR(255)
VARCHAR(3)
VARCHAR(3)
VARCHAR(40)
NUMBER
NUMBER
NUMBER
VARCHAR(1)
VARCHAR(8)
VARCHAR(8)
VARCHAR(132)

ORDER_ID
VARCHAR(1)
NUMBER
VARCHAR(44)

VARCHAR(5)

NUMBER
VARCHAR(5)
VARCHAR(1)
VARCHAR(6)
VARCHAR(64)
VARCHAR(1)

SIGN
TIMEUTC

CONDITION
ODATE
VARCHAR(1)
VARCHAR(14)

VARCHAR(255)
VARCHAR(4)

A_date_code_ARES_P

COUNTER
ORDER_ID
PRIORITY
RBA
RESOURCE_
TYPE

A_date_code_ARES_C

FLAG
ISN_
PIPE_NAME

A_date_code_APIPES

AND_OR
CODE
FIND_PATTERN_FROM
FIND_PATTERN_TO
FIND_SYSOUT_PATTERN
IF_NO
ISN_
ON_NO
PGM_BLOCK
PGM_STEP
PROC_STEP
STMT

ORDER_ID

A_date_code_AON

ISN_
TEXT

A_date_code_ANOTES

END_TIME
ENDED_STATUS
START_TIME

PK,I1 ORDER_ID
PK
RERUN_COUNTER

I1

I1

I1

U1
U1
U1

U1
U1

NUMBER
VARCHAR(5)
VARCHAR(1)
NUMBER
VARCHAR(6)
VARCHAR(64)
VARCHAR(1)

A_date_code_ARES_Q
MAX_RES
ORDER_ID
PRIORITY
QUANT
RBA
RESOURCE_
TYPE

ORDER_ID
VARCHAR(1)
NUMBER
VARCHAR(128)
NUMBER
VARCHAR(4000)

VARCHAR(5)

U1
U1
U1

GLOBAL_IND
ISN_
NAME
ORDER_
VALUE

A_date_code_ASETVAR
I1

ORDER_ID
VARCHAR(16)
NUMBER
VARCHAR(255)
VARCHAR(3)
VARCHAR(5)
VARCHAR(1)
VARCHAR(10)

VARCHAR(5)

VARCHAR(5)
VARCHAR(8)
VARCHAR(8)
NUMBER
VARCHAR(7)
VARCHAR(8)
VARCHAR(8)

DATA_CENTER
NUMBER
NUMBER
VARCHAR(3)
TIMESTMP
TIMESTMP
TIMESTMP
TIMESTMP
VARCHAR(8)
VARCHAR(12)
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR(25)

VARCHAR(20)

CODE
CONTROL_M_VER
CREATE_TIME
CTM_HOST_NAME
DATA_CENTER
EXECUTIONS
FUTURE1
FUTURE2
FUTURE3
JOBS
NET_DATE
NET_DATE_IDX
NET_NAME
PLATFORM
SCHED_GROUPS

REPORT_ID

VARCHAR(3)
VARCHAR(3)
TIMESTMP
VARCHAR(255)
VARCHAR(20)
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
TIMESTMP
NUMBER
VARCHAR(12)
VARCHAR(10)
NUMBER

NUMBER

NET_REPORT

DB_BASE_LEVEL
DB_UPDATE_LEVEL
DC_CODE
DEL_TIME
DOWNLOAD_TIME
NET_END_TIME
NET_START_TIME
NETDATE
NETNAME
NR_CAPTURE
NR_CTB_STEP
NR_DO
NR_DO_COND
NR_DO_CTBRULE
NR_DO_FORCEJ
NR_DO_IFRERUN
NR_DO_MAIL
NR_DO_REMEDY
NR_DO_SETVAR
NR_DO_SHOUT
NR_DO_SYSOUT
NR_JOB
NR_LNKI_C
NR_LNKI_P
NR_LNKI_Q
NR_LNKO_P
NR_NOTES
NR_ON
NR_PIPES
NR_RES_C
NR_RES_P
NR_RES_Q
NR_SETVAR
NR_SHOUT
NR_STEP_RANGE
TEXT

DOWNLOAD

FROM_PGMSTEP
FROM_PROCSTEP
ISN_
NAME
TO_PGMSTEP
TO_PROCSTEP

ORDER_ID

A_date_code_ASTEP_RANGE

DESTINATION
ISN_
MESSAGE
SHOUT_DAYSOFFSET
SHOUT_TIME
URGENCY
WHEN_COND

A_date_code_ASHOUT

I1

I1

I1

U1

U1

PK

U1

TIMESTMP
VARCHAR(1)
NUMBER

DEF_CACHE_TABLES_EVT
PK,I1 EVENT_TIMESTAMP
PK
EVENT_TYPE
PK
TABLE_ID

DEF_CTM_LEVEL_RBC
VARCHAR(30)
VARCHAR(3)
VARCHAR(10)
VARCHAR(20)
VARCHAR(8)
VARCHAR(8)
VARCHAR(30)
VARCHAR(255)
VARCHAR(160)
VARCHAR(30)
VARCHAR(2)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(10)
VARCHAR(3)
VARCHAR(1)
VARCHAR(53)
VARCHAR(30)

ID
VARCHAR(17)
VARCHAR(64)
VARCHAR(512)
CHARACTER(1)
VARCHAR(100)
TEXT
VARCHAR(512)
VARCHAR(20)
VARCHAR(17)
VARCHAR(64)

NUMBER

DEF_ITEMS

ACTIVE_FROM
ACTIVE_TILL
CONF_CAL
DATES_STR
DAY_STR
DAYS_CAL
MAX_WAIT
MONTH_1
MONTH_10
MONTH_11
MONTH_12
MONTH_2
MONTH_3
MONTH_4
MONTH_5
MONTH_6
MONTH_7
MONTH_8
MONTH_9
SHIFT
SHIFT_NUM
TAG_RELATION_DC_WC
W_DAY_STR
WEEKS_CAL

PK,FP RBC_NAME
PK,FP CAL_DEF_TYPE
PK,FP CAL_STATUS
PK,FP DATA_CENTER

PK

U1
U1

CREATE_TIME
CREATE_UID
DESCRIPTION
ENABLED
NAME
RAW_DATA
RESERVE1
TYPE
UPDATE_TIME
UPDATE_UID

VARCHAR(1)
NUMBER
VARCHAR(4000)
VARCHAR(4000)
VARCHAR(1)
NUMBER
VARCHAR(256)
NUMBER
NUMBER
VARCHAR(256)
VARCHAR(1)

NUMBER
NUMBER
NUMBER
NUMBER

DEF_VER_CAPTURE
PK,FK VERSION_SERIAL
PK,FK TABLE_ID
PK,FK JOB_ID
PK
ORDER_
BY_WHAT
COUNT_TO_TAKE
DELIMITER
FUTURE_USE
IS_CURRENT_VERSION
ISN_
SEARCH_STRING
SKIP_COLUMNS
SKIP_LINES
VARIABLE
VERSION_OPCODE

NUMBER
NUMBER
NUMBER

DEF_VER_CTB_STEP

VARCHAR(60)
VARCHAR(1)
NUMBER
VARCHAR(1)
VARCHAR(8)
VARCHAR(1)
VARCHAR(1)

NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR(5)
SMALLINT
SMALLINT
VARCHAR(1)
VARCHAR(1)

DEF_VER_DO

ARGUMENTS
IS_CURRENT_VERSION
ISN_
POSITION
RULE_NAME
TYPE
VERSION_OPCODE

FP,FP,U1 VERSION_SERIAL
FK,U1
JOB_ID
FK,U1
TABLE_ID

U1

U1
U1
U1
U1

ISN_
JOB_ID
TABLE_ID
VERSION_SERIAL
ACTION
DO_NO
IF_NO
IS_CURRENT_VERSION
VERSION_OPCODE

NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR(255)
SMALLINT
SMALLINT
VARCHAR(1)
VARCHAR(4)
VARCHAR(1)
VARCHAR(1)

DEF_VER_DO_COND
U1
U1
U1
U1

ISN_
JOB_ID
TABLE_ID
VERSION_SERIAL
CONDITION
DO_NO
IF_NO
IS_CURRENT_VERSION
ODATE
SIGN
VERSION_OPCODE

SERVICE_ODAT
SERVICE_KEY

U1
U1
U1
U1

U1
U1
U1
U1

U1
U1
U1
U1

U1
U1
U1
U1
U1
U1

U1
U1
U1
U1

U1
U1
U1
U1

U1
U1
U1
U1

PK

I2

I1

I3

PK

PK
PK

NUMBER
NUMBER
NUMBER
NUMBER

NUMBER
NUMBER
NUMBER
NUMBER

VARCHAR(64)
VARCHAR(4000)
VARCHAR(1)
VARCHAR(1)

NUMBER
NUMBER
NUMBER
NUMBER
SMALLINT
SMALLINT

NUMBER
NUMBER
NUMBER
NUMBER

NUMBER
NUMBER
NUMBER
NUMBER

VARCHAR(66)
VARCHAR(100)

BIM_AUTH_ID

VARCHAR(64)
VARCHAR(1)
VARCHAR(1)
VARCHAR(20)
VARCHAR(4000)
VARCHAR(1)
VARCHAR(64)
VARCHAR(64)
VARCHAR(17)
VARCHAR(64)
VARCHAR(30)
VARCHAR(21)

VARCHAR(64)

NUMBER
NUMBER
NUMBER

DEF_VER_JOB

VARCHAR(8)
VARCHAR(8)
VARCHAR(1)
VARCHAR(30)
VARCHAR(10)
VARCHAR(10)
VARCHAR(64)
VARCHAR(64)
VARCHAR(1)
VARCHAR(8)
VARCHAR(8)
VARCHAR(64)
VARCHAR(256)
VARCHAR(10)
VARCHAR(512)
VARCHAR(30)
VARCHAR(1)
VARCHAR(8)
VARCHAR(8)
VARCHAR(64)
VARCHAR(1)
VARCHAR(20)
VARCHAR(1)
VARCHAR(1)
VARCHAR(255)
VARCHAR(160)
VARCHAR(1)
VARCHAR(30)
SMALLINT
NUMBER
VARCHAR(255)
VARCHAR(14)
VARCHAR(64)
VARCHAR(4000)
VARCHAR(255)
VARCHAR(64)
VARCHAR(4)
VARCHAR(3)
VARCHAR(14)
VARCHAR(1)
VARCHAR(3)
VARCHAR(4)
VARCHAR(64)
VARCHAR(1)
TEXT
VARCHAR(6)
VARCHAR(4000)
VARCHAR(1)
VARCHAR(64)
VARCHAR(10)
NUMBER
VARCHAR(10)
VARCHAR(5)
VARCHAR(5)
VARCHAR(6)
SMALLINT
NUMBER
SMALLINT
SMALLINT
VARCHAR(255)
VARCHAR(64)
VARCHAR(3)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(50)
VARCHAR(255)
VARCHAR(30)
VARCHAR(770)
VARCHAR(255)
VARCHAR(44)
VARCHAR(1)
VARCHAR(1)
VARCHAR(2)
VARCHAR(1)
VARCHAR(8)
VARCHAR(8)
VARCHAR(3)
VARCHAR(2)
VARCHAR(1)
VARCHAR(16)
VARCHAR(10)
VARCHAR(3)
VARCHAR(4000)
VARCHAR(30)
VARCHAR(9)
VARCHAR(14)
VARCHAR(1)
VARCHAR(5)
VARCHAR(1)
VARCHAR(16)
VARCHAR(1)
VARCHAR(3)
VARCHAR(21)
VARCHAR(1)
VARCHAR(9)
VARCHAR(3)
VARCHAR(4)
NUMBER
VARCHAR(1)
VARCHAR(255)
VARCHAR(1)
VARCHAR(14)
VARCHAR(64)
VARCHAR(50)
VARCHAR(30)

CALENDAR

VARCHAR(20)
VARCHAR(4000)
VARCHAR(4000)
VARCHAR(255)
NUMBER
VARCHAR(4000)

VARCHAR(30)

SAMPLES_CPU_TIME

VARCHAR(4000)
VARCHAR(4000)
VARCHAR(4000)
VARCHAR(770)
VARCHAR(30)
VARCHAR(20)
VARCHAR(1)
NUMBER
NUMBER

VARCHAR(4000)

DATE_INDEX
DATE_DATETIME
DATE_DAY
DATE_MONTH
DATE_WDAY
DATE_YEAR
FULLDATE
ID

FIVE_MIN
FULL_HOUR
HALF_HOUR
ID
QUAR_HOUR
SIXTH_HOUR
TIME_FROM
TIME_TO

TIMESTMP
NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR(8)
NUMBER

VARCHAR(13)
VARCHAR(13)
VARCHAR(13)
NUMBER
VARCHAR(13)
VARCHAR(13)
VARCHAR(5)
VARCHAR(5)

TIME_INDEX

SAMPLES_FIRST_START_TIME VARCHAR(4000)

SAMPLES_JOB_ID
SAMPLES_RUN_TIME
SAMPLES_START_TIME
SCHED_TABLE
STAT_CAL
STAT_CAL_CTM
STAT_PERIOD
STD_DEV
STD_DEV_START_TIME

SAMPLES_AGENT_ELAPSED_TIME VARCHAR(4000)

AVG_AGENT_ELAPSED_TIME NUMBER
AVG_ALL_START_TIME
VARCHAR(6)
AVG_CPU_TIME
NUMBER
AVG_RUN_TIME
NUMBER
AVG_START_TIME
VARCHAR(6)
DATA_CENTER
VARCHAR(20)
DSN
VARCHAR(44)
JOB_MEM_NAME
VARCHAR(64)
LAST_UPDATED
TIMESTMP
MAX_RUN_TIME
NUMBER
MIN_RUN_TIME
NUMBER
NODE_GROUP
VARCHAR(50)

AVG_RUN_INFO

CALENDAR_CTM
DESCRIPTION
JOB_FILTER
NAME
ORDER_
RESERV1

DF_PERIODIC_STATS

ACTIVE_FROM
ACTIVE_TILL
ADJUST_COND
APPL_FORM
APPL_TYPE
APPL_VER
APPLICATION
AUTHOR
AUTO_ARCHIVE
CHANGE_DATE
CHANGE_TIME
CHANGE_USERID
CHECKSUM
CM_VER
CMD_LINE
CONF_CAL
CONFIRM_FLAG
CREATION_DATE
CREATION_TIME
CREATION_USER
CRITICAL
CTLD_CATEGORY
CYCLIC
CYCLIC_TYPE
DATES_STR
DAY_STR
DAYS_AND_OR
DAYS_CAL
DAYSKEEPINNOTOK
DELAY
DELETION_HOST
DELETION_TIMESTAMP
DELETION_USER
DESCRIPTION
DOC_LIB
DOC_MEM
DUE_OUT
DUE_OUT_DAYSOFFSET
EXPIRATION_TIMESTAMP
FROM_CLASS
FROM_DAYSOFFSET
FROM_TIME
GROUP_NAME
IND_CYCLIC
INSTREAM_JCL
INTERVAL
INTERVAL_SEQUENCE
IS_CURRENT_VERSION
JOB_NAME
JOB_NO
JOB_ORDER
JOB_RELESE
JOB_VERSION
JOBS_IN_GROUP
LARGE_SIZE
MAX_DAYS
MAX_RERUN
MAX_RUNS
MAX_WAIT
MEM_LIB
MEMNAME
MIN_PDS_TRACKS
MONTH_1
MONTH_10
MONTH_11
MONTH_12
MONTH_2
MONTH_3
MONTH_4
MONTH_5
MONTH_6
MONTH_7
MONTH_8
MONTH_9
MULTY_AGENT
NODE_ID
OVER_LIB
OWNER
PARENT_TABLE
PARM
PDS
PREV_DAY
PREVENT_NCT2
PRIORITY
REMOVEATONCE
REQ_NJE_NODE
RERUN_MEM
RETEN_DAYS
RETEN_GEN
RETRO
SCHEDULE_ENV
SHIFT
SHIFT_NUM
SPECIFIC_TIMES
STAT_CAL
STATE_MASK
SYNC_TIMESTAMP
SYNC_TYPE
SYS_AFFINITY
SYSDB
SYSOPT
TAG_RELATIONSHIP
TASK_CLASS
TASK_TYPE
TIME_REF
TIME_ZONE
TO_DAYSOFFSET
TO_TIME
TOLERANCE
USE_INSTREAM_JCL
VERSION_HOST
VERSION_OPCODE
VERSION_TIMESTAMP
VERSION_USER
W_DAY_STR
WEEKS_CAL

PK
VERSION_SERIAL
PK
JOB_ID
PK,FK TABLE_ID

I3

I4

I8
I2
I7

I1

I5

I6

PK

I1
I3
I4

I5

I2

I5
I1
I2
U6
I3
I4
U7
U8

U2
U2
U2
U3
U1

U1

U1

U1

U1

U1

I3
I1

I2

FK

U1

IS_CURRENT_VERSION
ISN_
TAG_NAME
VERSION_OPCODE

NUMBER
NUMBER
NUMBER
VARCHAR(1)
NUMBER
VARCHAR(20)
VARCHAR(1)

DEF_VER_LNKI_C
NUMBER
NUMBER
NUMBER
VARCHAR(1)
VARCHAR(1)
NUMBER
VARCHAR(64)
VARCHAR(1)
VARCHAR(1)

NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR(1)
VARCHAR(255)
VARCHAR(1)
NUMBER
VARCHAR(4)
VARCHAR(2)
VARCHAR(1)

NUMBER
NUMBER
NUMBER
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
NUMBER
NUMBER
VARCHAR(64)
VARCHAR(1)

NUMBER
NUMBER
NUMBER
VARCHAR(255)
VARCHAR(1)
NUMBER
VARCHAR(4)
VARCHAR(1)
VARCHAR(1)

VARCHAR(1)
VARCHAR(255)
VARCHAR(3)
VARCHAR(3)
VARCHAR(40)
SMALLINT
VARCHAR(1)
NUMBER
SMALLINT
VARCHAR(8)
VARCHAR(8)
VARCHAR(132)
VARCHAR(1)

NUMBER
NUMBER
NUMBER

DEF_VER_ON

CONDITION
IS_CURRENT_VERSION
ISN_
ODATE
SIGN
VERSION_OPCODE

AGENT_ELAPSED_TIME
APPLICATION
CPU_TIME
DSN
END_TIME
ENDED_STATUS
GROUP_NAME
JOB_ID
JOB_MEM_NAME
NETNAME
NODE_GROUP
NODE_ID
ORDER_DATE
ORDER_ID
OWNER
RERUN_COUNTER
SCHED_TABLE
START_TIME
STAT_CAL
STAT_CAL_CTM
STAT_PERIOD
WORKLOADS

NUMBER
NUMBER
NUMBER
VARCHAR(1)
VARCHAR(1)
NUMBER
VARCHAR(44)
VARCHAR(1)

NUMBER
NUMBER
NUMBER
VARCHAR(8)
VARCHAR(8)
VARCHAR(1)
NUMBER
VARCHAR(7)
VARCHAR(8)
VARCHAR(8)
VARCHAR(1)

NUMBER
NUMBER
NUMBER
VARCHAR(1)
VARCHAR(1)
NUMBER
VARCHAR(128)
VARCHAR(4000)
VARCHAR(1)
NUMBER

NUMBER
VARCHAR(64)
NUMBER
VARCHAR(20)
VARCHAR(44)
NUMBER
TIMESTMP
NUMBER
NUMBER
VARCHAR(64)
VARCHAR(17)
VARCHAR(64)
VARCHAR(50)
VARCHAR(50)
VARCHAR(8)
VARCHAR(5)
VARCHAR(30)
NUMBER
NUMBER
VARCHAR(770)
NUMBER
TIMESTMP
NUMBER
VARCHAR(30)
VARCHAR(20)
VARCHAR(1)
VARCHAR(525)

NUMBER
VARCHAR(64)
NUMBER
VARCHAR(44)
TIMESTMP
NUMBER
VARCHAR(64)
VARCHAR(17)
VARCHAR(64)
CHARACTER(12)
VARCHAR(50)
VARCHAR(50)
CHARACTER(8)
CHARACTER(5)
VARCHAR(30)
NUMBER
VARCHAR(770)
TIMESTMP
VARCHAR(30)
VARCHAR(20)
VARCHAR(1)
VARCHAR(525)

C001_RUNINFO

AGENT_ELAPSED_TIME
APPLICATION
CPU_TIME
DATA_CENTER
DSN
END_DATE_IDX
END_TIME
END_TIME_IDX
ENDED_STATUS
GROUP_NAME
JOB_ID
JOB_MEM_NAME
NODE_GROUP
NODE_ID
ORDER_DATE
ORDER_ID
OWNER
RERUN_COUNTER
RUN_TIME_SEC
SCHED_TABLE
START_DATE_IDX
START_TIME
START_TIME_IDX
STAT_CAL
STAT_CAL_CTM
STAT_PERIOD
WORKLOADS

RUNINFO_HISTORY

JOB STATISTICS

GLOBAL_IND
IS_CURRENT_VERSION
ISN_
NAME
VALUE
VERSION_OPCODE
VERSION_SERIAL

FK,U1 JOB_ID
FK,U1 ORDER_
FK,U1 TABLE_ID

DEF_VER_SETVAR

FROM_PGMSTEP
FROM_PROCSTEP
IS_CURRENT_VERSION
ISN_
NAME
TO_PGMSTEP
TO_PROCSTEP
VERSION_OPCODE

FK,U1 VERSION_SERIAL
FK,U1 JOB_ID
FK,U1 TABLE_ID

DEF_VER_STEP_RANGE

FLAG
IS_CURRENT_VERSION
ISN_
PIPE_NAME
VERSION_OPCODE

FK,U1 JOB_ID
FK,U1 TABLE_ID
FK,U1 VERSION_SERIAL

DEF_VER_PIPES

AND_OR
CODE
FIND_PATTERN_FROM
FIND_PATTERN_TO
FIND_SYSOUT_PATTERN
IF_NO
IS_CURRENT_VERSION
ISN_
ON_NO
PGM_STEP
PROC_STEP
STMT
VERSION_OPCODE

FK,U1 JOB_ID
FK,U1 TABLE_ID
FK,U1 VERSION_SERIAL

U1

FK,U1 JOB_ID
FK,U1 TABLE_ID
FK,U1 VERSION_SERIAL

DEF_VER_LNKO_P

HANDLE_RES_NOTOK
HANDLE_RES_OK
IS_CURRENT_VERSION
ISN_
QUANT
RESOURCE_
VERSION_OPCODE

FK,U1 JOB_ID
FK,U1 TABLE_ID
FK,U1 VERSION_SERIAL

DEF_VER_LNKI_Q

AND_OR
CONDITION
IS_CURRENT_VERSION
ISN_
ODATE
PARENTHESES
VERSION_OPCODE

PK,FK JOB_ID
PK,FK TABLE_ID
PK,FK VERSION_SERIAL
PK
ORDER_

DEF_VER_LNKI_P

HANDLE_RES_NOTOK
IS_CURRENT_VERSION
ISN_
RESOURCE_
TYPE
VERSION_OPCODE

FK,U1 JOB_ID
FK,U1 TABLE_ID
FK,U1 VERSION_SERIAL

U1

FK,U1 JOB_ID
FK,U1 TABLE_ID
FK,U1 VERSION_SERIAL

DEF_VER_JOB_TAGS

NUMBER

VARCHAR(20)
VARCHAR(3)
VARCHAR(10)
VARCHAR(30)

VARCHAR(3)
VARCHAR(10)
VARCHAR(30)
VARCHAR(20)
CHARACTER(4)

NAME
VALUE

NUMBER
VARCHAR(20)

U1

PK

VARCHAR(255)
VARCHAR(4000)

CPU_ARCH
FUTURE1
FUTURE2
FUTURE3
IS_APPL_JOB_RUNNER
IS_OS_JOB_RUNNER
LAST_UPDATED
NUM_CPU
NUM_SOCKETS
OS_TYPE
OS_VERSION

VARCHAR(100)
VARCHAR(100)
VARCHAR(100)
VARCHAR(100)
NUMBER
NUMBER
VARCHAR(17)
VARCHAR(10)
VARCHAR(10)
VARCHAR(100)
VARCHAR(128)

VARCHAR(255)

INSTALL_HOST
INSTALL_ACC_INS

VARCHAR(256)
VARCHAR(256)
VARCHAR(8)
VARCHAR(48)
VARCHAR(255)
VARCHAR(256)
VARCHAR(512)
VARCHAR(256)
VARCHAR(8)
VARCHAR(48)
VARCHAR(32)
VARCHAR(64)
VARCHAR(8)
VARCHAR(128)
VARCHAR(512)
VARCHAR(48)
VARCHAR(8)
VARCHAR(256)
VARCHAR(256)
VARCHAR(256)
VARCHAR(256)
VARCHAR(256)
VARCHAR(64)
VARCHAR(256)
VARCHAR(16)
VARCHAR(128)
VARCHAR(64)
VARCHAR(8)
VARCHAR(8)
VARCHAR(8)
VARCHAR(8)
VARCHAR(8)
VARCHAR(8)
VARCHAR(8)
VARCHAR(512)
VARCHAR(24)
VARCHAR(24)
VARCHAR(128)
VARCHAR(8)
VARCHAR(8)
VARCHAR(8)

VARCHAR(256)
VARCHAR(255)

CONFIG_HA

DB_ARCHIV_DISKSPACE
DB_ARCHIV_PATH
DB_ARCHIV_STAT
DB_FAILOVER_MODE
DB_HOST
DB_LOG_PATH
DB_OS
DB_PERFORMANCE
DB_PORT
DB_REPLICATION_STAT
DB_SCHEMA
DB_SERVICE
DB_STATUS
DB_TYPE
DB_VERSION
FAILOVER_MODE
FP_LEVEL
FUTURE_USE1
FUTURE_USE2
FUTURE_USE3
FUTURE_USE4
FUTURE_USE5
HTTP_MODE
INSTALL_DISKSPACE
INSTALL_MODE
INSTALL_OS
INSTALL_PLATFORM
INSTALL_TYPE
IS_ACTIVE_DB
IS_ACTIVE_ENV
IS_ARCHIVE
IS_CJK
IS_CLUSTER
IS_DB_MANAGER
LAST_HA_ACT_FAIL_MSG
LAST_HA_ACT_FAIL_TIME
LAST_REP_CHECK_TIME
MAJOR_VERSION
NS_PORT
PG_PROMOTE
WEB_SRV_PORT

VARCHAR(20)

CTM_CONFIG_HA
DATA_CENTER

DB_ARCHIV_DISKSPACE
VARCHAR(256)
DB_ARCHIV_PATH
VARCHAR(256)
DB_ARCHIV_STAT
VARCHAR(8)
DB_DISKSPACE
VARCHAR(256)
DB_FAILOVER_MODE
VARCHAR(48)
DB_HAS_HA
VARCHAR(8)
DB_HOST
VARCHAR(255)
DB_LOG_PATH
VARCHAR(256)
DB_NAME
VARCHAR(128)
DB_PERFORMANCE
VARCHAR(256)
DB_PORT
VARCHAR(8)
DB_PRIMARY_HOST
VARCHAR(256)
DB_PRIMARY_LOG_PATH
VARCHAR(256)
DB_REPLICATION_STAT
VARCHAR(48)
DB_SCHEMA
VARCHAR(32)
DB_SECONDARY_HOST
VARCHAR(256)
DB_SECONDARY_LOG_PATH VARCHAR(256)
DB_SERVICE
VARCHAR(64)
DB_STATUS
VARCHAR(512)
DB_TYPE
VARCHAR(128)
DB_VERSION
VARCHAR(128)
FAILOVER_MODE
VARCHAR(48)
FUTURE_USE1
VARCHAR(256)
FUTURE_USE2
VARCHAR(256)
FUTURE_USE3
VARCHAR(256)
FUTURE_USE4
VARCHAR(256)
FUTURE_USE5
VARCHAR(256)
HAS_HA
VARCHAR(8)
HOST
VARCHAR(256)
IS_DB_MANAGER
VARCHAR(8)
PRIMARY_HOST
VARCHAR(256)
SECONDARY_HOST
VARCHAR(256)

PREFIX

GCS_MSGS
VARCHAR(255)
VARCHAR(2)
NUMBER
VARCHAR(72)
VARCHAR(1)
VARCHAR(4)
VARCHAR(1)
VARCHAR(3)
VARCHAR(14)
TIMESTMP

VARCHAR(512)
VARCHAR(2)
VARCHAR(1)
VARCHAR(512)

VARCHAR(255)

GLOBAL_COND
FROM_DC
GCS_ID
REGEXP_FLAG
TO_DC

WL_RUN_JOBS
NUMBER
VARCHAR(20)
NUMBER
VARCHAR(20)
NUMBER
NUMBER

VERSION_ID

NUMBER
VARCHAR(1024)
VARCHAR(210)
VARCHAR(17)

NUMBER

WORKLOAD_VERSION

DATA_CENTER
JOBS_LIMIT
PERIOD_ID

PK,FK VERSION_ID
PK,FK WL_NAME
PK
DEF_ORDER

PK

LOCKED
LOG_MESSAGE
USERNAME
VERSION_DATE

VARCHAR(17)
VARCHAR(64)
VARCHAR(17)
VARCHAR(64)
VARCHAR(1024)
VARCHAR(17)
VARCHAR(64)
VARCHAR(1)
NUMBER

NUMBER
VARCHAR(20)

WORKLOADS

LAST_UPDATED
MAX_CPU
MAX_JOBS_ALLOWED

DATA_CENTER
NODES_PATTERN

VARCHAR(14)
NUMBER
NUMBER

VARCHAR(20)
VARCHAR(100)

NODE_RESTRICTIONS

CREATE_TIME
CREATED_BY
DATA_UPDATE_TIME
DATA_UPDATED_BY
DESCRIPTION
FILTER_UPDATE_TIME
FILTER_UPDATED_BY
STATE
WL_ORDER

PK,FK VERSION_ID
PK,FK WL_NAME

PK
PK

PK
PK
PK

PK
PK
PK

PK
PK
PK

VARCHAR(20)
VARCHAR(100)
VARCHAR(1)

CTM_PARAMS
DATA_CENTER
NAME
REC_TYPE

VARCHAR(512)
VARCHAR(512)

VARCHAR(17)

VARCHAR(50)
VARCHAR(50)
VARCHAR(255)

MNG_ALIASES
SRV_ALIAS
SRV_TYPE
HOSTNAME

VARCHAR(20)
VARCHAR(50)

VARCHAR(255)
VARCHAR(30)
VARCHAR(10)

MNG_APPL_HOST

LAST_UPDATED

HOSTNAME
OWNER
APPL_TYPE

VARCHAR(10)
VARCHAR(20)
VARCHAR(50)
VARCHAR(22)

NODE_GROUP

DATA_CENTER
NODE_ID

NODE_ID

APPLTYPE
DATA_CENTER
GRPNAME
LAST_UPDATED

VARCHAR(20)
VARCHAR(50)
VARCHAR(255)
VARCHAR(50)
VARCHAR(4)
VARCHAR(1)
NUMBER

HA_LOG_REC

COND_NAME
NODEID
ODATE
PARTICIPATION_TYPE
PERIOD_ID

VARCHAR(20)
VARCHAR(256)
VARCHAR(20)
VARCHAR(256)
VARCHAR(32)
VARCHAR(256)
VARCHAR(8)
VARCHAR(8)

NUMBER
VARCHAR(10)
NUMBER
TEXT
VARCHAR(17)

CONFIG_FILES_CONTENT

COMPONENT
ENTRY_TEXT
ENTRY_TIME
FUTURE_USE1
HA_ACTION
HOST
IS_ACTIVE_HOST
IS_PRIMARY_HOST

U1
U1

FILE_ID

FILE_ID
PLATFORM
CKSUM
CONTENT
LAST_UPDATED

NUMBER
NUMBER
VARCHAR(17)
VARCHAR(128)

U1

FILE_ID
IS_DIF_CONT_OS
NAME_UNIX
NAME_WIN
REL_PATH_UNIX
REL_PATH_WIN

VARCHAR(50)
VARCHAR(64)
VARCHAR(30)
VARCHAR(50)
VARCHAR(100)

NUMBER
VARCHAR(1)
VARCHAR(128)
VARCHAR(128)
VARCHAR(256)
VARCHAR(256)

COMP_NAME
PNAME
PTYPE
FAMILY
LEVEL1

PARAMS
PK
PK
PK
PK
PK

TIMESTMP
VARCHAR(255)
VARCHAR(100)
VARCHAR(100)
VARCHAR(100)
VARCHAR(100)
VARCHAR(512)

WID

VARCHAR(100)
VARCHAR(17)
TEXT
VARCHAR(512)
VARCHAR(1000)
VARCHAR(1000)
VARCHAR(100)
VARCHAR(100)
VARCHAR(210)
VARCHAR(64)
VARCHAR(1000)
TEXT
VARCHAR(20)
VARCHAR(17)
TEXT
VARCHAR(100)
VARCHAR(17)
VARCHAR(3)
VARCHAR(17)
NUMBER

NUMBER

DEF_WS

WORKSPACE

CR_ID
CREATE_TIME
DATA
DESCRIPTION
EMAIL_RECIPIENT
EMAIL_RECIPIENT_CC
FROM_ENV
NAME
OWNER
REQUEST_USER
REQUEST_USER_FULL
SOURCE_XML
STATE
STATE_UPD_TIME
TARGET_XML
TO_ENV
TRANSFER_SIDE_TIME
TYPE
UPDATE_TIME
WS_VERSION

PK

WID

NUMBER

DEF_WS_HISTORY
I1

VARCHAR(17)
VARCHAR(100)
VARCHAR(17)
TEXT
VARCHAR(512)
VARCHAR(1000)
VARCHAR(1000)
VARCHAR(100)
VARCHAR(255)
VARCHAR(255)
VARCHAR(100)
VARCHAR(64)
VARCHAR(64)
VARCHAR(20)
VARCHAR(100)
VARCHAR(3)
VARCHAR(32)
SMALLINT

CHECKED_OUT
CLIENT_DATA
CTM_PLATFORM_ORIG
CTM_PLATFORM_UPD
CTM_VER_ORIG
CTM_VER_UPD
DATA_CENTER_ORIG
DATA_CENTER_UPD
DEF_CD_ORIG
DEF_CD_UPD
DELETE_IND
DSN_ORIG
DSN_UPD
EXCLUSIVE_MODE
LAST_UPDATE_ORIG
SCHED_TABLE_ORIG
SCHED_TABLE_UPD
SITE_STD_ID_ORIG
SITE_STD_ID_UPD
STRICTNESS_ORIG
TABLE_ID
TABLE_TYPE_ORIG
TABLE_TYPE_UPD
UPDATE_STATE
USER_DAILY_ORIG
USER_DAILY_UPD

PK,FK WID
PK
WS_TABLE_SERNO

NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR(1)
VARCHAR(1)
TEXT
VARCHAR(10)

VARCHAR(1)
VARCHAR(512)
VARCHAR(10)
VARCHAR(10)
VARCHAR(3)
VARCHAR(3)
VARCHAR(20)
VARCHAR(20)
TEXT
TEXT
VARCHAR(1)
VARCHAR(44)
VARCHAR(44)
VARCHAR(1)
VARCHAR(17)
VARCHAR(64)
VARCHAR(64)
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR(10)
VARCHAR(10)
VARCHAR(10)

NUMBER
NUMBER

DEF_WS_TABLES

WS_JOB_SERNO
DELETE_IND
HAS_ORIGINAL_JOB
JOB
UPDATE_STATE

PK,FK WID
PK
ISN
PK,FK WS_TABLE_SERNO

DEF_WS_JOBS

CHECKIN_TIME
CR_ID
CREATE_TIME
DATA
DESCRIPTION
EMAIL_RECIPIENT
EMAIL_RECIPIENT_CC
FROM_ENV
FUTURE1
FUTURE2
NAME
OWNER
REQUEST_USER
STATE
TO_ENV
TYPE
TZ_INFO
TZ_OFFSET

PK

DATEW
DESCRIPTION
LEVEL2
LEVEL3
LEVEL4
LEVEL5
PVALUE

CONFIG_FILES_TO_SYNC

CHECK_SUM
LAST_UPDATED
MACHINE_NAME

CONFIG_FILES_HOSTS
FK

I1

I2,I1

FK,I1 DATA_CENTER
FK,I1 GRPNAME

U1
U1

DESCRIPTION
VALUE

COMMUNICATION AND CONFIGURATION
U1

HOSTNAME

NAME_VALUE
VARCHAR(255)

PK

VARCHAR(20)

MNG_SERVERS

NAME
VARCHAR(128)
VARCHAR(15)
NUMBER
NUMBER
VARCHAR(255)
NUMBER
NUMBER
VARCHAR(1)

DATA_CENTER

VARCHAR(255)
SMALLINT
VARCHAR(255)

PK

PK
PK

CKSUM
CODE
ENABLED
EXPIRES
EXTENSION_HISTORY
EXTENSIONS
REMINDERS
STATUS

PK

COMM
U1

VARCHAR(3)
VARCHAR(12)
VARCHAR(1)
VARCHAR(30)
VARCHAR(64)
VARCHAR(1)
VARCHAR(3)
VARCHAR(1)
VARCHAR(1)
NUMBER
VARCHAR(5)
VARCHAR(4)
VARCHAR(255)
VARCHAR(8)
VARCHAR(17)
NUMBER
NUMBER
NUMBER
VARCHAR(20)
VARCHAR(64)
SMALLINT
VARCHAR(1)
VARCHAR(14)
VARCHAR(255)
NUMBER
VARCHAR(100)
VARCHAR(100)
VARCHAR(100)
VARCHAR(100)
VARCHAR(100)
VARCHAR(10)
VARCHAR(10)
VARCHAR(1)
NUMBER
VARCHAR(14)
VARCHAR(2)
VARCHAR(99)
VARCHAR(1)
VARCHAR(17)
VARCHAR(50)
NUMBER

PROCESS_NAME
PROCESS_TYPE
MACHINE_NAME

VARCHAR(128)
NUMBER
VARCHAR(32)
NUMBER

COMMREG

CTLMACHINE
CTLPORT
LIFE_UPDATE_TIME
PID

VARCHAR(255)
SMALLINT
SMALLINT
VARCHAR(255)

CONFREG
PROCESS_NAME
PROCESS_TYPE
CONFIGURATION
MACHINE_NAME

NUMBER

VARCHAR(30)

VARCHAR(255)
NUMBER
SMALLINT
SMALLINT
VARCHAR(100)
TIMESTMP
VARCHAR(100)
VARCHAR(100)
VARCHAR(100)
VARCHAR(100)
VARCHAR(100)
SMALLINT
VARCHAR(384)

I_SERIALS

ADDITIONAL_PARAMS
CHECK_INTERVAL
CURRENT_STATE
DESIRED_STATE
FREE_TEXT
LAST_UPDATE
LEVEL1
LEVEL2
LEVEL3
LEVEL4
LEVEL5
MACHINE_TYPE
PROCESS_COMMAND

NAME
CNT

EM_LICENSE
NUMBER

GCS_DSTS

VARCHAR(255)
NUMBER

GCS_ADMIN

VARCHAR(3)
VARCHAR(2)
NUMBER
NUMBER
NUMBER
TIMESTMP

VARCHAR(255)
VARCHAR(20)
VARCHAR(4)
VARCHAR(1)
VARCHAR(14)

COND
GCS_ID
GCS_ISN_
MSG_DATA
MSG_TYP
ODATE
OP
SENDER
TIMEUTC
UPD_TIME

GLOBALCONDITIONS

VARCHAR(512)
VARCHAR(512)
VARCHAR(512)

HOSTNAME
PORT

ID

PK
PK

ADDITIONAL_DATA
LFP
LICENSE_DATA

U1
U1

I1

TIMESTMP
VARCHAR(2)
VARCHAR(1)

VARCHAR(64)
VARCHAR(255)

WORKLOAD
VERSION_ID
WL_NAME

WL_FILTER_DEFS

FIELDNAME
FIELDVALUE

VARCHAR(20)
VARCHAR(50)
VARCHAR(50)

NUMBER
VARCHAR(20)
NUMBER

WL_NODE_MAP

DATA_CENTER
FROM_NG
TO_NG

NUMBER

WL_PERIOD_DEFS
PERIOD_ID

VARCHAR(15)
VARCHAR(1)
VARCHAR(8)
VARCHAR(4)
VARCHAR(3)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1024)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(8)
VARCHAR(4)
VARCHAR(3)
VARCHAR(1)
VARCHAR(1)

VARCHAR(20)
NUMBER
NUMBER
VARCHAR(64)

NUMBER
VARCHAR(20)
NUMBER

WL_Q_RES

DATE_TYPE
FRIDAY
FROM_DATE
FROM_TIME
FROM_WEEK_DAY
MONDAY
SATURDAY
SPEC_DATES
SUNDAY
THURSDAY
TIME_TYPE
TO_DATE
TO_TIME
TO_WEEK_DAY
TUESDAY
WEDNESDAY

DATA_CENTER
PERIOD_ID
QUANT_LIMIT
RESOURCE_

PK,FK VERSION_ID
PK,FK WL_NAME
PK
DEF_ORDER

PK

PK,FK VERSION_ID
PK,FK WL_NAME
PK
DEF_ORDER

FK
FK

ENTRY_DATE
GCS_ID
STATUS

PK,I2 CONDITION
PK
DATA_CENTER
PK
ODATE
PK
SIGN
PK
TIMEUTC

GCS_GTW_RECOV

DEST
GCS_ID
GCS_ISN_
STAT
TRY_NO
UPD_TIME

PK

PK

PK
PK
PK
PK

PK
PK
PK

CODE
ACTIVE_NET_NAME
CMC_MANAGED
COLLECT_STAT_BY_FIELD
CONTACT
CONTROL_B
CONTROL_M_VER
CONTROL_R
CONTROL_T
CTM_ADMIN_PORT
CTM_DAILY_TIME
CTM_FP_LEVEL
CTM_HOST_NAME
CTM_ODATE
CTM_PARAMS_UPD_TIME
CTM_PORT_NUMBER
DB_BASE_LEVEL
DB_UPDATE_LEVEL
DEFINITION_SYNC_MODE
DESCRIPTION
DESIRED_STATE
ENABLED
END_DST_DATE
GTW_HOST_NAME
GTW_PORT_NUMBER
LEVEL1
LEVEL2
LEVEL3
LEVEL4
LEVEL5
PLATFORM
PROTOCOL
SMART_RECHECK
START_DAY_OF_WEEK
START_DST_DATE
SUMMER_TIME
TIME_ZONE
UPPERCASE
USER_DAILY_LAST_UPDATE
WL_SYNC_STATE
WORKLOAD_LVL

PK

DATABASE SCHEMA

VARCHAR(16)
VARCHAR(1)
NUMBER
VARCHAR(255)
VARCHAR(3)
VARCHAR(5)
VARCHAR(1)
VARCHAR(1)
VARCHAR(10)

NUMBER
NUMBER
NUMBER

DEF_VER_SHOUT

TABLE_ID

DEF_VER_TABLES

DESTINATION
IS_CURRENT_VERSION
ISN_
MESSAGE
SHOUT_DAYSOFFSET
SHOUT_TIME
URGENCY
VERSION_OPCODE
WHEN_COND

FK,U1 JOB_ID
FK,U1 TABLE_ID
FK,U1 VERSION_SERIAL

U1

PK
VARCHAR(14)
VARCHAR(20)
VARCHAR(4000)
VARCHAR(44)
TIMESTMP
TIMESTMP
VARCHAR(64)
TIMESTMP
VARCHAR(1)
NUMBER
VARCHAR(64)
NUMBER
NUMBER
VARCHAR(500)
VARCHAR(50)
VARCHAR(1)
NUMBER
VARCHAR(255)
VARCHAR(14)
VARCHAR(64)
VARCHAR(64)
NUMBER
VARCHAR(10)

DEF_VER_TAGS

CHECKSUM
DATA_CENTER
DEF_CD
DSN
LAST_EVENT_TIMESTAMP
LAST_UPDATED
LAST_UPDATED_USER
LAST_UPLOAD
MODIFIED
REAL_TABLEID
SCHED_TABLE
SITE_STD_ID
STRICTNESS
SYNC_MSG
SYNC_STATE
TABLE_STATUS
TABLE_TYPE
TBL_DELETION_HOST
TBL_DELETION_TIMESTAMP
TBL_DELETION_USER
USED_BY
USED_BY_CODE
USER_DAILY

NUMBER
NUMBER
NUMBER
VARCHAR(8)
VARCHAR(8)
VARCHAR(30)
VARCHAR(1)
VARCHAR(255)
VARCHAR(160)
VARCHAR(30)
VARCHAR(1)
NUMBER
VARCHAR(2)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(1)
VARCHAR(10)
VARCHAR(3)
VARCHAR(20)
VARCHAR(1)
VARCHAR(1)
VARCHAR(53)
VARCHAR(30)

DATA_CENTER
CAL_DEF_TYPE
CAL_STATUS
CALENDAR

VARCHAR(30)
VARCHAR(14)
NUMBER
TIMESTMP
VARCHAR(64)
TIMESTMP
NUMBER
VARCHAR(1)
VARCHAR(500)
VARCHAR(50)
VARCHAR(1)
VARCHAR(64)
NUMBER

CAL_DEF_TYPE
CAL_STATUS
CALENDAR
DATA_CENTER
YEAR

CHARACTER(183)
CHARACTER(183)
VARCHAR(4000)

DF_YEARS

ALIAS
CHECKSUM
ID
LAST_UPDATED
LAST_UPDATED_USER
LAST_UPLOAD
LINK_ID
MODIFIED
SYNC_MSG
SYNC_STATE
TYPE
USED_BY
USED_BY_CODE

DF_CALENDAR

ACTIVE_FROM
ACTIVE_TILL
CONF_CAL
CTM_LEVEL_RBC
DATES_STR
DAY_STR
DAYS_CAL
IS_CURRENT_VERSION
ISN_
MAX_WAIT
MONTH_1
MONTH_10
MONTH_11
MONTH_12
MONTH_2
MONTH_3
MONTH_4
MONTH_5
MONTH_6
MONTH_7
MONTH_8
MONTH_9
RETRO
SHIFT
SHIFT_NUM
TAG_NAME
TAG_RELATION_DC_WC
VERSION_OPCODE
W_DAY_STR
WEEKS_CAL

FK,U1 VERSION_SERIAL
FK,U1 JOB_ID
FK,U1 TABLE_ID

U1

PK
PK
PK
PK

PK
PK
PK
PK
PK

DAYS_1
DAYS_2
DESCRIPTION

NUMBER
VARCHAR(10)
VARCHAR(64)
VARCHAR(512)
VARCHAR(1)
NUMBER
VARCHAR(1)
VARCHAR(1)
VARCHAR(4000)
VARCHAR(44)
TIMESTMP
NUMBER
VARCHAR(64)
VARCHAR(17)
VARCHAR(64)
VARCHAR(255)
VARCHAR(64)
CHARACTER(12)
VARCHAR(8)
VARCHAR(50)
VARCHAR(50)
CHARACTER(8)
CHARACTER(5)
VARCHAR(30)
VARCHAR(6)
NUMBER
VARCHAR(4000)
VARCHAR(770)
TIMESTMP
VARCHAR(30)
VARCHAR(20)
VARCHAR(1)
VARCHAR(21)
TIMESTMP
VARCHAR(525)

C001_ARCINFO
AGENT_ELAPSED_TIME
APPL_TYPE
APPLICATION
CMD_LINE
COMMIT_REQUEST
CPU_TIME
CRITICAL
CYCLIC
DESCRIPTION
DSN
END_TIME
ENDED_STATUS
GROUP_NAME
JOB_ID
JOB_MEM_NAME
MEM_LIB
MEM_NAME
NETNAME
NJE_NODE
NODE_GROUP
NODE_ID
ORDER_DATE
ORDER_ID
OWNER
RBA
RERUN_COUNTER
RESERV
SCHED_TABLE
START_TIME
STAT_CAL
STAT_CAL_CTM
STAT_PERIOD
TASK_TYPE
TIMESTAMP
WORKLOADS

ADD_ONS

BMC Control-M Enterprise Manager 9
NUMBER
NUMBER
NUMBER
NUMBER

JOB AND CALENDAR DEFINITIONS
ISN_
JOB_ID
TABLE_ID
VERSION_SERIAL
VARCHAR(20)
SMALLINT
VARCHAR(44)
SMALLINT
VARCHAR(1)
VARCHAR(64)
VARCHAR(8)
VARCHAR(10)
VARCHAR(770)
TEXT
VARCHAR(1)

DEF_VER_DO_FORCEJ

DATA_CENTER
DO_NO
DSN
IF_NO
IS_CURRENT_VERSION
JOB
ODATE
REMOTE
SCHED_TABLE
VARS_AS_STR
VERSION_OPCODE

ISN_
JOB_ID
TABLE_ID
VERSION_SERIAL
VARCHAR(1)
SMALLINT
VARCHAR(8)
VARCHAR(8)
SMALLINT
VARCHAR(1)
VARCHAR(8)
VARCHAR(8)
VARCHAR(1)

DEF_VER_DO_IFRERUN

CONFIRM_FLAG
DO_NO
FROM_PGMSTEP
FROM_PROCSTEP
IF_NO
IS_CURRENT_VERSION
TO_PGMSTEP
TO_PROCSTEP
VERSION_OPCODE

ISN_
JOB_ID
TABLE_ID
VERSION_SERIAL
VARCHAR(1)
VARCHAR(4000)
VARCHAR(4000)
SMALLINT
SMALLINT
VARCHAR(1)
VARCHAR(4000)
VARCHAR(255)
VARCHAR(1)
VARCHAR(1)

DEF_VER_DO_MAIL

ATTACH_SYSOUT
CC_DESTINATION
DESTINATION
DO_NO
IF_NO
IS_CURRENT_VERSION
MESSAGE
SUBJECT_LINE
URGENCY
VERSION_OPCODE

ISN_
JOB_ID
TABLE_ID
VERSION_SERIAL
DO_NO
IF_NO

DEF_VER_DO_REMEDY

ATTR_NAME
ATTR_VALUE
IS_CURRENT_VERSION
VERSION_OPCODE

NUMBER
NUMBER
NUMBER
NUMBER

DEF_VER_DO_SETVAR
ISN_
JOB_ID
TABLE_ID
VERSION_SERIAL
SMALLINT
VARCHAR(1)
SMALLINT
VARCHAR(1)
VARCHAR(128)
VARCHAR(4000)
VARCHAR(1)

ISN_
JOB_ID
TABLE_ID
VERSION_SERIAL
VARCHAR(16)
SMALLINT
SMALLINT
VARCHAR(1)
VARCHAR(255)
VARCHAR(1)
VARCHAR(1)

DEF_VER_DO_SHOUT

DO_NO
GLOBAL_IND
IF_NO
IS_CURRENT_VERSION
NAME
VALUE
VERSION_OPCODE

DESTINATION
DO_NO
IF_NO
IS_CURRENT_VERSION
MESSAGE
URGENCY
VERSION_OPCODE

ISN_
JOB_ID
TABLE_ID
VERSION_SERIAL
SMALLINT
VARCHAR(1)
SMALLINT
VARCHAR(1)
VARCHAR(255)
VARCHAR(16)
VARCHAR(1)

DEF_VER_DO_SYSOUT

DO_NO
FROM_CLASS
IF_NO
IS_CURRENT_VERSION
PARM
SYSOPT
VERSION_OPCODE

VARCHAR(4000)

SERVICE_HIST_PARAMS
NAME
SERVICE_KEY

SERVICE_LOG
NUMBER

APPLICATION
CRITICAL
CYCLIC
DATA_CENTER
DESCRIPTION
EMERGENCY
GROUP_NAME
JOB_NAME
LAST_UPDATE
MEMNAME
OWNER
TASK_TYPE

SERVICE_HIST_AUTH

ACTIVE_NET_NAME
VARCHAR(12)
ACTUAL_FINISH_TIME
VARCHAR(17)
ACTUAL_START_TIME
VARCHAR(17)
CTM_ODAT
VARCHAR(8)
DATA_CENTER
VARCHAR(20)
DELTA_COMPLETION
NUMBER
DESCRIPTION
VARCHAR(255)
DUE_FINISH_TIME
VARCHAR(17)
EXPECTED_FINISH_TIME
VARCHAR(17)
EXT_ACTUAL_FINISH_TIME VARCHAR(13)
EXT_ACTUAL_START_TIME VARCHAR(13)
EXT_DUE_FINISH_TIME
VARCHAR(13)
EXT_EXPECTED_FINISH_TIME
VARCHAR(13)
EXT_ORDER_TIME
VARCHAR(13)
JOBS_NUM
NUMBER
LOG_DATE_IDX
NUMBER
LOG_TIME
VARCHAR(17)
LOG_TYPE
NUMBER
ORDER_DATE_IDX
NUMBER
ORDER_ID
VARCHAR(5)
ORDER_TIME
VARCHAR(17)
ORDERED_BY
VARCHAR(64)
PRIORITY
NUMBER
RESERV1
VARCHAR(255)
RESERV2
VARCHAR(255)
RESERV3
VARCHAR(255)
SERVICE_KEY
VARCHAR(100)
SERVICE_NAME
VARCHAR(200)
SERVICE_STATE
NUMBER
SERVICE_TYPE
VARCHAR(1)
SLACK_TIME
NUMBER
STATUS_FINAL
NUMBER
STATUS_FROM
NUMBER
STATUS_REASON_FROM
NUMBER
STATUS_REASON_TO
NUMBER
STATUS_TO
NUMBER
TZ_GMT_OFFSET
NUMBER

LOG_ID

VALUE

SERVICES
VARCHAR(8)
VARCHAR(100)

SERVICE_HIST

NUMBER
NUMBER
NUMBER
NUMBER
SMALLINT
SMALLINT
VARCHAR(1)
VARCHAR(45)
VARCHAR(8)
VARCHAR(1)

DEF_VER_DO_CTBRULE
U1
U1
U1
U1

ISN_
JOB_ID
TABLE_ID
VERSION_SERIAL
DO_NO
IF_NO
IS_CURRENT_VERSION
PARAMETERS
RULE_NAME
VERSION_OPCODE

PK
PK

NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR(17)
VARCHAR(12)

VARCHAR(8)
VARCHAR(20)
VARCHAR(100)

SERVICE_HIST_CTM

ACTUAL_END_TIME
VARCHAR(17)
ACTUAL_START_TIME
VARCHAR(17)
BIM_AUTH_ID
VARCHAR(64)
DEADLINE_TIME
VARCHAR(17)
ESTIMATED_END_TIME
VARCHAR(17)
ESTIMATED_START_TIME
VARCHAR(17)
EXT_ACTUAL_END_TIME
VARCHAR(13)
EXT_ACTUAL_START_TIME VARCHAR(13)
EXT_DEADLINE_TIME
VARCHAR(13)
EXT_ESTIMATED_END_TIME VARCHAR(13)
EXT_ESTIMATED_START_TIME VARCHAR(13)
EXT_ORDER_TIME
VARCHAR(13)
EXT_SLACK_TIME
VARCHAR(13)
FOLDERS_TOTAL
NUMBER
JOB_COMPLETED
NUMBER
JOB_ERROR
NUMBER
JOB_EXECUTED
NUMBER
JOB_TOTAL
NUMBER
JOB_UNKNOWN
NUMBER
JOB_WAIT_CONDITION
NUMBER
JOB_WAIT_NODE
NUMBER
JOB_WAIT_RESOURCE
NUMBER
JOB_WAIT_USER
NUMBER
JOB_WAIT_WORKLOAD
NUMBER
LAST_UPDATE
VARCHAR(17)
LOG_ID
NUMBER
ORDER_TIME
VARCHAR(17)
ORDERED_BY
VARCHAR(64)
PRIORITY
VARCHAR(2)
PROGRESS
NUMBER
RESERVE1
NUMBER
RESERVE2
NUMBER
RESERVE3
VARCHAR(256)
RESERVE4
VARCHAR(256)
SERVICE_DESCRIPTION
VARCHAR(400)
SERVICE_NAME
VARCHAR(200)
SERVICE_STATUS
NUMBER
SLACK_TIME
VARCHAR(17)
STATUS_REASON
NUMBER

PK,FK CTM_ODAT
PK
DATA_CENTER
PK,FK SERVICE_KEY
JOB_COMPLETED
JOB_ERROR
JOB_EXECUTED
JOB_TOTAL
JOB_UNKNOWN
JOB_WAIT_CONDITION
JOB_WAIT_NODE
JOB_WAIT_RESOURCE
JOB_WAIT_USER
JOB_WAIT_WORKLOAD
LAST_UPDATE
NET_NAME

U1

U1

PK
PK
PK
PK
PK
PK

VARCHAR(255)
VARCHAR(1)
VARCHAR(1000)
VARCHAR(1024)
VARCHAR(255)
VARCHAR(255)
VARCHAR(40)
VARCHAR(20)

ACTIONS_AUTH
ACTION
ACTION_TYPE
ADDITIONAL_INFO
AUDIT_FIELDS
AUDIT_OPERATION
AUTH_LEVEL
CATEGORY
DESTINATION

NUMBER
NUMBER
NUMBER
VARCHAR(210)
NUMBER
NUMBER

ACTIVEJOBSAUTHORIZATIONS
AUTHORIZATIONLEVEL
TERMINDEX
TERMTYPE
USERNAME
ISGROUP
MATCHINGINDEX

VARCHAR(64)
VARCHAR(255)
NUMBER

VARCHAR(255)

VARCHAR(255)

AUDIT_ATTRIBUTES

FIELDNAME
FIELDVALUE
OPERATOR

CLIENTTYPE
USERNAME

ATTRIB_NAME

FK,I1 OPERATION
I2

OLD_PASSWORD
START_DATETIME
USERNAME

VARCHAR(64)
VARCHAR(210)

VARCHAR(64)
VARCHAR(64)
TIMESTMP
VARCHAR(255)

VARCHAR(255)
VARCHAR(255)

NUMBER
VARCHAR(255)
VARCHAR(210)

VARCHAR(255)
TIMESTMP
VARCHAR(210)

PASSWORD_HISTORY

ISGROUP
LDAPGROUP
USERNAME

LDAP_GROUPS

OPERATION
OPERATION_TYPE

AUDIT_OPERATIONS

CLIENTVERSION
HOSTNAME
LOGINTIME
USERTYPE

AUDIT_LOGIN
PK
PK

U1

I2
I1

I1

NUMBER

ALARM

NUMBER

VARCHAR(255)
VARCHAR(32)
SMALLINT
NUMBER
VARCHAR(255)
VARCHAR(255)
VARCHAR(255)
VARCHAR(255)
VARCHAR(255)
VARCHAR(255)
VARCHAR(20)
VARCHAR(255)
SMALLINT
SMALLINT
TIMESTMP
TIMESTMP

PK

I2

I1

I3

NUMBER

PK
PK
PK
PK
PK
PK
PK

VARCHAR(20)
VARCHAR(10)
VARCHAR(4)

VARCHAR(20)
VARCHAR(44)
VARCHAR(64)
VARCHAR(10)

NUMBER
VARCHAR(17)
VARCHAR(64)
VARCHAR(400)
VARCHAR(1000)
VARCHAR(255)
NUMBER
NUMBER
VARCHAR(17)
VARCHAR(64)
VARCHAR(17)
VARCHAR(64)
VARCHAR(200)
VARCHAR(600)
NUMBER
NUMBER

PK

AUTHORIZATIONLEVEL
TERMTYPE
USERNAME
ISGROUP
MATCHINGINDEX
RESOURCETYPE
TERMINDEX

VARCHAR(64)
VARCHAR(255)
NUMBER

NUMBER
NUMBER
VARCHAR(210)
NUMBER
NUMBER
NUMBER
NUMBER

VARCHAR(20)
VARCHAR(44)
VARCHAR(1)
VARCHAR(8)
VARCHAR(8)
VARCHAR(17)
VARCHAR(64)
VARCHAR(1)
VARCHAR(512)
VARCHAR(64)
VARCHAR(8)
VARCHAR(44)
VARCHAR(64)
VARCHAR(1)
VARCHAR(10)

USER_DAILY_ZOS

DATA_CENTER
DSN
FORCE
JOB_MASK
JOB_ODATE
LAST_UPDATE
MEMNAME
ORDERER_TYPE
RBC_MASK
SCHED_TABLE
TARGET_ODATE
TARGET_TABLE_LIB
TARGET_TABLE_NAME
TARGET_TYPE
USER_DAILY

VARCHAR(100)
VARCHAR(100)
VARCHAR(17)
VARCHAR(210)
VARCHAR(1024)

USER_DATA_LIST

TEXT
VARCHAR(1)

VARCHAR(64)
VARCHAR(512)
VARCHAR(512)
VARCHAR(512)
VARCHAR(512)
TIMESTMP
TIMESTMP
VARCHAR(64)
TEXT

VARCHAR(512)

SCENARIO

CATEGORY
SUB_CATEGORY
UPDATE_TIME
USERNAME
NAME

NAME

DATA
PINNED

CREATED_BY
DESCRIPTION
RESERVE1
RESERVE2
RESERVE3
TIME_CREATED
TIME_UPDATED
UPDATED_BY
WHATIF

NUMBER
NUMBER
NUMBER
NUMBER

SERVICERULES_FILTERS

VARCHAR(64)
VARCHAR(4000)
NUMBER

VARCHAR(17)
VARCHAR(64)
VARCHAR(400)
VARCHAR(17)
VARCHAR(64)
VARCHAR(17)
VARCHAR(64)
VARCHAR(4000)

VARCHAR(200)

SLS_TEMPLATES

CREATE_TIME
CREATED_BY
DESCRIPTION
LAST_UPDATE_TIME
LAST_UPDATED_BY
LAST_USE_TIME
LAST_USED_BY
XML_DATA

NAME

FIELDNAME
FIELDVALUE
OPERATOR

PK,FK RULE_ID
PK
TERMINDEX
PK
TERMTYPE
PK
MATCHINGINDEX

PK

VARCHAR(210)
NUMBER

FIELDNAME
FIELDVALUE
OPERATOR

RESOURCESAUTHORIZATIONS

ACCOUNTLOCKDATE
TIMESTMP
ACCOUNTLOCKORIGINATOR VARCHAR(64)
AIACCESS
NUMBER
ALERTACCESS
NUMBER
ARCHIVEJOBACCESS
NUMBER
AUTHORIZACCESS
NUMBER
BIMACCESS
NUMBER
BIMFOR_CONFIG_ACCESS NUMBER
CLIACCESS
NUMBER
CMC_CTM_SECURITY
NUMBER
CMC_DB
NUMBER
CMC_LOGIN
NUMBER
CMC_OPER
NUMBER
COLLECTIONSDEFSACCESS NUMBER
COMMACCESS
NUMBER
DESCRIPTION
VARCHAR(255)
FILTERSDEFSACCESS
NUMBER
FORECASTACCESS
NUMBER
FUTURE1
VARCHAR(100)
FUTURE2
VARCHAR(100)
FUTURE3
VARCHAR(100)
HIERARCHIESDEFSACCESS NUMBER
ISACCOUNTLOCKED
NUMBER
ISPASSEXPIRENEXTLOGON NUMBER
JOBS_FILTER_FOR_GROUP NUMBER
LDAP_NAME
VARCHAR(255)
LDAP_ONLY_AUTHENTICATION NUMBER
LOGIN_AUTH_ARR
VARCHAR(100)
PASSEXPIREDATE
TIMESTMP
PASSEXPIREDAYS
NUMBER
PASSWORDSTARTDATE
TIMESTMP
PERIOD_STAT_ACCESS
NUMBER
PROM_ACT
NUMBER
PROM_ENV
NUMBER
SITE_STANDARD_ACCESS NUMBER
USERFULLNAME
VARCHAR(210)
USERPASSWORD
VARCHAR(255)
VIEWSDEFSACCESS
NUMBER

PK
USERNAME
PK,I1 ISGROUP

GENERALAUTHORIZATIONS

AUTHORIZATIONS AND AUDIT

SERIAL

VARCHAR(1024)
VARCHAR(255)
NUMBER
VARCHAR(64)
VARCHAR(100)
VARCHAR(100)
VARCHAR(1)
VARCHAR(30)
VARCHAR(50)
VARCHAR(100)
VARCHAR(255)
VARCHAR(100)
VARCHAR(255)
VARCHAR(32)
VARCHAR(255)
VARCHAR(255)
TEXT
VARCHAR(20)
VARCHAR(255)
VARCHAR(44)
VARCHAR(17)
VARCHAR(100)
TEXT
VARCHAR(255)
VARCHAR(64)
VARCHAR(255)
VARCHAR(1)
VARCHAR(100)
VARCHAR(20)
VARCHAR(64)
VARCHAR(64)
VARCHAR(255)
VARCHAR(64)
VARCHAR(2)
VARCHAR(15)
VARCHAR(255)
VARCHAR(8)
VARCHAR(5)
VARCHAR(64)
VARCHAR(64)
VARCHAR(15)
VARCHAR(210)
VARCHAR(255)
NUMBER
NUMBER
VARCHAR(255)
VARCHAR(1)
VARCHAR(20)
VARCHAR(50)
VARCHAR(8)
VARCHAR(100)
VARCHAR(64)
TIMESTMP
VARCHAR(100)
TEXT
VARCHAR(20)
VARCHAR(255)
VARCHAR(64)
VARCHAR(255)
VARCHAR(210)
NUMBER
VARCHAR(100)
VARCHAR(4)

AUDIT_ACTIVITIES

ADDITIONAL_DATA
AGENT_NODEID
ALERT_SERIAL
APPLICATION
APPLTYPE
APPLVER
AUTHORIZED
CALENDAR_NAME
CATEGORY
CHANGE_TICKET_ID
CHANGED_BY
CMVER
COMP_NAME
COMP_TYPE
CONDITION_DATE
CONDITION_NAME
CONTEXT
DATA_CENTER_NAME
DESCRIPTION
DSN
EVENT_TIME
FROM_ENV
FROM_VALUE
GLOBAL_PREFIX
GROUP_NAME
HOSTNAME
ITEM_ENABLED
ITEM_NAME
ITEM_TYPE
JOB_GROUP_NAME
JOB_NAME
JOB_OFFSET
MEM_NAME
MONTH
OP_CODE
OPERATION
ORDER_DATE
ORDER_ID
ORIGINAL_GROUP_NAME
ORIGINAL_USER_NAME
REMEDY_TICKET
REQUESTER
RESOURCE_NAME
RESOURCE_QUANTITY
RESOURCE_QUANTITY_DIFF
RESOURCE_TYPE
SEVERITY
STATE
SUB_CATEGORY
SYSOUT_INDEX
SYSTEM_USERNAME
TABLE_NAME
TIMESTAMP
TO_ENV
TO_VALUE
TYPE
USER_CATEGORY
USER_NAME
USER_NOTE
USERNAME
WORKSPACE_ID
WORKSPACE_NAME
YEAR

NUMBER

BIM_PROB_JOBS

DATA_CENTER
DSN
SCHED_TABLE
USER_DAILY

SIM_SYSSTATE_UDTBL

DATA_CENTER
USER_DAILY
USER_DAILY_TIME

SIM_SYSSTATE_UD

ACTIVE_NET_NAME
VARCHAR(12)
APPLICATION
VARCHAR(20)
DATA_CENTER
VARCHAR(20)
DESCRIPTION
VARCHAR(255)
END_TIME
TIMESTMP
EXECUTION_TIME
NUMBER
EXPECTED_END_TIME
TIMESTMP
EXPECTED_EXECUTION_TIME
NUMBER
EXPECTED_START_TIME
TIMESTMP
GROUP_NAME
VARCHAR(64)
JOB_NAME
VARCHAR(64)
JOB_STATUS
NUMBER
LOG_TIME
TIMESTMP
ORDER_ID
VARCHAR(5)
ORDER_LIB
VARCHAR(44)
ORDER_TABLE
VARCHAR(64)
PROBLEM_TYPE
NUMBER
RESERV1
VARCHAR(255)
RESERV2
VARCHAR(255)
RESERV3
VARCHAR(255)
SLACK_TIME
NUMBER
START_TIME
TIMESTMP
TZ_GMT_OFFSET
NUMBER

FK,I1 LOG_ID

I2

I1

I1

I1

SELF SERVICE DEFINITIONS

VARCHAR(255)
NUMBER
VARCHAR(15)
NUMBER
VARCHAR(4000)

NUMBER
VARCHAR(64)

SERVICEDEFS_PARAMS

ACTIVE
CREATE_TIME
CREATED_BY
DESCRIPTION
DESCRIPTION_FORMAT
GROUPBY_FIELDS
IMPORT_JOB_AUTOEDITS
INSTANTIATION_TYPE
LAST_UPDATE_TIME
LAST_UPDATED_BY
LAST_USE_TIME
LAST_USED_BY
NAME
NAME_FORMAT
ORDERABLE
RULE_ID

SERVICERULES

DISPLAY_NAME
ISN_
PARAM_TYPE
REQUIRED
VALIDATION

PK,FK SERVICE_ID
PK
PARAM_NAME

U1

PK

PK
PK
PK
PK

PK
PK
PK
PK

PK

U1

NUMBER
NUMBER
VARCHAR(600)
VARCHAR(210)

SERVICE_ACTIONS

ACTION_TYPE
ISGROUP
SERVICE_FILTER
USERNAME

NUMBER
NUMBER
VARCHAR(600)
VARCHAR(210)

SERVICE_AUTHORIZATIONS

TEXT
TEXT
VARCHAR(14)
VARCHAR(128)
VARCHAR(100)

NUMBER

USER_PREFERENCES

SSL_CA

AUTHORIZATION_LEVEL
ISGROUP
SERVICE_FILTER
USERNAME

ID

CA_CERT
CA_KEY
CREATE_DATE
DESCRIPTION
PASSPHRASE

VARCHAR(17)
VARCHAR(210)

VARCHAR(64)
VARCHAR(210)

USERSGROUPS

VARCHAR(1024)

NUMBER
VARCHAR(30)

USER_PREFERENCES_DATA

LAST_UPDATE_TIME
USERNAME

PK,FK ID
PK
NAME

VALUE

NUMBER
NUMBER
VARCHAR(210)

NAME

VARCHAR(255)
VARCHAR(64)

VARCHAR(64)

NAME
MATCHINGINDEX
TERMINDEX
TERMTYPE

VARCHAR(64)
VARCHAR(255)
NUMBER

VARCHAR(64)
NUMBER
NUMBER
NUMBER

VARCHAR(255)
VARCHAR(64)

VARCHAR(64)

FILTERDEFS

TERMINDEX
TERMTYPE
MATCHINGINDEX
NAME

NUMBER
NUMBER
NUMBER
VARCHAR(64)

VARCHAR(40)
VARCHAR(64)
VARCHAR(255)
VARCHAR(64)
VARCHAR(64)
NUMBER
VARCHAR(64)
NUMBER

VARCHAR(64)

VIEWDEFS

VARCHAR(255)
VARCHAR(40)
VARCHAR(40)
VARCHAR(40)
VARCHAR(40)
VARCHAR(40)
VARCHAR(40)
VARCHAR(64)

VARCHAR(64)

HIERARCHYDEFS

VARCHAR(64)
VARCHAR(255)
NUMBER

NAME

DESCRIPTION
LEVEL1
LEVEL2
LEVEL3
LEVEL4
LEVEL5
LEVEL6
USEDBY

NAME

FIELDNAME
FIELDVALUE
OPERATOR

FILTERMATCHINGS

DESCRIPTION
USEDBY

NAME

FIELDNAME
FIELDVALUE
OPERATOR

COLLECTIONMATCHINGS

DESCRIPTION
USEDBY

COLLECTIONDEFS

VIEWPOINTS

ACTIONTYPE
ISGROUP
USERNAME

JOBACTIONS

PK,I1 USERGROUP
PK
USERNAME

PK
PK
PK

PK

PK
PK
PK
PK

PK

PK
PK
PK
PK

PK

PK

BEGINLEVEL
COLLECTION
DESCRIPTION
FILTER
HIERARCHY
NETOVERVIEW
USEDBY
ZOOM

NUMBER
VARCHAR(50)
VARCHAR(50)

DICTIONARY_DESCRIPTION VARCHAR(255)

DICTIONARY_ID
FIELD_NAME
TABLE_NAME

RF_DICTIONARY

REPORTING FACILITY

PK
PK
PK

BMC Software, the BMC Software logos, and all other BMC Software product or service names are registered trademarks of BMC Software, Inc.
All other trademarks or registered trademarks belong to their respective companies. Copyright ©2015 BMC Software, Inc. All rights reserved.

For questions related to this poster or any of the Control-M products please contact Customer Support at www.bmc.com/support or call your local support center.

*472515*

The information provided here describes data layouts that are part of the internal product operation of BMC Software. This information is provided to help you understand the operation
of our products. By providing this information, BMC does not intend to sanction or to support user applicaton access. This informatuion is likely to change without any notice in the future,
and BMC is not obligated to support user applications that may depend on this information. Any customer access to internal database information that is not performed via approved
utilities or interfaces is done at the customer’s risk. The furnishing of this document does not give rights to any BMC intellectual property contained within it.

9.0.00

VERSION:

BMC Control-M Workload Automation

PROJECT:

PK
PK
PK
PK
PK

BATCH IMPACT MANAGER AND FORECAST

NUMBER

BIM_ALERT
ACTION

VARCHAR(255)
NUMBER
TIMESTMP
NUMBER
VARCHAR(255)
VARCHAR(255)
VARCHAR(255)
VARCHAR(255)

I4

ACTION_RESULT
ALERT_TYPE
ENTRY_TIME
LOG_ID
RESERV1
RESERV2
RESERV3
TICKET

NUMBER

I1

I2
I1
I3

I2

LOG_ID

VARCHAR(12)
TIMESTMP
TIMESTMP
VARCHAR(20)
NUMBER
VARCHAR(255)
TIMESTMP
TIMESTMP
NUMBER
NUMBER
TIMESTMP
NUMBER
NUMBER
VARCHAR(5)
TIMESTMP
NUMBER
VARCHAR(255)
VARCHAR(255)
VARCHAR(255)
VARCHAR(127)
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER

SERVICE_ID

VARCHAR(17)
VARCHAR(64)
VARCHAR(400)
VARCHAR(128)
NUMBER
VARCHAR(17)
VARCHAR(64)
VARCHAR(200)
NUMBER

NUMBER
NUMBER
VARCHAR(64)
VARCHAR(4000)
NUMBER

NUMBER
NUMBER

SERVICEDEFS_FILTERS

CREATE_TIME
CREATED_BY
DESCRIPTION
FILTER_CHECKSUM
INSTANTIATION_TYPE
LAST_UPDATE_TIME
LAST_UPDATED_BY
NAME
ORDERABLE

SERVICEDEFS

BIM_LOG
PK

ACTIVE_NET_NAME
ACTUAL_FINISH_TIME
ACTUAL_START_TIME
DATA_CENTER
DELTA_COMPLETION
DESCRIPTION
DUE_FINISH_TIME
EXPECTED_FINISH_TIME
JOBS_NUM
LOG_DATE_IDX
LOG_TIME
LOG_TYPE
ORDER_DATE_IDX
ORDER_ID
ORDER_TIME
PRIORITY
RESERV1
RESERV2
RESERV3
SERVICE_NAME
SLACK_TIME
STATUS_FINAL
STATUS_FROM
STATUS_TO
TZ_GMT_OFFSET

PK

I1

U2

SERIAL

EXCEPTION_ALERTS

SERIAL
ORDER_ID
DATA_CENTER
APPLICATION
CHANGED_BY
CLOSED_FROM_EM
GROUP_NAME
HANDLED
HOST_TIME
JOB_NAME
MEMNAME
MESSAGE
NODE_ID
NOTES
REMEDY_PROFILE
RUN_COUNTER
SEVERITY
TICKET_NUMBER
TYPE
UPD_TIME
USER_ID

NUMBER
VARCHAR(5)
VARCHAR(20)
VARCHAR(64)
VARCHAR(64)
VARCHAR(1)
VARCHAR(64)
NUMBER
TIMESTMP
VARCHAR(64)
VARCHAR(64)
VARCHAR(255)
VARCHAR(50)
VARCHAR(100)
VARCHAR(64)
NUMBER
VARCHAR(1)
VARCHAR(15)
VARCHAR(1)
TIMESTMP
VARCHAR(64)

ALERTS

TERMTYPE
MATCHINGINDEX
FIELDNAME
FIELDVALUE
OPERATOR

PK,FK SERVICE_ID
PK
TERMINDEX
PK
PK

U1
I2
I2

I2

PK

COMPONENT_MACHINE
COMPONENT_NAME
COMPONENT_TYPE
COUNTER
KEY1
KEY2
KEY3
KEY4
KEY5
MESSAGE
MESSAGE_ID
NOTE
STATUS
XSEVERITY
XTIME
XTIME_OF_LAST