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 |