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