Data Dictionary
ENTITY DESCRIPTIONS
ROOMS
Definition:
Contains room occupency information
Attributes:
room#
ward#
patient#
Identifier:
room#
ward#
patient#
Constraints:
Must conform to physical hospital layout.
Dimension:
420
WARDS
Definition:
Contains descriptions of the wards and related rooms
Attributes
ward#
description
#rooms
Identifier:
Ward#
Constraints:
Must conform to physical hospital layout.
Dimensions:
1 ward per floor, 8 floors
PATEINT INFO
Definition:
Contains information about patients stay in hospital
Attributes:
Patient#
address
first_name
admit date
last name
discharge date
phone#
lenght of stay
Ward#
status
discharge date
Identifier:
Patient#
Last name + first name
Status
Constraints:
Dimensions:
All active, Discharged and wait-listed patients for past 5 years
WAIT LIST
Definition:
Contains all patients waiting for a room and ward
Attributes:
Patient#
priority
Date on list
notice date
ward
expected lenght of stay
Identifier:
patient#
priority
ward
Constraints:
Dimensions:
100 per ward at any one time
O/R-SHIFT
Definition:
contains times and rooms for an operation
Attributes:
O/R room#
Recovery room#
time in
time out
O/R#
Identifier:
O/R#
Constraints:
Dimensions:
Max 8 per day for each of 50 rooms
OR-SCHEDULE
Definition:
Contains all info for an operation.
Attributes:
O/R#
patient#
staff#1
staff#2
staff#3
staff#4
Identifier:
OR#
patient#
staff#1
staff#2
staff#3
staff#4
Constraints:
Dimensions:
Max 8 per day for each of 50 rooms
STAFF INFO
Definition:
contains all relevent staff data
Attributes:
staff#
address
first name
last name
title
speciality
phone#
Identifier:
staff#
last name + first name
title
speciality
Constraints:
Dimensions:
min 17 staff for each of 7 wards + operations per day
SHIFT-INFO
Definition:
corresponds to a time slot in a day for a ward that needs to be staffed
Attrib:
Ward#
Shift#
date
start time
end time
title1
title2
title3
title4
title5
title6
title7
Identifier:
ward#
Date + start time
Shift#
Constraints:
Identifier:
3 per day per ward (Not including O/R)
WORK SCHEDULE
Definition:
Contains all staff assigned to a shift
Attrib:
Shift#
Staff#
Identifier:
Shift#
Staff#
Constraints:
Identifier:
7 X 3 XWards (max) per day
Entity Relationship Descriptions
Relationship:
IS ON
O/R SHIFT is on an O/R SCHEDULE
Definition:
An O/R SHIFT (Operation) is assigned to the O/R schedule to specify
staffing requirerments
Relationship:
BOOKED ON
O/R SSCHEDULE is booked on an O/R SHIFT
Definition:
An O/R SCHEDULE is made up of individual operations (O/R SHIFTS)
Relationship:
IS STAFFED BY
O/R SCHEDULE is staffed by STAFF
Definition:
An operation in the O/R SCHEDULE has staff assigned to it.
Relationship:
ARE ASSIGNED TO
STAFF are assigned to O/R SCHEDULE
Definition:
STAFF are selected to fill the requirements of an operation.
Relationship:
IS BOOKED FOR
STAFF is booked for WORK SCHEDULE
Definition:
STAFF are selected to fill the requirements of a ward.
Relationship:
HAS
WORK SCHEDULE has STAFF
Definition:
A WORK SCHEDULE (Shift) has staffing requirements
Relationship:
HAS
WORK SCHEDULE has SHIFTS
Definition
The work schedule is subdivided into shifts which require staff.
Relationship:
IS ASSIGNED TO
SHIFT is assigned to a WORK SCHEDULE
Definition:
A shift is defined for each ward requires staff to be scheduled for
that shift.
Relationship:
HAS
WARD has SHIFTS
Definition:
Each ward has the day divided into work periods requiring staff.
Relationship:
IS ASSIGNED TO
SHIFT is assigned to a WARD
Definition:
A shift containing staffing requirements is created for a ward.
Relationship:
HAS
WARD has ROOMS
Definition:
A ward is made up of rooms.
Relationship:
IS IN
ROOM is in a WARD
Definition:
A room belongs in a particular ward.
Relationship:
IS IN
PATIENT is in a ROOM
Definition:
A patient is assigned to a room on a ward that matches his/her
treatment type.
Relationship:
ASSIGNED TO
ROOM is assigned to a PATIENT
Definition:
A room may be occupied by a patient.
Relationship:
BOOKS
O/R SHIFT books ROOMS
Definition:
An O/R Shift (operation) requires a operating room and a recovery room.
Relationship:
IS ASSIGNED TO
ROOM is assigned to an O/R SHIFT
Definition:
A recovery room or an operating room may be designated for an operation.
Relationship:
HAS
O/R SCHEDULE has PATIENT
Definition:
An O/R Schedule (operation) is performed on a patient.
Relationship:
IS ON
PATIENT is on an O/R SCHEDULE
Definition:
A patient is scheduled for an operation (O/R Schedule).
Relationship:
IS ON
PATIENT in on WAIT LIST
Definition:
If no rooms are available, a patient is placed on the waiting list.
Relationship:
HAS
WAIT LIST has PATIENTS
Definition:
The waiting list is made up of patients who are waiting for a room to
become available.
DATA DICTIONARY
# rooms
int 4
Number of rooms in a ward.
address
text
Consists of house number, street, city, province, postal code
admittance date
date 8
Date a patient is admitted, dd/mm/yy.
date
date 8
dd/mm/yy
date on list
date 8
Date a patient is put on the waiting list, dd/mm/yy.
description
text
Specify type of ward, one of: emergency, operating geriatrics,
recovery, intensive care, cardiology obstetrics, pediatrics.
discharge date
date 8
Date a patient leaves the hospital, dd/mm/yy.
end time
time
Expected time operation or shift ends.
expected length of stay
int 4
Estimated number of days a patient will spend in the hospital for a
treatment.
first name
text
First name and initial of staff member or patient (if known).
last name
text
Last name of staff member or patient.
length of stay
int 4
Estimated number of days of stay when patient is admitted, changing to
actual number of days stayed after discharge.
notification date
date 8
Date the two-week notification for a patient was generated, dd/mm/yy.
O/R #
int 4
Number assigned to a specific O/R shift (operation).
O/R room #
int 4
Number assigned to a particular room on the operating ward.
O/R Schedule
Entity
Contains all relevant information for an operation.
O/R Shift
Entity
Contains times and rooms for an operation.
patient #
int 9
Unique identifier for a patient, may be Alberta Health Care Number.
Patient Info
Entity
Contains all information about a patient and treatment.
phone #
int 10
Area code + local number
priority
int 4
Relative placement on the waiting list.
recovery room #
int 4
Number assigned to a specific room on the recovery ward.
Rooms
Entity
Contains room number and patient number (if occupied).
Shift Info
Entity
Contains the date and times for a ward that need to have staff
assigned.
speciality
int 4
Number between 1 and 8 corresponding to a floor in the hospital.
staff # (n)
int 9
Unique identifier for a person currently employed at the hospital.
Staff Info
Entity
Contains all relevant information about a person working at the
hospital.
start time
time
Time a operation or shift begins.
status
char 1
Patient's status: Acitive, Discharged or Wait Listed
room #
int 4
Number assigned to a room on a particular ward.
title (n)
text
Identifies whether a staff is doctor, regular nurse or supervisory
nurse.
Wait List
Entity
Contains all patients waiting for a room.
ward #
int 4
Number assigned to a ward.
Wards
Entity
Contains all information about a ward.
Work Schedule
Entity
Contains all the staff assigned to a particular shift.
Back to the Appendix
Back to the Final Design Document titlepage
Back to the main page
Last Modified Mar. 5, 1996 by
Darrell Nash