DOCS_RCVD_ALGS
Description:
This table stores discrete allergies information received from outside sources.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
This item stores the Received Document record ID.
2 CONTACT_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 ALG_REF_ID VARCHAR No
This item stores a unique reference identifier to identify a specific instance of an allergy.
5 ALG_SEVERITY_C_NAME VARCHAR No
This item stores the overall allergy severity.
May contain organization-specific values: No
Category Entries:
High
Medium
Low
6 ALG_DATE_NOTED_DT DATETIME No
This item stores the date when the allergy was noted by the external system.
7 ALG_DATE_RESOLVD_DT DATETIME No
This item stores the date of when the allergy was resolved.
8 ALG_SRC_LPL_ID NUMERIC No
This item stores the source Problem List record identifier.
9 ALG_TYPE_OF_CHNG_C_NAME VARCHAR No
This item stores the type of change being performed on the allergy.
May contain organization-specific values: No
Category Entries:
Receive
Edit
Delete
10 ALGN_NAME VARCHAR No
This item stores the display name of the allergen as sent by the external source.
11 ALGN_ID NUMERIC No
This item stores the Allergen record identifier that maps to the allergen from the external source.
12 ALGN_ID_ALLERGEN_NAME VARCHAR No
The name of the allergen record.
13 ALG_TYPE VARCHAR No
This item stores the textual allergy type sent by the external source.
14 ALG_TYPE_ID_C_NAME VARCHAR No
This item stores the category value which maps to the allergy type sent by the external source.
May contain organization-specific values: Yes
Category Entries:
Systemic
Drug Class
Food
Environmental
Animal
Plant
Chemical
Drug Ingredient
Drug
opt
15 ALG_SRC_DXR_CSN NUMERIC No
This item will store the contact serial (CSN) number of the Received Document record that owns the instance of this allergy.
16 ALG_DUP_OVRD_LPL_ID NUMERIC No
This item stores the record identifier of the local allergy that this external allergy should be grouped with.
17 ALG_LAST_UPD_DTTM DATETIME (UTC) No
This item stores the date and time when the allergy was last updated by the external system.
18 ALG_PT_SRC_APP_C_NAME VARCHAR No
If this allergy is a patient-entered allergy (i.e. DXR type = 25), this item stores the application which was used to edit the allergy for the contact (e.g. MyChart or Welcome). If blank, this is assumed to be MyChart.
May contain organization-specific values: Yes
Category Entries:
MyChart
Welcome
19 ALGRX_TYPE VARCHAR No
This item stores the text value of the allergy reaction type sent by the external source.
20 ALGRX_TYPE_ID_C_NAME VARCHAR No
This item stores the category value which maps to the allergy reaction type sent by the external source.
May contain organization-specific values: Yes
21 ALG_DT_NOTED_NF_C_NAME VARCHAR No
This item stores the nullFlavor value from the effectiveTime low node in a received CDA document.
May contain organization-specific values: No
Category Entries:
No Information
Invalid
Derived
Other
Negative infinity
Positive infinity
Un-encoded
Masked
Not applicable
Unknown
Asked but unknown
Temporarily unavailable
Not asked
Sufficient quantity
Trace
Not present
User Selected
22 ALG_DT_RESOLV_NF_C_NAME VARCHAR No
This item stores the nullFlavor value from the effectiveTime high node in a received CDA document.
The category values for this column were already listed for column: ALG_DT_NOTED_NF_C_NAME
23 ALG_STATE_C_NAME VARCHAR No
This item stores the value from the statusCode node in a received CDA document. This item itself is not the status of the allergy.
May contain organization-specific values: No
Category Entries:
Other
Normal
Aborted
Active
Cancelled
Completed
Held
New
Suspended
Nullified
Obsolete
24 ALG_STATUS_ENTRY_C_NAME VARCHAR No
This item stores the value from the status entryRelationship node in a received CDA document. This item itself is not the status of the allergy.
May contain organization-specific values: No
Category Entries:
Active
Inactive
Resolved
25 ALG_HIST_STATUS_C_NAME VARCHAR No
The item indicates whether the allergy is current or historical.
May contain organization-specific values: No
Category Entries:
Current
Historical
Inactive
Discontinued
Deleted
26 ALG_HIST_DATE DATETIME No
This item stores the date that the historical status for this allergy is valid through. After this date, the historical status needs to be rechecked.
27 ALG_SRC_WPR_ID VARCHAR No
Stores the Patient Access Accounts ID of the MyChart user who edited the allergy for the contact.
28 ALG_CRITICALITY_C_NAME VARCHAR No
This item stores the category value for overall allergy criticality.
May contain organization-specific values: Yes
Category Entries:
Unable to assess
High
Low
Moderate
Fatal
29 ALG_CRITICALITY_TXT VARCHAR No
This item stores the free text allergy criticality.
30 ALG_PAT_ENC_CSN_ID NUMERIC No
Stores the contact serial number (CSN) of the encounter that the allergy was added on.
31 ALG_EXT_DATA_FILTER_REASON_C_NAME VARCHAR No
Stores the reason why an allergy should be filtered from the composite record.
May contain organization-specific values: No
Category Entries:
Claim Derivation: Procedure Code Inclusion/Exclusion List
Claim Derivation: Missing Provider
Claim Derivation: Sensitive Diagnosis
Claim Derivation: Missing Procedure Start Date
Claim Derivation: Excluded Procedure Modifier
Source Organization Unknown
Source Organization Mismatch
Source Organization Is Self
Clinical Note Type Exclusion List
Clinical Note Missing Service Instant
Clinical Note Missing Last Filed Instant
Clinical Note Missing Author Name
Dispense Cancellation
Same Day as Internal Encounter
Missing or Invalid Binary URL
Filtered or Missing Source Note
DocumentReference Status not Current
Claim Derivation: Excluded Linked Diagnoses
Claim Derivation: Missing Encounter Start Date
Entered In Error
FHIR resource contained an invalid category
Condition verification status is no longer confirmed
Condition is no longer valid for this patient due to age or sex
FHIR resource has an invalid start date
Encounter FHIR resource is missing the type element
FHIR resource is missing the status element
Encounter FHIR resource is missing the class element
Encounter FHIR resource contained an unrecognized status code
Encounter FHIR resource contained a status code for a future encounter
Encounter FHIR resource contained a class code for a future encounter
FHIR resource has a future start date
FHIR resource does not have a status of completed
FHIR resource is missing the code element
Diagnosis is missing a link to an encounter
FHIR resource contains a reference to encounter not in the system
FHIR resource contained a patient reference not matching the searched for patient
Immunization FHIR Resource is missing the vaccineCode element or did not contain a CVX code
FHIR Resource is missing an effective date/time
FHIR resource contained an invalid status
Observation FHIR resource is linked to a filtered Condition FHIR resource
SDOH Assessment contains no questions
Missing required data for data type
FHIR resource does not have a status of confirmed
Claim Derivation: Missing face-to-face services