Objects and Attributes

This page lists the objects and attributes that define CA SDM. The system uses objects and attributes to build notification text, scoreboard queries, and data partition constraints. The FACTORY Optional statement that accompanies each object, defines access to the object, including its relation attribute, a common name, the security group that can access it, the type of lists produced, and how those lists can be sorted. If omitted, the object is treated according to default specifications.
casm173
This page lists the objects and attributes that define CA SDM. The system uses objects and attributes to build notification text, scoreboard queries, and data partition constraints. The
FACTORY Optional
statement that accompanies each object, defines access to the object, including its relation attribute, a common name, the security group that can access it, the type of lists produced, and how those lists can be sorted. If omitted, the object is treated according to default specifications.
When an object is documented as a containing a LOCAL
DB Field
, the attribute maps to a local variable instead of a database column. Objects that are documented as a BREL
Data Type
, refer to a backward single relationship (SREL). For more information about default specifications and detailed lists of the attributes of each object, see the chapter "Object Definition Syntax."
This article contains the following topics:
attached_sla Object
The object details are as follows:
  1. Associated Table: Attached_SLA
  2. Factories: default, ttv_slas
  3. REL_ATTR: id
  4. Common Name: ticket_type
  5. Function Group:
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
_mapped_chg
_mapped_chg
INTEGER
chg id
_mapped_cr
_mapped_cr
STRING
call_req persid
_mapped_iss
_mapped_iss
STRING
issue persistent_id
_mapped_iss_wf
_mapped_iss_wf
INTEGER
isswf id
_mapped_wf
_mapped_wf
INTEGER
wf id
delete_flag
del
INTEGER
actbool enum
REQUIRED
id
id
INTEGER
UNIQUE REQUIRED KEY
last_mod_by
last_mod_by
UUID
ca_contact uuid
last_mod_dt
last_mod_dt
LOCAL_TIME
last_ttv_upd
last_ttv_upd
LOCAL_TIME
map_sdsc
map_sdsc
STRING
srv_desc code
REQUIRED
persistent_id
persid
STRING
sla_viol_status
sla_viol_status
INTEGER
ticket_id
ticket_id
INTEGER
REQUIRED S_KEY
ticket_type
ticket_type
STRING
REQUIRED
time_to_violation
time_to_violation
LOCAL_TIME
ttv_event
ttv_event
STRING
att_evt persid
attr_control Object
The object details are as follows:
  1. Associated Tables: dependent_control and usp_attr_control
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: attrname
Function Group: admin
REST Operations: CREATE READ UPDATE
Attribute
Data Type
SREL References
Flags
control
SREL dependent_control
Dependent control
attrname
STRING
Name of controlled attribute
locked
INTEGER
1 = attribute is read-only
required
INTEGER
1= attribute is required
delete_flag
INTEGER
SREL actbool
Required; on new default: 0
last_mod_by
SREL cnt
On new default user; on CI set user
last_mod_dt
DATE
On CI set now
auto_close Object
The object details are as follows:
  1. Associated Table: usp_auto_close
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: admin
  6. Tenant: optional
  7. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
