Table Detail Report

DMS_MEDIA_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Digital Media Services Media Group
Definition: Provides group relationship and member sequencing history. Contains parent/child & sequence information for media objects.
Table Type: ACTIVITY





Column Detail - DMS_MEDIA_GROUP


Column Name Type Null? Definition
DMS_MEDIA_CHILD_ID DOUBLE N References the dms_media_instance table for this group item.
DMS_MEDIA_GROUP_ID DOUBLE N Unique Identifier for the row.
DMS_MEDIA_PARENT_ID DOUBLE N References the dms_media_instance table for the parent of this group object.
DMS_MEDIA_SEQUENCE DOUBLE N Contains the group sequence value for this child item.
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_MEDIA_GROUP


Child Column in DMS_MEDIA_GROUP(FK) Parent Table Name Parent Column Name
Parents: DMS_MEDIA_CHILD_ID DMS_MEDIA_INSTANCE DMS_MEDIA_INSTANCE_ID
DMS_MEDIA_PARENT_ID DMS_MEDIA_INSTANCE DMS_MEDIA_INSTANCE_ID


DMS_MEDIA_IDENTIFIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Digital Media Services Media identifier
Definition: Provides indexes and references to media object identifiers.
Table Type: ACTIVITY





Column Detail - DMS_MEDIA_IDENTIFIER


Column Name Type Null? Definition
DMS_MEDIA_IDENTIFIER_ID DOUBLE N Unique identifier for the row
MEDIA_OBJECT_IDENTIFIER VARCHAR(64) N Contains the uniquely generated identifier for this media object.
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_MEDIA_IDENTIFIER




Parent Column in DMS_MEDIA_IDENTIFIER (PK) Child Table Name Child Column Name
Children: DMS_MEDIA_IDENTIFIER_ID DMS_ASSOCIATION MEDIA_SOURCE_ID
DMS_ASSOCIATION MEDIA_TARGET_ID
DMS_MEDIA_OWNERSHIP DMS_MEDIA_IDENTIFIER_ID


DMS_MEDIA_INSTANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Digital Media Services - Media Instance.
Definition: Contains references to media items in the Media Management archive.
Table Type: ACTIVITY





Column Detail - DMS_MEDIA_INSTANCE


