Table: dbo.Workpaper_Source_Ocr_Data
This table stores information of Source Document (PDF) OCR data and page index where the OCR belongs to .
Columns
Name | Type | Constraints | Description
workpaper_source_ocr_data_KEY | int (4) | NOT NULL | The Primary Key.
workpaper_KEY | int (4) | NOT NULL | Determines which workpaper this record is tracking. It is also a foreign key to the Workpaper table.
page_number | int (4) | NOT NULL | The page index of the OCR data within a document. Zero based.
ocr_data_xml | nvarchar (-1) | NOT NULL | This column stores one OCR section of the xml file retrieved from Source Data Processing document. This data do not stay in the database forever. The life of this data starts from the download of SDP document and ends when the workpaper gets deleted. This data do not get copied over to other workpapers and will be deleted during Rollforward and Finalize process.
workpaper_source_ocr_data_guid | uniqueidentifier (16) | NOT NULL | A unique guid for source data entry integration. This GUID is used to identify the document in communications with UltraTax, to support Source Data Entry.

Primary key
Name | Columns | Description
PK_Workpaper_Source_Ocr_Data | workpaper_source_ocr_data_KEY |
Unique constraints
Name | Columns | Description
UK_Workpaper_Source_Ocr_Data$workpaper_KEY$page_number | workpaper_KEY, page_number |
UK_Workpaper_Source_Ocr_Data$workpaper_source_ocr_data_guid | workpaper_source_ocr_data_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Workpaper_Source_Ocr_Data__Workpaper__workpaper_KEY | workpaper_KEY | Workpaper (workpaper_KEY) |