Table Detail Report

CONTAINER_CONDITION_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Container Condition Reference Table
Definition: Contains container types and their condition relationships for the BB Shipping & Transfer application.
Table Type: REFERENCE





Column Detail - CONTAINER_CONDITION_R


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.
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.
CNTNR_TEMPERATURE_DEGREE_CD DOUBLE N Indicates the default shipment temperature degree unit of measure associated with the container.
CNTNR_TEMPERATURE_VALUE DOUBLE N Indicates the default shipment temperature of the container.
CONDITION_CD DOUBLE N Container CD
CONTAINER_CONDITION_ID DOUBLE N Container Condition ID
CONTAINER_TYPE_CD DOUBLE N Container Type CD
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 - CONTAINER_CONDITION_R


Child Column in CONTAINER_CONDITION_R(FK) Parent Table Name Parent Column Name
Parents: CONDITION_CD CODE_VALUE CODE_VALUE
CONTAINER_TYPE_CD CODE_VALUE CODE_VALUE




Parent Column in CONTAINER_CONDITION_R (PK) Child Table Name Child Column Name
Children: CONTAINER_CONDITION_ID CONTNR_TYPE_PROD_R CONTAINER_CONDITION_ID


CONTAINER_ORG_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Container Organization Reference
Definition: Holds the organization and it's related containers for the BB Shipping & Transfer application.
Table Type: REFERENCE





Column Detail - CONTAINER_ORG_R


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.
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_ORG_ID DOUBLE N Unique identifier for the CONTAINER_ORG_R table.
CONTAINER_TYPE_CD DOUBLE N Type of container to which blood bank products can be added.
INVENTORY_AREA_CD DOUBLE N In addition to organizations, containers can be associated with inventory areas
ORGANIZATION_ID DOUBLE N Unique identifier from the ORGANIZATION table.
OWNER_AREA_CD DOUBLE N In addition to organizations, containers can be associated with owner areas
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 - CONTAINER_ORG_R


Child Column in CONTAINER_ORG_R(FK) Parent Table Name Parent Column Name
Parents: CONTAINER_TYPE_CD CODE_VALUE CODE_VALUE
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


CONTNR_TYPE_PROD_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table shows a product's relationship to a container type.
Definition: Container Type Product Reference Table
Table Type: REFERENCE





Column Detail - CONTNR_TYPE_PROD_R


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.
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_ID DOUBLE N Unique identifier for the CONTAINER_CONDITION_R table. Defines the container type and condition related to the product.
CONTNR_TYPE_PROD_ID DOUBLE N Container Type Product ID
PRODUCT_CD DOUBLE N Indicates the product type related to the specific container type.
QUANTITY DOUBLE N Indicates the maximum number of product types allowed in the specific container type.
UNIT_OF_MEAS_CD DOUBLE N Indicates the unit of measure the volume is measured 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.
VOLUME DOUBLE N Indicates the maximum volume of products allowed in the specified container type.



Relationship Detail - CONTNR_TYPE_PROD_R


Child Column in CONTNR_TYPE_PROD_R(FK) Parent Table Name Parent Column Name
Parents: PRODUCT_CD CODE_VALUE CODE_VALUE
UNIT_OF_MEAS_CD CODE_VALUE CODE_VALUE
CONTAINER_CONDITION_ID CONTAINER_CONDITION_R CONTAINER_CONDITION_ID


ORG_SHIPMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Organization Shipment Table
Definition: Contains organization preferences for the BB Shipping & Transfer application
Table Type: REFERENCE





Column Detail - ORG_SHIPMENT


Column Name Type Null? Definition
ACCEPT_EXPIRED_PROD_IND DOUBLE N Indicates whether or not an organization will allow receiving expired products which are shipped.
ACCEPT_POS_RESULT_IND DOUBLE N Indicates whether or not an organization will allow receiving products with positive results which are shipped.
ACCEPT_QUARANTINED_PROD_IND DOUBLE N Indicates whether or not an organization will allow receiving quarantined products which are shipped.
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.
DESTROY_ONCE_EXPIRED_IND DOUBLE N Indicates whether or not the shipping organization will destroy a product once it has been shipped and is expired.
INVENTORY_AREA_CD DOUBLE N Indicates the inventory area to which the preferenced belong.
ORGANIZATION_ID DOUBLE N Indicates the organization to which the preferenced belong.
ORG_SHIPMENT_ID DOUBLE N The unique identifier for the ORG_SHIPMENT table.
OWNER_AREA_CD DOUBLE N Indicates the owner area to which the preferenced belong.
REQ_TESTING_COMPLETE_IND DOUBLE N Indicates whether or not an organization will allow receiving products whose testing is not complete.
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 - ORG_SHIPMENT


Child Column in ORG_SHIPMENT(FK) Parent Table Name Parent Column Name
Parents: INVENTORY_AREA_CD CODE_VALUE CODE_VALUE
OWNER_AREA_CD CODE_VALUE CODE_VALUE
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in ORG_SHIPMENT (PK) Child Table Name Child Column Name
Children: ORG_SHIPMENT_ID ACCEPT_QUAR_REASON ORG_SHIPMENT_ID