CA Service Desk Manager R12.

5 Logical Data Model

cost_cntr
Cost Center
Isscat Service Desk Object Universe Name Data Type
Issue Category Lookup
Issalg name Name STRING(100)
Service Desk Object Universe Name Data Type
Issue Activity
prod
Service Desk Object Universe Name Data Type assignee Assignee UUID -> agt.id delete_flag Delete Flag INTEGER -> actbool.enum prp
Product dept chgalg
Department Change Activity Change Properties
analyst Analyst UUID -> cnt.id Service Desk delete_time Delete Time DATE
INTEGER -> Universe Name Data Type
caextwf_start_id Caextwf Start Id Object Service Desk Ob- Service Desk Object Universe Name Data Type
caextwf_sfrm.id Service Desk Object Universe Name Data Type Universe Name Data Type
STRING(30) -> ject
issue_id Issue Id Id ID Integer description Description STRING(240)
iss.persistent_id
INTEGER ->
…...
delete_flag Delete Flag creation_user Creation User STRING(64) analyst Analyst Uuid UUID-> cnt.id
type Type STRING(12) -> aty.code actbool.enum sym Symbol STRING(60) id Id INTEGER

id Id INTEGER tenant UUID -> tenant.id INTEGER -> change_id Change Id INTEGER -> chg.id label Label STRING(80)
group Group UUID -> grp.id delete_flag Delete Flag
actbool.enum
type Type STRING(12) -> aty.code last_mod_by Last Mod By Uuid UUID -> cnt.id
…..
description Description STRING(255)
last_mod_by Last Mod By UUID -> cnt.id rptmeth ……. last_mod_dt Last Mod Dt DATE
iss_prp
Issue Properties …...
Service Desk Object Universe Name Data Type …...
Iss ….
Service Desk Object Universe Name Data Type Issue Measures,Issue Group/Analyst,Issue Details Id INTEGER typecnt
Type of Contact
STRING(30) ->
owning_iss Owning Iss Service Desk Object Universe Name Data Type Sym String(60)
iss.persistent_id Service Desk Object Universe Name Data Type chgtype
required Required INTEGER -> bool.enum active Active Label INTEGER -> bool.enum Change Type
INTEGER -> INTEGER ->
delete_flag delete_flag Delete Flag
actbool.enum actbool.enum chg Service Desk Object Universe Name Data Type
validation_rule Validation Rule INTEGER -> prpval_rule.id affected_contact Affected Contact UUID -> cnt.id Change Close Date/Group/Analyst. Change Detail
id Id INTEGER INTEGER ->
last_mod_by UUID -> cnt.id delete_flag Delete Flag
actbool.enum
validation_type Validation Type INTEGER -> prpval_type.id iss_wf Service Desk
assignee Assignee UUID -> agt.id Universe Name Data Type
Issue Measures,Issue Work Flow last_mod_by Last Mod By Uuid UUID -> cnt.id Object description Description STRING(1000)
….. …..
Service Desk Object Universe Name Data Type id Id INTEGER
….. caextwf_instance_id Caextwf Instance ID INTEGER -> caextwf_inst.id last_mod_dt Last Mod Dt DATE chg_ref_num Chg Ref Num STRING(30)
asset Asset UUID -> nr.id last_mod_by UUID->cnt.id
category Category STRING(12) -> isscat.code INTEGER -> LOCAL STRING
sym Symbol STRING(60) active Active persistent_id Persistent Id
assignee Assignee UUID -> cnt.id Perscnt bool.enum (60)

created_via Created Via INTEGER -> intfc.id

