Difference between revisions of "Contact Table (Shared)"

From SDU
Jump to: navigation, search
m
m
 
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
 
[[Category:Tables]]
 
[[Category:Tables]]
<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+
{{Global Header}}
To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
+
{{Global Announcement}}
  
 
== Overview ==
 
== Overview ==

Latest revision as of 03:57, 27 July 2008

To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.

Overview

Logical Name: ca_contact

Object Name: cnt

Physical Name: ca_contact

Description: Contact data that is shared among Unicenter applications. Contacts include customers, employees, analysts, vendors, and groups.

References
Field Layer Relationship
Administrative Organization Logical ca_contact.admin_org => ca_organization.id
Object cnt.admin_org => org.id
Physical ca_contact.admin_organization_uuid => ca_organization.organization_uuid
Company Logical ca_contact.company => ca_cmpny.id
Object cnt.company => org.id
Physical ca_contact.company_uuid => ca_company.id
Type Logical ca_contact.type => ca_contact_type.id
Object cnt.type => ctp.id
Physical ca_contact.type => ca_contact_type.id
Referenced By
Layer Relationship
Logical

Call_Req.assignee => ca_contact.id
Call_Req.customer => ca_contact.id
Call_Req.group => ca_contact.id
Call_Req.log_agent => ca_contact.id
Change_Request.affected_contact => ca_contact.id
Change_Request.assignee => ca_contact.id
Change_Request.group => ca_contact.id
Change_Request.last_mod_by => ca_contact.id
Change_Request.log_agent => ca_contact.id
Change_Request.requestor => ca_contact.id

Object

chg.affected_contact => cnt.id
chg.assignee => cnt.id
chg.group => cnt.id
chg.last_mod_by => cnt.id
chg.log_agent => cnt.id
chg.requestor => cnt.id
cr.assignee => cnt.id
cr.customer => cnt.id
cr.group => cnt.id
cr.log_agent => cnt.id

Physical

call_req.assignee => ca_contact.id
call_req.customer => ca_contact.id
call_req.group => ca_contact.id
call_req.log_agent => ca_contact.id
chg.affected_contact => ca_contact.id
chg.assignee => ca_contact.id
chg.group => ca_contact.id
chg.last_mod_by => ca_contact.id
chg.log_agent => ca_contact.id
chg.requestor => ca_contact.id