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: CN_SRP_RATE_ASSIGNS_ALL

Product:	CN - Incentive Compensation
Description:	Salesperson Rate Tiers
Implementation/DBA Data:	CN.CN_SRP_RATE_ASSIGNS_ALL

Primary Key: CN_SRP_RATE_ASSIGNS_PK

SRP_QUOTA_ASSIGN_ID
RATE_TIER_ID

Primary Key: CN_SRP_RATE_ASSIGNS_UK1

RATE_TIER_ID
SRP_QUOTA_ASSIGN_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
CN_SRP_RATE_ASSIGNS_ALL	CN_SRP_PLAN_ASSIGNS_ALL	CN_SRP_RATE_ASSIGNS_ALL.SRP_PLAN_ASSIGN_ID
CN_SRP_RATE_ASSIGNS_ALL	CN_SRP_QUOTA_ASSIGNS_ALL	CN_SRP_RATE_ASSIGNS_ALL.SRP_QUOTA_ASSIGN_ID
CN_SRP_RATE_ASSIGNS_ALL	CN_RATE_SCHEDULES_ALL	CN_SRP_RATE_ASSIGNS_ALL.RATE_SCHEDULE_ID
CN_SRP_RATE_ASSIGNS_ALL	CN_QUOTAS_ALL	CN_SRP_RATE_ASSIGNS_ALL.QUOTA_ID
CN_SRP_RATE_ASSIGNS_ALL	CN_RT_QUOTA_ASGNS_ALL	CN_SRP_RATE_ASSIGNS_ALL.RT_QUOTA_ASGN_ID
CN_SRP_RATE_ASSIGNS_ALL	CN_RATE_TIERS_ALL	CN_SRP_RATE_ASSIGNS_ALL.RATE_TIER_ID