Person Contacting sym Symbol STRING(60)
creator Creator UUID -> cnt.id …. affected_contact Affected Contact Uuid UUID-> cnt.id
Service Desk Object Universe Name Data Type …..
Issstat delete_flag Delete Flag INTEGER -> actbool.enum assignee Assignee Uuid UUID-> agt.id
Issue Status Lookup group Group UUID -> grp.id Id Id INTEGER
cab CAB Uuid UUID -> grp.id chgstat
Service Desk Object Universe Name Data Type done_by Done By UUID -> cnt.id Change Status
Sym Symbol STRING(60)
impact Impact INTEGER -> imp.enum INTEGER ->
delete_flag Delete Flag INTEGER -> actbool.enum cab_approval CAB Approval Service Desk Ob-
group Group UUID -> grp.id bool.enum Universe Name Data Type
ject
tenant UUID -> tenant.id
last_mod_by Last Mod By UUID-> cnt.id last_mod_by Last Mod By UUID -> cnt.id ….. caextwf_instance_i
Caextwf Instance Id
INTEGER ->
active Active INTEGER
d caextwf_inst.id
…... STRING(12) ->
code Code STRING(12)
tenant Tenant UUID -> tenant.id organization Organization UUID -> org.id category Category
chgcat.code INTEGER ->
delete_flag Delete Flag
actbool.enum
orig_user_dept Orig User Dept INTEGER -> dept.id INTEGER ->
... wf
chgtype Change Type
chgtype.id description Description STRING(500)
tskstat Change Measures,Change Workflow Task
orig_user_cost_center Orig User Cost Center INTEGER -> cost_cntr.id INTEGER -> clo- hold Hold INTEGER
Task Status closure_code Closure Code
Service Desk Object Universe Name Data Type sure_code.id
tskty …..
parent Parent UUID -> iss.persistent_id Service Desk Task Type
Universe Name Data Type actual_duration Actual Duration DURATION created_via Created Via INTEGER -> intfc.id
Object
person_contacting Person Contacting INTEGER -> perscnt.id Service Desk Object Universe Name Data Type asset Asset Uuid UUID -> nr.id
id Id INTEGER group Group Uuid UUID-> grp.id
Workflow_prod_list
priority Priority INTEGER -> pri.enum sym Symbol STRING(60) id Id INTEGER assignee Assignee Uuid UUID -> cnt.id
iss_trans INTEGER -> chg_trans
impact Impact
last_mod_by Last Mod By Uuid UUID -> cnt.id Service Desk Object Universe Name Data Type imp.enum
product Product INTEGER -> prod.id sym Symbol STRING(60) chg Chg INTEGER -> chg.id
INTEGER ->
……..
last_mod_by Last Mod By Uuid UUID -> cnt.id group STRING(0) Service Desk Object Universe Name Data Type
delete_flag Delete Flag
Service Desk Object Universe Name Data Type log_agent Reported By UUID -> cnt.id actbool.enum
tenant Tenant Uuid UUID -> tenant.id id INTEGER STRING(30) ->
tenant Tenant Uuid UUID -> tenant.id condition
macro.persistent_id
STRING(30) -> INTEGER ->
condition …... delete_flag Delete Flag name STRING(0)
macro.persistent_id reporting_method Reporting Method INTEGER -> rptmeth.id actbool.enum condition_error STRING(255)

sym STRING(0) INTEGER ->

