Table Detail Report

CT_PT_PROT_BATCH_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Trials Patient Protocol Batch List
Definition: This table contains a list of patients to be batch enrolled on a protocol.
Table Type: ACTIVITY





Column Detail - CT_PT_PROT_BATCH_LIST


Column Name Type Null? Definition
CT_PT_PROT_BATCH_LIST_ID DOUBLE N PRIMARY KEY
PERSON_ID DOUBLE N The person for which the protocal batch list was created
PROT_MASTER_ID DOUBLE N THE PROTOCOL MASTER
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_PT_PROT_BATCH_LIST


Child Column in CT_PT_PROT_BATCH_LIST(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PROT_MASTER_ID PROT_MASTER PROT_MASTER_ID


CT_PT_SETTINGS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient/Trial Pre-screening Settings table.
Definition: This table holds whether a patient is interested in being pre-screened for clinical trial protocols.
Table Type: ACTIVITY





Column Detail - CT_PT_SETTINGS


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.
CT_PT_SETTINGS_ID DOUBLE N Primary key of the table. It is a system assigned number ( protocol_def_seq)
INTEREST_OPTION_CD DOUBLE N Interest option code value associated with the patient interest
NOT_INTERESTED_DT_TM DATETIME Y Date and time the Not Interested Indicator was set.
NOT_INTERESTED_IND DOUBLE N This field contains the code identifying the pre-screening status of the potential trial candidate for the protocol.
NOT_INTERESTED_PRSNL_ID DOUBLE N Prsnl updating not interested data
PERSON_ID DOUBLE N The person who does or does not have interest in being pre-screened for any clinical trial protocols. This is the value of the unique primary identifier of the person table for the person who has their interest for being pre-screened for Clinical Trials protocols indicated in this table. It is an internal system assigned number.
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_PT_SETTINGS


Child Column in CT_PT_SETTINGS(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID


CT_REASON_DELETED



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Trials - Reason Deleted
Definition: Stores the information on why enrollment information has been logically deleted.
Table Type: ACTIVITY





Column Detail - CT_REASON_DELETED


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.
CONSENT_ID DOUBLE N This is the value of the unique consent that has been logically deleted.
CT_REASON_DEL_ID DOUBLE N Primary Key. From Sequence PROTOCOL_DEF_SEQ
DELETION_DT_TM DATETIME N The date and time the deletion occurred.
DELETION_PRSNL_ID DOUBLE N The person who performed the deletion.
DELETION_REASON VARCHAR(2000) N The reason why the deletion was done. Free Form text.
PERSON_ID DOUBLE N Unique identifier from the PERSON table to indicate which patient has been deleted from the view.
PROT_MASTER_ID DOUBLE N Uniquely identifies the protocol on which the deletion of the patient is performed.
PT_ELIG_TRACKING_ID DOUBLE N Pt_Elig_Tracking_Id. Foreign Key.
REG_ID DOUBLE N From table PT_PROT_REG. Not a Foreign Key
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_REASON_DELETED


Child Column in CT_REASON_DELETED(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PROT_MASTER_ID PROT_MASTER PROT_MASTER_ID
DELETION_PRSNL_ID PRSNL PERSON_ID
CONSENT_ID PT_CONSENT PT_CONSENT_ID
PT_ELIG_TRACKING_ID PT_ELIG_TRACKING PT_ELIG_TRACKING_ID


CT_RN_PROT_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Research Network Protocol Configuration
Definition: Store the research network run data.
Table Type: REFERENCE





Column Detail - CT_RN_PROT_CONFIG


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.
CONFIG_INFO VARCHAR(4000) Y The configuration data string defining parameters used by the research network.
CONFIG_VERSION_NBR DOUBLE N The version of the configuration that was last saved.
CT_RN_PROT_CONFIG_ID DOUBLE N Primary key
DATA_EXTRACT_CAP_FLAG DOUBLE N Indicates if the research network protocol can have data extraction enabled. Available options are: 0 - Not capable of doing data extraction 1 - Capable of doing data extraction but it is disabled. 2 - Capable of doing data extraction and it is enabled.
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.
LONG_TEXT_ID DOUBLE N this field uniquely identifies a row in the long_text_reference table.
PREV_CT_RN_PROT_CONFIG_ID DOUBLE N the original value of ct_rn_prot_config_id used for grouping the related versions. required for type 2 versioning methodology.
PROT_MASTER_ID DOUBLE N this field uniquely identifies a row in the prot_master table.
PROT_PASSWORD VARCHAR(100) N Encrypted password used to authorize changing research network protocols mode.
RN_PROTOCOL_CD DOUBLE N This field contains the code for the protocol that is used to determine active status of the research network protocol
SOURCE_FILENAME VARCHAR(255) Y This field identifies the filename that was used during package installation for the research protocol.
STOP_DT_TM DATETIME Y The date/time after which the protocol will no longer be run through the research network
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_RN_PROT_CONFIG


Child Column in CT_RN_PROT_CONFIG(FK) Parent Table Name Parent Column Name
Parents: PREV_CT_RN_PROT_CONFIG_ID CT_RN_PROT_CONFIG CT_RN_PROT_CONFIG_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
PROT_MASTER_ID PROT_MASTER PROT_MASTER_ID




Parent Column in CT_RN_PROT_CONFIG (PK) Child Table Name Child Column Name
Children: CT_RN_PROT_CONFIG_ID CT_RN_PROT_CONFIG PREV_CT_RN_PROT_CONFIG_ID


CT_RN_PROT_RUN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Research Network Protocol Run
Definition: This table stores the research network run data for protocols.
Table Type: ACTIVITY





Column Detail - CT_RN_PROT_RUN


Column Name Type Null? Definition
COMPLETED_FLAG DOUBLE N This field contains the current status for the research network run. 0=Incomplete 1=Completed Successfully 2=Forced Completion
CT_RN_PROT_RUN_ID DOUBLE N Primary key
NEXT_RUN_DT_TM DATETIME Y the eligible date/time the protocol should be run through the research network.
PROT_MASTER_ID DOUBLE N this field uniquely identifies a row in the prot_master table.
PT_SENT_NBR DOUBLE N This field contains the number of patient sent from the research network.
RUN_GROUP_ID DOUBLE N this field uniquely identifies a research network run.This value is pulled from the sequence and used as a grouper for several rows. The value has no relation to a PK ID value from any particular row.
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_RN_PROT_RUN


Child Column in CT_RN_PROT_RUN(FK) Parent Table Name Parent Column Name
Parents: PROT_MASTER_ID PROT_MASTER PROT_MASTER_ID




Parent Column in CT_RN_PROT_RUN (PK) Child Table Name Child Column Name
Children: CT_RN_PROT_RUN_ID CT_RN_RUN_ACTIVITY CT_RN_PROT_RUN_ID