Difference between revisions of "Contact Table (Shared)"

Revision as of 00:30, 9 March 2008

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

@@ Line 7: / Line 7: @@
 '''Description:''' Contact data that is shared among Unicenter applications.  Contacts include customers, employees, analysts, vendors, and groups.
-{| align="center" border="1" cellpadding="4" cellspacing="0" style="background:lightcyan; text-align:left; width:90%"
+{| align="center" border="1" cellpadding="4" cellspacing="0" style="text-align:left; width:90%"
 |+ '''References'''
 |- style="background:paleturquoise"
@@ Line 39: / Line 39: @@
-{| align="center" border="1" cellpadding="4" cellspacing="0" style="background:lightcyan; text-align:left; width:90%"
+{| align="center" border="1" cellpadding="4" cellspacing="0" style="text-align:left; width:90%"
 |+ '''Referenced By'''
 |- style="background:paleturquoise"