Table Detail Report

PROT_DEFAULT_ROLES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Protocol Default Roles
Definition: This table contains all the default roles that are defined.
Table Type: REFERENCE





Column Detail - PROT_DEFAULT_ROLES


Column Name Type Null? Definition
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.
ORGANIZATION_ID DOUBLE N References the Organization table for Organization. The unique identifier of the organization (from the organization table) to which the member belongs.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
POSITION_CD DOUBLE N The position is used to determine the applications and tasks the personnel is authorized to use
PROT_DEFAULT_ROLE_ID DOUBLE N Primary Key. Generated from sequence protocol_def_seq.
PROT_ROLE_CD DOUBLE N The role which is played by the person/entity on the amendment.
ROLE_TYPE_CD DOUBLE N The Type of role played. eg., personal/Institutional
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 - PROT_DEFAULT_ROLES


Child Column in PROT_DEFAULT_ROLES(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID


PROT_ELIG_QUEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROT ELIG QUEST
Definition: This table contains the eligibility questions associated with an amendment.
Table Type: REFERENCE





Column Detail - PROT_ELIG_QUEST


Column Name Type Null? Definition
ANSWER_FORMAT_ID DOUBLE N The primary key of Answer_format table. Identifies the valid answer for this question.
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.
DATE_REQUIRED_FLAG DOUBLE N Indicates if a date is required.
DESIRED_VALUE VARCHAR(1) N This field contains the answer to the question that implies eligibility (the desired value).
ELIG_QUEST_NBR DOUBLE N This field contains the number of the eligibility question (1-first, 2-second, 3-third etc.).
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 References the Long Text for the Eligible Question. Foreign Key from the Long Text Reference table.
PREV_PROT_ELIG_QUEST_ID DOUBLE N The key for the original eligibility question of the versioned group. Used to support type-2 versioning.
PROT_AMENDMENT_ID DOUBLE N This field uniquely identifies a row in the prot_amendment table. This field identifies the protocol amendment for which the patient's eligibility is being evaluated. ***OBSOLETE***
PROT_ELIG_QUEST_ID DOUBLE N This is the value of the unique primary identifier of the prot_elig_quest table. It is an internal system assigned number.
PROT_QUESTIONNAIRE_ID DOUBLE N Uniquely identifies a questionnaire in the table
QUESTION VARCHAR(2000) N *OBSOLETE - Patient enrollment Eligibility Question. Replaced by value associate with LONG_TEXT_ID from Long Text Reference
QUEST_TYPE_IND DOUBLE N Indicates whether the question is an eligibility question or an informational question. If set to 1, it indicates that the question is an eligiblity question. If set to 0 it indicates that the question is an informational question. Informational quesitons do not impact eligiblity.
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.
VALUE_REQUIRED_FLAG DOUBLE N Indicates whether value is required or not.



Relationship Detail - PROT_ELIG_QUEST


Child Column in PROT_ELIG_QUEST(FK) Parent Table Name Parent Column Name
Parents: ANSWER_FORMAT_ID ANSWER_FORMAT ANSWER_FORMAT_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID
PREV_PROT_ELIG_QUEST_ID PROT_ELIG_QUEST PROT_ELIG_QUEST_ID
PROT_QUESTIONNAIRE_ID PROT_QUESTIONNAIRE PROT_QUESTIONNAIRE_ID




Parent Column in PROT_ELIG_QUEST (PK) Child Table Name Child Column Name
Children: PROT_ELIG_QUEST_ID PROT_ELIG_QUEST PREV_PROT_ELIG_QUEST_ID
PT_ELIG_RESULT PROT_ELIG_QUEST_ID


PROT_GRANT_SPONSOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores information about institutions that sponsor the protocol
Definition: Stores information about institutions that sponsor the protocol in whole or in part.. For this purpose, an institution can be a research institute, drug company, government agency, etc.
Table Type: REFERENCE





Column Detail - PROT_GRANT_SPONSOR


Column Name Type Null? Definition
FUNDED_IND DOUBLE N Indicator to specify if the organization supports the protocol with funds
GRANT_NBR VARCHAR(255) Y The grant number for the organization's support
GRANT_PROJECT_TITLE VARCHAR(255) Y This field contains a description of the grant/grant project that is supporting the protocol.
ORGANIZATION_ID DOUBLE N This field uniquely idenitifies a row in the organization table. This field identifies an institution that is sponsoring the protocol in whole or in part.. For this purpose, an institution can be a research institute, drug company, government agency, etc.
PRIMARY_SECONDARY_CD DOUBLE N This field contains a code indicating whether this grant is the primary source of support for the protocol or a secondary source of support for the protocol.
PROT_AMENDMENT_ID DOUBLE N Uniquely identifies the amendment
PROT_GRANT_SPONSOR_ID DOUBLE N Primary Key
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 - PROT_GRANT_SPONSOR


Child Column in PROT_GRANT_SPONSOR(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID




Parent Column in PROT_GRANT_SPONSOR (PK) Child Table Name Child Column Name
Children: PROT_GRANT_SPONSOR_ID SUPPORT_TYPE PROT_GRANT_SPONSOR_ID


PROT_MASTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Protocol Master
Definition: Table stores information about protocols
Table Type: REFERENCE





Column Detail - PROT_MASTER


Column Name Type Null? Definition
ACCESSION_NBR_LAST DOUBLE N this value holds the last acession number(order of enrollment) that was used to enroll patients on this protocol
ACCESSION_NBR_PREFIX VARCHAR(255) Y the prefix added to all acession numbers for enrollments on this protocol
ACCESSION_NBR_SIG_DIG DOUBLE N Number of significant digits in the accession number for enrollments on this protocol
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.
COLLAB_SITE_ORG_ID DOUBLE N Collaborating Site Organization for the protocol.
DISPLAY_IND DOUBLE N This field is an indicator that tells whether the protocol enrollment information for this protocol will be displayed in the electronic medical record.
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.
INITIATING_SERVICE_CD DOUBLE N This field contains a code for the service that is sponsoring (initiating) the protocol/study. Examples of a service would include, but not be limited to, Leukemia, Solid Tumor, After Completion of Therapy (ACT), Psychology, Department of Infectious Diseases, etc.
INITIATING_SERVICE_DESC VARCHAR(255) Y Free text description of the Initiating service
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.
NETWORK_FLAG DOUBLE N A flag to determine if a protocol came from Research Network (0 = did not come from Research Network, 1 = came from Research Network but now a PowerTrials protocol, 2 = came from Research Network and still in Research Network)
PARENT_PROT_MASTER_ID DOUBLE N The parent_prot_master_id is the PK of the protocol that is the parent.
PARTICIPATION_TYPE_CD DOUBLE N Indicates the type of participation of the organization on the protocol .. examples include Institution only, Cooperative group study, Clinical Practice study etc.
PEER_REVIEW_INDICATOR_CD DOUBLE N This field contains a code that indicates if the protocol undergoes peer review.
PRESCREEN_TYPE_FLAG DOUBLE N Type of prescreening associated with the protocol. 0 = Discern 1 = HE RuleBuilder
PREV_PROT_MASTER_ID DOUBLE N The ORIGINAL value of prot_master_id used for grouping the related versions. Required for Type 2 Versioning methodology.
PRIMARY_MNEMONIC VARCHAR(255) Y Mnemonic assigned to the protocol
PRIMARY_MNEMONIC_KEY VARCHAR(255) Y Mnemonic of the protocol stripped of special characters
PROGRAM_CD DOUBLE N This field contains a code identifying the program that is sponsoring the protocol/study. Examples of programs would include, but not be limited to, be Hematologic Malignancy, Solid Malignancy, Transplantation and Gene Therapy, Neurobiology, Infectious Disease and Brain Tumors, etc.
PROT_MASTER_ID DOUBLE N Primary Key
PROT_PHASE_CD DOUBLE N This field contains a code for the phase of the protocol. Examples of phases would include, but not be limited to, phase 1, phase 1A, phase 1B, phase 2, phase 3, etc.
PROT_PURPOSE_CD DOUBLE N This field contains a code identifying the purpose for the protocol/study. Examples of purposes would include, but not be limited to, cancer control, epidemiology, etc.
PROT_STATUS_CD DOUBLE N This field contains a code identifying the status of the protocol/study: approved, open, suspended (temporarily closed to accrual), closed to accrual, closed and terminated.
PROT_TYPE_CD DOUBLE N This field contains a code identifying the type of protocol; therapeutic, non-therapeutic, BCM guidelines etc.
RESEARCH_SPONSOR_ORG_ID DOUBLE N This field uniquely identifies a row in the organization table. This field contains the organization_id from the organization for the primary research sponsor. For this purpose, a research sponsor can be another hospital, research institute, drug company, government agency, etc.
SCREENER_IND DOUBLE N An indicator to determine if a protocol originated from screener (0 = created from powertrials, 1 = created from screener )
SUB_INITIATING_SERVICE_CD DOUBLE N This field contains a code for the service that is sub sponsoring (sub initiating) the protocol/study.
SUB_INITIATING_SERVICE_DESC VARCHAR(255) Y Free text description of the sub initiating service.
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 - PROT_MASTER


Child Column in PROT_MASTER(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
COLLAB_SITE_ORG_ID ORGANIZATION ORGANIZATION_ID
RESEARCH_SPONSOR_ORG_ID ORGANIZATION ORGANIZATION_ID
PARENT_PROT_MASTER_ID PROT_MASTER PROT_MASTER_ID
PREV_PROT_MASTER_ID PROT_MASTER PROT_MASTER_ID




Parent Column in PROT_MASTER (PK) Child Table Name Child Column Name
Children: PROT_MASTER_ID CONTRIBUTING_DEPT PROT_MASTER_ID
CT_PROT_CONFIG_VALUE PROT_MASTER_ID
CT_PROT_MILESTONES PROT_MASTER_ID
CT_PROT_PRESCREEN_JOB_INFO PROT_MASTER_ID
CT_PROT_REASON_DELETED PARENT_PROT_MASTER_ID
CT_PT_PROT_BATCH_LIST PROT_MASTER_ID
CT_REASON_DELETED PROT_MASTER_ID
CT_RN_PROT_CONFIG PROT_MASTER_ID
CT_RN_PROT_RUN PROT_MASTER_ID
CT_USER_PREFERENCE PROT_MASTER_ID
PEER_REVIEWER PROT_MASTER_ID
PROT_ALIAS PROT_MASTER_ID
PROT_AMENDMENT PROT_MASTER_ID
PROT_CRPC_BILLING PROT_MASTER_ID
PROT_CRPC_BILL_MODIFIER PROT_MASTER_ID
PROT_MASTER PARENT_PROT_MASTER_ID
PROT_MASTER PREV_PROT_MASTER_ID
PROT_REGULATORY_REQ PROT_MASTER_ID
PT_PROT_PRESCREEN PROT_MASTER_ID
PT_PROT_PRESCREEN_TEST PROT_MASTER_ID
PT_PROT_REG PROT_MASTER_ID
PW_PT_RELTN PROT_MASTER_ID


PROT_MODALITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Table stores information about treatment modalities that is used in the protocol
Definition: Table stores information about treatment modalities that is used in the protocol/study. Examples of modalities would include, but not be limited to, chemotherapy, radiation therapy, surgery, immunotherapy, etc.
Table Type: REFERENCE





Column Detail - PROT_MODALITY


Column Name Type Null? Definition
MODALITY_CD DOUBLE N This field contains a code that identifies a treatment modality that is used in the protocol/study
MODALITY_DESC_OTR VARCHAR(255) Y Free text description of the modality
PROT_AMENDMENT_ID DOUBLE N Uniquely identifies the amendment
PROT_MODALITY_ID DOUBLE N Primary Key
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 - PROT_MODALITY


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