Tidal Workload Automation

                                                                                     

Scheduler 6.2.2 Data Model

Database Tables
Logical Name Database TableAdded InRemoved InDescription
Action tskmst - - Action master definition
links to table for specific
action type.
ActionAlarmpoint tskalmpt - - AlarmPoint Action
definition.
ActionAlert tskalrt - - Operator alert action
definition.
ActionLog tsklog - - Log action definition.
ActionMail tskmail - - Mail action definition.
ActionSNMP tsksnmp - - SNMP and ITO action
definition.
ActionSchedule tsksch - - Add job action definition.
ActionVariable tskvar - - Variable action
definitions.
Alert alrtmst - - Operator console alerts
generated by event
triggers.
BusinessUnit bizunit 6.0.0 - Business Unit
BusinessView viewmst - - Display business view.
Calendar evntmst - - Calendar master records.
CalendarChild evntchld - - Group calendar members.
CalendarCondition evntcond - - Calendar condition
defintions.
CalendarYear evntyear - - Actual dates in calendar
by year.
Dashboard dshmst - - Dashboard master record
for each user's pane
definitions.
DashboardDetail dshdtl - - Dashboard pane
definitions (includes
default panes).
ExtendedInfo extinfo - - Extended information
from any table; data in
XML format.
FiscalCalendar evntfscl - - Fiscal calendar definitions.
FolderConfiguration foldermst - - Stores custom views.
HostedService hostedservice - - Specifies each service
available on a host
ImageRepository imagemst - - Store images to be used
 in Business Views.
ImageRepositoryLinkimagelnk 5.3.0 - Link Images to Job
Classes or Job Definition.
InfoNodeJoin infonode 5.3.0 - Join between InfoAdapter
Nodes and Run Nodes
they provide info for.
InterMasterVariable varmst2 - - Copy of Variable objects
from other masters.
Job jobmst - - Job rule definition master
records.
JobClass jobcls - - Job class definitions.
JobDependency jobdep - - Job dependency
definitions.
JobDetail jobdtl - - Job detail data.
JobOutput joboutput - - Contains output from
jobs.
JobReport jobreport 5.3.0 - Stores reports about jobs
and jobruns.
JobRun jobrun - - Job instance records
created by compiler.
JobRunEx jobrunx - - Extended JobRun info.
JobStatus jobstat - - Log of job status changes
for historical reporting.
Language lngmst - - Language master
(currently only English
supported).
Location locmst 6.0.0 - Location
MessageCatalog msgmst - - Message catalog for log
messages (no text).
MessageLog msglog - - Audit, Error and
Diagnostic log messages.
MessageParm msgparm - - Not used.
MessageText msgtxt - - Table of log messages by
language links to msgmst.
Node nodmst - - Connection data for the
master and agents.
Includes non-floating
license information.
NodeList nodlstms - - Agent list master records.
NodeListDetail nodlstdt - - Table of agents belonging
to agent lists.
NodeOutage nodout 5.2.2 - Node outage schedules.
NodeResource nodres 6.0.3 - Table to keep track of the
latest system resource
values for each node.
Owner owner - - Table of owners including
users and workgroups.
OwnerAgent owneragt - - Agents authorized for
each workgroup/owner.
PeoplesoftJob psjob - 5.3.0 PeopleSoft job rules.
PeoplesoftJobRun psrun - 5.3.0 PeopleSoft job instance
records.
Queue quemst - - Queue definition master
records.
QueueFilter quefilt - - Filters associated with
 each queue.
Resource resmst - - Represents a thing that a
job uses.
ResourceJobJoin resjob - - Joins resources to jobs.
ResourceLock reslock 5.2.2 - Stores the locked
resources.
ResourceNodeJoin resnod 6.0.3 - Joins resources to nodes
and nodelists.
SapJob sapjob - 5.1.3 Step data for SAP jobs
(not used for pre-defined
SAP jobs).
SapJobRun saprun - 5.1.3 Run data for all SAP jobs.
Schedule schmst - - Records for each
production day with
statistics created by
compiler.
Security secmst - - Security policy records.
SecurityServiceJoin secmstservice - - Join Security policy
records to services.
Service servicemst - - Contains services data
ServiceDist servicedist - - Holder of Service Jar file
StringMaster strmst - - Catalog of strings used
throughout sysADMIRAL
(excluding log messages)
- will be obsolete in a
future release.
SystemValue sysval - - System configuration
values including
demo/emergency license
codes.
TableCounts tblcnt - - Table of last unique ID
used for tables with
primary keys that are
generated sequentially.
TaskService tskservice - - Specifies a task (event)
service available on a
host
Trigger trgmst - - System and job event
definitions.
TriggerAction trgtsk - - Associations between
events and actions.
TriggerActionRun trgtskrun - - Execute table for triggers
and actions.
TriggerJobClassJoin trgjobcls - - Associations between
jobclasses and events.
TriggerJobJoin trgjob - - Associations between jobs
and events.
TriggerRun trgrun - 5.2.1 Historical data for job
instances that triggered
events used for reporting.
TriggerSchedule trgsch - - Relationship between a
trigger and a schedule.
User usrmst - - User records
corresponding to client
and agent runtime users.
UserJoin usreqv - - Associations between
users and runtime users.
UserService userservice - - Specifies each user with a
service
UserSession usersession 6.0.0 - User Session
Variable varmst - - Variable definitions and
current values.
WorkGroup workgrp - - Workgroup definitions.
WorkGroupUserJoin workusr - - Associations between
users and workgroups.

In-Memory Tables
Logical Name Database TableAdded InRemoved InDescription
ClientNode - - - Pseudo object with
connection data for
clients.
DirectoryMonitor - - - An object encapsulating
the parameters of a
directory monitor.
ExternalJobRun - - - Reference to an external
job.
FTConnection - - - A connection wrapped for
fault tolerance
FTNode - - - A fault tolerant node.
FileMonitor - - - File monitor objects that
represent files being
monitored by agents.
These do not get saved to
the database, but the ID
comes from the
TableCounts table so the
database table must be
set.
JesMonitor - - - Monitor objects that
represent JES jobs
monitored by the JES
Adapter. These do not get
saved to the database.
JobRunDep - - - JobRun dependency
definitions. These do not
get saved to the
database, but the ID
comes from the
TableCounts table so the
database table must be
set.
MasterJavaTimeZone- - - Inmemory table used for
list all available java
timezones on master jvm.
QueueJobList - - - A pseudo object that
holds a list of JobRuns for
a queue.
QueueMaster - - - A pseudo object that
manages Queues.
ServiceRequest - - - Keeps track of a client
 service request.
Statistics - - - Inmemory table to store
statistics information.
UpdateJobRecord - - - Psuedo object with
information about a job
run.
UserMessage - - - Inmemory table used for
routing user messages.
Action Table
Data Model

Table Summary
Logical Name Action
Database Tabletskmst
Added In -
Removed In -
Description Action master definition links to table for specific action type.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Description tskmst_desc string - - Description of action
ID tskmst_id int - - Unique ID for action; links to table of
appropriate type
LastChangeTime tskmst_lstchgtm datetime- - Last modified timestamp
LastUserModifiedTimetskmst_usrmodtmdatetime6.0.0 - Last modified by a user
Name tskmst_name string - - Name of action
Node_ID nodmst_id int - - Node this action runs on
Owner_ID owner_id int - - Unique ID for owners (users and workgroups)
Public tskmst_public string - - Flag indicating whether action can be used by
other users
Service_ID servicemst_id int - - Service this action runs on
Type tskmst_type short - - Type of action:
Name ValueDescription
TASK_TYPE_EMAIL 1 internal
TASK_TYPE_OPALERT 2 internal
TASK_TYPE_SNMP 3 internal
TASK_TYPE_JOBADD 4 internal
TASK_TYPE_LOG 5 internal
TASK_TYPE_VARIABLE 6 internal
TASK_TYPE_ITO 7 internal
Alarmpoint
action, run
TASK_TYPE_ALARMPOINT8 an
Alarmpoint
script
TASK_TYPE_WMI 9 internal
TASK_TYPE_MANAGEX 10 internal
TASK_TYPE_NETIQ 11 internal
TASK_TYPE_IRC 14 internal
TASK_TYPE_SAP 17 SAP Event
Generic
TASK_TYPE_SERVICE 18 Service
Event

In-Memory Columns
Logical NameDatabase Field Type Added InRemoved InDescription
ActionDetail WRAPPER_OBJECTcom.tidalsoft.framework.data.DataRecord- - The record
with details
about this
action.
ActionAlarmpoint Table
Data Model

Table Summary
Logical Name ActionAlarmpoint
Database Tabletskalmpt
Added In -
Removed In -
Description AlarmPoint Action definition.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Esc_userID esc_userid string - - internal
ExternalID usrmst_externid string - - External use ID to
link to third-party
packages
ID tskalmpt_id int - - Unique ID for
AlarmPoint action
LastChangeTimetskalmpt_lstchgtmdatetime6.0.0 - Last modified
timestamp
OptionOrder tskalmpt_optord string - - The order in which
these options will be
presented
Options tskalmpt_opt string - - The options available
for this action
Params tskalmpt_params string - - The message sent to
AlarmPoint to start
the phone
notification
Recjob_ID recjob_id int - - internal
ActionAlert Table
Data Model

Table Summary
Logical Name ActionAlert
Database Tabletskalrt
Added In -
Removed In -
Description Operator alert action definition.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
ID tskalrt_id int - - Unique ID for operator alert action
LastChangeTimetskalrt_lstchgtm datetime- - Last modified timestamp
Level tskalrt_level short - - Severity level of operator alert action:
Name ValueDescription
ALRTMST_LEVEL_INFO 4 internal
ALRTMST_LEVEL_WARNING3 internal
ALRTMST_LEVEL_ERROR 2 internal
ALRTMST_LEVEL_CRITICAL 1 internal
Message tskalrt_msg text - - Text of operator alert action message; variables
may be embedded
ActionLog Table
Data Model

Table Summary
Logical Name ActionLog
Database Tabletsklog
Added In -
Removed In -
Description Log action definition.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
EventNumber tsklog_evtnum string - - internal
ID tsklog_id int - - Unique ID for logging action
LastChangeTime tsklog_lstchgtm datetime6.0.0 - Last modified timestamp
Level tsklog_level short - - Severity level for log action:
Name ValueDescription
MSG_TYPE_ERROR 1 internal
MSG_TYPE_AUDIT 2 internal
MSG_TYPE_DIAGNOSTIC3 internal
Message tsklog_msg string - - Message for log action; variables may be
embedded
WindowsEventLogtsklog_ntevent string - - Flag indicating whether log action should
write to NT event log (Y/N)
ActionMail Table
Data Model

Table Summary
Logical Name ActionMail
Database Tabletskmail
Added In -
Removed In -
Description Mail action definition.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
Attachment tskmail_attach string - - The attachment to
include
ID tskmail_id int - - Unique ID for mail
action
LastChangeTimetskmail_lstchgtmdatetime6.0.0 - Last modified
timestamp
Memo tskmail_memo text - - Text of mail message
for action; variables
may embedded
Priority tskmail_priority short - - Priority for mail action
Subject tskmail_subject string - - Subject line for mail
action message;
variables may be
embedded
ToExternalUsers tskmail_to_ext string - - List user e-mail
addresses for mail
action for users not
defined to
sysADMIRAL
ToUsers tskmail_to_int string - - List of user IDs for
sysADMIRAL users to
which mail message
should be sent

In-Memory Columns
Logical NameDatabase FieldTypeAdded InRemoved InDescription
FromUser INMEMORY string- - The user that is sending
this email
ActionSchedule Table
Data Model

Table Summary
Logical Name ActionSchedule
Database Tabletsksch
Added In -
Removed In -
Description Add job action definition.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
FindParent tsksch_findparent short 6.0.0 - Flag to determine
how to find the job's
parent when it is
inserted
FromTime tsksch_fromtm datetime6.0.0 - Launch window
from time - number
of minutes from the
time the job was
inserted
ID tsksch_id int - - Jobmst ID for add
job action
Job_ID jobmst_id int - - Unique ID for job
LastChangeTimetsksch_lstchgtm datetime6.0.0 - Last modified
timestamp
Node_ID nodmst_id int - - Unique ID for
connection
Parameters tsksch_parametersclob 6.0.0 - Parameters for job
action; variables
may be embedded
Params tsksch_params string - 6.0.0 Parameters for job
action; variables
may be embedded
ProxyUser_ID tsksch_proxy int - - Runtime user for job
action
UntilTime tsksch_untiltm datetime6.0.0 - Launch window until
time - number of
minutes from the
time the job was
inserted
Variables tsksch_vars clob 6.0.0 - Variables for job
action
ActionSNMP Table
Data Model

Table Summary
Logical Name ActionSNMP
Database Tabletsksnmp
Added In -
Removed In -
Description SNMP and ITO action definition.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Community tsksnmp_comm string - - Community for SNMP
action
Host tsksnmp_host string - - Host for SNMP action
ID tsksnmp_id int - - Unique ID for SNMP
Action
LastChangeTimetsksnmp_lstchgtmdatetime6.0.0 - Last modified
timestamp
Level tsksnmp_level short - - Severity level for
SNMP action
Message tsksnmp_msg text - - Message for SNMP
action
Port tsksnmp_port short - - Reserved for future
use
ActionVariable Table
Data Model

Table Summary
Logical Name ActionVariable
Database Tabletskvar
Added In -
Removed In -
Description Variable action definitions.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
ID tskvar_id int - - Unique ID for variable action
LastChangeTimetskvar_lstchgtm datetime6.0.0 - Last modified timestamp
Node_ID nodmst_id int - - Unique ID for connection
Timing tskvar_timing short - - Timing of variable action update:
Name Value Description
VAR_TASK_BEFORE 1 internal
VAR_TASK_AFTER 2 internal
Type tskvar_type short - - Variable action operation:
Name ValueDescription
Set the
VAR_TASK_SET 1 variable to
the value
Increment
VAR_TASK_INCREMENT 2 the variable
by the value
Decrement
VAR_TASK_DECREMENT3 the variable
by the value
Value tskvar_val string - - Value to be used in variable action
Variable_ID varmst_id int - - Unique ID for variable
Alert Table
Data Model

Table Summary
Logical Name Alert
Database Tablealrtmst
Added In -
Removed In -
Description Operator console alerts generated by event triggers.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Description alrtmst_desc clob - - Text of alert message
ID alrtmst_id int - - Unique ID for operator alert
JobRun_ID jobrun_id int - - Unique ID for this run of job
Job_ID jobmst_id int - - Unique ID for job
LastChangeTime alrtmst_lstchgtm datetime6.0.0 - Last modified timestamp
LastUserModifiedTimealrtmst_usrmodtmdatetime6.0.0 - Last modified by a user
Level alrtmst_level short - - Severity level of alert:
Name ValueDescription
TMST_LEVEL_INFO 4 internal
ALRTMST_LEVEL_WARNING3 internal
ALRTMST_LEVEL_ERROR 2 internal
ALRTMST_LEVEL_CRITICAL 1 internal
Response alrtmst_resp text - - Text of operator response to alert
ResponseTime alrtmst_resptm datetime- - Time and date of operator response to alert
ResponseUser_ID alrtmst_respuser int - - User who responded to alert
State alrtmst_state short - - The status of the alert:
Name ValueDescription
ALRTMST_STATE_OPEN 1 internal
ALRTMST_STATE_ACK 2 internal
ALRTMST_STATE_CLOSED 3 internal
Time alrtmst_time datetime- - Date and time alert was generated
Type alrtmst_type short - - Whether a job or system alert:
Name Value Description
EVENT_TYPE_JOB 1 internal
EVENT_TYPE_SYSTEM 2 internal
BusinessUnit Table
Data Model

Table Summary
Logical Name BusinessUnit
Database Tablebizunit
Added In 6.0.0
Removed In -
Description Business Unit

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Active bizunit_active string - - Flag indicating
whether the
Business Unit is
enabled "Y" or
disabled "N"
Alias bizunit_alias string - - Short name for
BusinessUnit
Data bizunit_data text - - Data for
Business Unit
Description bizunit_desc text - - Description of
Business Unit
Dirty bizunit_dirty string - - Dirty flag
ID bizunit_id int - - Unique id of
this
BusinessUnit.
LastChangeTime bizunit_lstchgtm datetime- - Last modified
timestamp
LastUserModifiedTimebizunit_usrmodtmdatetime- - Last modified
by a user
Name bizunit_name string - - Name of the
BusinessUnit.
Public bizunit_public string - - Flag indicating
whether the
Business Unit is
public "Y" or
not "N"
TimeZoneID bizunit_tzid string - - TimeZone ID
associated with
this Business
Unit
BusinessView Table
Data Model

Table Summary
Logical Name BusinessView
Database Tableviewmst
Added In -
Removed In -
Description Display business view.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
GroupID viewmst_group int - - Group id
which the
business view
can access.
ID viewmst_id int - - Unique id of
this entry.
LastChangeTime viewmst_lstchgtm datetime- - Last modified
timestamp
LastUserModifiedTimeviewmst_usrmodtmdatetime- - Last modified
by a user
Layout viewmst_layout text - - Layout of
Business View
Name viewmst_name string - - Name of the
Business
View.
OwnerID viewmst_owner int - - ID for the
owner of
view.
PublicFlag viewmst_public string - - Available for
use by other
users (Y/N)
not owner
and not in
viewmst.
ViewJobs viewmst_jobs int - - Number of
jobs currently
defined and
enabled for
business view.
Calendar Table
Data Model

Table Summary
Logical Name Calendar
Database Tableevntmst
Added In -
Removed In -
Description Calendar master records.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Calendar evntmst_calendar int - - Calendar upon which this calendar is based
CreateTime evntmst_crttm datetime- - Timestamp when calendar created
Description evntmst_desc string - - Description of calendar
Fiscal evntmst_fiscal short - - Fiscal calendar upon which this calendar is
based
ForecastDate evntmst_frcstdt datetime- - Date forecasted through
Frequency evntmst_freq short - - Calendar frequency based on type
FromDate evntmst_fromdt datetime- - Effective date for calendar (first possible
date)
ID evntmst_id int - - Unique ID for this calendar
LastChangeTime evntmst_lstchgtm datetime- - Last modified timestamp
LastCompileTime evntmst_lstcmptm datetime- - Last time dates for this calendar were
compiled
LastUserModifiedTimeevntmst_usrmodtm datetime6.0.0 - Last modified by a user
Monthdays evntmst_monthdaysstring - - Days in month to include
Months evntmst_months string - - Months to include
Name evntmst_name string - - Name of calendar
Occur evntmst_occur short - - nth occurrence for subsets
Offset evntmst_offset short - - Offset for monthly, subset calendars
Owner evntmst_owner int - - Owner of calendar
Public evntmst_public string - - Available for use by other users (Y/N) not
owner and not in workgroup
Subtype evntmst_subtype short - - Reserved for future use
Timeframe evntmst_timeframe short - - Timeframe for subset calendars
TotalCount evntmst_totcnt short - - Reserved for future use
Type evntmst_type short - - GROUP = 1;
Name ValueDescription
DAILY 2 internal
WEEKLY 3 internal
MONTHLY_WITH_DAYS 4 internal
MONTHLY_WITH_WEEKS5 internal
LIST 6 internal
SUBSET 7 internal
UntilDate evntmst_untildt datetime- - Last possible calendar date to include
Weekdays evntmst_weekdays string - - Days of week to include
Weeks evntmst_weeks string - - Weeks in month to include
intsect evntmst_intsect string - - internal

In-Memory Columns
Logical NameDatabase FieldTypeAdded InRemoved InDescription
Processed INMEMORY string- - In-memory flag used by the calendar
compiler to keep track of compile needs.
(Y/N)
CalendarChild Table
Scheduler 6.1.0 Data Model

Table Summary
Logical Name CalendarChild
Database Tableevntchld
Added In -
Removed In -
Description Group calendar members.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Calendar_ID evntmst_id int - - Unique ID for this
calendar
ID evntchld_id int - - Unique ID for table
LastChangeTime evntchld_lstchgtmdatetime6.0.0 - Last modified
timestamp
Logic evntchld_logic short - - Include/exclude
Offset evntchld_offset short - - Adjust calendar by
days
ParentID evntchld_prntid int - - Link to group
calendar's
evntmst_id
SequenceNumberevntchld_seq short - - Sequence number
to order groups
children
CalendarCondition Table
Data Model

Table Summary
Logical Name CalendarCondition
Database Tableevntcond
Added In -
Removed In -
Description Calendar condition defintions.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Action evntcond_action short - - Action to use for
this condition
Action_ID evntcond_actionid int - - evntmst_id of
calendar to use
in finding
conditional date
Calendar_ID evntmst_id int - - Unique ID for
this calendar
ConflictCalendar_IDevntcond_confid int - - Conflicting
calendar's
evntmst_id
ID evntcond_id int - - Unique ID for
table
LastChangeTime evntcond_lstchgtmdatetime6.0.0 - Last modified
timestamp
Offset evntcond_offset short - - Adjust action
calendar by
number of days
SequenceNumber evntcond_seq short - - Sequence
number for
conflict condition
CalendarYear Table
Data Model

Table Summary
Logical Name CalendarYear
Database Tableevntyear
Added In -
Removed In -
Description Actual dates in calendar by year.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Calendar_ID evntmst_id int - - Unique ID for this
calendar
Dates1 evntyear_dates1 string - - Array of flags
indicating which
dates are included in
calendar for first 6
months of year
Dates2 evntyear_dates2 string - - Array of flags
indicating which
dates are included in
calendar for last 6
months of year
ID evntyear_id int - - Unique ID for table
LastChangeTimeevntyear_lstchgtmdatetime6.0.0 - Last modified
timestamp
Year evntyear_year int - - Year for which dates
have been calculated
ClientNode Table
Data Model

