C&P Data Dictionary: JOB_TYPES

Other files: ACCOUNTS AP AR AR_ITEMS BILLING_INFO CHANGE_ORDER CHECKS CHECK_ITEMS CLIENTS COSTS DEPTS GROUPS HISTORY HISTORY_CLIENT INT_ITEMS JE JOBS JOB_ORDER JOB_TASK JOB_TYPES MEDIA_EST MEDIA_EST_ITEMS MEDIA_ITEMS MEDIA_PLANS PAYMENTS PAYMENT_ITEMS PC PICTURES PO_ITEMS PO_TEMPLATE PRINT_SPECS PROGRAMS PROJECTS PURCHASE_ORDER RATES RECUR_AP RETAINERS STAFF STATIONS STATUS_CODES SUB_CLASSES TASK_TABLE VENDORS WEB_IP_LOG WEB_USERS WORKSHEETS

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 number 2dp special markup TYPE_RATE number 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 integer     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 integer     show estimate hours flag (yes/no) TYPE_AE_TITLE char 20 agency contact TYPE_JOB_SPECS char 2000   default job specifications TYPE_RATE_KIND integer billing rate method (client/staff/task) TYPE_TAX integer     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.