Table Detail Report

CT_RN_RUN_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Research Network Run Activity
Definition: This table stores the research network run history.
Table Type: ACTIVITY





Column Detail - CT_RN_RUN_ACTIVITY


Column Name Type Null? Definition
CT_RN_PROT_RUN_ID DOUBLE N this field uniquely identifies a row in the ct_rn_prot_run table.
CT_RN_RUN_ACTIVITY_ID DOUBLE N Primary key
STATUS_FLAG DOUBLE N This field contains the completed status of a research network run.
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_RUN_ACTIVITY


Child Column in CT_RN_RUN_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: CT_RN_PROT_RUN_ID CT_RN_PROT_RUN CT_RN_PROT_RUN_ID


CT_TYPE_COMMITTEE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Participation type and committee relationship table.
Definition: This table contains the default selected committees for protocol participation types.
Table Type: REFERENCE





Column Detail - CT_TYPE_COMMITTEE_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.
AMD_VALIDATE_IND DOUBLE N Default required value for amendments.
COMMITTEE_ID DOUBLE N This field uniquely identifies a row in the committee table. This field identifies the commitee that is related to the protocol amendment.
CT_TYPE_COMMITTEE_ID DOUBLE N This is the value of the unique primary identifier of the Ct_type_committee_reltn table. It is an internal system assigned number.
EDIT_IND DOUBLE N This field indicates whether this committee on this participation type can be edited
PARTICIPATION_TYPE_CD DOUBLE N This field indicates the type of participation available to protocols.
REV_VALIDATE_IND DOUBLE N Default required value for revisions.
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_TYPE_COMMITTEE_RELTN


Child Column in CT_TYPE_COMMITTEE_RELTN(FK) Parent Table Name Parent Column Name
Parents: COMMITTEE_ID COMMITTEE COMMITTEE_ID


CT_USER_DOMAIN_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: User sign on information for each Discovere domain.
Definition: This table stores the user sign on information for each Discovere domain.
Table Type: ACTIVITY





Column Detail - CT_USER_DOMAIN_INFO


Column Name Type Null? Definition
CT_DOMAIN_INFO_ID DOUBLE N This is the value of the unique primary identifier of the ct_domain_info table.
CT_USER_DOMAIN_INFO_ID DOUBLE N PRIMARY KEY
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. 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.
USER_TOKEN_TXT VARCHAR(255) N This field contains the user's token sign on information string.



Relationship Detail - CT_USER_DOMAIN_INFO


Child Column in CT_USER_DOMAIN_INFO(FK) Parent Table Name Parent Column Name
Parents: CT_DOMAIN_INFO_ID CT_DOMAIN_INFO CT_DOMAIN_INFO_ID
PERSON_ID PERSON PERSON_ID


CT_USER_PREFERENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Trials - User Preferences
Definition: Stores the clinical trial filter preferences for each user
Table Type: ACTIVITY





Column Detail - CT_USER_PREFERENCE


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.
CT_FACILITY_CD_GROUP_ID DOUBLE N FK value from a row in the CT_FACILITY_CD_GROUP table wihich helps identify a group of facilities
CT_USER_PREFERENCE_ID DOUBLE N PRIMARY KEY
FUNCTIONALITY_TYPE_FLAG DOUBLE N Type of functionality for which the filter preferences are stored
PREFERENCE_STATUS_FLAG DOUBLE N A status which indicates whether the preference was shared by other user or saved personally
PREFERENCE_TEXT LONGTEXT Y A large object block which contains the user preference data in text form.
PROT_MASTER_ID DOUBLE N FK value for a row in the PROT_MASTER table
PRSNL_ID DOUBLE N Unqiue Id of prsnl whose filter preferences in powertrials application needs to be stored
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_USER_PREFERENCE


Child Column in CT_USER_PREFERENCE(FK) Parent Table Name Parent Column Name
Parents: CT_FACILITY_CD_GROUP_ID CT_FACILITY_CD_GROUP CT_FACILITY_CD_GROUP_ID
PROT_MASTER_ID PROT_MASTER PROT_MASTER_ID
PRSNL_ID PRSNL PERSON_ID


DATA_SUBMISSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: DATA SUBMISSION
Definition: This table is used to store the organizations to which data must be sent
Table Type: REFERENCE





Column Detail - DATA_SUBMISSION


Column Name Type Null? Definition
DATA_SUBMISSION_ID DOUBLE N Primary Key
PROT_AMENDMENT_ID DOUBLE N Primary key of the prot_amendment table. Identifies the protocol amendment whose data must be sent.
REPORTING_CLASS_CD DOUBLE N The type of data that needs to be reported
SUBMITTED_TO_CD DOUBLE N The org to which the data is to be sent
SUBMITTED_TO_DESC VARCHAR(255) Y Written name of the organization to which the data is to be sent
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 - DATA_SUBMISSION


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