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