sys
symbol
STRING
Required
cr_ach
request
INTEGER
Required
On new default: 0
in_ach
incident
INTEGER
Required
On new default: 0
pr_ach
problem
INTEGER
Required
On new default: 0
chg_ach
change order
INTEGER
Required
On new default: 0
iss_ach
issue
INTEGER
Required
On new default: 0
delete_flag
INTEGER
actbool
On CI set now
description
description
STRING
last_mod_dt
DATE
On CI set now
last_mod_by
DATE
cnt
On CI set user
On new default user
aty Object
The object details are as follows:
  1. Associated Table: Act_Type
  2. Factories: default, chgaty, craty, issaty, mgsaty
  3. REL_ATTR: code
  4. Common Name: sym
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
chg_default_ survey
chg_default_survey
INTEGER
survey_tpl id
chg_notify_info
chg_notify_info
STRING
splmac persid
chg_send_ survey
chg_send_survey
INTEGER
chg_survey_ method
chg_survey_ method
INTEGER
ct_mth id
chg_survey_ msgbody
chg_survey_ msgbody
STRING
chg_survey_ msgtitle
chg_survey_msgtitl
STRING
code
code
STRING
UNIQUE REQUIRED S_KEY
cr_default_ survey
cr_default_survey
INTEGER
survey_tpl id
cr_notify_info
cr_notify_info
STRING
splmac persid
cr_send_survey
cr_send_survey
INTEGER
cr_survey_method
cr_survey_method
INTEGER
ct_mth id
cr_survey_msgbody
cr_survey_msgbody
STRING
cr_survey_msgtitle
cr_survey_msgtitle
STRING
delete_flag
del
INTEGER
actbool enum
REQUIRED
description
description
STRING
cr_flag
flag1
INTEGER
bool_tab enum
chg_flag
flag2
INTEGER
bool_tab enum
iss_flag
flag3
INTEGER
bool_tab enum
mgs_flag
flag4
INTEGER
bool_tab enum
kd_flag
flag5
INTEGER
bool_tab enum
id
id
INTEGER
UNIQUE REQUIRED KEY
internal
internal
INTEGER
iss_default_survey
iss_default_survey
INTEGER
survey_tpl id
iss_notify_info
iss_notify_info
STRING
splmac persid
iss_send_ survey
iss_send_survey
INTEGER
iss_survey_ method
iss_survey_method
INTEGER
ct_mth id
iss_survey_ msgbody
iss_survey_ msgbody
STRING
iss_survey_ msgtitle
iss_survey_msgtitl
STRING
kd_notify_info
kd_notify_info
STRING
splmac persid
last_mod_dt
last_mod_dt
LOCAL_TIME
mgs_notify_info
mgs_notify_info
STRING
splmac persid
notify_msg_ack
notify_ack
STRING
persistent_id
persid
STRING
sym
sym
STRING
REQUIRED S_KEY
audlog Object
The object details are as follows:
  1. Associated Table: Audit_Log
  2. Factories: default
  3. REL_ATTR: code
  4. Common Name: audobj_persid
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
analyst
analyst
UUID
ca_contact uuid
attr_after_val
attr_after_val
STRING
attr_before_val
attr_before_val
STRING
attr_name
attr_name
STRING
aud_opr
aud_opr
INTEGER
audobj_name
audobj_name
STRING
audobj_persid
audobj_persid
STRING
audobj_trkid
audobj_trkid
STRING
audobj_uniqueid
audobj_uniqueid
STRING
change_date
change_date
LOCAL_TIME
id
id
INTEGER
UNIQUE REQUIRED KEY
int1_rsrved
int1_rsrved
INTEGER
int2_rsrved
int2_rsrved
INTEGER
persistent_id
persid
STRING
str1_rsrved
str1_rsrved
STRING
bhvtpl Object
The object details are as follows:
  1. Associated Table: Behavior_Template
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: description
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
context_attrname
context_attrname
STRING
context_attrval
context_attrval
INTEGER
context_type
context_type
STRING
REQUIRED
delete_flag
del
INTEGER
actbool enum
REQUIRED
description
description
STRING
id
id
INTEGER
UNIQUE REQUIRED KEY
last_mod_by
last_mod_by
UUID
ca_contact uuid
modified_date
last_mod_dt
LOCAL_TIME
macro_condition
macro_condition
STRING
splmac persid
object_id
object_id
INTEGER
REQUIRED
object_type
object_type
STRING
REQUIRED
persistent_id
persid
STRING
transition_errmsg
transition_errmsg
STRING
transition_test
transition_test
STRING
splmac persid
BU_TRANS Object
The object details are as follows:
  1. Associated Table: BU_TRANS
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name:
  5. Function Group:
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
Document Hit Date
BU_DATE
LOCAL_TIME
Processed by Bubble Up Flag
BU_PROCESSED
INTEGER
Document Rating
BU_RATING
REAL
Document ID
DOC_ID
INTEGER
SKELETONS id
No Rating Flag
HIT_NO_VOTE
INTEGER
Hit Origin
HIT_ORIGIN
INTEGER
id
ID
INTEGER
REQUIRED KEY
Category Id
INDEX_ID
INTEGER
O_INDEXES id
Last Modified Date
LAST_MOD_DT
LOCAL_TIME
Contact ID
USER_ID
UUID
ca_contact uuid
ADMIN_TREE Object
The object details are as follows:
  1. Associated Table: admin_tree
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: CAPTION
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
CAPTION
CAPTION
STRING
DESCRIPTION
DESCRIPTION
STRING
HAS_CHILDREN
HAS_CHILDREN
INTEGER
id
ID
INTEGER
KEY
KT_ADMIN
KT_ADMIN
INTEGER
KT_KS_CAPTION
KT_KS_CAPTION
STRING
KT_KS_FLAG
KT_KS_FLAG
INTEGER
KT_MANAGER
KT_MANAGER
INTEGER
last_mod_dt
last_mod_dt
LOCAL_TIME
PARENT_ID
PARENT_ID
SREL
RESOURCE
RESOURCE
STRING
SD_ADMIN
SD_ADMIN
INTEGER
alg Object
The object details are as follows:
  1. Associated Table: Act_Log
  2. Factories: default
  3. REL_ATTR: persistent_id
  4. Common Name: description
  5. Function Group: call_mgr
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
action_desc
action_desc
STRING
analyst
analyst
UUID
ca_contact uuid
call_req_id
call_req_id
STRING
call_req persid
description
description
STRING
id
id
INTEGER
UNIQUE REQUIRED KEY
internal
internal
INTEGER
session
knowledge_ session
STRING
k_tool
knowledge_ tool
STRING
last_mod_dt
last_mod_dt
LOCAL_TIME
persistent_id
persid
STRING
system_time
system_time
LOCAL_TIME
time_spent
time_spent
DURATION
time_stamp
time_stamp
LOCAL_TIME
type
type
STRING
act_type code
am_asset_map Object
The object details are as follows:
  1. Associated Table: Am_Asset_Map
  2. Factories: default
  3. REL_ATTR: persistent_id
  4. Common Name: dmuuid
  5. Function Group:
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
dmuuid
am_dmuuid
STRING
domain_id
am_domain_id
INTEGER
server
am_server
STRING
type
am_type
INTEGER
unit_domain_id
am_unit_domain_id
INTEGER
unit_id
am_unit_id
INTEGER
id
id
INTEGER
UNIQUE REQUIRED KEY
int1_rsrved
int1_rsrved
INTEGER
int2_rsrved
int2_rsrved
INTEGER
ob_persid
ob_persid
STRING
ob_type
ob_type
STRING
persistent_id
persid
STRING
str1_rsrved
str1_rsrved
STRING
str2_rsrved
str2_rsrved
STRING
schema_ver
version
INTEGER
REQUIRED
arcpur_rule Object
The object details are as follows:
  1. Associated Table: Archive_Purge_Rule
  2. Factories: default
  3. REL_ATTR: persistent_id
  4. Common Name: name
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
add_query
add_query
STRING
arc_file_name
arc_file_name
STRING
conf_obj_name
conf_obj_name
STRING
days_inactive
days_inactive
INTEGER
REQUIRED
delete_flag
del
INTEGER
actbool enum
REQUIRED
id
id
INTEGER
UNIQUE REQUIRED KEY
last_mod_by
last_mod_by
UUID
ca_contact uuid
last_mod_dt
last_mod_dt
LOCAL_TIME
name
name
STRING
REQUIRED UNIQUE REQUIRED S_KEY
oper_type
oper_type
INTEGER
REQUIRED
persistent_id
persid
STRING
reoccur_interv
reoccur_interv
DURATION
sched
sched
STRING
bpwshft persid
atev Object
The object details are as follows:
  1. Associated Table: Attached_Events
  2. Factories: default
  3. REL_ATTR: persistent_id
  4. Common Name: user_smag
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
cancel_time
cancel_time
LOCAL_TIME
event_tmpl
event_tmpl
STRING
evt persid
REQUIRED S_KEY
fire_time
fire_time
LOCAL_TIME
first_fire_time
first_fire_time
LOCAL_TIME
group_name
group_name
STRING
id
id
INTEGER
UNIQUE REQUIRED KEY
last_mod_dt
last_mod_dt
LOCAL_TIME
num_fire
num_fire
INTEGER
obj_id
obj_id
STRING
REQUIRED
owning_ast
owning_ast
INTEGER
attached_sla id
persistent_id
persid
STRING
start_time
start_time
LOCAL_TIME
status_flag
status_flag
INTEGER
user_smag
user_smag
STRING
wait_time
wait_time
DURATION
atomic_cond Object
The object details are as follows:
  1. Associated Table: Atomic_Condition
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: description
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
cond_code
cond_code
STRING
connecter
connecter
INTEGER
REQUIRED
delete_flag
del
INTEGER
actbool enum
REQUIRED
description
description
STRING
id
id
INTEGER
UNIQUE REQUIRED KEY
l_paran
l_paran
INTEGER
REQUIRED
last_mod_by
last_mod_by
UUID
ca_contact uuid
last_mod_dt
last_mod_dt
LOCAL_TIME
lval
lval
STRING
atyp_asc code
REQUIRED
operator
operator
INTEGER
REQUIRED
owning_macro
owning_macro
STRING
splmac persid
persistent_id
persid
STRING
r_paran
r_paran
INTEGER
REQUIRED
rval
rval
STRING
rval_assoc
rval_assoc
STRING
atyp_asc code
sequence
sequence
INTEGER
REQUIRED
act_type_assoc Object
The object details are as follows:
  1. Associated Table: Act_Type_Assoc
  2. Factories: default
  3. REL_ATTR: code
  4. Common Name: sym
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
act_type
act_type
STRING
act_type code
code
code
STRING
UNIQUE REQUIRED S_KEY
description
description
STRING
id
id
INTEGER
UNIQUE REQUIRED KEY
internal
int1_rsrved
INTEGER
int2_rsrved
int2_rsrved
INTEGER
int3_rsrved
int3_rsrved
INTEGER
last_mod_by
last_mod_by
UUID
ca_contact uuid
last_mod_dt
last_mod_dt
LOCAL_TIME
log_me_f
log_me_f
INTEGER
ob_type
ob_type
STRING
ob_type_attr
ob_type_attr
STRING
persistent_id
persid
STRING
str1_rsrved
str1_rsrved
STRING
str2_rsrved
str2_rsrved
STRING
str3_rsrved
str3_rsrved
STRING
sym
sym
STRING
REQUIRED
ca_cmpny Object
The object details are as follows:
  1. Associated Table: ca_company
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
alias
alias
STRING
authentication_password
authentication_password
STRING
authentication_user_name
authentication_user_name
STRING
bbs
bbs
STRING
Company Name
company_name
STRING
company_type
company_type
INTEGER
ca_company_type id
id
company_uuid
UUID
UNIQUE REQUIRED KEY
creation_date
creation_date
LOCAL_TIME
creation_user
creation_user
STRING
delete_time
delete_time
LOCAL_TIME
description
description
STRING
exclude_registration
exclude_registration
integer
delete_flag
inactive
integer
actbool enum
last_update_date
last_update_date
LOCAL_TIME
last_update_user
last_update_user
STRING
location_uuid
location_uuid
UUID
ca_location location_uuid
month_fiscal_year_ends
month_fiscal_year_ends
integer
parent_company_uuid
parent_company_uuid
UUID
ca_company company_uuid
primary_contact_uuid
primary_contact_uuid
UUID
ca_contact uuid
version_number
version_number
integer
web_address
web_address
STRING
ca_tou Object
The object details are as follows:
  1. Associated Table: ca_tou
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: name
  5. Function Group: security
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
name
name
STRING
REQUIRED
description
description
STRING
terms_of_usage_text
STRING
version_number
version_number
INTEGER
DEFAULT 0
creation_user
creation_user
cnt
DEFAULT USER
creation_date
creation_date
DATE
last_mod_dt
last_mod_dt
DATE
last_update_date
last_update_date
DATE
cnt
delete_flag
del
INTEGER
actbool enum
REQUIRED
caextwf_inst Object
The object details are as follows:
  1. Associated Table: usp_caextwf_instances
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: procname
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
delete_flag
actbool.enum
REQUIRED
instance_id
instance_id
STRING(255)
object_persid
object_persid
STRING(60)
procname
procname
STRING(32768)
starttime
starttime
DATE
endtime
endtime
DATE
caextwf_sfrm Object
The object details are as follows:
  1. Associated Table: usp_caextwf_start_forms
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: procname
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
object_persid
object_persid
STRING(60)
caextwf_form
caextwf_form
STRING(255)
caextwf_path
caextwf_path
STRING(32768)
procname
STRING(0)
closure_code Object
The object contains the following:
  1. Associated Table: usp_closure_code
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
Data Type
SREL References
Flags
id
Integer
Unique
producer_id
String 20
persistent_id
String 60
delete_flag
SREL
actbool.enum
Standard active indicator
Required
sym
String 40
Required
code
String 40
Required
last_mod_by
SREL
cnt.id
last_mod_date
DATE
description
String 40
tenant
SREL
cmth Object
The object details are as follows:
  1. Associated Table: Contact_Method
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: notification_reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
cm_template
cm_template
STRING
delete_flag
del
INTEGER
actbool enum
REQUIRED
id
id
INTEGER
UNIQUE REQUIRED KEY
last_mod_by
last_mod_by
UUID
ca_contact uuid
last_mod_dt
last_mod_dt
LOCAL_TIME
DATE ON_CI {NOW}
description
nx_desc
STRING (40)
producer_id
LOCAL STRING (20)
persistent_id
persid
STRING (30)
supports_smtp
supports_smtp
SREL
bool.enum
sym
sym
STRING
UNIQUE REQUIRED S_KEY
write_file
write_file
INTEGER
cnote Object
The object details are as follows:
  1. Associated Table: Note_Board
  2. Factories: default
  3. REL_ATTR: persistent_id
  4. Common Name: text
  5. Function Group: announcement
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
active
active_flag
INTEGER
bool_tab enum
REQUIRED
close_date
close_date
LOCAL_TIME
cnote_type
cnote_type
INTEGER
control_group
control_group
UUID
del
del
INTEGER
id
id
INTEGER
UNIQUE REQUIRED KEY
internal
internal
INTEGER
location
loc_id
UUID
ca_location location_uuid
organization
organization
UUID
ca_organization uuid
persistent_id
persid
STRING
posted_by
posted_by
UUID
ca_contact uuid
posted_date
posted_date
LOCAL_TIME
text
text
STRING
cnt Object
The object details are as follows:
  1. Associated Table: ca_contact, usp_contact
  2. Factories: default, agt, cst, grp
  3. REL_ATTR: id
  4. Common Name: combo_name
  5. Function Group: contact
  6. ca_contact Table
  7. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
