PatientTransaction

The <PatientTransaction> element contains data relative to patient additions to the patient health history. There may be multiple <PatientTransaction> elements nested within a <PatientTransactions> element.

Element Description Type Notes

PatientNo

Patient ID

int

 

RecType

Record type

nvarchar

BMI
BP
CDRatio
Diagnosis
Head circumference
Height
IOP
Medical History
Ocular
Family History
Patient Ocular History
Ocular Medications
Ocular Surgical HIstory
Pachymetry
Resprate
SpO2
Systemic Family History
Systemic Medications
Systemic Surgical History
Temperature
Therapeutic Rx
Weight

RecText

Result value

nvarchar

Value data type based on RecType. Multiple values will be seperated by a pipe.

RecDate

Recorded date

datetime

Date the information was entered into the patient record.

Qty

Quantity for therapuetic Rx

nvarchar

 

Refills

Refills alloted for therapuetic Rx

int

 

Dosage

Dosage value for therapuetic Rx

nvarchar

 

Frequency

Frequency of dosage for therapuetic Rx

nvarchar

 

Application

Application of dosage for therapuetic Rx

nvarchar

 

Duration

Duration number

nvarchar

 

Duration2

Duration unit

nvarchar

For example, days, weeks, months.

RxId

?

int

 

PrintDate

Date Rx last printed

datetime

 

SubAllowed

Substitutions allowed

nvarchar

Yes
No

InActive

Order inactive

bit

0 = Yes
1 = No

RxExpirationDate

Prescription expiration date

datetime

 

RxDiscontinueDate

Discontinue date

datetime

 

ExamRec

Exam number

int

 

Onset

Onset of illness, allergy, etc

datetime

 

Reaction

Reaction to medication

nvarchar

 

RxStrength

Medication strength

nvarchar

 

RxNormId

RxNorm code

nvarchar

 

GenericName

Generic name of medication

nvarchar

 

Text2

Code associated with RecType

nvarchar

Values based on record type. May be ICD-10, ICD-9, refill information, special instructions, etc.

OTC

Over the counter indicator

bit

 

Narcotic

Narcotic indicator

bit

 

High_Risk

High risk medication indicator

bit

 

SNOMED

SNOMED code

nvarchar

If applicable. Associated to Rectype.

LOINC

LOINC code

nvarchar

If applicable. Associated to Rectype.

LOINC_RT

LOINC (right laterality)

nvarchar

If applicable. Associated to Rectype.

LOINC_LT

LOINC (left laterality)

nvarchar

If applicable. Associated to Rectype.

ExternalId

External ID

nvarchar

Associated to NDCID.

NDCID

National drug ID

nvarchar