Table Detail Report

HLA_AB_SCRN_WELL



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Antibody Screen Well
Definition: Defines what is contained in a single tray well located on a specific HLA antibody screen.
Table Type: REFERENCE





Column Detail - HLA_AB_SCRN_WELL


Column Name Type Null? Definition
CELL_ID DOUBLE N Identifies in conjunction with manufacturer the unique cells contained in an Antibody Screen tray well. Cell_id and manufacturer_cd are a foreign key reference to the primary key of the hla_ab_scrn_well_cell table.
LOT_NUMBER_ID DOUBLE N Relates the Antibody Screen well to the inventory lot and related map. It is a foreign key reference to the primary key of the lot_number_info table.
MANUFACTURER_CD DOUBLE N No longer used.
TRAY_NUMBER DOUBLE N Tray number of the Antibody Screen tray where the well or series of wells being defined are located. This will only be populated when inventory is mapped by column, row, or tray.
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 The horizontal coordinate of a well or series of wells on an Antibody Screen which are being defined. This will only be populated when inventory is mapped by well or column.
Y_POS DOUBLE N The vertical coordinate of a well or series of wells on an Antibody Screen which are being defined. This will only be populated when inventory is mapped by well or row.



Relationship Detail - HLA_AB_SCRN_WELL


Child Column in HLA_AB_SCRN_WELL(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID HLA_AB_SCREEN_TRAY_MAP LOT_NUMBER_ID
CELL_ID HLA_AB_SCRN_WELL_CELL CELL_ID


HLA_AB_SCRN_WELL_CELL



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Antibody Screen Well Cell
Definition: Defines a unique identifier for a specific donor's cells used in building an HLA antibody screen or screens.
Table Type: REFERENCE





Column Detail - HLA_AB_SCRN_WELL_CELL


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.
CELL_COMMENT VARCHAR(255) Y Comment pertaining to the cells contained in a well of an Antibody Screen.
CELL_DESC VARCHAR(20) Y The description of the cells contained in a well of an Antibody Screen. This is typically provided by the manufacturer of the screen or is named after the donor of the cells. Unique identifier the user gives the Antibody Screen well cell.
CELL_ID DOUBLE N A sequentially assigned number which uniquely identifies an Antibody Screen well cell.
CONTROL_IND DOUBLE Y Indicates that antibody screen well contains a control instead of testing cells. This will exclude it from being used in PRA calculations.
MANUFACTURER_CD DOUBLE N The code for the manufacturer who uses the well cells in making Antibody Screens
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_SCRN_WELL_CELL




Parent Column in HLA_AB_SCRN_WELL_CELL (PK) Child Table Name Child Column Name
Children: CELL_ID HLA_AB_SCRN_WELL CELL_ID
WELL_CELL_ANTIGEN CELL_ID


HLA_AB_SPEC_MAP



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - HLA_AB_SPEC_MAP


Column Name Type Null? Definition
AB_DTA_CD DOUBLE N The code specifying the discrete task assay which contains the Antibody specificity to be used in creating an Antibody Screen Specificity history record. It is a foreign key reference to the primary key of the discrete_task_assay table.
AB_HIST_SEQ_NBR DOUBLE N Allows the link between the hla_ab_spec_map and hla_ab_screen_history_map tables.
CATALOG_CD DOUBLE N The code referencing the order catalog procedure from which the Antibody Screen Specificity history record(s) will be built. It is a foreign key reference to the primary key of the order_catalog 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_SPEC_MAP


Child Column in HLA_AB_SPEC_MAP(FK) Parent Table Name Parent Column Name
Parents: AB_DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
CATALOG_CD ORDER_CATALOG CATALOG_CD


HLA_DISPLAY_PRECEDENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Display Precedence
Definition: HLA Display Precedence for assay loci and event sequences.
Table Type: REFERENCE





Column Detail - HLA_DISPLAY_PRECEDENCE


Column Name Type Null? Definition
HLA_DISPLAY_PRECEDENCE_ID DOUBLE N This column is used to uniquely identify a row on the HLA_DISPLAY_PRECEDENCE table.
PRECEDENCE_DESC VARCHAR(80) N Contains the user defined precedence description associated with this task assay code.
PRECEDENCE_NBR DOUBLE N Contains the user defined precedence number associated with this task assay code.
PRECEDENCE_TYPE_FLAG DOUBLE N Indicates the type of precedence for this row.
TASK_ASSAY_CD DOUBLE N Identifies the procedure associated to this 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 - HLA_DISPLAY_PRECEDENCE


Child Column in HLA_DISPLAY_PRECEDENCE(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD


HLA_DTA_EVENT_MAPPING



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Discrete Task Assay Event Mapping
Definition: Provides for the mapping of discrete task assays to an event mnemonic. Multiple DTA's can be mapped to a single mnemonic. Event codes for each mnemonic will be created and associated to the DTA's during a generation script.
Table Type: REFERENCE





Column Detail - HLA_DTA_EVENT_MAPPING


Column Name Type Null? Definition
DTA_CD DOUBLE N The code specifying the discrete task assay for which the event mnemonic is being mapped to.
EVENT_MNEMONIC VARCHAR(50) N The mnemonic for the event code which will be associated to the discrete task assay.
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_DTA_EVENT_MAPPING


Child Column in HLA_DTA_EVENT_MAPPING(FK) Parent Table Name Parent Column Name
Parents: DTA_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD