Table Detail Report

HLA_SERA_QUERY_AB



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Sera Query Antibody Screen Information
Definition: Defines antibody screen information relating to a specific sera on hla_sera_query_serum. All information conatined on this table is a snapshot from the time it was created.
Table Type: ACTIVITY





Column Detail - HLA_SERA_QUERY_AB


Column Name Type Null? Definition
AB_SEQ DOUBLE N Sequentially assigned
ANTIBODIES_LIST_TXT VARCHAR(4000) Y Contains a list of antibodies. This field is a snapshot of the list of antibody's code value display when the record was saved.
B_CELL_PRA DOUBLE Y The b-cell pra for the serum.
DILUTION CHAR(40) Y The dilution for the serum. This field is a snapshot of the code value's display when the record was saved.
METHODOLOGY CHAR(40) Y The methodology for the serum. This field is a snapshot of the code value's display when the record was saved.
OD_RATIO_VALUE DOUBLE N Holds the od ratio value for antibody screen history.
OD_VALUE DOUBLE N Holds the od value for antibody screen history.
REACTION CHAR(40) Y The reaction for the serum. This field is a snapshot of the code value's display when the record was saved.
SERA_QUERY_SERUM_ID DOUBLE N Identifies the sera query serum record to which this serum belongs. It is a foreign key reference to the primary key of the hla_sera_query_serum table.
T_CELL_PRA DOUBLE Y The T-Cell PRA for the serum.
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 - HLA_SERA_QUERY_AB


Child Column in HLA_SERA_QUERY_AB(FK) Parent Table Name Parent Column Name
Parents: SERA_QUERY_SERUM_ID HLA_SERA_QUERY_SERUM SERA_QUERY_SERUM_ID


HLA_SERA_QUERY_QUERIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Sera Query Queries
Definition: Defines a specific query which belongs to group of queries.
Table Type: ACTIVITY





Column Detail - HLA_SERA_QUERY_QUERIES


Column Name Type Null? Definition
QUERY_LONG_TEXT_ID DOUBLE N Relates this record to a specific long_text record where query descriptions are stored. It is a foreign key reference to the primary key of the long_text table.
SERA_QUERY_ID DOUBLE N Identifies the sera query record to which this query belongs. It is a foreign key reference to the primary key of the hla_sera_query table.
SERA_QUERY_QUERIES_ID DOUBLE N A sequentially assigned number which uniquely identifies a Sera Query Queries record.
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 - HLA_SERA_QUERY_QUERIES


Child Column in HLA_SERA_QUERY_QUERIES(FK) Parent Table Name Parent Column Name
Parents: SERA_QUERY_ID HLA_SERA_QUERY SERA_QUERY_ID
QUERY_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in HLA_SERA_QUERY_QUERIES (PK) Child Table Name Child Column Name
Children: SERA_QUERY_QUERIES_ID HLA_SERA_QUERY_R SERA_QUERY_QUERIES_ID


HLA_SERA_QUERY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Sera Query Reference
Definition: Defines a relationship between a hla_sera_query_queries item and a hla_sera_query_serum item.
Table Type: ACTIVITY





Column Detail - HLA_SERA_QUERY_R


Column Name Type Null? Definition
SERA_QUERY_QUERIES_ID DOUBLE N Identifies the sera query queries record to which this record relates. It is a foreign key reference to the primary key of the hla_sera_query_queries table.
SERA_QUERY_SERUM_ID DOUBLE N Identifies the sera query serum record to which this record relates. It is a foreign key reference to the primary key of the hla_sera_query_serum 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 - HLA_SERA_QUERY_R


Child Column in HLA_SERA_QUERY_R(FK) Parent Table Name Parent Column Name
Parents: SERA_QUERY_QUERIES_ID HLA_SERA_QUERY_QUERIES SERA_QUERY_QUERIES_ID
SERA_QUERY_SERUM_ID HLA_SERA_QUERY_SERUM SERA_QUERY_SERUM_ID


HLA_SERA_QUERY_SERUM



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Sera Query Serum
Definition: Defines a specific sera which belongs to a query. The data containted is a snapshot view of when the data was created.
Table Type: ACTIVITY





Column Detail - HLA_SERA_QUERY_SERUM