Table Summary
Logical Name ClientNode
Database TableIN-MEMORY
Added In -
Removed In -
Description Pseudo object with connection data for clients.

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
Alias INMEMORY string - - TCP/IP name used to connect to
agent
ClientConnectTime INMEMORY datetime - - The time the client connected
CommunicationConnection WRAPPER_OBJECTcom.tidalsoft.framework.comm.Connection- - The Connection used to talk to this
node.
ID INMEMORY int - - ID of this ClientNode object
IP INMEMORY string - - IP address
MachineName INMEMORY string - - Name of client machine
OpDepStatusTimestamp INMEMORY long - - Timestamp of when we last replied to
a client RequestData Q request.
OpRefreshQueuesTimestampINMEMORY long - - Timestamp of when we last replied to
a client Request Queue Data.
OpRequestDataQTimestamp INMEMORY long - - Timestamp of when we last replied to
a client RequestData.
OpRequestDataRTimestamp INMEMORY long - - Timestamp of when we last replied to
a client RequestData R request.
Type INMEMORY int - - The type of client
Name ValueDescription
A normal
NORMAL_CLIENT 1 GUI or
command
line client.
Another
master
REMOTE_MASTER2
subscribing
to us.
User_ID INMEMORY int - - ID of user logged into this client
Version INMEMORY string - - Version number of the client
Dashboard Table
Data Model

Table Summary
Logical Name Dashboard
Database Tabledshmst
Added In -
Removed In -
Description Dashboard master record for each user's pane definitions.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Description dshmst_desc string - - Reserved for
future use
ID dshmst_id int - - Unique ID for
bashboard
view
LastChangeTime dshmst_lstchgtm datetime6.0.0 - Last modified
timestamp
LastUserModifiedTimedshmst_usrmodtmdatetime6.0.0 - Last modified
by a user
Name dshmst_name string - - Name of
dashboard (not
used)
Owner dshmst_owner int - - User who
defined
dashboard
panes
Public dshmst_public string - - Reserved for
future use
DashboardDetail Table
Data Model

Table Summary
Logical Name DashboardDetail
Database Tabledshdtl
Added In -
Removed In -
Description Dashboard pane definitions (includes default panes).

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
AlertDays dshdtl_alertdays short - - Number of days of alert history to show in
alerts pane
Col dshdtl_col short - - Current column position of pane
Dashboard_ID dshmst_id int - - Unique ID for bashboard view
Flags dshdtl_flags string - - Dashboard pane filter flags
Height dshdtl_height short - - Last height of dashboard pane
ID dshdtl_id int - - Unique ID for dashboard pane
IncludeScheduled dshdtl_sched string - - Flag to include scheduled job data
IncludeUnscheduleddshdtl_unsched string - - Flag to include unscheduled job data
JobClass_ID jobcls_id int - - Unique ID for job class
LastChangeTime dshdtl_lstchgtm datetime6.0.0 - Last modified timestamp
Node_ID nodmst_id int - - Unique ID for connection
Queue_ID quemst_id int - - Unique ID for queue
Row dshdtl_row short - - Current row for dashboard pane
Selected dshdtl_selected string - - Determines whether dashboard pane is
currently being used
Status dshdtl_status string - - Status filter array
Title dshdtl_title string - - Title for top of dashboard pane
Type dshdtl_type short - - The type of dashboard pane:
Name ValueDescription
DASH_STATUS_PANE 1 internal
DASH_ALERTS_PANE 2 internal
DASH_STATISTICS_PANE3 internal
DASH_ACTIVITY_PANE 4 internal
DASH_PROGRESS_PANE 5 internal
Width dshdtl_width short - - Last width of dashboard pane
DirectoryMonitor Table
Data Model

Table Summary
Logical Name DirectoryMonitor
Database TableIN-MEMORY
Added In -
Removed In -
Description An object encapsulating the parameters of a directory monitor.

In-Memory Columns
Logical NameDatabase FieldType Added InRemoved InDescription
Active INMEMORY int - - True if monitor is active
FileMask INMEMORY String- - Pattern to match files against.
ID INMEMORY int - - ID of this monitor
MinSize INMEMORY int - - Minimum size (in bytes) of files for operation.
Name INMEMORY String- - Name of this monitor
Node_ID INMEMORY int - - ID of the agent that this monitor runs on.
Operation INMEMORY int - - The operation to take when the monitor condition is
met.
Name ValueDescription
Move the
source file(s)
OP_MOVE_FILE 0 to the
destination
directory.
Deletes the
OP_DELETE_FILE 1 source
file(s).
Retrieves
the source
file(s) and
OP_RETRIEVE_AND_MOVE_FILE 2 moves them
to the
destination
directory.
Retrieves
the source
OP_RETRIEVE_AND_DELETE_FILE3 file(s) and
deletes
them.
Source INMEMORY String- - The source directory
Stable INMEMORY int - - Time (in milliseconds) files need to be stable
(maintain same size) before operation.
Target INMEMORY String- - The target directory
TriggerID INMEMORY int - - ID of the monitor's trigger
WaitPeriod INMEMORY int - - Time (in milliseconds) to wait before operation.
ExtendedInfo Table
Data Model

Table Summary
Logical Name ExtendedInfo
Database Tableextinfo
Added In -
Removed In -
Description Extended information from any table; data in XML format.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
Data extinfo_data text - - The data in XML format
DataID extinfo_dataid int - - The ID of this data
Dirty extinfo_dirty string - - Flag indicating whether the data has
been modified
ID extinfo_id int - - Unique ID for table
LastChangeTimeextinfo_lstchgtm datetime6.0.0 - Last modified timestamp
Sort extinfo_sort string - - Key used to sort this table
TableID extinfo_tblid int - - The ID of the table this is for
Name ValueDescription
TBL_NODMST 1
TBL_NODLSTMS 2
TBL_NODLSTDT 3
TBL_LNGMST 4
TBL_SCHMST 5
TBL_SECMST 6
TBL_OWNER 7
TBL_USRMST 8
TBL_WORKGRP 9
TBL_EVNTMST 10
TBL_JOBCLS 11
TBL_JOBDTL 12
TBL_JOBMST 13
TBL_QUEMST 14
TBL_JOBDEP 15
TBL_JOBRUN 16
TBL_MSGMST 17
TBL_MSGLOG 18
TBL_MSGPARM 19
TBL_MSGTXT 20
TBL_TBLCNT 21
TBL_ALRTMST 22
TBL_STRMST 23
TBL_QUEFILT 24
TBL_WORKUSR 25
TBL_TRGMST 26
TBL_TSKMST 27
TBL_TRGTSK 28
TBL_TRGJOB 29
TBL_TSKMAIL 30
TBL_TSKSCH 31
TBL_TSKSNMP 32
TBL_TSKALRT 33
TBL_SYSVAL 34
TBL_VARMST 35
TBL_USREQV 36
TBL_EVNTCHLD 37
TBL_JOBSTAT 38
TBL_TSKVAR 39
TBL_TSKLOG 40
TBL_TRGRUN 41
TBL_DSHMST 42
TBL_DSHDTL 43
TBL_EVNTYEAR 44
TBL_EVNTCOND 45
TBL_EVNTFSCL 46
TBL_OWNERAGT 47
TBL_SAPJOB 48
TBL_SAPRUN 49
TBL_TSKALMPT 50
TBL_PSJOB 51
TBL_PSRUN 52
TBL_PSPARM 53
TBL_PRTMST 54
TBL_VARMST2 55
TBL_JOBOUTPUT56
TBL_EXTINFO 57
ExternalJobRun Table
Data Model

Table Summary
Logical Name ExternalJobRun
Database TableIN-MEMORY
Added In -
Removed In -
Description Reference to an external job.

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
ActualStartTime INMEMORY datetime - - Actual start time of job
AdapterJobID INMEMORY int - - The ID of the Job used to talk with the Common
Adapter.
Attributes INMEMORY text - - Attributes of external item
ClientRequestClientListWRAPPER_OBJECTjava.util.List- - List of Client objects that made the request
Duration INMEMORY int - - Actual duration time in seconds
ExternalID INMEMORY String - - ID number assigned by external system
ExternalName INMEMORY string - - Name assigned by external system
ExternalServer INMEMORY string - - Server name of external system
ID INMEMORY int - - Unique ID for this run of job
Name Value Description
Bit that is set
EXTERNAL_JOBRUN_FLAG0x4000000in the ID to
indicate an
ExternalJobRun
Instance INMEMORY int - - Sequential number for job repeating within day
JobType INMEMORY short - - Type of job definition:
Name INMEMORY string - - Name of the job
Node_ID INMEMORY int - - Unique ID for connection
Priority INMEMORY short - - Priority of this job relative to other jobs in queue
Queue_ID INMEMORY int - - Unique ID for queue
Status INMEMORY short - - Current status of job instance
UserName INMEMORY string - - Name of run time user of external item
FileMonitor Table
Data Model

Table Summary
Logical Name FileMonitor
Database TableIN-MEMORY
Added In -
Removed In -
File monitor objects that represent files being monitored by agents.
Description These do not get saved to the database, but the ID comes from the
TableCounts table so the database table must be set.

In-Memory Columns
Logical NameDatabase FieldTypeAdded InRemoved InDescription
FileExtent INMEMORY long - - Size for file dependency
Filename INMEMORY string- - Path and name of file for
file dependency; variables
may be embedded
Filetype INMEMORY short - - Type of file dependency:
ID INMEMORY int - - ID of the file monitor
definition
IsMet INMEMORY int - - Flag that is 1 if dependency
is met
Node_ID INMEMORY int - - Unique ID for connection
Operator INMEMORY short - - Operator used for
dependency condition, one
of
JobDependency.JOB_DEP_*
FiscalCalendar Table
Data Model

Table Summary
Logical Name FiscalCalendar
Database Tableevntfscl
Added In -
Removed In -
Description Fiscal calendar definitions.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
DayBegin evntfscl_daybegin short - - internal
FixedBegin evntfscl_fixedbegin string- - For fiscal
calendars,
whether the
beginning
month and year
will be the same
every year
ID evntfscl_id int - - Unique ID for
fiscal calendar
LastChangeTime evntfscl_lstchgtm datetime6.0.0 - Last modified
timestamp
MonthBegin evntfscl_monthbeginshort - - internal
Name evntfscl_name string - - Name of fiscal
calendar
Period1 evntfscl_period1 short - - 4 or 5 weeks for
first week in
quarter
Period2 evntfscl_period2 short - - 4 or 5 weeks in
second month
of quarter
Period3 evntfscl_period3 short - - 4 or 5 weeks in
third month of
quarter
Quarter evntfscl_quarter int - - Used to modify
a specific year
for a fiscal
calendar; the
quarter being
modified
QuarterBreakdownevntfscl_qtrbreakdn string - - Used to modify
a specific year
 for a fiscal
calendar; the
weeks in each
month of this
quarter
StartYear evntfscl_startyr int - - internal
Year evntfscl_year int - - Used to modify
a specific year
for a fiscal
calendar; the
year being
modified
FolderConfiguration Table
Data Model

Table Summary
Logical Name FolderConfiguration
Database Tablefoldermst
Added In -
Removed In -
Description Stores custom views.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Filter foldermst_data text - - The view's
filter.
FixedParentID foldermst_linkedto int - - Fixed client
id of the
view's
parent.
FolderParentID foldermst_prntid int - - ID of the
custom
view's
parent.
ID foldermst_id int - - ID of the
custom
view.
LastChangeTime foldermst_lstchgtm datetime6.0.0 - Last
modified
timestamp
LastUserModifiedTimefoldermst_usrmodtm datetime6.0.0 - Last
modified by
a user
LogicalType foldermst_logicaltypeint - - Content type
of the
Folder. 1-
Group, 2-
URL, 3-JAC,
4-Job
Definition
Name foldermst_name string - - Name of the
custom
view.
ObjectType foldermst_objecttypeint 5.3.0 - Indicates
what type of
object it is.
 1-Regular
Pre-defined
Node, 2-
Saved View,
3-Custom
Folder
Owner foldermst_owner int - - Owner of
calendar
Public foldermst_public string - - If this field is
public.
Type foldermst_type int - - Type of the
Folder. 1-
Group, 2-
URL, 3-View
FTConnection Table
Data Model

Table Summary
Logical Name FTConnection
Database TableIN-MEMORY
Added In -
Removed In -
Description A connection wrapped for fault tolerance

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
CommunicationConnectionWRAPPER_OBJECTcom.tidalsoft.framework.comm.Connection- - The Connection used to talk to this
node.
ConnectionState INMEMORY int - - the state of connection
Name ValueDescription
This
CONNECTED 1 connection
is alive
This
LOST 2 connection
is lost
This
CONNECTING 3 connection
is trying to
connect
The remote
NOT_CONNECTED4 node is not
connected.
HBTimerID INMEMORY int - - Unique ID for the timer sending
heartbeat
ID INMEMORY int - - Unique ID for this fault tolerant node
LastHBTime INMEMORY datetime - - last heart beat arrived time
LastMissedHBTime INMEMORY datetime - - last heart beat missed time
MissedHBTimes INMEMORY int - - times for missed heart beat since last
heart beat arrived
RemoteNode WRAPPER_OBJECTcom.tidalsoft.scheduler.model.Node - - The remote Node over the end of
connection information
FTNode Table
Data Model

Table Summary
Logical Name FTNode
Database TableIN-MEMORY
Added In -
Removed In -
Description A fault tolerant node.

In-Memory Columns
Logical NameDatabase Field Type Added InRemoved InDescription
AMConnection WRAPPER_OBJECTFTConnection- - the connection to the alternative master node
FMConnection WRAPPER_OBJECTFTConnection- - the connection to Fault Monitor
FTMode INMEMORY string - - the running fault-tolerant mode for a node
Name ValueDescription
This Node is
PRIMARY_MASTER "PM" the primary
Master
This Node is
BACKUP_MASTER "BM" backup
master
This Node is
FAULTTOLERANT_MONITOR"FM" a fault
tolerant
monitor
FTState INMEMORY int - - fault tolerant state
Name ValueDescription
STARTING_UP 1 This ft node is
initializing.
STABLE 2 This ft node is stable
running
This ft node is in critical
CRITICAL 3 state, may fail or back
to stable again.
This ft node is
SWITCHING 4 switching to another
state
This ft node is shutting
SHUTTING_DOWN5
down
ID INMEMORY int - - Unique ID for this fault tolerant node
Name ValueDescription
This Node is
NODE_ID_PRIMARY_MASTER1 the primary
Master
This Node is
NODE_ID_BACKUP_MASTER -1 the backup
Master
This Node is
NODE_ID_FAULT_MONITOR -2 the fault
monitor
This Node is
NODE_ID_SERVICE_HOST -3 a service
host
Node WRAPPER_OBJECTNode - - Node information
HostedService Table
Data Model

Table Summary
Logical Name HostedService
Database Tablehostedservice
Added In -
Removed In -
Description Specifies each service available on a host

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
ID hostedservice_id int - - Unique ID for
this record
LastChangeTimehostedservice_lstchgtmdatetime6.0.0 - Last modified
timestamp
Node_ID nodmst_id int - - The foreign key
to the nodmst
table
Service_ID servicemst_id int - - The foreign key
to the
servicemst table
ImageRepository Table
Data Model

Table Summary
Logical Name ImageRepository
Database Tableimagemst
Added In -
Removed In -
Description Store images to be used in Business Views.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
BinaryData imagemst_data blob - 6.0.0 Content of
the file.
Data imagemst_encoded clob 6.0.0 - Image data
encoded in
Base64
FileName imagemst_filename string - - Filename.
ID imagemst_id int - - Unique id of
this entry.
LastChangeTime imagemst_lstchgtm datetime- - Last
modified
timestamp
LastUserModifiedTimeimagemst_usrmodtmdatetime6.0.0 - Last
modified by
a user
Name imagemst_name string - - Name of the
Image.
Size imagemst_size int - - Size of the
file.
Type imagemst_type string - - File type
(.png, .bmp,
.jpg).
ImageRepositoryLink Table
Data Model

Table Summary
Logical Name ImageRepositoryLink
Database Tableimagelnk
Added In 5.3.0
Removed In -
Description Link Images to Job Classes or Job Definition.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
ID imagelnk_id int - - Unique id of this
entry.
ImageID imagemst_id int - - ID of the Image.
JobClass jobcls_id int - - ID of the associated
Job Class.
JobMst jobmst_id int - - ID of the associated
Job Definition.
LastChangeTimeimagelnk_lstchgtmdatetime6.0.0 - Last modified
timestamp
InfoNodeJoin Table
Data Model

Table Summary
Logical Name InfoNodeJoin
Database Tableinfonode
Added In 5.3.0
Removed In -
Description Join between InfoAdapter Nodes and Run Nodes they provide info for.

Database Columns
Logical Name Database Field TypeAdded In Removed In Description
ID infonode_id int - - Unique id of this entry.
InfoNodeID infonodmst_id int - - ID of the InfoAdapter.
RunNodeID runnodmst_id int - - ID of the Run Node.
InterMasterVariable Table
Data Model

Table Summary
Logical Name InterMasterVariable
Database Tablevarmst2
Added In -
Removed In -
Description Copy of Variable objects from other masters.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
ID varmst2_id int - - Unique ID for table
LastChangeTime varmst2_lstchgtm datetime6.0.0 - Last modified timestamp
LastUserModifiedTimevarmst2_usrmodtmdatetime6.0.0 - Last modified by a user
Node_ID nodmst_id int - - Node ID that matches our Node table
OldValue varmst_lstval string 6.0.0 - Last value of the variable
Value varmst_value string 6.0.0 - Current value of the variable
VariablePublic varmst_public string - - Flag indicating whether all users can
refer to variable (Y/N)
VariableReadonly varmst_readonly string - - Flag indicating whether the variable is
readonly
Variable_ID varmst_id int - - Unique ID for variable
Variable_name varmst_name string - - Name of variable
Variable_type varmst_type short - - Type of variable:
Name ValueDescription
Value is a
VARIABLE_STRING 1
string
Value is a
VARIABLE_NUMBER2
number
Value is a
VARIABLE_DATE 3
date
Variable is a
VARIABLE_BOOL 4
boolean
JesMonitor Table
Data Model

Table Summary
Logical Name JesMonitor
Database TableIN-MEMORY
Added In -
Removed In -
Monitor objects that represent JES jobs monitored by the JES Adapter.
Description
These do not get saved to the database.

In-Memory Columns
Logical Name Database FieldTypeAdded InRemoved InDescription
GetHistoryTimerAmtINMEMORY int - - Number of seconds to
sleep.
GetHistoryTimer_ID INMEMORY int - - ID of timer used to
trigger request for
history.
JobName INMEMORY string- - Name of the JES job
NodeID INMEMORY int - - ID of the JES Node
Job Table
Data Model

Table Summary
Logical Name Job
Database Tablejobmst
Added In -
Removed In -
Description Job rule definition master records.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Active jobmst_active string- - Job enabled flag (Y/N)
Alias jobmst_alias string- - Short name for job for use with command line
BusinessUnit_ID bizunit_id int 6.0.0 - The Business Unit this job belongs to
CalendarOffset jobmst_evntoffset short - - Offset from each date in job's calendar to run
job
Calendar_ID evntmst_id int - - Unique ID for this calendar
CreateTime jobmst_crttm datetime- - Timestamp for job creation
Description jobmst_desc text - - Description of job (notes)
DescriptionType jobmst_desc_type string 6.1.0 - 'U' if the Description is a URL, 'T' or null if plain
text
Dirty jobmst_dirty string - - Reserved for future use
ID jobmst_id int - - Unique ID for job
JobClass_ID jobcls_id int - - Unique ID for job class
JobDetail_ID jobdtl_id int - - Unique ID for job detail data
LastChangeTime jobmst_lstchgtm datetime- - Last modified timestamp
LastUserModifiedTimejobmst_usrmodtm datetime6.0.0 - Last modified by a user
Mode jobmst_mode short - - Reserved for future use
Name jobmst_name string - - Name of job
Owner jobmst_owner int - - User or workgroup that owns job
ParentID jobmst_prntid int - - Group to which the job belongs
ParentName jobmst_prntname string - - Name of parent group (full path)
RunBook jobmst_runbook text - - Operator instructions for job
RunBookType jobmst_runbook_typestring 6.1.0 - 'U' if the RunBook is a URL, 'T' or null if plain
text
Type jobmst_type short - - Type of job definition:
Name ValueDescription
This is a
group;
JOB_TYPE_GROUP 1
parent to
other jobs.
A normal job
with a
JOB_TYPE_JOB 2 command
line to
execute.
JOB_TYPE_SAPJOB 3 An SAP job
A Peoplesoft
JOB_TYPE_PSJOB 4
job
An Oracle
JOB_TYPE_ORAJOB 5 Applications
job
JOB_TYPE_FTPJOB 6 An FTP job
An AS/400
JOB_TYPE_OS400JOB 7
job
A job for
 one of the
JOB_TYPE_ADAPTER 8 new
adapters
(circa 2004)
A OVMS
JOB_TYPE_OVMS_BATCH 12
batch job
JOB_TYPE_OVMS_JOB 13 A OVMS job
A OVMS
JOB_TYPE_OVMS_COMMAND14 command
job
JOB_TYPE_MPEJOB 15 A Z/OS job
A Data
JOB_TYPE_DATA_MOVER 16
Mover job
Variables jobmst_vars clob 6.0.0 - Local variables defined for this job

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
ExtendedInfo WRAPPER_OBJECTExtendedInfo- - The ExtendedInfo record for this
Job
SkipJobRunInstanceWRAPPER_OBJECTint - - If this Job has the "skip if
previous instance active" flag
set, then this field is ID of the
JobRun currently running. This
makes it easier for other jobruns
to check.
JobClass Table
Data Model

Table Summary
Logical Name JobClass
Database Tablejobcls
Added In -
Removed In -
Description Job class definitions.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Description jobcls_desc string - - Description of
job class
ID jobcls_id int - - Unique ID for
job class
LastChangeTime jobcls_lstchgtm datetime- - Last modified
timestamp
LastUserModifiedTimejobcls_usrmodtmdatetime6.0.0 - Last modified by
a user
Name jobcls_name string - - Name of job
class
JobDependency Table
Data Model

Table Summary
Logical Name JobDependency
Database Tablejobdep
Added In -
Removed In -
Description Job dependency definitions.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
CanIgnore jobdep_canignore string
- - Ignore if dependency not in schedule (Y/N)
DateOffset jobdep_dateoffset short- - Date offset for dependency instance
FileExtent jobdep_fileextent long - - Size for file dependency; OR if OS/390 dep, the
condition code range (lo word *+ hi word)
Filename jobdep_filename string - - Path and name of file for file dependency; variables
may be embedded; OR if OS/390 dep, the name of
the OS/390 command
Filetype jobdep_filetype short - - Type of file dependency; OR if a OS/390 dep, the
exit code to match
Name Value Description
JOB_DEP_FD_EXISTS 200 internal
JOB_DEP_FD_NOTEXISTS 201 internal
JOB_DEP_FD_SIZELE 202 internal
JOB_DEP_FD_SIZEGE 203 internal
JOB_DEP_FD_STABLE 204 internal
JOB_DEP_FD_CHANGED 205 internal
ID jobdep_id int - - ID of the dependency definition
InstanceOffset jobdep_instoffset short - - Job dependency offset from first or last instance
InstanceWithinGroup jobdep_ingroup string - - Flag that job dependency should match instance
within group
JobDependency_ID jobdep_jobmst int - - jobmst_id for job dependency
JobLogic jobdep_joblogic short - - Condition used for matching occurrence:
Name ValueDescription
JOB_DEP_FIRST 1 internal
if OS/390 dep, means
JOB_DEP_LAST 2
latest
JOB_DEP_MATCH 3 internal
JOB_DEP_SPECIFIC4 internal
JOB_DEP_OFFSET 5 internal
Job_ID jobmst_id int - - Unique ID for job
KeepMetIfReady jobdep_keepmetifreadystring 6.1.0 - When a job is waiting on resource, don't let the
dependency go unmet (Y/N)
LastChangeTime jobdep_lstchgtm datetime6.0.0 - Last modified timestamp
LastUserModifiedTimejobdep_usrmodtm datetime6.0.0 - Last modified by a user
Node_ID nodmst_id int - - Unique ID for connection
Operator jobdep_operator short - - Operator used for dependency condition:
Name Value Description
JOB_DEP_EQUALS 1 internal
JOB_DEP_NOTEQUALS 2 internal
JOB_DEP_LESS 3 internal
JOB_DEP_LESSEQUALS 4 internal
JOB_DEP_GREATER 5 internal
JOB_DEP_GREATEREQUALS 6 internal
Status jobdep_status short - - Status required to meet dependency requirement;
OR if OS/390 dep, 0 = do not wait for completion, 1
= wait
Type jobdep_type short - - Type of dependency:
Name ValueDescription
 Dependes
JOB_DEP_JOB 1 on another
Job
Depends on
JOB_DEP_FILE 2
a file
Depends on
JOB_DEP_VARIABLE 3
a Variable
Depends on
JOB_DEP_WMI 4 a WMI
message.
Depends on
JOB_DEP_JES 9 an OS/390
(JES) job
Maximum
JOB_MAX_DEP_TYPE 99 "real" dep
type
Pseudo
JOB_PSEUDO_DEP_TIME 100 dependency
on a time
Pseudo
dependency
JOB_PSEUDO_DEP_PARENT 101
on a parent
group job
Pseudo
JOB_PSEUDO_DEP_CONCUR 102 dependency
on previous
job in series
Pseudo
dependency
on previous
day
carryover. If
setting is
that
JOB_PSEUDO_DEP_CARRYOVER103
previous
day's jobs
run first,
then all of
today's jobs
will have this
dependency.
Value jobdep_value string - - Value required for variable dependency; OR if
OS/390 dep, the step name
Variable_ID varmst_id int - - Unique ID for variable
JobDetail Table
Data Model

Table Summary
Logical Name JobDetail
Database Tablejobdtl
Added In -
Removed In -
Description Job detail data.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
AbrtOnCldErr jobdtl_abrtonclderr string 5.3.0 - Whether to cancel if any child goes to error
AllowAdhoc jobdtl_allowadhoc string - - Allow unscheduled instance of job (Y/N)
Carryover jobdtl_carryover short - - How many days to carry the job over from the originally scheduled run
date
Command jobdtl_cmd string - - Command/program to be executed for job; variables may be embedded
Concurrency jobdtl_concur short - - Job concurrency option:
Name ValueDescription
JOB_CONCURRENCY_RUN 1 internal
JOB_CONCURRENCY_SKIP 2 internal
Run when
previous
active
JOB_CONCURRENCY_DEFER_NORMAL 3
instance
completes
normally
Run when
previous
active
JOB_CONCURRENCY_DEFER_COMPLETE 4 instance
completes
with any
status
Run when all
previous
JOB_CONCURRENCY_DEFER_SEQUENTIAL 5 instance
completes
with any
status
Run when all
previous
JOB_CONCURRENCY_DEFER_SEQUENTIAL_COMPLETE6 instance
completes
with any
status
DepRerun jobdtl_deprerun string - - Rerun every time dependency is met (Y/N)
DependecyLogic jobdtl_deplogic short - - Type of dependency logic:
Name Value Description
JOB_DEP_AND 1 internal
JOB_DEP_OR 2 internal
Duration jobdtl_duration int - - Estimated duration time in seconds
EnvFile jobdtl_envfile string - - Environment file for job; variables may be embedded
EstMethod jobdtl_estmethod short 5.2.2 - Method used to determine time needed for the job to run
Name ValueDescription
JOB_TIME_NEEDED_IS_EST_DUR 1 Use the estimated duration as
the time needed to run
JOB_TIME_NEEDED_IS_MAX_DUR2 Use the maximum duration as
the time needed to run
Failalarm jobdtl_failalarm string - - Reserved for future use
FromDate jobdtl_fromdt datetime- - Earliest date to run job
FromTime jobdtl_fromtm datetime- - Earliest time of day to run job (time dependency)
ID jobdtl_id int - - Unique ID for job detail data
InheritAgent jobdtl_inhagent string - - Flag to inherit run information from group (Y/N)
InheritCalendar jobdtl_inhevent string - - Flag to inherit calendar information from group (Y/N)
InheritOptions jobdtl_inhoptions string - - Reserved for future use
InheritRepeat jobdtl_inhrepeat string - - Reserved for future use
InheritTime jobdtl_inhtime string - - time window information from group (Y/N)
Interval jobdtl_interval short - - For repeating jobs, time between runs
IntervalCount jobdtl_intervalcnt short - - Number of times a job repeats
JobEstDurExcludejobdtl_estdurexcludeint 5.3.0 - Bit mask of statuses to exclude when calculating Estimated Duration
LastChangeTime jobdtl_lstchgtm datetime6.0.0 - Last modified timestamp
MaxRunTime jobdtl_maxrun int - - Maximum time a job should run; used with job events
MinRunTime jobdtl_minrun int - - Minimum time a job should run; used with job events
NearOutage jobdtl_nearoutage short 5.2.2 - What to do if the job is likely to run into an agent outage window
Name ValueDescription
JOB_NEAR_OUTAGE_RUN_ANYWAY1 Run the job anyway
JOB_NEAR_OUTAGE_SKIP 2 Do not run the job
JOB_NEAR_OUTAGE_DEFER 3 Defer the job until after the
outage window is over
NodeList_ID nodlstmst_id int - - Unique ID of agent list
Node_ID nodmst_id int - - Unique ID for connection
NormalExit jobdtl_normalexit short - - Value for normal exit code
NormalOp jobdtl_normalop short - - Operator for range of normal
Name Value Description
OP_EQUALS 1 internal
OP_NOT_EQUALS 2 internal
OP_LESS_THAN 3 internal
OP_LESS_THAN_OR_EQUAL 4 internal
OP_GREATER_THAN 5 internal
OP_GREATER_THAN_OR_EQUAL 6 internal
OP_ODD 7 OpenVMS: odd exit code
OP_EVEN 8 OpenVMS: even exit code
NormalRange jobdtl_normalrange short - - Highest in range of normal exit code values
OutputName jobdtl_outputname string - - Name of job's output file if other than stdout; variables may be embedded
Params jobdtl_params clob - - Parameter string passed to job's command/program; variables may be
embedded
PeopleSoftJob jobdtl_psjob int - 5.3.0 internal
Priority jobdtl_priority short - - Job's priority relative to other jobs in queue
Proxy jobdtl_proxy int - - Runtime user for job; default is owner of job
Proxy2 jobdtl_proxy2 int 5.2.1 - Local user for job, default is 0
Rerun jobdtl_rerun string - - Indicates if this is a perpetually running job (Y/N)
RerunOK jobdtl_rerunok string - - internal
Retension jobdtl_retnsn short - - Retention period for job history in days
SapCount jobdtl_sapcount int - 5.1.3 SAP's unique internal ID for job
SaveLogOnly jobdtl_savelogonly string - - internal
SaveOutput jobdtl_saveoutput string - - (Y/N/R) - Append/Discard/Replace output
Service_ID servicemst_id int - - The foreign key to the servicemst table
StatusCl jobdtl_statuscl string 5.3.0 - Whether to account child status in completion status
TimeWindow jobdtl_timewin short - - Specifics of time window:
Name ValueDescription
JOB_RUN_NOTIMEDEP 0 no time dependencies
JOB_TIMEWIN_TOMORROW1 If job not ready by end of time
window: Try again tomorrow
JOB_TIMEWIN_TIMEOUT 2 If job not ready by end of time
window: Timeout
If job not ready by end of time
JOB_TIMEWIN_TRIGGER 3
window: Timeout; Same as option 2
JOB_TIMEWIN_EVENT 4 If job not ready by end of time
window: Trigger event only
TrackCl jobdtl_trackcl string 5.3.0 - Whether to track spawned child processes
TrackCommand jobdtl_trackcmd string - - Command to pipe job's output for tracking
Trackmethod jobdtl_trackmethod short - - Tracking method:
Name ValueDescription
JOB_TRACK_EXITCODE 1 Determine success based on exit code
JOB_TRACK_EXTERNAL 2 Success defined by external source
JOB_TRACK_COMMAND 3 Success defined by exit code in command
pipe
JOB_TRACK_NORMALSTR 4 Success if text in output
JOB_TRACK_ABNORMSTR5 Failure if text in output
TransactionID jobdtl_trxid int - - internal
Unit jobdtl_unit string - - Reserved for future use
UntilDate jobdtl_untildt datetime- - Last date job should run
UntilTime jobdtl_untiltm datetime- - Latest time of day a job can start
WaitForOperator jobdtl_waitop string - - Job waits for operator release (Y/N)
WorkingDirectory jobdtl_workdir string - - Directory to run program in
XmlData jobdtl_extinfo clob - - XML data associated with this job.

In-Memory Columns
Logical Name Database Field Type Added In Removed In Description
Job_ID INMEMORY int - - ID for the job record
PrevIntervalCount INMEMORY short - - Previous value of the IntervalCount field.
JobOutput Table
Data Model

Table Summary
Logical Name JobOutput
Database Tablejoboutput
Added In -
Removed In -
Description Contains output from jobs.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
ID joboutput_id int - - Unique ID for table
JobRun_ID jobrun_id int - - Unique ID for this
record (the
JobRun_ID of the
owner record)
LastChangeTimejoboutput_lstchgtmdatetime6.0.0 - Last modified
timestamp
Output jobrun_output clob - - Blob field
containing actual
output of job
OutputLength jobrun_outputlen int - - Size of output
JobReport Table
Data Model

Table Summary
Logical Name JobReport
Database Tablejobreport
Added In 5.3.0
Removed In -
Description Stores reports about jobs and jobruns.

Database Columns
Logical NameDatabase FieldType Added InRemoved InDescription
Data jobreport_data text - - Data for this JobReport.
Date jobreport_date datetime- - Date this JobReport
was generated.
ID jobreport_id int - - Unique ID of this
JobReport.
InfoNodeID infonodmst_id int - - ID of the Adapter that
generated this
JobReport.
JobID jobmst_id int - - ID of the Job this
JobReport is for.
JobRunID jobrun_id int - - ID of the JobRun this
JobReport is for.
RunNodeID runnodmst_id int - - ID of the Node that this
JobReport's job or
jobrun runs on.
Status jobreport_status int - - Status of this
JobReport.
Type jobreport_type int - - Type of this JobReport.
JobRun Table
Data Model

Table Summary
Logical Name JobRun
Database Tablejobrun
Added In -
Removed In -
Description Job instance records created by compiler.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
AbrtOnCldErr jobrun_abrtonclderr string 5.3.0 - Whether to cancel if any child goes to error
ActualStartTime jobrun_time datetime- - Actual start time of job
Adhoc jobrun_adhoc string - - Was job was submitted manually (Y/N)
AgentInstance jobrun_agentinst short - - Sequential instance number for repeating jobs by agent (for jobs that
are broadcast)
AllowAdhoc jobrun_allowadhoc string - - see jobdtl_allowadhoc
Batch jobrun_batch short - - Internal flag for jobMgr reading jobs in batches
BusinessUnit_ID bizunit_id int 6.0.0 - The Business Unit this job belongs to
Carryover jobrun_carryover short - - How many days to carry the job over from the originally scheduled
run date
Command jobrun_cmd string - - see jobdtl_cmd
Concur jobrun_concur short - - see jobdtl_concur
DepTextLength jobrun_depslen int - - The length of the dependencies text field
DependecyLogic jobrun_deplogic short - - see jobdtl_deplogic
Dependencies jobrun_deps clob - - The status of dependencies for this job in a single string
DependencyRerun jobrun_deprerun string - - Rerun every time dependency is met (Y/N)
Dirty jobrun_dirty string 5.2.2 - "X" if the jobrun is deleted.
Duration jobrun_duration int - - Actual duration time in seconds
EnvFile jobrun_envfile string - - see jobdtl_envfile
EstMethod jobrun_estmethod short 5.2.2 - see jobdtl_estmethod
EstimatedDuration jobrun_estduration int - - Estimated duration time in seconds
EstimatedStartTime jobrun_esttime datetime- - Estimated start time determined by compiler
ExitCode jobrun_exitcode int - - Exit code upon job completion
Expire jobrun_expire datetime- - internal
ExternalID jobrun_externid int - 6.0.0 Unique external ID number for tracking
ExternalIDString jobrun_externid_str string 6.0.0 - Unique external ID number for tracking
Flags1 jobrun_flags1 int - - Internal flags used for master processing
FromStep jobrun_fromstep short - - internal
FromTime jobrun_fromtm datetime- - Earliest time job can run (time dependency)
FullPath jobrun_fullpath string 6.0.0 - JobRun ID ancestor path from top level jobrun to this jobrun
GroupInstance jobrun_groupinst short - - Instance number for repeating job within group
HasDependents jobrun_hasdependentsstring - - internal
HasResourcesLockedFlag jobrun_reslock string - - Y if this jobrun has resources locked, N if not.
ID jobrun_id int - - Unique ID for this run of job
IgnoreTimeDependency jobrun_ignoretime string - - Time dependency override
Instance jobrun_instance int - - Sequential number for job repeating within day
Interval jobrun_interval short - - see jobdtl_interval
IntervalCount jobrun_intervalcnt short - - see jobdtl_intervalcnt
JobClass_ID jobcls_id int - - Unique ID for job class
JobParentID jobmst_prntid int - - Group to which the job belongs
JobType jobmst_type short - - Type of job definition:
 Name ValueDescription
JOB_TYPE_GROUP 1 Job is a parent of other jobs
JOB_TYPE_JOB 2 A normal job
JOB_TYPE_SAPJOB 3 SAP job
JOB_TYPE_PSJOB 4 A Peoplesoft job
JOB_TYPE_ORAJOB 5 An Oracle Applications job
JOB_TYPE_FTPJOB 6 An FTP job
JOB_TYPE_OS400JOB 7 An AS/400 job
A job for one of the new adapters
JOB_TYPE_ADAPTER 8
(circa 2004)
JOB_TYPE_OVMS_BATCH 12 A job for one of the OVMS Batch
JOB_TYPE_OVMS_JOB 13 A job for one of the OVMS Job
JOB_TYPE_OVMS_COMMAND14 A job for one of the OVMS
Command
JOB_TYPE_MPEJOB 15 A job for one of the MPEJOB
JOB_TYPE_DATA_MOVER 16 A job for one of the DataMover
job
Job_ID jobmst_id int - - Unique ID for job
LastChangeTime jobrun_lstchgtm datetime- - Last modified timestamp
LastUserModifiedTime jobrun_usrmodtm datetime6.0.0 - Last modified by a user
LaunchAcknowledged jobrun_psjob int - - Launch acknowledged by agent
LaunchTime jobrun_launchtm datetime5.3.0 - Time the job status changed to Launch
MaxRunTime jobrun_maxrun int - - see jobdtl_maxrun
Met jobrun_met string - - Flag that indicates whether this job's dependencies are currently
satisfied (Y/N)
MinRunTime jobrun_minrun int - - see jobdtl_minrun
NearOutage jobrun_nearoutage short 5.2.2 - see jobdtl_nearoutage
NodeList_ID nodlstmst_id int - - Unique ID of agent list
Node_ID nodmst_id int - - Unique ID for connection
NonTimeDependencies jobrun_nontimedep string - - Flag to indicate whether this job has non-time dependencies (Y/N)
NormalExit jobrun_normalexit short - - see jobdtl_normalexit
NormalOP jobrun_normalop short - - see jobdtl_normalop
NormalRange jobrun_normalrange short - - see jobdtl_normalrange
OriginalStatus jobrun_orgstatus short - - Original status of job prior to Set Status
Output jobrun_output string - - Blob field containing actual output of job
OutputLength jobrun_outputlen int - - Size of output
OutputName jobrun_outputname string - - Alternate output filename for job (other than stdout)
Owner jobrun_owner int - - User or workgroup that owns job
Params jobrun_params clob - - Command/program parameters used for this run of the job
ParentID jobrun_prntid int - - Parent group for this job in the current schedule
Priority jobrun_priority short - - Priority of this job relative to other jobs in queue
ProcessID jobrun_processid int 6.0.0 - Process ID for the jobrun
ProductionDate jobrun_proddt datetime- - Production date for this job instance
Proxy jobrun_proxy int - - Runtime user for this job instance
Proxy2 jobrun_proxy2 int 5.2.1 - Local user for this job instance, default is 0
QueueTime jobrun_queuetm datetime5.3.0 - Timestamp of when the job entered the queue
Queue_ID quemst_id int - - Unique ID for queue
Rerun jobrun_rerun string - - see jobdtl_rerun
Reruns jobrun_reruns short - - Number of times this job instance has been rerun
ResetSuccessor jobrun_resetsucc string - - If set when job is loaded from DB, then cancel the job if predessesor
is cancelled.
RunDate jobrun_rundt datetime- - The most recent production date on which this job was running
SaveLogOnly jobrun_savelogonly string - - internal
SaveOutput jobrun_saveoutput string - - see jobdtl_saveoutput
Service_ID servicemst_id int - - Reference to the servicemst ID record
StartRunDate jobrun_startrundt datetime6.1.0 - The production date on which this job started running
Status jobrun_status short - - Current status of job instance. This is the status used by the business
logic.
Name ValueDescription
JOB_STATUS_ACTIVE_RANGE 50 internal
JOB_STATUS_PREDONE_RANGE 90 internal
JOB_STATUS_DONE_RANGE 100 internal
has just been compiled,
JOB_STATUS_SCHEDULED 0
initial state
JOB_STATUS_WAIT 1 internal
JOB_STATUS_WAITOP 2 internal
 JOB_STATUS_HOLD 3 internal
