Contact Table (Shared)

From SDU
Revision as of 03:57, 27 July 2008 by Gityerfix (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
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