access_type
access_type
SREL
acctyp.id
admin_org
admin_organization_uuid
UUID
ca_organization uuid
alias
alias
STRING
alt_phone
alt_phone_ number
STRING
cnthandling_list
BREL
contact_handling
contact_num
alternate_ identifier
STRING
notes
comment
STRING
company
company_uuid
UUID
ca_company company_uuid
type
contact_type
integer
ca_contact_type id
id
contact_uuid
UUID
UNIQUE REQUIRED KEY
billing_code
cost_center
INTEGER
ca_resource_cost_center id
creation_date
creation_date
LOCAL_TIME
creation_user
creation_user
STRING
delete_time
delete_time
LOCAL_TIME
dept
department
INTEGER
ca_resource_department id
email_address
email_address
STRING
exclude_ registration
exclude_ registration
integer
fax_phone
fax_number
STRING
first_name
first_name
STRING
floor_location
floor_location
STRING
delete_flag
inactive
integer
actbool enum
job_function
job_function
integer
position
job_title
integer
ca_job_title id
last_name
last_name
STRING
last_mod
last_update_date
LOCAL_TIME
last_mod_by
last_update_user
STRING
location
location_uuid
UUID
ca_location location_uuid
mail_stop
mail_stop
STRING
middle_name
middle_name
STRING
mobile_phone
mobile_phone_ number
STRING
organization
organization_ uuid
UUID
ca_organization uuid
pemail_address
pager_email_ address
STRING
beeper_phone
pager_number
STRING
phone_number
pri_phone_ number
STRING
roles
roles
LIST
room_location
room_location
STRING
supervisor_ contact_uuid
supervisor_ contact_uuid
UUID
ca_contact uuid
userid
userid
STRING
version_number
version_number
integer
cnt_role Object
The object details are as follows:
  1. Associated Table: usp_cnt_role
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: id
  5. Function Group: security
  6. REST Operations: CREATE READ UPDATE
