Table Detail Report

CT_DOCUMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CT DOCUMENT
Definition: This table stores information about the documents associated with an amendment.
Table Type: REFERENCE





Column Detail - CT_DOCUMENT


Column Name Type Null? Definition
BEGIN_EFFECTIVE_DT_TM DATETIME N Begin Effective Date and Time
CT_DOCUMENT_ID DOUBLE N This is the value of the unique primary identifier of the ct_document table. It is an internal system assigned number.
DESCRIPTION VARCHAR(255) Y The description of the document
DOCUMENT_TYPE_CD DOUBLE N The type of document. It can be a consent document or a protocol document or a concept document.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
PREV_CT_DOCUMENT_ID DOUBLE N The original value of ct_document_version_id used for grouping the related versions. Required for type2 versioning.
PROT_AMENDMENT_ID DOUBLE N The amendment to which this document belongs
TITLE VARCHAR(40) N The title or name of the document
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 - CT_DOCUMENT


Child Column in CT_DOCUMENT(FK) Parent Table Name Parent Column Name
Parents: PREV_CT_DOCUMENT_ID CT_DOCUMENT CT_DOCUMENT_ID
PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID




Parent Column in CT_DOCUMENT (PK) Child Table Name Child Column Name
Children: CT_DOCUMENT_ID CT_DOCUMENT PREV_CT_DOCUMENT_ID
CT_DOCUMENT_VERSION CT_DOCUMENT_ID


CT_DOCUMENT_BLOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Ct_Document_Blob
Definition: This table is used to store the physical document blob for documents saved for a clinical trial.
Table Type: REFERENCE





Column Detail - CT_DOCUMENT_BLOB


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.
BLOB_LENGTH DOUBLE N Original length of the blob
CT_DOCUMENT_BLOB_ID DOUBLE N Unique identifier for each row (PK). Referenced by the ct_document_version table.
CT_DOCUMENT_VERSION_ID DOUBLE N FOREIGN KEY FROM CT_DOCUMENT_VERSION
LONG_BLOB LONGBLOB Y Long raw defined column stores large binary data from the ct_document_version table.
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 - CT_DOCUMENT_BLOB


Child Column in CT_DOCUMENT_BLOB(FK) Parent Table Name Parent Column Name
Parents: CT_DOCUMENT_VERSION_ID CT_DOCUMENT_VERSION CT_DOCUMENT_VERSION_ID


CT_DOCUMENT_VERSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: CT DOCUMENT VERSION
Definition: Contains the version information of documents
Table Type: REFERENCE





Column Detail - CT_DOCUMENT_VERSION


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.
BEGIN_EFFECTIVE_DT_TM DATETIME N Begin Effective Date and Time
CT_DOCUMENT_ID DOUBLE N The document to which this version belongs
CT_DOCUMENT_VERSION_ID DOUBLE N This is the value of the unique primary identifier of the ct_document_version table. It is an internal system assigned number.
DISPLAY_IND DOUBLE N Indicates whether a document can be displayed outside the document manager or consenting process.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FILE_NAME VARCHAR(255) N File name of the document
LONG_BLOB_ID DOUBLE N This is the value of the unique primary identifier of the long_blob table. It is an internal system assigned number.
PREV_CT_DOCUMENT_VERSION_ID DOUBLE N The original value of ct_document_version_id used for grouping the related versions. Required for type2 versioning.
PRINT_WITH_CONSENT_IND DOUBLE N Indicates whether the document will be prompted to be printed when the consent is release for a patient.
REVISION_ID DOUBLE N The revision_id , in case this document is associated with a revision
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.
VERSION_DESCRIPTION VARCHAR(255) N Textual description of the version
VERSION_NBR DOUBLE N The number of the version



Relationship Detail - CT_DOCUMENT_VERSION


Child Column in CT_DOCUMENT_VERSION(FK) Parent Table Name Parent Column Name
Parents: CT_DOCUMENT_ID CT_DOCUMENT CT_DOCUMENT_ID
PREV_CT_DOCUMENT_VERSION_ID CT_DOCUMENT_VERSION CT_DOCUMENT_VERSION_ID
LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID
REVISION_ID REVISION REVISION_ID




Parent Column in CT_DOCUMENT_VERSION (PK) Child Table Name Child Column Name
Children: CT_DOCUMENT_VERSION_ID CT_DOCUMENT_BLOB CT_DOCUMENT_VERSION_ID
CT_DOCUMENT_VERSION PREV_CT_DOCUMENT_VERSION_ID
PT_CONSENT CT_DOCUMENT_VERSION_ID


CT_DOMAIN_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discovere Domain Information
Definition: This table stores the Discovere domain information
Table Type: REFERENCE





Column Detail - CT_DOMAIN_INFO


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CT_DOMAIN_INFO_ID DOUBLE N Primary key
DOMAIN_NAME VARCHAR(255) N This field contains the name of the domain.
DOMAIN_NAME_IDENT VARCHAR(255) N Key for domain. Contains the Domain Name key data. uniquely identifies an active row of data. This name will be entered via front end tool and will be unique for active/effective rows.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PREV_CT_DOMAIN_INFO_ID DOUBLE N The original value of the ct_domain_info_id used for grouping the related versons. Required for type 2 versioning methodology.
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.
URL1_TXT VARCHAR(255) N This field contains the first domain URL string.
URL2_TXT VARCHAR(255) N This field contains the second domain URL string.



Relationship Detail - CT_DOMAIN_INFO


Child Column in CT_DOMAIN_INFO(FK) Parent Table Name Parent Column Name
Parents: PREV_CT_DOMAIN_INFO_ID CT_DOMAIN_INFO CT_DOMAIN_INFO_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in CT_DOMAIN_INFO (PK) Child Table Name Child Column Name
Children: CT_DOMAIN_INFO_ID CT_DOMAIN_INFO PREV_CT_DOMAIN_INFO_ID
CT_USER_DOMAIN_INFO CT_DOMAIN_INFO_ID
PROT_AMENDMENT CT_DOMAIN_INFO_ID


CT_EXCLUDED_CLIENTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Organizations to be excluded from Verification Process
Definition: Stores the organization ID's tat will be excluded from the verification process.
Table Type: REFERENCE





Column Detail - CT_EXCLUDED_CLIENTS


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ORGANIZATION_ID DOUBLE N The unique identifier of the organization (from ORGANIZATION table) to which the member belongs.
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 - CT_EXCLUDED_CLIENTS


Child Column in CT_EXCLUDED_CLIENTS(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID