Table Detail Report

HLA_AB_SCREEN_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Antibody Screen Batch
Definition: Relates a unique HLA antibody screen batch number to the inventory lot and HLA antibody screen tray map selected for the batch.
Table Type: ACTIVITY





Column Detail - HLA_AB_SCREEN_BATCH


Column Name Type Null? Definition
BATCH_DESC VARCHAR(30) Y A user assigned description which uniquely identifies an Antibody Screen batch.
BATCH_ID DOUBLE N A sequentially assigned number which uniquely identifies an Antibody Screen batch.
BATCH_NUMBER DOUBLE Y A sequentially assigned number which uniquely identifies an Antibody Screen batch.
DOWNLOAD_DT_TM DATETIME Y The date and time that the batch was downloaded.
DOWNLOAD_PRSNL_ID DOUBLE N The ID of the user who downloaded the batch.
FILL_METHOD_FLAG DOUBLE N Flag to record whether an antibody screen batch was filled by column. 0 = filled by row; 1 = filled by column
LOT_NUMBER_ID DOUBLE N Identifies the inventory lot of the Antibody Screen used for this batch. It is a foreign key reference to the primary key of the lot_number_info table.
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 - HLA_AB_SCREEN_BATCH


Child Column in HLA_AB_SCREEN_BATCH(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID LOT_NUMBER_INFO LOT_NUMBER_ID




Parent Column in HLA_AB_SCREEN_BATCH (PK) Child Table Name Child Column Name
Children: BATCH_ID HLA_AB_SCREEN_RESULT BATCH_ID
HLA_AB_SCREEN_WELL_SCORE BATCH_ID
HLA_SCREEN_ANALYSIS BATCH_ID
HLA_X_SPECIMEN_DETAIL BATCH_ID


HLA_AB_SCREEN_HISTORY_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Antibody Screen History Map
Definition: Provides for the mapping of discrete task assay results for a specific orderable procedure to the appropriate fields in the Person HLA Antibody Screen record. This mapping is used to create these records when the results are released for charting.
Table Type: REFERENCE





Column Detail - HLA_AB_SCREEN_HISTORY_MAP


Column Name Type Null? Definition
B_CELL_PRA_DTA_CD DOUBLE N The code specifying the discrete task assay which contains the B-Cell Panel Reactive Antibody percentage to be used in creating an Antibody Screen history record. It is a foreign key reference to the primary key of the discrete_task_assay table.
CATALOG_CD DOUBLE N The code referencing the order catalog procedure from which the Antibody Screen history record(s) will be built. It is a foreign key reference to the primary key of the order_catalog table.
DILUTION_DTA_CD DOUBLE N The code specifying the discrete task assay which contains the dilution to be used in creating an Antibody Screen history record. It is a foreign key reference to the primary key of the discrete_task_assay table.
DILUTION_NOM_ID DOUBLE N Identifies the nomenclature entry to use for dilution in creating an Antibody Screen history record. It is a foreign key reference to the primary key of the nomenclature table.
METHODOLOGY_DTA_CD DOUBLE N The code specifying the discrete task assay which contains the methodology to be used in creating an Antibody Screen history record. It is a foreign key reference to the primary key of the discrete_task_assay table.
METHODOLOGY_NOM_ID DOUBLE N Identifies the nomenclature entry to use for methodology in creating an Antibody Screen history record. It is a foreign key reference to the primary key of the nomenclature table.
OD_DTA_CD DOUBLE N Allows the user to map a discrete task assay to the od value on the history tables for antibody screens.
OD_RATIO_DTA_CD DOUBLE N Allows the user to map a discrete task assay to the od ratio value on the history tables for antibody screens.
REACTION_DTA_CD DOUBLE N The code specifying the discrete task assay which contains the reaction to be used in creating an Antibody Screen history record. It is a foreign key reference to the primary key of the discrete_task_assay table.
SEQ_NUMBER DOUBLE N Arbitrarily assigned number to make each record unique. This is necessary since multiple HLA Antibody Screen History Map records may be created for a single order catalog procedure.
T_CELL_PRA_DTA_CD DOUBLE N The code specifying the discrete task assay which contains the T-Cell Panel Reactive Antibody percentage to be used in creating an Antibody Screen history record. It is a foreign key reference to the primary key of the discrete_task_assay 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_AB_SCREEN_HISTORY_MAP


Child Column in HLA_AB_SCREEN_HISTORY_MAP(FK) Parent Table Name Parent Column Name
Parents: B_CELL_PRA_DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
DILUTION_DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
METHODOLOGY_DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
REACTION_DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
T_CELL_PRA_DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
DILUTION_NOM_ID NOMENCLATURE NOMENCLATURE_ID
METHODOLOGY_NOM_ID NOMENCLATURE NOMENCLATURE_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD


HLA_AB_SCREEN_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Antibody Screen Result
Definition: Records the raw result data specific to an HLA antibody screen for an order included in the screen's batch.
Table Type: ACTIVITY





Column Detail - HLA_AB_SCREEN_RESULT


Column Name Type Null? Definition
BATCH_ID DOUBLE N References the batch to which the Antibody Screen results apply. Orders may be placed in multiple batches or in the same batch multiple times. It is a foreign key reference to the primary key of the hla_ab_screen_batch table.
BATCH_NUMBER DOUBLE Y References the batch to which the Antibody Screen results apply. Orders may be placed in multiple batches or in the same batch multiple times. It is a foreign key reference to the primary key of the hla_ab_screen_batch table.
BATCH_TRAY_NUMBER DOUBLE N The Antibody Screen tray within the batch that the order was placed on. This will only be populated when inventory is mapped by well and is tested by tray.
BATCH_X_POS DOUBLE N The horizontal coordinate of a well on an Antibody Screen tray within the batch that the order was placed on. This will only be populated when inventory is mapped by row and tested by column or when it is mapped by tray and tested by well.
BATCH_Y_POS DOUBLE N The vertical coordinate of a well on an Antibody Screen tray within the batch that the order was placed on. This will only be populated when inventory is mapped by column and tested by row or when it is mapped by tray and tested by well.
B_CELL_PRA DOUBLE Y The B-Cell percentage Panel Reactive Antibody for the order at this batch placement. PRA = Positive Wells / Total Wells Scored.
COMMENT_LONG_TEXT_ID DOUBLE N Relates this record to a specific long_text record where antibody screen result comments are stored. It is a foreign key reference to the primary key of the long_text table.
COMPLEMENT VARCHAR(20) Y Complement lot number or other information pertaining to the complement used on an HLA antibody screen tray.
DILUTION_CD DOUBLE N The code for the dilution that used for the order at this batch placement.
METHODOLOGY_CD DOUBLE N The code for the methodology that used for the order at this batch placement.
ORDER_ID DOUBLE N Relates results for the Antibody Screen batch placement to a specific order. It is a foreign key reference to the primary key of the orders table.
PLATED_DT_TM DATETIME Y The date the HLA antibody screen tray was plated.
PLATED_PRSNL_ID DOUBLE N Id of the person who plated the HLA antibody screen tray.
READ_DT_TM DATETIME Y The date the HLA Antibody screen tray was reviewed.
READ_PRSNL_ID DOUBLE N Id of the person who read the HLA antibody screen tray.
T_CELL_PRA DOUBLE Y The T-Cell percentage Panel Reactive Antibody for the order at this batch placement. PRA = Positive Wells / Total Wells Scored.
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.
VIABILITY DOUBLE Y Viability percentage for the serum placed on an HLA antibody screen tray.



Relationship Detail - HLA_AB_SCREEN_RESULT


Child Column in HLA_AB_SCREEN_RESULT(FK) Parent Table Name Parent Column Name
Parents: BATCH_ID HLA_AB_SCREEN_BATCH BATCH_ID
COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
PLATED_PRSNL_ID PRSNL PERSON_ID
READ_PRSNL_ID PRSNL PERSON_ID


HLA_AB_SCREEN_TRAY_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Antibody Screen Tray Map
Definition: Further defines an inventory lot as being an HLA antibody screen tray or trays, and specifies the dimensions of the tray(s) and how the tray(s) are mapped.
Table Type: REFERENCE





Column Detail - HLA_AB_SCREEN_TRAY_MAP


Column Name Type Null? Definition
FILL_METHOD_FLAG DOUBLE N Flag to enable batches to be filled by column in HLA Antibody Screen Batch Build. 0 = fill by row; 1 = fill by column
LOT_NUMBER_ID DOUBLE N Uniquely identifies the record. It is a foreign key reference to the primary key of the lot_number_info table.
QC_IND DOUBLE Y Indicates whether or not quality control procedures have been performed on the antibody screen.
TRAY_ABBREVIATION CHAR(20) Y The abbreviation given an HLA Antibody Screen tray or batch of trays. This abbreviation will be used to identify the Antibody Screen when it used in testing.
TRAY_COUNT DOUBLE Y The number of trays which make up the Antibody Screen.
TRAY_ORIENTATION_CD DOUBLE N Specifies the default direction a tray within the batch is rotated when placed on the microscope.
TRAY_TYPE_CD DOUBLE N The code for the method used in mapping the tray(s) in the Antibody Screen. Antibody Screen trays may be mapped by well, by column, by row, or by tray.
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.
X_ALPHA_IND DOUBLE Y Indicates whether the horizontal coordinates of each tray should be represented as characters.
X_DIM DOUBLE Y Horizontal dimension of each tray included in the Antibody Screen.
Y_ALPHA_IND DOUBLE Y Indicates whether the vertical coordinates of each tray should be represented as characters.
Y_DIM DOUBLE Y Vertical dimension of each tray included in the Antibody Screen.



Relationship Detail - HLA_AB_SCREEN_TRAY_MAP


Child Column in HLA_AB_SCREEN_TRAY_MAP(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID LOT_NUMBER_INFO LOT_NUMBER_ID




Parent Column in HLA_AB_SCREEN_TRAY_MAP (PK) Child Table Name Child Column Name
Children: LOT_NUMBER_ID HLA_AB_SCRN_WELL LOT_NUMBER_ID


HLA_AB_SCREEN_WELL_SCORE



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Antibody Screen Well Score
Definition: Records individual well scores as part of the raw result data specific to an HLA antibody screen for an order included in the screen's batch.
Table Type: ACTIVITY





Column Detail - HLA_AB_SCREEN_WELL_SCORE


Column Name Type Null? Definition
BATCH_ID DOUBLE N References the batch to which the Antibody Screen well scores apply. Orders may be placed in multiple batches or in the same batch multiple times. It is a foreign key reference to the primary key of the hla_ab_screen_batch table.
BATCH_NUMBER DOUBLE Y References the batch to which the Antibody Screen well scores apply. Orders may be placed in multiple batches or in the same batch multiple times. It is a foreign key reference to the primary key of the hla_ab_screen_batch table.
B_CELL_WELL_SCORE_CD DOUBLE N The code for the well score given to this Antibody Screen well for the B-Cell reaction.
FALSE_NEG_IND DOUBLE Y Indicates whether the well was falsely scored as negative based on the antibodies identified in the interpretation of the Antibody Screen. NOT CURRENTLY IMPLEMENTED.
FALSE_POS_IND DOUBLE Y Indicates whether the well was falsely scored as positive based on the antibodies identified in the interpretation of the Antibody Screen. NOT CURRENTLY IMPLEMENTED.
ORDER_ID DOUBLE N Relates results for the Antibody Screen batch placement to a specific order. It is a foreign key reference to the primary key of the orders table.
TRAY_NUMBER DOUBLE N Tray number of the tray where the well being scored is located.
T_CELL_WELL_SCORE_CD DOUBLE N The code for the well score given to this Antibody Screen well for the T-Cell reaction.
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.
X_POS DOUBLE N Horizontal coordinate of the well being scored.
Y_POS DOUBLE N Vertical coordinate of the well being scored.



Relationship Detail - HLA_AB_SCREEN_WELL_SCORE


Child Column in HLA_AB_SCREEN_WELL_SCORE(FK) Parent Table Name Parent Column Name
Parents: BATCH_ID HLA_AB_SCREEN_BATCH BATCH_ID
ORDER_ID ORDERS ORDER_ID