BB_PTC_TEMP_PERSON



Column Section Top of Page


Table-level Detail

Description: Blood Bank Patient Typing and Comments Temporary Person
Definition: Stores Person_id and action type(Hide/Delete/Unhide) of persons chosen to have their data hidden, deleted or unhidden
Table Type: ACTIVITY





Column Detail - BB_PTC_TEMP_PERSON


Column Name Type Null? Definition
BB_PTC_TEMP_PERSON_ID DOUBLE N Unique generated number that identifies a single row on the BB_PTC_TEMP_PERSON table.
EXPORT_IND DOUBLE N Indicates whether the export action has occured or not.
PERSON_ID DOUBLE N Uniquely identifies the related Person.
PROCESS_TYPE_FLAG DOUBLE N Type of action selected(Hide/Delete/UnHide)
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.


BB_RH_PHENOTYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: BLOOD BANK RH PHENOTYPE
Definition: A reference table of the Rh Phenotype for Blood Bank results.
Table Type: REFERENCE





Column Detail - BB_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.
FR_NOMENCLATURE_ID DOUBLE N An ID that represents the Fisher-Race nomenclature for a particular Rh phenotype, ex. "CDE/CDE", "cde/cde".
RH_PHENOTYPE_ID DOUBLE N An internal system-assigned number that ensures 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.
W_NOMENCLATURE_ID DOUBLE N An ID that represents the Weiner nomenclature for a particular Rh phenotype, ex. "R1/R1", "r1/r1".



Relationship Detail - BB_RH_PHENOTYPE


Child Column in BB_RH_PHENOTYPE(FK) Parent Table Name Parent Column Name
Parents: FR_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
W_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID




Parent Column in BB_RH_PHENOTYPE (PK) Child Table Name Child Column Name
Children: RH_PHENOTYPE_ID BB_RH_PHENO_TESTING RH_PHENOTYPE_ID
PERSON_RH_PHENOTYPE RH_PHENOTYPE_ID
PRODUCT_RH_PHENOTYPE RH_PHENOTYPE_ID


BB_RH_PHENO_TESTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Rh Phenotype Testing
Definition: A reference table that is a child table to the bb_rh_phenotype table. For every Rh Phenotype defined, it identifies the actual antigens represented by the Rh phenotype
Table Type: REFERENCE





Column Detail - BB_RH_PHENO_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 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.
RH_PHENOTYPE_ID DOUBLE N This column links the rows on this table to a row on the bb_rh_phenotype table, the parent table. For every row on the bb_rh_phenotype table, there will be many rows on this table for that rh_phenotype_id.
RH_PHENO_TESTING_ID DOUBLE N An internal system-assigned number that ensures the uniqueness of each row on this table.
SEQUENCE DOUBLE N An internal number used to sequence the antigens properly in the Special Testing Tool.
SPECIAL_TESTING_CD DOUBLE N This code value represents the antigen into which the Rh phenotype translates, e.g., "C+", or "e-".
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_RH_PHENO_TESTING


Child Column in BB_RH_PHENO_TESTING(FK) Parent Table Name Parent Column Name
Parents: RH_PHENOTYPE_ID BB_RH_PHENOTYPE RH_PHENOTYPE_ID


BLOOD_BANK_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Comments
Definition: All blood bank specific comments on a person.
Table Type: ACTIVITY





Column Detail - BLOOD_BANK_COMMENT


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.
BB_COMMENT_ID DOUBLE N The primary key to this table. An internal system-assigned number that makes each row unique.
COMMENT_ADDED_PRSNL_ID DOUBLE Y Uniquely identifies the personnel who added the comment.
COMMENT_DT_TM DATETIME Y Indicates date and time the comment was written.;
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.
LONG_TEXT_ID DOUBLE N The primary key to the LONG_TEXT table. An internal system-assigned number. On this table, it corresponds to the text contained in the blood bank comments entered.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - BLOOD_BANK_COMMENT


Child Column in BLOOD_BANK_COMMENT(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID
COMMENT_ADDED_PRSNL_ID PRSNL PERSON_ID


EXT_DATA_CODING



Column Section Top of Page


Table-level Detail

Description: External Data Coding
Definition: Contains codified values from an external source (e.g. FHIR) and associates the value to a piece of externally staged data.
Table Type: ACTIVITY





Column Detail - EXT_DATA_CODING


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.
CODE_TEXT VARCHAR(40) N The codified value.
CODING_SYSTEM_URI VARCHAR(255) N The URI of the coding system.
EXT_DATA_CODING_ID DOUBLE N Unique generated number that identifies a single row on the EXT_DATA_CODING table
PARENT_ENTITY_ID DOUBLE N The primary key of the external data associated with this codified value.
PARENT_ENTITY_NAME VARCHAR(30) N The name of the table associated with this codified value.
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.
VERSION_TEXT VARCHAR(10) N The version of the coding system.