Table Detail Report

QUESTIONNAIRE_DOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROT_QUESTIONNAIRE to CT_DOCUMENT_VERSION relationships
Definition: This table stores the relationships between consent documents and the corresponding questionnaires.
Table Type: REFERENCE





Column Detail - QUESTIONNAIRE_DOC_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.
CT_DOCUMENT_ID DOUBLE N References the document which is attached to the Questionnaire
PROT_QUESTIONNAIRE_ID DOUBLE N References the questionnaire to which the document is to be attached. FK from Prot_Questionnaire.
QUESTIONNAIRE_DOC_ID DOUBLE N Primary key for Relationship.
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 - QUESTIONNAIRE_DOC_RELTN


Child Column in QUESTIONNAIRE_DOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: PROT_QUESTIONNAIRE_ID PROT_QUESTIONNAIRE PROT_QUESTIONNAIRE_ID


REVISION



Column Section Relationship Section Top of Page


Table-level Detail

Description: REVISION
Definition: Tables stores information about Revisions created on an amendment
Table Type: REFERENCE





Column Detail - REVISION


Column Name Type Null? Definition
PROT_AMENDMENT_ID DOUBLE N The amendment for which this revision belongs to
REVISION_DESCRIPTION VARCHAR(255) N Free Text description of the reason for the revision
REVISION_DT_TM DATETIME N This field contains the date and time on which the revision was made.
REVISION_ID DOUBLE N Primary Key
REVISION_NBR DOUBLE N This field contains the number of the revision (1-first revision, 2-second revision, 3-third revision, etc.). A revision is a minor change to the protocol document such as correction of a spelling error or typographic error.
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 - REVISION


Child Column in REVISION(FK) Parent Table Name Parent Column Name
Parents: PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID




Parent Column in REVISION (PK) Child Table Name Child Column Name
Children: REVISION_ID CT_DOCUMENT_VERSION REVISION_ID


SAFETY_COMMITTEE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SAFETY COMMITTEE
Definition: Table stores all the members comprising the safety committee for an amendment
Table Type: REFERENCE





Column Detail - SAFETY_COMMITTEE


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.
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
SAFETY_COMMITTEE_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 - SAFETY_COMMITTEE


Child Column in SAFETY_COMMITTEE(FK) Parent Table Name Parent Column Name
Parents: PROT_AMENDMENT_ID PROT_AMENDMENT PROT_AMENDMENT_ID
PERSON_ID PRSNL PERSON_ID


SUPPORT_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Table stores all the types of support provided by the grant sponsor organization
Definition: Table stores information about all the types of support provided by the grant sponsor organization
Table Type: REFERENCE





Column Detail - SUPPORT_TYPE


Column Name Type Null? Definition
PROT_GRANT_SPONSOR_ID DOUBLE N FK to prot_grant_sponsor table .. identifies the sponsor
SUPPORT_TYPE_CD DOUBLE N The type of support provided by the grant sponsor - Code Set 17436
SUPPORT_TYPE_DESC_OTR VARCHAR(255) Y Free text description of Other support provided by grant sponsor
SUPPORT_TYPE_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 - SUPPORT_TYPE


Child Column in SUPPORT_TYPE(FK) Parent Table Name Parent Column Name
Parents: PROT_GRANT_SPONSOR_ID PROT_GRANT_SPONSOR PROT_GRANT_SPONSOR_ID


VALID_ANSWER_CAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: VALID ANSWER CAT
Definition: This table stores valid answers for categorical questions.
Table Type: REFERENCE





Column Detail - VALID_ANSWER_CAT


Column Name Type Null? Definition
ANSWER_FORMAT_ID DOUBLE N Uniquely identifies a row in the answer format table. The answer format to which this valid answer relates to
CATEGORY_ITEM_ID DOUBLE N This identifies the category Item that is a valid answer
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.
VALID_ANSWER_CAT_ID DOUBLE N Uniquely identifies a row in the valid_answer_cat table. It is a system assigned number.



Relationship Detail - VALID_ANSWER_CAT


Child Column in VALID_ANSWER_CAT(FK) Parent Table Name Parent Column Name
Parents: ANSWER_FORMAT_ID ANSWER_FORMAT ANSWER_FORMAT_ID
CATEGORY_ITEM_ID CATEGORY_ITEM CATEGORY_ITEM_ID