Table Detail Report

PERSON_HLA_AB_SPEC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person HLA Antibody Specificity
Definition: Defines specific antibodies identified for a person during HLA antibody screening over time.
Table Type: ACTIVITY





Column Detail - PERSON_HLA_AB_SPEC


Column Name Type Null? Definition
HLA_AB_SCREEN_ID DOUBLE N Relates the Antibody Screen Specificity History to a manually entered Antibody Screen History record. Not populated when history is automatically generated.
HLA_AB_SPEC_ID DOUBLE N A sequentially assigned number which uniquely identifies an HLA Antibody Screen Specificity history record.
HLA_TYPE_NOM_ID DOUBLE N Identifies the nomenclature entry for the antibody determined by an Antibody Screen. Either derived from Antibody Screen results or entered manually into history.
MAP_AB_DTA_CD DOUBLE Y Reference to ab_dta_cd on the hla_ab_spec_map table. This records the mapping record used to create the person_hla_ab_spec record.
ORDER_ID DOUBLE N Relates results for the HLA Typing tray to a specific order. It is a foreign key reference to the primary key of the orders table.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - PERSON_HLA_AB_SPEC


Child Column in PERSON_HLA_AB_SPEC(FK) Parent Table Name Parent Column Name
Parents: HLA_TYPE_NOM_ID NOMENCLATURE NOMENCLATURE_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID
HLA_AB_SCREEN_ID PERSON_HLA_AB_SCREEN HLA_AB_SCREEN_ID


PERSON_HLA_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person HLA Event
Definition: Defines a person's HLA Events
Table Type: ACTIVITY





Column Detail - PERSON_HLA_EVENT


Column Name Type Null? Definition
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
HLA_EVENT_DT_TM DATETIME Y Date HLA Event occurred.
HLA_EVENT_ID DOUBLE N A sequentially assigned number which uniquely identifies an HLA Event history record.
HLA_EVENT_TEXT_ID DOUBLE N Relates this record to a specific long_text record where HLA Event history text are stored. It is a foreign key reference to the primary key of the long_text table.
HLA_EVENT_TYPE_CD DOUBLE N HLA Event Type code is used to identify the type of event that has occurred.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRSNL_ID DOUBLE N Identifies the user who last updated the person_hla_event record.
REMOVED_DT_TM DATETIME Y The date and time this record was removed from HLA history.
REMOVED_IND DOUBLE Y Indicates that the record has been removed from HLA history. Records are not deleted so that a complete audit trail can be kept.
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 - PERSON_HLA_EVENT


Child Column in PERSON_HLA_EVENT(FK) Parent Table Name Parent Column Name
Parents: HLA_EVENT_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in PERSON_HLA_EVENT (PK) Child Table Name Child Column Name
Children: HLA_EVENT_ID PERSON_HLA_EVENT_AUDIT HLA_EVENT_ID


PERSON_HLA_EVENT_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person HLA Event Audit
Definition: Provides an audit trail of the Person HLA Event table whenever a record is modified.
Table Type: ACTIVITY





Column Detail - PERSON_HLA_EVENT_AUDIT


Column Name Type Null? Definition
AUDIT_DT_TM DATETIME Y Date and time that the audit record was created.
HLA_EVENT_AUDIT_ID DOUBLE N A sequentially assigned number which uniquely identifies an HLA Event History audit record.
HLA_EVENT_DT_TM DATETIME Y Date and time that the original person_hla_event record was created.
HLA_EVENT_ID DOUBLE N Relates this audit record to the current HLA Event History record. It is a foreign key reference to the primary key of the person_hla_event table.
HLA_EVENT_TEXT_ID DOUBLE N Relates this record to a specific long_text record where HLA Event history audit trail event text is located. It is a foreign key reference to the primary key of the long_text table.
HLA_EVENT_TYPE_CD DOUBLE N The type of HLA event for this record
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRSNL_ID DOUBLE N Identifies the user who updated the person_hla_event record which resulted in the creation of this audit 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 - PERSON_HLA_EVENT_AUDIT


Child Column in PERSON_HLA_EVENT_AUDIT(FK) Parent Table Name Parent Column Name
Parents: HLA_EVENT_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID
HLA_EVENT_ID PERSON_HLA_EVENT HLA_EVENT_ID
PRSNL_ID PRSNL PERSON_ID


PERSON_HLA_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person HLA Type
Definition: Defines a person's permanent HLA type for the various HLA loci.
Table Type: ACTIVITY





Column Detail - PERSON_HLA_TYPE