missed the window today,
JOB_STATUS_TIMEOUTTODAY 5
will try again tomorrow
JOB_STATUS_AGENTUNAVAIL 7 agent is not connected
JOB_STATUS_AGENTINACTIVE 8 agent is marked inactive
agent is in an outage
JOB_STATUS_AGENTOUTAGE 9
period
the parent group is
JOB_STATUS_WAITONGROUP 10 waiting on operator
(waitop)
the children are waiting
JOB_STATUS_WAITCHILDREN 11 on dependencies, or none
active
JOB_STATUS_CANCELLED_PENDING12 cancel pending the job
JOB_STATUS_READY 49 keep it the last in the
group
JOB_STATUS_LAUNCH 50 internal
JOB_STATUS_ACTIVE 51 internal
JOB_STATUS_STOP 52 internal
JOB_STATUS_DEFERRED 53 internal
JOB_STATUS_ERROR 66 internal
JOB_STATUS_PRENORMAL 97 internal
JOB_STATUS_PREABNORM 98 internal
JOB_STATUS_PREEXTERN 99 internal
Special status for deps;
JOB_STATUS_COMPLETED 100
means any done status
JOB_STATUS_NORMAL 101 internal
JOB_STATUS_ABNORMAL 103 internal
JOB_STATUS_SKIPPED 104 internal
JOB_STATUS_ORPHAN 105 job's agent is down
JOB_STATUS_ABORTED 106 post launch action
JOB_STATUS_EXTERN 107 internal
missed the window today,
JOB_STATUS_TIMEOUT 108 requires manual
intervention
JOB_STATUS_CANCELLED 109 pre-launch action
JOB_STATUS_PREORPHAN 110 potential orphan
JOB_STATUS_CANCELLED_NORMAL 112 job cancelled normally
StatusChangeTime jobrun_stachgtm datetime- - Date and time of last status change
StatusCl jobrun_statuscl string 5.3.0 - Whether to account child status in completion status
Successors jobrun_successors clob 6.0.0 - IDs of JobRuns that depend on this JobRun
TimeBatch jobrun_timebatch short - - For internal use; managing reading jobs by batch
TimeDifference jobrun_timediff int - - Time difference between master and agent
TimeWindow jobrun_timewin short - - see jobdtl_timewin
TrackCl jobrun_trackcl string 5.3.0 - Whether to track spawned child processes
TrackCommand jobrun_trackcmd string - - see jobdtl_trackcmd
TrackMethod jobrun_trackmethod short - - see jobdtl_trackmethod
TransactionID jobrun_trxid int - - internal
TriggerActionRun_ID trgtskrun_id int 5.2.1 - Id of the trigger-action run that originated this job
TriggerActionRun_Transactiontrgtskrun_transaction int 5.2.1 - Id of the transaction that originated this job
UntilTime jobrun_untiltm datetime- - see jobdtl_untiltm
Variables jobrun_vars clob 6.0.0 - Local variables used for this run of the job.
Waitop jobrun_waitop string - - Job waits for operator release (Y/N)
WorkingDirectory jobrun_workdir string - - Directory to run program in
XmlData jobrun_extinfo clob - - XML data associated with this job.

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
ActiveTime WRAPPER_OBJECTlong - - Time the job went into Active status
AdapterJob WRAPPER_OBJECTObject - - The Job from the Common Adapter.
AdapterJobID INMEMORY int - - The ID of the Job used to talk with the Common
Adapter.
AdhocOverrideFlag INMEMORY string - - Flag is Y if this is an adhoc job and time deps should
be ignored.
CacheLastChangeTime INMEMORY datetime - - Last in-memory modified timestamp
CachedJobRecord WRAPPER_OBJECTcom.tidalsoft.scheduler.model.Job - - Cached reference to jobrun's job record.
CachedJobRunExRecord WRAPPER_OBJECTcom.tidalsoft.scheduler.model.JobRunEx - - Cached reference to jobrun's jobrunex record.
CalcStartTimeTimerID INMEMORY int - - Timer ID for recalculating estimated start time
ChildJobsWereLoadedFlag INMEMORY string - - "Y" if all child jobruns are known to have been loaded
into memory. Used to optimize loading child jobruns
when rerunning a group from a previous production
day.
ClientRequestMessage INMEMORY string - - Message to send back to the client.
ClientRequestSuccess INMEMORY string - - Y if successful, N if not.
ClientRequestUserContext WRAPPER_OBJECTcom.tidalsoft.scheduler.api.objects.UserContext- - ApiObject user session context of the request.
CurrentEstimatedStartTime INMEMORY datetime - - Estimated start time at runtime
ExtendedInfo WRAPPER_OBJECTExtendedInfo - - The ExtendedInfo record for this JobRun
FtpBytes INMEMORY int - - The total number of bytes handled by FTP
FtpFiles INMEMORY int - - The total number of files handled by FTP
FtpSeconds INMEMORY int - - The total number of seconds the FTP operation worked
FtpSkipped INMEMORY int - - The number of files skipped by FTP
GroupActiveFlag INMEMORY string - - Flag is Y if this is a group that is running, regardless of
current status. This is set to Y when group first goes
active and is only reset when group is rerun.
HasChildRunFlag INMEMORY string - - Set to Y if a child of this group is active or has
completed.
HasStatusChangeMessage WRAPPER_OBJECTboolean - - Flag is true if the jobrun has a status change message
in the queue.
IsCancelledFlag INMEMORY string - - Flag is Y if the job is being cancelled.
IsCheckDepsCalled WRAPPER_OBJECTlong - - Record if Check Dependencies call in enroute in the
message queue.
IsReleaseFlag INMEMORY string - - Flag is Y if the job is being released from a HOLD.
IsRerunFlag INMEMORY string - - Flag is Y if the job is rerunning; it is N during the first
run of the job.
JobRunDepList WRAPPER_OBJECTDataList - - The DataList of JobRunDep objects for this JobRun
LaunchPhase INMEMORY int - - Which phase of launching is this job in
Name ValueDescription
JOB_LAUNCHPHASE_WAITING 0 Job is waiting
mode
Job has been
JOB_LAUNCHPHASE_LAUNCHING20 launched by
the
QueueManager
Job has been
launched by
the Agent and
JOB_LAUNCHPHASE_LAUNCHED 50 Service objects
and job has
changed state
to launched
MessageText_ID INMEMORY int - - The ID of the MessageText object with some data for
this job
NeededDependencyCount WRAPPER_OBJECTint - - Count of the number of dependencies needed to be
met before job can run. This is used to reduce the
number of messages sent by JobRunDep objects.
PeoplesoftJobRuns WRAPPER_OBJECTDataList - - If this is a PeopleSoft job, then this points to the
PeoplesoftJobRun record.
PrevStatus INMEMORY short - - Previous status of job instance:
QueueTimer_ID INMEMORY int - - The ID of the timer used by the Queue to fire if the job
has been waiting too long
SapJobRuns WRAPPER_OBJECTDataList - - If this is a SAP job, then this points to the SapJobRun
record.
TriggerTimerType INMEMORY int - - The trigger that the TriggerTimer is tracking.
TriggerTimer_ID INMEMORY int - - The ID of the timer that fires at different times to
enforce triggers.
TriggerTimers WRAPPER_OBJECTObject - - Trigger timer ids.
Triggers WRAPPER_OBJECTjava.util.Vector - - List of the jobrun's triggers.
UpdateEstimatedStartTimeTimestampINMEMORY long - - Timestamp of when we last updated the estimated
start time.
WaitingOnResourcesTime WRAPPER_OBJECTlong - - Time the job went into Waiting on Resources status
JobRunDep Table
Data Model

Table Summary
Logical Name JobRunDep
Database TableIN-MEMORY
Added In -
Removed In -
Description JobRun dependency definitions. These do not get saved to the database, but
the ID comes from the TableCounts table so the database table must be set.

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
CanIgnore INMEMORY string - - Ignore if dependency not in
schedule (Y/N)
DateOffset INMEMORY short - - Date offset for dependency
instance
DependencyVariable_IDINMEMORY int - - ID for variable in the value
field as a token
FileExtent INMEMORY long - - Size for file dependency
Filename INMEMORY string - - Path and name of file for
file dependency; variables
may be embedded
Filetype INMEMORY short - - Type of file dependency:
FromTimer_ID INMEMORY int - - The ID of the timer that
fires at the start of the job
window
HasMetBeenUsed WRAPPER_OBJECTString - - Flag that is Y if the
dependency being met was
used to run a job. For jobs
that repeat, this will
prevent a job from
rerunning until the
dependency went back to
unmet, then to met.
ID INMEMORY int - - ID of this JobRunDep object
InstanceOffset INMEMORY short - - Job dependency offset from
first or last instance
InstanceWithinGroup INMEMORY string - - Flag that job dependency
should match instance
within group
IsMet WRAPPER_OBJECTString - - Flag that is Y if dependency
is met
JesMessage INMEMORY string - - Holds XML messages from
JES adapter
JobDependency WRAPPER_OBJECTJobDependency- - The dependency definition
JobDependency_ID INMEMORY int - - ID of the JobDependency
object this dep is based on.
JobLogic INMEMORY short - - Condition used for
matching occurrence:
JobRunRecord WRAPPER_OBJECTJobRun - - The JobRun record that
owns this
JobRun_ID INMEMORY int - - ID of JobRun that owns this
dep
Job_ID INMEMORY int - - ID of the Job type we
depend on (if a job dep)
KeepMetIfReady INMEMORY string - - When a job is waiting on
resource, don't let the
dependency go unmet
(Y/N)
MetValue INMEMORY string - - The value of the variable
that caused this
dependency to be met
Node_ID INMEMORY int - - Unique ID for connection
Operator INMEMORY short - - Operator used for
dependency condition, one
of
JobDependency.JOB_DEP_*
Override WRAPPER_OBJECTString - - Flag that is Y if dependency
can be overridden
Sequence INMEMORY int - - Sequence number; used by
JES
Status INMEMORY short - - Status required to meet
dependency requirement
TimesMet WRAPPER_OBJECTint - - Number of times
dependency was met.
TimesUsed WRAPPER_OBJECTint - - Number of times
dependency was used to
satisfy its owning job.
Type WRAPPER_OBJECTshort - - Type of dependency:
UntilTimer_ID INMEMORY int - - The ID of the timer that
fires at the end of the job
window
Value INMEMORY string - - Value required for variable
dependency
Variable_ID INMEMORY int - - Unique ID for variable
JobRunEx Table
Data Model

Table Summary
Logical Name JobRunEx
Database Tablejobrunx
Added In -
Removed In -
Description Extended JobRun info.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
ID jobrun_id int - - Unique ID for this run of job
LastChangeTimejobrunx_lstchgtmdatetime6.0.0 - Last modified timestamp
XmlData jobrun_extinfo clob - - XML data associated with this job.

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
CachedJobRunRecordWRAPPER_OBJECTcom.tidalsoft.scheduler.model.JobRun- - Cached
reference to
jobrunex's
jobrun
record.
JobStatus Table
Data Model

Table Summary
Logical Name JobStatus
Database Tablejobstat
Added In -
Removed In -
Description Log of job status changes for historical reporting.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
ID jobstat_id int - - Unique ID for table
JobRun_ID jobrun_id int - - Unique ID for this run of job
LastChangeTime jobstat_lstchgtm datetime6.0.0 - Last modified timestamp
ProductionDate jobrun_proddt datetime- - Production date for this job instance
Status jobrun_status short - - Current status of job instance:
Name ValueDescription
JOB_STATUS_ACTIVE_RANGE 50 internal
JOB_STATUS_PREDONE_RANGE90 internal
JOB_STATUS_DONE_RANGE 100 internal
has just been
JOB_STATUS_SCHEDULED 0 compiled,
initial state
JOB_STATUS_WAIT 1 internal
JOB_STATUS_WAITOP 2 internal
JOB_STATUS_HOLD 3 internal
missed the
window
JOB_STATUS_TIMEOUTTODAY 5 today, will try
again
tomorrow
agent is not
JOB_STATUS_AGENTUNAVAIL 7
connected
agent is
JOB_STATUS_AGENTINACTIVE 8 marked
inactive
agent is in an
JOB_STATUS_AGENTOUTAGE 9
outage period
the parent
group is
JOB_STATUS_WAITONGROUP 10 waiting on
operator
(waitop)
the children
are waiting on
JOB_STATUS_WAITCHILDREN 11
dependencies,
or none active
keep it the
JOB_STATUS_READY 49 last in the
group
JOB_STATUS_LAUNCH 50 internal
JOB_STATUS_ACTIVE 51 internal
JOB_STATUS_STOP 52 internal
JOB_STATUS_DEFERRED 53 internal
JOB_STATUS_ERROR 66 internal
 JOB_STATUS_PRENORMAL 97 internal
JOB_STATUS_PREABNORM 98 internal
JOB_STATUS_PREEXTERN 99 internal
JOB_STATUS_NORMAL 101 internal
JOB_STATUS_ABNORMAL 103 internal
JOB_STATUS_SKIPPED 104 internal
job's agent is
JOB_STATUS_ORPHAN 105
down
post launch
JOB_STATUS_ABORTED 106
action
JOB_STATUS_EXTERN 107 internal
missed the
window
today,
JOB_STATUS_TIMEOUT 108
requires
manual
intervention
JOB_STATUS_CANCELLED 109 pre-launch
action
StatusChangeTimejobrun_stachgtmdatetime- - Date and time of last status change
Language Table
Data Model

Table Summary
Logical Name Language
Database Tablelngmst
Added In -
Removed In -
Description Language master (currently only English supported).

Database Columns
Logical Name Database Field Type Added In Removed In Description
Description lngmst_desc string- - Reserved for future use
ID lngmst_id int - - Unique ID for language
Name lngmst_name string- - English only for now
Location Table
Data Model

Table Summary
Logical Name Location
Database Tablelocmst
Added In 6.0.0
Removed In -
Description Location

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
ID locmst_id int - - Unique id of
this Location.
LastChangeTime locmst_lstchgtm datetime- - Last modified
timestamp
LastUserModifiedTimelocmst_usrmodtmdatetime- - Last modified
by a user
Name locmst_name string - - Name of the
Location.
MasterJavaTimeZone Table
Data Model

Table Summary
Logical Name MasterJavaTimeZone
Database TableMasterJavaTimeZone
Added In -
Removed In -
Inmemory table used for list all available java timezones on master
Description
jvm.

In-Memory Columns
Logical Name Database FieldType Added InRemoved InDescription
DSTTZOffset INMEMORY int - - DST Timezone time
differences:
FullName INMEMORY string - - Full name of java
timezone.
ID INMEMORY int - - Unique ID of this
MasterJavaTimeZone.
InDSTTZPeriod INMEMORY String - - Current in DST
Timezone period:
LastChangeTimeINMEMORY datetime- - Last modified
timestamp
MasterTZOffset INMEMORY int - - Master Timezone
Offset:
Name INMEMORY string - - short name of java
timezone.
TimeZoneID INMEMORY string - - Unique timezone id.
UTCTZOffset INMEMORY int - - UTC/GMT Timezone
Offset:
MessageCatalog Table
Data Model

Table Summary
Logical Name MessageCatalog
Database Tablemsgmst
Added In -
Removed In -
Description Message catalog for log messages (no text).

Database Columns
Logical Name Database Field TypeAdded InRemoved InDescription
Exclude msgmst_exclude string- - Flag to indicate whether to exclude this type
of log message (Y/N)
ID msgmst_id int - - Unique ID for this log message type
Type msgmst_type short - - Severity of log message:
Name ValueDescription
MSG_TYPE_ERROR 1 internal
MSG_TYPE_AUDIT 2 internal
MSG_TYPE_DIAGNOSTIC3 internal
MSG_TYPE_WARNING 4 internal
WindowsEventLogmsgmst_eventlogstring- - Flag to indicate if message should be added
to NT Event logging (Y/N)

In-Memory Columns
Logical Name Database Field Type Added In Removed In Description
LastChangeTime INMEMORY datetime - - Last modified timestamp
MessageLog Table
Data Model

Table Summary
Logical Name MessageLog
Database Tablemsglog
Added In -
Removed In -
Description Audit, Error and Diagnostic log messages.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Category msglog_category short 6.0.0 - Category of this message
Computer msglog_computer string - - Name of computer for log record
Context msglog_context int 6.0.0 - Context of this message
CreateDate msglog_crtdt datetime- - Creation date for message
ID msglog_id int - - Unique ID for log record
JobRun_ID jobrun_id int - - Unique ID for this run of job
Job_ID jobmst_id int - - Unique ID for job
LastChangeTimemsglog_lstchgtm datetime6.0.0 - Last modified timestamp
Message_ID msgmst_id int - - Unique ID for this log message type
Node_ID nodmst_id int - - Unique ID for connection
OriginalUserID msglog_origid int - - Log of original ID of user prior to
impersonating another user
Queue_ID quemst_id int 6.0.0 - Unique ID for queue
Resource_ID resmst_id int 6.0.3 - Unique ID for the resource
Session_ID usersession_id int 6.0.0 - Unique ID for the Session
Source msglog_source short - - Source of log message:
Name ValueDescription
SOURCE_MASTER 1 internal
SOURCE_CLIENT 2 internal
SOURCE_AGENTMGR 3 internal
SOURCE_FAULT 4 internal
SOURCE_DEPMGR 5 internal
SOURCE_JOBMGR 6 internal
SOURCE_TASKMGR 7 internal
SOURCE_QUEMGR 8 internal
SOURCE_COMPILER 9 internal
SOURCE_CQD 10 internal
SOURCE_CLIENTMSG 11 internal
SOURCE_API 12 internal
SOURCE_ADAPTER 13 internal
SOURCE_TRANSPORTER 14 internal
SubCategory msglog_subcategoryshort 6.0.0 - SubCategory of this message
Text msglog_text string - - Log message text
Type msglog_type short - - Severity of log message:
Name ValueDescription
MSG_TYPE_ERROR 1 internal
MSG_TYPE_AUDIT 2 internal
MSG_TYPE_DIAGNOSTIC3 internal
MSG_TYPE_WARNING 4 internal
User_ID usrmst_id int - - Unique ID for user; default runtime user
when an agent is selected for a job
MessageParm Table
Data Model

Table Summary
Logical Name MessageParm
Database Tablemsgparm
Added In -
Removed In -
Description Not used.

Database Columns
Logical NameDatabase Field TypeAdded InRemoved InDescription
ID msgparm_id int - - Reserved for future use
Message_ID msgmst_id int - - Unique ID for this log
message type
Sequence msgparm_sequenceshort - - Reserved for future use
Token msgparm_token string- - Reserved for future use
Type msgparm_type short - - Reserved for future use
MessageText Table
Data Model

Table Summary
Logical Name MessageText
Database Tablemsgtxt
Added In -
Removed In -
Description Table of log messages by language links to msgmst.

Database Columns
Logical NameDatabase FieldTypeAdded InRemoved InDescription
ID msgtxt_id int - - Unique ID for table
Language_ID lngmst_id int - - Unique ID for language
Message_ID msgmst_id int - - Unique ID for this log
message type
Text msgtxt_text string- - Text of log message
Node Table
Data Model

Table Summary
Logical Name Node
Database Tablenodmst
Added In -
Removed In -
Description Connection data for the master and agents. Includes non-floating license information.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Active nodmst_active string - - Flag indicating whether agent is enabled "Y",
disabled "N", in an outage "O" that will end when
the user enables the node, or suspended "S" in
an outage that will end with the end of outage
time is reached
Alias nodmst_alias string 5.2.2 - TCP/IP name used to connect to agent
Alias2 nodmst_alias2 string 6.0.0 - Second alias for node
BackupHostname nodmst_backup string 6.1.0 - Backup master hostname
CpuCount nodmst_cpucnt short 6.0.0 - Number of CPUs on the node
Description nodmst_desc string - - Description of agent
EnabledJobs nodmst_activejobs short - - Number of jobs currently defined and enabled for
agent (used for licensing)
ID nodmst_id int - - Unique ID for connection
Name ValueDescription
This Node is
NODE_ID_PRIMARY_MASTER1 the primary
Master
This Node is
NODE_ID_BACKUP_MASTER -1 the backup
Master
This Node is
NODE_ID_FAULT_MONITOR -2 the fault
monitor
This Node is
NODE_ID_SERVICE_HOST -3 a service
host
IP nodmst_ip string - - Reserved for future use
LastChangeTime nodmst_lstchgtm datetime- - Last modified timestamp
LastUserModifiedTime nodmst_usrmodtm datetime6.0.0 - Last modified by a user
LastUserSetActiveTimenodmst_lstusracttm datetime5.2.2 - The most recent DateTime at which the user
enabled or disabled the node.
License nodmst_license clob - - Encrypted license information for master and
non-floating agents
Limit nodmst_limit short - - Maximum number of jobs that can run at the
same time on the agent
LocationID locmst_id int 6.0.0 - The foreign key to the locmst table
Name nodmst_name string - - Logical name for agent assigned by Administrator
NodeInfo nodmst_info clob - - The blob field for node information
OSType nodmst_ostype short - - Type of operating system for connection
Name ValueDescription
This Node is
NODE_OSTYPE_NT 1
Windows
This Node is
NODE_OSTYPE_UNIX 2
Unix
This Node is
NODE_OSTYPE_MPE 3
MPE
This Node is
NODE_OSTYPE_MVS 4
MVS
This Node is
NODE_OSTYPE_SAP 5
SAP adapter
This Node is
NODE_OSTYPE_PS 6 PeopleSoft
adapter
NODE_OSTYPE_AS400 7 This Node is
AS/400
This Node is
 NODE_OSTYPE_ORA 8 Oracle
