ACCEPT_QUAR_PROD_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Accept Quarantine Products Reference Table
Definition: Indicates which product types can be shipped for a specific quarantine.
Table Type: REFERENCE





Column Detail - ACCEPT_QUAR_PROD_R


Column Name Type Null? Definition
ACCEPT_QUAR_PROD_ID DOUBLE N Unique identifier for the ACCEPT_QUAR_PROD_R table.
ACCEPT_QUAR_REASON_ID DOUBLE N Unique identifier for the ACCEPT_QUAR_REASON table.
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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
PRODUCT_CD DOUBLE N Indicates the product type which can be sent with a quarantine.
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 - ACCEPT_QUAR_PROD_R


Child Column in ACCEPT_QUAR_PROD_R(FK) Parent Table Name Parent Column Name
Parents: ACCEPT_QUAR_REASON_ID ACCEPT_QUAR_REASON ACCEPT_QUAR_REASON_ID
PRODUCT_CD CODE_VALUE CODE_VALUE


ACCEPT_QUAR_REASON



Column Section Relationship Section Top of Page


Table-level Detail

Description: Accept Quarantine Reason
Definition: Contains a list of acceptable quarantined products for an organization.
Table Type: REFERENCE





Column Detail - ACCEPT_QUAR_REASON


Column Name Type Null? Definition
ACCEPT_QUAR_REASON_ID DOUBLE N Unique identifier for the ACCEPT_QUAR_REASON table.
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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ORG_SHIPMENT_ID DOUBLE N Unique identifier for the ORG_SHIPMENT table. Associates the acceptable quarantined products with an organization.
QUAR_REASON_CD DOUBLE N Contains the quarantine reason code value.
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 - ACCEPT_QUAR_REASON


Child Column in ACCEPT_QUAR_REASON(FK) Parent Table Name Parent Column Name
Parents: QUAR_REASON_CD CODE_VALUE CODE_VALUE
ORG_SHIPMENT_ID ORG_SHIPMENT ORG_SHIPMENT_ID




Parent Column in ACCEPT_QUAR_REASON (PK) Child Table Name Child Column Name
Children: ACCEPT_QUAR_REASON_ID ACCEPT_QUAR_PROD_R ACCEPT_QUAR_REASON_ID


BB_SHIPMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Shipment Table
Definition: Contains the attributes of a shipment, including: shipment number, organization, order date, sent date, needed date, status, courier, and order placed by.
Table Type: ACTIVITY





Column Detail - BB_SHIPMENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
COURIER_CD DOUBLE N Indicates the courier by which a shipment was sent.
FROM_FACILITY_CD DOUBLE N Identifies from which facility products were shipped.
INVENTORY_AREA_CD DOUBLE N Inventory area to which the shipment is being sent.
LONG_TEXT_ID DOUBLE N Contains notes of type BBSHIPPING pertaining to the shipment.
NEEDED_DT_TM DATETIME Y The date and time the shipment is needed at the receiving organization.
ORDER_DT_TM DATETIME Y The date and time the shipment was ordered by an organization.
ORDER_PLACED_BY VARCHAR(100) Y The person who placed the shipment order.
ORDER_PRIORITY_CD DOUBLE N Indicates the order priority of the shipment.
ORGANIZATION_ID DOUBLE N Unique identifier from the ORGANIZATION table. Indicates the organization to which the shipment is being sent.
OWNER_AREA_CD DOUBLE N Owner area to which the shipment is being sent.
RECORDED_BY_PRSNL_ID DOUBLE N The person who created the new shipment.
SHIPMENT_DT_TM DATETIME Y The date and time the shipment was sent.
SHIPMENT_ID DOUBLE N Unique identifier for the BB_SHIPMENT table.
SHIPMENT_NBR DOUBLE N A uniquely assigned number given to the shipment. This is created by the BB_SHIPMENT_SEQ.
SHIPMENT_STATUS_FLAG DOUBLE N Indicates the status of the shipment: Ordered, In Progress, Shipped, or Canceled 0 - Shipment has been ordered; 1 - The shpment is in progress; 2 - The shipment has been shipped or transferred; 3 - The shipment has been cancelled.
UPDT_APPLCTX DOUBLE N 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 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. 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 N 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 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. 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 N 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_SHIPMENT


