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
NameTypeConstraintsDescription
workpaper_source_ocr_data_KEYint (4)NOT NULLThe Primary Key.
workpaper_KEYint (4)NOT NULLDetermines which workpaper this record is tracking. It is also a foreign key to the Workpaper table.
page_numberint (4)NOT NULLThe page index of the OCR data within a document. Zero based.
ocr_data_xmlnvarchar (-1)NOT NULLThis 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_guiduniqueidentifier (16)NOT NULLA 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
NameColumnsDescription
PK_Workpaper_Source_Ocr_Dataworkpaper_source_ocr_data_KEY
Unique constraints
NameColumnsDescription
UK_Workpaper_Source_Ocr_Data$workpaper_KEY$page_numberworkpaper_KEY, page_number
UK_Workpaper_Source_Ocr_Data$workpaper_source_ocr_data_guidworkpaper_source_ocr_data_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Workpaper_Source_Ocr_Data__Workpaper__workpaper_KEYworkpaper_KEYWorkpaper (workpaper_KEY)

Schema diagram