Table Detail Report
PT_PROT_PRESCREEN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Potential Trial Candidate table. |
Definition: | This table holds all the patients that have been pre-screened against specific protocols and their status. |
Table Type: | ACTIVITY |
Column Detail - PT_PROT_PRESCREEN
Column Name | Type | Null? | Definition |
---|---|---|---|
ADDED_VIA_FLAG | DOUBLE | N | Defines if patient was added manually or through prescreening. 0- prescreened, 1- manually added |
COMMENT_TEXT | VARCHAR(4000) | Y | Comment Text. Will be null if not used. |
CT_PRESCREEN_JOB_ID | DOUBLE | N | This field uniquely identifies a job in ct_prescreen_job table. |
MODE_IND | DOUBLE | N | This field indicates whether the potential trial candidate was found in test mode or normal mode. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table for the person who is a potential trial candidate. It is an internal system assigned number. |
PROT_MASTER_ID | DOUBLE | N | Uniquely identifies a row in Prot_Master table. This field identifies the protocol on which the patient is a potential trial candidate. |
PT_PROT_PRESCREEN_ID | DOUBLE | N | Primary key of the pt_prot_prescreen table. It is a system assigned number ( protocol_def_seq) |
REASON_TEXT | VARCHAR(2000) | Y | Reason Comment |
REFERRED_DT_TM | DATETIME | Y | This field contains the date and time on which the potential trial candidate was referred. |
REFERRED_PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table for the person who referred the potential trial candidate. It is an internal system assigned number. |
SCREENED_DT_TM | DATETIME | Y | This field contains the date and time on which the pre-screening was run and the potential trial candidate was found. |
SCREENER_PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table for the person ran the pre-screening. It is an internal system assigned number. |
SCREENING_STATUS_CD | DOUBLE | N | This field contains the code identifying the pre-screening status of the potential trial candidate for the protocol. (17901) |
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 - PT_PROT_PRESCREEN
Child Column in PT_PROT_PRESCREEN(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 | |
REFERRED_PERSON_ID | PRSNL | PERSON_ID | |
SCREENER_PERSON_ID | PRSNL | PERSON_ID |
PT_PROT_PRESCREEN_TEST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PowerTrials Test Screening Matches |
Definition: | Store the test screening matches temporarily for each protocol and the corresponding job. |
Table Type: | ACTIVITY |
Column Detail - PT_PROT_PRESCREEN_TEST
Column Name | Type | Null? | Definition |
---|---|---|---|
CT_PRESCREEN_JOB_ID | DOUBLE | N | This field uniquely identifies a job in ct_prescreen_job table. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table for the person who is a potential trial candidate. it is an internal system assigned number. |
PROT_MASTER_ID | DOUBLE | N | This field uniquely identifies a row in the prot_master table. |
PT_PROT_PRESCREEN_TEST_ID | DOUBLE | N | Primary key |
SCREENED_DT_TM | DATETIME | N | This field contains the date and time on which the pre-screening was run and the potential trial candidate was found. |
SCREENER_PRSNL_ID | DOUBLE | N | This is the value of the unique primary identifier of the prsnl table for the person ran the pre-screening. it is an internal system assigned number. |
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 - PT_PROT_PRESCREEN_TEST
Child Column in PT_PROT_PRESCREEN_TEST(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 | |
SCREENER_PRSNL_ID | PRSNL | PERSON_ID |
PT_PROT_REG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table contains information about registration of a patient on a protocol |
Definition: | This table contains information about the registration of a patient on a protocol |
Table Type: | ACTIVITY |
Column Detail - PT_PROT_REG
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. |
BEST_RESPONSE_CD | DOUBLE | N | This field contains the code that identifies the best response that the patient obtained while enrolled on the protocol. |
DIAGNOSIS_TYPE_CD | DOUBLE | N | This field contains the code identifying the diagnosis type for which the patient was enrolled in the protocol. |
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. |
ENROLLING_ORGANIZATION_ID | DOUBLE | N | This field uniquely identifies a row in the organization table. This field identifies the institution that enrolled the patient in the protocol. |
EPISODE_ID | DOUBLE | N | This is the value of the unique primary identifier of the episode table. It is an internal system assigned number. This episode is related to the enrollment. |
FIRST_CR_DT_TM | DATETIME | Y | This field contains the date and time on which the first complete remission occurred. |
FIRST_DIS_REL_EVENT_DEATH_CD | DOUBLE | N | This field contains the code indicating the first disease related event such as progression, relapse or second malignancy or death if death was the first disease related event to occur. |
FIRST_PD_DT_TM | DATETIME | Y | This field contains the date and time on which the first disease progression/relapse occurred. |
FIRST_PD_FAILURE_DT_TM | DATETIME | Y | This field contains the date and time of the first disease progression or relapse that occurred while the patient was on study. This field will be automatically updated when the relapse/progression is recorded in the patient protocol data. |
NOMENCLATURE_ID | DOUBLE | N | This field uniquely identifies a row in the nomenclature table. This field identifies the diagnosis for which the patient was enrolled in the protocol. |
OFF_STUDY_DT_TM | DATETIME | Y | This field contains the date and time on which the patient was taken off study. If a patient dies on study, the date off study will be the patient's date of death. If a patient fails on study and is enrolled in a subsequent study, the date off study will be the date of enrollment on the subsequent study. |
OFF_TX_REMOVAL_ORGANIZATION_ID | DOUBLE | N | Organization removing patient off treatment. |
OFF_TX_REMOVAL_PERSON_ID | DOUBLE | N | Person removing patient off treatment.study. |
ON_STUDY_DT_TM | DATETIME | N | This field contains the date and time on which the patient was enrolled on the study. Often, this is the date the patient's consent form was signed. |
ON_TX_ASSIGN_PRSNL_ID | DOUBLE | N | Assigning person when patent is on treatment |
ON_TX_COMMENT | VARCHAR(255) | N | Comments to be added when patent is on treatment |
ON_TX_ORGANIZATION_ID | DOUBLE | N | Assigning institute when patent is on treatment |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PROT_ACCESSION_NBR | VARCHAR(255) | N | This field contains the patient's accession number (order of enrollment) for this protocol. |
PROT_ARM_ID | DOUBLE | N | This field uniquely identifies a row in the prot_arm table. This field identifies the protocol arm in which the patient was enrolled. |
PROT_MASTER_ID | DOUBLE | N | Uniquelu identifies a row in prot_master table. This field identifies the protocol on which the patient is enrolled. |
PT_PROT_REG_ID | DOUBLE | N | Primary key of the pt_prot_reg table. It is a system assigned number. |
REASON_OFF_TX_CD | DOUBLE | N | Reason Off Treatment |
REASON_OFF_TX_DESC | VARCHAR(255) | Y | Textual reason patient is taken off treatment. |
REG_ID | DOUBLE | N | A unique key for the registation of a patient on a protocol. No two active rows can have the same reg_id |
REMOVAL_ORGANIZATION_ID | DOUBLE | N | This field uniquely identifies a row in the organization table. This field identifies the institution/organization with which the person who removed the patient from the protocol was associated. For this purpose, an institution can be another hospital, research institute, drug company, government agency, etc. |
REMOVAL_PERSON_ID | DOUBLE | N | This field uniquely identifies a row in the person table. This field identifies the individual who removed the patient from the protocol. |
REMOVAL_REASON_CD | DOUBLE | N | Codified reason patient is taken off study. |
REMOVAL_REASON_DESC | VARCHAR(255) | Y | Textual reason patient is taken off study. |
STATUS_ENUM | DOUBLE | N | Number to indicate the current status of the enrolled patient(1: On Study,2:OnTreatment, 3:Off Treatment,4-OnFollowup,5-OffStudy) |
TX_COMPLETION_DT_TM | DATETIME | Y | This field contains the date and time on which treatment was completed. |
TX_START_DT_TM | DATETIME | Y | This field contains the date and time on which treatment commenced. |
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 - PT_PROT_REG
Child Column in PT_PROT_REG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EPISODE_ID | EPISODE | EPISODE_ID |
NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
ENROLLING_ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
OFF_TX_REMOVAL_ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
ON_TX_ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
REMOVAL_ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID | |
PROT_ARM_ID | PROT_ARM | PROT_ARM_ID | |
PROT_MASTER_ID | PROT_MASTER | PROT_MASTER_ID | |
OFF_TX_REMOVAL_PERSON_ID | PRSNL | PERSON_ID | |
ON_TX_ASSIGN_PRSNL_ID | PRSNL | PERSON_ID | |
REMOVAL_PERSON_ID | PRSNL | PERSON_ID |
Parent Column in PT_PROT_REG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PT_PROT_REG_ID | ASSIGN_REG_RELTN | REG_ID |
PT_REG_CONSENT_RELTN | REG_ID | ||
PT_REG_ELIG_RELTN | REG_ID |
PT_REG_CONSENT_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PT REG CONSENT RELTN |
Definition: | Stores the relationship between Registration and Consent |
Table Type: | ACTIVITY |
Column Detail - PT_REG_CONSENT_RELTN
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 | Uniquely Identifies the consent |
PT_REG_CONSENT_RELTN_ID | DOUBLE | N | Primary Key |
REG_ID | DOUBLE | N | Uniquely identifies the registration |
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 - PT_REG_CONSENT_RELTN
Child Column in PT_REG_CONSENT_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONSENT_ID | PT_CONSENT | PT_CONSENT_ID |
REG_ID | PT_PROT_REG | PT_PROT_REG_ID |
PT_REG_ELIG_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PT REG ELIG RELTN |
Definition: | Table stores the relationship between Protocol registration and the eligibility |
Table Type: | ACTIVITY |
Column Detail - PT_REG_ELIG_RELTN
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. |
PT_ELIG_TRACKING_ID | DOUBLE | N | This field uniquely identifies a row in the pt_elig_tracking table |
PT_REG_ELIG_RELTN_ID | DOUBLE | N | Primary Key |
REG_ID | DOUBLE | N | Uniquely identifies the registration |
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 - PT_REG_ELIG_RELTN
Child Column in PT_REG_ELIG_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PT_ELIG_TRACKING_ID | PT_ELIG_TRACKING | PT_ELIG_TRACKING_ID |
REG_ID | PT_PROT_REG | PT_PROT_REG_ID |