Field
Name: |
Type: |
Length: |
Index: |
Description: |
BR_SEQ |
Sequence |
|
|
sequence # |
BR_CAMPAIGN |
char |
10 |
|
campaign ID code or number |
BR_NAME |
char |
40 |
|
campaign name |
BR_DESC |
char |
2000 |
|
campaign description/notes |
BR_BUDGET_AMT |
Short num |
2 dp |
|
budget amount |
BR_COST_AMT |
Short num |
2 dp |
|
cost-to-date amount |
BR_CAMP_START |
Short date |
1980..2079 |
|
campaign begins |
BR_CAMP_END |
Short date |
1980..2079 |
|
campaign ends |
BR_SPOTS |
Short num |
0 dp |
|
number of spots/ads for campaign |
BR_RATINGS |
Short num |
2 dp |
|
total ratings for campaign |
BR_COST |
Short num |
2 dp |
|
total cost to date |
BR_CPP |
Short num |
2 dp |
|
total cost per point |
BR_CPS |
Short num |
2 dp |
|
total cost per spot |
BR_RF |
Short num |
2 dp |
|
total reach/frequency |
BR_CLIENT_NUM |
char |
10 |
|
client number |
BR_DUE_DATE |
Short date |
1980..2079 |
|
when is this media brief due? |
BR_OBJECTIVE |
char |
2000 |
|
brief's objective |
BR_TARGET_AGE |
char |
2000 |
|
target market |
BR_TARGET_GENDER |
char |
2000 |
|
target market |
BR_TARGET_OCCUPAT ION |
char |
2000 |
|
target market |
BR_TARGET_LIFESTYL E |
char |
2000 |
|
target market |
BR_MEDIA_REC |
char |
2000 |
|
media reccomendation |
BR_MEDIA_SCHED |
char |
2000 |
|
media schedule |
BR_EXHIBITS |
char |
2000 |
|
support exhibits |
BR_BUD_BCAST |
Short num |
0 dp |
|
budget - broadcast |
BR_BUD_CABLE |
Short num |
0 dp |
|
budget - cable |
BR_BUD_RADIO |
Short num |
0 dp |
|
budget - radio |
BR_BUD_NEWS |
Short num |
0 dp |
|
budget - newspaper |
BR_BUD_MAG |
Short num |
0 dp |
|
budget - magazine |
BR_BUD_OUT |
Short num |
0 dp |
|
budget - outdoor |
BR_BUD_INTER |
Short num |
0 dp |
|
budget - interactive |
BR_BUD_OTHER |
Short num |
0 dp |
|
budget - other |
BR_ADDED_BY |
char |
4 |
|
added by - initials |
BR_AE |
char |
4 |
|
acct exec - initials |
BR_REP |
char |
40 |
|
media rep |
BR_STATUS |
char |
200 |
|
current status |
BR_STATUS_NUM |
short int |
(0 to 255) |
|
0=Approved/1=Killed/ 2=Pending/ |