ARTIFACT
 

Each artifact will have 1 record in this file. It holds the main description of the item, its category, the client responsible for it and other information particular to each artifact.

For the systems relational database this is the main record that ties the services, inventory used and technician information to each artifact.
 
ARTIFACT Main Artifact File  
name c
20
     Artifact name - "id" as the artifact will be known to the program - must be unique to each artifact
category c
10
     category of this artifact
group c
10
     groups of artifacts
descrip c
200
     description of this artifact. The notes table can be used for further explanations
client c
10
     client reponsible for this artifact
datein d
    date artifact first entered system
dateout d       when the artifact leaves the system
viewstatus c
    Contains levels of veiw permissions - W-web, P-public, H-hidden
insid c       Institution ID