Table: CN_PROCESS_BATCHES_ALL

Product:	CN - Incentive Compensation
Description:	Process Batches used in Calculation process.
Implementation/DBA Data:	CN.CN_PROCESS_BATCHES_ALL

Primary Key: CN_PROCESS_BATCHES_PK

1. PROCESS_BATCH_ID

Primary Key: CN_PROCESS_BATCHES_UK1

1. LOGICAL_BATCH_ID
2. SRP_PERIOD_ID

Primary Key: CN_PROCESS_BATCHES_UK2

1. LOGICAL_BATCH_ID
2. SALESREP_ID
3. PERIOD_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
CN_PROCESS_BATCHES_ALL		CN_SRP_PERIODS_ALL	CN_PROCESS_BATCHES_ALL.SRP_PERIOD_ID
CN_PROCESS_BATCHES_ALL		CN_SALESREPS_API_ALL	CN_PROCESS_BATCHES_ALL.SALESREP_ID
CN_PROCESS_BATCHES_ALL		CN_PERIOD_STATUSES_ALL	CN_PROCESS_BATCHES_ALL.PERIOD_ID