Child Column in BB_SHIPMENT(FK) Parent Table Name Parent Column Name
Parents: COURIER_CD CODE_VALUE CODE_VALUE
INVENTORY_AREA_CD LOCATION LOCATION_CD
OWNER_AREA_CD LOCATION LOCATION_CD
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in BB_SHIPMENT (PK) Child Table Name Child Column Name
Children: SHIPMENT_ID BB_SHIP_CONTAINER SHIPMENT_ID
BB_SHIP_EVENT SHIPMENT_ID


BB_SHIP_CONTAINER



Column Section Relationship Section Top of Page


Table-level Detail

Description: BB Ship Container Table
Definition: This table holds all containers and it's attributes associated with shipments from the BB_SHIPMENT table.
Table Type: ACTIVITY





Column Detail - BB_SHIP_CONTAINER


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CONTAINER_CONDITION_CD DOUBLE N Contains the condition of the container (i.e. wet ice or room temperature).
CONTAINER_ID DOUBLE N Unique identifier for the BB_SHIP_CONTAINER table
CONTAINER_NBR DOUBLE N Sequential number given to each container in a specific shipment.
CONTAINER_TYPE_CD DOUBLE N Contains the type of container used (i.e. box or cooler).
SHIPMENT_ID DOUBLE N Unique identifier from the BB_SHIPMENT table. Indicates which shipment the container is part of.
TEMPERATURE_DEGREE_CD DOUBLE N Indicates the shipment temperature degree unit of measure associated with the container.
TEMPERATURE_VALUE DOUBLE N Indicates the shipment temperature of the container.
TOTAL_WEIGHT DOUBLE N The total weight of the shipment.
UNIT_OF_MEAS_CD DOUBLE N The unit of measure the total weight is given in.
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 - BB_SHIP_CONTAINER


Child Column in BB_SHIP_CONTAINER(FK) Parent Table Name Parent Column Name
Parents: SHIPMENT_ID BB_SHIPMENT SHIPMENT_ID
CONTAINER_CONDITION_CD CODE_VALUE CODE_VALUE
CONTAINER_TYPE_CD CODE_VALUE CODE_VALUE
UNIT_OF_MEAS_CD CODE_VALUE CODE_VALUE




Parent Column in BB_SHIP_CONTAINER (PK) Child Table Name Child Column Name
Children: CONTAINER_ID BB_SHIP_EVENT CONTAINER_ID


BB_SHIP_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: BB Ship Event
Definition: Contains product information for the BB Ship and Transfer application
Table Type: ACTIVITY





Column Detail - BB_SHIP_EVENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CONTAINER_ID DOUBLE N Unique identifier from BB_SHIP_CONTAINER table. Defines the container to which the product belongs.
FROM_INVENTORY_AREA_CD DOUBLE N Indicates the inventory area from which the product is being transferred.
FROM_OWNER_AREA_CD DOUBLE N Indicates the owner area from which the product is being transferred.
PRODUCT_EVENT_ID DOUBLE N Unique identifier from the PRODUCT_EVENT table for the "SHIPPED" product event.
PRODUCT_ID DOUBLE N Unique product ID from the PRODUCT table for the product being transferred.
RETURN_CONDITION_CD DOUBLE N Indicates the condition of the product at the time the product is returned to inventory.
RETURN_DT_TM DATETIME Y Date and time at which the product is returned from a shipment to inventory.
RETURN_VIS_INSP_CD DOUBLE N Visual inspection of the product when it is returned to inventory from a shipment.
SHIPMENT_ID DOUBLE N Unique identifier from BB_SHIPMENT table. Defines the shipment to which the product belongs.
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.
VIS_INSP_CD DOUBLE N Visual inspection of the product when it has been added to a shipment container



Relationship Detail - BB_SHIP_EVENT


Child Column in BB_SHIP_EVENT(FK) Parent Table Name Parent Column Name
Parents: SHIPMENT_ID BB_SHIPMENT SHIPMENT_ID
CONTAINER_ID BB_SHIP_CONTAINER CONTAINER_ID
RETURN_CONDITION_CD CODE_VALUE CODE_VALUE
RETURN_VIS_INSP_CD CODE_VALUE CODE_VALUE
PRODUCT_ID PRODUCT PRODUCT_ID
PRODUCT_EVENT_ID PRODUCT_EVENT PRODUCT_EVENT_ID