Groups
MAIL_CAMPAIGN
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | ||
| 2 | STATUS_ID | NUMBER | 22 | Y | ||
| 3 | NAME | VARCHAR2 | 100 | Y | ||
| 4 | POP_SUBJECT | VARCHAR2 | 100 | Y | ||
| 5 | MAIL_TEMPLATE_ID | NUMBER | 22 | Y | ||
| 6 | TYPE_ID | NUMBER | 22 | Y | ||
| 7 | FROM_NAME | VARCHAR2 | 100 | Y | ||
| 8 | FROM_EMAIL | VARCHAR2 | 100 | Y | ||
| 9 | NEXT_DATE | DATE | 7 | Y | ||
| 10 | INTERVAL | NUMBER | 22 | Y | ||
| 11 | INTERVAL_TYPE | CHAR | 1 | Y | ||
| 12 | IS_INTERNAL_MAIL | CHAR | 1 | Y | ||
| 13 | MAIL_CAMPAIGN_METHOD | VARCHAR2 | 50 | Y | ||
| 14 | MAIL_CAMPAIGN_HANDLER | VARCHAR2 | 50 | Y | ||
| 15 | START_TIME | DATE | 7 | Y | ||
| 16 | NEXT_DATE_SQL | VARCHAR2 | 1000 | Y | ||
| 17 | CODE | VARCHAR2 | 10 | Y | ||
| 18 | AS_ATTACHMENT | CHAR | 1 | Y | ||
| 19 | SAVE_ONLY | CHAR | 1 | Y | ||
| 20 | PUBLIC_ATTACHMENT | VARCHAR2 | 500 | Y | ||
| 21 | BRANDED_CAMPAIGN | VARCHAR2 | 4 | Y | ||
| 22 | MAIL_TEMPLATE_KEY | VARCHAR2 | 800 | Y |