Column Name Type Null? Definition
ACCESSION CHAR(20) Y An accession number identifies an order or a group of orders. Relates the HLA Typing History to the order from which it was derived. Not populated when history is manually entered.
CHARTED_IND DOUBLE Y Indicates whether or not a manually entered HLA typing has been sent to the OCF Clinical Event tables for charting.
COMMENT_LONG_TEXT_ID DOUBLE N Relates this record to a specific long_text record where HLA Typing history comments are stored. It is a foreign key reference to the primary key of the long_text table. Either derived from HLA Typing order comments or entered manually.
COMPLETE_DT_TM DATETIME Y Date and time that the HLA Typing results were completed.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
HLA_DT_TM DATETIME Y Date and time that the record was created.
HLA_TYPE_ID DOUBLE N A sequentially assigned number which uniquely identifies an HLA Typing history record.
HLA_TYPE_NOM_ID DOUBLE N Identifies the nomenclature entry for the antigen which is part of the HLA Typing. Either derived from HLA Typing results or entered manually into history.
LOCI_CD DOUBLE N The code for the specific HLA Loci where the HLA antigen is located. Either derived from HLA Typing results or entered manually into history.
ORDER_ID DOUBLE N Relates the HLATyping History to the order from which it was derived. Not populated when history is manually entered. It is a foreign key reference to the primary key of the orders table.
OUTSIDE_TYPING_IND DOUBLE Y Indicates that the HLA Typing was performed by an external laboratory.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRELIMINARY_IND DOUBLE Y Indicates that the typing result has been performed but not verified.
PRSNL_ID DOUBLE N Identifies the user who last updated the person_hla_type record or the person who performed the testing for history which is derived from HLA Typing results.
REFERENCE_NBR VARCHAR(60) N Reference number created by ESI interface to identify duplicates. Populated with hla_type_id if not an interfaced record.
REMOVED_DT_TM DATETIME Y The date and time this record was removed from HLA history.
REMOVED_IND DOUBLE Y Indicates that the record has been removed from HLA history. Records are not deleted so that a complete audit trail can be kept.
SPECIMEN_TYPE_CD DOUBLE N The code for the specimen type used for the hla typing.
TASK_ASSAY_CD DOUBLE N Relates this HLA type to an associated procedure.
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 - PERSON_HLA_TYPE


Child Column in PERSON_HLA_TYPE(FK) Parent Table Name Parent Column Name
Parents: HLA_TYPE_NOM_ID NOMENCLATURE NOMENCLATURE_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID




Parent Column in PERSON_HLA_TYPE (PK) Child Table Name Child Column Name
Children: HLA_TYPE_ID PERSON_HLA_TYPE_AUDIT HLA_TYPE_ID


PERSON_HLA_TYPE_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person HLA Type Audit
Definition: Provides an audit trail of the Person HLA Type table whenever a record is modified.
Table Type: ACTIVITY





Column Detail - PERSON_HLA_TYPE_AUDIT


Column Name Type Null? Definition
AUDIT_DT_TM DATETIME Y Date and time that the audit record was created.
CHARTED_IND DOUBLE Y Indicator to signify whether the row has been charted.
COMMENT_LONG_TEXT_ID DOUBLE N Relates this record to a specific long_text record where HLA Typing history audit trail comments are stored. It is a foreign key reference to the primary key of the long_text table.
COMPLETE_DT_TM DATETIME Y Date and time that the HLA Typing results were completed.
HLA_DT_TM DATETIME Y Date and time that the original person_hla_type record was created.
HLA_TYPE_AUDIT_ID DOUBLE N A sequentially assigned number which uniquely identifies an HLA Typing History audit record.
HLA_TYPE_ID DOUBLE N Relates this audit record to the current HLA Typing History record. It is a foreign key reference to the primary key of the person_hla_type table.
HLA_TYPE_NOM_ID DOUBLE N Identifies the nomenclature entry for the antigen which is part of the HLA Typing.
LOCI_CD DOUBLE N The code for the specific HLA Loci where the HLA antigen is located.
OUTSIDE_TYPING_IND DOUBLE Y Indicates that the HLA Typing was performed by an external laboratory.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRSNL_ID DOUBLE N Identifies the user who updated the person_hla_type record which resulted in the creation of this audit record.
SPECIMEN_TYPE_CD DOUBLE N The code for the specimen type used for the hla typing.
TASK_ASSAY_CD DOUBLE N Relates this HLA type to an associated procedure.
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 - PERSON_HLA_TYPE_AUDIT


Child Column in PERSON_HLA_TYPE_AUDIT(FK) Parent Table Name Parent Column Name
Parents: COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
HLA_TYPE_NOM_ID NOMENCLATURE NOMENCLATURE_ID
PERSON_ID PERSON PERSON_ID
HLA_TYPE_ID PERSON_HLA_TYPE HLA_TYPE_ID