delete_flag INTEGER -> actbool.enum …... delete_flag
requestor Requestor UUID -> cnt.id attached_sla actbool.enum
Attached Service Type ...
description STRING(255)
last_mod_by UUID-> cnt.id rootcause Rootcause INTEGER -> rc.id
Service Desk chgcat id INTEGER
Universe Name Data Type
status Status STRING(12) -> issstat.code
Object Change Category
new_status STRING(12) -> issstat.code is_default INTEGER
INTEGER -> Service Desk Ob-
delete_flag Delete Flag Universe Name Data Type last_mod_by UUID-> cnt.id
STRING(30) -> actbool.enum ject
support_lev Support Lev
no_contract_sdsc.code
status STRING(12) -> issstat.code last_mod_by Last Mod By Uuid UUID -> cnt.id tgt_time assignee Assignee Uuid UUID--> agt.id last_mod_dt DATE
Target Time
STRING(30) -> _mapped_chg Mapped Chg INTEGER -> chg.id must_comment INTEGER
template_name Template Name cab CAB Uuid UUID--> grp.id
... iss_tpl.template_name
STRING(30) -> persis- Service Desk Object Universe Name Data Type
Service Desk Ob-
Universe Name Data Type new_status STRING(12) -> code
_mapped_cr Mapped Cr ject
tent_id INTEGER ->
caextwf_start_id Caextwf Start Id status STRING(12) -> code
type_of_contact Type Of Contact INTEGER -> typecnt.id INTEGER -> caextwf_sfrm.id
STRING(30) -> delete_flag Delete Flag actbool.enum
last_mod_dt Last Mod Dt DATE
_mapped_iss Mapped Iss tenant UUID -> tenant.id
iss.persistent_id chgtype Change Type INTEGER -> chgtype.id
mapped_chg Mapped Chg UUID-> chg.id last_mod_by UUID -> cnt.id ……..
….. _mapped_iss_wf Mapped Iss Wf INTEGER -> iss_wf.id
delete_flag Delete Flag INTEGER -> actbool.enum
STRING(30) -> STRING(0) ->
KCAT _mapped_wf Mapped Wf INTEGER -> wf.id mapped_cr Mapped Cr cr.persistent_id
object_type Object Type event_prod_list.sym
Knowledge Category …..
STRING(30) -> STRING(30) -> STRING(30) ->
map_sdsc Map Sdsc mapped_iss Mapped Iss iss.persistent_id
service_type Service Type sdsc.code
sdsc.code
Service Desk Object Universe Name Data Type
svy_qtpl
ttv_event Ttv Event
STRING(30) -> persis- …...
AUTHOR_ID Author UUID -> cnt.id tent_id
svy_tpl Universe
Service Desk Object Data Type
…... Name
CR_CAT Cr Cat STRING(30) -> pcat.persistent_id
Universe owning_survey INTEGER -> svy_tpl.id
Service Desk Object Data Type
Name
INTEGER -> last_mod_by UUID -> cnt.id
DOC_TEMPLATE Doc Template
CI_DOC_TEMPLATES.id id INTEGER
Lrel_asset_chgnr
Linked Relationship Type sequence INTEGER
evt
ISS_CAT Iss Cat STRING(12) -> isscat.code sdsc atev sym STRING(60)
ttv_slas Service Desk Object Universe Name Data Type tenant UUID -> tenant.id
Service Desk Universe last_mod_by UUID -> cnt.id
Service Desk Universe Service Desk Universe Data Type
Data Type Data Type Object Name id Id INTEGER ...
last_mod_by Last Mod By UUID -> cnt.id Service Desk Object Universe Name Data Type Object Name Object Name
STRING(30) -> last_mod_dt DATE
condition
id INTEGER id INTEGER event_tmpl STRING(30) -> persistent_id macro.persistent_id
….. last_mod_by UUID-> cnt.id
tenant UUID -> tenant.id
delete_flag INTEGER -> actbool.enum
_mapped_chg INTEGER -> chg.id owning_contract INTEGER -> svc_contract.id owning_ast INTEGER -> attached_sla.id
last_mod_by UUID -> cnt.id nr nr UUID -> nr.id delete_flag INTEGER -> actbool.enum
STRING(30) -> tenant UUID -> tenant.id
STRING(30) -> schedule
wrkshft.persistent_id
svy_atpl
_mapped_cr STRING(0) ->
cr.persistent_id obj_type ...
timezone STRING(12) -> tz.code event_prod_list.sym chg chg UUID -> chg.id
Kdlinks STRING(30) -> sym STRING(60) Universe
Document Ticket Links,Knowledge Measures _mapped_iss Service Desk Object Data Type
iss.persistent_id Name
…... tenant UUID -> tenant.id …...
Service Desk Object Universe Name Data Type timezone STRING(12) -> tz.code
_mapped_iss_wf INTEGER -> iss_wf.id STRING(30) -> id INTEGER
UUID -> work_shift
iss Iss last_mod_by UUID -> cnt.id wrkshft.persistent_id
iss.persistent_id _mapped_wf INTEGER -> wf.id last_mod_by UUID -> cnt.id
svytrk
delete_flag INTEGER -> actbool.enum …...
Survey Tracking last_mod_dt DATE
kd Kd INTEGER -> KD.id delete_flag INTEGER -> actbool.enum
…... Service Desk Object Universe Name Data Type
own-
last_mod_by Last Mod By UUID -> cnt.id INTEGER -> svy_qtpl.id
last_mod_by UUID -> cnt.id ing_survey_question
cntid UUID -> cnt.id
tenant Tenant UUID -> tenant.id persistent_id STRING(30)
map_sdsc STRING(30) -> sdsc.code tenant UUID -> tenant.id
sequence INTEGER
…. delete_flag Delete Flag INTEGER  actbool.enum
tenant UUID -> tenant.id
tenant UUID -> tenant.id
STRING(30) -> tplid Survey Template Id INTEGER  sry_tpl.id
ttv_event
KD atev.persistent_id
...
Knowledge Measures,Knowledge Document ...
…...
Service Desk Object Universe Name Data Type
resocode svystat
Resolution Code mgs
ASSIGNEE_ID Assignee UUID -> cnt.id
Universe Managed Survey
Service Desk Object Universe Name Data Type Service Desk Object Data Type
AUTHOR_ID Author UUID-> cnt.id Name
id ID INTEGER Service Desk Object Universe Name Data Type
INTEGER -> id INTEGER
CURRENT_ACTION_ID Current Action Id
symptom_code CI_ACTIONS.id
Symptom Code rc last_mod_by UUID->cnt.id tplid INTEGER -> svy_tpl.id
INTEGER -> Imp tenant UUID -> tenant.id
DOC_TEMPLATE_ID Doc Template Id Root Cause Intfc
CI_DOC_TEMPLATES.id
Service Desk Object Universe Name Data Type Impact Interface sub_counter INTEGER
sym Symbol STRING(128) active Active INTEGER  actrbool.enum
INTEGER -> Service Desk Object Universe Name Data Type
DOC_TYPE_ID Doc Type Id Service Desk Object Universe Name Data Type
id ID INTEGER CI_DOC_TYPES.id Service Desk Object Universe Name Data Type tenant UUID -> tenant.id
INTEGER -> tenant UUID -> tenant.id tplid Tplid INTEGER  svy_tpl.id
delete_flag Delete Flag INTEGER -> INTEGER -> cycle INTEGER
FILE_ID File Id INTEGER -> attmnt.id actbool.enum delete_flag Delete Flag delete_flag Delete Flag
last_mod_by UUID->cnt.id actbool.enum actbool.enum pri assignee Assignee Uuid UUID  cnt.id
Priority …... delete_flag INTEGER -> actbool.enum
INTEGER -> last_mod_by Last Mod By Uuid UUID-> cnt.id
FILE_TYPE File Type description Description STRING(255) last_mod_by Last Mod By UUID -> cnt.id
sym Symbol STRING(128) KT_FILE_TYPE.id group Group Uuid UUID  grp.id
Service Desk Object Universe Name Data Type
….. ...
INITIATOR_ID Initiator UUID -> cnt.id
last_mod_by Last Mod By UUID -> cnt.id …... STRING(12) 
…... status Status Code
INTEGER -> mgsstat.code
delete_flag Delete Flag
KD_PERMISSION_INDEX_ Kd Permission Index ….. actbool.enum resomethod
INTEGER -> KCAT.id Resolution Method initial_method Initial Method INTEGER  cmth.id
ID Id
last_mod_by Last Mod By UUID -> cnt.id mgsstat
…... Service Desk Object Universe Name Data Type Managed Survey Status reminder_method Reminder Method INTEGER  cmth.id

