Data Element Dictionary

This article contains the following topics:
casm171
This article contains the following topics:
Explains the definitions for the tables in the CA SDM database. The tables are found in schema (.sch) files. See the ddict.sch file in the $NX_ROOT/site directory (UNIX) or
installation
-
directory\
site directory (Windows) for the most current list of all database tables for your specific installation.
Although several of the tables in this section are obsolete, for backward compatibility, or reserved for future use, it is important that you not delete these -- or any other table -- from the database schema. You can add new tables and add new fields/columns to the existing tables, but never delete any of the tables. Many applications access the mdb database, so deleting or modifying existing fields or tables could cause some applications to not function properly. Ensure that you follow supported schema modification best practices by using the Web Screen Painter.
admin_tree Table
Program control table used by CA SDM applications.
  • SQL Name
    -- admin_tree
  • Object
    -- ADMIN_TREE
Field
Data Type
Reference
Remarks
caption
STRING 50
 
 
description
STRING 255
 
Specifies the textual description of this tree entry.
has_children
INTEGER
 
 
id
INTEGER KEY
 
Unique (to the table) Numeric ID
kt_admin
INTEGER
 
 
kt_ks_caption
STRING 50
 
 
kt_ks_flag
INTEGER
 
 
kt_manager
INTEGER
 
 
last_mod_dt
LOCAL_TIME
 
Indicates the timestamp of when this record was last modified.
parent_id
SREL
 
 
resource
STRING 255
 
 
sd_admin
INTEGER
 
 
 
Animator Table
Program control table used by CA SDM applications
  • SQL Name
    -- anima
  • Object
    -- ANI
Field
Data Type
Reference
Remarks
a_act
INTEGER
 
 
a_delta
INTEGER
 
 
a_lock
STRING 200
 
 
a_name
STRING 30 S_KEY
 
 
a_org
LOCAL_TIME
 
 
a_string
STRING 30
 
 
a_time
LOCAL_TIME
 
 
id
INTEGER KEY UNIQUE NOT_NULL
 
Unique (to the table) Numeric ID
t_method
STRING 30 S_KEY
 
 
t_persid
STRING 30 S_KEY
 
 
t_type
INTEGER
 
 
 
Atomic_Condition Table
These define a single condition.
  • SQL Name
    -- atomic_cond
  • Object
    -- atomic_cond
Field
Data Type
Reference
Remarks
cond_code
STRING 500
 
 
connecter
INTEGER NOT_NULL
 
 
del
INTEGER NOT_NULL
Active_Boolean_ Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
description
STRING 240
 
Specifies the textual description of this condition.
id
INTEGER UNIQUE NOT_NULL KEY
 
Unique (to the table) Numeric ID
l_paran
INTEGER NOT_NULL
 
 
last_mod_by
UUID
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
LOCAL_TIME
 
Indicates the timestamp of when this record was last modified
lval
STRING 30 NOT_NULL
Act_Type_Assoc ::code
 
operator
INTEGER NOT_NULL
 
 
owning_macro
STRING 30
Spell_Macro::persid
 
persid
STRING 30
 
Persistent ID (SystemObjectName:id)
r_paran
INTEGER NOT_NULL
 
 
rval
STRING 50
 
 
rval_assoc
STRING 30
Act_Type_Assoc ::code
 
sequence
INTEGER NOT_NULL
 
Ordering
 
Attribute_Name Table
Provides corresponding user name for an object attribute. Default population for the table should set at_name and at_dflt to the same thing. The user sees and is able to modify only the at_name. at_dflt is used to restore the default name. at_desc could be user changeable or not. It is of use for identifying the attribute for an as yet unplanned user maintenance application. at_sys should never be seen by the user, nor should at_obj.
  • SQL Name
    -- atn
Field
Data Type
Reference
Remarks
at_desc
STRING 240
 
Specifies the description of the attribute.
at_dflt
STRING 30
 
Specifies the default external name.
at_name
STRING 30
 
Specifies the user name for attribute.
at_obj
STRING 30 S_KEY
 
Specifies the system object name.
at_sys
STRING 30 S_KEY
 
Specifies the system name.
del
INTEGER NOT_NULL
 
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER UNIQUE NOT_NULL KEY
 
Unique (to the table) Numeric ID
 
Audit_Log Table
Contains all audit log entries.
  • SQL Name
    -- audit_log
  • Object
    -- audlog
Field
Data Type
Reference
Remarks
analyst
Byte 16
ca_contact::uuid
Specifies the user whose update generated this audit record.
Note:
This is a foreign key.
attr_after_val
nvarchar(160)
 
Specifies the new value of the object's attribute that has changed.
attr_before_val
nvarchar(160)
 
Indicates the previous value of the object's attribute that has changed.
attr_name
nvarchar(80)
 
This is the object's attribute that has changed.
aud_opr
INTEGER
 
Indicates the type of operation that generated this entry, such as, update, insert, and delete.
audobj_name
nvarchar(10)
 
Used for tracking the object that has changed.
audobj_persid
nvarchar(30)
 
Used for tracking the object that has changed.
audobj_trkid
nvarchar(40)
 
Used for tracking the object that has changed.
audobj_uniqueid
nvarchar(30)
 
Used for tracking the object that has changed.
change_date
INTEGER
 
The change date value for this Audit_Log.
id
INTEGER
 
Specifies the unique (to the table) numeric ID.
Note:
This is a primary key.
int1_rsrved
INTEGER
 
Reserved
int2_rsrved
INTEGER
 
Reserved
persid
nvarchar(30)
 
This is the Persistent ID (SystemObjectName:id).
str1_rsrved
nvarchar(25)
 
Reserved for future use by CA.
 
Behavior_Template Table
Each object includes a list of things to execute based on the state of the object. If no behavior is associated with the state transition then it simply controls whether the object can be transitioned to the state.
  • SQL Name
    -- bhvtpl
  • Object
    -- bhvtpl
Field
Data Type
Reference
Remarks
context_attrname
STRING 30
 
Specifies the attribute name, such as "state".
context_attrval
INTEGER
 
Specifies the attribute value.
context_type
STRING 30 NOT_NULL
 
