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 |