Table Detail Report
BB_TAG_VERIFY_EXCPN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Blood Bank Tag Verify Exception |
Definition: | Contains a row for each product with failed tag verification that is dispensed to patient(by overriding the exception). |
Table Type: | ACTIVITY |
Column Detail - BB_TAG_VERIFY_EXCPN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BB_TAG_VERIFY_EXCPN_ID | DOUBLE | N | A system generated number to uniquely identify a row on the BB_TAG_VERIFY_EXCPN table. |
EXCEPTION_ID | DOUBLE | Y | Uniquely identifies the related row on the BB_EXCEPTION table. |
TAG_PRODUCT_NBR_TXT | VARCHAR(20) | Y | Product number scanned from tag. |
TAG_PRODUCT_SUB_NBR_TXT | VARCHAR(2) | Y | Stores the sub number of product scanned from tag |
TAG_PRODUCT_TYPE_CD | DOUBLE | Y | Product type scanned from tag |
UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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 - BB_TAG_VERIFY_EXCPN
Child Column in BB_TAG_VERIFY_EXCPN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EXCEPTION_ID | BB_EXCEPTION | EXCEPTION_ID |
DEPENDENCY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Dependency |
Definition: | A Cerner-defined table of the dependencies certain preference questions have to other preference questions, for the database preference wizard. |
Table Type: | REFERENCE |
Column Detail - DEPENDENCY
Column Name | Type | Null? | Definition |
---|---|---|---|
DEPEND_QUEST_CD | DOUBLE | N | The question which is dependent on the answer (response) the user gives to the question defined in the QUESTION_CD column, i.e., this question should only appear in the DBPreference Wizard database tool if the answer to the other is the as the response defined in this row. |
MODULE_CD | DOUBLE | N | The module to which the question pertains (ex. "PathNet Blood Bank Transfusion", "Pharmacy"). |
PROCESS_CD | DOUBLE | N | The process within the module to which the question pertains (ex. the "Dispense" process within the PathNet Blood Bank Transfusion module). |
QUESTION_CD | DOUBLE | N | The question which determines whether other (dependent) question(s) should be asked of the user, depending on the answer to this question. |
RESPONSE_CD | DOUBLE | N | The response that determines whether or not the dependent question(s) should be asked of the user. |
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 - DEPENDENCY
Child Column in DEPENDENCY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | QUESTION_CD | VALID_RESPONSE | QUESTION_CD |
RESPONSE_CD | VALID_RESPONSE | RESPONSE_CD |
QUESTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Question |
Definition: | A reference table of the questions to be asked of the user in the Preference wizard. The questions vary by HNA module. |
Table Type: | REFERENCE |
Column Detail - QUESTION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
CDF_MEANING | CHAR(12) | Y | For a question whose responses are to come from a Code Set, this field (CDF_MEANING) indicates that the valid values from the Code Set are to come from a subset with a CDF_Meaning on the Code_Value table with a value equal to the value in this field. |
CODE_SET | DOUBLE | Y | The number of the code set where the question is defined. |
DEF_ANSWER | VARCHAR(200) | Y | The Cerner-defined default answer defined for this question (ex. "Yes", "No", etc.) |
DWB_IND | DOUBLE | Y | Not currently used. |
MODULE_CD | DOUBLE | N | The module to which the question pertains (ex. "PathNet Blood Bank Transfusion", "Pharmacy"). |
PROCESS_CD | DOUBLE | N | The process within the module to which the question pertains (ex. the "Dispense" process within the PathNet Blood Bank Transfusion module). |
QUESTION | VARCHAR(200) | Y | The Cerner-defined text of the question that should be asked of the user. |
QUESTION_CD | DOUBLE | N | The code value of the question, from code set 1661. |
RESPONSE_FLAG | DOUBLE | Y | The type of response to this question. |
RESPONSE_LENGTH | DOUBLE | Y | The Cerner-defined maximum length of the answer. |
SEQUENCE | DOUBLE | Y | The Cerner-defined sequence in which the questions should display within a process. |
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 - QUESTION
Parent Column in QUESTION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | QUESTION_CD | ANSWER | QUESTION_CD |
VALID_RESPONSE | QUESTION_CD |
QUESTION_DEPENDENCY
Column Section | Top of Page |
Table-level Detail
Description: | Question Dependency |
Definition: | A Cerner-defined reference table of questions that are dependent on other questions based on the answer to a particular question, e.g., if one question is answered Yes, prompt for other questions. Used in the DB Preference Wizard database building tool. |
Table Type: | REFERENCE |
Column Detail - QUESTION_DEPENDENCY
Column Name | Type | Null? | Definition |
---|---|---|---|
QUESTION_CD | DOUBLE | N | The question that has a dependency to another question. |
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. |
V500_SPECIMEN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | V500 specimen |
Definition: | Every specimen tracked by the PathNet Specimen Collections module will be represented by a row in this table. |
Table Type: | ACTIVITY |
Column Detail - V500_SPECIMEN
Column Name | Type | Null? | Definition |
---|---|---|---|
ADDITIONAL_SPECIMEN_ID | DOUBLE | N | not currently used |
BODY_SITE_CD | DOUBLE | N | Code value identifying the default body site from which this specimen was drawn. |
COLLECTION_METHOD_CD | DOUBLE | N | Code value identifying the collection method used to collect this specimen. |
COLLECTION_MODE | DOUBLE | Y | not currently used |
CREATION_DT_TM | DATETIME | N | Date and time this specimen was created. |
CREATION_PRSNL_ID | DOUBLE | N | Identifier of the person who created this entry. |
DRAWN_DT_TM | DATETIME | Y | The Date and Time this specimen was collected. |
DRAWN_ID | DOUBLE | N | The person id of the individual who collected this specimen. |
EVENT_ID | DOUBLE | N | not currently being used |
LONG_TEXT_ID | DOUBLE | N | The id of the textual specimen source description in the long text table. |
PREV_SPECIMEN_ID | DOUBLE | N | Used for tracking when specimens are manipulated in SpecimenLogin. |
QNS_IND | DOUBLE | Y | not currently being used |
REJECTION_IND | DOUBLE | Y | not currently being used |
REJECTION_REASON_CD | DOUBLE | N | not currently being used |
SPECIMEN_COLLECT_PRIORITY_CD | DOUBLE | N | Not currently being populated. |
SPECIMEN_COLLECT_VOL | DOUBLE | Y | Not currently being used. |
SPECIMEN_COMMENT | VARCHAR(200) | Y | Not currently being used. |
SPECIMEN_DANGER_CD | DOUBLE | N | Not currently being used. |
SPECIMEN_ID | DOUBLE | N | The system generated number that uniquely identifies each specimen. |
SPECIMEN_SRC_CD | DOUBLE | N | not currently being used |
SPECIMEN_SRC_TEXT | VARCHAR(40) | Y | Free text specimen source comment. |
SPECIMEN_STATUS_CD | DOUBLE | N | not currently being used |
SPECIMEN_TYPE_CD | DOUBLE | N | System generated number that uniquely identifies specimen type of the specimen. |
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 - V500_SPECIMEN
Child Column in V500_SPECIMEN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CREATION_PRSNL_ID | PRSNL | PERSON_ID |
DRAWN_ID | PRSNL | PERSON_ID |
Parent Column in V500_SPECIMEN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SPECIMEN_ID | BB_SPEC_EXPIRE_OVRD | SPECIMEN_ID |
CE_SPECIMEN_COLL | SPECIMEN_ID | ||
CONTAINER | SPECIMEN_ID | ||
CONTAINER_EVENT | SPECIMEN_ID | ||
PERSON_ABORH_RESULT | SPECIMEN_ID | ||
SPECIMEN_USAGE | PARENT_SPECIMEN_ID | ||
SPECIMEN_USAGE | SPECIMEN_ID |