Attributes
Data Type
Related Object
Flags
id
INTEGER
UNIQUE
contact
SREL
cnt
role_obj
SREL
role
is_default
INTEGER
last_mod_dt
DATE
cost_cntr Object
The object details are as follows:
  1. Associated Table: ca_resource_cost_center
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: name
  5. Function Group: inventory
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
description
description
STRING
creation_date
creation_date
LOCAL_TIME
creation_user
creation_user
STRING
delete_time
delete_time
LOCAL_TIME
exclude_registration
exclude_registration
integer
id
id
INTEGER
UNIQUE REQUIRED KEY
delete_flag
inactive
integer
actbool enum
last_mod
last_update_date
LOCAL_TIME
last_update_user
last_update_user
STRING
name
name
STRING
version_number
version_number
integer
country Object
The object details are as follows:
  1. Associated Table: ca_country
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: name
  5. Function Group: inventory
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
creation_date
creation_date
LOCAL_TIME
creation_user
creation_user
STRING
description
description
STRING
id
id
INTEGER
UNIQUE REQUIRED KEY
delete_flag
inactive
integer
actbool enum
last_mod
last_update_date
LOCAL_TIME
last_update_user
last_update_user
STRING
name
name
STRING
version_number
version_number
integer
cr Object
The object details are as follows:
Associated Table: Call_Req
Factories: default
REL_ATTR: persistent_id
Common Name: ref_num
Function Group: call_mgr
REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
description
description
STRING
active
active_flag
INTEGER
bool_tab enum
REQUIRED
active_prev
LOCAL
SREL
bool.enum
affected_ resource
affected_rc
UUID
ca_owned_ resource uuid
assignee
assignee
UUID
assignee_prev
LOCAL
SREL
agt.id
call_back_date
call_back_date
LOCAL_ TIME
call_back_flag
call_back_flag
INTEGER
category
category
STRING
prob_ctg persid
category_prev
LOCAL
SREL
pcat.persistent_id
caused_by_chg
caused_by_chg
SREL
chg.id
change
change
INTEGER
chg id
charge_back_id
charge_back_ id
STRING
close_date
close_date
LOCAL_ TIME
cr_tticket
cr_tticket
INTEGER
created_via
created_via
INTEGER
interface id
customer
customer
UUID
ca_contact uuid
REQUIRED
event_token
event_token
STRING
external_system_ticket
STRING (4000)
extern_ref
extern_ref
STRING
group
group_id
UUID
group_prev
LOCAL
SREL
grp.id
id
id
INTEGER
UNIQUE REQUIRED KEY
impact
impact
INTEGER
impact enum
impact_prev
LOCAL
SREL
imp.enum
incident_priority
incident_priority
INTEGER
incorrectly_assigned
SREL
actbool
last_act_id
last_act_id
STRING
last_mod_dt
last_mod_dt
LOCAL_TIME
log_agent
log_agent
UUID
ca_contact uuid
REQUIRED
macro_ predicted_ violation
macro_predict_ viol
INTEGER
major_incident
SREL
actbool
open_date
open_date
LOCAL_ TIME
org
orig_user_admin_org
SREL
org
orig_user_cost_center
SREL
cost_cntr
orig_user_dept
SREL
dept
orig_user_organization
SREL
org
outage_detail_what
STRING (4000)
outage_detail_who
STRING (4000)
outage_detail_why
STRING (4000)
outage_end_time
outage_end_time
LOCAL_TIME
outage_reason
SREL
outage_reason
outage_start _time
outage_start _time
LOCAL_TIME
outage_type
SREL
outage_type
parent
parent
STRING
call_req persid
pct_service_restored
INTEGER
persistent_id
persid
STRING
predicted_sla_violation
predicted_sla_viol
INTEGER
priority
priority
INTEGER
pri enum
REQUIRED
priority_prev
LOCAL
SREL
pri.enum
problem
problem
STRING
ref_num
ref_num
STRING
UNIQUE REQUIRED S_KEY
remote_control_used
SREL
actbool
requested_by
SREL
cnt
resolvable_at_lower
SREL
actbool
resolve_date
resolve_date
LOCAL_ TIME
return_to_service
SREL
actbool
rootcause
rootcause
INTEGER
rootcause id
extern_token
sched_token
STRING
severity
severity
INTEGER
sevrty enum
severity_prev
LOCAL
SREL
sev.enum
sla_violation
sla_violation
INTEGER
base_template
solution
STRING
call_req persid
status
status
STRING
cr_stat code
status_prev
LOCAL
SREL
crs.code
string1
string1
STRING
string2
string2
STRING
string3
string3
STRING
string4
string4
STRING
string5
string5
STRING
string6
string6
STRING
children
QREL
cr
sla_events
QREL
tev
attached_slas
BREL
attached_sla._mapped_cr
add_sla_persids
add_sla_persids
STRING
site_sla_attrs
site_sla_attrs
STRING
audit_userid
audit_userid
SREL
cnt.id
fldchange_log
fldchange_log
STRING
affected_service
affected_service
SREL
nr
init_urg
LOCAL INTEGER
init_imp
LOCAL INTEGER
cap_reason
LOCAL STRING
auto_urg
LOCAL INTEGER
auto_imp
LOCAL INTEGER
man_urg
LOCAL INTEGER
man_imp
LOCAL INTEGER
summary
summary
STRING
support_lev
support_lev
STRING
srv_desc code
symptom_code
SREL
symptom_code
template_name
template_name
STRING
cr_template template_name
time_spent_ sum
time_spent_ sum
DURATION
type
type
STRING
crt code
urgency
urgency
INTEGER
urgncy enum
urgency_prev
LOCAL
SREL
urg.enum
target_times
target_times
BREL
tgt_time_mapped_cr
target_start_last
target_start_last
DATE
target_hold_last
target_hold_last
DATE
target_hold_count
target_hold_count
INTEGER
target_resolved_last
target_resolved_last
DATE
target_resolved_count
target_resolved_count
INTEGER
target_closed_last
target_closed_last
DATE
target_closed_count
target_closed_count
INTEGER
close_date_prev
close_date_prev
LOCAL DATE
resolve_date_prev
resolve_date_prev
LOCAL DATE
target_hold_count_prev
target_hold_count_prev
INTEGER
target_resolved_count_prev
target_resolved_count
_prev
LOCAL INTEGER
target_closed_count_prev
target_closed_count_prev
LOCAL INTEGER
tgt_time_mapped_iss
lr Object
The object details are as follows:
  1. Associated Table: Notify_Log_Header
  2. Factories: default
  3. REL_ATTR: persistent_id
  4. Common Name: msg_hdr
  5. Function Group: notify
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
cmth_used
cmth_used
INTEGER
ct_mth id
cntxt_obj
cntxt_obj
STRING
delete_flag
del
INTEGER
actbool enum
REQUIRED
id
id
INTEGER
UNIQUE REQUIRED KEY
last_mod
last_mod
LOCAL_TIME
nlh_ack_by
nlh_ack_by
LOCAL_TIME
ack_time
nlh_ack_time
DURATION
contact
nlh_c_addressee
UUID
ca_contact uuid
nlh_c_alias
nlh_c_alias
UUID
notify_method
nlh_cm_method
INTEGER
noturg enum
email_address
nlh_email
STRING
end_date
nlh_end
LOCAL_TIME
msg_hdr
nlh_hdr
STRING
msg_text
nlh_msg
STRING
msg_html
nlh_msg_html
STRING
pri_event
nlh_pri
INTEGER
start_date
nlh_start
LOCAL_TIME
REQUIRED
status
nlh_status
INTEGER
activity_notify
nlh_transition
INTEGER
notify_type
nlh_type
INTEGER
msg_ack
nlh_user_ack
STRING
symptom_code Object
The object details are as follows:
  1. Associated Table: usp_symptom_code
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Field
Data type
Reference
Flags
delete_flag
SREL
actbool.enum
ON_NEW
description
STRING (4000)
id
INTEGER UNIQUE
producer_id
LOCAL STRING (20)
persistent_id
LOCAL STRING (60)
last_mod_by
SREL
cnt
ON_NEW {USER}
ON_CI {USER}
last_mod_dt
DATE
ON_CI {NOW}
sym
STRING 60
state Object
The object details are as follows:
  1. Associated Table: ca_state_province
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
description
description
STRING
creation_date
creation_date
LOCAL_TIME
creation_user
creation_user
STRING
delete_time
delete_time
LOCAL_TIME
exclude_registration
exclude_registration
integer
id
id
INTEGER
UNIQUE REQUIRED KEY
delete_flag
inactive
integer
actbool enum
last_mod_dt
last_update_date
LOCAL_TIME
last_mod_by
last_update_user
STRING
sym
symbol
STRING
version_number
version_number
integer
crt Object
The object details are as follows:
  1. Associated Table: Call_Req_Type
  2. Factories: default
  3. REL_ATTR: code
  4. Common Name: sym
  5. Function Group: call_mgr_reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
