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 |