Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
|
PtExpectedOutcomeParameterOID | int | NOT NULL | Object ID of an Expected Outcome Parameter |
ExpectedOutcomeParameterCVEId | varchar(32) | NOT NULL | Common Vocabulary Engine(CVE) Identifier of the Expected Outcome Parameter |
ChangeDateTime | smalldatetime | NOT NULL | Date and time(Local) the information for this Expected Outcome Parameter was updated |
ChangedByName | varchar(188) | NOT NULL | Name of the User who made a change to the information for this Expected Outcome Parameter |
ChangedBy_oid | int | NOT NULL | Object ID of the User who made a change to the information for this Expected Outcome Parameter(HSUser) |
DisplayName | varchar(254) | NOT NULL | Display Name of the Expected Outcome Parameter. Default value is from the Common Vocabulary Engine(CVE) definition |
DataType | varchar(20) | NOT NULL | Any of the data types as defined in the CVE |
| | | Allowable Values: |
| | | 1 - DateOffset |
| | | 2 - Numeric |
| | | 3 - Encoded |
| | | 4 - FreeText |
| | | 5 - Date |
| | | 6 - Partial Date |
Value | varchar(254) | NULL | The value of the Patient's Expected Outcome Parameter |
ValueCVEId | varchar(32) | NULL | The CVE Id for the patient's expected outcome parameter value. This is determined by the Display Name Preference of the concept in the CVE |
ValueBehaviorCd | varchar(32) | NULL | The behavior code of the patient's expected outcome parameter's value derived from the values ERCD code from CVE |
BehaviorCd | varchar(32) | NULL | The behavior code of the patient's expected outcome parameter name. It is dervived from the parameters ERCD code from CVE |
LastCngSeqNo | int | NOT NULL | This represents the optimistic lock column(number of updates to this row, 1 = inserted) |
PtExpectedOutcome_oid | int | NOT NULL | Object ID of the associate expected outcome(HPtExpectedOutcome) |
SetSeqNo | int | NULL | Determines in what relative position the parameter will appear in the display |
ValDsply | bit | NOT NULL | Determines if the attribute appears on the application detail regardless of whether or not a value is defaulted or entered |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|
|