| # |
Name |
Data Type |
Length |
| 1 |
CRMD_CAMP_HIID |
BIGINT |
8 |
| 2 |
RUN_DATE |
TIMESTAMP |
8 |
| 3 |
DELTA_TYPE |
CHARACTER(1) |
1 |
| 4 |
CAMPAIGN_CODE |
CHARACTER VARYING(30) |
30 |
| 5 |
CAMPAIGN_TYPE |
CHARACTER VARYING(30) |
30 |
| 6 |
CAMPAIGN_NAME |
CHARACTER VARYING(100) |
100 |
| 7 |
TRACKING_ID |
CHARACTER VARYING(30) |
30 |
| 9 |
CHANNEL |
CHARACTER VARYING(30) |
30 |
| 10 |
LINE_OF_BUSINESS |
CHARACTER VARYING(30) |
30 |
| 11 |
OBJECTIVE |
CHARACTER VARYING(4000) |
4000 |
| 12 |
OFFER_CODE |
CHARACTER VARYING(40) |
40 |
| 13 |
OFFER_DESC |
CHARACTER VARYING(16000) |
16000 |
| 14 |
ORIGINATED_BY |
CHARACTER VARYING(30) |
30 |
| 15 |
CAMPAIGN_OWNER_ID |
CHARACTER VARYING(30) |
30 |
| 16 |
CAMPAIGN_OWNER |
CHARACTER VARYING(100) |
100 |
| 17 |
PRODUCT_PORTFOLIO |
CHARACTER VARYING(30) |
30 |
| 18 |
STATUS |
CHARACTER VARYING(30) |
30 |
| 19 |
BUDGETED_COST |
CHARACTER VARYING(20) |
20 |
| 20 |
ACTUAL_COST |
CHARACTER VARYING(20) |
20 |
| 21 |
LEADS_TARGETTED |
CHARACTER VARYING(20) |
20 |
| 22 |
REVENUE_TARGET |
CHARACTER VARYING(20) |
20 |
| 23 |
START_DATE |
TIMESTAMP |
8 |
| 24 |
END_DATE |
TIMESTAMP |
8 |
| 25 |
CREATED_USER |
CHARACTER VARYING(20) |
20 |
| 26 |
CREATED_TS |
TIMESTAMP |
8 |
| 27 |
MODIFIED_USER |
CHARACTER VARYING(20) |
20 |
| 28 |
MODIFIED_TS |
TIMESTAMP |
8 |