Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object Identifier of this record. This field is a primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1503. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application. |
RecordId | int | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
Description | varchar(1) | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
IsVersioned | bit | NOT NULL | Whether the table data is Versioned or not. |
| | | Allowable Values: |
| | | 0 - No version data captured. |
| | | 1 - Version changes available in _Ver table. |
| | | Once this field is set to 1, you cannot reset it to 0. If value is 1 , the current row represents the latest state , and all version data will be present in another table with the name HExtendedOrder_Ver. |
| | | Note: The presence of this field in tables depends on the configuration at the time of table design. |
CreatedUserId | int | NULL | Object ID of the logged in user who created this record. |
| | | This field is linked to HSUser table to get details about the user. For more information see description of HSUser table |
CreationTime | smalldatetime | NULL | Date and time when the record is created. |
UserDefinedDateTime1 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime2 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime3 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime4 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime5 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime6 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime7 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime8 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime9 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime10 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime11 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime12 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime13 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime14 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime15 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime16 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime17 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime18 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime19 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedDateTime20 | smalldatetime | NULL | Field to store extended data of type date\time. |
UserDefinedNumeric1 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric2 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric3 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric4 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric5 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric6 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric7 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric8 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric9 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric10 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric11 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric12 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric13 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric14 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric15 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric16 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric17 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric18 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric19 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric20 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric21 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric22 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric23 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric24 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric25 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric26 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric27 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric28 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric29 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric30 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric31 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric32 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric33 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric34 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric35 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric36 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric37 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric38 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric39 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric40 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric41 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric42 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric43 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric44 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric45 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric46 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric47 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric48 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric49 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedNumeric50 | int | NULL | Field to store extended data of type Numeric. |
UserDefinedDecimal1 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal2 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal3 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal4 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal5 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal6 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal7 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal8 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal9 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal10 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal11 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal12 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal13 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal14 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal15 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal16 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal17 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal18 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal19 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedDecimal20 | varchar(15) | NULL | Field to store extended data of type Decimal. |
UserDefinedString1 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString2 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString3 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString4 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString5 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString6 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString7 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString8 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString9 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString10 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString11 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString12 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString13 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString14 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString15 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString16 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString17 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString18 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString19 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString20 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString21 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString22 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString23 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString24 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString25 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString26 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString27 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString28 | varchar(90) | NULL | Field to store extended data of type String. |
UserDefinedString29 | varchar(90) | NULL | Field to store extended data of type String. |
UserDefinedString30 | varchar(90) | NULL | Field to store extended data of type String. |
UserDefinedString31 | varchar(90) | NULL | Field to store extended data of type String. |
UserDefinedString32 | varchar(90) | NULL | Field to store extended data of type String. |
UserDefinedString33 | varchar(90) | NULL | Field to store extended data of type String. |
UserDefinedString34 | varchar(90) | NULL | Field to store extended data of type String. |
UserDefinedString35 | varchar(90) | NULL | Field to store extended data of type String. |
UserDefinedString36 | varchar(90) | NULL | Field to store extended data of type String. |
UserDefinedString37 | varchar(90) | NULL | Field to store extended data of type String. |
UserDefinedString38 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString39 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString40 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString41 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString42 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString43 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString44 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString45 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString46 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString47 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString48 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString49 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString50 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString51 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString52 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString53 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString54 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString55 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString56 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString57 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString58 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString59 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString60 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString61 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString62 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString63 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString64 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString65 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString66 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString67 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString68 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString69 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString70 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString71 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString72 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString73 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString74 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString75 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString76 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString77 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString78 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString79 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString80 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString81 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString82 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString83 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString84 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString85 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString86 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString87 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString88 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString89 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString90 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString91 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString92 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString93 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString94 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString95 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString96 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString97 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString98 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString99 | varchar(255) | NULL | Field to store extended data of type String. |
UserDefinedString100 | varchar(255) | NULL | Field to store extended data of type String. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|
|