Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
|
PtProblemParameterOID | int | NOT NULL | Object ID of a Problem Parameter |
ProblemParameterCVEId | varchar(32) | NOT NULL | Common Vocabulary Engine(CVE) identifier of the Problem Parameter |
ChangeDateTime | smalldatetime | NOT NULL | Date and time(Local) the parameter was changed |
ChangedByName | varchar(188) | NOT NULL | Name of the User who made a change to this parameter(HSUser) |
DisplayName | varchar(254) | NOT NULL | Name that is displayed for this problem parameter |
DataType | varchar(20) | NOT NULL | Data Type of the value for this Problem Parameter |
| | | Allowable Values: |
| | | 1 - DateOffset |
| | | 2 - Numeric |
| | | 3 - Encoded |
| | | 4 - FreeText |
| | | 5 - Date |
| | | 6 - Partial Date |
Value | varchar(254) | NULL | Value Parameter defined in Common Vocabulary Engine(CVE) |
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 |
BehaviorCd | varchar(32) | NULL | The behavior code of the patient's expected outcome parameter name. It is dervived from the parameters ERCD code |
LastCngSeqNo | int | NOT NULL | This represents the optimistic lock column(number of updates to this row, 1 = inserted) |
PtProblem_oid | int | NOT NULL | Object ID of Patient's Problem(HPtProblem) |
SetSeqNo | int | NULL | Determines in what relative position the parameter will appear in the display |
ValDsply | int | 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 |
ChangedBy_oid | int | NOT NULL | Object ID of the User who made a change to this Problem Parameter(HSUser) |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|
|