Table Detail Report

PROT_STRATUM



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROT STRATUM
Definition: Contains information about stratum associated with an amendment
Table Type: REFERENCE





Column Detail - PROT_STRATUM


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.
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.
LENGTH_EVALUATION DOUBLE Y Indicates the time period during which toxicity will be evaluated
LENGTH_EVALUATION_UOM_CD DOUBLE N Indicates the unit for the evaluation period. It can be Days, Months or Years.
ORGANIZATION_ID DOUBLE N This field uniquely identifies a row in the organization table. This field identifies the institution responsible for the stratum. For this purpose, an institution can be another hospital, research institute, drug company, government agency, etc.
PARENT_STRATUM_ID DOUBLE N The link back to the stratum_id that this stratum originated or was copied from.
PROT_AMENDMENT_ID DOUBLE N This field uniquely identifies a row in the prot_amendment table. This field identifies the protocol amendment for which this stratum is defined.
PROT_STRATUM_ID DOUBLE N This is the value of the unique primary identifier of the prot_stratum table. It is an internal system assigned number.
STATUS_CHG_REASON_CD DOUBLE N A code value indicating the reason for change in the status of the stratum.
STRATUM_CD DOUBLE N This field contains a code that identifies the stratum.
STRATUM_COHORT_TYPE_CD DOUBLE N Identifies the type of cohorts. Can be "No Cohort", "Multiple cohort accrue simultaneously" or "One cohort can accrue at a time"
STRATUM_CTMS_EXTN_TXT VARCHAR(255) Y The extension id for the stratum communicated in web service request
STRATUM_DESCRIPTION VARCHAR(2000) Y This field contains a description of the stratum
STRATUM_ID DOUBLE N A logical identifier into the prot_stratum table. No two active rows (rows with end_effective_dt_tm = "31-dec-2100") will have the same stratum_id.
STRATUM_LABEL VARCHAR(100) N A display label for the stratum
STRATUM_STATUS_CD DOUBLE N Status of the stratum. Can be "Open to accrual", or "Closed" or "temporarily suspended"
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_STRATUM


Child Column in PROT_STRATUM(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID
PARENT_STRATUM_ID PROT_STRATUM PROT_STRATUM_ID




Parent Column in PROT_STRATUM (PK) Child Table Name Child Column Name
Children: PROT_STRATUM_ID PROT_STRATUM PARENT_STRATUM_ID


PROT_STRATUM_SUSP



Column Section Top of Page


Table-level Detail

Description: PROT STRATUM SUSP
Definition: This table stores information about the suspension of a stratum
Table Type: REFERENCE





Column Detail - PROT_STRATUM_SUSP


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.
COMMENT_TXT LONGBLOB Y This field contains any comments about the suspension that were deemed appropriate.
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.
PROT_STRATUM_SUSP_ID DOUBLE N This is the value of the unique primary identifier of the prot_stratum_susp table. It is an internal system assigned number.
REASON_CD DOUBLE N This field contains the code that identifies the reason the protocol stratum was suspended.
STRATUM_ID DOUBLE N This field identifies the protocol stratum that was suspended.
SUSP_EFFECTIVE_DT_TM DATETIME N The date and time at which the suspesion begins
SUSP_END_DT_TM DATETIME N The date and time when the suspension ends
SUSP_ID DOUBLE N A logical identifier into the prot_stratum_susp 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.


PROT_SUSPENSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROT SUSPENSION
Definition: This table contains information about suspsion of accrual on a protocol
Table Type: REFERENCE





Column Detail - PROT_SUSPENSION


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.
COMMENT_TXT LONGBLOB Y This field contains an explanation of the reasons the protocol was closed for accrual.
CT_MILESTONES_ID DOUBLE N This field identifies the milestone that resulted in the protocol being suspended
END_EFFECTIVE_DT_TM DATETIME Y 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.
PROT_AMENDMENT_ID DOUBLE N Identifies the amendment being suspended
PROT_SUSPENSION_ID DOUBLE N This is the value of the unique primary identifier of the prot_suspension table. It is an internal system assigned number.
REASON_CD DOUBLE N The reason for suspension
REASON_FOR_CORRESPONDENCE_CD DOUBLE N Indicates the reason for correspondence
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_SUSPENSION


Child Column in PROT_SUSPENSION(FK) Parent Table Name Parent Column Name
Parents: CT_MILESTONES_ID CT_MILESTONES CT_MILESTONES_ID
PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID


PT_CONSENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PT CONSENT
Definition: This table stores the information related to consents.
Table Type: ACTIVITY





Column Detail - PT_CONSENT


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.
CONSENTING_ORGANIZATION_ID DOUBLE N This field uniquely identifies a row in the organization table. This field identifies the institution with which the person consenting the patient was affiliated. For this purpose, an institution can be another hospital, research institute, drug company, government agency, etc.
CONSENTING_PERSON_ID DOUBLE N This field uniquely identifies a row in the person table. This field identifies the individual who consented the patient.
CONSENT_ID DOUBLE N Logical identifier into the pt_consent table. No two active rows (End_effective_dt_tm = 31-dec-2100) will have the same consent_id
CONSENT_NBR DOUBLE N This filed is a sequence number of consent released for a person on a protocol.
CONSENT_RECEIVED_DT_TM DATETIME Y Date and time on which the consent was received
CONSENT_RECEIVED_TM_IND DOUBLE N This column identifies whether time is entered by user from front end for Consent Received Time field
CONSENT_RELEASED_DT_TM DATETIME Y Date and time at which the consent was released
CONSENT_RELEASED_TM_IND DOUBLE N This column identifies whether time is entered by user from front end for Consent Released Time field
CONSENT_SIGNED_DT_TM DATETIME N Date and time at which the consent was signed
CONSENT_SIGNED_TM_IND DOUBLE N This column identifies whether time is entered by user from front end for Consent Signed Time field
CT_DOCUMENT_VERSION_ID DOUBLE N Identifies the consent document associated with the patient and 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.
NOT_RETURNED_DT_TM DATETIME N The date and time on which it is determined that consent will not be returned
NOT_RETURNED_REASON_CD DOUBLE N The reason why consent was not returned
NOT_RETURNED_TM_IND DOUBLE N This column identifies whether time is entered by user from front end for Not Returned Time field
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_AMENDMENT_ID DOUBLE N Identifies the amendment for which the consent belongs
PT_CONSENT_ID DOUBLE N This is the value of the unique primary identifier of the pt_consent table. It is an internal system assigned number.
REASON_FOR_CONSENT_CD DOUBLE N This field contains a code identifying the reason the patient was consented for this protocol enrollment.
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_CONSENT


Child Column in PT_CONSENT(FK) Parent Table Name Parent Column Name
Parents: CT_DOCUMENT_VERSION_ID CT_DOCUMENT_VERSION CT_DOCUMENT_VERSION_ID
CONSENTING_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
CONSENTING_PERSON_ID PERSON PERSON_ID
PERSON_ID PERSON PERSON_ID
PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID




Parent Column in PT_CONSENT (PK) Child Table Name Child Column Name
Children: PT_CONSENT_ID CT_REASON_DELETED CONSENT_ID
PT_ELIG_CONSENT_RELTN CONSENT_ID
PT_REG_CONSENT_RELTN CONSENT_ID


PT_CONTROL



Column Section Relationship Section Top of Page


Table-level Detail

Description: PT CONTROL
Definition: This table dcuments the status of a patient. If he was enrolled on a protocol, if not the reason why he was not enrolled etc.
Table Type: ACTIVITY





Column Detail - PT_CONTROL


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CHANGE_DT_TM DATETIME Y The date and time on which the patient status changed
END_EFFECTIVE_DT_TM DATETIME Y 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.
FOLLOW_UP_STATUS_CD DOUBLE N %followup%
INITIAL_PROT_ENROLL_STATUS_CD DOUBLE N Indicates whether the patient was initially enrolled on a protocol. If so what type
NOT_ON_PROT_COMMENT_TXT LONGBLOB Y Comments indicating why the patient was not on a protocol
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PT_CONTROL_ID DOUBLE N Primary key of the pt_control table
PT_STATUS_CD DOUBLE N Indicates the status of the patient. If he is alive, active , discharged etc.
REASON_FOR_NO_PROT_ENROLL_CD DOUBLE N Indicates the reason why the patient was not enrolled on any protocol
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_CONTROL


Child Column in PT_CONTROL(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID