C&P Data Dictionary: STATUS_CODES

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

STATUS_CODES is the data file that stores the Status Codes. Each STATUS_CODES record contains a single Status Code. It is a data file used primarly on Trafficing reports (e.g., By Job, Client, Job Number, etc.). Each STATUS_CODES record has fields for Alerts (i.e., STATUS_ALERT, STATUS_STOP, STATUS_ALERT_BUTTON), Descriptioin (i.e., STATUS_DESC) and E-Mail data (i.e., ) for each. See related data files:   JOB_TASK   WORKSHEETS Field Name: Type: Length: Index: Description: STATUS_SEQ sequence x STATUS_NUM number 0dp x status code number STATUS_DESC char 40 status name (description) STATUS_ALERT char 240   status alert STATUS_STOP integer stop setting STATUS_PROD_ALERT integer     alert on production status STATUS_BILL_ALERT integer alert on billing status STATUS_ALERT_BUTTON char 20   status alert button STATUS_CAT char 20 pending/work in progress/finished/closed STATUS_MAIL_TO char 32000   send mail to initials STATUS_MAIL_MSG char 32000 e-mail message STATUS_MAIL_CC char 40   e-mail cc: to STATUS_MAIL_BCC char 40 e-mail bcc: to 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.