ProCAL Database

CALSoft 6 stores any projects you create using the Process Calculation, CUT/Vent Establishment, or Deviation Evaluation sections in a database referred to as the "ProCAL Database".   This database file is an Access Database named "ProCAL.mdb" and resides behind the scenes on your computer.   

By default, the ProCAL database is stored in your CALSoft6\data directory.   The database location is listed in your Preferences (see ProCAL Directory for more information).    

When you add a new record to the ProCAL database, CALSoft chooses the next available number in the database and assigns that as the Record Number for the project you are working on, and is the main reference # for that "project".     The database starts with the number 10,000, so your first Record will be #10,000. (Note that the older CALSoft 5 version started with record #1).   

(**see this article If you want to learn about how to convert your old CALSoft 5 ProCAL database into the new CALSoft 6 database format).

There are three parts (tables) to the ProCAL database depending on the section of CALSoft you are working in:

	Process Calculation	These records are referred to as "ProCAL Records" (Learn more about ProCAL Records here)
	Set CUT/Vent	These records are referred to as "TDCal Records"
	Deviation Evaluation	These records are referred to as "DEVCAL Records"

Think of the DATABASE as a file cabinet where you store all your projects.

Think of the SECTIONS of CALSoft as the drawers in the File Cabinet

Think of the RECORDS as files in the file cabinet that store all the specific information on each project. 

ProCAL Database = File Cabinet Sections of CALSoft = Drawers in the File Cabinet - ProCAL (Process Calculation) - TDCAL  (CUT/VENT Establishment) - DevCAL (Deviation Evaluation) Records = Folders in the CALBase  - ProCAL Records - TDCAL Records - DevCAL Records

PROCAL DATABASE STRUCTURE:

The following information is stored in the ProCAL Database under each Record for each section:

ProCAL Records	TDCAL Records	DevCAL Records
ProCAL Record # (ID)	TDCAL Record # (ID)	DevCAL Record # (ID)
Date set/completed	Date set/completed	ProCAL Record # (ID)
Processor Name	Processor Name	Processor Name
Location	Location	Location
Product	Retort Type	Product
Container Type	Retort Manufacturer/Model	Retort Description
Container Diameter	Retort #	Container Description
Container Information	Control System	Other information/Notes
Retort Type	Other information/Notes	Deviation Dates
Other Information/Notes	Temperature Type	Deviation Codes
Temperature Type	Start Process Temp	Quantity
HP File names/locations loaded into this ProCAL Record	Start Process Time	Hold Number
HP File Used to Set Process (Candidate File)	Vent Closed Temp	Temperature Type
Lead # Used to Set Process (Candidate File TC#)	Vent Closed Time	Product Type (LACF, Acidified, or Other)
jh	Custom Text	jh
fh	Condition Type(s)	fh
f2	Condition Value(s)/Text	f2
xbh		xbh
Product Type (LACF, Acidified, or Other)		Tref value
Target Lethality (F)		Z value
Z value		m+g value
TRef value		Actual IT
m+g value		Actual RT
Come Up Time used for Come Up Time Credit		Actual CUT
Process Correction %		Actual Cook Time
Thermocouple Correction factor		Target Commercial Sterility
Low IT		Target Minimum Health
High IT		IT Low
IT Interval		IT High
Low RT		IT Interval
High RT		RT Low
RT Interval		RT High
Process Time Extension		RT Interval
Process Time Extension Reason		Evaluated By
Critical Factor(s)		Evaluated Date
		Product Disposition