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. |