AUTO_MATCH_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains the DICOM tags that should be used during auto matching
Definition: Auto Match Definition
Table Type: REFERENCE





Column Detail - AUTO_MATCH_DEFINITION


Column Name Type Null? Definition
ACTIVITY_SUBTYPE_CD DOUBLE N This column is used to flex the definitions by modality
AUTO_MATCH_DEF_ID DOUBLE N This column is the primary key and is set using the clin_image_seq number.
DISCIPLINE_CD DOUBLE N The discipline, such as radiology or cardiology, for which the auto match definition data applies.
HISTORICAL_IND DOUBLE Y Indicator is used to tell whether or not the row is for a historical auto match definition
IMAGE_TAG VARCHAR(11) N this column is a foreign key to the IMAGE_MATCH_TAG table. It identifies the DICOM tag from the image that should be compared.
IM_DEVICE_ID DOUBLE N This column contains a foreign key to the IM_DEVICE table. It allows for flexing the definition by a specific exam room.
RIS_TAG VARCHAR(11) N This column is a foreign key to the IMAGE_MATCH_TAG table. It identifies the tag from the RIS that should be used to compare.
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.
VALUE_TYPE VARCHAR(16) N The definable type of value contained in the flag.



Relationship Detail - AUTO_MATCH_DEFINITION


Child Column in AUTO_MATCH_DEFINITION(FK) Parent Table Name Parent Column Name
Parents: IMAGE_TAG IMAGE_MATCH_TAG TAG
RIS_TAG IMAGE_MATCH_TAG TAG
IM_DEVICE_ID IM_DEVICE IM_DEVICE_ID


DMS_ASSOCIATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: DMS Association
Definition: This table is used to create media object associations such as annotations.
Table Type: ACTIVITY





Column Detail - DMS_ASSOCIATION


Column Name Type Null? Definition
ASSOCIATION_TYPE_FLAG DOUBLE N This flag indicates the type of association. 0 - Not specified, 1- XFRM (Transform), 2 - XFRM replace, 3 - RPLC (Replace), 4 - Append, 5 - Annotation, 6 - Signs.
DMS_ASSOCIATION_ID DOUBLE N The unique primary key of the DMS_Association table
MEDIA_SOURCE_ID DOUBLE N Foreign key to the dms_media_identifier table representing the source object for the association. This will be the base document for annotations.
MEDIA_SOURCE_VERSION DOUBLE N The version of the media source instance. The first version is version 1.
MEDIA_TARGET_ID DOUBLE N Foreign key to the dms_media_identifier table representing the target object for the association. This will be the annotation object.
MEDIA_TARGET_VERSION DOUBLE N The version of the media target instance. The first version is version 1.
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 - DMS_ASSOCIATION


Child Column in DMS_ASSOCIATION(FK) Parent Table Name Parent Column Name
Parents: MEDIA_SOURCE_ID DMS_MEDIA_IDENTIFIER DMS_MEDIA_IDENTIFIER_ID
MEDIA_TARGET_ID DMS_MEDIA_IDENTIFIER DMS_MEDIA_IDENTIFIER_ID


DMS_CONTENT_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Digital media services content type.
Definition: Contains information about the general classification of media items.
Table Type: REFERENCE





Column Detail - DMS_CONTENT_TYPE


Column Name Type Null? Definition
ACCESS_FLAG DOUBLE N This flag will be used by solutions to determine access privileges. 0 - No access, 1-Read access, 2 - Write access, 3 - Read/Write access.
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.
AUDIT_IND DOUBLE N Indicator used to enable or disable auditing for events on objects with this content type.
AUDIT_NAME VARCHAR(64) Y The name of the audit event to use for this content type.
CERNER_IND DOUBLE N This column is used to identify Cerner defined content types.
CONTENT_GROUP_NAME VARCHAR(32) Y Grouping mechanism used for storage usage reporting.
CONTENT_TYPE_KEY VARCHAR(32) N The content type key (no spaces, all uppercase)
DESCRIPTION VARCHAR(255) N The description of the content type
DISPLAY VARCHAR(60) N The display name of the content type
DMS_CONTENT_TYPE_ID DOUBLE N Unique identifier for this row
DMS_REPOSITORY_ID DOUBLE N Foreign key to the DMS_REPOSITORY table.
EXPIRATION_DURATION DOUBLE N The length of time (in days) to keep media instances of this content type.
MAX_VERSIONS DOUBLE N The maximum versions that can be stored for media instances of this content type
METADATA_TABLE_EXISTS DOUBLE N An indicator used to determine if XML Metadata queries are allowed.
OWNERSHIP_IND DOUBLE N Indicates if ownership is allowed or not.
SIGNATURE_REQ_IND DOUBLE N Used to indicate if digital signatures are required for a content type. If set to 0 then digital signatures are not required to save a media instance with this content type. If set to 1 then digital signatures are required to save a media instance with this content type.
TEMPORARY_IND DOUBLE N Indicates the temporal nature of the content
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 - DMS_CONTENT_TYPE


