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
Condition marked invalid in external data
Condition missing from subsequent bulk flat file load
Data invalidated by delete utility
LDA Added in Error