Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
|
PtOutcomeHistoryOID | int | NOT NULL | Object ID of the Expected Outcome History Row |
PtExpectedOutcome_oid | int | NOT NULL | Object ID of the Expected Outcome this change is associated with |
PtActualOutcome_oid | int | NULL | Object ID of the Actual Outcome associated with this Expected Outcome |
| | | When Null, an Actual Outcome has not been assigned |
Action | varchar(254) | NOT NULL | Action made on the Outcome for the history entry |
| | | Allowable Values: |
| | | ADDED |
| | | CHARTED |
| | | REVISED |
ChartingStatus | varchar(254) | NULL | Charting Status value for the history entry |
| | | Allowable Values: |
| | | Improved |
| | | Met |
| | | Not Met |
| | | Progressing |
StatusCd | varchar(32) | NULL | Status code |
| | | Allowable Values: |
| | | NULL |
| | | ACTIVE |
| | | INACTIVE |
ChangeDateTime | smalldatetime | NOT NULL | Date and time(Local) the information for this Expected Outcome was updated |
ChangedByOid | int | NOT NULL | Object ID of the User making a change to the information for this Expected Outcome(HSUser) |
ChangedByName | varchar(188) | NOT NULL | Name of the User making a change to the information for this Expected Outcome Parameter |
LastCngSeqNo | int | NOT NULL | Number of times this problem has been changed(Initial creation value will be 1) |
|
|