Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
|
PtActualOutcomeOID | int | NOT NULL | Object ID of an Actual Outcome for a Patient |
ActualOutcomeChartedBy_oid | int | NOT NULL | Object ID of the User who charted the actual outcome(HSUser) |
ActualOutcomeChartedDateTime | datetime | NOT NULL | Date and time(Local) the Actual Outcome was charted for |
ActualOutcomeChartedByName | varchar(188) | NULL | Name of the User who charted the Actual Outcome(Format First Last, Title) |
ActualOutcomeStatus | varchar(254) | NOT NULL | Outcome status that was actually charted |
| | | Allowable Values: |
| | | Met |
| | | Not Met |
| | | Progressing |
| | | Improved |
| | | Stabilized |
| | | Deteriorated |
LastCngSeqNo | int | NOT NULL | Number of times this outcome has been changed(Initial creation value will be 1) |
PtExpectedOutcome_oid | int | NOT NULL | Object ID of the Patient's Expected Outcome(HPtExpectedOutcome) |
IsMarkedErroneous | smallint | NOT NULL | Actual Outcome for this Expected Outcome has been marked as erroneous |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True |
HasClinNote | smallint | NOT NULL | Are there Clinical Note(s) associated with this Outcome |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True |
ChangedBy_oid | int | NOT NULL | Object ID of the User who updated the actual outcome(HSUser) |
ChangeDateTime | smalldatetime | NOT NULL | Date and time(Local) the information was updated |
ChangedByName | varchar(188) | NOT NULL | Name of the User who made a change to the actual outcome information(Format First Last, Title) |
ActualOutcomeStatusCVEId | varchar(32) | NOT NULL | Common Vocabulary Engine(CVE) identifier for the status |
Patient_oid | int | NOT NULL | Object ID of the patient(HPatient) the acutal outcome is associated with |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|
|