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 1411. 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(64) | NULL | User-defined information provided in the application. |
IsDeleted | tinyint | NOT NULL | Specifies whether the record is soft deleted. |
| | | Allowable Values |
| | | 0 - Active |
| | | 1 - Marked as Deleted. |
IsVersioned | bit | NOT NULL | When set to True, the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0 - False, 1 - True. 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 the description of HSUser table |
CreationTime | smalldatetime | NULL | Date and time when the record is created. |
ServiceName | varchar(64) | NULL | Name of the Service. |
Abbreviation | varchar(16) | NULL | Abbreviated name of the Service. |
HasSubService | bit | NULL | Whether this definition represents a set which has child services linked to it. Allowable Values: 0 - No child services , 1 - has child services. |
ViewableInFlowsheet | bit | NULL | Whether the service can be viewed in a result flowsheet. Allowable Values: 0 - Not Viewable , 1 - Viewable. |
TypeOfDefinition | varchar(24) | NULL | The definition type of the service. ie Service, Finding or Service And Finding. |
TypeOfDefinitionCode | smallint | NULL | Code associated with the definition type of the service. |
| | | Allowable Values: |
| | | 0 - Service |
| | | 1 - Finding |
| | | 2 - Service and Finding |
IsTemplate | tinyint | NULL | Whether a finding associated with the service is system-defined. |
| | | Allowable Values: |
| | | 0 - User Defined |
| | | 1 - System Defined - no edits allowed |
| | | 2 - System Defined - Allowed to search and list in catalog browser and allow editing only the finding details of min/max value for graph. |
|
ServiceOrSetType | tinyint | NOT NULL | Whether this definition is a service or service set. |
| | | Allowable Values: |
| | | 0 - Service(when HasSubService=0) , Convenience Set( when HasSubService = 1) |
| | | 1 - Orderable Set |
| | | 2 - Predefined Meds |
| | | 3 - Predefined IV |
| | | 4 - None( if it's just a finding .i.e TypeOfDefinitionCode = 1) |
ValidityStatus | varchar(16) | NULL | Validity status of the service. |
ValidityStatusCode | smallint | NULL | Code associated with the validity status of the service. |
| | | Allowable Values: |
| | | 0 - Active |
| | | 1 - Inactive |
| | | 2 - Incomplete |
| | | 3 - Obsolete |
DefaultMediaBorrowerUnit_oid | int | NULL | Not Valued. |
DefaultMediaBorrower_oid | int | NULL | Not Valued. |
ServiceType_oid | int | NULL | ObjectID of HServiceType table. Represents the Type of service definition(eg Laboratory, Nursing etc.). |
ServiceSubType_oid | int | NULL | ObjectID of HServiceType table. Represents the Sub-Type for the service(eg Blood Bank, Microbiology etc.). |
OwningOrganization_oid | int | NULL | ObjectID of HHealthCareUnit. Represents the organization which defines this service. |
SubOwningOrganization_oid | int | NULL | ObjectID of HHealthCareUnit. Represents the sub-organization which defines this service. |
FormType | varchar(32) | NULL | The adaptable form type associated with the Orderable service. eg Assessment Page Type , Assessment Columnar Type etc. |
FormTypeCode | smallint | NULL | Code associated with the form type Data Dictionary Item. |
FormUsage | varchar(32) | NULL | Usage of form, which determines the number of fields that can be placed in adaptable form. Eg. Admission assessment or shift, Vital signs or I and O etc. |
FormUsageCode | smallint | NULL | Code associated with the form usage. |
RevisedDateTime | smalldatetime | NOT NULL | Date and time when the service was modified. |
HasRefRange | bit | NOT NULL | When set to True, indicates that the service has a reference range. |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True. |
AsWrittenDescription | varchar(300) | NULL | The description of the service as entered by the user. This information is mandatory for drug services. |
SetGroupIndicator | bit | NOT NULL | When set to True, indicates that the service, which is a part of the convenience package, can be reordered. |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True. |
IsFreeText | bit | NOT NULL | When set to True, indicates that the service is a free-text service. |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True. |
GenericName | varchar(64) | NULL | Generic name for a drug service definition. |
GenericAbbreviation | varchar(16) | NULL | Abbreviated generic name for a drug service definition. |
MedSuppInfo_oid | int | NULL | Not Valued. |
Commondefn_oid | int | NULL | Object ID of HCommonDefinition. |
FindingName | varchar(64) | NULL | Name of the finding. |
DrugIndicator | tinyint | NOT NULL | Indicates the type of drug service. |
| | | Allowable Values: |
| | | 0 - None |
| | | 1 - Route |
| | | 2 - Package |
PresentationIndicator | varchar(3) | NULL | Indicator for the type of service being processed. |
| | | Allowable Values: |
| | | NRS - Nursing |
| | | CRD - CDMS - will not be valued any more |
| | | DG - Intervention orders. |
| | | Null - If nothing from above |
Orderable | bit | NULL | When set to 1, indicates that the service can be ordered. |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True. |
LRIndicatorRequired | bit | NOT NULL | Whether the user should be required to indicate the left or the right side when placing an order for a service. |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True. |
ExpandSet | bit | NOT NULL | When set to 1, indicates that the set should be expanded by default. |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True. |
SingleSelect | smallint | NULL | Whether the convenience set is single select or not. |
| | | Allowable Values: |
| | | 0 or NULL - False |
| | | 1 - True. |
IndentItems | smallint | NULL | Whether the items in convenience set are indented or not. |
| | | Allowable Values: |
| | | 0 or NULL - False |
| | | 1 - True. |
IsPediatric | TINYINT | NULL | 1 if the service is intended for Pediatric patient, 0(default) otherwise. |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True. |
ServiceNameAI | AS | ServiceName COLLATE | Accent Insensitive column for ServiceName. |
AbbreviationAI | AS | Abbreviation COLLATE | Accent Insensitive column for Abbreviation. |
LinkTypeName | varchar(64) | NULL | Name of the Link Type the service belongs to. |
DisplayAsOrderSet | TINYINT | NULL | Whether the set is displayable as an order set, meaning will be picked up in the current orders sort by order set view. Allowable Values: 0 - False , 1 - True |
CancelPACheck | bit | NULL | When canceling no visit pending activation order, whether a check will be performed at the service level when the order type preference is enabled. Allowable Values: 0 - False , 1 - True |
DaysToCancelPANoVisitOrder | smallint | NULL | Number of Days after which no visit pending activation orders for this service can be canceled by the Job, if CancelPACheck is enabled. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|