Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object ID of the object(such as patient, order, etc.). This field is always a primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | HFC(Healthcare Foundation Class) ID of the object. Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application. |
RecordId | int | NULL | Record ID of the patient. |
Description | varchar(255) | NULL | Not Used |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified |
IsDeleted | tinyint | NOT NULL | Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted) |
CreatedUserId | int | NULL | Object ID of the user who created the object. This field is linked to HSUser table to get details about the user. For more information on HSUser table. |
CreationTime | smalldatetime | NULL | Date and time when the object is created. |
Code | varchar(30) | NULL | Unique code of the diagnosis of the patient's ailment. |
CodeDescription | varchar(255) | NULL | Description of the code associated with the diagnosis of the patient's ailment. |
Type | tinyint | NULL | Diagnosis type. Allowable Values: 0, 1, 2, 3, 4, or NULL Key of allowable values: 0 - RegistrationDiagnosis 1 - AdmittingDiagnosis 2 - WorkingDiagnosis 3 - DischargeDiagnosis 4 - BillingDiagnosis |
IsPrimary | bit | NULL | When set to True, indicates that the diagnosis of the patient's ailment is the primary diagnosis Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True |
Priority | int | NULL | Priority of the diagnosis. The diagnosis of a patient's ailment is assigned a priority. If the priority is high, indicates that the patient requires immediate medical attention. Allowable Values: For Germany: 0, 1, 2, 3, 4, 5, 6, or NULL Key of allowable values: 0 - Stat 1 - ASAP(As Soon As Possible) 2 - Routine 3 - Preop 4 - Callback 5 - TimingCritical 6 - PRN(As needed) For USA: 1, 2, or NULL Key of allowable values: 1 - Primary 2 - Secondary |
Release | varchar(10) | NULL | Release number of the set of the International Classification of Diseases(ICD) codes to which the diagnosis belongs. Each release of ICD codes is assigned a release number and contains a set of ICD codes. One or more diagnosis can belong to one or more releases. For example, consider that the release numbers assigned to the two sets of ICD codes are ICD-1 and ICD- 2. Consider that the diagnosis of patient P1 is Diagnosis1 and those of patient P2 are Diagnosis2 and Diagnosis3. Diagnosis1 and Diagnosis3 belong to ICD-1and Diagnosis2 belongs to ICD-2. |
Version | varchar(10) | NULL | Version number of the set of the International Classification of Diseases(ICD) codes to which the diagnosis belongs. Each release of ICD codes is assigned a release number and contains a set of ICD codes. A version number is assigned to the release number when the same set of ICD codes is release with minor modifications. The version number always follows the release number. One or more diagnosis can belong to one or more releases. For example, consider that the release numbers assigned to the two sets of ICD codes are ICD-1.1 and ICD- 2.2. The version numbers in these are '. 1' and '. 2', respectively. Consider that the diagnosis of patient P1 is Diagnosis1 and those of patient P2 are Diagnosis2 and Diagnosis3. Diagnosis1 and Diagnosis3 belong to ICD-1.1 and Diagnosis2 belongs to ICD-2.2. |
StartDate | datetime | NULL | Date and Time on which the diagnosis of the patient's ailment starts. |
EndDate | datetime | NULL | Date and Time on which the diagnosis of the patient's ailment ends. |
Comments | varchar(255) | NULL | Comments entered by the user related to the diagnosis of the patient's ailment. |
IsPreliminary | bit | NULL | When set to True, indicates that the diagnosis of the patient's ailment is in preliminary stage. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True |
IsExtension | bit | NULL | When set to True, indicates that the complete diagnosis of the patient's ailment would take longer time than anticipated. This would require the patient to stay in the hospital longer than usual. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True |
IsNurse | bit | NULL | When set to True, indicates that the nurse would diagnose the patient's ailment. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True |
LinkType | varchar(1) | NULL | Specify how different diagnoses are linked together. For example, the different diagnoses could be linked together either by * or by |. The application uses the value stored in this field to identify a parent or sub-diagnosis. |
AssignedBy | varchar(190) | NULL | Name of the physician who would diagnose the patient's ailment. |
ParentDiagnosisOID | int | NULL | Object ID of the parent diagnosis for linked diagnosis. For the regular diagnosis, this field stores NULL. |
ExternalID | varchar(10) | NULL | ID of the diagnosis that belongs to a third-party application. |
IsHMD | bit | NULL | When set to True, indicates that the diagnosis belongs to Hospital Main Diagnosis. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True |
DiagnosisStatus | int | NULL | Status of the diagnosis of the patient's ailment. The value stored in this field communicates to the Connectivity module whether the diagnosis is newly added, modified, or deleted. Allowable Values: 0, 1, 2, or NULL Key of allowable values: 0 - Added 1 - Modified 2 - Deleted |
Localization | int | NULL | Localization for diagnosis and procedure. For example, if a patient's elbow needs surgery, LeftLocalization could mean that the surgical procedure needs to be performed on the patient's left elbow. Allowable Values: 0, 1,2 ,3, or NULL Key of allowable values: 0 - NoLocalization 1 - LeftLocalization 2 - RightLocalization 3 - BothLocalization |
AssociatedUnitOID | int | NULL | Object ID of the unit associated with the patient who is diagnosed. |
ParentExternalID | varchar(10) | NULL | External ID of the parent diagnosis for linked diagnosis. For the regular diagnosis, this field stores NULL. |
Visit_oid | int | NULL | Value stored as a result of a one-to-many relationship between HDiagnosis and HPatientVisit. |
ExternalObjectID | int | NULL | Object ID provided a Soarian module. |
ExternalObjectType | varchar(64) | NULL | Type of the external object. This is a data dictionary item. |
LastCngDtime | datetime | NULL | Current Universal Time Coordinate or Greenwich Mean Time when object was changed.. |
Certainty | varchar(20) | NULL | Indicates that the diagnosis information was received in inbound transactions. |
DiagnosisMainType | varchar(1) | NULL | Value that says whether the diagnosis unit is hospital specific or department specific. |
DiagType | smallint | NULL | Differentiates between Liftetime Cancer Diagnosis(Patient Level) and Visit Level Diagnosis. Lifetime Cancer Diagnosis is valued with DiagType "Lifetime". Visit Level Diagnosis is valued "Financial" |
Stage | varchar(64) | NULL | Lifetime Cancer Diagnosis attribute which provides stage and stage type(Pathologic or Clinical). |
Status | varchar(32) | NULL | Diagnosis status code. Allowable values are ACTIVE/INACTIVE/RESOLVED/ERRONEOUS/NULL. For ERRONEOUS diagnosis we automatically set its IsDeleted=1, and further ensure that ERRONEOUS diagnoses are NOT purged. |
PatientOID | int | NOT NULL | Object ID of the patient. This is same as the value stored in ObjectID in HPatient. |
ClinDiagTypeOID | int | NULL | Lifetime Cancer Diagnosis attribute. |
ClinDiagName | varchar(128) | NULL | Lifetime Cancer Diagnosis Name(User Can search on this and it displays on UI) |
VisitMoveNumber | varchar(75) | NULL | Move number of visit. A move occurs in a SAP external system, frequently when a patient changes MRU. For non-SAP users, this column should always be NULL. |
ShortDescription | varchar(70) | NULL | De-normalized Short description of the ICD code. Introduced after moving from ICD9 to ICD10 |
SnomedCode | varchar(32) | NULL | Snomed Code value of the Diagnosis / It could be NULL |
SnomedDesc | varchar(256) | NULL | Snomed Description value of the Diagnosis / It could be NULL |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|