Specifies information which determines whether the transition is valid for the consumercontext object.
Note:
For general use, the context_attrnamecontext_attrval pair was added. However, can't get the list of valid values very easily from the GUI so we've added an SREL to the object that context_attrnamecontext_attrval really represents. short name of object (eg. wf)
del
INTEGER NOT_NULL
Active_ Boolean_ Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
description
STRING 500
 
Specifies the textual description of this behavior template
id
INTEGER UNIQUE NOT_NULL KEY
 
Unique (to the table) Numeric ID
last_mod_by
UUID
ca_contact:: uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
LOCAL_TIME
 
Indicates the timestamp of when this record was last modified.
macro_condition
STRING 30
Spell_Macro ::persid
Specifies whether the macro executes.
object_id
INTEGER NOT_NULL
 
Specifies the id of creator object.
object_type
STRING 30 NOT_NULL
 
Specifies the short name of creator object.
persid
STRING 30
 
Persistent ID (SystemObjectName:id)
transition_errmsg
STRING 240
 
Specifies the text to display on failure.
transition_test
STRING 30
Spell_Macro ::persid
Specifies the condition.
 
Bop_Workshift Table
Workshift definition.
  • SQL Name
    -- bpwshft
  • Object
    -- wrkshft
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_Table::enum
This is the Deleted flag:
0
-- Active
1
-- Inactive/marked as deleted
description
nvarchar(80)
 
Specifies the textual description of this workshift.
id
INTEGER
 
Unique (to the table) Numeric ID.
last_mod_by
Byte(16)
ca_contact:: uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
 
Indicates the timestamp of when this record was last modified.
persid
nvarchar(30)
 
Persistent ID (SystemObjectName:id).
Note:
This is a primary key.
sched
nvarchar(1000)
 
Describes the schedule of this workshift.
sym
nvarchar(30)
 
Represents the symbolic value for this workshift.
 
BU_TRANS Table
Program control table used by Knowledge Management.
  • SQL Name
    -- BU_TRANS
  • Object
    -- BU_TRANS
Field
Data Type
Reference
Remarks
BU_DATE
LOCAL_TIME
 
 
BU_PROCESSED
INTEGER
 
 
BU_RATING
REAL
 
 
DOC_ID
INTEGER
SKELETONS::id
 
HIT_NO_VOTE
INTEGER
 
 
HIT_ORIGIN
INTEGER
 
 
ID
INTEGER NOT_NULL KEY
 
Unique (to the table) Numeric ID
INDEX_ID
INTEGER
O_INDEXES::id
 
User_slv
INTEGER
 
 
Ticket_slv
INTEGER
 
 
LAST_MOD_DT
LOCAL_TIME
 
Indicates the timestamp of when this record was last modified.
USER_ID
UUID
ca_contact::uuid
Specifies the UUID of the user id.
kd_duration
INTEGER
 
Specifies the duration of a specific event, such as how long a knowledge document was open.
 
Business_Management_Repository Table
Table that keeps track of CA NSM repositories used by Service Analyzer.
  • SQL Name
    -- busrep
  • Object
    -- bmrep
Field
Data Type
Reference
Remarks
del
INTEGER NOT_NULL
Active_Boolean_ Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
hostname
STRING 64 UNIQUE NOT_NULL
 
 
id
INTEGER UNIQUE NOT_NULL KEY
 
Unique (to the table) Numeric ID
last_mod_by
UUID
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
LOCAL_TIME
 
Indicates the timestamp of when this record was last modified.
nx_desc
STRING 40
 
 
password
STRING 200
 
 
persid
STRING 30
 
Persistent ID (SystemObjectName:id)
sym
STRING 60 UNIQUE NOT_NULL S_KEY
 
 
userid
STRING 40
 
 
 
Column_Name Table
Column Name list used by Web Screen Painter.
  • SQL Name
    -- cn
Field
Data Type
Reference
Remarks
cn_desc
STRING 240
 
description of column
cn_dflt
STRING 30
 
default external name
cn_name
STRING 30
 
user name for column
cn_sys
STRING 30
S_KEY
 
system name
cn_table
STRING 30
S_KEY
 
system table name
del
INTEGER
NOT_NULL
 
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER
UNIQUE
NOT_NULL KEY
 
Unique (to the table) Numeric ID
 
Contact_Method Table
Defines contact method types. The cm_template field is a command string that gets executed as a script (with environment variables set) by the notify subsystem.
  • SQL Name
    -- ct_mth
  • Object
    -- cmth
Field
Data Type
Reference
Remarks
cm_template
nvarchar(240)
 
Specifies the method template.
del
INTEGER
Active_Boolean_Table::enum
Identifies the Delete flag, as follows:
0
-- Active
1
-- Inactive/marked as deleted)
id
INTEGER
 
Specifies the primary key of this table, this is also a unique, numeric ID.
last_mod_by
byte(16)
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
 
Identifies the timestamp of when this record was last modified.
nx_desc
nvarchar(40)
 
Specifies the Contact method description.
persid
nvarchar(30)
 
Specifies the Persistent ID (SystemObjectName:id).
supports_smtp
INTEGER
 
Determines if the method supports SMTP email addresses.
sym
nvarchar(60)
 
Identifies the Contact method symbolic name.
write_file
INTEGER
 
Flag that indicates the following:
1
-- write output to the file
 
D_PAINTER Table
Tables to be used for Form Server and Screen Painter For the new GUI.
  • SQL Name
    -- D_PAINTER
Field
Data Type
Reference
Remarks
CNTLID
INTEGER
 
id of the control
CNTLTYPE
INTEGER
 
type of control
DDID
INTEGER
 
data dictionary id
ENTITYID
INTEGER
 
entity type
EXTRA_L1
INTEGER
 
user-definable
EXTRA_L2
INTEGER
 
user-definable
EXTRA_L3
INTEGER
 
user-definable
EXTRA_S1
STRING 50
 
user-definable
EXTRA_S2
STRING 50
 
user-definable
EXTRA_S3
STRING 50
 
user-definable
FORMGROUP
STRING 50
 
group in which the form is contained
FORMID
INTEGER
 
id number of the form
FORMNAME
STRING 50
 
name of the form
FORMTYPE
INTEGER
 
type of form
ID
INTEGER UNIQUE NOT_NULL KEY
 
key ID
MAPBACK
STRING 30
 
data dictionary owner
PARENTID
INTEGER
 
control id of parent control
PREDEFINED
INTEGER
 
