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 |