Soarian Clinicals Schema Documentation | |
Return to Table-Index |
Table Name | Table Comment |
HCareTeamAssignmentHistory | Contains patient/staff assignment history information. |
Column Name | Column Datatype | Column Null Option | Column Comment |
CareTeamAssignHistory_OID | int | NOT NULL | Unique ObjectID assigned to the row entry. |
Patient_oid | int | NOT NULL | Patient ObjectId. Must exist in HPatient table. |
Staff_oid | int | NOT NULL | Staff member Objectid. Must exist in HStaff table. |
AssignmentStartDTime | DATETIME | NOT NULL | Staff assignment start date and time. |
AssignmentEndDTime | DATETIME | NOT NULL | Staff assignment End date and time. |
LastCngDtime | DATETIME | NULL | System UTC date /time when row was updated. |
Return to Table-Index |
Soarian Clinicals Schema Documentation | ||
Copyright © 2023, Oracle and/or its affiliates |