Column Name Type Null? Definition
ABORH CHAR(80) Y The ABO/Rh blood type. This field is a snapshot of the code value's display when the record was saved.
ACCESSION CHAR(20) Y The unformatted accession number.
ANTIBODIES VARCHAR(100) Y The list of antibodies. This field is a snapshot of the list of antibody's code value display when the record was saved.
FMT_ACCESSION CHAR(40) Y The formatted accession. This field is a snapshot of the formatted accession when the record was saved.
HIC VARCHAR(200) Y The HIC alias replaces the UNOS alias. All previous UNOS aliases should display as the HIC alias. A README will be required to copy data from the UNOS column to the HIC column. Going forward, only the HIC column will be populated.
HLA_AB_SCREEN_ID DOUBLE N Identifies the manual record to which this serum belongs. It is a foreign key reference to the primary key of the person_hla_ab_screen table.
LOCATION VARCHAR(255) Y The location. This field is a snapshot of the code value's display when the record was saved.
MRN VARCHAR(200) Y The medical record number. This field is a snapshot of the MRN when the record was saved.
NAME_FULL_FORMATTED VARCHAR(100) Y The name full formatted. This field is a snapshot of the person's name full formatted when the record was saved.
NMDP VARCHAR(200) Y The NMDP number. This field is a snapshot of the NMDP when the record was saved. The NMDP is pulled from the person alias type codeset.
OPO VARCHAR(200) Y OPO Alias for OPO Donor ID / OPO Recipient ID
ORDER_DT_TM DATETIME Y The order date and time for the serum.
ORDER_ID DOUBLE N Identifies the non-manual record to which this serum belongs. It is a foreign key reference to the primary key of the orders table.
ORDER_MNEMONIC VARCHAR(100) Y The order mnemonic. This field is a snapshot of the order mnemonic when the record was saved.
ORDER_STATUS CHAR(40) Y The order status. This field is a snapshot of the code value's display when the record was saved.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
POSSIBLE_AB_STRING VARCHAR(255) Y The list of possible antibodies. This field is a snapshot of the string of possible antibodies when the record was saved.
RECIPIENT_STATUS VARCHAR(255) Y The recipient status. This field is a snapshot of the code value's display when the record was saved.
REMOVED_IND DOUBLE Y Variable to indicate whether the serum should be displayed in the retrieved or removed spreadsheet.
SERA_QUERY_ID DOUBLE N Identifies the sera query record to which this query belongs. It is a foreign key reference to the primary key of the hla_sera_query table.
SERA_QUERY_SERUM_ID DOUBLE N A sequentially assigned number which uniquely identifies a Sera Query Serum record.
SERUM_QUERY_INFO VARCHAR(255) Y Textual information pertaining to the record's serum.
TRANSPLANT_CENTER VARCHAR(255) Y The transplant center. This field is a snapshot of the code value's display when the record was saved.
UNOS VARCHAR(200) Y The UNOS number. This field is a snapshot of the UNOS when the record was saved. The UNOS is pulled from the person alias type codeset.
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 - HLA_SERA_QUERY_SERUM


Child Column in HLA_SERA_QUERY_SERUM(FK) Parent Table Name Parent Column Name
Parents: SERA_QUERY_ID HLA_SERA_QUERY SERA_QUERY_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID
HLA_AB_SCREEN_ID PERSON_HLA_AB_SCREEN HLA_AB_SCREEN_ID




Parent Column in HLA_SERA_QUERY_SERUM (PK) Child Table Name Child Column Name
Children: SERA_QUERY_SERUM_ID HLA_SERA_QUERY_AB SERA_QUERY_SERUM_ID
HLA_SERA_QUERY_R SERA_QUERY_SERUM_ID


HLA_TRAY_WELL_SERUM



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Typing Tray Well Serum
Definition: Defines a unique identifier for a specific donor's serum used in building an HLA typing tray or trays.
Table Type: REFERENCE





Column Detail - HLA_TRAY_WELL_SERUM


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.
MANUFACTURER_CD DOUBLE N The code for the manufacturer who uses the well serum in making HLA Typing trays.
SERUM_COMMENT VARCHAR(255) Y Comment pertaining to the serum contained in a well of an HLA Typing tray.
SERUM_DESC VARCHAR(20) Y The description of the serum contained in a well of an HLA Typing tray. This is typically provided by the manufacturer of the tray or is named after the donor of the serum. Unique identifier the user gives the HLA Typing tray well serum.
SERUM_ID DOUBLE N A sequentially assigned number which uniquely identifies an HLA Typing tray well serum.
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 - HLA_TRAY_WELL_SERUM




Parent Column in HLA_TRAY_WELL_SERUM (PK) Child Table Name Child Column Name
Children: SERUM_ID HLA_TYP_TRAY_WELL SERUM_ID
WELL_SERUM_AB SERUM_ID