Table: dbo.Workpaper_Source_Document_Processing
This table stores information about a workpaper as it is being sent to Source Document Processing. Entries in this table will tracking an automated process that uploads a file to be OCRd, waits for processing to be complted, downloads the file and then splits up documents. Each workpaper has only one entry in this table and the status gets updated as changes occur. Workpaper entries can be Added, processed and Uploaded/Downloaded to secure servers for OCR processing from Engagement Binder Window in Workpaper Dashboard. They can also be processed and Uploaded/Downloaded from Source Document Portlet (Firm Dashboard)
Columns
NameTypeConstraintsDescription
workpaper_KEYint (4)NOT NULLDetermines which workpaper this record is tracking. The Primary Key.
workpaper_source_document_processing_status_KEYint (4)NOT NULLThe current state of processing for the workpaper.
request_idint (4)This value is sent to us by Source Document Processing and can be used to track the status of this particular record. Before processing the request_id will be null. After processing begins we will be given a positive unique integer that will identify the request.
error_has_occurredbit (1)NOT NULLSpecifies if an error occured while processing this record at this current state.
date_last_submitteddatetime (8, 3)When workpaper entry is added, value should be NULL as entry is not yet processed. Date and time value is stored when engagement binder is processed. As workpaper entries could be Processed, Cancelled and again Processed, this column stores only last processed date and time values.
date_last_completeddatetime (8, 3)When workpaper entry is added, value should be NULL as entry is not yet downloaded. Date and time value is stored when engagement binder is downloaded. This column stores only last downloaded date and time values.
Primary key
NameColumnsDescription
PK_Workpaper_Source_Document_Processing$workpaper_KEYworkpaper_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Workpaper_Source_Document_Processing__Workpaper__workpaper_KEYworkpaper_KEYWorkpaper (workpaper_KEY)
FK_Workpaper_Source_Document_Processing__Workpaper_Source_Document_Processing_Status__workpaper_source_document_processing_statuworkpaper_source_document_processing_status_KEYWorkpaper_Source_Document_Processing_Status (workpaper_source_document_processing_status_KEY)

Schema diagram