Table: CN_SRP_PERIOD_QUOTAS_ALL

Product:	CN - Incentive Compensation
Description:	Salesperson Plan Elements by Period
Implementation/DBA Data:	CN.CN_SRP_PERIOD_QUOTAS_ALL

Primary Key: CN_SRP_PERIOD_QUOTAS_PK

1. SRP_PERIOD_QUOTA_ID

Primary Key: CN_SRP_PERIOD_QUOTAS_UK1

1. SRP_QUOTA_ASSIGN_ID
2. PERIOD_ID

Primary Key: CN_SRP_PERIOD_QUOTAS_UK2

1. SALESREP_ID
2. PERIOD_ID
3. QUOTA_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
CN_SRP_PERIOD_QUOTAS_ALL		CN_PERIOD_STATUSES_ALL	CN_SRP_PERIOD_QUOTAS_ALL.PERIOD_ID
CN_SRP_PERIOD_QUOTAS_ALL		CN_SRP_PLAN_ASSIGNS_ALL	CN_SRP_PERIOD_QUOTAS_ALL.SRP_PLAN_ASSIGN_ID
CN_SRP_PERIOD_QUOTAS_ALL		CN_SRP_QUOTA_ASSIGNS_ALL	CN_SRP_PERIOD_QUOTAS_ALL.SRP_QUOTA_ASSIGN_ID
CN_SRP_PERIOD_QUOTAS_ALL		CN_QUOTAS_ALL	CN_SRP_PERIOD_QUOTAS_ALL.QUOTA_ID
CN_SRP_PER_QUOTA_RC_ALL		CN_SRP_PERIOD_QUOTAS_ALL	CN_SRP_PER_QUOTA_RC_ALL.SRP_PERIOD_QUOTA_ID