Difference between revisions of "Contact Table (Shared)"
m |
m |
||
| Line 1: | Line 1: | ||
| + | __NOTOC__ | ||
| + | [[Category:Tables]] | ||
| + | <div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br> | ||
| + | To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div> | ||
| + | |||
| + | == Overview == | ||
'''Logical Name:''' ca_contact | '''Logical Name:''' ca_contact | ||
| Line 37: | Line 43: | ||
| Physical || ca_contact.type => ca_contact_type.id | | Physical || ca_contact.type => ca_contact_type.id | ||
|} | |} | ||
| − | |||
{| align="center" border="1" cellpadding="4" cellspacing="0" style="text-align:left; width:90%" | {| align="center" border="1" cellpadding="4" cellspacing="0" style="text-align:left; width:90%" | ||
| Line 81: | Line 86: | ||
chg.requestor => ca_contact.id<br> | chg.requestor => ca_contact.id<br> | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 11:54, 26 July 2008
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.
| 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 |
| Layer | Relationship |
|---|---|
| Logical |
Call_Req.assignee => ca_contact.id |
| Object |
chg.affected_contact => cnt.id |
| Physical |
call_req.assignee => ca_contact.id |
