Table Detail Report

CT_PROT_MILESTONES



Column Section Relationship Section Top of Page


Table-level Detail

Description: CT PROT MILESTONES
Definition: This table contains the protocol level milestones
Table Type: REFERENCE





Column Detail - CT_PROT_MILESTONES


Column Name Type Null? Definition
ACTIVITY_CD DOUBLE N The activity performed. Example: Activated By, Sent To etc.
COMMITTEE_ID DOUBLE N The committee responsible for performing the activity
CT_PROT_MILESTONES_ID DOUBLE N This is the value of the unique primary identifier of the ct_prot_milestones table. It is an internal system assigned number.
ENTITY_TYPE_FLAG DOUBLE N Identifies whether an organization or a committee or a role is responsible for performing the action.
ORGANIZATION_ID DOUBLE N Foreign Key into the Organization table. Identifies the organization responsible for the action.
PERFORMED_DT_TM DATETIME N The date on which the action was performed
PROT_MASTER_ID DOUBLE N The protocol for which this belongs
PROT_ROLE_CD DOUBLE N The role responsoble for the action. Example: Prinicipal Investigator, Co-Investigator etc.
SEQUENCE_NBR DOUBLE N The number of the milestone
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_PROT_MILESTONES


Child Column in CT_PROT_MILESTONES(FK) Parent Table Name Parent Column Name
Parents: COMMITTEE_ID COMMITTEE COMMITTEE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PROT_MASTER_ID PROT_MASTER PROT_MASTER_ID


CT_PROT_PRESCREEN_JOB_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: PowerTrials Screening Job Data for Protocols
Definition: Stores the prescreening job results for each protocol in the job.
Table Type: ACTIVITY





Column Detail - CT_PROT_PRESCREEN_JOB_INFO


Column Name Type Null? Definition
CHUNK_INDEX_NBR DOUBLE N Stores the index value of chunk which is being run for pre-screening
CHUNK_NBR DOUBLE N Stores the number of chunks in which the patient data will be divided in and used for pre-screening
COMPLETED_FLAG DOUBLE N This field contains the current status for the prescreening job. 0=Incomplete 1=Completed Successfully 2=Forced Completion
CT_PRESCREEN_JOB_ID DOUBLE N This field uniquely identifies a job in ct_prescreen_job table.
CT_PROT_PRESCREEN_JOB_INFO_ID DOUBLE N Primary Key
CURR_EVAL_PAT_CNT DOUBLE N The number of patients that have been evalauted by the HE server
PERSON_ID DOUBLE N this field uniquely identifies a row in the person table for which the prescreening was done
PROT_MASTER_ID DOUBLE N This field uniquely identifies a row in the prot_master table.
PT_QUALIFIED_NBR DOUBLE N This field contains the number of patient qualified for this protocol for the specific job.
TOTAL_EVAL_PAT_CNT DOUBLE N The total number of patients that are to be evaluated for quick prescreening
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_PROT_PRESCREEN_JOB_INFO


Child Column in CT_PROT_PRESCREEN_JOB_INFO(FK) Parent Table Name Parent Column Name
Parents: CT_PRESCREEN_JOB_ID CT_PRESCREEN_JOB CT_PRESCREEN_JOB_ID
PERSON_ID PERSON PERSON_ID
PROT_MASTER_ID PROT_MASTER PROT_MASTER_ID


CT_PROT_REASON_DELETED



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Trials - Protocol Reason Deleted
Definition: Stores the information on why protocol information has been logically deleted from the PROT_MASTER table.
Table Type: REFERENCE





Column Detail - CT_PROT_REASON_DELETED


Column Name Type Null? Definition
CT_PROT_REASON_DELETED_ID DOUBLE N PRIMARY KEY
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_TXT VARCHAR(2000) Y The reason why the deletion was done. Free Form text
PARENT_PROT_MASTER_ID DOUBLE N Parent prot_master id From table prot_master. This is the foreign key for prot_master_id present in prot_master 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_PROT_REASON_DELETED


Child Column in CT_PROT_REASON_DELETED(FK) Parent Table Name Parent Column Name
Parents: PARENT_PROT_MASTER_ID PROT_MASTER PROT_MASTER_ID
DELETION_PRSNL_ID PRSNL PERSON_ID


CT_PROT_TYPE_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Protocol Type Configuration
Definition: This table stores the configuration data for the protocol types.
Table Type: REFERENCE





Column Detail - CT_PROT_TYPE_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_VALUE_CD DOUBLE N This field contains the code identifying the configuration value.
CT_PROT_TYPE_CONFIG_ID DOUBLE N Primary key
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.
ITEM_CD DOUBLE N This field contains the code identifying the item.
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_PROT_TYPE_CONFIG_ID DOUBLE N The original value of the ct_prot_type_config_id used for grouping the related versons. Required for type 2 versioning methodology.
PROTOCOL_TYPE_CD DOUBLE N This field contains a code identifying the protocol type.
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_PROT_TYPE_CONFIG


Child Column in CT_PROT_TYPE_CONFIG(FK) Parent Table Name Parent Column Name
Parents: PREV_CT_PROT_TYPE_CONFIG_ID CT_PROT_TYPE_CONFIG CT_PROT_TYPE_CONFIG_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in CT_PROT_TYPE_CONFIG (PK) Child Table Name Child Column Name
Children: CT_PROT_TYPE_CONFIG_ID CT_PROT_TYPE_CONFIG PREV_CT_PROT_TYPE_CONFIG_ID


CT_PT_AMD_ASSIGNMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CT PT AMD ASSIGNMENT
Definition: This table documents the assignment of a patient to an amendment.
Table Type: ACTIVITY





Column Detail - CT_PT_AMD_ASSIGNMENT


Column Name Type Null? Definition
ASSIGN_END_DT_TM DATETIME N The date on which the patient's assignment to the amendment ended
ASSIGN_START_DT_TM DATETIME N The date on which the patient was put on this amendment
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_PT_AMD_ASSIGNMENT_ID DOUBLE N This is the value of the unique primary identifier of the ct_pt_amd_assignment table. It is an internal system assigned number.
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.
PROT_AMENDMENT_ID DOUBLE N The amendment on which the patient was assigned
REG_ID DOUBLE N Identifies the protocol registration that this assignment is related to. A reg_id is logical identifier in the pt_prot_reg table. It identifier an active enrollment of a patient on a protocol.
TRANSFER_CHECKED_AMENDMENT_ID DOUBLE N The amendment against which an attempt is done to transfer the patient
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_AMD_ASSIGNMENT


Child Column in CT_PT_AMD_ASSIGNMENT(FK) Parent Table Name Parent Column Name
Parents: PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID
TRANSFER_CHECKED_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID