Table Detail Report

CT_FACILITY_CD_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: CT Facility Code Groups
Definition: Stores the Clinical Trials Facility Code Groupings for a CT User Preference
Table Type: ACTIVITY





Column Detail - CT_FACILITY_CD_GROUP


Column Name Type Null? Definition
CT_FACILITY_CD_GROUP_ID DOUBLE N PRIMARY KEY
FACILITY_CD DOUBLE N Facility for this grouping
FACILITY_GROUP_ID DOUBLE N GROUPER for set of Facilities. Value is same as PK for first facility in the group.
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_FACILITY_CD_GROUP


Child Column in CT_FACILITY_CD_GROUP(FK) Parent Table Name Parent Column Name
Parents: FACILITY_GROUP_ID CT_FACILITY_CD_GROUP CT_FACILITY_CD_GROUP_ID




Parent Column in CT_FACILITY_CD_GROUP (PK) Child Table Name Child Column Name
Children: CT_FACILITY_CD_GROUP_ID CT_FACILITY_CD_GROUP FACILITY_GROUP_ID
CT_USER_PREFERENCE CT_FACILITY_CD_GROUP_ID


CT_MILESTONES



Column Section Relationship Section Top of Page


Table-level Detail

Description: CT MILESTONES
Definition: This table is used to store the milestones attached to an amendment
Table Type: REFERENCE





Column Detail - CT_MILESTONES


Column Name Type Null? Definition
ACTIVITY_CD DOUBLE N The activity related to the milestone. Example: Activate By, Approved By etc.
COMMITTEE_ID DOUBLE N The committee performing the activity
CT_MILESTONES_ID DOUBLE N This is the value of the unique primary identifier of the ct_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 and time on which the action was performed
PROT_AMENDMENT_ID DOUBLE N The amendment to which the milestone 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. A milestone for an amendment can have any number from 1 to the number of milestones.
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_MILESTONES


Child Column in CT_MILESTONES(FK) Parent Table Name Parent Column Name
Parents: COMMITTEE_ID COMMITTEE COMMITTEE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID




Parent Column in CT_MILESTONES (PK) Child Table Name Child Column Name
Children: CT_MILESTONES_ID PROT_SUSPENSION CT_MILESTONES_ID


CT_PRESCREEN_JOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Power Trials Screening Job Data
Definition: Store the prescreening job data
Table Type: ACTIVITY





Column Detail - CT_PRESCREEN_JOB


Column Name Type Null? Definition
CT_PRESCREEN_JOB_ID DOUBLE N Primary key
JOB_END_DT_TM DATETIME N The date and time for which this job ended.
JOB_START_DT_TM DATETIME N The date and time for which this job started.
JOB_STATUS_CD DOUBLE N This field holds the status of the prescreening job.
JOB_TYPE_FLAG DOUBLE N This field indicates what type of screening job this is: Prescreen Test POM(0), Prescreen Test(1) or Prescreen(2)
LONG_TEXT_ID DOUBLE N This field uniquely identifies a row in the LONG_TEXT table.
PRSNL_ID DOUBLE N This field uniquely identifies a row in the prsnl table. It is the person that initiated the prescreening job.
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_PRESCREEN_JOB


Child Column in CT_PRESCREEN_JOB(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in CT_PRESCREEN_JOB (PK) Child Table Name Child Column Name
Children: CT_PRESCREEN_JOB_ID CT_PROT_PRESCREEN_JOB_INFO CT_PRESCREEN_JOB_ID
PT_PROT_PRESCREEN CT_PRESCREEN_JOB_ID
PT_PROT_PRESCREEN_TEST CT_PRESCREEN_JOB_ID


CT_PROT_AMD_CUSTOM_FLD_VAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Protocol amendment custom field value
Definition: This table stores the values entered for a custom field.
Table Type: REFERENCE





Column Detail - CT_PROT_AMD_CUSTOM_FLD_VAL


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.
CT_CUSTOM_FIELD_ID DOUBLE N This field uniquely identifies a row in the ct_custom_field table.
CT_PROT_AMD_CUSTOM_FLD_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.
FIELD_POSITION DOUBLE N A number which identifies the positon of the field
PREV_CT_PROT_AMD_CUSTOM_FLD_ID DOUBLE N The original value of the ct_prot_amd_custom_field_value_id used for grouping the related versons. Required for type 2 versioning methodology.
PROT_AMENDMENT_ID DOUBLE N This field uniquely identifies a row in the prot_amendment table.
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_CD DOUBLE N This field contains the code that was selected by the user. The code set from which it is from is defined by the ct_custom_field_id record.Flex on code sets.
VALUE_DT_TM DATETIME N This field contains the date and time entered in by the user.
VALUE_TEXT VARCHAR(255) N This field contains the text entered in by the user.



Relationship Detail - CT_PROT_AMD_CUSTOM_FLD_VAL


Child Column in CT_PROT_AMD_CUSTOM_FLD_VAL(FK) Parent Table Name Parent Column Name
Parents: CT_CUSTOM_FIELD_ID CT_CUSTOM_FIELD CT_CUSTOM_FIELD_ID
PREV_CT_PROT_AMD_CUSTOM_FLD_ID CT_PROT_AMD_CUSTOM_FLD_VAL CT_PROT_AMD_CUSTOM_FLD_ID
PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID




Parent Column in CT_PROT_AMD_CUSTOM_FLD_VAL (PK) Child Table Name Child Column Name
Children: CT_PROT_AMD_CUSTOM_FLD_ID CT_PROT_AMD_CUSTOM_FLD_VAL PREV_CT_PROT_AMD_CUSTOM_FLD_ID


CT_PROT_CONFIG_VALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Protocol Level configuration value
Definition: This table stores the configuration values entered for a protocol.
Table Type: REFERENCE





Column Detail - CT_PROT_CONFIG_VALUE


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_CONFIG_VALUE_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.
PREV_CT_PROT_CONFIG_VALUE_ID DOUBLE N The original value of the ct_prot_config_value_id used for grouping the related versons. Required for type 2 versioning methodology.
PROT_MASTER_ID DOUBLE N This field uniquely identifies a row in the prot_master table.
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_PROT_CONFIG_VALUE


Child Column in CT_PROT_CONFIG_VALUE(FK) Parent Table Name Parent Column Name
Parents: PREV_CT_PROT_CONFIG_VALUE_ID CT_PROT_CONFIG_VALUE CT_PROT_CONFIG_VALUE_ID
PROT_MASTER_ID PROT_MASTER PROT_MASTER_ID




Parent Column in CT_PROT_CONFIG_VALUE (PK) Child Table Name Child Column Name
Children: CT_PROT_CONFIG_VALUE_ID CT_PROT_CONFIG_VALUE PREV_CT_PROT_CONFIG_VALUE_ID