Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents

Entities (tables)

Medication

...

Request requests

varchar,
NameTypeM/ODescription and constraints
iduuidM
human_receipt_id

datajsonbM
request_numbervarchar(255)M
Must have special proc program_type varchar (Dictionary: PROGRAM_TYPE

statusvarchar(255)M
created

inserted_
at
by
date
uuidM
started

updated_
at
by
date
uuidM
ended

inserted_at
date
timestampM
dispense

updated_
valid_from
at
date
timestampM
dispense

verification_
valid_to dateMperson
codevarchar(255)O
medication_request_iduuidM
employee_

Medication Requests

This entity defines  Medication request (terms) information structure.

NameTypeM/ODescription and constraints
iduuidM
receipt

request_
period_type RECEIPT_PERIOD_TYPE
number
varchar (Dictionary:
varchar(255)M
receipt

created_
age_type varchar (Dictionary: RECEIPT_AGE_TYPE)
atdateM
innm

started_
id
at
uuid
dateM
innm

ended_
route varchar (Dictionary: MEDICATIONS_ROUTE_TYPE)
atdateM
innm

dispense_valid_
dosage
from
Dosage: jsonb
dateM
innm

dispense_
container
valid_
dosage
to
Dosage: jsonb
dateM
innm

person_
qty
id
numbernumber
uuidM
innm_dose_used_qty

employee_iduuidM
note

medication_id
varchar
uuid
O
M
dosage

medication_
instuction
qty
varchar
numeric
O
M
status
varchar (Dictionary: MEDICATION_REQUEST_STATUS
varchar(255)M
is_activebooleanM
recall

rejected_atdateO
recalled

rejected_byuuidO
recall

reject_reasonvarchar(255)O
medication_request_
for_medication_request
requests_iduuidM
medical_program_iduuid
M
O
inserted_
at
by
timestamp
uuidM
inserted

updated_byuuidM
updated

inserted_attimestampM
updated_
by
at
uuid
timestampM
context

verification_code
reference
varchar(
encounter)
255)O
division_iduuidM
legal_entity_iduuidM