Child Column in DMS_CONTENT_TYPE(FK) Parent Table Name Parent Column Name
Parents: DMS_REPOSITORY_ID DMS_REPOSITORY DMS_REPOSITORY_ID




Parent Column in DMS_CONTENT_TYPE (PK) Child Table Name Child Column Name
Children: DMS_CONTENT_TYPE_ID DMS_EVENT_REASON_R DMS_CONTENT_TYPE_ID
DMS_MEDIA_INSTANCE DMS_CONTENT_TYPE_ID
DMS_MEDIA_METADATA_REF DMS_CONTENT_TYPE_ID
DMS_VIEWER CONTENT_TYPE_ID


DMS_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DMS event
Definition: Contains reference names and display values for attributes of media instances.
Table Type: ACTIVITY





Column Detail - DMS_EVENT


Column Name Type Null? Definition
CREATED_BY_ID DOUBLE N The id of the user that initiated the event
DMS_EVENT_ID DOUBLE N Unique identifier for this row
DMS_EVENT_REF_ID DOUBLE N The id of the event that we are tracking
DMS_MEDIA_INSTANCE_ID DOUBLE N The media instance that is associated to the row
DMS_REASON_REF_ID DOUBLE N Optional reason associated to the event
EVENT_COMMENT VARCHAR(255) Y Optional comment associated to the event
EVENT_DETAIL VARCHAR(255) Y Textual details associated to the event
EVENT_DT_TM DATETIME N The date and time of the event we are tracking
LONG_TEXT_ID DOUBLE N If the details will not fit into the EVENT_DETAIL column, this will reference the details that are stored on the LONG_TEXT table.
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 - DMS_EVENT


Child Column in DMS_EVENT(FK) Parent Table Name Parent Column Name
Parents: DMS_MEDIA_INSTANCE_ID DMS_MEDIA_INSTANCE DMS_MEDIA_INSTANCE_ID
DMS_EVENT_REF_ID DMS_REF DMS_REF_ID
DMS_REASON_REF_ID DMS_REF DMS_REF_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
CREATED_BY_ID PRSNL PERSON_ID


DMS_EVENT_REASON_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: DMS event reason relationship.
Definition: Contains event reason relationship information. It related content types to valid reasons for content retrieval.
Table Type: REFERENCE





Column Detail - DMS_EVENT_REASON_R


Column Name Type Null? Definition
DMS_CONTENT_TYPE_ID DOUBLE N Refers to a specific content type
DMS_EVENT_REASON_R_ID DOUBLE N Unique identifier for this row
DMS_REASON_REF_ID DOUBLE N Refers to a specific event reason
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 - DMS_EVENT_REASON_R


Child Column in DMS_EVENT_REASON_R(FK) Parent Table Name Parent Column Name
Parents: DMS_CONTENT_TYPE_ID DMS_CONTENT_TYPE DMS_CONTENT_TYPE_ID
DMS_REASON_REF_ID DMS_REF DMS_REF_ID


2024.4.01Data Models:Table Name Index

CPS_JP_CAMM_DELETECONTENT



Column Section Top of Page


Table-level Detail

Description: CPS_JP_CAMM_DELETECONTENT
Definition: Holds information about delete content (CAMM DO) job parameters
Table Type: ACTIVITY





Column Detail - CPS_JP_CAMM_DELETECONTENT


Column Name Type Null? Definition
CPS_JP_CAMM_DELETECONTENT_ID DOUBLE N PRIMARY KEY
CPS_JQ_CAMM_DELETECONTENT_ID DOUBLE N Foreign Key Value
PARAM_NAME VARCHAR(200) Y parameter name for the CPS_JQ_CAMM_DELETECONTENT job.
PARAM_VALUE VARCHAR(4000) Y value of the corresponding CPS_JQ_CAMM_DELETECONTENT parameter.
SEQUENCE_NBR DOUBLE Y Number that specifies the order of the parameter for the corresponding CPS_JQ_CAMM_DELETECONTENT job.
SYS_TS DATETIME(6) N TimeStamp of when the job parameter was inserted/updated, generated by the database