0
-- Normal screen
2
-- Default screen
PROPLIST
STRING 1000
 
properties for the control
SECLEVEL
INTEGER
 
security level
TSTAMP
REAL
 
time stamp
 
Delegation_Server Table
List of servers that can be delegated from this one along with xport methods.
  • SQL Name
    -- dlgsrvr
  • Object
    -- dlgsrvr
Field
Data Type
Reference
Remarks
anon_userid
STRING 8
 
Specifies the anonymous userid.
appl_addr
STRING 48
 
Specifies the name or address of application.
default_assignee
UUID
ca_contact::uuid
Specifies the assignee for incoming tickets.
default_userid
STRING 8
 
Specifies the default userid.
del
INTEGER NOT_NULL
Active_Boolean_ Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER
UNIQUE
NOT_NULL KEY
 
Unique (to the table) Numeric ID
metafile
STRING 256
 
Specifies the path to conversion metafile def.
nx_desc
STRING 40
 
Specifies the description.
password
STRING 16
 
Specifies the server password.
server
STRING 128
 
Specifies the server name or ip address.
sym
STRING 64 UNIQUE NOT_NULL S_KEY
 
Specifies the system name.
transport
INTEGER
 
 
 
Controlled_Table Table
Program control table used by CA SDM applications.
  • SQL Name
    -- ctab
  • Object
    -- ctab
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_ Table::enum
Indicates the Deleted flag, as follows:
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER
 
Primary key to this table, it is a unique numeric ID.
nx_desc
nvarchar(40)
 
Specifies the Table description.
obj_name
nvarchar(30)
 
Specifies the Majic object name that corresponds to this table.
persid
nvarchar(30)
 
Persistent ID (SystemObjectName:id).
sym
nvarchar(30)
 
Represents the symbolic name of this controlled table.
 
EBR_SUFFIXES Table
Program control table used by Knowledge Management.
  • SQL Name
    -- EBR_SUFFIXES
  • Object
    -- EBR_SUFFIXES
Field
Data Type
Reference
Remarks
ID
INTEGER NOT_NULL KEY
 
Unique (to the table) Numeric ID
SUFFIX
STRING 50
 
 
 
Priority Table
List of Priority entries. The priority reflects the time-frame in which a ticket must be resolved. For the ticket, it represents the highest priority of any problem attached to the ticket. Problem priorities are derived from the scope (impact) and severity of the problem.
  • SQL Name
    -- pri
  • Object
    -- pri
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_Table::enum
Deleted flag that indicates the following:
0
-- Active
1
-- Inactive/marked as deleted
enum
INTEGER
 
Primary key of this table.
id
INTEGER
 
Specifies the unique (to the table) numeric ID.
last_mod_by
byte(16)
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
 
Indicates the timestamp of when this record was last modified.
nx_desc
nvarchar(40)
 
Describes the priority.
service_type
nvarchar(30)
Service_Desc:: code
Classic Service Type. Foreign key to the code field of the srv_desc table.
sym
nvarchar(12)
 
Indicates the symbolic name for this priority.
 
Queued_Notify Table
Notifications that are queued due to workshifts are saved here.
  • SQL Name
    -- not_que
  • Object
    -- notque
Field
Data Type
Reference
Remarks
cmth_override
INTEGER
 
method over ride
context_instance
INTEGER 30
 
Contains the persistent ID of the associated Activity Log for the notifications
context_persid
STRING 30
 
Contains the persistent ID of object for notification
del
INTEGER NOT_NULL
Active_Boolean_Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER UNIQUE NOT_NULL KEY
 
Unique (to the table) Numeric ID
internal
INTEGER
 
internal notification
msg_ack
STRING 40
 
message acknowledgment
msg_body
STRING 1000
 
message text
msg_body_html
STRING 32768
 
message text
msg_title
STRING 40
 
Msg header text
notify_level
INTEGER
 
notification level
persid
STRING 30
 
Persistent ID (SystemObjectName:id)
transition_pt
INTEGER
 
transition point
 
Quick_Template_Types Table
Quick_Template_Types - Reference table for quick template types.
  • SQL Name
    -- quick_tpl_types
  • Object
    -- quick_tpl_types
Field
Data Type
Reference
Remarks
del
INTEGER NOT_NULL
Active_Boolean_ Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
enum
INTEGER UNIQUE NOT_NULL
 
Enumerated value for this entry - specifies ordering in lists and relative values
id
INTEGER UNIQUE NOT_NULL KEY
 
Unique (to the table) Numeric ID
nx_desc
STRING 40
 
Descriptive Info
persid
STRING 30
 
Persistent ID (SystemObjectName:id)
sym
STRING 30
 
Symbolic name of level
 
Remote_Ref Table
Remote References. Used for smart hooks. Determines what command to execute. Different command for UNIX and pc's using the same smart hook. Can apply security to smart hook.
  • SQL Name
    -- rem_ref
  • Object
    -- rrf
Field
Data Type
Reference
Remarks
description
STRING 500
 
Specifies the description of the command.
arch_type
STRING 12
 
Specifies the architecture to exec this on UNIX or PC. If empty, then all.
code
STRING 12 UNIQUE NOT_NULL S_KEY
 
Specifies the noneditable key for command.
del
INTEGER NOT_NULL
Active_Boolean_Table::enum
Deleted flag
0
-- Active
1 --
Inactive/marked as deleted
exec_str
STRING 500
 
Specifies the string to execute on UNIX.
function_group
STRING 30
 
Specifies the function group for security.
id
INTEGER UNIQUE NOT_NULL KEY
 
Unique (to the table) Numeric ID
last_mod_by
UUID
ca_contact::uuid
Specifies the UUID of the contact who last modified this record
last_mod_dt
LOCAL_TIME
 
Indicates the timestamp of when this record was last modified.
pcexec_str
STRING 500
 
Specifies the string to execute on pc.
sym
STRING 30 NOT_NULL
 
Specifies the name of command.
 
Response Table
Personalized response text used to simplify data entry when using the CA SDM applications.
  • SQL Name
    -- response
  • Object
    -- response
Field
Data Type
Reference
Remarks
chg_flag
INTEGER S_KEY
 
 
cr_flag
INTEGER S_KEY
 
 
del
INTEGER NOT_NULL
Active_Boolean_ Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER UNIQUE NOT_NULL KEY
 
