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 |