Clients & Profits Worldwide :: Data Dictionary

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

Home > Support > Data Dictionary > JOB_TYPES

Search:

C&P Data Dictionary: JOB_TYPES

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

JOB_TYPES is the data file that stores the Job Type Spec Sheets, or Job Templates. Each JOB_TYPES record contains a Job Type Spec Sheet. It is a lookup file used for creating new jobs and for storing Traffic Milestones. Each JOB_TYPES record has fields for Job Milestones (i.e., TYPE_TRAFFIC1 thru TYPE_TRAFFIC12), Creative Brief Titles (i.e., TYPE_CB_1_LABEL thru TYPE_CB_15_LABEL) and other Job Specs i.e., TYPE_MARKUP, TYPE_RATE, for each job template. These fields are updated when new Job Types are created.

See related data files: JOBS

Field Name:	Type:	Length:	Index:	Description:
TYPE_SEQ	sequence		x	sequence #
TYPE_CODE	char	15	x	spec sheet code/number
TYPE_NAME	char	40		spec sheet name/title
TYPE_DISCLAIMER	char	2000		standard estimate disclaimer for this job type
TYPE_TRAFFIC1	char	7		traffic milestone
TYPE_TRAFFIC2	char	7		traffic milestone
TYPE_TRAFFIC3	char	7		traffic milestone
TYPE_TRAFFIC4	char	7		traffic milestone
TYPE_TRAFFIC5	char	7		traffic milestone
TYPE_TRAFFIC6	char	7		traffic milestone
TYPE_TRAFFIC7	char	7		traffic milestone
TYPE_TRAFFIC8	char	7		traffic milestone
TYPE_TRAFFIC9	char	7		traffic milestone
TYPE_TRAFFIC10	char	7		traffic milestone
TYPE_MARKUP	short num	2dp		special markup
TYPE_RATE	short num	2dp		special billing rate
TYPE_TASK_LIST	list			list of tasks for this template
TYPE_HEADING	char	20		default estimate heading
TYPE_EST_COL1	char	15		default estimate column 1
TYPE_EST_COL2	char	15		default estimate column 2
TYPE_EST_COL3	char	15		default estimate column 3
TYPE_TRAFFIC11	char	7		traffic milestone
TYPE_TRAFFIC12	char	7		traffic milestone
TYPE_FIELD1	char	20		user-defined field label
TYPE_FIELD2	char	20		user-defined field label
TYPE_FIELD3	char	20		user-defined field label
TYPE_FIELD4	char	20		user-defined field label
TYPE_FIELD5	char	20		user-defined field label
TYPE_FIELD6	char	20		user-defined field label
TYPE_CONTING	short int	(0 to 255)		contingency type (0=none/1=%/2=$)
TYPE_CON_PC	number	2dp		contingency %
TYPE_CON_AMT	number	2dp		contingency flat $
TYPE_CON_NOTE	char	2000		contingency note
TYPE_SHOW_HRS	short int	(0 to 255)		show estimate hours flag (yes/no)
TYPE_AE_TITLE	char	20		agency contact
TYPE_JOB_SPECS	char	2000		default job specifications
TYPE_RATE_KIND	short int	(0 to 255)		billing rate method (client/staff/task)
TYPE_TAX	short int	(0 to 255)		taxable?
TYPE_CB_1_LABEL	char	2000
TYPE_CB_2_LABEL	char	2000
TYPE_CB_3_LABEL	char	2000
TYPE_CB_4_LABEL	char	2000
TYPE_CB_5_LABEL	char	2000
TYPE_CB_6_LABEL	char	2000
TYPE_CB_7_LABEL	char	2000
TYPE_CB_8_LABEL	char	2000
TYPE_CB_9_LABEL	char	2000
TYPE_CB_10_LABEL	char	2000
TYPE_CB_11_LABEL	char	2000
TYPE_CB_12_LABEL	char	2000
TYPE_CB_13_LABEL	char	2000
TYPE_CB_14_LABEL	char	2000
TYPE_CB_15_LABEL	char	2000

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