Table Detail Report
PROT_OBJECTIVE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PROT OBJECTIVE |
Definition: | Stores the objectives associated with the amendment |
Table Type: | REFERENCE |
Column Detail - PROT_OBJECTIVE
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 | 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. |
LONG_TEXT_ID | DOUBLE | N | References the long_text for the objective. Foreign Key from Long_Text_Reference table. |
OBJECTIVE | VARCHAR(2000) | N | *OBSOLETE - Replaced by value associate with LONG_TEXT_ID from Long Text Reference |
OBJECTIVE_NBR | VARCHAR(30) | N | This field contains a number indicating whether the objective is the first, second, third, ... nth objective |
OBJECTIVE_TYPE_CD | DOUBLE | N | This field contains an indicator as to whether the objective is a primary objective or secondary objective. |
PARENT_PROT_OBJECTIVE_ID | DOUBLE | N | Uniquely identifies the parent of the current objective |
PROT_AMENDMENT_ID | DOUBLE | N | Uniquely identifies the Amendment |
PROT_OBJECTIVE_ID | DOUBLE | N | Primary Key |
SEQUENCE_NBR | DOUBLE | N | This field contains a number indicating whether the objective is the first, second, third, ... nth objective. |
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_OBJECTIVE
Child Column in PROT_OBJECTIVE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
PROT_AMENDMENT_ID | PROT_AMENDMENT | PROT_AMENDMENT_ID | |
PARENT_PROT_OBJECTIVE_ID | PROT_OBJECTIVE | PROT_OBJECTIVE_ID |
Parent Column in PROT_OBJECTIVE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PROT_OBJECTIVE_ID | PROT_OBJECTIVE | PARENT_PROT_OBJECTIVE_ID |
PROT_QUESTIONNAIRE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PROT QUESTIONNAIRE |
Definition: | This table stores information on questionnaires connected to an amendment |
Table Type: | REFERENCE |
Column Detail - PROT_QUESTIONNAIRE
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. |
DESC_LONG_TEXT_ID | DOUBLE | N | References the long text for the checklist description. Foreign key from the long text reference table. |
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. |
PREV_PROT_QUESTIONNAIRE_ID | DOUBLE | N | The original value of prot_questionnaire_id used for grouping the related versions. Required for type2 versioning. |
PROT_AMENDMENT_ID | DOUBLE | N | Refers to the amendment that this questionnaire is connected to |
PROT_QUESTIONNAIRE_ID | DOUBLE | N | Uniquely identifies a questionnaire in the table |
QUESTIONNAIRE_NAME | VARCHAR(255) | Y | Free text name of the questionnaire. |
QUESTIONNAIRE_TYPE_CD | DOUBLE | N | Identifies the type of the questionnaire (CS: Checklist_type) |
SPECIAL_INST_LONG_TEXT_ID | DOUBLE | N | References the long text for the checklist special instruction. Foreign key from the long text reference 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. |
Relationship Detail - PROT_QUESTIONNAIRE
Child Column in PROT_QUESTIONNAIRE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DESC_LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
SPECIAL_INST_LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID | |
PROT_AMENDMENT_ID | PROT_AMENDMENT | PROT_AMENDMENT_ID | |
PREV_PROT_QUESTIONNAIRE_ID | PROT_QUESTIONNAIRE | PROT_QUESTIONNAIRE_ID |
Parent Column in PROT_QUESTIONNAIRE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PROT_QUESTIONNAIRE_ID | PROT_ELIG_QUEST | PROT_QUESTIONNAIRE_ID |
PROT_QUESTIONNAIRE | PREV_PROT_QUESTIONNAIRE_ID | ||
PT_ELIG_TRACKING | PROT_QUESTIONNAIRE_ID | ||
QUESTIONNAIRE_DOC_RELTN | PROT_QUESTIONNAIRE_ID |
PROT_REGULATORY_REQ
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PROT REGULATORY REQ |
Definition: | This table documents the information about regulatory reports on a protocol |
Table Type: | REFERENCE |
Column Detail - PROT_REGULATORY_REQ
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. |
PROT_MASTER_ID | DOUBLE | N | Identifies the protocol for which this regulatory report is for |
PROT_REGULATORY_REQ_ID | DOUBLE | N | Primary key of the prot_regulatory_req table |
REGULATORY_REQ_ID | DOUBLE | N | Uniquely identifies an active row in Prot_regulatory_req table |
REG_REPORTING_TYPE_CD | DOUBLE | N | Indicates the type of regulatory reporting |
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_REGULATORY_REQ
Child Column in PROT_REGULATORY_REQ(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROT_MASTER_ID | PROT_MASTER | PROT_MASTER_ID |
PROT_ROLE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PROT ROLE |
Definition: | Table stores all the roles assignments for an amendment |
Table Type: | REFERENCE |
Column Detail - PROT_ROLE
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. |
CREATED_BY_CTMS_IND | DOUBLE | N | Indicates whether the role is created by CTMS. 0 indicates that the role is manually created and 1 indicates that the role is created by CTMS. |
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. |
ORGANIZATION_ID | DOUBLE | N | Uniquely identifies the organization playing a role on the amendment |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
POSITION_CD | DOUBLE | N | The position is used to determine the applications and tasks the personnel is authorized to use |
PRIMARY_CONTACT_IND | DOUBLE | N | Indicates whether a role is the primary contact for the amendment. |
PRIMARY_CONTACT_RANK_NBR | DOUBLE | N | Defines the rank/order of primary contacts. |
PROT_AMENDMENT_ID | DOUBLE | N | Uniquely identifies the amendment |
PROT_ROLE_CD | DOUBLE | N | The role which is played by the person/entity on the amendmentz |
PROT_ROLE_ID | DOUBLE | N | Primary Key |
PROT_ROLE_TYPE_CD | DOUBLE | N | The Type of role played. eg., personal/Institutional |
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_ROLE
Child Column in PROT_ROLE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
PROT_AMENDMENT_ID | PROT_AMENDMENT | PROT_AMENDMENT_ID | |
PERSON_ID | PRSNL | PERSON_ID |
PROT_ROLE_ACCESS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PROT ROLE ACCESS |
Definition: | Table stores the access rights each role has for various functionalities |
Table Type: | REFERENCE |
Column Detail - PROT_ROLE_ACCESS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESS_MASK | CHAR(5) | N | A mask of characters to indicate the level of access - the mask could be made up of any or all of the following - R - Read C - Create U - Update D - Delete E - Execute |
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 | 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. |
FUNCTIONALITY_CD | DOUBLE | N | Indicates the functionality for which the access mask is being defined |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
PROT_ROLE_ACCESS_ID | DOUBLE | N | Primary Key |
PROT_ROLE_CD | DOUBLE | N | The role for which access mask is being defined |
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_ROLE_ACCESS
Child Column in PROT_ROLE_ACCESS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |