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 |