REFERRAL_DX

Description: |
The REFERRAL_DX table contains diagnosis information stored with referrals.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
REFERRAL_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | REFERRAL_ID | NUMERIC | No |
The referral ID for the referral record.
2 | LINE | INTEGER | No |
The line number of the diagnosis associated with the referral. For example, if a referral has two associated diagnoses, the first diagnosis will have a line value of 1, while the second diagnosis will have a line value of 2.
3 | DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
4 | DX_TEXT | VARCHAR | No |
Free text associated with each additional diagnosis (I RFL 1000).
5 | DX_CODE_TYPE_C_NAME | VARCHAR | No |
Stores the code type of the additional diagnosis
May contain organization-specific values: Yes
Category Entries:
Unspecified diagnosis
Referral diagnosis
Secondary diagnosis
Additional diagnosis
Action diagnosis
Temporary diagnosis
Course diagnosis
Procedure
X-ray examination