Table: dbo.PPC_Workpaper
This table stores document information of a PPC Checkpoint Tools documents. WorkpaperCS can integration with PPCs Checkpoint Tools by allowing users to add PPC Checkpoint Tools document into WorkpaperCS. Information stored in this table come from Custom Properties of PPC Checkpoint tools Excel or Word documents.
Columns
NameTypeConstraintsDescription
workpaper_KEYint (4)NOT NULLPrimary key for this table and a foreign key to the Workpaper table.
template_versionnvarchar (512)NOT NULLPPC Checkpoint Tools template version.
product_codenvarchar (512)NOT NULLPPC Checkpoint Tools product code.
template_file_namenvarchar (512)NOT NULLPPC Checkpoint Tools template file name.
template_titlenvarchar (512)NOT NULLPPC Checkpoint Tools template title.
template_id_guiduniqueidentifier (16)NOT NULLPPC Checkpoint Tools template id. This is their document id as Guid format.
book_acronymnvarchar (512)NOT NULLPPC CheckpointTools template document book_acronym custom property. Data stored in this column comes from PPC CheckpointTools OBET type template Word or Excel document custom properties. They will be empty for non-OBET type template documents.
Primary key
NameColumnsDescription
PK_PPC_Workpaper$workpaper_KEYworkpaper_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_PPC_Workpaper__Workpaper__workpaper_KEYworkpaper_KEYWorkpaper (workpaper_KEY)

Schema diagram