Column Name Type Null? Definition
APP_CTX VARCHAR(128) Y A string mnemonic of the application in context when this instance was created.
CHECKSUM DOUBLE N This contains the checksum value for the stored content.
CONSUMERCREATED_DT_TM DATETIME Y The media object's creation date and time set by the consumer. Basically it is whatever date the consumer says is the actual creation date, because they may have an object they created weeks before they actually put into MOM.
CONSUMERCREATED_PREC_FLAG DOUBLE N Used to indicate date precision. 0 - Date is precise to the second, 1 - Date is precise to the minute, 2 - Date is precise to the hour, 3 - Date is precise to the day, 4 - Date is precise to the month, 5 - Date is precise to the year.
CONSUMERCREATED_TZ DOUBLE N The time zone for the consumer created time.
CONTENT_SIZE DOUBLE N Indicates the byte size of the content.
CONTENT_TYPE VARCHAR(32) N OBSOLETE - NO LONGER USED. Replaced by dms_content_type_id.
CONTENT_UID VARCHAR(64) N The unique key to the content instance in the media archive.
CONTRIBUTION_DT_TM DATETIME Y The date and time this version of the media object was contributed
CONTRIBUTOR_ID DOUBLE N The ID of the user who contributed this version of the media object.
CREATED_BY_ID DOUBLE N The person_id that represents the individual that created this row.
CREATED_DT_TM DATETIME N The date and time that this row was created.
DMS_CONTENT_TYPE_ID DOUBLE N The type of content that this media instance refers to.
DMS_MEDIA_IDENTIFIER_GROUP_ID DOUBLE N This column points to the DMS_MEDIA_IDENTIFIER row if the row is part of a group.
DMS_MEDIA_IDENTIFIER_ID DOUBLE N References the DMS_MEDIA_IDENTIFIER table for the media object identifier.
DMS_MEDIA_INSTANCE_ID DOUBLE N Unique identifier for the row.
DMS_REPOSITORY_ID DOUBLE N Index to the dms_repository table
DMS_XML_METADATA_ID DOUBLE N This is the identifier of the XML data in table DMS_XML_Metadata.
ENCRYPTION_IND DOUBLE N indicates the instance is encrypted
IDENTIFIER VARCHAR(64) N ** OBSOLETE - NO LONGER USED ** - The uniquely generated identifier for this media item.
LONG_BLOB_ID DOUBLE N This is a foreign key to the long_blob table used to store content when the archive is not used.
LONG_TEXT_ID DOUBLE N Reference to the LONG_TEXT_REFERENCE table for the actual XML metadata file.
MEDIA_TYPE VARCHAR(255) N Indicates the format of the content that this row refers to. Examples include "text/plain", "text/xml", etc.
METADATA_VERSION DOUBLE Y The version number of the meta-data schema that is associated with this media instance.
NAME VARCHAR(255) Y The name or title associated to the media instance.
SENSITIVE_LEVEL_NBR DOUBLE N This column is used to indicate sensitivity level. Any value greater than zero indicates that the object is sensitive.
SERVICESTART_DT_TM DATETIME Y The service start time.
SERVICESTART_PREC_FLAG DOUBLE N Used to indicate date precision. 0 - Date is precise to the second, 1 - Date is precise to the minute, 2 - Date is precise to the hour, 3 - Date is precise to the day, 4 - Date is precise to the month, 5 - Date is precise to the year.
SERVICESTART_TZ DOUBLE N The time zone for the service start time.
SERVICESTOP_DT_TM DATETIME Y The service stop time.
SERVICESTOP_PREC_FLAG DOUBLE N Used to indicate date precision. 0 - Date is precise to the second, 1 - Date is precise to the minute, 2 - Date is precise to the hour, 3 - Date is precise to the day, 4 - Date is precise to the month, 5 - Date is precise to the year.
SERVICESTOP_TZ DOUBLE N The time zone for the service stop time.
STATUS_FLAG DOUBLE N This column is used to indicate the state of the dms_media_instance row, either active, inactive or in-error. Additional statuses may also be stored. -2 - Deleted, -1 - In error, 0 - Inactive, 1 - Active, 2 - Inactive waiting deletion, 3 - Initialized.
STORED_AS_DICOM_IND DOUBLE N Used to indicate that the object was stored as a Dicom object. 0 - Not a Dicom object, 1 - Dicom object.
THUMBNAIL_UID VARCHAR(64) Y The unique key to the thumbnail image instance in the media archive.
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.
VERSION DOUBLE N The version of the media instance. The first version is version 1.



Relationship Detail - DMS_MEDIA_INSTANCE


Child Column in DMS_MEDIA_INSTANCE(FK) Parent Table Name Parent Column Name
Parents: DMS_CONTENT_TYPE_ID DMS_CONTENT_TYPE DMS_CONTENT_TYPE_ID
DMS_REPOSITORY_ID DMS_REPOSITORY DMS_REPOSITORY_ID
LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
CONTRIBUTOR_ID PRSNL PERSON_ID
CREATED_BY_ID PRSNL PERSON_ID




Parent Column in DMS_MEDIA_INSTANCE (PK) Child Table Name Child Column Name
Children: DMS_MEDIA_INSTANCE_ID DMS_EVENT DMS_MEDIA_INSTANCE_ID
DMS_MEDIA_GROUP DMS_MEDIA_CHILD_ID
DMS_MEDIA_GROUP DMS_MEDIA_PARENT_ID
DMS_MEDIA_METADATA DMS_MEDIA_INSTANCE_ID
DMS_MEDIA_SIGNATURE DMS_MEDIA_INSTANCE_ID
DMS_VIEWER DMS_MEDIA_INSTANCE_ID


DMS_MEDIA_METADATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: DMS Media Meta-data
Definition: Contains application defined data that is relevant to a given media instance.
Table Type: ACTIVITY





Column Detail - DMS_MEDIA_METADATA


Column Name Type Null? Definition
DMS_MEDIA_INSTANCE_ID DOUBLE N The media instance that is associated with this row.
DMS_MEDIA_METADATA_ID DOUBLE N Unique identifier for the row.
TAG_NAME VARCHAR(40) N The name of the metadata tag associated with this row.
TAG_PATH VARCHAR(255) N The fully qualified path of the metadata tag that this row is associated with.
TAG_SEQ DOUBLE Y This field is used if the path to a given tag contains multiple results. This sequence value will ensure that the order remains the same as originally entered.
TAG_VALUE VARCHAR(255) N The string value of this tag.
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_MEDIA_METADATA