STRING(30) -> id ID INTEGER last_mod_by Last Mod By Uuid UUID  cnt.id

service_type Service Type Universe
no_contract_sdsc.code Service Desk Object Data Type
Name
last_mod_by UUID->cnt.id ...
….. delete_flag Delete Flag INTEGER -> actbool.enum
outage_type sym Symbol STRING(128)
Outage Type
last_mod_by Last Mod By UUID -> cnt.id
Service Desk Object Universe Name Data Type tenant UUID -> tenant.id mgsalg
pri_cal
... Service Desk Object Universe Name Data Type
id ID INTEGER …...
Service Desk Object Universe Name Data Type
analyst UUID -> cnt.id
last_mod_by Last Mod by UUID->cnt.id INTEGER ->
cat_urg
bool.enum mgs_id INTEGER -> mgs.id
crt svy_ans
sym Symbol STRING(60) urg INTEGER -> pr_trans Survey Answer
ci_imp Request Type tenant UUID -> tenant.id
Urgency bool.enum
Universe
INTEGER -> Service Desk Object Universe Name Data Type Service Desk Object Data Type
…... Service Desk Object Universe Name Data Type delete_flag Name type STRING(12) -> aty.code
actbool.enum Service Desk Object Universe Name Data Type
last_mod_by UUID -> cnt.id
INTEGER -> code Code STRING(10)
id Id INTEGER imp_def STRING(30) ->
imp.enum condition
tenant UUID -> tenant.id
...
macro.persistent_id
INTEGER -> delete_flag Delete Flag INTEGER -> actbool.enum
in_flag INTEGER -> own- Owning Survey
last_mod_by Last Mod By Uuid UUID -> cnt.id bool.enum delete_flag INTEGER  svy_ques.id
actbool.enum ing_survey_question Question
last_mod_by UUID-> cnt.id description Description STRING(255)
pcat sym Symbol STRING(60) cr last_mod_by UUID -> cnt.id delete_flag Delete Flag INTEGER  actrbool.enum
Request area Look u p Request CloseDate/Group/Analyst,Request Measures and Details svy_ques
….. …...
delete_flag Delete Flag INTEGER -> actbool.enum Service Desk Object Universe Name Data Type STRING(12) -> ...
new_status
Service Desk Object Universe Name Data Type crs.code
Universe
affected_resource Configuration Item UUID -> nr.id STRING(12) -> Service Desk Object Data Type
id Id INTEGER …... status Name
crs.code
survey id INTEGER
created_via Created Via INTEGER -> intfc.id
in_flag In Flag INTEGER tenant UUID -> tenant.id Survey Detail
crs owning_survey INTEGER -> survey.id
customer Customer UUID -> cnt.id Service Desk Object Universe Name Data Type
last_mod_by Last Mod By UUID -> cnt.id Request Status …...
sev
last_mod_by UUID -> cnt.id
Severity group Group UUID-> grp.id Service Desk Object Universe Name Data Type id Id INTEGER
last_mod_dt Last Mod Dt DATE alg
Service Desk Object Universe Name Data Type Incident/Problem,Request Activity , Request Activity Measures tenant UUID -> tenant.id
impact Impact INTEGER -> imp.enum delete_flag Delete Flag INTEGER -> actbool.enum cr_trans sym Symbol STRING(60)
organization Organization UUID -> org.id Service Desk Object Universe Name Data Type
id Id INTEGER
incorrectly_assigned Incorrectly Assigned INTEGER -> bool.enum last_mod_by Last Mod By UUID -> cnt.id include_comment Include Comment INTEGER ...
INTEGER -> analyst Analyst Uuid UUID-> cnt.id Service Desk Object Universe Name Data Type
owning_contract Owning Contract
svc_contract.id sym Symbol STRING(60)
STRING(30) - tenant Tenant UUID -> tenant.id STRING(30) -> last_mod_by Last Mod By Uuid UUID -> cnt.id
call_req_id Call Req Id last_mod_by Last Mod By UUID -> cnt.id condition
persistent_id Persistent Id STRING(30) >cr.persistent_id macro.persistent_id
last_mod_by Last Mod By Uuid UUID-> cnt.id
INTEGER -> last_mod_dt Last Mod Dt DATE
rel_ticket_type Rel Ticket Type STRING(12) -> aty.code major_incident Major Incident INTEGER -> bool.enum …... delete_flag
pr_flag Pr Flag INTEGER actbool.enum
last_mod_dt Last Mod Dt DATE ...
type Type STRING(12) -> aty.code orig_user_dept Orig User Dept INTEGER -> dept.id last_mod_by UUID -> cnt.id
…...
…...
STRING(12) ->
…... …... new_status
crs.code
cr_prp INTEGER -> transi-
Properties of Requests,Incidents,Problems t_type
tion_type.id
sa_event_history sa_event_type
nrf Service Desk Object Universe Name Data Type Event History SA Event Type
tenant UUID -> tenant.id
Resource Family Look up grc
last_mod_by Last Mod By UUID -> cnt.id Service Desk Object Universe Name Data Type Service Desk Object Universe Name Data Type
Resource Class Lookup
…...
Service Desk Object Universe Name Data Type INTEGER -> Id ID INTEGER
Service Desk Object Universe Name Data Type STRING(30) -> eventType Event Category
owning_cr Owning Cr sa_event_type.id
cr.persistent_id
id Id INTEGER last_mod_dt Last Mod Dt DATE
STRING(30) ->
tenant Tenant UUID -> tenant.id INTEGER -> cr_rel Cr Rel
Ca_cmpny validation_rule Validation Rule in_trans cr.persistent_id
prpval_rule.id localizationID Localizationid INTEGER
delete_flag Delete Flag INTEGER -> actbool.enum Ca Company
INTEGER ->
delete_flag Delete Flag INTEGER -> actbool.enum INTEGER -> eventType Event Type
Service Desk Object Universe Name Data Type validation_type Validation Type sa_event_type.id …...
mfrmod prpval_type.id Service Desk Object Universe Name Data Type
description Description STRING(255)
STRING(30) ->
family Family INTEGER -> nrf.id company_type Company Type INTEGER -> vpt.id STRING(30) -> iss_rel Iss Rel
Service Desk Object Universe Name Data Type …... condition iss.persistent_id
STRING(0) -> as- macro.persistent_id
extension_name Extension Name
setx_prod_list.sym tenant UUID -> tenant.id
…... tenant Tenant UUID -> tenant.id delete_flag Delete Flag INTEGER -> actbool.enum INTEGER ->
delete_flag
actbool.enum …...
…...
delete_flag Delete Flag INTEGER -> actbool.enum location_uuid Location Uuid UUID -> loc.id
ci_twa_ci last_mod_by UUID -> cnt.id
CI Transaction Work Area
family Family INTEGER -> nrf.id parent_company_uuid Parent Company Uuid UUID -> ca_cmpny.id STRING(12) ->
new_status sa_script_exec_status sa_script
Service Desk Object Universe Name Data Type crs.code
projex UUID-> cnt.id Service Script Exce Status Script, Lookups
…... primary_contact_uuid Primary Contact Uuid
Provider Eligible STRING(12) ->
delete_flag Delete Flag INTEGER -> actbool.enum status Service Desk Universe
crs.code Universe Name Data Type Service Desk Object Data Type
Object Name
Service Desk Object Universe Name Data Type …... INTEGER -> transi-
INTEGER -> t_type INTEGER ->
tran_status Tran Status tion_type.id eventID Eventid disclaimer Disclaimer UUID-> sa_disclaimer.id
delete_flag INTEGER -> actbool.enum ci_twa_statusnames.enum sa_event_history.id