Unique (to the table) Numeric ID
in_flag
INTEGER S_KEY
 
 
iss_flag
INTEGER S_KEY
 
 
last_mod_by
UUID
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
LOCAL_TIME
 
Indicates the timestamp of when this record was last modified.
persid
STRING 30
 
Persistent ID (SystemObjectName:id)
pr_flag
INTEGER S_KEY
 
 
response
STRING 1000
 
response text
response_owner
UUID S_KEY
ca_contact::uuid
response owner
sym
STRING 50 NOT_NULL S_KEY
 
symbol
 
Rootcause Table
Reference table to denote the rootcause type used when resolving or closing a request, change order, or issue.
  • SQL Name
    -- rootcause
  • Object
    -- rc
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_Table::enum
Specifies the Deleted flag as follows:
0
-- Active
1
-- Inactive/marked as deleted
description
nvarchar(240)
 
Provides a textual description of this root cause.
id
INTEGER
 
Primary key of this table.
last_mod_by
byte(16)
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
 
Indicates the timestamp of when this record was last modified.
persid
nvarchar(30)
 
Persistent ID (SystemObjectName:id).
sym
nvarchar(60)
 
Identifies the symbolic value for this Rootcause.
 
 
Rpt_Meth Table
Reporting methods used to display information within the CA SDM applications.
  • SQL Name
    -- rptmth
  • Object
    -- rptm
Field
Data Type
Reference
Remarks
description
STRING 80
 
Specifies the textual description of this reporting method.
def_pg_len
STRING 80
 
Specifies the page length default.
default_out
STRING 80
 
Specifies the output default.
del
INTEGER NOT_NULL
Active_Boolean_Table::enum
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER UNIQUE NOT_NULL KEY
 
Unique (to the table) Numeric ID
is_default
INTEGER
 
If set, this specifies the default reporting method.
last_mod_by
UUID
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
LOCAL_TIME
 
Indicates the timestamp of when this record was last modified.
script
STRING 1000
 
 
sym
STRING 30 NOT_NULL
 
 
 
Reporting_Method Table
Reference table to denote how the contact with the customer occurred. Example: email, phone.
  • SQL Name
    -- repmeth
  • Object
    -- rptmeth
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_Table::enum
Specifies the Deleted flag as follows:
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER
 
Primary key of this table.
last_mod_by
byte(16)
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
 
Indicates the timestamp of when this record was last modified.
persid
nvarchar(30)
 
Persistent ID (SystemObjectName:id).
sym
nvarchar(60)
 
Identifies the symbolic value for this Reporting Method.
 
Note_Board Table
Message board (announcements) on the main menu.
  • SQL Name
    -- cnote
  • Object
    -- cnote
Field
Data Type
Reference
Remarks
active_flag
INTEGER NOT_NULL
Boolean_Table:: enum
0
-- Inactive
1
-- Active
close_date
LOCAL_TIME
 
Indicates when closed
cnote_type
INTEGER
 
Indicates the announcement type
control_group
UUID
 
Specifies the group to display to
del
INTEGER
 
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER UNIQUE NOT_NULL KEY
 
Unique (to the table) Numeric ID
internal
INTEGER
 
Internal Flag
loc_id
UUID
ca_location:: location_uuid
Indicates a pointer to location
organization
UUID
ca_organization ::organization_ uuid
Indicates a pointer to Organization
persid
STRING 30
 
Persistent ID (SystemObjectName:id)
posted_by
UUID
ca_contact::uuid
Specifies who posted the announcement
posted_date
LOCAL_TIME
 
Indicates the last modify time
text
STRING 4000
 
Indicates the message text
 
Prob_Category Table
Call Request call areas. Category of the issue that the customer is calling about. Can be hierarchical.
  • SQL Name
    -- prob_ctg
  • Object
    -- pcat
Field
Data Type
Reference
Remarks
id
INTEGER
UNIQUE NOT_NULL KEY
Unique (to the table) numeric ID.
persid
STRING (30)
 
Persistent ID (SystemObjectName:id)
del
INTEGER
NOT_NULL
Delete flag that indicates the following:
0
-- Active
1
-- Inactive/marked as deleted
sym
STRING (1000)
NOT_NULL S_KEY
Specifies the symbolic name of the request area.
last_mod_dt
LOCAL_TIME
 
Identifies the timestamp of when this record was last modified.
last_mod_by
UUID
ca_contact
Specifies the UUID of the contact who last modified this record.
description
STRING (500)
 
Identifies the textual description of the call area.
organization
UUID
ca_organization
Foreign key to the id field of the ca_organization table, this is the Organization.
assignee
UUID
ca_contact
Foreign key to the contact_uuid field of the ca_contact table, this is the Assignee.
group_id
UUID
ca_contact
Foreign key to the contact_uuid field of the ca_contact table, this is the Group.
tcode
INTEGER
 
Deprecated
service_type
STRING (30)
Service_Desc
Foreign key to the code field of the srv_desc table, this is the Classic Service Type.
survey
INTEGER
Survey_Template
Foreign key of the id field of the survey_tpl table, this is the Survey.
schedule
INTEGER
Bop_Workshift
Deprecated
auto_assign
INTEGER
 
Represents the flag that enables auto assignment.
owning_contract
INTEGER
Service_Contract
Foreign key to the id field of the svc_contract table.This is the Service Contract.
cr_flag
INTEGER
 
Represents the cr_flag status. When set to 1, this status is valid for requests.
in_flag
INTEGER
 
Specifies the Incident flag. When set to 1, the status is valid for Incidents.
pr_flag
INTEGER
 
Specifies the Problem flag. When set to 1, the status is valid for Problems.
suggest_knowledge
INTEGER
 
Specifies whether or not to suggest knowledge to users.
1
-- Suggest knowledge.
2
-- Do not suggest knowledge.
assignable_ci_attr
STRING (60)
 
Identifies the name of the attribute on a CI object that contains the grp contact that should be used to perform Category/CI auto group assignment.
flow_flag
INTEGER
 
Specifies the type of workflow:
0
-- Classic Workflow or none (default)
2
-- CA IT PAM
caextwf_start_id
INTEGER
caextwf_start_forms
Identifies the CA IT PAM process definition information to use when the user selects this category on a change order, issue, request.
tenant
UUID
ca_contact
 