adapter
This Node is
NODE_OSTYPE_ZEKE 9 Zeke
adapter
This Node is
ZOS
NODE_OSTYPE_ZOS 10
(OS/390)
adapter
This Node is
NODE_OSTYPE_CONS 11 Agent
Consolidator
adapter
This Node is
NODE_OSTYPE_SERVICE 12 a service
adapter
This Node is
NODE_OSTYPE_OVMS 13 a OVMS
agent
This Node
NODE_OSTYPE_DISTMASTER14 distributed
Master
PSAppServer nodmst_appserver string - 6.1.0 This field was used to hold backup master
hostname but is now removed
PSLogDirectory nodmst_logdir string - 6.1.0 This field was used for setting date/time var
cache received from remote masters but is now
removed.
PSOutputDirectory nodmst_outputdir string - 5.3.0 Output directory for PeopleSoft process
scheduler
ParentID nodmst_prntid int - - For Triton agents, the ID of its Consolidator
PeopleSoftDBName nodmst_dbname string - 5.3.0 Database name for PeopleSoft instance
PeopleSoftDBServer nodmst_dbserver string - 5.3.0 Name of database server for PeopleSoft instance
PeopleSoftType nodmst_pstype short - 5.3.0 Type of database for PeopleSoft
PeopleSoftUser nodmst_psuser int - 5.3.0 User ID corresponding to PeopleSoft database
access user
PeopleSoftUser2 nodmst_psuser2 int - 5.3.0 internal
PlatformVersion nodmst_platform_versionstring 6.0.0 - The version of whatever platform the master,
agent or adapter is running against
Port1 nodmst_port1 short - - Port 1 used for socket communication
Port2 nodmst_port2 short - - Port 1 used for socket communication
Port3 nodmst_port3 short - - Port 1 used for socket communication
RuntimeUser_ID usrmst_id int - - Unique ID for user; default runtime user when
an agent is selected for a job
SapClient nodmst_sapclient string - 5.1.3 For an SAP connection, the ID of a client for the
given instance
SapInstance nodmst_sapinstance string - 5.1.3 For an SAP connection, the ID of an SAP instance
SapUser nodmst_sapuser int - 5.1.3 SAP user master uses to check job status and get
output
ServiceID servicemst_id int - - The foreign key to the servicemst table
String1 nodmst_string1 string - - internal
String2 nodmst_string2 string - - internal
String3 nodmst_string3 string - - internal
TimeDiff nodmst_timediff int - - Time difference between agent and master
Timezone nodmst_tz string 5.2.2 - Timezone of the node
Type nodmst_type short - - Type of connection:
Name ValueDescription
This Node is
NODE_MASTER 1 the primary
Master
NODE_AGENT 2 This Node is an
agent
NODE_SHELL 3 This Node is a
shell
This Node is
NODE_BACKUP 4 the backup
Master
This Node is
NODE_FAULTMON 5 the fault
monitor
NODE_TRITON_AGENT 6 This Node is a
Triton agent
NODE_REMOTE_MASTER 7 This Node is a
remote master
This Node is a
NODE_ADAPTER 8 Common
Adapter
Communication
NODE_CONSOLIDATOR 9 proxy between
master and
agents
 This Node is a
NODE_SERVICE_HOST 10 Host for
services
This Node is an
Adapter that
NODE_SERVICE_ADAPTER11 runs as a
service in a
Service Host
This Node is a
NODE_DISTMASTER 12 Distributed
Master node
User nodmst_user int - - internal
VarSet nodmst_varset clob 6.1.0 - variable set for this connection
Version nodmst_version short - 6.0.0 The version of the master, agent or adapter
VersionString nodmst_version_str string 6.0.0 - The version of the master, agent or adapter

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
ActiveJobs INMEMORY short - - Number of
jobs currently
running on
agent
AdapterConnection WRAPPER_OBJECTObject - - The
Connection
used to talk
with the
Common
Adapter.
AdapterConnectionID INMEMORY int - - The ID of the
Connection
used to talk
with the
Common
Adapter.
AgentCPUCount INMEMORY int - - CPU Count
reported by
Agent
AgentDirectoryMonitorSnapinInitializedINMEMORY int - - Set to 1 if the
Monitor snapin
is running
AgentDirectoryMonitorSnapinVersion INMEMORY string - - Version
number of the
Monitor snapin
AgentFtpSnapinInitialized INMEMORY int - - Set to 1 if the
FTP snapin is
running
AgentFtpSnapinVersion INMEMORY string - - Version
number of the
FTP snapin
AgentJobSnapinInitialized INMEMORY int - - Set to 1 if the
Job snapin is
running
AgentJobSnapinVersion INMEMORY string - - Version
number of the
Job snapin
AgentLoad INMEMORY int - - The current
load of the
agent
AgentMachineName INMEMORY string - - The name of
the machine
the Agent runs
on
AgentMonitorSnapinInitialized INMEMORY int - - Set to 1 if the
Monitor snapin
is running
AgentMonitorSnapinVersion INMEMORY string - - Version
number of the
Monitor snapin
AgentNumLaunchedJobs WRAPPER_OBJECTcom.tidalsoft.framework.util.MutableInteger - - The current
number of jobs
that have been
launched on
the agent.
Used by
QueueMaster
to not overload
an agent.
AgentOSName INMEMORY String - - Agent OS
Name
AgentOSVer INMEMORY String - - Agent OS
 Version
AgentPlatform INMEMORY String - - Agent Platform
AgentSnapinInitSent INMEMORY int - - A flag that
indicates
whether the
agent snapin
init messages
have been sent
AgentVersion INMEMORY string - - The version
number of the
Agent
CacheLastChangeTime INMEMORY datetime - - Last in-
memory
modified
timestamp
CalcTimeZone WRAPPER_OBJECTboolean - - Calculate
TimeZone?
ClientPingTimer_ID INMEMORY int - - The ID of the
timer that fires
to tell the
Master to ping
the client
CommunicationConnection WRAPPER_OBJECTcom.tidalsoft.framework.comm.Connection - - The
Connection
used to talk to
this node.
ConnectionActive INMEMORY string - - Flag indicating
whether the
master has a
connection to
the agent.
(Y/N)
ConnectionObject WRAPPER_OBJECTObject - - An object
needed to
connect to the
remote
system.
CurrentOutageEnd INMEMORY datetime 5.2.2 - The DateTime
at which the
current outage
will end, or null
if not currently
in an outage
period.
CurrentProductionDay INMEMORY datetime - - The current
production day
for the master
DistributedID INMEMORY int - - ID of
distributed
process.
FtpSkippedFiles INMEMORY int - - The number of
files skipped by
FTP
FtpTotalBytes INMEMORY long - - The total
number of
bytes handled
by FTP
FtpTotalFiles INMEMORY int - - The total
number of files
handled by
FTP
FtpTotalSeconds INMEMORY long - - The total
number of
seconds the
FTP agent
worked
HeartbeatTimestamp INMEMORY long - - Timestamp of
when the last
heartbeat was
received from
the node.
Initialized INMEMORY string - - Flag indicating
whether agent
is initialized
(has
responded to
the master's
init message)
IsFirstAdapterConnectionAttempt INMEMORY String - - This is set to
"Y" until the
adapter makes
 its connection.
JmxObject WRAPPER_OBJECTjava.lang.Object 5.3.1 - JMX
management
object.
LastHeartBeatRecvTime INMEMORY datetime 5.2.2 - Last Time we
recevied
Heartbeat from
this
connection.
MasterPaused INMEMORY string - - A flag that
indicates
whether the
master is
active (N) or
paused (Y)
MasterRollover INMEMORY string - - A flag that
indicates
whether the
master is
rolling over to
a new
production day
(Y) or not (N)
MasterStartTime INMEMORY datetime - - The time the
master started
NextOutageBegin INMEMORY datetime 5.2.2 - The DateTime
at which the
next outage
will begin, or
null if currently
in an outage
period or none
are defined for
the node.
NodeDateFormatter WRAPPER_OBJECTjava.text.SimpleDateFormat 5.3.1 - Node Date
Formater
Object.
NodeExtension WRAPPER_OBJECTcom.tidalsoft.scheduler.logic.NodeExtension - - Reference to
an object that
contains
additional data
about this
Node.
ProcessRemoteVariableListsTimestampINMEMORY long - - Timestamp of
when the
remote
variable lists
was processed.
RecheckConnTimer INMEMORY int - - The ID of a
timer that fires
to tell the
Master to
recheck the
Node
connection
status
RemoteMasterClient WRAPPER_OBJECTcom.tidalsoft.scheduler.api.RemoteMasterClient6.0.0 - Remote master
client.
RemoteMasterTimer_ID INMEMORY int - - The ID of the
timer that
RemoteMasters
use to test the
connection.
Timer_ID1 INMEMORY int - - The ID of a
timer used by
the Node
Timer_ID2 INMEMORY int - - The ID of a
timer used by
the Node
UseEncryption INMEMORY string - - A flag that
indicates if the
master should
send encrypted
messages to
this agent.
NodeList Table
Data Model

Table Summary
Logical Name NodeList
Database Tablenodlstms
Added In -
Removed In -
Description Agent list master records.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Description nodlstmst_desc string - - Description of agent list
ID nodlstmst_id int - - Unique ID of agent list
LastChangeTime nodlstmst_lstchgtm datetime- - Last modified timestamp
LastUsed nodlstmst_lastused int - - ID of agent last used (for rotational lists)
LastUserModifiedTimenodlstms_usrmodtmdatetime6.0.0 - Last modified by a user
Name nodlstmst_name string - - Name of agent list
OSType nodlstmst_ostype short - - Operating system type of agents in list:
Name ValueDescription
NODE_OSTYPE_NT 1 Windows
NT/2000/XP
NODE_OSTYPE_UNIX2 Unix (all flavors)
NODE_OSTYPE_MPE 3 MPE
NODE_OSTYPE_MVS 4 MVS
NODE_OSTYPE_SAP 5 SAP
ParentID nodlstmst_prntid int - - For nested agent lists, parent list for a list
SequenceNumber nodlstmst_seq short - - Sequence number for list within list
Service_ID servicemst_id int - - The foreign key to the servicemst table
Type nodlstmst_type short - - Type of agent list:
Name ValueDescription
Process list in
NODE_LIST_ORDERED 1 order by
SequenceNumber
NODE_LIST_RANDOM 2 Randomly select
agents
Load balance:
NODE_LIST_BALANCED 3 run on most idle
agent
NODE_LIST_BROADCAST4 Broadcast to all
agents
NODE_LIST_ROTATION 5 Rotate among
agents

In-Memory Columns
Logical Name Database Field TypeAdded InRemoved InDescription
Active INMEMORY string
- - Flag indicating whether the nodelist
is active "Y" (has at least one active
child), inactive "N", outage "O", or
suspended "S" (all children are in
an outage and at least one is
suspended).
AgentList WRAPPER_OBJECTDataList - - The list of Agents, ordered by
sequence number.
AgentLoad INMEMORY int - - The current load of the agent
AgentNumActiveJobsINMEMORY int - - The current number of active jobs
CurrentOutageEnd INMEMORY datetime5.2.2 - The DateTime at which the current
outage will end on at least one
node in the list, or null if not
currently in an outage period.
NextOutageBegin INMEMORY datetime5.2.2 - The DateTime at which all of the
nodes on the list will be in a
simultaneous outage period, or null
if currently in an outage period or
none are defined for any node.
NodeListDetail Table
Data Model

Table Summary
Logical Name NodeListDetail
Database Tablenodlstdt
Added In -
Removed In -
Description Table of agents belonging to agent lists.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
ID nodlstdtl_id int - - Unique ID for
association between
agent and agent list
LastChangeTime nodlstdt_lstchgtmdatetime6.0.0 - Last modified
timestamp
NodeList_ID nodlstmst_id int - - Unique ID of agent
list
Node_ID nodmst_id int - - Unique ID for
connection
SequenceNumbernodlstdtl_seq short - - Sequence of agent
within agent list (for
ordered lists)
NodeOutage Table
Data Model

Table Summary
Logical Name NodeOutage
Database Tablenodout
Added In 5.2.2
Removed In -
Description Node outage schedules.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Calendar_ID evntmst_id int - - Unique ID for the calendar
FromTime nodout_fromtm datetime- - Start time of the outage
ID nodout_id int - - Unique ID for this outage
LastChangeTime nodout_lstchgtm datetime6.0.0 - Last modified timestamp
LastUserModifiedTimenodout_usrmodtmdatetime6.0.0 - Last modified by a user
Node_ID nodmst_id int - - Unique ID for node that has an outage
State nodout_state short - - State of the connection during outage
Name ValueDescription
The node is
suspended
NODE_OUTAGE_STATE_SUSPEND1
during the
outage
The node is
NODE_OUTAGE_STATE_DISABLE 2 disabled
during the
outage
UntilTime nodout_untiltm datetime- - End time of the outage

In-Memory Columns
Logical Name Database FieldType Added InRemoved InDescription
CurrentOutageEnd INMEMORY datetime5.2.2 - The DateTime at which this specific
outage will end, or null if this outage
is not currently in effect.
Initialized INMEMORY int - - Set to 1 when the outage times have
been initialized
NextOutageBegin INMEMORY datetime5.2.2 - The DateTime at which this specific
outage will next begin, or null if
currently in an outage period or there
is no future instance of this outage.
OutageBeginTimer_IDINMEMORY int - - The ID of the outage begin timer used
by the NodeOutage
OutageEndTimer_ID INMEMORY int - - The ID of the outage end timer used
by the NodeOutage
NodeResource Table
Data Model

Table Summary
Logical Name NodeResource
Database Tablenodres
Added In 6.0.3
Removed In -
Description Table to keep track of the latest system resource values for each node.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
CurrentSinceConnectednodres_current string
- - Flag indicating
if the value
has been
updated since
the connection
to the node
was
established
("Y" or "N")
ExternalIDString nodres_externid_strstring - - Unique
external ID
number for
tracking
ID nodres_id int - - Unique ID of
this
NodeResource.
Interval nodres_interval short - - Current
refresh interval
between
collections of a
system
resource
LastChangeTime nodres_lstchgtm datetime- - Last modified
timestamp
LastValue nodres_lstval string - - The previous
value of the
resource for
the node
LaunchAcknowledged nodres_launchack int - - Launch of
resource
command
acknowledged
 by agent
Node_ID nodmst_id int - - Unique ID for
connection
Resource_ID resmst_id int - - Unique ID for
the resource
Status nodres_status short - - Current status
of resource
command
execution.
TaskType nodres_tasktype short - - This is set so
as to route the
resource
command
through the
Agent handler
Task_ID task_id int - - Unique ID for
this
NodeResource
command
executing on
the agent
Value nodres_value string - - The latest
value of the
resource for
the node

In-Memory Columns
Logical NameDatabase FieldTypeAdded InRemoved InDescription
Timer_ID INMEMORY int - - The ID of a timer used by
the NodeResource to
collect the resource at the
specified interval
Owner Table
Data Model

Table Summary
Logical Name Owner
Database Tableowner
Added In -
Removed In -
Description Table of owners including users and workgroups.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
Allagents owner_allagents string - - Flag indicating whether user/workgroup is
authorized for all agents (Y/N)
ID owner_id int - - Unique ID for owners (users and workgroups)
LastChangeTimeowner_lstchgtm datetime6.0.0 - Last modified timestamp
Name owner_name string - - Name of owner (workgroup or user)
Type owner_type short - - f owner:
Name ValueDescription
OWNER_TYPE_USER 1 internal
OWNER_TYPE_WORKGROUP2 internal
OwnerAgent Table
Data Model

Table Summary
Logical Name OwnerAgent
Database Tableowneragt
Added In -
Removed In -
Description Agents authorized for each workgroup/owner.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
ID owneragt_id int - - Unique ID for table
LastChangeTimeowneragt_lstchgtmdatetime6.0.0 - Last modified
timestamp
Node_ID nodmst_id int - - Unique ID for
connection
Owner_ID owner_id int - - Unique ID for
owners (users and
workgroups)
PeoplesoftJob Table
Data Model

Table Summary
Logical Name PeoplesoftJob
Database Tablepsjob
Added In -
Removed In 5.3.0
Description PeopleSoft job rules.

Database Columns
Logical Name Database FieldTypeAdded InRemoved InDescription
ActionSchedule_IDtsksch_id int - - Jobmst ID for add job action
Always psjob_always string- - Run always flag for PeoleSoft process
ID psjob_id int - - Unique ID for table
Job_ID jobmst_id int - - Unique ID for job
Output psjob_output short - - PeopleSoft output path
OutputDestination psjob_outdest string- - Printer or file output destnation for
PeopleSoft process
Name ValueDescription
PSDEST_NONE "0" internal
PSDEST_PRINTER"1" internal
PSDEST_FILE "2" internal
OutputFormat psjob_outfmt int - - internal
OutputPath psjob_saoutput string- - PeopleSoft process output path for
sysJADMIRAL
ProcessName psjob_procname string- - PeopleSoft process name
ProcessTtype psjob_proctype string- - PeopleSoft process type
RunControl psjob_runcontrolstring- - PeopleSoft run control ID
RunMask psjob_runmask string- - internal
RunValues psjob_runvals clob - - internal
Server psjob_server string- - Server name for process loaded from
pre-existing jobs
Step psjob_step short - - PeopleSoft process sequence number
PeoplesoftJobRun Table
Data Model

Table Summary
Logical Name PeoplesoftJobRun
Database Tablepsrun
Added In -
Removed In 5.3.0
Description PeopleSoft job instance records.

Database Columns
Logical Name Database Field TypeAdded InRemoved InDescription
ActionSchedule_IDtsksch_id int - - Jobmst ID for add job
action
Always psrun_always string- - see psjob_always
ID psrun_id int - - Unique ID for psrun
Instance psrun_instance int - - Process request table
instance number
JobRun_ID jobrun_id int - - Unique ID for this run
of job
Job_ID jobmst_id int - - Unique ID for job
Output psrun_output short - - see psjob_ouptut
OutputDestination psrun_outdest string- - see psjob_outdest
OutputFormat psrun_outfmt int - - internal
OutputPath psrun_saoutput string- - see psjob_saoutput
ParamList psrun_parmlist string- - Parameter list for
PeopleSoft process
ProcessName psrun_procname string- - see psjob_procname
ProcessType psrun_proctype string- - see psjob_proctype
RunControl psrun_runcontrolstring- - see psjob_runcontrol
RunMask psrun_runmask string- - internal
RunValues psrun_runvals clob - - internal
Server psrun_server string- - see psjob_server
Step psrun_step short - - see psjob_step

In-Memory Columns
Logical NameDatabase FieldTypeAdded InRemoved InDescription
LastInstance INMEMORY int - - Saves the last process
instance number for
restart.
Queue Table
Data Model

Table Summary
Logical Name Queue
Database Tablequemst
Added In -
Removed In -
Description Queue definition master records.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Active quemst_active string - - Flag indicating
whether queue
is currently
enabled (Y/N)
Bump quemst_bmp string - - Flag to indicate
whether jobs
are bumped in
priority after
waiting
BumpFrequency quemst_bmp_freq short - - How often in
minutes to
bump job's
priority
BumpPriority quemst_bmp_pri short - - Number of
priority points
to bump after
each interval
BumpQueue quemst_bmp_que int - - Higher priority
queue to bump
to after a job
has been
bumped past
priority of 100
Description quemst_desc string - - Description of
queue
FromTime quemst_fromtm datetime- - Earliest time
jobs can run in
queue
HighPriority quemst_hipri string - - Flag indicating
jobs in queue
should launch
immediately
 regardless of
number of jobs
running (Y/N)
ID quemst_id int - - Unique ID for
queue
Info quemst_info clob - - XML data
about the
queue.
LastChangeTime quemst_lstchgtm datetime- - Last modified
timestamp
LastUserModifiedTimequemst_usrmodtmdatetime6.0.0 - Last modified
by a user
Limit quemst_limit short - - Maximum
number of jobs
that can run in
queue at the
same time
Name quemst_name string - - Name of
queue
Nice quemst_nice short - - Nice value for
UNIX jobs run
from queue
ParentID quemst_prntid int - - ID for queue's
parent
Priority quemst_pri short - - Priority of
queue relative
to other
queues
SapClass quemst_sapclass string - 5.1.3 SAP Class
UntilTime quemst_untiltm datetime- - Latest time
jobs can
launch from
the queue

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
BumpTimeTimer_ID INMEMORY int - - Timer ID for
until time
ChildQueueList WRAPPER_OBJECTDataList - - The DataList
of Queues
that are
children of
this Queue
ClearDoneTimer_ID INMEMORY int - - Timer ID for
timer to
clear done
jobs
FromTimeTimer_ID INMEMORY int - - Timer ID for
from time
IsJobRunWaitListSortedWRAPPER_OBJECTboolean - - Is DataList
of JobRun
objects
waiting in
this Queue
Sorted
JobRunRunList WRAPPER_OBJECTQueueJobList- - The DataList
of JobRun
objects
running in
this Queue
JobRunWaitList WRAPPER_OBJECTQueueJobList- - The DataList
of JobRun
objects
waiting in
this Queue
NumRunningJobs INMEMORY int - - Number of
running jobs
in the
queue.
NumWaitingJobs INMEMORY int - - Number of
waiting jobs
in the
queue.
Open INMEMORY string - - Flag
indicating
whether
queue is
currently
open (Y/N)
ParentPriority INMEMORY int - - The smallest
priority of
any ancestor
ParentQueue WRAPPER_OBJECTQueue - - The parent
of this
Queue
UntilTimeTimer_ID INMEMORY int - - Timer ID for
until time
QueueFilter Table
Data Model

Table Summary
Logical Name QueueFilter
Database Tablequefilt
Added In -
Removed In -
Description Filters associated with each queue.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Exclude quefilt_exclude string - - Flag indicating whether queue filter criteria
is for exclusion (Y/N)
ID quefilt_id int - - Unique ID for queue filter
Integer1 quefilt_integer1 int - - Integer value for queue filter
Integer2 quefilt_integer2 int - - Integer value for queue filter
LastChangeTime quefilt_lstchgtm datetime6.0.0 - Last modified timestamp
LastUserModifiedTimequefilt_usrmodtmdatetime6.0.0 - Last modified by a user
QueueFilter_Info quefilt_info clob - - The blob field for queue filter information
Queue_ID quemst_id int - - Unique ID for queue
ServiceID servicemst_id int - - The foreign key to the servicemst table
String quefilt_string string - - String value for queue filter
Type quefilt_type short - - Type of queue filter:
Name ValueDescription
QUE_TYPE_NAME 1 internal
QUE_TYPE_NAMEMASK 2 internal
QUE_TYPE_GROUP 3 internal
QUE_TYPE_CLASS 4 internal
QUE_TYPE_CMD 5 internal
QUE_TYPE_CMDMASK 6 internal
QUE_TYPE_PATH 7 internal
QUE_TYPE_OWNER 8 internal
QUE_TYPE_USER 9 internal
QUE_TYPE_NODE 10 internal
QUE_TYPE_NODELIST 11 internal
QUE_TYPE_PRIORITY 12 internal
QUE_TYPE_RUNTIME 13 internal
QUE_TYPE_ONDEMAND14 internal
QUE_TYPE_MANUAL 15 internal
QUE_TYPE_SAP 16 Special filter
for SAP jobs
Filter data
QUE_TYPE_ADAPTER 17 created by
an adapter.
Special filter
for
QUE_TYPE_ORA 18
OracleApps
jobs
The
maximum
MAX_QUE_TYPE 18 number
used for
type of filter.
QueueJobList Table
Data Model

