BLOB_REFERENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: blob_reference
Definition: This table is used to store a row for each image. In the future it may contain other blob types such as video, sound, or presentation files.
Table Type: ACTIVITY





Column Detail - BLOB_REFERENCE


Column Name Type Null? Definition
BLOB_DT_TM DATETIME Y The date and time the blob was created.
BLOB_FOREIGN_IDENT VARCHAR(255) Y The field stores information regarding blob originating from a foreign system. For ex: For PathNet Anatomic Pathology Images that are imported from foreign systems, this column would be used to store information that can be used to get back to the original\source image in the foreign system.
BLOB_HANDLE VARCHAR(255) Y This field contains the unique identifier for the blob data. For AP Images it contains the DICOM UID string for the image.
BLOB_REF_ID DOUBLE N This field is the unique identifier for each blob_reference row.
BLOB_TITLE VARCHAR(255) Y This field contains the display name for the blob_reference row.
BLOB_TYPE_CD DOUBLE N This field contains a reference to code set 26820 which provides more information about the type of blob stored. For example, drivers license, consent form, requisition, etc.
CHARTABLE_NOTE_ID DOUBLE N This field contains the id of the long_text table row that contains the chartable note for the specific blob_reference row.
CREATE_PRSNL_ID DOUBLE N This field contains the personnel id for the person who added this blob_reference row.
DOCUMENT_ID DOUBLE N Uniquely identifies a logical document. There may be more than one row with the same document_id, but only one of those rows will be current as indicated by the valid_until_dt_tm field.
FORMAT_CD DOUBLE N This field contains the storage format identifier for a specific blob_reference row.
NON_CHARTABLE_NOTE_ID DOUBLE N This field contains the id of the long_text table row that contains the non-chartable note for the specific blob_reference ro
OWNER_CD DOUBLE N This is field is currently not used. In the future it may hold an identifier of the team that owns the blob_reference row.
PARENT_ENTITY_ID DOUBLE N This field contains an identifier for the parent table row.
PARENT_ENTITY_NAME VARCHAR(32) Y This field contains the name of table that this blob_reference row is associated to.
PUBLISH_FLAG DOUBLE N This field indicates whether or not this blob data should be published.
SEQUENCE_NBR DOUBLE N This field contains the display ordering for this blob_reference row.
SOURCE_DEVICE_CD DOUBLE N This field contains the unique identifier of the device that was used to capture the corresponding blob data.
STORAGE_CD DOUBLE N This field contains the unique identifier to indicate where the blob data is stored.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VALID_FROM_DT_TM DATETIME N This field contains the "Beginning Point" of when a row in the table is valid.
VALID_UNTIL_DT_TM DATETIME N This field contains the "End Point" of when a row in the table is valid.



Relationship Detail - BLOB_REFERENCE


Child Column in BLOB_REFERENCE(FK) Parent Table Name Parent Column Name
Parents: DOCUMENT_ID BLOB_REFERENCE BLOB_REF_ID
CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in BLOB_REFERENCE (PK) Child Table Name Child Column Name
Children: BLOB_REF_ID BLOB_REFERENCE DOCUMENT_ID
CDI_FORM_ACTIVITY BLOB_REF_ID
CDI_TRANS_LOG BLOB_REF_ID
PFT_QUEUE_ITEM BLOB_REF_ID
PFT_QUEUE_ITEM_HIST BLOB_REF_ID
PPR_CONSENT_POLICY BLOB_REF_SCAN_ID
PPR_CONSENT_STATUS BLOB_REF_SCAN_ID


CDI_AC_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Ascent Capture Batch
Definition: This table is used to track statistics for batches created in Kofax Capture. This data is copied from the third party system to this table by the CPDI Audit Service.
Table Type: ACTIVITY





Column Detail - CDI_AC_BATCH


Column Name Type Null? Definition
BATCHCLASS VARCHAR(32) N Name of the Kofax batch class on which the batch is based.
BATCHCLASSDESCRIPTION VARCHAR(80) N Description of the Kofax batch class on which the batch is based.
BATCHNAME VARCHAR(128) N Name assigned to the batch when it is created.
CDI_AC_BATCH_ID DOUBLE N The unique primary key of this table. It is internally generated.
CREATE_DT_TM DATETIME N The date and time when the batch was created.
CREATIONSTATIONID VARCHAR(32) N Identifies the Kofax Capture station where the batch was created. The Station ID is assigned during the Kofax installation process.
CREATIONUSERID VARCHAR(50) N If the User Profiles feature is enabled, this is the Kofax Capture login ID for the user who created the batch. If the feature is not enabled, this is the Windows login name for the user who created the batch. If a Windows login name is not required, the value is listed as "Unknown".
CREATIONUSERNAME VARCHAR(80) N If the User Profiles feature is enabled, this is the user name assigned in the profile of the user who created the batch. If the feature is not enabled, this is the Windows login name for the user who created the batch. If a Windows login name is not required, the value is listed as "Unknown".
EXTERNAL_BATCH_IDENT DOUBLE N Unique incremental value assigned to each batch that is created at a Kofax Capture site.
TRANSFERID VARCHAR(38) N Reserved for use by Kofax Capture.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CDI_AC_BATCH




Parent Column in CDI_AC_BATCH (PK) Child Table Name Child Column Name
Children: CDI_AC_BATCH_ID CDI_AC_BATCHMODULE CDI_AC_BATCH_ID
CDI_BATCH_SUMMARY CDI_AC_BATCH_ID


CDI_AC_BATCHCLASS



Column Section Relationship Section Top of Page


Table-level Detail

Description: CPDI Ascent Capture Batch Classes.
Definition: This table defines CPDI configurations for Ascent Capture Batch Classes.
Table Type: REFERENCE





Column Detail - CDI_AC_BATCHCLASS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ALIAS_CONTRIB_SRC_CD DOUBLE N Specifies the contributor source to use when resolving document type aliases for this batch class.
AUDITING_IND DOUBLE N Specifies whether or not to include this batch class for auditing and reporting.
AUTO_CLOSE DOUBLE N Specifies if the batch should be closed automatically when auto process is completed successfully.
AUTO_COMP_NOTIFY DOUBLE N Specifies if the validation operated should be notified when the batch has finished auto processing.
BATCHCLASS_NAME VARCHAR(32) N Ascent capture batch class name.
BATCH_PROFILE_IND DOUBLE N indicates that this is a batch profile (batch class) for use in KTA Advanced Capture
CDI_AC_BATCHCLASS_ID DOUBLE N Unique ID for the batch class.
CPDI_BATCH_CLASS_IND DOUBLE N Indicates if this is a CPDI batch class (1) or a Kofax batch class (0).
ORGANIZATION_ID DOUBLE N The ID of the organization the batch class is associated to.
SINGLE_ENCNTR DOUBLE N Specifies if the batch class is meant for single encounter batches. User will be prompted if the batch contains documents for multiple encounters.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - CDI_AC_BATCHCLASS


Child Column in CDI_AC_BATCHCLASS(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in CDI_AC_BATCHCLASS (PK) Child Table Name Child Column Name
Children: CDI_AC_BATCHCLASS_ID CDI_AC_BATCHCLASS_PARENT_R CDI_AC_BATCHCLASS_ID
CDI_DOCUMENT_TYPE CDI_AC_BATCHCLASS_ID
CDI_PENDING_BATCH CDI_AC_BATCHCLASS_ID


CDI_AC_BATCHCLASS_PARENT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI_AC_BATCHCLASS_PARENT_R
Definition: Table that relates cdi_ac_batchclass id's to document parent_level cd values from code set 26821.
Table Type: REFERENCE





Column Detail - CDI_AC_BATCHCLASS_PARENT_R


Column Name Type Null? Definition
CDI_AC_BATCHCLASS_ID DOUBLE N ID for batch class as defined on the CDI_AC_BATCHCLASS_ID table.
CDI_AC_BATCHCLASS_PARENT_R_ID DOUBLE N Unique generated number that identifies a single row on the CDI_AC_BATCHCLASS_PARENT_R table.
PARENT_LEVEL_CD DOUBLE N Document type parent level code value from code set 26821.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CDI_AC_BATCHCLASS_PARENT_R


Child Column in CDI_AC_BATCHCLASS_PARENT_R(FK) Parent Table Name Parent Column Name
Parents: CDI_AC_BATCHCLASS_ID CDI_AC_BATCHCLASS CDI_AC_BATCHCLASS_ID


CDI_AC_BATCHMODULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Ascent Capture Batch Module
Definition: The CDI Ascent Capture Batch Module table
Table Type: ACTIVITY





Column Detail - CDI_AC_BATCHMODULE


Column Name Type Null? Definition
BATCHDESCRIPTION VARCHAR(80) N batch description
BATCHMODULEID VARCHAR(38) N batch module identifier
BATCHSTATUS DOUBLE Y batch status
CDI_AC_BATCHMODULE_ID DOUBLE N cdi ascent capture batch module identifier
CDI_AC_BATCH_ID DOUBLE N cdi ascent capture batch identifier column
CHANGEDFORMTYPES DOUBLE Y changed form types
DELETED DOUBLE Y deleted
DOCUMENTSCREATED DOUBLE Y documents created
DOCUMENTSDELETED DOUBLE Y documents deleted
ENDDATETIME DATETIME N end date time
ERRORCODE DOUBLE Y error code
ERRORTEXT VARCHAR(255) N error text
EXPECTEDDOCS DOUBLE Y expected docs
EXPECTEDPAGES DOUBLE Y expected pages
EXTERNAL_BATCH_IDENT DOUBLE N external batch identifier value
MODULECLOSEUNIQUEID VARCHAR(250) N module close unique identifier
MODULELAUNCHID VARCHAR(38) N module launch identifier
MODULENAME VARCHAR(32) N module name
ORPHANED DOUBLE Y orphaned
PAGESDELETED DOUBLE Y PAGES DELETED
PAGESPERDOCUMENT DOUBLE Y pages per document
PAGESREPLACED DOUBLE Y pages replaced
PAGESSCANNED DOUBLE Y pages scanned
PRIORITY DOUBLE Y priority value
STARTDATETIME DATETIME Y start date and time
TRANSFERID VARCHAR(38) N transfer identifier
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CDI_AC_BATCHMODULE


Child Column in CDI_AC_BATCHMODULE(FK) Parent Table Name Parent Column Name
Parents: CDI_AC_BATCH_ID CDI_AC_BATCH CDI_AC_BATCH_ID