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 |