Table Summary
Logical Name QueueJobList
Database TableIN-MEMORY
Added In -
Removed In -
Description A pseudo object that holds a list of JobRuns for a queue.

In-Memory Columns
Logical NameDatabase Field Type Added InRemoved InDescription
JobRunList WRAPPER_OBJECTDataList- - The DataList of JobRun
objects
Queue_ID INMEMORY int - - ID of queue that owns this
list
Type INMEMORY short - - Type of list:
Name ValueDescription
Jobs that are
WAITLIST1
waiting
Jobs that are
RUNLIST 2
running
QueueMaster Table
Data Model

Table Summary
Logical Name QueueMaster
Database TableIN-MEMORY
Added In -
Removed In -
Description A pseudo object that manages Queues.

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
Active INMEMORY string - - Flag
indicating
whether
queue
processing is
currently
enabled
(Y/N)
CheckJobsTimer_ID WRAPPER_OBJECTint - - The ID of
the timer
that
QueueMaster
uses to try to
launch jobs.
IsProcessJobStatusCalled WRAPPER_OBJECTlong - - Record if
Process Job
Status call in
enroute in
the message
queue.
JobStatusChangeList WRAPPER_OBJECTjava.util.concurrent.ConcurrentLinkedQueue- - List of jobrun
object with
status
change
message
that needs to
be
processed.
QueueList WRAPPER_OBJECTDataList - - The DataList
of all Queue
objects
ValidateResLockTimer_IDINMEMORY int - - The ID of
the timer
that
QueueMaster
uses to try to
validate
resource
locks.
Resource Table
Data Model

Table Summary
Logical Name Resource
Database Tableresmst
Added In -
Removed In -
Description Represents a thing that a job uses.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Active resmst_active string - - Flag indicating whether resource is enabled
ApplyToAllNodes resmst_allnodes string 6.0.3 - Flag indicating whether resource collection is to be
applied to all nodes of the specified type.
BusinessUnit_ID bizunit_id int 6.0.3 - The Business Unit this resource belongs to
CollectionMethod resmst_collmethodshort 6.0.3 - Method use to determine the resource value based
on execution of the command.
Name ValueDescription
Resource
value is the
RESOURCE_COLLECT_OUTPUT 1 output of
the
command
Resource
value is the
RESOURCE_COLLECT_EXITCODE2 exit code of
the
command
Command resmst_cmd string 6.0.3 - Command/program to be executed to collect
resource
DataType resmst_datatype short 6.0.3 - Data type of resource value:
Name ValueDescription
RESOURCE_STRING 1 Value is a string
RESOURCE_NUMBER2 Value is an integer
RESOURCE_DATE 3 Value is a date
(M/d/yyyy)
RESOURCE_BOOL 4 Value is a boolean
Description resmst_desc string - - Description
ID resmst_id int - - Unique ID for record
InUse resmst_inuse int - - Number in use
Interval resmst_interval short 6.0.3 - Refresh interval between collections of a system
resource
LastChangeTime resmst_lstchgtm datetime- - Last modified timestamp
LastUserModifiedTimeresmst_usrmodtm datetime6.0.0 - Last modified by a user
Limit resmst_limit int - - Number available
Locked resmst_locked int 5.2.2 - The number of resources that are locked offline
Name resmst_name string - - The name of this resource
Node_OSType nodmst_ostype short 6.0.3 - Type of operating system for connection.
Node_Type nodmst_type short 6.0.3 - Type of connection.
Offline resmst_offline int 5.2.2 - The number of resources that are offline
Owner resmst_owner int - - Owner of resource
Params resmst_params clob 6.0.3 - Parameter string passed to command/program
Public resmst_public string - - Flag indicating whether resource is public
ResourceType resmst_restype short 6.0.3 - Type of resource:
Name ValueDescription
TYPE_VIRTUAL 1 A defined virtual resource.
A resource published by a
 TYPE_PUBLISHED2
node.
A defined command
TYPE_CUSTOM 3 executed on a node to
collect a resource value.
Task_ID resmst_taskid int - - Unique ID for this Resource command executing on
any of the agents that it is joined with
ResourceJobJoin Table
Data Model

Table Summary
Logical Name ResourceJobJoin
Database Tableresjob
Added In -
Removed In -
Description Joins resources to jobs.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
CompareValue resjob_value string 6.0.3 - Value to compare
ID resjob_id int - - Unique ID for record
JobID jobmst_id int - - ID of the Job
LastChangeTimeresjob_lstchgtm datetime6.0.0 - Last modified timestamp
Operator resjob_operator short 6.0.3 - Operator used to compare resource value
Name ValueDescription
The node
resource
value is
EQUAL 1
equal to the
compare
value.
The node
resource
value is not
NOT_EQUAL 2
equal to the
compare
value.
The node
resource
value is less
LESS_THAN 3
than the
comparison
value.
The node
resource
value is less
LESS_THAN_OR_EQUAL 4 than or
equal to the
comparison
value.
The node
resource
value is
GREATER_THAN 5 greater than
the
comparison
value.
The node
resource
value is
 greater than
GREATER_THAN_OR_EQUAL 6
or equal to
the
comparison
value.
The node
resource
value
CONTAINS 7
contains the
comparison
value.
The node
resource
does not
DOES_NOT_CONTAIN 8
contain the
comparison
value.
The node
resource
value
matches the
MATCHES_PATTERN 9 pattern
specified in
the
comparison
value.
The node
resource
value does
not match
DOES_NOT_MATCH_PATTERN10 the pattern
specified in
the
comparison
value.
The node
resource
value
matches the
regular
MATCHES_REGEXP 11
expression
specified in
the
comparison
value.
The node
resource
value does
not match
the regular
DOES_NOT_MATCH_REGEXP 12
expression
specified in
the
comparison
value.
ResourceID resmst_id int - - ID of the resource
Used resjob_use int - - Number of the resource used
ResourceLock Table
Data Model

Table Summary
Logical Name ResourceLock
Database Tablereslock
Added In 5.2.2
Removed In -
Description Stores the locked resources.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
ID reslock_id int - - Unique ID for record
JobRunID jobrun_id int - - ID of the JobRun
LastChangeTimereslock_lstchgtmdatetime6.0.0 - Last modified
timestamp
NumLocked reslock_locked int - - Number of the
resources locked
ResourceID resmst_id int - - ID of the resource
ResourceNodeJoin Table
Data Model

Table Summary
Logical Name ResourceNodeJoin
Database Tableresnod
Added In 6.0.3
Removed In -
Description Joins resources to nodes and nodelists.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
ID resnod_id int - - Unique ID for record
LastChangeTimeresnod_lstchgtm datetime- - Last modified
timestamp
NodeList_ID nodlstmst_id int - - Unique ID of agent list
Node_ID nodmst_id int - - Unique ID for
connection
Resource_ID resmst_id int - - ID of the resource
SapJob Table
Data Model

Table Summary
Logical Name SapJob
Database Tablesapjob
Added In -
Removed In 5.1.3
Description Step data for SAP jobs (not used for pre-defined SAP jobs).

Database Columns
Logical Name Database Field TypeAdded InRemoved InDescription
ActionSchedule_IDtsksch_id int - - Jobmst ID for add job action
Archive sapjob_archive short - - SAP archive option
Copies sapjob_copies short - - Number of copies of SAP job output to
print
DeleteAfterSpool sapjob_delspool string- - Flag indicating whether to delete SAP
spool file after deleted
Info sapjob_info string- - SAP archive parameter
Job_ID jobmst_id int - - Unique ID for job
Object sapjob_object string- - SAP archive parameter
OutputPassword sapjob_outpass string- - Password to assign to job's output
Params sapjob_parms string- - Parameters for ABAP progarm
PrintNow sapjob_printnow string- - internal
Printer sapjob_printer string- - Printer for job step
Program sapjob_program string- - ABAP program or external program for
job step
SapObject sapjob_sapobjectstring- - SAP archive parameter
Step sapjob_step short - - SAP job step number
StepInfo sapjob_stepinfo text - - internal
StepType sapjob_steptype short - - Type of SAP job step:
Name ValueDescription
ABAP 1 SAP ABAP
program
EXTERNAL_PROGRAM2 External
program
INFO_PACK 3 Info Package
BW Process
PROCESS_CHAIN 4
Chain
Title sapjob_title string- - The print title for an SAP job
Variant sapjob_variant string- - Variant to use for ABAP program
VariantMask sapjob_varmask string- - internal
VariantValues sapjob_varvals string- - internal
SapJobRun Table
Data Model

Table Summary
Logical Name SapJobRun
Database Tablesaprun
Added In -
Removed In 5.1.3
Description Run data for all SAP jobs.

Database Columns
Logical Name Database Field TypeAdded InRemoved InDescription
ActionSchedule_IDtsksch_id int - - Jobmst ID for add job action
Archive saprun_archive short - - SAP archive parameter
Copies saprun_copies short - - Number of print copies
DeleteAfterSpool saprun_delspool string- - Delete spool file after printing (Y/N)
Info saprun_info string- - SAP archive parameter
JobRun_ID jobrun_id int - - Unique ID for this run of job
Job_ID jobmst_id int - - Unique ID for job
Object saprun_object string- - SAP archive parameter
OutputPassword saprun_outpass string- - Output password
Parms saprun_parms string- - Parameters for external programs
PrintNow saprun_printnow string- - Print immediately (not spooled)
Printer saprun_printer string- - Printer device
Program saprun_program string- - ABAP or external program
SapObject saprun_sapobjectstring- - SAP archive info
Step saprun_step short - - Sequence number of SAP job step
StepInfo saprun_stepinfo text - - internal
StepType saprun_steptype short - - Type of SAP job step:
Name ValueDescription
SAP ABAP
ABAP 1
program
External
EXTERNAL_PROGRAM 2
program
External
EXTERNAL_COMMAND3
command
INFO_PACK 4 Info Package
BW Process
PROCESS_CHAIN 5
Chain
Title saprun_title string- - internal
Variant saprun_variant string- - ABAP program variant
VariantMask saprun_varmask string- - internal
VariantValues saprun_varvals string- - internal
Schedule Table
Data Model

Table Summary
Logical Name Schedule
Database Tableschmst
Added In -
Removed In -
Description Records for each production day with statistics created by compiler.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
AdhocGroups schmst_adhocgroupsint - - internal
AdhocJobs2 schmst_adhocjobs2 int - - internal
BatchCount schmst_btchcnt int - - internal
Carryover2 schmst_carryover2 int - - internal
CompileFinished schmst_comp short - - Flags whether compile has completed for
day (2 if completed)
Name ValueDescription
Compiler has
COMPILE_INIT 0
just started.
Compiler is
COMPILE_IN_PROCESS1
running.
Compiler has
COMPILE_COMPLETED 2
finished.
Compiler
created a
COMPILE_FORECAST 3
forecast for
the date.
CompileTime schmst_comptime short - - The duration of the compile
ID schmst_id int - - Unique ID for table
LastChangeTime schmst_lstchgtm datetime6.0.0 - Last modified timestamp
LastCompileTime schmst_lstcmptm datetime- - The last time the date was compiled
LastUserModifiedTimeschmst_usrmodtm datetime6.0.0 - Last modified by a user
NextBatch schmst_nxtbtch int - - internal
ProductionDate schmst_proddt datetime- - Production date
Reruns2 schmst_reruns2 int - - internal
ScheduledGroups schmst_schgroups int - - internal
ScheduledJobs2 schmst_schjobs2 int - - internal
Security Table
Data Model

Table Summary
Logical Name Security
Database Tablesecmst
Added In -
Removed In -
Description Security policy records.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Cat20 secmst_cat20 int - - Bit mask of functions for CATEGORY_20
Cat21 secmst_cat21 int - - Bit mask of functions for CATEGORY_21
Cat28 secmst_cat28 int 5.2.1 - Reserved for future use
CatActions secmst_cat13 int - - Bit mask of functions for CATEGORY_ACTIONS
CatAgentLists secmst_cat16 int - - Bit mask of functions for CATEGORY_AGENTLISTS
CatAlerts secmst_cat19 int - - Bit mask of functions for CATEGORY_ALERTS
CatBusinessUnit secmst_cat26 int 5.2.1 - Bit mask of functions for CATEGORY_BUSINESSUNIT
CatCalendars secmst_cat11 int - - Bit mask of functions for CATEGORY_CALENDARS =
11
CatClasses secmst_cat4 int - - Bit mask of functions for CATEGORY_CLASSES
CatConfig secmst_cat5 int - - Bit mask of functions for CATEGORY_CONFIG
CatConsole secmst_cat6 int - - Bit mask of functions for CATEGORY_CONSOLE
CatCustomResources secmst_cat27 int 5.2.1 - Bit mask of functions for
CATEGORY_CUSTOMRESOURCES
CatFaultMonitor secmst_cat22 int - - Bit mask of functions for CATEGORY_FAULTMON
CatFileEvents secmst_cat25 int - - Bit mask of functions for CATEGORY_DIREVENTS
CatGeneral secmst_cat1 int - - Bit mask of functions for CATEGORY_GENERAL
Name ValueDescription
SECURITY_ADD 1 Generic
SECURITY_EDIT 2 Generic
SECURITY_DELETE 3 Generic
SECURITY_VIEW 4 Generic
SECURITY_ADDPUBLIC 11 internal
SECURITY_VIEWLOGS 12 internal
SECURITY_REPORTS 13 internal
SECURITY_VIEWHISTORY 14 internal
SECURITY_VIEWSTATUS 15 internal
SECURITY_PERSONAL_DATA 11 Users
SECURITY_ASSIGN_POLICY 12 Users
SECURITY_RUNTIME_USER 13 Users
SECURITY_IMPERSONATE 14 Users
SECURITY_ASSIGN_AGENTS 15 Users
SECURITY_LANGCONFIG 16 Users
SECURITY_ASSIGN_EVENT 11 Jobs
SECURITY_ENABLE 12 Jobs
SECURITY_VIEW_ALL 15 Job COnsole
SECURITY_VIEW_OWN 5 Job COnsole
SECURITY_EDIT_ALL 16 Job COnsole
SECURITY_EDIT_OWN 17 Job COnsole
SECURITY_CONTROL_ALL 18 Job COnsole
SECURITY_CONTROL_OWN 19 Job COnsole
SECURITY_ACK_ALERT 11 Alerts
SECURITY_CLOSE_ALERT 12 Alerts
SECURITY_JOB_CANCEL 11 Job Controls
SECURITY_JOB_HOLD 12 Job Controls
SECURITY_JOB_OVERRIDE 13 Job Controls
 SECURITY_JOB_RELEASE 14 Job Controls
SECURITY_JOB_RERUN 15 Job Controls
SECURITY_JOB_SET_STATUS 16 Job Controls
SECURITY_SYSTEM_QUEUE 11 Queues
SECURITY_NICE_VALUE 12 Queues
SECURITY_CONNECTIONS 11 Nodes
SECURITY_NODE_LIMITS 12 Nodes
SECURITY_CREATE_SCHEDULE 11 Schedule
SECURITY_PAUSE_SCHEDULE 12 Schedule
SECURITY_REFRESH_SCHEDULE 13 Schedule
SECURITY_CONTROL_FAULTMON11 Fault
Monitor
SECURITY_VIEW_FAULTMON 12 Fault
Monitor
SECURITY_API 16
CatJobControl secmst_cat10 int - - Bit mask of functions for CATEGORY_JOBCONTROL
CatJobEvents secmst_cat12 int - - Bit mask of functions for CATEGORY_JOBEVENTS
CatJobs secmst_cat9 int - - Bit mask of functions for CATEGORY_JOBS
CatLicenses secmst_cat15 int - - Bit mask of functions for CATEGORY_LICENSES
CatQueues secmst_cat14 int - - Bit mask of functions for CATEGORY_QUEUES
CatResources secmst_cat23 int - - Bit mask of functions for CATEGORY_RESOURCES
CatSchedule secmst_cat17 int - - Bit mask of functions for CATEGORY_SCHEDULE
CatSecurity secmst_cat2 int - - Bit mask of functions for CATEGORY_SECURITY
CatSysEvents secmst_cat18 int - - Bit mask of functions for CATEGORY_SYSEVENTS
CatUsers secmst_cat3 int - - Bit mask of functions for CATEGORY_USERS
CatVarEvents secmst_cat24 int - - Bit mask of functions for CATEGORY_VAREVENTS
CatVariables secmst_cat8 int - - Bit mask of functions for CATEGORY_VARIABLES
CatWorkgroups secmst_cat7 int - - Bit mask of functions for CATEGORY_WORKGROUPS
Description secmst_desc string - - Description of security profile
ID secmst_id int - - Unique ID for security profile
LastChangeTime secmst_lstchgtm datetime- - Last modified timestamp
LastUserModifiedTimesecmst_usrmodtmdatetime6.0.0 - Last modified by a user
Name secmst_name string - - Security profile name
SecurityServiceJoin Table
Data Model

Table Summary
Logical Name SecurityServiceJoin
Database Tablesecmstservice
Added In -
Removed In -
Description Join Security policy records to services.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Category secmstservice_cat int - - Category
CustomBits secmstservice_customcatint - - Security Bits
for Custom
Adapter Bits,
which are
defined in
services.xml
ID secmstservice_id int - - Unique ID for
record
LastChangeTimesecmstservice_lstchgtm datetime6.0.0 - Last modified
timestamp
SecurityID secmst_id int - - ID for security
record
ServiceID servicemst_id int - - ID for service
record
Service Table
Data Model

Table Summary
Logical Name Service
Database Tableservicemst
Added In -
Removed In -
Description Contains services data

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Config servicemst_config clob - - The
configuration
of the service
in xml format
- i.e. type,
version ...etc.
ExtInfo servicemst_extInfo clob - - The extended
information of
the service in
xml format
FullName servicemst_fullName string - - The full name
of the service
GUID servicemst_guid string - - The unique
global ID of
the service
ID servicemst_id int - - Primary Key
for this record
LastChangeTime servicemst_lstchgtm datetime6.0.0 - Last modified
timestamp
Name servicemst_name string - - The name of
the service
PrepJobOnWaitOpservicemst_prepWaitOpstring - - Flag which
specifies if
should send
prepare job
msg if job is
waiting for
operator
release
Type servicemst_type string - - The types of
service
processes
 supported by
the service.
ID'd by each
char in a
binary
manner
Version servicemst_version string - - The version
of the service

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
AlwaysLicensedWRAPPER_OBJECTjava.lang.String- - Flag Whether
this service is
always
licensed
ServiceDist Table
Data Model

Table Summary
Logical Name ServiceDist
Database Tableservicedist
Added In -
Removed In -
Description Holder of Service Jar file

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
ID servicedist_id int - - Unique ID for
servicedist record
LastChangeTimeservicedist_lstchgtmdatetime6.0.0 - Last modified
timestamp
Service_ID servicemst_id int - - Foreign key from
servicemst id table
Service_Pkg service_pkg clob - - Binary Blob field
for jar
ServiceRequest Table
Data Model

Table Summary
Logical Name ServiceRequest
Database TableIN-MEMORY
Added In -
Removed In -
Description Keeps track of a client service request.

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
AdapterHostID INMEMORY int - - ID of the
adapterhost
that hosts
the service
(available
only if
ServiceID is
zero)
AsyncResult WRAPPER_OBJECTcom.tidalsoft.framework.async.AsyncResult- - Async result.
ClientRequestIDINMEMORY int - - ID of the
request from
the client
RequestData WRAPPER_OBJECTjava.lang.String - - Data of the
request
RequestID INMEMORY int - - ID of the
request
ServiceGUID WRAPPER_OBJECTjava.lang.String - - GUID of the
service that
handles the
request
(available
only if
ServiceID is
zero)
ServiceID INMEMORY int - - ID of the
service that
handles the
request
Statistics Table
Data Model

Table Summary
Logical Name Statistics
Database TableStatistics
Added In -
Removed In -
Description Inmemory table to store statistics information.

In-Memory Columns
Logical Name Database FieldTypeAdded InRemoved InDescription
ID INMEMORY int - - ID of statistics
object
JobsTogo INMEMORY int - - The number of
jobs that are
waiting and still
eligible to run.
JobsTotal INMEMORY int - - The total jobs to
be run.
JobsWait INMEMORY int - - The number of
jobs that are
waiting and still
eligible to run.
NumAdhocJobs INMEMORY int - - Number of adhoc
jobs.
NumCarryOverJobs INMEMORY int - - Number of carry
over jobs.
NumCarryOverToGoJobsINMEMORY int - - Number of carry
over and ready to
go jobs.
NumJobsCancelled INMEMORY int - - Number of jobs
that are
cancelled.
NumJobsDone INMEMORY int - - Number of jobs
that are done.
NumRerunJobs INMEMORY int - - Number of rerun
jobs.
NumScheduledJobs INMEMORY int - - Number of
scheduled jobs.
StringMaster Table
Data Model

