The file table "deFile" contains the following header information for each extracted dataset.

A new dataset is created for each extraction. The handling of identical source files is described in the Delete duplicate file rows option, see Standard schema mode.

_FileID

This is a unique internal ID assigned to each dataset.

_TimeStamp

The second column contains the date and start time of the acquisition.

_FileName

This column refers to the file name of the DAT file. This is used for information or as a 'pathname' to display datasets in ibaAnalyzer.

_FileType

This column specifies the file type and refers to the recording system. Examples: "real" → ibaPDA record, "ibaQDR" → ibaQDR record

_Complete

This column shows the status of the extraction process. The first dataset of a file extraction is always inserted into the file table ("deFile") with status "_Complete = 0". After finishing all other inserts in the channel headers and segment tables, the flag is updated to "_Complete = 1".

When querying the "deFile" table, it is recommended that the WHERE condition checks this complete flag to see whether the corresponding extraction was successful.

_ErrorOnExtract

This flag is set if an extraction error occurs.

_TimeStampMicroSecs

This column is created by enabling the Extract microseconds column in the Extractor output tab, see Standard schema mode.

Note
	In many database systems there are data types that can process microsecond resolution. A separate column exists for the purpose of maintaining backward compatibility.

The "deFile" is displayed in the database as shown in the following figure.