AMENDMENT_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: AMENDMENT ALIAS
Definition: This table is used to store the aliases for an amendment
Table Type: REFERENCE





Column Detail - AMENDMENT_ALIAS


Column Name Type Null? Definition
ALIAS_ID DOUBLE N A unique key for the Amendment alias on a protocol. No two active rows can have the same Alias_id.
ALIAS_POOL_CD DOUBLE N Identifies the alias pool to which this alias belongs
AMENDMENT_ALIAS VARCHAR(255) N This is the alias assigned to the amendment
AMENDMENT_ALIAS_ID DOUBLE N This is the value of the unique primary identifier of the amendment_alias table. It is an internal system assigned number.
AMENDMENT_ALIAS_TYPE_CD DOUBLE N Protocol Alias Type
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_AMENDMENT_ID DOUBLE N This is the value of the unique primary identifier of the prot_amendment 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 - AMENDMENT_ALIAS


Child Column in AMENDMENT_ALIAS(FK) Parent Table Name Parent Column Name
Parents: ALIAS_ID AMENDMENT_ALIAS AMENDMENT_ALIAS_ID




Parent Column in AMENDMENT_ALIAS (PK) Child Table Name Child Column Name
Children: AMENDMENT_ALIAS_ID AMENDMENT_ALIAS ALIAS_ID


AMENDMENT_REASON



Column Section Relationship Section Top of Page


Table-level Detail

Description: AMENDMENT REASON
Definition: This table documents the reason for an amendment
Table Type: REFERENCE





Column Detail - AMENDMENT_REASON


Column Name Type Null? Definition
AMENDMENT_REASON_CD DOUBLE N This field indicates the reason for the creation of the amendment.
AMENDMENT_REASON_ID DOUBLE N Primary identifier into the amendment_reason table.
PROT_AMENDMENT_ID DOUBLE N The primary key into the prot_amendment 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 - AMENDMENT_REASON


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


ANSWER_DOMAIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains the answer domains
Definition: Answer Domains
Table Type: REFERENCE





Column Detail - ANSWER_DOMAIN


Column Name Type Null? Definition
ANSWER_DOMAIN_DESCN VARCHAR(255) N Description of the answer domain
ANSWER_DOMAIN_ID DOUBLE N This is the value of the unique primary identifier of the answer_domain table. It is an internal system assigned number.
ANSWER_DOMAIN_LABEL VARCHAR(30) N A short description of the answer domain less than 30 characters
ANSWER_DOMAIN_TYPE_CD DOUBLE N The type of answer domain. It can be Range, Categorical, Date, Lab or Numerical.
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 - ANSWER_DOMAIN




Parent Column in ANSWER_DOMAIN (PK) Child Table Name Child Column Name
Children: ANSWER_DOMAIN_ID ANSWER_FORMAT ANSWER_DOMAIN_ID
CATEGORY_ITEM ANSWER_DOMAIN_ID


ANSWER_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: answer_format contains valid answer formats for protocol eligibility questions.
Definition: answer_format contains valid answer formats for protocol eligibility questions. One or more answer formats make up an answer domain.
Table Type: REFERENCE





Column Detail - ANSWER_FORMAT


Column Name Type Null? Definition
ANSWER_DOMAIN_ID DOUBLE N This is the value of the unique primary identifier of the answer_domain table. It is an internal system assigned number.
ANSWER_FORMAT_ID DOUBLE N This is the value of the unique primary identifier of the answer_format table. It is an internal system assigned number.
FORMAT_DESCN VARCHAR(255) N A textual description of the format
FORMAT_LABEL VARCHAR(30) N A short display label less than 30 characters in length
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 - ANSWER_FORMAT


Child Column in ANSWER_FORMAT(FK) Parent Table Name Parent Column Name
Parents: ANSWER_DOMAIN_ID ANSWER_DOMAIN ANSWER_DOMAIN_ID




Parent Column in ANSWER_FORMAT (PK) Child Table Name Child Column Name
Children: ANSWER_FORMAT_ID ELIG_QUEST_LIBRARY ANSWER_FORMAT_ID
PROT_ELIG_QUEST ANSWER_FORMAT_ID
VALID_ANSWER_CAT ANSWER_FORMAT_ID


APPL_DISEASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: The applicable diseases for the amendment
Definition: The applicable disease for the amendment
Table Type: REFERENCE





Column Detail - APPL_DISEASE


Column Name Type Null? Definition
APPL_DISEASE_DESC_OTR VARCHAR(255) Y Description of the disease
APPL_DISEASE_ID DOUBLE N This is the value of the unique primary identifier of the appl_disease table. It is an internal system assigned number.
DISEASE_SUB_TYPE_CD DOUBLE N Disease sub-type
DISEASE_TYPE_CD DOUBLE N Indicates the type of disease
PROT_AMENDMENT_ID DOUBLE N This is the value of the unique primary identifier of the prot_amendment 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 - APPL_DISEASE


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