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 |