ss_include
INTEGER
 
Required.
On new default: 0
ss_sym
STRING (128)
 
 
category_urgency
INTEGER
Urgency
 
sap_prop
INTEGER
 
 
 
Product Table
Reference table to denote the product that the complaint relates to.
  • SQL Name
    -- product
  • Object
    -- prod
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_ Table::enum
Delete flag that indicates the following:
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER
 
Primary key of this table.
last_mod_by
byte(16)
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
 
Indicates the timestamp of when this record was last modified.
persid
nvarchar(30)
 
Persistent ID (SystemObjectName:id).
sym
nvarchar(60)
 
Specifies the symbolic value for this Product.
 
sa_agent_availability Table
Program control table used by Support Automation.
  • SQL Name
    -- sa_agent_availability
  • Object
    -- sa_agent_availability
Field
Data Type
Reference
Remarks
id
INTEGER
 
KEY
agentID
UUID
ca_contact
NOT_NULL
queueID
INTEGER
sa_queue
NOT_NULL
status
INTEGER
 
 
availEpoch
LOCAL_TIME
 
 
clientSessionID
INTEGER
sa_login_session
 
matchEpoch
LOCAL_TIME
 
 
groupID
INTEGER
sa_group
 
incidentCount
INTEGER
 
 
last_mod_by
UUID
cnt
Specifies the UUID of the contact who last modified this record.
last_mod_dt
DATE
 
Specifies the timestamp of when this record was last modified.
tenant
UUID
ca_tenant
Specifies the UUID of the tenant.
Table_Name Table
Table name list used by CA SDM applications.
  • SQL Name
    -- tn
Field
Data Type
Reference
Remarks
del
INTEGER NOT_NULL
 
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER UNIQUE NOT_NULL KEY
 
Unique (to the table) Numeric ID
tn_desc
STRING 240
 
description or table
tn_dflt
STRING 30
 
default external name
tn_name
STRING 30
 
user name for table
tn_sys
STRING 30 S_KEY
 
system name
usp_special_handling Table
The usp_special_handling table defines the characteristics of each special handling classification.
Attribute
Data Type
SREL References
Flags
alert_icon_url
STRING 1000
 
 
alert_text
STRING 60
 
 
autodisplay_notes
INTEGER
 
 
del
INTEGER
 
NOT_NULL
description
STRING 4000
 
 
escalate_urgency
INTEGER
 
 
id
INTEGER
 
UNIQUE NOT_NULL KEY
last_mod_by
UUID
ca_contact
 
last_mod_dt
LOCAL_TIME
 
 
sym
STRING 60
 
NOT_NULL
tenant
UUID
ca_tenant
 
usp_symptom_code Table
The usp_symptom_code table associates codes with a special handling classification.
Attribute
Data Type
SREL References
Flags
del
INTEGER
 
NOT_NULL
description
STRING 4000
 
 
id
INTEGER
 
UNIQUE NOT_NULL KEY
last_mod_by
UUID
ca_contact
 
last_mod_dt
LOCAL_TIME
 
 
sym
STRING 60
 
NOT NULL
tenant
UUID
ca_tenant
 
usp_tab Table
Information on Tabs used in the Role Based UI.
  • SQL Name
     -- usp_tab
  • Object
     -- tab
Field
Data Type
Reference
Remarks
id
INTEGER
 
Specifies the unique (to the table) numeric ID.
name
STRING (80)
 
Tab Name
display_name
STRING (80)
 
Text displayed on tab
code
STRING 30
 
Code
del
INTEGER
Active_
Boolean_
Table::enum
 
description
STRING (255)
 
Description
menu_bar_obj
INTEGER
usp_menu_bar::id
Foreign key to the menu bar id field of the usp_menu_bar table.
web_form_obj
INTEGER
web_form::id
Foreign key to the web form id field of the usp_web_form table.
usp_ticket_type Table
The usp_ticket_type table lists the ticket types referenced by Action Object drop-down list (action_object) in the usp_mailbox_rule table.
Field
Data Type
Description
id
INTEGER UNIQUE KEY
Specifies the primary key of this table.
allow_mailbox
INTEGER
 
code
STRING 30 UNIQUE S_KEY
Specifies the REL_ATTR value of the table, and the distinct keyword for each ticket type that is recognized by some components
del
INTEGER
 
sym
STRING 60
Specifies the symbolic value for the ticket type.
ticket_object
STRING 30
Specifies the Majic object for the ticket (cr, chg, or iss).
ticket_object_type
STRING 1
Specifies the Call_Request_Type field (R, I or P) for the cr object.
The following values are the defaults for the usp_ticket_type table:
id
code
sym
ticket_obj
ticket_obj_type
100
REQUEST
Request
cr
R
200
INCIDENT
Incident
cr
I
300
PROBLEM
Problem
cr
P
400
CHANGE
Change
chg
 
500
ISSUE
Issue
iss
 
usp_web_form Table
Information on Web Forms used in the Role Based UI.
  • SQL Name
     -- usp_web_form
  • Object
     -- web_form
Field
Data Type
Reference
Remarks
id
INTEGER
 
Specifies the unique (to the table) numeric ID.
name
STRING (80)
 
Tab Name
code
STRING 30
 
Code
del
INTEGER
Active_Boolean_
Table::enum
 
description
STRING (255)
 
Description
wf_resource
STRING (1024)
 
The URL to display the HTMPL form, Report, Go button resource or third party form.
wf_type
INTEGER
 
The type of the web form:
0
-- HTMPL
1
-- Report
2
-- Go Resource
3
-- Other
dflt_for_obj
STRING 30
 
For Go Resource type web forms only. Indicates that this Go Resource will override the role's default when displaying objects of this type (such as "Request", "Issue", "Change Order"). Only one Go Resource can be assigned a dflt_for_obj for each type.
usp_attr_control Table
A dependent_control object specifies the attribute name and locked or required value that activates dependent control.
  • SQL Name
     -- usp_attr_control
  • Object
     -- att_control
Attribute
DB Field
Data Type
SREL References
Flags
id
id
INTEGER
 
UNIQUE REQUIRED KEY
control
control
INTEGER REF
usp_dependent_control
 
attrname
attrname
STRING 64
 
Identifies attribute name.
locked
locked
INTEGER
 
Identifies locked attribute.
required
required
INTEGER
 
Identifies required attribute.
last_mod_dt
last_mod_dt
LOCAL_TIME
 
Indicates the timestamp of when this record was last modified.
last_mod_by
last_mod_by
UUID REF
ca_contact
Specifies the UUID of the contact who last modified this record.
del
 
INTEGER
nn
Deleted flag
0
-- Active
1
-- Inactive/marked as deleted
tenant
 
UUID REF
ca_tenant
 
 usp_auto_close Table
The auto close object controls the automatic closure of a ticket (request, incident, problem, change order, issue). The usp_auto_close table lists the automatic closure settings. For each ticket type, you can define the number of business hours before the closure takes place. By definition, zero hours means that automatic closure is not implemented for the ticket type.
In an untenanted system only one active row is allowed in this table.
In a tenanted system, each tenant can have its own row and only one row is permitted. In addition, one active Public row is permitted for tenants that do not have a tenanted row. If a tenant does not have its own row of auto-close settings, and there is not an active Public row, the automatic closure feature is disabled for that tenant.
  • SQL Name
     -- usp_auto_close
  • Object
     -- auto_close
Label
Field
Description
id
INTEGER
Unique key
sym
STRING 80
 
cr_ach
INTEGER
 
in_ach
INTEGER
 
pr_ach
INTEGER
 
chg_ach
INTEGER
 
iss_ach
INTEGER
 
description
STRING 255
 
last_mod_dt
LOCAL_TIME
 
last_mod_by
UUID REF
ca_tenant
del
INTEGER
nn
tenant
UUID REF
ca_tenant
 usp_ci_window Table
The usp_ci_window table stores the associations between windows and configuration items.
  • SQL Name
     -- usp_ci_window
  • Object
     -- ci_window
Attribute
Data Type
SREL References
id
 
 
nr_uuid
UUID
nr (object)
Window_id
ID
window (object)
producer_id
STRING
 
persistent_id
STRING
 
last_mod_by
SREL
last_mod_dt
DATE
 
usp_email_type Table
The usp_email_type table lists the email types that are available for the Email Type drop-down list (email_type) in the usp_mailbox table.
Field
Data Type
Description
id
INTEGER UNIQUE KEY
Specifies the primary key of this table.
code
STRING 30 UNIQUE S_KEY
Specifies the code value for the email type.
del
INTEGER
 
incoming
INTEGER
Specifies whether the email type is incoming or outgoing.
sym
STRING 60
Specifies the symbolic value for the email type.
The following values are the defaults for the usp_email_type table:
id
code
incoming
sym
100
NONE
1
NONE
200
IMAP
1
IMAP
300
POP3
1
POP3
400
SMTP
0
SMTP
 
usp_export_list_format Table
The usp_export_list_format table lists the file format that is used to export list results outside of CA Service Desk Manager.
  • SQL Name
     -- usp_export_list_format
  • Object
     -- usp_exlist_format
Label
Field
Description
id
INTEGER
Unique (to the table) Numeric ID.
file_extention
STRING
Specifies the active file format to export search list results. Excel (.xls) is currently supported.
mime_type
STRING
Specifies the internet media type.
xslt_name
STRING
Specifies the XSL file name on the server.
sym
STRING
Specifies the export file format.
delete_flag
INTEGER
Delete indicator.
 
usp_ical_alarm Table
 
  • SQL Name
     -- usp_ical_alarm
  • Object
     -- ical_alarm
Field
Data Type
Reference
Remarks
id
INTEGER
 
Unique key
del
INTEGER
 
 
alarm_value
STRING 120
 
 
sym
STRING 60
 
 
last_mod_dt
LOCAL_TIME
 
 
last_mod_by
UUID REF
ca_contact
 
 
usp_ical_event_template Table
 
  • SQL Name
     -- usp_ical_event_template
  • Object
     -- ical_event_template
Field
Data Type
Reference
 
id
INTEGER
 
Unique key
del
INTEGER
 
NOT_NULL
obj_type
STRING 30
 
NOT_NULL
code
STRING 60
 
NOT_NULL
sym
STRING 60
 
NOT_NULL
start_date
STRING 30
 
NOT_NULL
end_date
STRING 30
 
 
alarm
INTEGER
usp_ical_alarm
 
categories
STRING 128
 
 
summary
STRING 240
 
 
description
STRING 4000
 
 
url
STRING 4000
 
 
extra_entries
STRING 4000
 
 
last_mod_dt
LOCAL_TIME
 
 
last_mod_by
UUID
ca_contact
 
usp_owned_resource Table
Holds information about the owned resource.
  • SQL Name
     -- usp_owned_resource
  • Object
     -- usp_owned_resource
Attribute
DB Field
Data Type
SREL References
Flags
argis_id
nr_argis_id
STRING
 
 
assoc_projex
assoc_projex
BREL
 
audit_userid
audit_userid
LOCAL SREL
cnt
 
assoc_in
assoc_in
QREL
cr
 
assoc_pr
assoc_pr
QREL
cr
 
bm_rep
nr_bm_rep
INTEGER
busrep id
 
bm_label
nr_bmlabel
STRING
 
 
bm_macro_smag
bm_macro_smag
LOCAL STRING 0
 
 
bm_status
nr_bms
INTEGER
busstat status_no
 
expiration_date
nr_exp_dt
LOCAL_TIME
 
 
financial_num
nr_financial_id
STRING
 
 
nsm_id
nsm_id
STRING 40
 
 
contact_1
nr_nx_ref_1
UUID
ca_contact uuid
 
contact_2
nr_nx_ref_2
UUID
ca_contact uuid
 
contact_3
nr_nx_ref_3
UUID
ca_contact uuid
 
linked_id_usp_ owned_resource
linked_id_usp_ owned_resource
UUID
 
 
smag_1
nr_nx_string1
STRING
 
 
smag_2
nr_nx_string2
STRING
 
 
smag_3
nr_nx_string3
STRING
 
 
smag_4
nr_nx_string4
STRING
 
 
smag_5
nr_nx_string5
STRING
 
 
smag_6
nr_nx_string6
STRING
 
 
priority
nr_pr_id
INTEGER
pri enum
 
name_type
nr_prim_skt_id
INTEGER
 
 
service_type
nr_service_type
STRING
srv_desc code
 
