Clients & Profits Worldwide :: Data Dictionary

Free help: USER GUIDE } WHAT'S NEW } SYSTEM MANAGER NEWS

Home > Support > Data Dictionary > MEDIA_BRIEFS

Search:

C&P Data Dictionary: MEDIA_BRIEFS

Other files:

acc_periods
access_privs
accounts
addresses
ap
ar
ar_items
archived_jobs
asset_types
asset_files
asset_prefs
avail
billing_info
cal
calendar
change_items
change_order
checks
check_items
clients
contacts
costs
credit_card_prefs
date_count
depts
est_revs
f_preference
finance
global_vars
groups
history
history_client
history_vendor
home
int_items
je
jobs
job_order
job_task
job_types
media_briefs
media_est
media_est_items
media_items
media_plans
media_prefs
meetings
mlink
mlink_prefs
odbcusers
outbox
palm_cats
palm_jobs
palm_tasks
payments
payment_items
pc
pictures
po_items
po_template
prefs
print_specs
programs
projects
proposals
purchase_order
rates
recur_ap
retainers
sales_actions
sales_campaigns
sales_letters
schedule_chart
schedule_header
staff
statements
stations
status_codes
sub_classes
task_table
temp_tasks
thought
time_import
timecard
timeline
user_info
vendors
version
web_html
web_ip_log
web_log
web_prefs
web_users_log
working
worksheets
y1099

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/

LEGEND:

Type indicates whether a field contains characters (i.e., "char") which contains any combination of letters or numbers, numbers (which has a set number of decimal places), or integers (i.e., numbers that range from 0 to 255 only).

Length shows the size of a field. Character fields have lengths that are fixed, depending on their purpose. Description and note fields have a length of 32000, which make them variable-length; their actual size depends on how much data is entered into them.

Index indicates fields that are indexed in the database, which makes them key fields for finding and sorting data. For best performances on reporting and exporting, searches should made on index fields first.

Need help exporting? See the Exporting Data from Clients & Profits tech note.

For subscribers: VIDEOS } FAQs/TECH NOTES } COMMUNITY } LEARN } BUGS/WISH LIST } TIPS