tenant UUID -> tenant.id Script Executed INTEGER ->

executedStatus INTEGER groupID Groupid
id UUID -> nr.id nr type Type STRING(50) Status sa_script_group.id
Resoource Detail
…... scriptID Scriptid INTEGER -> sa_script.id surveyID Surveyid INTEGER -> sa_survey.id
Service Desk Object Universe Name Data Type Service Desk Object Universe Name Data Type Service Desk Object Universe Name Data Type
…...
organization UUID -> org.id
INTEGER -> …... …...
bm_status Bm Status family Family INTEGER -> nrf.id resource_contact Resource Contact UUID -> cnt.id
…... bms.status_no

class Class INTEGER -> grc.id is_asset Is Asset INTEGER -> bool.enum resource_owner_uuid Resource Owner UUID -> cnt.id ci_twa_statusnames Transition_type
sa_queued_user sa_queue
Ci Transaction Work Area Statusnames Queue, Lookups
company_bought_for_uuid Company Bought For UUID -> ca_cmpny.id is_ci Is Ci INTEGER -> bool.enum service_impact Service Impact INTEGER -> imp.enum Queued Users
Service Desk Object Universe Name Data Type Service Desk Object Universe Name Data Type Service Desk Ob-
ci_window Universe Name Data Type Service Desk Object Universe Name Data Type
ject
CI Window Filters, CI Window, CI Window Lookups contact_1 Contact 1 UUID -> cnt.id location Location UUID -> loc.id service_org Service Org UUID -> org.id
delete_flag Delete Flag INTEGER -> actbool.enum id INTEGER INTEGER ->
categoryID Categoryid
queueID Queue ID INTEGER -> sa_queue.id sa_custom_category.id
Service Desk Object Universe Name Data Type STRING(30) ->
contact_2 Contact 2 UUID -> cnt.id manufacturer Manufacturer UUID -> ca_cmpny.id service_type Service Type sym STRING(80)
no_contract_sdsc.code description Description STRING(240) INTEGER -> cr_template Cr Template UUID-> cr.persistent_id
id Id INTEGER sessionID Session ID
sa_login_session.id
contact_3 Contact 3 UUID -> cnt.id model Model UUID -> mfrmod.id status Service Status INTEGER -> rss.id
id Id INTEGER last_mod_by UUID -> cnt.id Escalationtar-
escalationTargetQueue INTEGER -> sa_queue.id
window Window INTEGER -> window.id INTEGER -> user_route_rel User Route Rel UUID-> sa_user_route.id getqueue
delete_flag Delete Flag org_bought_for_uuid Org Bought For UUID -> org.id supplier Supplier UUID -> ca_cmpny.id
actbool.enum INTEGER ->
…... delete_flag INTEGER ->
actbool.enum isActive Is Active
last_mod_dt Last Mod Dt DATE department Department INTEGER -> dept.id priority Priority INTEGER -> pri.enum vendor_repair Vendor Repair UUID -> ca_cmpny.id last_mod_by UUID-> cnt.id actrbool.enum
…...
…... isDefault Is Default INTEGER -> bool.enum
expense_code Expense Code INTEGER -> cost_cntr.id repair_org Repair Org UUID -> org.id vendor_restore Vendor Restore UUID -> ca_cmpny.id …...

