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 |