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 |