code
code
nvarchar(10)
UNIQUE REQUIRED S_KEY
delete_flag
del
INTEGER
actbool enum
REQUIRED
display_name
display_name
nvarchar 30
id
id
INTEGER
UNIQUE REQUIRED KEY
description
nx_desc
nvarchar 30
persistent_id
persid
nvarchar 30
sym
sym
nvarchar 30
REQUIRED
ctab Object
The object details are as follows:
  1. Associated Table: Controlled_Table
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
delete_flag
del
INTEGER
actbool enum
REQUIRED
id
id
INTEGER
UNIQUE REQUIRED KEY
desc
nx_desc
nvarchar(40)
obj_name
obj_name
nvarchar 30
persistent_id
persid
nvarchar 30
sym
sym
nvarchar 30
UNIQUE REQUIRED S_KEY
ctimer Object
The object details are as follows:
  1. Associated Table: Cr_Call_Timers
  2. Factories: default
  3. REL_ATTR: persistent_id
  4. Common Name: color
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
beep
beep
INTEGER
color
color
STRING
delete_flag
del
INTEGER
actbool enum
REQUIRED
id
id
INTEGER
UNIQUE REQUIRED KEY
last_mod_by
last_mod_by
UUID
ca_contact uuid
last_mod_dt
last_mod_dt
LOCAL_TIME
persistent_id
persid
STRING
text
text
STRING
threshold
threshold
DURATION
REQUIRED
ctp Object
The object details are as follows:
  1. Associated Table: ca_contact_type
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
creation_date
creation_date
LOCAL_TIME
creation_user
creation_user
STRING
delete_time
delete_time
LOCAL_TIME
description
description
STRING
exclude_registration
exclude_registration
integer
id
id
INTEGER
UNIQUE REQUIRED KEY
delete_flag
inactive
integer
actbool enum
last_mod_dt
last_update_date
LOCAL_TIME
last_mod_by
last_update_user
STRING
sym
name
STRING
user_uuid
user_uuid
UUID
ca_contact uuid
version_number
version_number
integer
view_internal
view_internal
integer
dblocks Object
The object details are as follows:
  1. Associated Table: Virtual internal table
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: Id
  5. Function Group: dblock
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
name
STRING 0
table_name
STRING 0
factory_name
SREL
prod_list.sym
lock_hash
INTEGER
lock_uuid
UUID
lock_string
STRING 0
lock_owner
STRING 0
when_taken
DATE
process
STRING 0
request
INTEGER
delete_flag
SREL
actbool.enum
dcon Object
The object details are as follows:
  1. Associated Table: Domain_Constraint
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: constraint_majic
  5. Function Group: security
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
id
id
INTEGER
UNIQUE REQUIRED KEY
persistent_id
persid
STRING
REQUIRED
delete_flag
del
INTEGER
actbool enum
REQUIRED
alias
alias
INTEGER
last_mod_dt
last_mod_dt
LOCAL_TIME
last_mod_by
last_mod_by
STRING
ca_contact uuid
REQUIRED
dom_id
dom_id
INTEGER
Domain id
REQUIRED
tbl_id
tbl_id
INTEGER
Controlled_Table id
REQUIRED
type
type
INTEGER
Domain_Constraint_Type
REQUIRED
error_msg
error_msg
STRING
enum
constraint_majic
constraint_majic
STRING
constraint_SQL
constraint_sql
STRING
dcon_typ Object
The object details are as follows:
  1. Associated Table: Domain_Constraint_Type
  2. Factories: default
  3. REL_ATTR: enum
  4. Common Name: sym
  5. Function Group: security
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
delete_flag
del
INTEGER
actbool enum
REQUIRED
enum
enum
INTEGER
REQUIRED
id
id
INTEGER
UNIQUE REQUIRED KEY
description
nx_desc
nvarchar(40)
persistent_id
persid
nvarchar 30
sym
sym
nvarchar(12)
UNIQUE REQUIRED S_KEY
dept Object
The object details are as follows:
  1. Associated Table: ca_resource_department
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: name
  5. Function Group: inventory
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
description
description
STRING
creation_date
creation_date
LOCAL_TIME
creation_user
creation_user
STRING
delete_time
delete_time
LOCAL_TIME
exclude_registration
exclude_registration
integer
id
id
INTEGER
UNIQUE REQUIRED KEY
delete_flag
inactive
integer
actbool enum
last_mod
last_update_date
LOCAL_TIME
last_update_user
last_update_user
STRING
name
name
STRING
version_number
version_number
integer
dlgsrvr Object
The object details are as follows:
  1. Associated Table: Delegation_Server
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
anon_userid
anon_userid
STRING
appl_addr
appl_addr
STRING
default_assignee
default_assignee
UUID
ca_contact uuid
default_userid
default_userid
STRING
delete_flag
del
INTEGER
actbool enum
REQUIRED
id
id
INTEGER
UNIQUE REQUIRED KEY
metafile
metafile
STRING
description
nx_desc
STRING
password
password
STRING
server
server
STRING
sym
sym
STRING
UNIQUE REQUIRED S_KEY
transport
transport
INTEGER
dmn Object
The object details are as follows:
  1. Associated Table: Domain
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: security
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
delete_flag
del
INTEGER
actbool enum
REQUIRED
id
id
INTEGER
UNIQUE REQUIRED KEY
last_mod_by
last_mod_by
UUID
ca_contact uuid
last_mod
last_mod_dt
LOCAL_TIME
desc
nx_desc
STRING
persistent_id
persid
STRING
sym
sym
STRING
UNIQUE REQUIRED S_KEY
doc_rep Object
The object details are as follows:
  1. Associated Table: Document_Repository
  2. Factories: default
  3. REL_ATTR: persistent_id
  4. Common Name: sym
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
description
description
STRING
archive_path
archive_path
STRING
archive_type
archive_type
INTEGER
cgi_path
cgi_path
STRING
default_rep
default_rep
INTEGER
delete_flag
del
INTEGER
actbool enum
REQUIRED
file_limit_size
file_limit_size
INTEGER
id
id
INTEGER
UNIQUE REQUIRED KEY
last_mod_by
last_mod_by
UUID
ca_contact uuid
last_mod_dt
last_mod_dt
LOCAL_TIME
persistent_id
persid
STRING
prohibited_file_ext
prohibited_ext
STRING
protocol
protocol
STRING
repository_type
repository_type
INTEGER
retrieve_path
retrieve_path
STRING
server
server
STRING
servlet_path
servlet_path
STRING
sym
sym
STRING
REQUIRED S_KEY
upload_path
upload_path
STRING
ext_entity_map Object
The object details are as follows:
  1. Associated Table: External_Entity_Map
  2. Factories: default, sd_chg_map
  3. REL_ATTR: persistent_id
  4. Common Name: xschema_code
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
id
id
INTEGER
UNIQUE REQUIRED KEY
int1_rsrved
int1_rsrved
INTEGER
int2_rsrved
int2_rsrved
INTEGER
int3_rsrved
int3_rsrved
INTEGER
int4_rsrved
int4_rsrved
INTEGER
int5_rsrved
int5_rsrved
INTEGER
int6_rsrved
int6_rsrved
INTEGER
lstr1_rsrved
lstr1_rsrved
STRING
lstr2_rsrved
lstr2_rsrved
STRING
ob_persid
ob_persid
STRING
ob_type
ob_type
STRING
persistent_id
persid
STRING
str1_rsrved
str1_rsrved
STRING
str2_rsrved
str2_rsrved
STRING
xentity_id
xentity_id
STRING
REQUIRED
xschema_code
xschema_code
STRING
REQUIRED
xschema_ver
xschema_ver
INTEGER
REQUIRED
fmgrp Object
The object details are as follows:
  1. Associated Table: Form_Group
  2. Factories: default, all_fmgrp
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
description
description
STRING
delete_flag
del
INTEGER
actbool enum
REQUIRED
id
id
INTEGER
UNIQUE REQUIRED KEY
last_mod_by
last_mod_by
UUID
ca_contact uuid
last_mod_dt
last_mod_dt
LOCAL_TIME
sym
sym
STRING
REQUIRED S_KEY
gl_code Object
The object details are as follows:
  1. Associated Table: ca_resource_gl_code
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: name
  5. Function Group: inventory
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
description
description
STRING
creation_date
creation_date
LOCAL_TIME
creation_user
creation_user
STRING
delete_time
delete_time
LOCAL_TIME
exclude_ registration
exclude_ registration
integer
id
id
INTEGER
UNIQUE REQUIRED KEY
delete_flag
inactive
integer
actbool enum
last_mod
last_update_date
LOCAL_TIME
last_update_user
last_update_user
STRING
name
name
STRING
version_number
version_number
integer
grc Object
The object details are as follows:
  1. Associated Table: ca_resource_class
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: type
  5. Function Group: inventory
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
description
description
STRING
creation_date
creation_date
LOCAL_TIME
creation_user
creation_user
STRING
delete_time
delete_time
LOCAL_TIME
exclude_ registration
exclude_ registration
integer
family
family_id
INTEGER
ca_resource_ family id
id
id
INTEGER
UNIQUE REQUIRED KEY
delete_flag
inactive
integer
actbool enum
last_mod
last_update_date
LOCAL_TIME
last_update_user
last_update_user
STRING
type
name
STRING
parent_id
parent_id
SREL
nsm_class
usp_nsm_class
INTEGER
buscls id
version_number
version_number
integer
grpmem Object
The object details are as follows:
  1. Associated Table: Group_Member
  2. Factories: default
  3. REL_ATTR: persistent_id
  4. Common Name:
  5. Function Group:
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
group
group_id
UUID
REQUIRED
id
id
INTEGER
UNIQUE REQUIRED KEY
manager_flag
manager_flag
INTEGER
member
member
UUID
ca_contact uuid
REQUIRED
notify_flag
notify_flag
INTEGER
hier Object
The object details are as follows:
  1. Associated Table: Asset_Assignment
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: license_num
  5. Function Group: inventory
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
child
hier_child
byte(16)
ca_owned_ resource uuid
REQUIRED S_KEY
license_num
hier_license_num
nvarchar(40)
log_date
hier_log_date
INTEGER
REQUIRED
parent
hier_parent
byte(16)
ca_owned_ resource uuid
REQUIRED S_KEY
id
id
INTEGER
UNIQUE REQUIRED KEY
last_mod_by
last_mod_by
byte(16)
ca_contact uuid
last_mod_dt
last_mod_dt
INTEGER
persistent_id
persid
nvarchar(30)
ical_alarm Object
The object details are as follows:
  1. Associated Table: usp_ical_alarm
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
Data Type
Remarks
sym
STRING
Required
alarm_value
STRING
ical_event_template Object
The object details are as follows:
  1. Associated Table: usp_ical_event_template
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
Data Type
Remarks
code
STRING
Required
sym
INTEGER
Required
alarm
SREL ical_alarm
start_date
STRING
end_date
STRING
obj_type
SREL actlog_prod_list
categories
STRING
summary
STRING
description
STRING
url
STRING
extra_entries
STRING
imp Object
The object details are as follows:
  1. Associated Table: Impact
  2. Factories: default
  3. REL_ATTR: enum
  4. Common Name: sym
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
delete_flag
del
INTEGER
actbool enum
REQUIRED
enum
enum
INTEGER
REQUIRED
id
id
INTEGER
UNIQUE REQUIRED KEY
last_mod_by
last_mod_by
UUID
ca_contact uuid
last_mod_dt
last_mod_dt
LOCAL_TIME
description
nx_desc
STRING
sym
sym
STRING
UNIQUE REQUIRED S_KEY
value
value
INTEGER
in Object
The object details are as follows:
  1. Associated Table: Call_Req
  2. Factories: default
  3. REL_ATTR: persistent_id
  4. Common Name: ref_num
