Organizing
a file is the representation of stored records that makes up a file. This shows
the relationship between the records in the file. In essence, it is the
arrangement of a file to allow desired processing.
File Design (Master name file)
|
|
Field
Name |
Field
Length |
Whether
indexed or not |
Types
of filed (A/N) |
|
Hospital
No. |
NUMB
|
6
|
|
Numerical
|
|
Surname
|
SURM
|
30
|
N
|
A/N
Alphanumeric |
|
Other
name |
OTHN
|
30
|
_
|
A
|
|
Address
|
ADDR
|
20
|
_
|
A/N
|
|
Date
of birth |
DOB
|
10
|
_
|
DOB
|
|
Sex
|
SEX
|
6
or 1 |
_
|
A
|
|
Age
|
AGE
|
3
|
_
|
N
|
|
Consultant
|
CONSUL
|
30
|
Indexed
|
A
|
|
Date
|
DATE
|
10
|
_
|
A/N
|
It is difficult to use name for indexing you
use what is unique for indexing e.g. the hospital’ No. it is important to give your
file a
use what is unique for indexing e.g. the hospital’ No. it is important to give your
file a
name.
Patient
Admission File
Admission File
|
Hospital
No. |
Surname
|
Other Names
|
Address
|
Date of
Birth |
Sex
|
Age
|
Consult
|
Date
|
|
2204406
|
David
|
Ade
|
52 more
lle-Ife |
1/1/1970
|
M
|
33 years
|
Dr. Olu
|
20/2/03
|
|
220458
|
John
|
Ola
|
4
orange lle-Ife |
17/2/1872
|
F
|
31 years
|
Dr.
Femi |
20/3/03
|
These groups of records make up a file.
|
|
Field
Type |
Filled
length |
Index
or not |
Filled
name |
|
Hospital
No. |
N
|
6
|
No
|
NUMB
|
|
Name
|
A/N
|
30
|
√
|
NAME
|
|
Sex
|
A
|
1
|
√
|
SEX
|
|
Age
|
N
|
3
|
Yes
|
AGE
|
|
Department
|
A
|
6
|
√
|
DEPT.
|
|
Principle
|
A
|
6
|
√
|
PRIN.
|
|
Complication
|
A
|
6
|
√
|
COMP.
|
|
Association
|
A
|
6
|
√
|
ASSO.
|
|
date of
admission |
A/N
|
10
|
No
|
DOA
|
|
Date of
birth |
A/N
|
10
|
√
|
DOP
|
|
Post-mortem
|
A
|
1
|
√
|
PM
|
|
Consultant
|
A
|
30
|
Yes
|
CONSULT
|