…... isscat_rel Isscat Rel STRING(12) -> isscat.code

sa_login_session
ci_twa_relation Login Session, SA Groups is_special Is Special INTEGER -> bool.enum
CI Transaction Work Area Relation Service Desk Ob-
Universe Name Data Type STRING(30) ->
ject pcat_rel Pcat Rel
Service Desk Object Universe Name Data Type attr_control pcat.persistent_id
INTEGER ->
CategoryID Categoryid
sa_custom_category.id INTEGER ->
delete_flag Delete Flag INTEGER -> actbool.enum responseID Response ID
Service Desk Object Universe Name Data Type sa_chat_preset.id
hier GroupID Group ID INTEGER -> sa_group.id
rss INTEGER ->
cialg tran_status Tran Status control
INTEGER -> depend-
workshift Workshift
STRING(30) ->
Resource Status Lookup ci_twa_statusnames.enum ent_control.id wrkshft.persistent_id
CI Activity Log Lookups,CI Activity Log Filters,C Activity Log Service Desk Object Universe Name Data Type initialQueueID Initialqueueid INTEGER -> sa_queue.id
Service Desk Object Universe Name Data Type Service Desk Object Universe Name Data Type type Type STRING(100) INTEGER ->
delete_flag …...
child UUID -> nr.id actbool.enum INTEGER ->
delete_flag Delete Flag INTEGER -> actbool.enum localizationID Localizationid sa_localization.localization
Ci_id Id UUID->nr.id …... last_mod_by UUID-> cnt.id ID
last_mod_by UUID -> cnt.id
id Id INTEGER Last_mod_dt Last Mod Dt DATE
sa_virtual_session
tenant UUID -> tenant.id userID User ID UUID->cnt.id
Vertual Session
parent UUID -> nr.id nr_com
sym Symbol STRING(100) tenant CI Tenant Name UUID->tenant.id CI Audit Log …... Service Desk Object Universe Name Data Type
…...
tenant UUID -> tenant.id Service Desk Object Universe Name Data Type
…... queueID Queue ID INTEGER -> sa_queue.id
…...
…... asset_id Asset ID UUID -> nr.id INTEGER ->
sa_group sessionID Session ID
SA Groups, Lookups sa_login_session.id
tenant Tenant ID UUID -> tenant.id
Service Desk Object Universe Name Data Type handledTime Handled Time INTEGER