sla
nr_sla_id
INTEGER
 
 
warranty_end
nr_wrty_end_dt
LOCAL_TIME
 
 
warranty_start
nr_wrty_st_dt
LOCAL_TIME
 
 
id
owned_resource_uuid
UUID
 
 
USP_Preferences Table
Holds information about the CA SDM and Knowledge Management application preferences.
  • SQL Name
     -- usp_preferences
  • Object
     -- usp_preferences
Field
Data Type
Reference
Remarks
ANALYST_ID
UUID
ca_contact ::uuid
 
ARC_DOCS_TO_ DISPLAY
INTEGER
 
 
ASSIGNEE
INTEGER
 
 
AUTHOR
INTEGER
 
 
BU_RESULT
INTEGER
 
 
CLASSIC_ RESULTSET_ CONTEXT
INTEGER
 
Specifies the Classic resultset context menu activation.
CREATED_VIA
INTEGER
 
 
CREATION_DATE
INTEGER
 
Indicates the timestamp indicating when this record was created.
CURRENT_ACTION
INTEGER
 
 
CUSTOM1
INTEGER
 
 
CUSTOM2
INTEGER
 
 
CUSTOM3
INTEGER
 
 
CUSTOM4
INTEGER
 
 
CUSTOM5
INTEGER
 
 
CUSTOM_NUM1
INTEGER
 
 
CUSTOM_NUM2
INTEGER
 
 
DOC_ID
INTEGER
 
 
DOC_TEMPLATE
INTEGER
 
 
DOC_TYPE
INTEGER
 
 
DOC_VERSION
INTEGER
 
 
EXPIRATION_DATE
INTEGER
 
 
GLOBALSD_ ACTIVE_ZONE
INTEGER
 
Specifies the status of the Global Service Desk Active Zone log reader:
0x01
-- Reduce popups
0x02
-- Close log reader
HITS
INTEGER
 
 
ID
INTEGER NOT_NULL KEY
 
Specifies the numeric ID that is unique to this table.
INBOX_COUNTER
INTEGER
 
 
INITIATOR
INTEGER
 
 
ITEM
INTEGER
 
 
KT_REPORT_ CARD_PAST_ DAYS
INTEGER
 
Indicates the Knowledge report card past_days status. This is a user-defined preference.
KT_REPORT_ CARD_SCREEN_ DEFAULT
INTEGER
 
Indicates the Knowledge report card screen default. this is a user-defined preference.
LAST_ACCEPTED_DATE
INTEGER
 
 
LAST_MOD_DT
LOCAL_TIME
 
Indicates the timestamp for when this record was last modified.
MODIFY_DATE
INTEGER
 
 
ONE_B_DOC_ VIEW_MODE
INTEGER
 
 
ONE_B_DOCS_TO_DISPLAY
INTEGER
 
 
ONE_B_HIDE_ DETAILS
INTEGER
 
 
ONE_B_MATCH_ TYPE
INTEGER
 
 
ONE_B_SEARCH_FIELDS
INTEGER
 
 
ONE_B_SEARCH_ORDER
STRING 255
 
 
ONE_B_SEARCH_TYPE
INTEGER
 
 
ONE_B_WORD_ PARTS
INTEGER
 
 
OWNER
INTEGER
 
 
PRIMARY_INDEX
INTEGER
 
 
PRIORITY
INTEGER
 
 
PRODUCT
INTEGER
 
 
PUBLISHED_DATE
INTEGER
 
 
REVIEW_DATE
INTEGER
 
 
SD_ACCEPTED_ HITS
INTEGER
 
 
SD_IMPACT
INTEGER
 
 
SD_PRIORITY
INTEGER
 
 
SD_ROOTCAUSE
INTEGER
 
 
SD_SEARCH_ FIELDS_CR
INTEGER
 
Specifies the CA SDM and Knowledge Management search fields for requests.
SD_SEARCH_ FIELDS_ISS
INTEGER
 
Specifies the CA SDM and Knowledge Management search fields for issues.
SD_SEVERITY
INTEGER
 
 
SD_URGENCY
INTEGER
 
 
START_DATE
INTEGER
 
 
STATUS
INTEGER
 
 
SUBJECT_EXPERT
INTEGER
 
 
USER_DEF_ID
INTEGER
 
 
WEB_LAST_LOGIN
LOCAL_TIME
 
Indicates the time of the last web login.
WEB_POPUP1_ HEIGHT
INTEGER
 
Specifies the maximum height for pop-up1.
WEB_POPUP1_ WIDTH
INTEGER
 
Specifies the maximum width for the Web pop-up1.
WEB_POPUP2_ HEIGHT
INTEGER
 
Specifies the medium Web pop-up2 height.
WEB_POPUP2_ WIDTH
INTEGER
 
Specifies the Medium Web pop-up2 width.
WEB_POPUP3_ HEIGHT
INTEGER
 
Specifies the Small Web pop-up3 height.
WEB_POPUP3_ WIDTH
INTEGER
 
Specifies the Small Web pop-up3 width.
WEB_POPUP4_ HEIGHT
INTEGER
 
Specifies the extra Small Web pop-up height.
WEB_POPUP4_ WIDTH
INTEGER
 
Specifies the extra Small Web pop-up4 width.
WEB_ PREFERENCES
INTEGER
 
Indicates Web Preferences Flags.
WEB_SUPPRESS_TOUR
INTEGER
 
Specifies the Web suppressor tour flag:
1
-- Do not Suppress
2
-- Suppress tour page
WEB_TOOLBAR_ TAB
INTEGER
 
Indicates the initial toolbar tab.
WF_TEMPLATE
INTEGER
 
 
 
usp_pri_cal Table
Stores priority calculation data.
  • SQL Name
     -- usp_pri_cal
  • Object
     -- pri_cal
Field
Data Type
Reference
Remarks
id
INTEGER
 
UNIQUE NOT_NULL KEY
name
STRING 80
 
NOT_NULL UNIQUE NOT_NULL S_KEY
description
STRING 1024
 
 
del
INTEGER
 
NOT_NULL
in_flag
INTEGER
Boolean_Table
 
pr_flag
INTEGER
Boolean_Table
 
imp_def
INTEGER
Impact
 
urg_def
INTEGER
Urgency
 
