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 |