BLOB_SUMMARY_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: blob_summary_ref
Definition: This table contains a row for each Thumbnail of an anatomic pathology image.
Table Type: ACTIVITY





Column Detail - BLOB_SUMMARY_REF


Column Name Type Null? Definition
BLOB_REF_ID DOUBLE N This field contains unique identifier of the blob_reference row to which this blob_summary_ref row is derived from.
COMPRESSION_CD DOUBLE N This field contains the unique identifier for the compression algorithm used to store the blob.
FORMAT_CD DOUBLE N This field contains the storage format identifier for a specific thumbnail row.
LONG_BLOB_ID DOUBLE N This field contains the unique identifier for the long_blob row that contains the thumbnail image data.
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 - BLOB_SUMMARY_REF


Child Column in BLOB_SUMMARY_REF(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID


PVW_DATASET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains DICOM SOP UIDS including archiving information.
Definition: DATESET FOR DICOM STANDARD. UIDS are stored. Indicates archiving solution/location.
Table Type: ACTIVITY





Column Detail - PVW_DATASET


Column Name Type Null? Definition
ARCHIVE_CD DOUBLE N Identifies the archive soulution available
ARCHIVE_LOC_CD DOUBLE N Multiple Storage/ archive can be supported.
BLOB_HANDLE VARCHAR(255) Y Indicating the actual location of the image.
DATASET_REF_ID DOUBLE N Unique identifier for each row of data in the Proview SOP table.
DATASET_UID VARCHAR(512) N Unique identifier that identifies the image (SOP Instance UID) or a study UID or Series UID. This would conform to DICOM standard
LEVEL_CD DOUBLE N Study Level, Series Level, Image Level Identifier
PARENT_DATASET_REF_ID DOUBLE N Parent dataset_ref_id to maintain parent child relationship.
PARENT_ENTITY_ID DOUBLE N Unique identifier of the row in the table defined by Parent Entity Name.
PARENT_ENTITY_NAME VARCHAR(32) Y Identifies a table where additional information about this row could be found
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - PVW_DATASET


Child Column in PVW_DATASET(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID


PVW_DICOMAE



Column Section Top of Page


Table-level Detail

Description: PVW_DICOMApplicationEntity
Definition: This table holds DICOM information regarding AE title, host and address.
Table Type: ACTIVITY





Column Detail - PVW_DICOMAE


Column Name Type Null? Definition
AE_HOST_ADDR VARCHAR(64) N This field contains the IP host address of the location where the DICOM software is located.
AE_HOST_NAME VARCHAR(64) N This field contains the IP host name of the location where the DICOM software is located.
AE_ID DOUBLE N Unique identifier representing a row in the table.
AE_TITLE VARCHAR(12) N Application Entity Title
ARCHIVE_LOCATION_CD DOUBLE N Identifies the AE title that is responsible for the storage.
PORT_NUMBER DOUBLE Y Socket port number.
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.
VENDOR_CD DOUBLE N Image viewer vendor