Attribute
DB Field
Data Type
SREL References
Flags
description
description
STRING
active
active_flag
INTEGER
bool_tab enum
REQUIRED
active_prev
LOCAL
SREL
bool.enum
affected_ resource
affected_rc
UUID
ca_owned_ resource uuid
assignee
assignee
UUID
assignee_prev
LOCAL
SREL
agt.id
call_back_date
call_back_date
LOCAL_TIME
call_back_flag
call_back_flag
INTEGER
category
category
STRING
prob_ctg persid
category_prev
LOCAL
SREL
pcat.persistent_id
caused_by_chg
caused_by_chg
SREL
chg.id
change
change
INTEGER
chg id
charge_back_id
charge_back_id
STRING
close_date
close_date
LOCAL_TIME
cr_tticket
cr_tticket
INTEGER
created_via
created_via
INTEGER
interface id
customer
customer
UUID
ca_contact uuid
REQUIRED
event_token
event_token
STRING
extern_ref
extern_ref
STRING
group
group_id
UUID
group_prev
LOCAL
SREL
grp.id
id
id
INTEGER
UNIQUE REQUIRED KEY
impact
impact
INTEGER
impact enum
impact_prev
LOCAL
SREL
imp.enum
incident_priority
incident_priority
INTEGER
last_act_id
last_act_id
STRING
last_mod_dt
last_mod_dt
LOCAL_TIME
log_agent
log_agent
UUID
ca_contact uuid
REQUIRED
macro_ predicted_ violation
macro_predict_ viol
INTEGER
open_date
open_date
LOCAL_TIME
outage_end_ time
outage_end_ time
LOCAL_TIME
outage_start_ time
outage_start_ time
LOCAL_TIME
parent
parent
STRING
call_req persid
persistent_id
persid
STRING
predicted_sla_ violation
predicted_sla_ viol
INTEGER
priority
priority
INTEGER
pri enum
REQUIRED
priority_prev
LOCAL
SREL
pri.enum
problem
problem
STRING
ref_num
ref_num
STRING
UNIQUE REQUIRED S_KEY
resolve_date
resolve_date
LOCAL_ TIME
rootcause
rootcause
INTEGER
rootcause id
extern_token
sched_token
STRING
severity
severity
INTEGER
sevrty enum
severity_prev
LOCAL
SREL
sev.enum
sla_violation
sla_violation
INTEGER
base_template
solution
STRING
call_req persid
status
status
STRING
cr_stat code
status_prev
LOCAL
SREL
crs.code
string1
string1
STRING
string2
string2
STRING
string3
string3
STRING
string4
string4
STRING
string5
string5
STRING
string6
string6
STRING
summary
summary
STRING
support_lev
support_lev
STRING
srv_desc code
template_name
template_name
STRING
cr_template template_name
time_spent_ sum
time_spent_ sum
DURATION
type
type
STRING
crt code
urgency
urgency
INTEGER
urgncy enum
urgency_prev
LOCAL
SREL
urg.enum
in_trans Object
The object details are as follows:
  1. Associated Tables: in_trans
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: condition_error
  5. Function Group: call_mgr_reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
