rule_patient_data

If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of rule_patient_data.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Patient Reminders that the Clinical Decision Support system is configured to run for this specific patient.

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

date

DATETIME

19

√

NULL

pid

BIGINT

19

null

patient_data.pid

Defined in XML

R

The internal patient identifier

category

VARCHAR

31

''

rule_action_item.category

Defined in XML

R

Maps to the category item in the rule_action_item table

item

VARCHAR

31

''

rule_action_item.item

Defined in XML

R

Maps to the item column in the rule_action_item table

complete

VARCHAR

31

''

Maps to list_options list yesno

result

VARCHAR

255

''

Showing 1 to 7 of 7 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
category	Performance	Asc/Asc	category + item
pid	Performance	Asc	pid

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees