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.

casm1401

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:

Associated Table: Attached_SLA

Factories: default, ttv_slas

REL_ATTR: id

Common Name: ticket_type

Function Group:

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:

Associated Tables: dependent_control and usp_attr_control

Factories: default

REL_ATTR: id

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:

Associated Table: usp_auto_close

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: admin

Tenant: optional

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:

Associated Table: Act_Type

Factories: default, chgaty, craty, issaty, mgsaty

REL_ATTR: code

Common Name: sym

Function Group: admin

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:

Associated Table: Audit_Log

Factories: default

REL_ATTR: code

Common Name: audobj_persid

Function Group: admin

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:

Associated Table: Behavior_Template

Factories: default

REL_ATTR: id

Common Name: description

Function Group: admin

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:

Associated Table: BU_TRANS

Factories: default

REL_ATTR: id

Common Name:

Function Group:

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:

Associated Table: admin_tree

Factories: default

REL_ATTR: id

Common Name: CAPTION

Function Group: reference

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:

Associated Table: Act_Log

Factories: default

REL_ATTR: persistent_id

Common Name: description

Function Group: call_mgr

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:

Associated Table: Am_Asset_Map

Factories: default

REL_ATTR: persistent_id

Common Name: dmuuid

Function Group:

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:

Associated Table: Archive_Purge_Rule

Factories: default

REL_ATTR: persistent_id

Common Name: name

Function Group: admin

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:

Associated Table: Attached_Events

Factories: default

REL_ATTR: persistent_id

Common Name: user_smag

Function Group: admin

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:

Associated Table: Atomic_Condition

Factories: default

REL_ATTR: id

Common Name: description

Function Group: admin

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:

Associated Table: Act_Type_Assoc

Factories: default

REL_ATTR: code

Common Name: sym

Function Group: admin

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:

Associated Table: ca_company

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: reference

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:

Associated Table: ca_tou

Factories: default

REL_ATTR: id

Common Name: name

Function Group: security

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:

Associated Table: usp_caextwf_instances

Factories: default

REL_ATTR: id

Common Name: procname

Function Group: reference

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:

Associated Table: usp_caextwf_start_forms

Factories: default

REL_ATTR: id

Common Name: procname

Function Group: reference

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:

Associated Table: usp_closure_code

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: reference

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:

Associated Table: Contact_Method

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: notification_reference

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:

Associated Table: Note_Board

Factories: default

REL_ATTR: persistent_id

Common Name: text

Function Group: announcement

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:

Associated Table: ca_contact, usp_contact

Factories: default, agt, cst, grp

REL_ATTR: id

Common Name: combo_name

Function Group: contact

ca_contact Table

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:

Associated Table: usp_cnt_role

Factories: default

REL_ATTR: id

Common Name: id

Function Group: security

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:

Associated Table: ca_resource_cost_center

Factories: default

REL_ATTR: id

Common Name: name

Function Group: inventory

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:

Associated Table: ca_country

Factories: default

REL_ATTR: id

Common Name: name

Function Group: inventory

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:

Associated Table: Notify_Log_Header

Factories: default

REL_ATTR: persistent_id

Common Name: msg_hdr

Function Group: notify

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:

Associated Table: usp_symptom_code

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: reference

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:

Associated Table: ca_state_province

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: reference

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:

Associated Table: Call_Req_Type

Factories: default

REL_ATTR: code

Common Name: sym

Function Group: call_mgr_reference

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:

Associated Table: Controlled_Table

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: admin

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:

Associated Table: Cr_Call_Timers

Factories: default

REL_ATTR: persistent_id

Common Name: color

Function Group: admin

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:

Associated Table: ca_contact_type

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: reference

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:

Associated Table: Virtual internal table

Factories: default

REL_ATTR: id

Common Name: Id

Function Group: dblock

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:

Associated Table: Domain_Constraint

Factories: default

REL_ATTR: id

Common Name: constraint_majic

Function Group: security

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:

Associated Table: Domain_Constraint_Type

Factories: default

REL_ATTR: enum

Common Name: sym

Function Group: security

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:

Associated Table: ca_resource_department

Factories: default

REL_ATTR: id

Common Name: name

Function Group: inventory

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:

Associated Table: Delegation_Server

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: reference

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:

Associated Table: Domain

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: security

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:

Associated Table: Document_Repository

Factories: default

REL_ATTR: persistent_id

Common Name: sym

Function Group: admin

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:

Associated Table: External_Entity_Map

Factories: default, sd_chg_map

REL_ATTR: persistent_id

Common Name: xschema_code

Function Group: reference

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:

Associated Table: Form_Group

Factories: default, all_fmgrp

REL_ATTR: id

Common Name: sym

Function Group: admin

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:

Associated Table: ca_resource_gl_code

Factories: default

REL_ATTR: id

Common Name: name

Function Group: inventory

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:

Associated Table: ca_resource_class

Factories: default

REL_ATTR: id

Common Name: type

Function Group: inventory

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:

Associated Table: Group_Member

Factories: default

REL_ATTR: persistent_id

Common Name:

Function Group:

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:

Associated Table: Asset_Assignment

Factories: default

REL_ATTR: id

Common Name: license_num

Function Group: inventory

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:

Associated Table: usp_ical_alarm

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: reference

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:

Associated Table: usp_ical_event_template

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: reference

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:

Associated Table: Impact

Factories: default

REL_ATTR: enum

Common Name: sym

Function Group: reference

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:

Associated Table: Call_Req

Factories: default

REL_ATTR: persistent_id

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:

Associated Tables: in_trans

Factories: default

REL_ATTR: id

Common Name: condition_error

Function Group: call_mgr_reference

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:

Associated Table: INDEX_DOC_LINKS

Factories: default

REL_ATTR: id

Common Name: RELATIONAL_ID

Function Group:

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:

Associated Table: Interface

Factories: default

REL_ATTR: id

Common Name: sym

Function Group: admin

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:

Associated Table: ca_job_function

Factories: default

REL_ATTR: id

Common Name: name

Function Group: inventory

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:

Associated Table: usp_kpi

Factories: default

REL_ATTR: id

Common Name: kpi_name

Function Group: admin

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:

Associated Table: O_INDEXES

Factories: default

REL_ATTR: id

Common Name: CAPTION

Function Group:

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

CA Service Management - 14.1

Objects and Attributes