ci_mdr_idmap writer_id Writer ID UUID -> cnt.id INTEGER ->

ci_mdr_provider bmhier categoryID Category ID …...
sa_custom_category.id
CI Mdr Provider, CI Mdr Provider Lookups Mdr Id Mapping
Business Management Hierarchy
…... STRING(30) ->
Service Desk Object Universe Name Data Type Service Desk Object Universe Name Data Type cr_rel Cr Rel
Service Desk Object Universe Name Data Type cr.persistent_id

delete_flag Delete Flag INTEGER -> actbool.enum cmdb_asset_id CMDB Asset ID UUID -> nr.id isscat_rel Isscat Rel STRING(12) -> isscat.code
child UUID -> nr.id
sa_group_current_user
delete_flag INTEGER -> actbool.enum INTEGER -> dependent_control originalGroupID Originalgroupid INTEGER -> sa_group.id
description Description STRING(255) ci_rel_type CI Rel Type Service Desk Object Universe Name Data Type
ci_rel_type.id
ci_rel_type INTEGER -> ->
last_mod_by Contact Last Mod By UUID-> cnt.id Service Desk Object Universe Name Data Type ownerSessionID Ownersessionid groupID INTEGER -> sa_group.id
encryptedpassword Encryptedpassword STRING(255) delete_flag Delete Flag INTEGER -> actbool.enum CI Rel Type, CI Rel Type Lookups, CI Multiple Maintenance sa_login_session.id
Windows, CI Conflict Windows last_mod_by UUID-> cnt.id
INTEGER -> STRING(30) ->
mdr_provider_id id INTEGER pcat_rel Pcat Rel
…... ci_mdr_provider.id last_mod_by UUID -> cnt.id Service Desk Object Universe Name Data Type pcat.persistent_id sessionID sa_login_session.id

tenant UUID -> tenant.id last_mod_by UUID-> cnt.id INTEGER ->

childtoparent Childtoparent STRING(50) user_route_rel User Route Rel tenant UUID -> tenant.id
parent UUID-> nr.id sa_user_route.id

…... objname STRING(255) …... …...

tenant UUID -> tenant.id delete_flag Delete Flag INTEGER -> actbool.enum
ci_mdr_snapshot
CI Mdr Snapshot INTEGER ->
…... is_peer Is Peer INTEGER -> actbool.enum delete_flag
actbool.enum
Service Desk Object Universe Name Data Type
…... …...
delete_flag Delete Flag INTEGER -> actbool.enum

id Id INTEGER

INTEGER ->
mdr_provider_id Mdr Provider Id
ci_mdr_provider.id

…...

Note: To view all columns in a table, click the link (table name) that appears in the header area.
The CA_SDM12.5_Logical_Data_Model_Guide contains the complete list of tables.