Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
|
PtExpectedOutcomeOID | int | NOT NULL | Object ID of an Expected Outcome for a Patient |
ExpectedOutcomeCVEId | varchar(32) | NOT NULL | Common Vocabulary Engine(CVE) identifier for the expected outcome |
AssignedBy_oid | int | NOT NULL | Object ID of the User who assigned the expected outcome(HSUser) |
AssignedDateTime | smalldatetime | NOT NULL | Date and time(Local) the expected outcome was assigned |
AssignedByName | varchar(188) | NOT NULL | Name of the User who assigned the expected outcome |
ChangeDateTime | smalldatetime | NOT NULL | Date and time(Local) this expected outcome information was changed |
ChangedByName | varchar(188) | NOT NULL | Name of the User making a change to the expected outcome information |
DisplayName | varchar(254) | NOT NULL | Name displayed for the Expected Outcome as defined in Common Vocabulary Engine(CVE) |
Status | varchar(254) | NOT NULL | Status of the Expected Outcome |
| | | Allowable Values: |
| | | Active |
| | | Resolved |
| | | Inactive |
| | | Erroneous |
StatusCd | varchar(32) | NOT NULL | Status Code of the Expected Outcome |
| | | Allowable Values: |
| | | ACTIVE |
| | | INACTIVE |
| | | RESOLVED |
| | | ERRONEOUS |
HasRevisionHistory | smallint | NULL | Expected Outcome information was revised |
| | | Allowable Values: |
| | | 0 / Null - False |
| | | 1 - True |
LastCngSeqNo | int | NOT NULL | Number of times this expected outcome was changed(Initial creation value will be 1) |
HasActualOutcomeAndVisitDeleted | smallint | NULL | The patient visit associated with this outcome has been cancelled/deleted AND an actual outcome was assigned |
| | | Allowable Values: |
| | | 0 / Null - False |
| | | 1 - True |
Patient_oid | int | NOT NULL | Object ID of the Patient(HPatient) the expected outcome information is associated with |
PatientVisit_oid | int | NULL | Object ID of the patient visit(HPatientVisit) |
| | | Object ID of the patient visit(HPatientVisit) the expected outcome information is associated with |
| | | Valued when the Expected Outcome is associated with a Visit |
| | | Null when: |
| | | - The Expected Outcome is associated at the Patient Level and not a specific visit |
| | | - The Patient's Visit this Expected Outcome had been associated with was Canceled / Deleted so this Expected Outcome is no longer associated with a specific visit but is still associated to the Patient |
ChangedBy_oid | int | NOT NULL | Object ID of the User making a change to the expected outcome information(HSUser) |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|
|