Table Detail Report
PRODUCT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Product |
Definition: | Stores demographic information about all blood bank products, whether a blood product or derivative. The main parent table in the PathNet Blood Bank Transfusion. Only common attributes about all products are stored in this table. |
Table Type: | ACTIVITY |
Column Detail - PRODUCT
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. |
ALTERNATE_NBR | VARCHAR(20) | Y | This column can be used to record the original number labeled on the bag of blood, in the case of sites who choose to re-number blood products received from their supplier. This way they can still track the product by its original number, which is important in the for look-backs. |
BARCODE_NBR | CHAR(20) | Y | The original barcoded version of the product number, e.g., "1212345", which may have been translated into "G12345", depending on the alpha translation feature. |
BIOHAZARD_IND | DOUBLE | N | Indicates that the product is biohazardous. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
CORRECTED_IND | DOUBLE | Y | Indicates whether or not this product has been corrected in some way, such as its demographics changed, etc. |
CREATE_DT_TM | DATETIME | Y | Indicates the date and time the product row was created |
CUR_DISPENSE_DEVICE_ID | DOUBLE | N | An internal system-assigned number. The primary key of the BB_DEVICE table. An identification of the device to which the product was dispensed. An example is "SURG FRIDGE #1", for a refrigerator within the surgical area. |
CUR_EXPIRE_DT_TM | DATETIME | Y | Defines when the product itself will expire. The current expiration date and time is entered at the time the product is received from the label on the product, but may be updated if it is modified or corrected. |
CUR_INV_AREA_CD | DOUBLE | N | Identifies the code value for the current inventory area where the product resides. This inventory area is any area that keeps blood products or derivatives in an inventory, from which the products are dispensed. This means that the it could be the main blood bank, or a surgical area or emergency room that stocks blood for use in surgery. |
CUR_INV_DEVICE_ID | DOUBLE | N | Identifies the current inventory device where this product resides within inventory. An example would be "Freezer #1". This column is not currently used. |
CUR_INV_LOCN_CD | DOUBLE | N | The current location of this product as it relates to a patient's location. This column is only applicable when the product is actively dispensed or transfused to a patient. It is cleared out if the product is returned. |
CUR_OWNER_AREA_CD | DOUBLE | N | Identifies the code value for the current blood bank owner area where the product resides. This owner area is a fully-functioning blood bank that is responsible for the blood received or drawn there. A blood bank owner area can have several inventory areas within it. An example of an owner area would be "General Hospital North", with its inventory areas being "Main BB - GH North", "Surgery - GH North", and "ER - GH North". |
CUR_SUPPLIER_ID | DOUBLE | N | This column represents an organization_ID, which is the primary key to the ORGANIZATION table. It is an internal system-assigned number. It identifies the supplier of this product, the organization who sent the product to the transfusion service. |
CUR_UNIT_MEAS_CD | DOUBLE | N | The unit of measure in which this product's volume is recorded. It is entered at the time the product is received, from the label on the actual product (ex. "milliliters"). |
DISEASE_CD | DOUBLE | N | This column will store the unique identifier of the disease associated with the product. |
DONATED_BY_RELATIVE_IND | DOUBLE | Y | Obsolete. No longer used. - This column only applies to directed products received into the Blood Bank. It indicates whether or not the product was donated by a relative of the recipient or not. - This information is now on the AUTO_DIRECTED and CORRECTED_PRODUCT table. |
DONATION_TYPE_CD | DOUBLE | N | This column will store the unique identifier of the donation type associated. |
ELECTRONIC_ENTRY_FLAG | DOUBLE | N | Indicates whether the primary product demographic fields were entered via Electronic Entry, and if so what form of entry was used. 0 - Product demographics are not guaranteed to have been entered electronically; 1 - Product demographics were scanned in via barcode reader |
FLAG_CHARS | VARCHAR(2) | Y | Stores the flag characters of an ISBT-128 donation number |
INTENDED_USE_PRINT_PARM_TXT | VARCHAR(1) | N | Contains the intended use of the product. It is derived from the ISBT ABORh Barcode. Valid values are:Autologous Crossover AAutologous Only 1 (one)Autologous Only Biohazard XDirected Biohazard 3Directed Only 2Directed Crossover DNot Specified 0 (zero)For Emergency Use Only !If the Product ABORH wasn't scanned in via ISBT Barcode, intended_use_print_parm_txt will be blank. |
INTERFACED_DEVICE_FLAG | DOUBLE | N | Indicates that the product is currently being tracked using an interfaced inventory tracking system. If it is set to be in a device, but the cur_dispense_device_id is 0, it means it is in transit. |
INTERFACE_PRODUCT_ID | DOUBLE | N | The product ID for a transferred product. |
LOCKED_IND | DOUBLE | Y | Indicates whether or not the product is locked for update by a particular blood bank transaction. Inquiry transactions do not update this indicator to locked. |
MODIFIED_PRODUCT_ID | DOUBLE | N | This column represents the PRODUCT_ID of the original product from which this product was created through the product modification application. The product_id is the primary key of the PRODUCT table. It is an internal system-assigned number that uniquely identifies a product in the blood bank. |
MODIFIED_PRODUCT_IND | DOUBLE | Y | Indicates whether the product has been modified after it was received into the blood bank's inventory. This indicator is only updated on the "parent" product, not the new "child" products created from the original parent product. |
ORIG_INV_LOCN_CD | DOUBLE | N | The original location of this product in the blood bank's inventory at the time it was received. |
ORIG_SHIP_COND_CD | DOUBLE | N | The original condition in which the product was shipped to the transfusion service (ex. "Dry Ice"). |
ORIG_UNIT_MEAS_CD | DOUBLE | N | The unit of measure in which this product's volume was originally recorded. It is entered at the time the product is received, from the label on the actual product (ex. "milliliters"). |
ORIG_VIS_INSP_CD | DOUBLE | N | The outcome of the visual inspection when this product was received (ex. "OK", "Bag leaking", etc.). This visual inspection may cause the product to need to be quarantined. |
POOLED_PRODUCT_ID | DOUBLE | N | This column represents the PRODUCT_ID of the new pooled product into which this product was pooled through the pooling application. The product_id is the primary key of the PRODUCT table. It is an internal system-assigned number that uniquely identifies a product in the blood bank. |
POOLED_PRODUCT_IND | DOUBLE | Y | Indicates whether the product is a pooled product, i.e.., a product that was created through the pooling process. This indicator is only updated on the newly created product, not the products that were components within the pool. |
POOL_OPTION_ID | DOUBLE | N | If this product was created by the pooling process, it identifies the pool option chosen by the user in the pooling transaction. |
PRODUCT_CAT_CD | DOUBLE | N | The category of products to which this specific type of product belongs. An example of a product category is "Plasma", which might include a product type of "Fresh Frozen Plasma", "Thawed Plasma", and "Salvaged Plasma". |
PRODUCT_CD | DOUBLE | N | The type of product (ex. "Fresh Frozen Plasma") derived from the label on the bag of blood. |
PRODUCT_CLASS_CD | DOUBLE | N | The class of products to which this specific type of product belongs. Two classes of products may be used: blood products and derivatives. |
PRODUCT_ID | DOUBLE | N | The primary key to this table. An internal system-assigned number that keeps each row unique. |
PRODUCT_NBR | VARCHAR(20) | N | The number assigned to this product to identify it. Also known as "unit number". It is entered at the time the product is received into the blood bank's inventory, from the label on the actual bag of blood. In the case of derivative products, it is the lot number from the batch of derivatives. |
PRODUCT_SUB_NBR | CHAR(5) | Y | A letter or number assigned to each product with the same product number, in order to make them unique. An example is splitting red blood cells into smaller bags of red cells. The sub number is assigned as "1", "2", "3", etc. or as "A", "B", "C", etc. |
PRODUCT_TYPE_BARCODE | VARCHAR(22) | Y | This is the barcode value that was etiered in BB Recieve Products or corrected in Correct Inventory. |
RECV_DT_TM | DATETIME | Y | The date and time the product was received into the blood bank's inventory from a supplier. This column is empty on products created from the pooling or modification process since they are not received but rather created by the blood bank. |
RECV_PRSNL_ID | DOUBLE | N | This column represents the person_id of the person from the personnel table (prsnl) that received this product into the blood bank's inventory. |
REQ_LABEL_VERIFY_IND | DOUBLE | N | Product requires label verify because a lebel was printed or mod opt was defined to print a label. |
SERIAL_NUMBER_TXT | VARCHAR(22) | Y | Contains GS1 serial number for derivative products when applicable |
STORAGE_TEMP_CD | DOUBLE | N | The temperature at which the product should be stored. |
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 - PRODUCT
Child Column in PRODUCT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CUR_SUPPLIER_ID | ORGANIZATION | ORGANIZATION_ID |
INTERFACE_PRODUCT_ID | PRODUCT | PRODUCT_ID | |
MODIFIED_PRODUCT_ID | PRODUCT | PRODUCT_ID | |
POOLED_PRODUCT_ID | PRODUCT | PRODUCT_ID |
Parent Column in PRODUCT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PRODUCT_ID | ASSIGN | PRODUCT_ID |
ASSIGN_RELEASE | PRODUCT_ID | ||
AUTO_DIRECTED | PRODUCT_ID | ||
BB_AUTODIR_EXCEPTION | PRODUCT_ID | ||
BB_DEVICE_TRANSFER | PRODUCT_ID | ||
BB_EDN_DSCRPNCY_OVRD | PRODUCT_ID | ||
BB_EXC_CXM_PRODUCT | PRODUCT_ID | ||
BB_LABEL_VERIFY | PRODUCT_ID | ||
BB_ORDER_CELL | PRODUCT_ID | ||
BB_SHIP_EVENT | PRODUCT_ID | ||
BB_SPEC_EXP_OVRD_PROD | PRODUCT_ID | ||
BLOOD_PRODUCT | PRODUCT_ID | ||
CE_PRODUCT | PRODUCT_ID | ||
CORRECTED_PRODUCT | POOLED_PRODUCT_ID | ||
CORRECTED_PRODUCT | PRODUCT_ID | ||
CROSSMATCH | PRODUCT_ID | ||
DERIVATIVE | PRODUCT_ID | ||
DESTRUCTION | PRODUCT_ID | ||
DISPENSE_RETURN | PRODUCT_ID | ||
DISPOSITION | PRODUCT_ID | ||
MODIFICATION | PRODUCT_ID | ||
MODIFY_DEVICE | PRODUCT_ID | ||
ORDERS | PRODUCT_ID | ||
PATIENT_DISPENSE | PRODUCT_ID | ||
PRODUCT | INTERFACE_PRODUCT_ID | ||
PRODUCT | MODIFIED_PRODUCT_ID | ||
PRODUCT | POOLED_PRODUCT_ID | ||
PRODUCT_EVENT | PRODUCT_ID | ||
PRODUCT_NOTE | PRODUCT_ID | ||
PRODUCT_RH_PHENOTYPE | PRODUCT_ID | ||
QUARANTINE | PRODUCT_ID | ||
QUARANTINE_RELEASE | PRODUCT_ID | ||
RECEIPT | PRODUCT_ID | ||
SPECIAL_TESTING | PRODUCT_ID | ||
SPECIAL_TESTING_RESULT | PRODUCT_ID | ||
TRANSFER | PRODUCT_ID | ||
TRANSFUSION | PRODUCT_ID |
PRODUCT_ABORH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Product Aborh |
Definition: | A user-defined reference table that defines the combinations of product and aborhs to be used in patient/product compatibility checking throughout the PathNet Blood Bank Transfusion system. |
Table Type: | REFERENCE |
Column Detail - PRODUCT_ABORH
Column Name | Type | Null? | Definition |
---|---|---|---|
ABORH_OPTION_FLAG | DOUBLE | Y | When associating this product type and ABORh with a patient, this flag defines whether the patient's entire ABORh should be validated, or just the patient's Rh type. |
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. |
BBD_NO_GT_DIR_PRSN_FLAG | DOUBLE | N | OBSOLETE ** NO LONGER BEING USED ** Defines whether or not to allow a product of this type and ABORh to be associated to a person with no ABORh, within the "ReceiveProducts" application, when entering the recipient information in the Autologous/Directed window. |
DISP_NO_CURRABORH_PRSN_FLAG | DOUBLE | N | Defines whether or not to allow a product of this type and ABORh to be dispensed to a person with no current ABO. |
NO_GT_AUTODIR_PRSN_FLAG | DOUBLE | Y | Defines whether or not to allow a product of this type and ABORh to be associated to a person with no ABORh, within the "ReceiveProducts" application, when entering the recipient information in the Autologous/Directed window. |
NO_GT_ON_PRSN_FLAG | DOUBLE | Y | Defines whether or not to allow a product of this type and ABORh to be assigned, crossmatched, or dispensed. to a person with no ABORh. |
PRODUCT_ABORH_CD | DOUBLE | N | The product's ABORh that is being defined with a certain product type for patient ABORh compatibility (ex. "O Neg"). |
PRODUCT_CD | DOUBLE | N | The type of product defined for patient compatibility (ex. "Red Blood Cells"). |
SEQUENCE_NBR | DOUBLE | N | An internal number which, when combined with the product type and product's ABORh. is used to make each row unique. It begins at 1 and is incremented by 1. It is needed because the user may choose to inactivate a product and ABORh combination, and later add it again as active. |
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 - PRODUCT_ABORH
Child Column in PRODUCT_ABORH(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRODUCT_CD | PRODUCT_INDEX | PRODUCT_CD |
PRODUCT_NOTE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Product Note |
Definition: | Contains all notes (comments, freetext) entered on products. |
Table Type: | ACTIVITY |
Column Detail - PRODUCT_NOTE
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. |
BBHIST_PRODUCT_ID | DOUBLE | N | The primary key to the BBHIST_PRODUCT table (Product_ID). An internal system-assigned number. On this table, it identifies the product_id from the BBHIST_PRODUCT table for which the comment is associated with. |
LONG_TEXT_ID | DOUBLE | N | The primary key to the LONG_TEXT table. An internal system-assigned number. On this table, it identifies the text entered for this product. |
PRODUCT_ID | DOUBLE | N | The primary key to the PRODUCT table. An internal system-assigned number. On this table, it identifies the product for which comments were entered. |
PRODUCT_NOTE_ID | DOUBLE | N | The primary key to this table. An internal system-assigned number that makes each row unique. |
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 - PRODUCT_NOTE
Child Column in PRODUCT_NOTE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BBHIST_PRODUCT_ID | BBHIST_PRODUCT | PRODUCT_ID |
PRODUCT_ID | PRODUCT | PRODUCT_ID |
PRODUCT_RH_PHENOTYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Product Rh Phenotype |
Definition: | This table contains the Rh phenotype tested on the product. |
Table Type: | ACTIVITY |
Column Detail - PRODUCT_RH_PHENOTYPE
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 | N | 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. |
NOMENCLATURE_ID | DOUBLE | N | Links this row for this product's Rh phenotype to the actual nomenclature (alpha response) entered, e.g., "CDE/CDE". |
PRODUCT_ID | DOUBLE | N | Links this row to the actual product for which this Rh phenotype is being stored. It is the primary key to the Product table. |
PRODUCT_RH_PHENOTYPE_ID | DOUBLE | N | The primary key to this table. An internal system-assigned number that ensures the uniqueness of each row. |
RH_PHENOTYPE_ID | DOUBLE | N | Links this row to the reference table on which Rh phenotypes are defined by the user. An example is "CDE/CDE". This column is the primary key to the bb_Rh_phenotype table. |
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 - PRODUCT_RH_PHENOTYPE
Child Column in PRODUCT_RH_PHENOTYPE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RH_PHENOTYPE_ID | BB_RH_PHENOTYPE | RH_PHENOTYPE_ID |
PRODUCT_ID | PRODUCT | PRODUCT_ID |
Parent Column in PRODUCT_RH_PHENOTYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PRODUCT_RH_PHENOTYPE_ID | SPECIAL_TESTING | PRODUCT_RH_PHENOTYPE_ID |
SPECIAL_TESTING
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Special Testing |
Definition: | Contains all special testing done on a product, whether from the base label on the bag, or from resulting procedures on the product. This includes antigen typings as well as any other special testing, e.g., CMV negative, etc. |
Table Type: | ACTIVITY |
Column Detail - SPECIAL_TESTING
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. |
BARCODE_VALUE_TXT | VARCHAR(20) | N | Contains the ISBT barcode associated with the special testing attribute. |
CONFIRMED_IND | DOUBLE | Y | Indicates whether or not this antigen or attribute of the product has is considered confirmed or not. ***NOT USED AT THIS TIME |
MODIFIABLE_FLAG | DOUBLE | N | Indicates if the user can remove the special testing from the product. 0 = Special Testing was added manually and can be modified by the user. 1 = Special Testing was added via barcode scan, and can NOT be modified by the user. |
PRODUCT_ID | DOUBLE | N | The primary key to the PRODUCT table. An internal system-assigned number. On this table, it identifies the product for which special testing (antigens or attributes) has been recorded. |
PRODUCT_RH_PHENOTYPE_ID | DOUBLE | N | Links the antigen on this row to the Rh phenotype to which it belongs. Links this row to a row on the Product_rh_phenotype table. An example is C+ on this row originating from the Rh phenotype of "CDE/cde". |
SPECIAL_TESTING_CD | DOUBLE | N | Defines the special testing item (antigen or attribute) that was recorded on the product, whether it was done at the time the product was received into the blood bank's inventory, or at the time the results were verified for the testing. |
SPECIAL_TESTING_ID | DOUBLE | N | The primary key of this table. An internal system-assigned number to ensure the uniqueness of each row. |
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 - SPECIAL_TESTING
Child Column in SPECIAL_TESTING(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRODUCT_ID | PRODUCT | PRODUCT_ID |
PRODUCT_RH_PHENOTYPE_ID | PRODUCT_RH_PHENOTYPE | PRODUCT_RH_PHENOTYPE_ID |
Parent Column in SPECIAL_TESTING (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SPECIAL_TESTING_ID | CORRECTED_SPECIAL_TESTS | ORIG_SPECIAL_TESTING_ID |
SPECIAL_TESTING_RESULT | SPECIAL_TESTING_ID |