Contents List:Doctor and PatientTable Definition Sheets DOCTOR & PATIENT — INDEX DOCTOR & PATIENT — GLOSSARY |
Return to:Title PageArdue Library Ardue Site Plan See also: |
Consider the following SALADIN chart, whose functions are both to model rôle-playing relationships and to provide specimen Table Definitions.
| Table Reference | Table Name | Table Type Code | Dependency Type Code |
|---|---|---|---|
| R 5 | LEGAL ENTITY | SS | N |
| R 10 | ROLE | SS | N |
| R 15 | ROLE AUTHORITY | S | N |
| R 20 | ENTITY HAS CERTIFIED ROLE | S | S |
| R 25 | ENTITY HAS ASSUMED ROLE | S | S |
| R 30 | TRANSACTION TYPE | S | N |
| R 35 | ENTITY HAS ROLE | D | C |
| R 40 | TRANSACTION TYPE REQUIRES ROLES | S | S |
| R 45 | TRANSACTION | S | S |
| Field Name | Field Description | Field Size & Data Type |
|---|---|---|
| ACT ENT | The ID NR which identifies the party which plays the active rôle in a transaction | As for ID NR |
| ACTIVE ROLE | The ROLE CODE which identifies the active rôle in a transaction | As for ROLE CODE |
| AUTHORITY CODE | An ID NR which identifies a legal entity which is an authority | A 5-figure integer |
| DEF TRANS TYPE | A precise definition of a transaction type | Text: maximum length to be determined. |
| ID NR | A number which uniquely identifies a legal entity. | A 5-figure integer |
| NAME | The name of a legal entity | A string of up to 50 alphanumeric characters |
| PASS ENT | The ID NR which identifies the party which plays the passive rôle in a transaction | As for ID NR |
| PASSIVE ROLE | The ROLE CODE which identifies the passive rôle in a transaction | As for ROLE CODE |
| ROLE CODE | A convenient code for specifying a rôle which a legal entity may play | Up to 4 alphabetic characters in upper case |
| ROLE DEFINITION | A precise definition of a rôle in plain language | Text. Maximum length to be determined. |
| TRANS ID | A number which uniquely identifies a transaction | A 5-figure integer; may require to be increased to 6 figures at some time in the future. |
| TRANS TYPE CODE | A convenient code for identifying a transaction type | Up to 6 alphabetic characters in upper case |
2. Group Fields
| GROUP FIELD NAME | COMPONENT ELEMENTARY FIELDS |
|---|---|
| TRANSACTOR | ACTIVE ROLE |
| ACT ENT | |
| TRANSACTEE | PASSIVE ROLE |
| PASS ENT |
Version Number: 1
Date & Time: 15/08/92 06:27
Author: DM