Contact Table (Shared)

From SDU
Revision as of 00:30, 9 March 2008 by Gregg (Talk | contribs)

Jump to: navigation, search

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