ci_imp
INTEGER
Boolean_Table
 
cat_urg
INTEGER
Boolean_Table
 
bk_window
INTEGER
 
 
cnt_vip
INTEGER
 
 
pri_5_4
INTEGER
Priority
 
pri_5_3
INTEGER
Priority
 
pri_5_2
INTEGER
Priority
 
pri_5_1
INTEGER
Priority
 
pri_5_0
INTEGER
Priority
 
pri_4_4
INTEGER
Priority
 
pri_4_3
INTEGER
Priority
 
pri_4_2
INTEGER
Priority
 
pri_4_1
INTEGER
Priority
 
pri_4_0
INTEGER
Priority
 
pri_3_4
INTEGER
Priority
 
pri_3_3
INTEGER
Priority
 
pri_3_2
INTEGER
Priority
 
pri_3_1
INTEGER
Priority
 
pri_3_0
INTEGER
Priority
 
pri_2_4
INTEGER
Priority
 
pri_2_3
INTEGER
Priority
 
pri_2_2
INTEGER
Priority
 
pri_2_1
INTEGER
Priority
 
pri_2_0
INTEGER
Priority
 
pri_1_4
INTEGER
Priority
 
pri_1_3
INTEGER
Priority
 
pri_1_2
INTEGER
Priority
 
pri_1_1
INTEGER
Priority
 
pri_1_0
INTEGER
Priority
 
pri_0_4
INTEGER
Priority
 
pri_0_3
INTEGER
Priority
 
pri_0_2
INTEGER
Priority
 
pri_0_1
INTEGER
Priority
 
pri_0_0
INTEGER
Priority
 
cap_reason
INTEGER
Boolean_Table
 
last_mod_dt
LOCAL_TIME
 
 
last_mod_by
UUID
ca_contact
 
tenant
UUID
ca_tenant
 
 
usp_properties Table
Provides a list of property/value pairs for CA SDM and Knowledge Management applications.
  • SQL Name
     -- usp_properties
  • Object
     -- usp_properties
The maximum number of characters (HTML or pure text) allowed in the document's resolution field is 32768 bytes by default. The system Administrator can set this limit based on the type of data being stored. The limit can be set from the Administration tab, Knowledge, Documents, Document Settings.
There is also a built-in limit of 32768 bytes for the document's pure text that will be indexed. If the resolution of a document is larger than the set limit, only the first 32768 bytes of the document will be indexed and the rest will be ignored.
Field
Data Type
Reference
Remarks
ID
INTEGER NOT_NULL KEY
 
Unique (to the table) Numeric ID.
auto_policies_last
Date
 
Displays the
last
date and time when automated policies were run on the server; stored in seconds, in UNIX time format.
auto_policies_next_ interval
Number
 
Identifies the number of days between automated calculation batches.
last_mod_dt
LOCAL_TIME
 
Indicates the timestamp of when this record was last modified.
notify_days_bef_doc_ exp
Number
 
Defines the number of days before the document expires and a notification is sent.
property_default
STRING 32768
 
Identifies the property default.
property_description
STRING 255
 
Identifies the property description.
property_name
STRING 100 S_KEY
 
Identifies the property name.
property_type
STRING 100
 
Identifies the property type.
property_value
STRING 32768
 
Identifies the property value.
suggest_knowledge_ for _issue_cats
INTEGER
 
Flag that determines whether or not to suggest knowledge to customers.
1
-- Suggest knowledge by default for all issue categories.
0
-- Do not suggest knowledge.
usp_notification_phrase Table
The usp_notification_phrase table lists common phrases that notification message templates can use.
  • S QL Name
     -- usp_notification_phrase
  • Object
     -- notification_phrase
Field
Data Type
References
Description
id
INTEGER UNIQUE KEY
 
Specifies the primary key of this table.
del
INTEGER REF
 
 
last_mod_dt
LOCAL_TIME
 
Specifies the time stamp of when this record was last modified.
last_mod_by
UUID REF
ca_contact
Specifies the UUID of the contact who last modified this record.
code
STRING UNIQUE S_KEY
 
Specifies the code name for the notification phrase that identifies the specific phrase when referenced in other text.
sym
STRING
 
Specifies the display name for the notification phrase.
description
STRING
 
Describes the notification phrase.
phrase
STRING
 
Specifies the phrase text to use for notification.
usp_organization Table
This table provides extensions to the ca_organization table that are used only by CA SDM products.
  • SQL Name
     -- usp_organization
  • Object
     -- org
Field
Data Type
Reference
Remarks
iorg_assigned_svr
INTEGER
 
Deprecated.
iorg_service_type
nvarchar(30)
Service_Desc::code
Foreign key to the code field of the srv_desc table, this is the Classic Service Type.
last_mod
INTEGER
 
Indicates the timestamp of when this record was last modified.
organization_uuid
byte(16)
 
Primary key. Unique identifier.
owning_contract
INTEGER
Service_Contract::id
Identifies the unique (to the table) numeric ID.
Form_Group Table
Listing of defined form groups.
  • SQL Name
     -- fmgrp
  • Object
     -- fmgrp
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_Table::enum
Specifies the Deleted flag, as follows:
0
-- Active
1
-- Inactive/marked as deleted
description
nvarchar(100)
 
Specifies the textual description of this form group.
id
INTEGER
 
Primary key of this table, it is a unique, numeric ID.
last_mod_by
byte(16)
ca_contact::uuid
Specifies the UUID of the contact who last modified this record.
last_mod_dt
INTEGER
 
Indicates the timestamp of when this record was last modified.
sym
nvarchar(30)
 
Specifies the symbolic value for this Form_Group.
True_False_Table Table
Contains localized True or False strings that display on the UI.
  • SQL Name
     -- True_False_Table
  • Object
     -- true_false
Field
Data Type
Reference
Remarks
id
INTEGER
 
UNIQUE NOT_NULL KEY Unique to the table Numeric ID.
del
INTEGER
 
NOT_NULL Deleted flag:
0
-- Active
1
-- Inactive/marked as deleted
enum
INTEGER
 
NOT_NULL Enumerated value for this entry
0
-- False
1
-- True
sym
STRING 60
 
UNIQUE NOT_NULL S_KEY Identifies the symbolic value for this target
desc
STRING 40
 
Describes the enum