Table Detail Report

HLA_NOMEN_CODE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Nomenclature Code Cross Reference
Definition: Defines a relationship between a nomenclature item and a code value item.
Table Type: REFERENCE





Column Detail - HLA_NOMEN_CODE_R


Column Name Type Null? Definition
NOMENCLATURE_ID DOUBLE N Identifies the nomenclature entry which is related to a code value.
RELATED_CD DOUBLE N Identifies the code value that is related to the nomenclature item.
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_NOMEN_CODE_R


Child Column in HLA_NOMEN_CODE_R(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


HLA_ORDER_LOCK



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Order Lock
Definition: This table is used for activity monitoring of HLA application.
Table Type: ACTIVITY





Column Detail - HLA_ORDER_LOCK


Column Name Type Null? Definition
HLA_ORDER_LOCK_ID DOUBLE N Unique generated number that identifies a single row on the HLA_ORDER_LOCK table.
ILOCK_IND DOUBLE N Indicates if the patient order is locked or not. 1 - locked, 2 - not looked.
PERSON_ID DOUBLE N Person whose order is locked. This infromation will be obtained from the script.
PERSON_LOCK_DT_TM DATETIME Y The date and time the technician locked the person order.
TECH_LOCK_ID DOUBLE N The technician who has locked the person order.
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_ORDER_LOCK


Child Column in HLA_ORDER_LOCK(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
TECH_LOCK_ID PRSNL PERSON_ID


HLA_SCREEN_ANALYSIS



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Antibody Screen Analysis
Definition: Stores the activity data related to the modified antibody screen analysis.
Table Type: ACTIVITY





Column Detail - HLA_SCREEN_ANALYSIS


Column Name Type Null? Definition
ANALYSIS_DESC VARCHAR(250) N A textual string entered by a user when the analysis was saved.
ANALYSIS_DT_TM DATETIME N Current date and time the analysis was saved to the table. Used to display when selecting to load a saved analysis.
BATCH_ID DOUBLE N Relationship identifier from HLA_AB_SCREEN_BATCH, which relates a unique HLA antibody screen batch number to the inventory lot and HLA antibody screen tray map selected for the batch.
CRITERIA_ID DOUBLE N Unique identifier for a modified antibody screen analysis.
CROSS_SPECIMEN_ID DOUBLE N Identifies the relationship to the information to HLA_X_SPECIMEN_ANALYSIS, which is a saved cross specimen analysis.
CUTOFF_TYPE_FLAG DOUBLE N Identifies what the cutoff value is holding: 1 = inclusion percentage, 2 = r-value 3 = chi square
CUTOFF_VALUE DOUBLE N Value to use as the CUTOFF when displaying the r-value and tail analysis views in the antibody screen analysis. Holds either the inclusion percentage, r-value or chi square cut off value.
POSITIVE_DEFINITION_CD DOUBLE N Value of the positive score cutoff.
REMOVE_PERSON_ANTIGEN_IND DOUBLE N Indicates whether to remove the persons HLA typing antigens from the analysis automatically.
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_SCREEN_ANALYSIS


Child Column in HLA_SCREEN_ANALYSIS(FK) Parent Table Name Parent Column Name
Parents: BATCH_ID HLA_AB_SCREEN_BATCH BATCH_ID
CROSS_SPECIMEN_ID HLA_X_SPECIMEN_ANALYSIS CROSS_SPECIMEN_ID




Parent Column in HLA_SCREEN_ANALYSIS (PK) Child Table Name Child Column Name
Children: CRITERIA_ID HLA_SCREEN_ANALYSIS_DETAIL CRITERIA_ID


HLA_SCREEN_ANALYSIS_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Antibody Screen Analysis Detail
Definition: Detail information related to a saved modified antibody screen analysis.
Table Type: ACTIVITY





Column Detail - HLA_SCREEN_ANALYSIS_DETAIL


Column Name Type Null? Definition
ANTIGEN_CD DOUBLE N Antigen that is to be removed from the antibody screen analysis.
BCELL_LOCI_CD DOUBLE N Contains the b-cell loci that is to be included in the antibody screen analysis.
CREG_ID DOUBLE N CREG identifier that relates to the information to be removed from the antibody screen analysis.
CRITERIA_ID DOUBLE N Relates information to the activity data of the modified antibody screen analysis.
SCREEN_ANALYSIS_DETAIL_ID DOUBLE N An identifier used to keep each row on the HLA_SCREEN_ANALYSIS_DETAIL table unique.
TCELL_LOCI_CD DOUBLE N The t-cell loci that is to be included in the antibody screen analysis.
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_SCREEN_ANALYSIS_DETAIL


Child Column in HLA_SCREEN_ANALYSIS_DETAIL(FK) Parent Table Name Parent Column Name
Parents: CREG_ID CREG CREG_ID
CRITERIA_ID HLA_SCREEN_ANALYSIS CRITERIA_ID


HLA_SERA_QUERY



Column Section Relationship Section Top of Page


Table-level Detail

Description: HLA Sera Query.
Definition: Defines a unique description and time for a query. Queries are comprised of a list of sera brought back from a serum search.
Table Type: ACTIVITY





Column Detail - HLA_SERA_QUERY


Column Name Type Null? Definition
QUERY_DESCRIPTION VARCHAR(255) Y The description of the query. Unique identifier the user gives the query.
QUERY_DT_TM DATETIME Y Date and time assigned to the record.
SERA_QUERY_ID DOUBLE N A sequentially assigned number which uniquely identifies a Query Sera 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




Parent Column in HLA_SERA_QUERY (PK) Child Table Name Child Column Name
Children: SERA_QUERY_ID HLA_SERA_QUERY_QUERIES SERA_QUERY_ID
HLA_SERA_QUERY_SERUM SERA_QUERY_ID