Table Summary
Logical Name StringMaster
Database Tablestrmst
Added In -
Removed In -
Catalog of strings used throughout sysADMIRAL (excluding log
Description
messages) - will be obsolete in a future release.

Database Columns
Logical NameDatabase FieldTypeAdded InRemoved InDescription
Description strmst_desc string- - Resource string (by
language)
ID strmst_id short - - Unique ID for string
Language_ID lngmst_id int - - Unique ID for language
Type strmst_type short - - Type of string (category)
SystemValue Table
Data Model

Table Summary
Logical Name SystemValue
Database Tablesysval
Added In -
Removed In -
Description System configuration values including demo/emergency license codes.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
ID sysval_id int - - Unique ID for system configuration value:
Name ValueDescription
SYSVAL_POLL_INTERVAL 1 internal
SYSVAL_MAIL_TYPE 2 internal
SYSVAL_MAIL_USER 3 internal
SYSVAL_LOG_LANGUAGE 4 internal
SYSVAL_AUDIT_ON 5 internal
SYSVAL_AUDIT_FLAGS 6 internal
SYSVAL_DIAG_ON 7 internal
SYSVAL_DIAG_FLAGS 8 internal
SYSVAL_AUDIT_RETAIN 9 internal
SYSVAL_ERROR_RETAIN 10 internal
SYSVAL_DIAG_RETAIN 11 internal
SYSVAL_PURGE_FREQUENCY 12 how often, in days, to
purge the system
SYSVAL_PURGE_DATE 13 the last time we purged
the system
SYSVAL_COMPILE_OUTLOOK 14 number of days in the
future to compile
SYSVAL_CLIENT_PORT 15 No longer used
SYSVAL_COMPANY_NAME 16 internal
SYSVAL_ALERT_RETAIN 17 internal
SYSVAL_MAIL_PASSWORD 18 internal
SYSVAL_MAIL_ADDRESS 19 internal
SYSVAL_CALENDAR_DATE 20 internal
SYSVAL_FAULT_TOLERANCE 21 internal
SYSVAL_BACKUP_TIME 22 internal
SYSVAL_DEFAULT_JOBPRI 23 internal
SYSVAL_DEFAULT_JOBCONCUR 24 internal
SYSVAL_DEFAULT_JOBHIST 25 internal
SYSVAL_DEFAULT_UNSCHED 26 internal
SYSVAL_DEFAULT_PUBLIC 27 internal
SYSVAL_DEFAULT_AGENT 28 internal
SYSVAL_EMERGENCY_CODE1 29 internal
SYSVAL_EMERGENCY_CODE2 30 internal
SYSVAL_STATUS_ORDER1 31 internal
SYSVAL_STATUS_ORDER3 33 internal
SYSVAL_DEFAULT_OUTPUT 34 internal
SYSVAL_MASTER_LAST_START 35 the last time the master
started (TDateTime)
beginning of day -offset
in hours from midnight
SYSVAL_BOD_OFFSET 36
(string e.g. 2.25 = 02:15
AM)
compile offset from
SYSVAL_COMPILE_OFFSET 37 midnight in hours (string
eg. 2.25 = 02:15 AM)
SYSVAL_WEEK_BEGINS 38 internal
SYSVAL_USE_NT_PASSWORDS 39 internal
SYSVAL_CALENDAR_FRCSTDATE 40 internal
SYSVAL_SCHEDULE_CARRYOVER 41 internal
SYSVAL_AGENT_TIMEZONE 42 Y - Relative to Agent N -
Relative to (Default is N)
SYSVAL_ITO_INSTALLED 43 internal
SYSVAL_SAP_UNRELEASED 44 internal
SYSVAL_SAP_DEFAULT_AGENT 45 internal
SYSVAL_SAP_AUDIT 46 internal
SYSVAL_SAP_LAUNCH 47 internal
SYSVAL_WMI_INSTALLED 48 internal
SYSVAL_ALARMPT_INSTALLED 49 internal
SYSVAL_MANAGEX_METHOD 50 internal
SYSVAL_SYNCH_DB 51 internal
SYSVAL_PS_DEFAULT_AGENT 52 internal
SYSVAL_USE_AS_PASSWORDS 53 internal
SYSVAL_PS_DEFAULT_OUTPATH 54 internal
SYSVAL_SAP_COPY 55 internal
SYSVAL_MAIL_DELIMITER 56 internal
SYSVAL_NETIQ_METHOD 57 internal
SYSVAL_MANAGEX_INSTALLED 58 internal
SYSVAL_NETIQ_INSTALLED 59 internal
SYSVAL_FTP_USER 60 internal
SYSVAL_FTP_PASSWORD 61 internal
SYSVAL_INTERNAL_PASSWORD 62 internal
SYSVAL_DATABASE_VERSION 63 internal
SYSVAL_SAP_VALIDATION 64 internal
SYSVAL_FT_REPLICATION 65 internal
SYSVAL_ZKENV_OK 66 internal
SYSVAL_ORA_DEFAULT_AGENT 67 internal
SYSVAL_ORA_LAUNCH 68 internal
SYSVAL_ORA_TIMEOUT 69 internal
SYSVAL_CARRYOVER_DAYS 70 internal
SYSVAL_ORAENV_OK 71 internal
SYSVAL_SAP_SYS_LAUNCH 72 internal
SYSVAL_SAPENV_OK 73 internal
SYSVAL_ZOSENV_OK 74 internal
SYSVAL_IRCENV_OK 75 internal
SYSVAL_DEFAULT_SUMMARY 76 internal
SYSVAL_SAP_POLLINTERVAL 77 internal
0 means to hold jobs for
new day until carryover
SYSVAL_CARRYOVER_HOLD 78 jobs from previous day
complete; 1 means to
run them together.
SYSVAL_DEFAULT_CARRYOVER 79 0 is Yes, 1 is No
SYSVAL_TRANSPORTER_FLAGS 80 For transporter
SYSVAL_DEFAULT_SAP_CLASS 81 Default of SapClass in
Queue
Y or N (Default is N) use
SYSVAL_CONSOLIDATOR_OK 82 consolidator for agents.
Show option in client.
SYSVAL_OLD_PERT_VIEW 83 Use old pert view in
client?
SYSVAL_CURRENT_PRODDATE 84 Current product date.
Used in carrover options.
SYSVAL_PS_BYPASS_LOGON 85
SYSVAL_PS_KERBEROS 86
SYSVAL_KERBEROS_PREFIX 87
SYSVAL_ORA_DEFAULT_PRI 88
Number of days before a
SYSVAL_TRIGGERACTIONRUN_EXPIRATION 89 TriggerActionRun
expires.
The number of seconds
to wait for a connection
SYSVAL_LOSTCONNECTION_WAIT_SYSEVENT 90 recovery before sending
a lost connection system
event.
Use the unix users profile
SYSVAL_DEFAULT_SRC_PROFILE 91
for default job definition.
Whether the FTP runtime
SYSVAL_FTP_LOCALUSER 92
user is Required
Set to Y to rerun on
SYSVAL_C_NORMAL_RERUN 93
completed normally only.
Default method of
SYSVAL_DEFAULT_JOB_EST_METHOD 94 estimating the start time
for a job
Default course of action
SYSVAL_DEFAULT_JOB_NEAR_OUTAGE 95 for a job to take if it is
likely to run into an
agent outage window
Maximum size (in
characters) for an email
SYSVAL_MAX_EMAIL_BODY_SIZE 96
body when the email is
sent from the master.
SYSVAL_JOB_CONFIRM_DISABLE 97
Bit mask of statuses to
SYSVAL_JOB_EST_DUR_EXCLUDE 98 exclude when calculating
Estimated Duration
A flag that indicates if
 the master was paused
SYSVAL_MASTER_PAUSED_BY_CLIENT 99
by a client (Y) or
something else (N)
A flag that indicates if
SYSVAL_QUEUES_PAUSED 100 the queues are paused, Y
or N
Set this to allow the
SYSVAL_SHOW_TRIGGERING_AGENT_JOB_ACTION_OPTION 101 client to select the agent
that triggered the job
action.
Option to set the trim
SYSVAL_TRIM_VARIABLES 102 options for variable
values.
Option to set whether to
carry over jobs that
SYSVAL_CARRYOVER_DEPRERUN_JOBS 103 rerun each time deps are
met if they don't have a
set end time.
Obsolete -- Option to see
whether trgtsk records
SYSVAL_REORDER_TRGTSK 104
should be reordered for
cache performance
Option to control the
SYSVAL_EMAIL_TIMEOUT 105 timeout on the email
server socket connection
SYSVAL_REMOVE_BROWSE 106
Send msg_text with
SYSVAL_OPENVIEW_SEND_MSG_QUOTED 107 quotes (Y) or without
quotes (N).
If there is no job output
and we are scanning for
abnormal text, set the
SYSVAL_SCAN_ABNORMAL_NO_OUPUT_COMPLETES_NORMALLY 108
job to Completed
Normally (Y) or
Externally Defined (N).

Option specify final state

for jobs has not run at
the end of the production
day and is not allowed to
carry-over to the next
production date. (Y) to
SYSVAL_UNRUNJOBS_FINALSTATE 109
specify the final state or
(N) to do nothing. Less
than or equal 0 is
skipped state where as
any other digit is the
final state.

Use this value to control

the expiration/purge of
temporary user account
SYSVAL_TEMPUSER_RETAIN 110
which create during
logon the Client
Manager.
Send application name
SYSVAL_OPENVIEW_SEND_APP_QUOTED 111 with quotes (Y) or
without quotes (N).
 Recompile calendars
when the number of
days since the last
SYSVAL_RECOMPILE_CALENDARS_AFTER_DAYS 112 calendar compile reaches
this number. Set to -1 to
disable automatic
calendar recompile.
Override rerun when
SYSVAL_OVERRIDE_RERUN_TIME_DEPENDENCY_MET 113 time dependency is met
for disabled job. Default
is (N) and override (Y).

When selecting an agent

from an ordered agent
list, set to (N) to ignore
the agent job limit when
selecting an agent.
SYSVAL_ORDERED_AGENTLIST_CHECK_AGENT_JOB_LIMIT 114
Default is (Y) which
means if the agent has
reached its job limit,
check the next agent in
the ordered list.

When doing production

day rollover and deferred
concurrent jobs are
SYSVAL_CARRYOVER_ALL_CONCURRENT_LOGIC_JOBS 115 carried over, also carry
over other job instances
involved in the
concurrency logic.
The master stores a
generated revision index
SYSVAL_DATA_CACHE_REVISION_INDEX 116 here, used when
updating the client
manager data cache.

Allow user to control

domain name query
string during login
authentication process. 1
- Use Windows login
domain name only.
(default) 2 - Use the last
AD internal domain
SYSVAL_DOMAIN_NAME_ACCESS_CONTROL 117
name. 3 - First query
Windows login domain,
then query AD internal
domain name.4 - First
query AD internal domain
name, then query
Windows login domain
name.

Default interval for

SYSVAL_PUBLISHED_SYSTEM_RESOURCE_REFRESH_RATE 118 agents to send published
system resource values.
Set to (Y) to enforce the
"allow unscheduled"
option on the master for
all clients (including
SYSVAL_ENFORCE_ALLOW_ADHOC_FOR_ALL_CLIENTS 119
 command line and API).
Default is (N) which will
leave enforcement up to
saClient.

Set to (Y) to enforce the

"allow unscheduled"
option on the master for
any job action that
SYSVAL_ENFORCE_ALLOW_ADHOC_FOR_JOB_ACTIONS 120
attempts to insert the
job. Default is (N) which
will not enforce the
option for job actions.

Set sysval_integer to the

maximum number of
seconds the system time
is allowed to shift
forward or backward. If
SYSVAL_QUANTUM_LEAP 121
the master detects a
time shift greater than
this, then the master is
paused and an alert is
raised.

Set to (Y) to stop the

current user from being
added to the job runtime
SYSVAL_DISABLE_CURRENTUSER_AS_RUNTIMEUSER 122
user list when the job
owner is an LDAP group
or a workgroup.
The number of seconds
to wait after the end of a
susped outage for the
connection to be
restored before sending
SYSVAL_END_SUSPEND_OUTAGE_LOSTCONNECTION_WAIT_SYSEVENT123 a lost connection system
event. Set sysval_string
to "N" to disable lost
connection events in this
case.
Set sysval_integer to the
number of seconds to
wait between
SYSVAL_STATUS_SENDING_INTERVAL 124
broadcasting master
status updates to clients.
Default is 3 seconds.
Set sysval_integer to the
number of seconds to
wait between
SYSVAL_JOBSTATS_SENDING_INTERVAL 125
broadcasting jobstat
updates to clients.
Default is 1 second.

Factor by which to
reduce the frequency of
messages sent to clients
from the time the master
starts up. For example, 2
SYSVAL_STARTUP_MSG_REDUCTION_FACTOR 126
means wait 2 * interval,
5 means wait 5 *
 interval. Default is 1,
meaning no reduction
factor is in effect.

The amount of time in

minutes starting from
master startup to keep
the message reduction
SYSVAL_STARTUP_MSG_REDUCTION_TIME
127 factor in effect before
returning to the normal
intervals. Default is 0,
meaning the reduction
factor is not used.

SYSVAL_KEEP_ORPHANED_JOBS_IN_ASSIGNED_QUEUE Whether to keep

orphaned jobs in queue.
128
Value can be "Y" or "N".
Default value is "N".

Set sysval_string to "Y"

to prevent the master
from initially sending
status messages for all
jobruns to newly
connected clients. When
set to "N" (the default
SYSVAL_SKIP_NEW_CLIENT_JOB_UPDATES 129
value) the master will
initially send status
updates for all jobruns as
before.
Note: This sysval is
obsolete in TES 6.0+
releases.

When sysval_string is set

to "Y", all jobs and
groups created by a copy
operation are disabled.
SYSVAL_DISABLE_JOBS_CREATED_BY_COPY 130 If set to "N" (default),
the jobs created by copy
retain the enabled status
of the original job.

Set sysval_integer to the

number of records to
retain when the cache
only tables
SYSVAL_CACHE_MSG_RETAIN_SIZE 131 (SystemActivityMessage,
FMLog, UserMessage)
are purged every 4 hours
in the CM. Default is
400.
Set sysval_string to "Y"
to always allow to carry
over these jobs with
status -
Active/Launched/Stopped
SYSVAL_ALWAYS_CARRYOVER_ACTIVE_JOBS_TO_PRODUCTION_DATE 132 without limited by
expiration date or carry
over days setting. When
set to "N", the jobs will
 be limited by the
conditions.

Set sysval_string to "Y"

(the default value) to
allow the workgroup to
SYSVAL_ALLOW_MEMBER_WORKGROUP_RUNTIME_USER 133 assign additional runtime
user. When set to "N",
no additional workgroup
runtime user included.

Set sysval_string to "Y"

to allow the client to
filter the LOVs with the
SYSVAL_CLIENT_LOV_FILTER_IN 134 "in" clause. When set to
"N" (the default value),
the LOVs are filtered with
the "begins with" clause.

Set sysval_string to "Y"

to override 'Do not time
out' if not ready by end
of production day and
SYSVAL_OVERRIDE_NOT_TIMEOUT_BY_END_PRODUCTION_DAY 135 will set job status to
'Timeout'. When set to
"N" (the default value), it
will maintain the
corresponding status.

Set sysval_string to "Y"

to disable the rerun
context menu command
from the UI for any job
SYSVAL_DISABLE_RERUN_FOR_ABORTED_STATUS 136 in 'Aborted' status.
  When set to "N" (the
default value), it will
keep 'Rerun' context
menu command.

History purge offset from

SYSVAL_PURGE_OFFSET 137 production day start in
minutes in
sysval_integer.
Set sysval_string to Y to
SYSVAL_CAL_531_COMPATIBILE 150 retain 5.3.1. calendar
logic.
Set sysval_string to Y to
allow child job to run
SYSVAL_PARENT_CANCELLED_STATUS 151
even if parent is in
cancelled status
Set sysval_string to Y to
adjust run day if job is in
TIMEZONE_RUNDAY_ADJUST 152
different time zone
ahead of the master.
Set sysval_string to Y to
have adhoc and
SYSVAL_ADHOC_BROADCAST_ENHANCEMENT 153
broadcast enhancement
futures.
Set sysval_string to Y to
SYSVAL_BROADCAST_JOBCOMPILE 154 have adhoc and
 broadcast enhancement
futures.
Set sysval_string to Y to
SYSVAL_JOB_CLASS 155 allow null values for
string variables.
Set sysval_string to Y to
SYSVAL_RE_UPGRADE_BV 156 change jobclass of child
jobs if jobclass of parent
is changed.
Set sysval_string to Y to
re-upgrade BV and
intended for the
SYSVAL_SKIPPEDJOB_ENHANCEMENT 157
customers who already
upgraded from 5.3.1 to
6.2.1.
Set sysval_string to Y to
SYSVAL_LAUNCH_STUCK_ENHANCEMENT 158 skip the job at the time
of production rollover.
Set minutes to trigger
SYSVAL_STRING_VARIABLE_NULL_SETTING 159 the event if job in launch
status longer than
expected.
Used by SCOM MP to
SYSVAL_SCOM_001 10001 track last-read row in
msglog table.
Used by SCOM MP to
SYSVAL_SCOM_002 10002 track last-read row in
alrtmst table.

SYSVAL_SCOM_003 10003 Reserved for SCOM

Adapter for TES.
SYSVAL_SCOM_004 10004 Reserved for SCOM
Adapter for TES.
Reserved for SCOM
SYSVAL_SCOM_005 10005
Adapter for TES.
Reserved for SCOM
SYSVAL_SCOM_006 10006
Adapter for TES.
Reserved for SCOM
SYSVAL_SCOM_007 10007
Adapter for TES.
SYSVAL_SCOM_008 10008 Reserved for SCOM
Adapter for TES.
SYSVAL_SCOM_009 10009 Reserved for SCOM
Adapter for TES.
SYSVAL_SCOM_010 10010 Reserved for SCOM
Adapter for TES.
Position of diag value for
UXSOURCE_SCHEDULER 0 Scheduler (see
SYSVAL_DIAG_FLAGS)
Position of diag value for
UXSOURCE_CLIENTMGR 1 Client Manager (see
SYSVAL_DIAG_FLAGS)
Position of diag value for
UXSOURCE_AGTMGR 2 Agent Manager (see
SYSVAL_DIAG_FLAGS)
Position of diag value for
UXSOURCE_COMPILER 3 Compiler (see
 SYSVAL_DIAG_FLAGS)
Position of diag value for
UXSOURCE_JOBMGR 4 Job Manager (see
SYSVAL_DIAG_FLAGS)
Position of diag value for
Event (Action/Trigger)
UXSOURCE_EVENTMGR 5
Manager (see
SYSVAL_DIAG_FLAGS)
Position of diag value for
UXSOURCE_QUEUEMGR 6 Queues (see
SYSVAL_DIAG_FLAGS)
Position of diag value for
UXSOURCE_DB 7 Database (see
SYSVAL_DIAG_FLAGS)
Position of diag value for
UXSOURCE_COMM 8 Communications (see
SYSVAL_DIAG_FLAGS)
Log level of NONE (see
LOG_LEVEL_NONE 0
SYSVAL_DIAG_FLAGS)
Log level of SEVERE (see
LOG_LEVEL_SEVERE 1
SYSVAL_DIAG_FLAGS)
Log level of WARNING
LOG_LEVEL_WARNING 2 (see
SYSVAL_DIAG_FLAGS)
Log level of INFO (see
LOG_LEVEL_INFO 3
SYSVAL_DIAG_FLAGS)
LOG_LEVEL_FINE 4 Log level of FINE (see
SYSVAL_DIAG_FLAGS)
LOG_LEVEL_FINER 5 Log level of FINER (see
SYSVAL_DIAG_FLAGS)
LOG_LEVEL_FINEST 6 Log level of FINEST (see
SYSVAL_DIAG_FLAGS)
Integer sysval_integer int - - Integer system configuration value
LastChangeTimesysval_lstchgtm datetime6.0.0 - Last modified timestamp
LongString sysval_longstr clob 6.0.0 - Long String system configuration value
String sysval_string string - - String system configuration value
Time sysval_time datetime- - Date/time system configuration value
TableCounts Table
Data Model

Table Summary
Logical Name TableCounts
Database Tabletblcnt
Added In -
Removed In -
Table of last unique ID used for tables with primary keys that are
Description
generated sequentially.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
ID tblcnt_id int - - Unique ID for table
LastChangeTimetblcnt_lstchgdt datetime- - Last modified
timestamp
LastID tblcnt_lstid int - - Last sequential unique
ID used for table
TableName tblcnt_tblname string - - Name of sysADMIRAL
database table
TaskService Table
Data Model

Table Summary
Logical Name TaskService
Database Tabletskservice
Added In -
Removed In -
Description Specifies a task (event) service available on a host

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
ID tskservice_id int - - Unique ID for this
record
Info tskservice_info text - - XML data about the
service
LastChangeTimetskservice_lstchgtmdatetime6.0.0 - Last modified
timestamp.
Trigger Table
Data Model

