Groups
CAMPAIGN
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | Y | Primary key | |
| 2 | CODE | VARCHAR2 | 80 | Y | ||
| 3 | NAME | VARCHAR2 | 80 | Y | ||
| 4 | STATUS_ID | NUMBER | 22 | Y | ||
| 5 | FROM_DATE | DATE | 7 | Y | ||
| 6 | TO_DATE | DATE | 7 | Y | ||
| 7 | ON_ASSIGN_METHOD | VARCHAR2 | 200 | Y | ||
| 8 | ON_ACTIVATE_METHOD | VARCHAR2 | 200 | Y | ||
| 9 | ON_EXPIRE_METHOD | VARCHAR2 | 200 | Y | ||
| 10 | ON_TERMINATE_METHOD | VARCHAR2 | 200 | Y | ||
| 11 | PRICE_CODE | VARCHAR2 | 100 | Y | ||
| 12 | ACTIVATION_TYPE_ID | NUMBER | 22 | Y | ||
| 13 | VALIDITY_PERIOD | NUMBER | 22 | Y | ||
| 14 | VALIDITY_PERIOD_TYPE_ID | NUMBER | 22 | Y | ||
| 15 | EXCLUSIVE_GROUP | VARCHAR2 | 256 | Y | ||
| 16 | EXCLUSIVE_GROUP_PRIORITY | NUMBER | 22 | Y | ||
| 17 | SHORT_DESCRIPTION | VARCHAR2 | 500 | Y | ||
| 18 | LONG_DESCRIPTION | VARCHAR2 | 4000 | Y | ||
| 19 | CAMPAIGN_KEY | VARCHAR2 | 64 | Y | ||
| 20 | VALIDITY_PERIOD_END_DATE | DATE | 7 | Y | ||
| 21 | DISPLAY_PRIORITY | NUMBER | 22 | Y | ||
| 22 | CAN_AUTO_EXTEND | VARCHAR2 | 4 | Y | ||
| 23 | MULTIPLE_ALLOWED | NUMBER | 22 | N |
Definition of all Campaigns