status
status
STRING
crs
Specifies the current ticket status.
new_status
new status
STRING
crs
Specifies the new ticket status.
is default
INTEGER
Default transition that appears when the Status field is empty.
On new default: 0
must_comment
INTEGER
Comment required when using a transition.
On new default: 0
delete_flag
del
actbool
Required.
On new default: 0
condition
macro
Site condition macro to approve transition.
condition_error
STRING
Error message for site condition.
description
STRING
Description of this transition.
last_mod_by
cnt
On new default user;
on CI set user
last_mod_dt
DATE
On CI set user now
INDEX_DOC_LINKS Object
The object details are as follows:
  1. Associated Table: INDEX_DOC_LINKS
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: RELATIONAL_ID
  5. Function Group:
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SRE References
Flags
Document ID
DOC_ID
INTEGER
SKELETONS id
id
ID
INTEGER
REQUIRED KEY
Category ID
INDEX_ID
INTEGER
O_INDEXES id
Last Modified Date
LAST_MOD_DT
LOCAL_TIME
Relational ID
RELATIONAL_ID
STRING
intfc Object
The object details are as follows:
  1. Associated Table: Interface
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: sym
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
code
code
STRING
UNIQUE REQUIRED
delete_flag
del
INTEGER
actbool enum
REQUIRED
id
id
INTEGER
UNIQUE KEY
last_mod_by
last_mod_by
UUID
ca_contact uuid
last_mod_dt
last_mod_dt
LOCAL_TIME
desc
nx_desc
STRING
persistent_id
persid
STRING
sym
sym
STRING
UNIQUE REQUIRED
job_func Object
The object details are as follows:
  1. Associated Table: ca_job_function
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: name
  5. Function Group: inventory
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
creation_date
creation_date
LOCAL_TIME
creation_user
creation_user
STRING
delete_time
delete_time
LOCAL_TIME
description
description
STRING
exclude_ registration
exclude_ registration
integer
id
id
INTEGER
UNIQUE REQUIRED KEY
delete_flag
inactive
integer
actbool enum
last_mod
last_update_date
LOCAL_TIME
last_update_user
last_update_user
STRING
name
name
STRING
version_number
version_number
integer
kc Object
The object details are as follows:
  1. Associated Table: usp_kpi
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: kpi_name
  5. Function Group: admin
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
kpi_name
name
STRING
REQUIRED
sys_name
sys_name
STRING
kpi_type
type
INTEGER
REQUIRED
delete_flag
status
actbool
REQUIRED
process_type
process_type
INTEGER
stored_query_id
stored_query_id
STRING
crsq
user_context
user_context
UUID
cnt
sql_query
sql_query
STRING
description
description
STRING
refresh_time
refresh_time
INTEGER
REQUIRED
metric_type
metric_type
INTEGER
REQUIRED
curr_kpi_time_ stamp
curr_kpi_time_ stamp
INTEGER
version_number
version_number
INTEGER
tenant
tenant
STRING
last_mod_by
last_mod_by
UUID
cnt
last_mod_dt
last_mod_dt
DATE
KCAT Object
The object details are as follows:
  1. Associated Table: O_INDEXES
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: CAPTION
  5. Function Group:
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
DESCRIPTION
DESCRIPTION
STRING
AUTHOR_ID
AUTHOR_ID
UUID
ca_contact uuid
CAPTION
CAPTION
STRING
REQUIRED
DOC_TEMPLATE
DOC_TEMPLATE
INTEGER
CI_DOC_ TEMPLATES id
HAS_CHILDREN
HAS_CHILDREN
INTEGER
HAS_DOCS
HAS_DOCS
INTEGER
id
ID
INTEGER
KEY
KEYWORDS
KEYWORDS
STRING
ON_COPY_PASTE
ON_COPY_PASTE
INTEGER
ON_CUT_PASTE
ON_CUT_PASTE
INTEGER
last_mod_dt
LAST_MOD_DT
LOCAL_TIME
Indicates the timestamp of when this record was last modified.
last_mod_by
LAST_MOD_BY
SREL
cnt
Specifies the UUID of the contact who modified this record.
OWNER_ID
OWNER_ID
UUID
ca_contact uuid
PARENT_ID
PARENT_ID
SREL
O_INDEXES id
ALLOW_QA
ALLOW_QA
INTEGER
PERMISSION_ INDEX_ID
PERMISSION_ INDEX_ID
INTEGER
O_INDEXES id
READ_PGROUP
READ_PGROUP
INTEGER
P_GROUPS id
persistent_id
persid
STRING
PGROUP TYPE
PGROUP_TYPE
INTEGER
Indicates if the P Groups is based on Roles or Groups:
1
-- Groups (Default)
2
-- Roles
producer_id
producer_id
STRING
RELATIONAL_ID
RELATIONAL_ID
STRING
SUBJECT_EXPERT_ID
SUBJECT_EXPERT_ID
UUID
ca_contact uuid
WF_TEMPLATE
WF_TEMPLATE
SREL
CI_WF_ TEMPLATES id
WRITE_PGROUP
WRITE_PGROUP
INTEGER
P_GROUPS id
kcd Object
The object details are as follows:
  1. Associated Table: usp_kpi_data
  2. Factories: default
  3. REL_ATTR: id
  4. Function Group: admin
  5. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
