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 1412. 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 | Not Valued in this table. Column exists as part of persistence framework implementation. |
IsDeleted | tinyint | NOT NULL | Specifies whether the record is soft deleted. |
| | | Allowable Values |
| | | 0 - Active |
| | | 1 - Marked as Deleted. |
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 HServiceDetail_Ver. |
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. |
MinimumTimeBetweenServices | int | NULL | When the Order for the same service for the same HCU is placed and duplicate check indicator is on, the value stored on this attribute is used to validate whether Order should be allowed to place again. |
UnitOfMinimumTimeBetweenServices | varchar(16) | NULL | holds the unit of Minimum Time Between Services.Valued from Name field of Dictionary Item of Type OaR.EnumDuration.This is system defined DDI and can't be changed by user. |
UnitOfMinimumTimeBetweenServicesCode | smallint | NULL | Code for unit of Minimum Time Between Services. Valued from ItemCode field of Dictionary Item of Type OaR.EnumDuration.This is system defined DDI and can't be changed by user. |
RequiresScheduling | bit | NULL | determines if the service is schedule-able or not. Not used in Clinical workflows |
PatientPresenceRequired | bit | NULL | whether patient must be presence to have the test performed. Not used in Clinical workflows |
PatientCanPerform | bit | NULL | whether patient can perform the service. Not used in Clinical workflows |
DuplicateCheck | bit | NULL | whether service can undergo duplicate checking. Allowable Values: 0 - False, 1 - True. |
MaximumDuration | smallint | NULL | the maximum duration for the service. A licensed person who is authorized to place an order can check the order duration entered or calculated against this value and issues a message if the user is over the maximum duration permitted |
UnitOfMaximumDuration | varchar(16) | NULL | holds the unit of Maximum duration. Valued from Name field of Dictionary Item of Type OaR.EnumDuration.This is system defined DDI and can't be changed by user. |
UnitOfMaximumDurationCode | smallint | NULL | holds the code of the unit of Maximum duration. Valued from ItemCode field of Dictionary Item of Type OaR.EnumDuration.This is system defined DDI and can't be changed by user. |
ReasonForRequestRequired | bit | NULL | whether the reason for request should be charted or not during during order entry. Allowable Values: 0 - False, 1 - True. |
IndividuallyOrderable | bit | NULL | whether the order can be placed individually. |
| | | Allowable Values : |
| | | 0 - Order for the service can't be placed individually but only as part of a set. |
| | | 1 - Order for the service can be placed individually. |
ServiceDescriptionOverrider | bit | NULL | whether user is able to change the Name of the Order on the Order Detail Form during order entry. Allowable Value: 0-False, 1-True |
MustReviewIndicator | bit | NULL | Whether the user should review the details of the order for the service during order entry.Allowable Value: 0-False, 1-True |
Chargeable | bit | NULL | Whether the service is chargeable. Allowable Value: 0-False, 1-True |
ChargeCode | varchar(32) | NULL | Primary Charge Description Master Code |
HasMaterials | bit | NULL | whether the service has materials . Allowable Value: 0-False, 1-True |
StartDateTime | smalldatetime | NULL | Start date time since when the detail of the service became active. |
EndDateTime | smalldatetime | NULL | End date time till when the detail of the service will be active. |
ObsoleteDateTime | smalldatetime | NULL | Date time when the detail of the service was made obsolete. |
MedicalNecessityRequired | bit | NULL | Whether Order for the service should undergo Medical Necessity Check. Allowable Value: 0-False, 1-True |
AutomaticCreditIndicator | bit | NULL | Whether the Chargeable service allows automatic Credits. Allowable Value: 0-False, 1-True |
ChargeDescriptionOverrideIndicator | bit | NULL | Whether user can modify the charge description. Allowable Value: 0-False, 1-True |
TimeChargeIndicator | bit | NULL | Whether the service will be time charged. |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True |
PriorityIndicator | varchar(32) | NULL | Default Priority on the order entry. If an order is of high priority, indicates that it must be performed immediately. |
PriorityIndicatorCode | smallint | NULL | Indicates the code associated with the priority. |
| | | Allowable Values: |
| | | 0 - Routine |
| | | 1 - Timing Critical |
| | | 2 - Now Routine |
| | | 3 - As Soon As possible |
| | | 4 - Preoperative |
| | | 5 - Call Back |
| | | 6 - Stat |
TransportIndicator | varchar(32) | NULL | whether a transportation charge should be applied for the service, and how to apply the transportation charge |
TransportIndicatorCode | smallint | NULL | Code for the Transport Indicator |
| | | Allowable values: |
| | | 0= no charge(Default) |
| | | 1= charge 1X for order |
| | | 2= Apply charge 1X for each member |
| | | 3= Apply charge 1X for each quantity |
MethodIndicator | varchar(32) | NULL | whether a method charge should be applied for the service |
MethodIndicatorCode | smallint | NULL | Code for the Method Indicator |
| | | Allowable values: |
| | | 0= no charge(Default) |
| | | 1= charge 1X for order |
| | | 2= Apply charge 1X for each member |
| | | 3= Apply charge 1X for each quantity |
SecondaryChargeDescriptionMasterCode | varchar(32) | NULL | Secondary Charge Description Master Code. |
ChargeForEachMemberInPackage | bit | NULL | Whether each member in package should be charged.Allowable Value: 0-False, 1-True |
MaxOrderableQuantity | int | NULL | Maximum orderable quantity of the service. |
UnitOfQuantity | varchar(16) | NULL | Unit for Maximum orderable quantity |
IsRestricted | tinyint | NULL | Whether the service is restricted. Order for restricted services are only visible to the clinical users who have enough security privileges to view them. |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True |
Instructions | varchar(255) | NULL | Freetext instructions for performing the service. If valued ,will get defaulted on the order during order entry. |
LevelOfSignature | tinyint | NULL | Signature levels can be 0-9 and set at User's security settings. This field represents the level of signature required for this service to be Co-signed by the user. It's applicable only when CoSignatureRequired field is True. |
NumberOfSignature | tinyint | NULL | Number of signatures required for the order to become active or co-signed. |
ContrastIndicator | bit | NULL | Whether the service requires contrast media e.g. dye .It serves as warning to service provider.Allowable Value: 0-False, 1-True |
SubVisitRequired | bit | NULL | whether sub visit processing is required for service or not.Allowable Value: 0-False, 1-True |
SubVisitIndicator | varchar(255) | NULL | Indicator describing how the sub visit should be created when order is placed. |
SubVisitIndicatorCode | smallint | NULL | Code for the Sub Visit Indicator |
| | | Allowable Values: |
| | | 0 - No Sub Visit |
| | | 1 - Add Sub Visit |
| | | 2 - Add Sub Visit per day |
| | | 3 - Add Sub Visit always |
| | | 4 - New Sub Visit |
LevelOfSignatureForActive | tinyint | NULL | Signature levels can be 0-9 and set at User's security settings. This field represents the level of signature required for this service to be Activated. It's applicable only when CoSignatureRequired field is True. |
AcknowledgeRequired | bit | NULL | Whether the order for the service is required to be acknowledged. |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True |
CoSignatureRequired | bit | NULL | Whether the order for the service is required to be co-signed. |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True |
DefaultServiceProviderType | varchar(20) | NULL | Valued from Dictionary Item of Type OaR.DefaultServiceProviderType.This is system defined DDI and can't be changed by user. Represents the type of the default service provider set on the service. |
DefaultServiceProviderTypeCode | smallint | NULL | Code for the Default Service Provider Type. It's the ItemCode field of the DDI |
| | | Allowable Values: |
| | | 0 - Service requestor |
| | | 1 - Service provider |
| | | 2 - Other. |
UnitOfMinQtyOfSpecimenRequired | varchar(16) | NULL | Unit for the Minimum Quantity of specimen required. |
SpecimenRequired | bit | NULL | Whether the specimen sample is required to be collected for this service. |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True |
MinQtyOfSpecimenRequired | Varchar(12) | NULL | The minimum quantity of the specimen sample required to be collected. |
StrainType | bit | NULL | Whether service is of strain type or not. For strain type services, the system mandates that enddatetme be valued while capturing sample collection. |
| | | Allowable Values |
| | | 0 - False |
| | | 1 - True. |
SampleCollector | varchar(20) | NULL | who(unit) will be the sample collector. eg ServiceRequestor,ServiceProvider or None |
SampleCollectorCode | smallint | NULL | Code for the Sample Collector |
| | | Allowable Value: |
| | | 0 - Service Requestor . On Order entry , this will default the Medically responsible unit(MRU) of the Visit as Sample Collector |
| | | 1 - Service Provider. On Order entry ,this will default the service provider defaulted on the order as sample collector |
| | | 2 - None . On Order entry , system will look at the Default Sample Collector preference under Log Specimen Collection category for defaulting the sample collector on the order. |
ValidityStatus | varchar(16) | NULL | Validity status of the service. eg Active,Inactive etc |
ValidityStatusCode | smallint | NULL | Code for the Validity Status of the service |
| | | Allowable Values: |
| | | 0 - Active |
| | | 1 - Inactive |
| | | 2 - Incomplete |
| | | 3 - Obsolete |
DefaultServiceProvider_oid | int | NULL | ObjectID of HHealthcareUnit table. Represents the default service provider set in the Service Provider tab of service catalog. |
Service_oid | int | NOT NULL | ObjectID of HService table , to which this detail is linked to. |
Specimen_oid | int | NULL | ObjectID of HSpecimen table. It's the defaulted specimen on the service. |
ViewableInInterventionWkl | bit | NULL | Whether the order for the service will be available for Intervention charting. Allowable Value: 0-False, 1-True |
PriceOverrideIndicator | bit | NULL | Whether the system will allow to override the price of the service on the CHarge UI. Allowable Value: 0-False, 1-True |
UnitCodeForMinQtyOfSpecimen | varchar(16) | NULL | Code for the Unit of Minimum quantity of specimen required. |
UnitCodeForQuantity | varchar(16) | NULL | Unit code for the quantity of the service. |
MedNecFrequencyIndicator | bit | NULL | whether the frequency information is to be considered while processing medical necessity check for a service. Allowable Value: 0-False, 1-True |
MedNecDuration | smallint | NULL | Duration for the Frequency check.This is used to check whether the order is performed in the given duration or not |
MedNecDurationUnitCode | smallint | NULL | Duration unit code for the frequency check. |
AsWrittenDescription | varchar(300) | NULL | Service as written |
Reqmanualcharge | Char(1) | NOT NULL | Whether the service requires to be manually charged. Allowable Value: 0-False, 1-True |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|