All values associated with a claim are stored in the Claim External Value record. The PAT_RSN_VISIT_DX table holds the diagnoses that document the patient's reason for an outpatient visit.
Primary Key
Column Name
Ordinal Position
RECORD_ID
1
LINE
2
Column Information
Name
Type
Discontinued?
1
RECORD_ID
NUMERIC
No
The unique identifier for the claim record.
2
LINE
INTEGER
No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3
PAT_RSN_VISIT_QUAL
VARCHAR
No
This item holds the qualifier identifying the code set for the patient reason for visit diagnoses.
4
PAT_RSN_VISIT_DX
VARCHAR
No
This item holds the diagnoses representing the patient's reason for the visit.