ALLERGY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Allergy
Definition: The Allergy table contains coded and freetext allergic reaction and adverse effect information about a person
Table Type: ACTIVITY





Column Detail - ALLERGY


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ALLERGY_ID DOUBLE N Uniquely defines an allergy/adverse reaction within the allergy table. The allergy_id can be associated with multiple allergy instances. When a new allergy is added to the allergy table the allergy_id is assigned to the allergy_instance_id.
ALLERGY_INSTANCE_ID DOUBLE N Unique identifier for the allergy table. Each change or revision made to an allergy/adverse reaction creates a new allergy instance.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BEG_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CANCEL_DT_TM DATETIME Y The date and time that the allergy was set to a status of cancelled.
CANCEL_PRSNL_ID DOUBLE N The unique identifier of the person who cancelled the allergy.
CANCEL_REASON_CD DOUBLE N Identifies the reason why a reaction has been cancelled.
CMB_DT_TM DATETIME Y Date/Time the item was combined
CMB_FLAG DOUBLE N Flag indicating the combined status of the item. 0 = not part of combined, 1 Combined, 2 Historically Combined, 3 Continuation of Combine indication
CMB_INSTANCE_ID DOUBLE N The "From" person's Allergy instance identifier of the allergy being combined
CMB_PERSON_ID DOUBLE N Person identifier of the "From" person being combined
CMB_PRSNL_ID DOUBLE N Person identifier who performed the combined
CMB_TZ DOUBLE Y Combine Date Time ZoneColumn
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.
CREATED_DT_TM DATETIME Y The date and time that the allergy/adverse reaction was entered on the allergy profile.
CREATED_PRSNL_ID DOUBLE N The unique identifier of the person who entered the allergy.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ONSET_DT_TM DATETIME Y The date that the reaction was identified.
ONSET_PRECISION_CD DOUBLE N indicates to what precision (not entered , age , about , before , after ,unknown) the onset_dt_tm has been set.
ONSET_PRECISION_FLAG DOUBLE Y Indicates to what level of accuracy the onset_dt_tm has been set. 10 = not entered, 20 = Date, 30 = Week Of, 40 = Month, 50 = Year, 60 = Date and Time
ONSET_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ORGANIZATION_ID DOUBLE N Foreign Key from ORGANIZATION table primary key
ORIG_PRSNL_ID DOUBLE N The person who originally inserted the allergy instanceColumn
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REACTION_CLASS_CD DOUBLE N Identifies the type of reaction, e.g. allergy, adverse drug reaction.
REACTION_STATUS_CD DOUBLE N The status of the reaction, e.g. confirmed, cancelled, proposed, working, suspected.
REACTION_STATUS_DT_TM DATETIME Y The date and time the REACTION_STATUS_CD was valued with the current value.Column
REC_SRC_IDENTIFER VARCHAR(50) Y Original source identifier that the allergy was received with from an interface.
REC_SRC_STRING VARCHAR(255) Y Original source string that the allergy was received with from an interface.
REC_SRC_VOCAB_CD DOUBLE N Original source vocabulary that the allergy was received with from an interface.
REVIEWED_DT_TM DATETIME Y Indicated the date and time the allergy was last reviewed by authenticated health care provider.
REVIEWED_PRSNL_ID DOUBLE N The person_id of the authenticated user who has reviewed the allergy.
REVIEWED_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SEVERITY_CD DOUBLE N Indicates the general severity of the allergy or reaction.
SOURCE_OF_INFO_CD DOUBLE N Identifies the source of the information regarding the reaction, e.g. provider, parent, chart, interface.
SOURCE_OF_INFO_FT VARCHAR(50) Y A free text description of the source of the information.
SUBSTANCE_FTDESC VARCHAR(255) Y A free text description of the substance.
SUBSTANCE_NOM_ID DOUBLE N Identifies the substance causing the reaction.
SUBSTANCE_TYPE_CD DOUBLE N Identifies the type of substance, e.g. drug, food, contrast, environment.
SUB_CONCEPT_CKI VARCHAR(255) Y CKI from the concept table which is a functional concept.
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.
VERIFIED_STATUS_FLAG DOUBLE Y Flag denotes whether the allergy has been verified by pharmacy.



Relationship Detail - ALLERGY


Child Column in ALLERGY(FK) Parent Table Name Parent Column Name
Parents: ALLERGY_ID ALLERGY ALLERGY_INSTANCE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
SUBSTANCE_NOM_ID NOMENCLATURE NOMENCLATURE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID




Parent Column in ALLERGY (PK) Child Table Name Child Column Name
Children: ALLERGY_INSTANCE_ID ALLERGY ALLERGY_ID
ALLERGY_COMMENT ALLERGY_ID
ALLERGY_REVIEW_HIST ALLERGY_INSTANCE_ID
REACTION ALLERGY_ID


ALLERGY_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Allergy Comment
Definition: Allows comments to be added to adverse effects and allergic reactions.
Table Type: ACTIVITY





Column Detail - ALLERGY_COMMENT


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ALLERGY_COMMENT LONGTEXT Y The textual comment regarding the allergy.
ALLERGY_COMMENT_ID DOUBLE N Unique identifier for the allergy comment.
ALLERGY_ID DOUBLE N Uniquely defines an allergy/adverse reaction within the allergy table. The allergy_id can be associated with multiple allergy instances. When a new allergy is added to the allergy table the allergy_id is assigned to the allergy_instance_id.
ALLERGY_INSTANCE_ID DOUBLE N Unique identifier for the allergy table. Each change or revision made to an allergy/adverse reaction creates a new allergy instance.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BEG_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CMB_COMMENT_ID DOUBLE N The "From" person's comment identifier of the comment being combined
CMB_DT_TM DATETIME Y Date/Time the item was combined
CMB_FLAG DOUBLE N Flag indicating the combined status of the item. 0 = not part of combined, 1 Combined, 2 Historically Combined, 3 Continuation of Combine indication
CMB_PERSON_ID DOUBLE N Person identifier of the "From" person being combined
CMB_PRSNL_ID DOUBLE N Person identifier who performed the combined
CMB_TZ DOUBLE Y Combine Date Time ZoneColumn
COMMENT_DT_TM DATETIME Y The date and time that the comment was recorded.
COMMENT_PRSNL_ID DOUBLE N The unique identifier of the person that recorded the comment.
COMMENT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
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 - ALLERGY_COMMENT


Child Column in ALLERGY_COMMENT(FK) Parent Table Name Parent Column Name
Parents: ALLERGY_ID ALLERGY ALLERGY_INSTANCE_ID


ALLERGY_EXT_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: External staging table for Allergy concept
Definition: To temporarily hold untrested data that has come from an external source (e.g. FHIR)
Table Type: ACTIVITY





Column Detail - ALLERGY_EXT_DATA


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The date and time of the action.
ACTION_PRSNL_ID DOUBLE N The personnel who performed the action.
ACTION_STATUS_CD DOUBLE N Action status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
ACTIVE_IND DOUBLE N 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ALLERGY_EXT_BLOB LONGBLOB Y The data that has come from an external interface.
ALLERGY_EXT_DATA_ID DOUBLE N PRIMARY KEY
ALLERGY_ID DOUBLE N This value comes from the ALLERGY_ID field on the ALLERGY table and not from the PK for ALLERGY.
CLIENT_IDENT VARCHAR(255) Y The client identifier that represents the client who wrote the data to the system.
CMB_ALLERGY_EXT_DATA_ID DOUBLE N Field to store the combined from ALLERGY_EXT_DATA_ID. This will be useful for tracking back to the combined row of staged allergy.
CMB_DT_TM DATETIME Y Filed to store the date/time when the combine occurred.
CMB_PERSON_ID DOUBLE N Field to store the combined from PERSON_ID. This will be useful for tracking back to the combined person_id of staged allergy.
CMB_PRSNL_ID DOUBLE N Field to store the person who performed combine
DATA_LOB_ENCODING_STR VARCHAR(10) Y The encoding of the ALLERGY_EXT_BLOB column.
ENCNTR_ID DOUBLE N This value comes from the ENCNTR_ID on the ENCOUNTER table
EXT_BLOB_VERSION DOUBLE Y The version of the external data
NOMENCLATURE_FT VARCHAR(255) Y FREE TEXT FOR THE NOMENCLATURE
NOMENCLATURE_ID DOUBLE N Identifier of the row referenced in the NOMENCLATURE table
PERSON_ID DOUBLE N The PERSON related to the external data
REQUESTED_ACTION_CD DOUBLE N Action requested for the data
SUBMITTED_DT_TM DATETIME Y The date and time this external data was added to the staging tables.
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 - ALLERGY_EXT_DATA


Child Column in ALLERGY_EXT_DATA(FK) Parent Table Name Parent Column Name
Parents: CMB_ALLERGY_EXT_DATA_ID ALLERGY_EXT_DATA ALLERGY_EXT_DATA_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
CMB_PERSON_ID PERSON PERSON_ID
PERSON_ID PERSON PERSON_ID
ACTION_PRSNL_ID PRSNL PERSON_ID
CMB_PRSNL_ID PRSNL PERSON_ID




Parent Column in ALLERGY_EXT_DATA (PK) Child Table Name Child Column Name
Children: ALLERGY_EXT_DATA_ID ALLERGY_EXT_DATA CMB_ALLERGY_EXT_DATA_ID


ALLERGY_REVIEW_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Allergy Review History
Definition: This table is used to store Allergy Review History information for each instance of the Allergy . This project involves displaying Reviewed date and time , reviewed prsnl name for each instance of the allergy.
Table Type: ACTIVITY





Column Detail - ALLERGY_REVIEW_HIST


Column Name Type Null? Definition
ALLERGY_INSTANCE_ID DOUBLE N Instance id of the Allergy of which are storing review history
ALLERGY_REVIEW_HIST_ID DOUBLE N Primary Key
REVIEWED_DT_TM DATETIME N Reviewed date and time
REVIEWED_PRSNL_ID DOUBLE N Id of the prsnl who reviewed the allergy
REVIEWED_TZ DOUBLE Y Reviewed date time zone
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 - ALLERGY_REVIEW_HIST


Child Column in ALLERGY_REVIEW_HIST(FK) Parent Table Name Parent Column Name
Parents: ALLERGY_INSTANCE_ID ALLERGY ALLERGY_INSTANCE_ID


CODE_VALUE_FILTER



Column Section Top of Page


Table-level Detail

Description: CODE VALUE FILTER
Definition: The CODE_VALUE_FILTER table stores CODE_SET(s) that have been filtered.
Table Type: REFERENCE





Column Detail - CODE_VALUE_FILTER


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CODE_SET DOUBLE N The code set of the filter.Column
CODE_VALUE_FILTER_ID DOUBLE N Primary Key.Column
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FILTER_IND DOUBLE N Indicates inclusive (0) or exclusive (1) filter.Column
FILTER_TYPE_CD DOUBLE N Indicates the type of filter, such as Immunization or Location as examples.Column
FLEX1_ID DOUBLE N Value of the primary identifier of associate parent entity.Column
FLEX2_ID DOUBLE N Value of the primary identifier of associate parent entity.Column
FLEX3_ID DOUBLE N Value of the primary identifier of associate parent entity.Column
FLEX4_ID DOUBLE N Value of the primary identifier of associate parent entity.Column
FLEX5_ID DOUBLE N *** OBSOLETE COLUMN *** Value of the primary identifier of associate parent entity.Column
PARENT_ENTITY_NAME1 VARCHAR(32) Y The upper case table name to which this row is associated.Column
PARENT_ENTITY_NAME2 VARCHAR(32) Y The upper case table name to which this row is associated.Column
PARENT_ENTITY_NAME3 VARCHAR(32) Y The upper case table name to which this row is associated.Column
PARENT_ENTITY_NAME4 VARCHAR(32) Y The upper case table name to which this row is associated.Column
PARENT_ENTITY_NAME5 VARCHAR(32) Y *** obsolete column *** The upper case table name to which this row is associated.Column
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.