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 |