CPS_JP_CAMM_GDPR_DELSTUDY



Column Section Top of Page


Table-level Detail

Description: CPS_JP_CAMM_GDPR_DELSTUDY
Definition: Holds information about delete study (CAMM DO) job parameters
Table Type: ACTIVITY





Column Detail - CPS_JP_CAMM_GDPR_DELSTUDY


Column Name Type Null? Definition
CPS_JP_CAMM_GDPR_DELSTUDY_ID DOUBLE N PRIMARY KEY
CPS_JQ_CAMM_GDPR_DELSTUDY_ID DOUBLE N Foreign Key Value
PARAM_NAME VARCHAR(200) Y parameter name for the CPS_JQ_CAMM_DELETECONTENT job.
PARAM_VALUE VARCHAR(4000) Y value of the corresponding CPS_JQ_CAMM_DELETECONTENT parameter.
SEQUENCE_NBR DOUBLE Y Number that specifies the order of the parameter for the corresponding CPS_JQ_CAMM_DELETECONTENT job.
SYS_TS DATETIME(6) N TimeStamp of when the job parameter was inserted/updated, generated by the database


CPS_JP_CAMM_GDPR_HIDESTUDY



Column Section Top of Page


Table-level Detail

Description: CPS_JP_CAMM_GDPR_HIDESTUDY
Definition: Holds information about hide study (CAMM DO) job parameters
Table Type: ACTIVITY





Column Detail - CPS_JP_CAMM_GDPR_HIDESTUDY


Column Name Type Null? Definition
CPS_JP_CAMM_GDPR_HIDESTUDY_ID DOUBLE N PRIMARY KEY
CPS_JQ_CAMM_GDPR_HIDESTUDY_ID DOUBLE N Foreign Key Value
PARAM_NAME VARCHAR(200) Y parameter name for the CPS_JQ_CAMM_DELETECONTENT job.
PARAM_VALUE VARCHAR(4000) Y value of the corresponding CPS_JQ_CAMM_DELETECONTENT parameter.
SEQUENCE_NBR DOUBLE Y Number that specifies the order of the parameter for the corresponding CPS_JQ_CAMM_DELETECONTENT job.
SYS_TS DATETIME(6) N TimeStamp of when the job parameter was inserted/updated, generated by the database


CPS_JP_CAMM_GDPR_RESTSTUDY



Column Section Top of Page


Table-level Detail

Description: CPS_JP_CAMM_GDPR_RESTSTUDY
Definition: Holds information about restore study (CAMM DO) job parameters
Table Type: ACTIVITY





Column Detail - CPS_JP_CAMM_GDPR_RESTSTUDY


Column Name Type Null? Definition
CPS_JP_CAMM_GDPR_RESTSTUDY_ID DOUBLE N PRIMARY KEY
CPS_JQ_CAMM_GDPR_RESTSTUDY_ID DOUBLE N Foreign Key Value
PARAM_NAME VARCHAR(200) Y parameter name for the CPS_JQ_CAMM_DELETECONTENT job.
PARAM_VALUE VARCHAR(4000) Y value of the corresponding CPS_JQ_CAMM_DELETECONTENT parameter.
SEQUENCE_NBR DOUBLE Y Number that specifies the order of the parameter for the corresponding CPS_JQ_CAMM_DELETECONTENT job.
SYS_TS DATETIME(6) N TimeStamp of when the job parameter was inserted/updated, generated by the database


CPS_JP_CAMM_UPDATESTUDY



Column Section Top of Page


Table-level Detail

Description: CammPlatformServices_JobParameters_MATCH_STUDY
Definition: Holds information about match study job parameters
Table Type: ACTIVITY





Column Detail - CPS_JP_CAMM_UPDATESTUDY


Column Name Type Null? Definition
CPS_JP_CAMM_UPDATESTUDY_ID DOUBLE N PRIMARY KEY ( using sequence CPS_JOB_SEQ )
CPS_JQ_CAMM_UPDATESTUDY_ID DOUBLE N Unique number that identifies a single row on the CPS_JQ_MATCH_STUDY table.
PARAM_NAME VARCHAR(200) Y parameter name for the CPS_MATCH_STUDY job.
PARAM_VALUE VARCHAR(4000) Y value of the corresponding CPS_MATCH_STUDY parameter.
SEQUENCE_NBR DOUBLE Y Number that specifies the order of the parameter for the corresponding CPS_MATCH_STUDY job.
SYS_TS DATETIME(6) N TimeStamp of when the job parameter was inserted/updated
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.