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