eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: CS_HZ_SR_CONTACT_POINTS

Product:	CS - Service
Description:	This table stores contact points for a service requests.
Implementation/DBA Data:	CS.CS_HZ_SR_CONTACT_POINTS

Primary Key: CS_HZ_SR_CONTACT_POINTS_UK1

PARTY_ID
INCIDENT_ID

Primary Key: CS_HZ_SR_CP_PK

SR_CONTACT_POINT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
CS_HZ_SR_CONTACT_POINTS	HZ_PARTIES	CS_HZ_SR_CONTACT_POINTS.PARTY_ID
CS_HZ_SR_CONTACT_POINTS	CS_INCIDENTS_ALL_B	CS_HZ_SR_CONTACT_POINTS.INCIDENT_ID
CS_HZ_SR_CONTACT_POINTS	HZ_CONTACT_POINTS	CS_HZ_SR_CONTACT_POINTS.CONTACT_POINT_ID
CS_HZ_SR_CONTACT_POINTS	CS_PARTY_ROLES_B	CS_HZ_SR_CONTACT_POINTS.PARTY_ROLE_CODE
CS_HZ_SR_CONTACT_PNTS_AUDIT	CS_HZ_SR_CONTACT_POINTS	CS_HZ_SR_CONTACT_PNTS_AUDIT.SR_CONTACT_POINT_ID
CS_INCIDENTS_ALL_B	CS_HZ_SR_CONTACT_POINTS	CS_INCIDENTS_ALL_B.PRIMARY_CONTACT_ID