Table Detail Report
ASSIGN_ELIG_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ASSIGN ELIGIBILITY RELATION |
Definition: | This table contains the relation between pt_elig_tracking and prot_cohort tables |
Table Type: | ACTIVITY |
Column Detail - ASSIGN_ELIG_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ASSIGN_ELIG_RELTN_ID | DOUBLE | N | This is the value of the unique primary identifier of the assign_elig_reltn table. It is an internal system assigned number. |
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. |
COHORT_ID | DOUBLE | N | A logical identifier in the prot_cohort table. No two rows in the prot_cohort table will have the same cohort_id when end_effective_dt_tm = 31-dec-2100 |
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. |
PT_ELIG_TRACKING_ID | DOUBLE | N | This is the value of the unique primary identifier of the pt_elig_tracking table. It is an internal system assigned number. |
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 - ASSIGN_ELIG_RELTN
Child Column in ASSIGN_ELIG_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PT_ELIG_TRACKING_ID | PT_ELIG_TRACKING | PT_ELIG_TRACKING_ID |
ASSIGN_REG_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table contains the relationship between pt_prot_reg and prot_cohort tables. |
Definition: | This is a relationship table between pt_prot_reg and prot_cohort tables |
Table Type: | ACTIVITY |
Column Detail - ASSIGN_REG_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ASSIGN_REG_RELTN_ID | DOUBLE | N | This is the value of the unique primary identifier of the assign_reg_reltn table. It is an internal system assigned number. |
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. |
COHORT_ID | DOUBLE | N | This is a logical identifier in the prot_cohort table. It uniquely identifies an active row in the prot_cohort table. No two rows with an end_effective_dt_tm of max_date (dec-31-2100) can have the same cohort_id. |
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. |
REG_ID | DOUBLE | N | Uniquely identifies the registration |
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 - ASSIGN_REG_RELTN
Child Column in ASSIGN_REG_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REG_ID | PT_PROT_REG | PT_PROT_REG_ID |
CATEGORY_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table contains all the categories associated with categorical questions |
Definition: | This table contains all the categories associated with categorical eligibility questions. |
Table Type: | REFERENCE |
Column Detail - CATEGORY_ITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
ANSWER_DOMAIN_ID | DOUBLE | N | Indicates the answer domain to which this category_item belongs |
CATEGORY_ITEM_ID | DOUBLE | N | This is the value of the unique primary identifier of the category_item table. It is an internal system assigned number. |
CATEGORY_ITEM_NBR | DOUBLE | N | The number of the category For Ex: A category 'Sex' can have three choices 'Male', 'Female' and 'Unknown'. In this case the Category_item_nbr will be 1, 2 and 3 respectively. |
CATEGORY_ITEM_TEXT | VARCHAR(255) | N | The textual description of the category item |
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 - CATEGORY_ITEM
Child Column in CATEGORY_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ANSWER_DOMAIN_ID | ANSWER_DOMAIN | ANSWER_DOMAIN_ID |
Parent Column in CATEGORY_ITEM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CATEGORY_ITEM_ID | VALID_ANSWER_CAT | CATEGORY_ITEM_ID |
COMMITTEE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table contains information about committees. |
Definition: | This table contains the information about the committees |
Table Type: | REFERENCE |
Column Detail - 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. |
COMMITTEE_ID | DOUBLE | N | This is the value of the unique primary identifier of the committee table. It is an internal system assigned number. |
COMMITTEE_NAME | VARCHAR(255) | N | Name of the committee |
COMMITTEE_TYPE_CD | DOUBLE | N | Indicates the type of committee. Valid values are IRB, CPSRMC and OTHER. |
EMAIL_ADDRESS | VARCHAR(255) | Y | E-mail address of the committee |
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. |
SPONSORING_ORG_ID | DOUBLE | N | This is the value of the unique primary identifier of the organization table. It is an internal system assigned number. |
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 - COMMITTEE
Child Column in COMMITTEE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SPONSORING_ORG_ID | ORGANIZATION | ORGANIZATION_ID |
Parent Column in COMMITTEE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | COMMITTEE_ID | COMMITTEE_MEMBER | COMMITTEE_ID |
CT_DEFAULT_MILESTONES | COMMITTEE_ID | ||
CT_MILESTONES | COMMITTEE_ID | ||
CT_PROT_MILESTONES | COMMITTEE_ID | ||
CT_TYPE_COMMITTEE_RELTN | COMMITTEE_ID | ||
PROT_AMD_COMMITTEE_RELTN | COMMITTEE_ID |
COMMITTEE_MEMBER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | COMMITTEE MEMBER |
Definition: | This tables contains ids of committee members and the organizations they belong |
Table Type: | REFERENCE |
Column Detail - COMMITTEE_MEMBER
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. |
COMMITTEE_ID | DOUBLE | N | This is the value of the unique primary identifier of the committe table. It is an internal system assigned number. |
COMMITTEE_MEMBER_ID | DOUBLE | N | This is the value of the unique primary identifier of the committee_member table. It is an internal system assigned number. |
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. |
ORGANIZATION_ID | DOUBLE | N | The unique identifier of the organization (from the organization table) to which the member belongs. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
ROLE_CD | DOUBLE | N | The role of the member in the committee |
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 - COMMITTEE_MEMBER
Child Column in COMMITTEE_MEMBER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | COMMITTEE_ID | COMMITTEE | COMMITTEE_ID |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PRSNL | PERSON_ID |