Confidentiality LevelLocation Observation PriorityObservation StatusOccurred Ts
| Business Data Model Data Model |
| Description | An observation from a tracking tag that is normally captured when a tag changes its location. The real time location system holds the definition of business rules which determine monitored locations and duration of resource presence in that location needed to trigger the recording of the location change. |
| Attributes | |
| Confidentiality Level |
|
| Location Observation Priority |
|
| Observation Status |
|
| Occurred Ts |
|
| Relationship | |
 Tag Location Observation_Location_FK |
|
| Tracking Tag Location Observation_Tracking Tag_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Confidentiality Level
| Description | The level of security, privacy, or both, surrounding the order or observation result. For example: Highly confidential Not confidential Confidential Restricted Do not reveal to study sponsor |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Location Observation Priority
| Description | The importance of location observation. Most observations are reported as "Routine". For example: Routine Emergency |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Observation Status
| Description | Indicates the state of the observation. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Occurred Ts
| Description | The date and time when the observation actually occurred. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Tag Location Observation_Location_FK
| Is Identifying Relationship | true |
| Child Table | Tracking Tag Location Observation |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Location |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Tracking Tag Location Observation_Tracking Tag_FK
| Is Identifying Relationship | true |
| Child Table | Tracking Tag Location Observation |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Tracking Tag |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |