Table Detail Report

DMS_MEDIA_OWNERSHIP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Digital Media Services Media Ownership
Definition: Contains media ownership keys that relate to media objects.
Table Type: ACTIVITY





Column Detail - DMS_MEDIA_OWNERSHIP


Column Name Type Null? Definition
DMS_MEDIA_IDENTIFIER_ID DOUBLE N The ID of the row in the DMS_MEDIA_IDENTIFIER table that the ownership key relates to.
DMS_MEDIA_OWNERSHIP_ID DOUBLE N The primary key of the DMS_MEDIA_OWNERSHIP table.
OWNERSHIP_UUID VARCHAR(255) N Contains the ownership key.
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_OWNERSHIP


Child Column in DMS_MEDIA_OWNERSHIP(FK) Parent Table Name Parent Column Name
Parents: DMS_MEDIA_IDENTIFIER_ID DMS_MEDIA_IDENTIFIER DMS_MEDIA_IDENTIFIER_ID


DMS_MEDIA_SIGNATURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Digital Media Services Signature
Definition: Contains the digital signatures for media instances.
Table Type: ACTIVITY





Column Detail - DMS_MEDIA_SIGNATURE


Column Name Type Null? Definition
DMS_MEDIA_INSTANCE_ID DOUBLE N The media instance that is associated with this row.
DMS_MEDIA_SIGNATURE_ID DOUBLE N Unique identifier for the row.
SIGNATURE_BLOB_ID DOUBLE N Id of the LONG_BLOB row where the signature is stored.
SIGNER VARCHAR(100) N The username of the person that signed the media instance.
SIGN_DT_TM DATETIME N The date and time that the media instance was signed.
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_SIGNATURE


Child Column in DMS_MEDIA_SIGNATURE(FK) Parent Table Name Parent Column Name
Parents: DMS_MEDIA_INSTANCE_ID DMS_MEDIA_INSTANCE DMS_MEDIA_INSTANCE_ID
SIGNATURE_BLOB_ID LONG_BLOB LONG_BLOB_ID


DMS_MEDIA_XREF



Column Section Top of Page


Table-level Detail

Description: DMS media cross reference.
Definition: Contains information about the general classification of media items.
Table Type: ACTIVITY





Column Detail - DMS_MEDIA_XREF


Column Name Type Null? Definition
DMS_MEDIA_IDENTIFIER_ID DOUBLE N References the DMS_MEDIA_IDENTIFIER table for the media object identifier.
DMS_MEDIA_XREF_ID DOUBLE N Unique identifier for this row.
IDENTIFIER VARCHAR(64) Y OBSOLETE - NO LONGER USED - Media cross ref identifier.
PARENT_ENTITY_ID DOUBLE N The foreign key that this media instance is referencing.
PARENT_ENTITY_ID_STRING VARCHAR(128) Y We now have a non-Millennium implementation and need the ability to create cross references to UIDs represented as strings instead of only indexes to other Millennium tables. So instead of just parent_entity_name/id of orders(table)/1234 we may have something like orders(table)/1234@domainxyz where the parent_entiry_id_string is a string representation of the ID.
PARENT_ENTITY_NAME VARCHAR(30) N The name of the foreign table that the parent_entity_id refers to.
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.


DMS_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Digital Media Services Reference.
Definition: Contains reference names and display values for attributes of media instances.
Table Type: REFERENCE





Column Detail - DMS_REF


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.
DISPLAY VARCHAR(60) N The user visible text
DMS_REF_ID DOUBLE N Unique identifier for this row
REF_GROUP VARCHAR(32) N String to group sets of reference rows (uppercase without spaces)
REF_KEY VARCHAR(32) N Unique string to identify a row (uppercase without spaces) within a group
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_REF




Parent Column in DMS_REF (PK) Child Table Name Child Column Name
Children: DMS_REF_ID DMS_EVENT DMS_EVENT_REF_ID
DMS_EVENT DMS_REASON_REF_ID
DMS_EVENT_REASON_R DMS_REASON_REF_ID


DMS_REPOSITORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: DMS_REPOSITORY
Definition: Contains media object repository information
Table Type: REFERENCE





Column Detail - DMS_REPOSITORY


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.
DEFAULT_IND DOUBLE N This column is used to indicate the default repository
DMS_REPOSITORY_ID DOUBLE N Primary dms_repository table
ENCRYPTION_IND DOUBLE N This column is used to indicate if the object is encrypted
LOCATION VARCHAR(255) Y Repository location
OVERFLOW_ID DOUBLE N The DMS_REPOSITORY_ID of the repository used to store objects that exceed the size limit
PASSWORD VARCHAR(64) Y Repository access password
REPOSITORY_NAME VARCHAR(16) Y name of the repository used
SIZE_LIMIT DOUBLE N This column contains the size limit for objects stored on this repository
TYPE_FLAG DOUBLE N This column is used to indicate the type of repository 0 - archive, 1 - share,2 - Millennium
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.
USERNAME VARCHAR(64) Y Repository access username



Relationship Detail - DMS_REPOSITORY




Parent Column in DMS_REPOSITORY (PK) Child Table Name Child Column Name
Children: DMS_REPOSITORY_ID DMS_CONTENT_TYPE DMS_REPOSITORY_ID
DMS_MEDIA_INSTANCE DMS_REPOSITORY_ID


2024.4.01Data Models:Table Name Index

Table Detail Report

CPS_JQ_CAMM_GDPR_RESTSTUDY



Column Section Top of Page


Table-level Detail

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





Column Detail - CPS_JQ_CAMM_GDPR_RESTSTUDY


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_RESTSTUDY_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_UPDATESTUDY



Column Section Top of Page


Table-level Detail

Description: CammPlatformServices_JobQueue_MATCH_STUDY
Definition: Holds information about match study jobs while they are queued to be processed
Table Type: ACTIVITY





Column Detail - CPS_JQ_CAMM_UPDATESTUDY


Column Name Type Null? Definition
CPS_EQ_ID DOUBLE Y Unique number that identifies an event in the CAMM archive system
CPS_JQ_CAMM_UPDATESTUDY_ID DOUBLE N PRIMARY KEY ( using sequence CPS_JOB_SEQ )
CPS_RULE_ID DOUBLE Y Unique number that identifies a Rule in the CAMM archive system
ENTITY_IDENT VARCHAR(200) N Unique string that identifies the ENTITY being acted upon
EXPIRATION_TS DATETIME(6) Y TimeStamp of when the Job is no longer valid
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) N 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
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
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_VALIDATEHISTORY



Column Section Top of Page


Table-level Detail

Description: CPS_JQ_CAMM_VALIDATEHISTORY
Definition: CammPlatformServices_JobQueue_VALIDATE History
Table Type: ACTIVITY





Column Detail - CPS_JQ_CAMM_VALIDATEHISTORY


Column Name Type Null? Definition
CPS_EQ_ID DOUBLE Y Unique number that identifies an event in the CAMM archive system
CPS_JQ_CAMM_VALIDATEHISTORY_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) N 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) N 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
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_VALIDATESTUDY



Column Section Top of Page


Table-level Detail

Description: CPS_JQ_CAMM_VALIDATESTUDY
Definition: CammPlatformServices_JobQueue_VALIDATE STUDY
Table Type: ACTIVITY





Column Detail - CPS_JQ_CAMM_VALIDATESTUDY


Column Name Type Null? Definition
CPS_EQ_ID DOUBLE Y Unique number that identifies an event in the CAMM archive system
CPS_JQ_CAMM_VALIDATESTUDY_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) N 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) N 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
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.