Child Column in DMS_MEDIA_METADATA(FK) Parent Table Name Parent Column Name
Parents: DMS_MEDIA_INSTANCE_ID DMS_MEDIA_INSTANCE DMS_MEDIA_INSTANCE_ID


DMS_MEDIA_METADATA_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: DMS Media Meta-data reference.
Definition: Contains the media metadata XML definitions for a given content type.
Table Type: REFERENCE





Column Detail - DMS_MEDIA_METADATA_REF


Column Name Type Null? Definition
DMS_CONTENT_TYPE_ID DOUBLE N The type of content that this definition is for.
DMS_MEDIA_METADATA_REF_ID DOUBLE N Unique identifier for the row.
LONG_TEXT_ID DOUBLE N Reference to the LONG_TEXT_REFERENCE table for the actual XML schema definition
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.
VERSION DOUBLE N The version of this schema definition.



Relationship Detail - DMS_MEDIA_METADATA_REF


Child Column in DMS_MEDIA_METADATA_REF(FK) Parent Table Name Parent Column Name
Parents: DMS_CONTENT_TYPE_ID DMS_CONTENT_TYPE DMS_CONTENT_TYPE_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


2024.4.01Data Models:Table Name Index

Table Detail Report

CPS_JP_CAMM_VALIDATEHISTORY



Column Section Top of Page


Table-level Detail

Description: CammPlatformServices_JobParameters_validate History
Definition: Holds information about Validate History job parameters
Table Type: ACTIVITY





Column Detail - CPS_JP_CAMM_VALIDATEHISTORY


Column Name Type Null? Definition
CPS_JP_CAMM_VALIDATEHISTORY_ID DOUBLE N PRIMARY KEY
CPS_JQ_CAMM_VALIDATEHISTORY_ID DOUBLE N Unique number that identifies a single row on the CPS_JQ_VALIDATEHISTORY table.
PARAM_NAME VARCHAR(200) N parameter name for the CPS_JQ_VALIDATEHISTORY job.
PARAM_VALUE VARCHAR(4000) N value of the corresponding CPS_JQ_VALIDATEHISTORY parameter.
SEQUENCE_NBR DOUBLE N Number that specifies the order of the parameter for the corresponding CPS_JQ_VALIDATEHISTORY job.
SYS_TS DATETIME(6) N TimeStamp of when the job parameter was inserted/updated, generated by the database
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.


CPS_JP_CAMM_VALIDATESTUDY



Column Section Top of Page


Table-level Detail

Description: CammPlatformServices_JobParameters_validate study
Definition: Holds information about Validate study job parameters
Table Type: ACTIVITY





Column Detail - CPS_JP_CAMM_VALIDATESTUDY


Column Name Type Null? Definition
CPS_JP_CAMM_VALIDATESTUDY_ID DOUBLE N PRIMARY KEY
CPS_JQ_CAMM_VALIDATESTUDY_ID DOUBLE N Unique number that identifies a single row on the CPS_JQ_VALIDATESTUDY table.
PARAM_NAME VARCHAR(200) N parameter name for the CPS_JQ_VALIDATESTUDY job.
PARAM_VALUE VARCHAR(4000) N value of the corresponding CPS_JQ_VALIDATESTUDY parameter.
SEQUENCE_NBR DOUBLE N Number that specifies the order of the parameter for the corresponding CPS_JQ_VALIDATESTUDY job.
SYS_TS DATETIME(6) N TimeStamp of when the job parameter was inserted/updated, generated by the database
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.


CPS_JQ_CAMM_DELETECONTENT



Column Section Top of Page


Table-level Detail

Description: CammPlatformServices_JobQueue_DELETECONTENT
Definition: Holds information about delete content (CAMM DO) jobs while they are queued to be processed
Table Type: ACTIVITY





Column Detail - CPS_JQ_CAMM_DELETECONTENT