kpi_id
kpi_id
INTEGER
kc
kpi_time_ stamp
kpi_time_ stamp
DATE
metric_type
type
INTEGER
REQUIRED
kpi_value
kpi_value
INTEGER
REQUIRED
duration_count
duration_count
INTEGER
duration_sum
duration_sum
INTEGER
duration_max
duration_max
INTEGER
duration_ average
duration_ average
INTEGER
execute_time
execute_time
INTEGER
version_number
version_number
INTEGER
kdlinks Object
The object details are as follows:
  1. Associated Table: kdlinks
  2. Factories: default
  3. REL_ATTR: persistent_id
  4. Common Name: sd_obj_type
  5. Function Group:
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
Request Linked
cr
STRING
call_req persid
id
ID
INTEGER
KEY
Issue Linked
iss
STRING
issue persistent_id
Document
kd
INTEGER
SKELETONS id
Analyst
last_mod_by
UUID
ca_contact uuid
Last Modified Date
LAST_MOD_DT
LOCAL_TIME
Link Type
link_type
INTEGER
Ticket ID
sd_obj_id
INTEGER
Ticket Type
sd_obj_type
STRING
KT_REPORT_CARD Object
The object details are as follows:
  1. Associated Table: KT_REPORT_CARD
  2. Factories: default
  3. REL_ATTR: id
  4. Common Name: SUBJECT_ID
  5. Function Group: reference
  6. REST Operations: CREATE READ UPDATE
Attribute
DB Field
Data Type
SREL References
Flags
id
ID
INTEGER
KEY
SUBJECT_ID
SUBJECT_ID
nvarchar(40)
PAST_DAYS
PAST_DAYS
INTEGER
ORG_STATISTICS
ORG_STATISTICS
INTEGER
DOCUMENTS_ SUBMITTED
DOCUMENTS_ SUBMITTED
INTEGER
DOCUMENTS_ PUBLISHED
DOCUMENTS_ PUBLISHED
INTEGER
TOTAL_HITS
TOTAL_HITS
INTEGER
AVERAGE_ EFFECTIVENESS_ RATING
AVERAGE_ EFFECTIVENESS_ RATING
INTEGER
TOTAL_ SOLUTION_ COUNT
TOTAL_ SOLUTION_ COUNT
INTEGER
creation_user
creation_user
nvarchar(64)
creation_date
creation_date
INTEGER
last_update_user
last_update_user
nvarchar(64)
last_update_date
last_update_date
INTEGER
TOTAL_VOTES
TOTAL_VOTES
INTEGER
AVG_RATING
AVG_RATING
DOUBLE
USER_SLV_CNT
USER_SLV_CNT
INTEGER
LINKED_ KNOWLEDGE_BY_OTHERS
LINKED_ KNOWLEDGE_BY_OTHERS
INTEGER
LINKED_ KNOWLEGE_BY_ ME
LINKED_ KNOWLEGE_BY_ ME
INTEGER
CLOSED_TICKETS
CLOSED_TICKETS
INTEGER
TICKETS_WITH_ KNOWLEDGE
TICKETS_WITH_ KNOWLEDGE
INTEGER
TICKETS_HAD_ SEARCH_ ACTIVITIES
TICKETS_HAD_ SEARCH_ ACTIVITIES
INTEGER
KNOWLEDGE_ SUBMIT_FROM_ TICKET
KNOWLEDGE_ SUBMIT_FROM_ TICKET
INTEGER
TIME_TO_PUBLISH
TIME_TO_PUBLISH
INTEGER
MY_COMMENTS
MY_COMMENTS
INTEGER
DOCUMENTS_ RETIRED
DOCUMENTS_ RETIRED
INTEGER
TIME_TO_FIX
TIME_TO_FIX
INTEGER
FLAGS_FIXED
FLAGS_FIXED
INTEGER
COMMENTS_ON_MY_DOCUMENTS
COMMENTS_ON_MY_DOCUMENTS
INTEGER
FIRST_CALL_RES_ WITH_KNOW
FIRST_CALL_RES_ WITH_KNOW
INTEGER
FIRST_CALL_RES_ WITHOUT_KNOW
FIRST_CALL_RES_ WITHOUT_KNOW
INTEGER
CONTRIBUTOR_ UUID
CONTRIBUTOR_ UUID
SREL
cnt
TENANCY_ UNRESTRICTED
IS_SUPERVISOR
IS_SUPERVISOR
INTEGER
SUPERVISOR_ID
SUPERVISOR_ID
SREL
cnt
TENANCY_ UNRESTRICTED
MY_ORG_REF_ID
MY_ORG_REF_ID
SREL
KT_REPORT_CARD
PAST_DAYS_TEXT
PAST_DAYS_TEXT
nvarchar(20)
Populates from the resource file.
LAST_MOD_DT_ TEXT
LAST_MOD_DT_ TEXT
nvarchar(20)
Specifies the KRC calculation date.
DOCUMENTS_ PUBLISHED_ PERCENT
DOCUMENTS_ PUBLISHED_ PERCENT
nvarchar(4)
AVG_HITS
AVG_HITS
nvarchar(20)
AVG_RATING_ TEXT
AVG_RATING_ TEXT
nvarchar(100)
last_mod_dt
last_mod_dt
DATE
last_mod_by
last_mod_by
SREL
cnt
ktd Object
The object details are as follows: