Table Detail Report

PT_ELIG_CONSENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PT ELIG CONSENT RELTN
Definition: This table contains the relationship between an eligiblity attempt and a consent
Table Type: ACTIVITY





Column Detail - PT_ELIG_CONSENT_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.
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.
CONSENT_ID DOUBLE N A logical row into the pt_consent table. It identifies an active row (consent) that an eligiblity is associated with
PT_ELIG_CONSENT_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the pt_elig_consent_reltn table. It is an internal system assigned number.
PT_ELIG_TRACKING_ID DOUBLE N Identifies a unique row in the pt_elig_tracking table. This identifies the eligibility attempt to which the consent is associated
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_ELIG_CONSENT_RELTN


Child Column in PT_ELIG_CONSENT_RELTN(FK) Parent Table Name Parent Column Name
Parents: CONSENT_ID PT_CONSENT PT_CONSENT_ID
PT_ELIG_TRACKING_ID PT_ELIG_TRACKING PT_ELIG_TRACKING_ID


PT_ELIG_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores all the answers entered when answering the eligibility questions
Definition: Stores all the answers entered when answering the eligibility questions to enrol a patient on a protocol
Table Type: ACTIVITY





Column Detail - PT_ELIG_RESULT


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.
AUDITED_VALUE VARCHAR(255) Y This field contains the value upon which the answer for the protocol eligibility question should have been based.
AUDITED_VALUE_CD DOUBLE N This field contains the answer for the protocol eligibility question entered during the verification process
ELIG_INDICATOR_CD DOUBLE N This field contains the code that indicates whether or not the patient met this eligibility requirement.
ELIG_REVIEW_DT_TM DATETIME Y This field contains the date and time on which the patient's eligibility for enrollment in the protocol was reviewed
ELIG_VALUE_PROVIDER_ORG_ID DOUBLE N This field uniquely identifies a row in the organization table. This field identifies the institution/organization with which the individual who provided the value used to answer the protocol eligibility question was affiliated.
ELIG_VALUE_PROVIDER_PERSON_ID DOUBLE N This field uniquely identifies a row in the person table. This field identifies the individual who supplied the value upon which the eligibility was based.
PROT_AMENDMENT_ID DOUBLE N This field uniquely identifies a row in the prot_amendment table. This field identifies the protocol whose eligibility for enrollment is being evaluated.
PROT_ELIG_QUEST_ID DOUBLE N This field uniquely identifies a row in the prot_elig_quest table. This field identifies the protocol eligibility question that was evaluated.
PT_ELIG_RESULT_ID DOUBLE N This is the value of the unique primary identifier of the pt_elig_result table. It is an internal system assigned number.
PT_ELIG_TRACKING_ID DOUBLE N This field uniquely identifies a row in the pt_elig_tracking table. This field identifies the protocol enrollment attempt.
SPECIMEN_TEST_DT_TM DATETIME Y This field contains the date and time the specimen was collected or the date and time of the test upon which the patient's eligibility was determined.
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 VARCHAR(255) Y This field contains the value upon which the patient's eligibility for enrollment in the protocol was determined.
VALUE_CD DOUBLE N The answer entered by the user during eligibility checking
VERIFIED_ELIG_STATUS_CD DOUBLE N This field contains the code identifying whether the patient met the eligibility criteria after the data was verified.
VERIFIED_SPECIMEN_TEST_DT_TM DATETIME Y This field contains the date and time the specimen was collected or the date and time of the test upon which the patient's eligibility was verified.



Relationship Detail - PT_ELIG_RESULT


Child Column in PT_ELIG_RESULT(FK) Parent Table Name Parent Column Name
Parents: ELIG_VALUE_PROVIDER_ORG_ID ORGANIZATION ORGANIZATION_ID
PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID
PROT_ELIG_QUEST_ID PROT_ELIG_QUEST PROT_ELIG_QUEST_ID
ELIG_VALUE_PROVIDER_PERSON_ID PRSNL PERSON_ID
PT_ELIG_TRACKING_ID PT_ELIG_TRACKING PT_ELIG_TRACKING_ID


PT_ELIG_TRACKING



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table stores the eligiblity attempts done to enroll a patient on a protocol
Definition: This table stores the eligiblity attempts done to enroll a patient on a protocol. It stores the status of the attempt, such as if the patient was found eligible etc.
Table Type: ACTIVITY





Column Detail - PT_ELIG_TRACKING


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.
ELIG_REQUEST_ORG_ID DOUBLE N Organization requesting the eligibilty attempt of the patient on the protocol
ELIG_REQUEST_PERSON_ID DOUBLE N The person requesting the eligiblity attempt of the patient on the protocol
ELIG_REVIEW_ORG_ID DOUBLE N The organization reviewing the eligibility attempt
ELIG_REVIEW_PERSON_ID DOUBLE N The person reviewing the eligiblity
ELIG_STATUS_CD DOUBLE N This field contains the code defining the patient's eligibility for enrollment in the protocol.
ENROLLMENT_NBR DOUBLE N This field identifies the sequence of the protocol amendment for which the patient is being evaluated for eligibility.
LAST_ATTEMPT_INDICATOR_CD DOUBLE N This field contains the code that defines this attempt to enroll the patient in the protocol as the last attempt made to enroll the patient in the protocol.
OVERRIDE_DT_TM DATETIME Y Stores the date that the eligibility evaluation was over-ridden
OVERRIDE_REASON_CD DOUBLE N Stores the reason why eligibility evaluation was over-ridden
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 This field uniquely identifies a row in the prot_amendment table. This field identifies the protocol amendment for which the patient's eligibility is being evaluated. ***OBSOLETE***
PROT_QUESTIONNAIRE_ID DOUBLE N Uniquely identifies a questionnaire in the table
PT_ELIG_TRACKING_ID DOUBLE N Primary key of pt_elig_tracking table
REASON_INELIGIBLE_CD DOUBLE N This field contains the code for the primary reason the patient was found ineligible to be enrolled in the protocol.
SEQUENCE_NBR DOUBLE N This field contains the number of the attempt to enroll the patient in the protocol amendment.
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_ELIG_TRACKING


Child Column in PT_ELIG_TRACKING(FK) Parent Table Name Parent Column Name
Parents: ELIG_REQUEST_ORG_ID ORGANIZATION ORGANIZATION_ID
ELIG_REVIEW_ORG_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID
PROT_QUESTIONNAIRE_ID PROT_QUESTIONNAIRE PROT_QUESTIONNAIRE_ID
ELIG_REQUEST_PERSON_ID PRSNL PERSON_ID
ELIG_REVIEW_PERSON_ID PRSNL PERSON_ID




Parent Column in PT_ELIG_TRACKING (PK) Child Table Name Child Column Name
Children: PT_ELIG_TRACKING_ID ASSIGN_ELIG_RELTN PT_ELIG_TRACKING_ID
CT_REASON_DELETED PT_ELIG_TRACKING_ID
PT_ELIG_CONSENT_RELTN PT_ELIG_TRACKING_ID
PT_ELIG_RESULT PT_ELIG_TRACKING_ID
PT_ELIG_TRACKING_NOTES PT_ELIG_TRACKING_ID
PT_REG_ELIG_RELTN PT_ELIG_TRACKING_ID


PT_ELIG_TRACKING_NOTES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Checklist Notes
Definition: This table stores notes attached to eligibility checklists filled out for patients.
Table Type: ACTIVITY





Column Detail - PT_ELIG_TRACKING_NOTES


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.
NOTE_LONG_TEXT_ID DOUBLE N references the long text for the checklist description. foreign key from the long text reference table.
NOTE_TYPE_CD DOUBLE N This indicates what type of note it is.
PREV_PT_ELIG_TRACKING_NOTES_ID DOUBLE N The original value of the Pt_elig_tracking_notes_id used for grouping the related versons. Required for type 2 versioning methodology.
PT_ELIG_TRACKING_ID DOUBLE N Identifies a unique row in the pt_elig_tracking table. This identifies the eligibility attempt to which the note is associated.
PT_ELIG_TRACKING_NOTES_ID DOUBLE N Primary key
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_ELIG_TRACKING_NOTES


Child Column in PT_ELIG_TRACKING_NOTES(FK) Parent Table Name Parent Column Name
Parents: NOTE_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PT_ELIG_TRACKING_ID PT_ELIG_TRACKING PT_ELIG_TRACKING_ID
PREV_PT_ELIG_TRACKING_NOTES_ID PT_ELIG_TRACKING_NOTES PT_ELIG_TRACKING_NOTES_ID




Parent Column in PT_ELIG_TRACKING_NOTES (PK) Child Table Name Child Column Name
Children: PT_ELIG_TRACKING_NOTES_ID PT_ELIG_TRACKING_NOTES PREV_PT_ELIG_TRACKING_NOTES_ID


PT_INTEREST_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Interest Comment
Definition: Doucments the optional comments for patient interest change workflow in Clinical Trials
Table Type: ACTIVITY





Column Detail - PT_INTEREST_COMMENT


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.
COMMENT_ADDED_DT_TM DATETIME N The date and time when comment was added
COMMENT_ADDED_PRSNL_ID DOUBLE N The person who added the comment
COMMENT_TXT VARCHAR(2000) Y comment added during the interest change workflow. Free Form text.
PERSON_ID DOUBLE N The patient for whom the interest change comment is being added
PT_INTEREST_COMMENT_ID DOUBLE N PRIMARY KEY
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_INTEREST_COMMENT


Child Column in PT_INTEREST_COMMENT(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
COMMENT_ADDED_PRSNL_ID PRSNL PERSON_ID