Column Name Type Null? Definition
CPS_EQ_ID DOUBLE Y Unique number that identifies an event in the CAMM archive system
CPS_JQ_CAMM_DELETECONTENT_ID DOUBLE N PRIMARY KEY
CPS_RULE_ID DOUBLE Y Unique number that identifies a Rule in the CAMM archive system
ENTITY_IDENT VARCHAR(200) Y Unique string that identifies the object being acted upon
EXPIRATION_TS DATETIME(6) Y TRY_CNT
FAILURE_CNT DOUBLE Y Number of times the job was failed processing
IN_PROGRESS_IND DOUBLE Y Flag that indicates if the job is currently being processed
JOB_TS DATETIME(6) Y TimeStamp of when the job was submitted provided by code
NEXT_RETRY_TS DATETIME(6) Y TimeStamp of when the Job must be retried.
STATUS_MESSAGE VARCHAR(2000) Y The status of the job processing
SYS_TS DATETIME(6) N TimeStamp of when the job was inserted/updated, generated by the database
TARGET_IDENT VARCHAR(300) Y Unique string that identifies a target for the job
TENANT_IDENT VARCHAR(64) Y Unique string that identifies a Tenant in the CAMM archive system
TRY_CNT DOUBLE Y Number of times the job was attempted to be processed


CPS_JQ_CAMM_GDPR_DELSTUDY



Column Section Top of Page


Table-level Detail

Description: CPS_JQ_CAMM_GDPR_DELSTUDY
Definition: Holds information about delete study (CAMM DO) jobs while they are queued to be processed
Table Type: ACTIVITY





Column Detail - CPS_JQ_CAMM_GDPR_DELSTUDY


Column Name Type Null? Definition
CPS_EQ_ID DOUBLE Y Unique number that identifies an event in the CAMM archive system
CPS_JQ_CAMM_GDPR_DELSTUDY_ID DOUBLE N PRIMARY KEY
CPS_RULE_ID DOUBLE Y Unique number that identifies a Rule in the CAMM archive system
ENTITY_IDENT VARCHAR(200) Y Unique string that identifies the object being acted upon
EXPIRATION_TS DATETIME(6) Y TRY_CNT
FAILURE_CNT DOUBLE Y Number of times the job was failed processing
IN_PROGRESS_IND DOUBLE Y Flag that indicates if the job is currently being processed
JOB_TS DATETIME(6) Y TimeStamp of when the job was submitted provided by code
NEXT_RETRY_TS DATETIME(6) Y TimeStamp of when the Job must be retried.
STATUS_MESSAGE VARCHAR(2000) Y The status of the job processing
SYS_TS DATETIME(6) N TimeStamp of when the job was inserted/updated, generated by the database
TARGET_IDENT VARCHAR(300) Y Unique string that identifies a target for the job
TENANT_IDENT VARCHAR(64) Y Unique string that identifies a Tenant in the CAMM archive system
TRY_CNT DOUBLE Y Number of times the job was attempted to be processed


CPS_JQ_CAMM_GDPR_HIDESTUDY



Column Section Top of Page


Table-level Detail

Description: CPS_JQ_CAMM_GDPR_HIDESTUDY
Definition: Holds information about hide study (CAMM DO) jobs while they are queued to be processed
Table Type: ACTIVITY





Column Detail - CPS_JQ_CAMM_GDPR_HIDESTUDY


Column Name Type Null? Definition
CPS_EQ_ID DOUBLE Y Unique number that identifies an event in the CAMM archive system
CPS_JQ_CAMM_GDPR_HIDESTUDY_ID DOUBLE N PRIMARY KEY
CPS_RULE_ID DOUBLE Y Unique number that identifies a Rule in the CAMM archive system
ENTITY_IDENT VARCHAR(200) Y Unique string that identifies the object being acted upon
EXPIRATION_TS DATETIME(6) Y TRY_CNT
FAILURE_CNT DOUBLE Y Number of times the job was failed processing
IN_PROGRESS_IND DOUBLE Y Flag that indicates if the job is currently being processed
JOB_TS DATETIME(6) Y TimeStamp of when the job was submitted provided by code
NEXT_RETRY_TS DATETIME(6) Y TimeStamp of when the Job must be retried.
STATUS_MESSAGE VARCHAR(2000) Y The status of the job processing
SYS_TS DATETIME(6) N TimeStamp of when the job was inserted/updated, generated by the database
TARGET_IDENT VARCHAR(300) Y Unique string that identifies a target for the job
TENANT_IDENT VARCHAR(64) Y Unique string that identifies a Tenant in the CAMM archive system
TRY_CNT DOUBLE Y Number of times the job was attempted to be processed