Table Summary
Logical Name Trigger
Database Tabletrgmst
Added In -
Removed In -
Description System and job event definitions.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Active trgmst_active string- - Flag indicating whether system or job event is enabled
AllJobs trgmst_alljobs string- - Indicates whether job event applies to all jobs (across system)
Description trgmst_desc string- - Description of event
ID trgmst_id int - - Unique ID for job or system event
Info trgmst_info string- - Configuration data for this trigger
Jobctl trgmst_jobctl short - - Job control action associated with job event:
Name Value Description
JOB_CTL_CANCEL 1 internal
JOB_CTL_HOLD 2 internal
JOB_CTL_OVERRIDE 3 internal
JOB_CTL_RELEASE 4 internal
JOB_CTL_RERUN 5 internal
JOB_CTL_SET_ABNORMAL 6 internal
JOB_CTL_SET_NORMAL 7 internal
JOB_CTL_SET_ERROR 8 internal
JOB_CTL_SET_EXTERNAL 9 internal
JOB_CTL_SET_ORPHANED 10 internal
JOB_CTL_SET_SKIPPED 11 internal
JOB_CTL_SET_CANCEL_PENDING 12 internal
JOB_CTL_SET_WAITOP 13 internal
JOB_CTL_SET_CANCEL_WAITOP 14 internal
LastChangeTime trgmst_lstchgtm datetime- - Last modified timestamp
LastUserModifiedTimetrgmst_usrmodtm datetime6.0.0 - Last modified by a user
MaxReruns trgmst_maxreruns int - - internal
Monitor trgmst_monitor int - - Status indicating whether this trigger is monitoring
Name ValueDescription
EVENT_STATUS_SCHEDULED 1 internal
EVENT_STATUS_SUSPENDED 2 internal
EVENT_STATUS_OUTSIDE_TIMEWIN 3 internal
EVENT_STATUS_NOTSCHEDULED 4 internal
EVENT_STATUS_NOTSCHEDULED_SUSPENDED5 internal
Name trgmst_name string - - Name of job or system event
Node_ID nodmst_id int - - Node associated with this trigger
Owner_ID owner_id int - - Unique ID for owners (users and workgroups)
Params trgmst_parm string - - internal
Public trgmst_public string - - Flag indicating whether any user can associate jobs with event
(Y/N)
Service_ID servicemst_id int - - Service associated with this trigger
Trigger trgmst_trigger short - - Trigger for the event:
Name ValueDescription
TRIG_COMPLETE 1 Job completed
Job completed
TRIG_ABNORMAL 2
abnormally
TRIG_NORMAL 3 Job completed
normally
Job added to schedule
TRIG_ONDEMAND 4
on demand
Job ready but waiting
TRIG_WAITOP 5
for operator
TRIG_HOLD 6 Waiting job was put on
hold
TRIG_READY 7 Job is ready to run
Job not ready by time
TRIG_TIMEOUT 8
window
TRIG_LAUNCH 9 Job has been launched
TRIG_ACTIVE 10 Job is active
TRIG_STOP 11 Active job has been
stopped
TRIG_ERROR 12 Job ended in ERROR
TRIG_SKIPPED 13 Job has been skipped
TRIG_DEFERRED 14 Job has been deferred
TRIG_AGENTUNAVAIL 15 Agent for job was
unavailable
TRIG_AGENTINACTIVE 16 Agent for job was
inactive
TRIG_STATUS 17 Job status changed
TRIG_MAYBE_LATE 18 Job might start later
than expected
Job might not be ready
TRIG_MAYBE_LATE_WDW 20 by end of its time
window
TRIG_LONG 21 Job ran longer than
expected
Job hit end of its time
TRIG_ACTIVE_WDW 22
window
Job might hit end of its
TRIG_MAYBE_ACTIVE_WDW 23
time window
TRIG_DEPENDENCY 24 Job's dependency no
longer satisfied
Job finished later than
TRIG_LATE_FINISH 25
expected
TRIG_EXCEED_MAX 26 Job ran longer than
maximum time
Job ran shorter than
TRIG_BELOW_MIN 27
minimum time
TRIG_RERUN 28 Operator reran the job
Operator cancelled the
TRIG_CANCEL 29
job
TRIG_ABORT 30 Operator aborted the
job
Operator override of
TRIG_OVERRIDE 31
job dependencies
The status of the job is
TRIG_LAUNCH_ON_STARTUP 32
LAUNCH on master
Job added to schedule
TRIG_SCHEDULED 33
by regular compile
Job has been
TRIG_ORPHANED 34
orphaned
Job would exceed max
TRIG_EXCEED_MAXRUNS 35
reruns
Job completed with a
TRIG_COMPLETE_WITH_EXIT_CODE36 specific exit code; code
range stored in Params
Job completed
TRIG_NORMAL_OUTPUT 37 normally, but is
expecting output
Job completed
TRIG_ABNORMAL_OUTPUT 38 abnormally, but is
expecting output
Job externally defined,
TRIG_EXTERN_OUTPUT 39
but is expecting output
Job has insufficient
TRIG_LAUNCH_NEAR_OUTAGE 40 time to run before
agent outage
TRIG_EST_NEAR_OUTAGE 41 Job might run into
outage window
TRIG_EXTERN 42 Job externally defined
Job start time is here,
TRIG_NONTIME_DEPS_REMAIN 43 but other
dependencies are not
satisified
TRIG_SYS_SYSQUEUE_ZERO 1 internal
TRIG_SYS_ANYQUEUE_ZERO 2 internal
TRIG_SYS_SYSQUEUE_AT_LIMIT 3 internal
TRIG_SYS_ANYQUEUE_AT_LIMIT 4 internal
TRIG_SYS_AGENT_AT_LIMIT 5 internal
TRIG_SYS_COMPILE_START 6 internal
TRIG_SYS_COMPILE_DONE 7 internal
TRIG_SYS_MASTER_PAUSED 8 internal
TRIG_SYS_MASTER_RESUMED 9 internal
TRIG_SYS_AGENT_DOWN 10 internal
TRIG_SYS_MASTER_DOWN 11 internal
TRIG_SYS_BACKUP_STARTED 12 internal
TRIG_SYS_MASTER_STARTED 13 internal
TRIG_SYS_NEW_DAY 14 internal
Lost connection to
 TRIG_SYS_LOST_FAULT_MONITOR 15
Fault Monitor
TRIG_SYS_LOST_BACKUP_MASTER 16 Lost connection to
Backup Master
TRIG_SYS_LOST_DATABASE 17 Lost connection to
Database
Lost connection to
TRIG_SYS_LOST_REMOTE_MASTER 18
Remote Master
TRIG_SYS_AGENT_OUTAGE_BEGIN 20 Agent has entered a
planned outage period
TRIG_SYS_AGENT_OUTAGE_END 21 Agent has exited a
planned outage period
TriggerActionCount trgmst_trgtskcnt int - - Number of times triggered
TriggerActionRunID trgmst_lasttrgtskrunint - - ID of last trigger run
Type trgmst_type short - - Whether job or system event:
Name Value Description
JOB 1 Job events
SYSTEM 2 System events
EVENT_TYPE_AGENT 3 Agent events
EVENT_TYPE_DIR 4 File events
EVENT_TYPE_VAR 5 Variable events
EVENT_TYPE_SERVICE 6 Service events

In-Memory Columns
Logical Name Database Field Type Added InRemoved InDescription
DelayedRuns WRAPPER_OBJECTjava.util.Collection- - Keeps track of any runs that are delayed
ExitCodeMax INMEMORY int - - internal
ExitCodeMin INMEMORY int - - internal
ExitCodeOperationINMEMORY int - - internal
MonitorContext WRAPPER_OBJECTObject - - Keeps track of any data associated with an
event monitoring
MonitorTimer WRAPPER_OBJECTjava.lang.Integer - - Keeps track of the timer used for
implementing time-windows for
monitoring
Monitor_Node_ID INMEMORY int - - Node which is Monitoring this trigger
TriggerAction Table
Data Model

Table Summary
Logical Name TriggerAction
Database Tabletrgtsk
Added In -
Removed In -
Description Associations between events and actions.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
Action_ID tskmst_id int - - Unique ID for action; links to table of appropriate
type
ID trgtsk_id int - - Unique ID for table
LastChangeTimetrgtsk_lstchgtm datetime6.0.0 - Last modified timestamp
Order trgtsk_order int - - Order of action within event
Trigger_ID trgmst_id int - - Unique ID for job or system event
Type trgtsk_type int - - Type of Event-Action
Name ValueDescription
TRGTSK_TYPE_USER_DEFINED0 internal
TRGTSK_TYPE_JOB_CONTROL 1 internal
TriggerActionRun Table
Data Model

Table Summary
Logical Name TriggerActionRun
Database Tabletrgtskrun
Added In -
Removed In -
Description Execute table for triggers and actions.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Action_ID tskmst_id int - - ID of the action associated with this run
CreateDate trgtskrun_crtdt datetime- - Date this run was created
Data trgtskrun_data string - - Generic data tied to this run.
Event_ID trgmst_id int - - ID of the event associated with this run
Expire trgtskrun_expire datetime- - Date this run should expire
ID trgtskrun_id int - - ID for this run
JobRun_ID jobrun_id int - - ID of the jobrun associated with this run
Job_ID jobmst_id int - - ID of the job associated with this run
LastChangeTimetrgtskrun_lstchgtm datetime6.0.0 - Last modified timestamp
NodeTarget nodmst_target int - - ID of the target node associated with this run
Node_ID nodmst_id int - - ID of the node associated with this run
Parent_ID trgtskrun_parent int - - Parent associated with this run
Payload trgtskrun_payload string - - Payload for this run
RunDate trgtskrun_rundt datetime- - Date this run was ran
ServiceTarget servicemst_target int - - ID of the target service associated with this run
Service_ID servicemst_id int - - ID of the service associated with this run
Status trgtskrun_status int - - Status of this run
Name ValueDescription
status - run
TRGTSKRUN_STATUS_PENDING 1
is pending
status - run
TRGTSKRUN_STATUS_FINISHED2
is finished
status - run
TRGTSKRUN_STATUS_SKIPPED 3
is skipped
Transaction trgtskrun_transactionint - - ID of the transaction this run belongs to
User_ID usrmst_id int - - ID of the user associated with this run
TriggerJobClassJoin Table
Data Model

Table Summary
Logical Name TriggerJobClassJoin
Database Tabletrgjobcls
Added In -
Removed In -
Description Associations between jobclasses and events.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
ID trgjobcls_id int - - ID for this record
JobClass_ID jobcls_id int - - ID for the jobclass
LastChangeTimetrgjobcls_lstchgtmdatetime6.0.0 - Last modified timestamp
Order trgjobcls_order int - - Order of the event within the jobclass
Trigger_ID trgmst_id int - - ID for the event
Type trgjobcls_type int - - Type of the event
Name ValueDescription
TRGJOBCLS_TYPE_BEFORE1 internal
TRGJOBCLS_TYPE_AFTER 2 internal
TriggerJobJoin Table
Data Model

Table Summary
Logical Name TriggerJobJoin
Database Tabletrgjob
Added In -
Removed In -
Description Associations between jobs and events.

Database Columns
Logical Name Database FieldType Added InRemoved InDescription
ID trgjob_id int - - Unique ID for table
Job_ID jobmst_id int - - Unique ID for job
LastChangeTimetrgjob_lstchgtm datetime6.0.0 - Last modified timestamp
Level trgjob_level int - - How deep this trigger will be inherited by the job's
descendents
Order trgjob_order int - - Order of event in job
Trigger_ID trgmst_id int - - Unique ID for job or system event
Type trgjob_type int - - Type of event
Name ValueDescription
TRGJOB_TYPE_JOB 0 internal
TRGJOB_TYPE_GROUP_BEFORE1 internal
TRGJOB_TYPE_GROUP_AFTER 2 internal
TriggerRun Table
Data Model

Table Summary
Logical Name TriggerRun
Database Tabletrgrun
Added In -
Removed In 5.2.1
Historical data for job instances that triggered events used for
Description
reporting.

Database Columns
Logical NameDatabase FieldType Added InRemoved InDescription
ID trgrun_id int - - Unique ID for table
JobRun_ID jobrun_id int - - Unique ID for this run
of job
Time trgrun_time datetime- - Time trigger was pulled
Trigger_ID trgmst_id int - - Unique ID for job or
system event
TriggerSchedule Table
Data Model

Table Summary
Logical Name TriggerSchedule
Database Tabletrgsch
Added In -
Removed In -
Description Relationship between a trigger and a schedule.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Calendar_ID evntmst_id int - -
Event_ID trgmst_id int - -
FromDate trgsch_fromdt datetime- -
ID trgsch_id int - -
IgnoreConstraints trgsch_ignoreconst string - -
IgnoreOccurrence trgsch_ignoreoccur string - -
IgnoreTimeWindowtrgsch_ignoretimewinstring - -
LastChangeTime trgsch_lstchgtm datetime6.0.0 - Last modified
timestamp
MaxRuns trgsch_maxruns int - -
MaxrunInterval trgsch_maxinterval int - -
Offset trgsch_offset int - -
TimeWindow trgsch_timewin string - -
UntilDate trgsch_untildt datetime- -
UpdateJobRecord Table
Data Model

Table Summary
Logical Name UpdateJobRecord
Database TableIN-MEMORY
Added In -
Removed In -
Description Psuedo object with information about a job run.

In-Memory Columns
Logical NameDatabase FieldType Added InRemoved InDescription
Duration INMEMORY int - - Duration of process in
seconds
EndTime INMEMORY datetime- - The time the job ended
ExitCode INMEMORY int - - Exit code from process
ExternalID INMEMORY int - - OS ID for this job
ID INMEMORY int - - Unique ID for record
Output INMEMORY string - - Output from the job
StartTime INMEMORY datetime- - The time the job
started
Status INMEMORY short - - Status of job
User Table
Data Model

Table Summary
Logical Name User
Database Tableusrmst
Added In -
Removed In -
Description User records corresponding to client and agent runtime users.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Description usrmst_desc string - - ser
Domain usrmst_domain string - - NT domain
for user
Email usrmst_email string - - User's email
address
EmailType usrmst_emailtype short - - Reserved for
future use
ExternalID usrmst_externid string - - External use
ID to link to
third-party
packages
Fullname usrmst_fullname string 5.2.2 - Full name of
user
ID usrmst_id int - - Unique ID
for user;
default
runtime user
when an
agent is
selected for
a job
KerberosKeytab usrmst_keytab string 6.1.0 - Fully
qualified
path to the
Kerberos
keytab file
for this user
on the
master host
KerberosPrincipal usrmst_principal string 6.1.0 - Kerberos
principal for
this user on
 the master
host
Language_ID lngmst_id int - - Unique ID
for language
LastChangeTime usrmst_lstchgtm datetime- - Last
modified
timestamp
LastUserModifiedTime usrmst_usrmodtm datetime6.0.0 - Last
modified by
a user
Name usrmst_name string 5.2.2 - Name of
user (login)
OracleAppsPassword usrmst_orapassword string - - Password for
the Oracle
Apps server
PagerNumber usrmst_pagerno string - - User's pager
number
Password usrmst_password string - - User's
encrypted
NT password
for
launching
jobs with
passwords
PeopleSoftAppServPasswordusrmst_aspassword string - 5.3.0 Password for
the
PeopleSoft
application
server
PeopleSoftPassword usrmst_pspassword string - 5.3.0 internal
PhoneNumber usrmst_phoneno string - - User's phone
number
Profile usrmst_profile clob 6.0.0 - Client profile
data for the
User
SapPassword usrmst_sappasswordstring - 5.1.3 User's SAP
password
(encrypted)
Security_ID secmst_id int - - Unique ID
for security
profile
SuperUser usrmst_suser string - - Superuser
flag
(Y/N/R/P)
TempAccount usrmst_tmpacct string 6.0.0 - Flag: Y if
this is a
temporary
user
account, N
or null if
normal user
WinGroup usrmst_wingroup string - - Flag: Y if
this is a
Windows
group, N if
normal user
In-Memory Columns
Logical NameDatabase Field Type Added InRemoved InDescription
ExtendedInfo WRAPPER_OBJECTExtendedInfo- - The
ExtendedInfo
record for this
Job
UserJoin Table
Data Model

Table Summary
Logical Name UserJoin
Database Tableusreqv
Added In -
Removed In -
Description Associations between users and runtime users.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
EquivalentUser_IDusrmst_equivalentint - - User ID of
equivalent users
ID usreqv_id int - - Unique ID for table
LastChangeTime usreqv_lstchgtm datetime6.0.0 - Last modified
timestamp
Node_ID nodmst_id int - - Unique ID for
connection
User_ID usrmst_id int - - Unique ID for
user; default
runtime user when
an agent is
selected for a job
UserMessage Table
Data Model

Table Summary
Logical Name UserMessage
Database TableIN-MEMORY
Added In -
Removed In -
Description Inmemory table used for routing user messages.

In-Memory Columns
Logical Name Database FieldType Added InRemoved InDescription
FromUserSessionINMEMORY int - - Session ID that is the
sender of the
message.
ID INMEMORY int - - Unique ID of this
UserMessage.
LastChangeTime INMEMORY datetime- - Last modified
timestamp
Message INMEMORY string - - The message
MsgTimestamp INMEMORY datetime- - Timestamp for
message
ReadByUser INMEMORY string - - Flag indicating if the
user has read the
message ("Y") or not
("N")
Timestamp INMEMORY string - - Timestamp for
message
ToUserSession INMEMORY int - - Session ID that is the
receiver of the
message.
Type INMEMORY short - - Type of message
UserService Table
Data Model

Table Summary
Logical Name UserService
Database Tableuserservice
Added In -
Removed In -
Description Specifies each user with a service

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
ID userservice_id int - - Unique ID for this
record
LastChangeTimeuserservice_lstchgtmdatetime6.0.0 - Last modified
timestamp
Password userservice_pwd string - - user encrypted
password for this
service
Service_ID servicemst_id int - - The foreign key to
the servicemst
table
User_ID usrmst_id int - - The foreign key to
the usrmst table
UserSession Table
Data Model

Table Summary
Logical Name UserSession
Database Tableusersession
Added In 6.0.0
Removed In -
Description User Session

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Computer usersession_computer string - - Name of the
client
computer for
the session
EndTime usersession_endtm datetime- - Timestamp
when the
session
ended, null if
session is still
active
ID usersession_id int - - Unique id of
this Session.
LastChangeTimeusersession_lstchgtm datetime- - Last modified
timestamp
SessionIDString usersession_sessionid_strstring - - Session ID
from UI or
Browser
StartTime usersession_starttm datetime- - Timestamp
when the
session
started
User_ID usrmst_id int - - User for this
usersession
XmlData usersession_data text - - Store
clientmanager
id when
session
created

In-Memory Columns
Logical Name Database FieldTypeAdded InRemoved InDescription
ImpersonateUser_IDINMEMORY int - - ID of user
impersonated during
client session
PortalUser_ID INMEMORY int - - ID of user New Scale
portal user during
client session
Variable Table
Data Model

Table Summary
Logical Name Variable
Database Tablevarmst
Added In -
Removed In -
Description Variable definitions and current values.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Calc varmst_calc string - - internal
Description varmst_desc string - - Description of variable
ID varmst_id int - - Unique ID for variable
InnerValue varmst_value string - - Current value of variable. This is
"InnerValue" because the query
"getValue" is the public way to access
the data.
LastChangeTime varmst_lstchgtm datetime- - Last modified timestamp
LastUserModifiedTimevarmst_usrmodtmdatetime6.0.0 - Last modified by a user
LastValue varmst_lstval string - - internal
Name varmst_name string - - Name of variable
Offsets varmst_offsets clob - - internal
Owner_ID owner_id int - - Unique ID for owners (users and
workgroups)
Public varmst_public string - - Flag indicating whether all users can
refer to variable (Y/N)
Publish varmst_publish string - - internal
Readonly varmst_readonly string - - internal
StartCalendar varmst_startcal int - - internal
StartDate varmst_startdt datetime- - internal
StartType varmst_starttype string - - internal
Type varmst_type short - - Type of variable:
Name ValueDescription
VARIABLE_STRING 1 Variable is a
string
VARIABLE_NUMBER2 Variable is
an integer
Variable is a
VARIABLE_DATE 3 date
(M/d/yyyy)
Variable is a
VARIABLE_BOOL 4
boolean
WorkGroup Table
Data Model

Table Summary
Logical Name WorkGroup
Database Tableworkgrp
Added In -
Removed In -
Description Workgroup definitions.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Description workgrp_desc string- - Description of
workgroup
ExternalID workgrp_externid string - - internal
ID workgrp_id int - - Unique ID for
workgroup
LastChangeTime workgrp_lstchgtm datetime- - Last modified
timestamp
LastUserModifiedTimeworkgrp_usrmodtmdatetime6.0.0 - Last modified
by a user
Name workgrp_name string - - Name of
workgroup
Owner workgrp_owner int - - User that
owns
workgroup
ParentID workgrp_prntid int - - Reserved for
future use
Profile workgrp_profile clob 6.0.0 - Client profile
data for the
Workgroup
WorkGroupUserJoin Table
Data Model

Table Summary
Logical Name WorkGroupUserJoin
Database Tableworkusr
Added In -
Removed In -
Description Associations between users and workgroups.

Database Columns
Logical Name Database Field Type Added InRemoved InDescription
Exclude workusr_exclude string - - Reserved for future
use
GroupSecurityIDsworkusr_winsecidstext 6.0.0 - XML format of list
of External
Windows
WorkGroup/LDAP
WorkGroup
Security Policy
records' id
ID workusr_id int - - Unique ID for table
LastChangeTime workusr_lstchgtm datetime6.0.0 - Last modified
timestamp
Owner_ID owner_id int - - Unique ID for
owners (users and
workgroups)
UserSecurityIDs workusr_secids text 6.0.0 - XML format of list
of Security Policy
records' id
WorkGroup_ID workgrp_id int - - Unique ID for
workgroup