Arabic: قائمة تكاليف طبية غير مباشرة - قوائم تكاليف طبية غير مباشرة English: Medical Overhead List - Medical Overhead Lists
overheadListAccommDetails (HMSOverheadListAccommLine) , overheadListAttendantDetails (HMSOverheadListAttendantLine) , overheadListBloodDetails (HMSOverheadListBloodLine) , overheadListCheckDetails (HMSOverheadListCheckLine) , overheadListLabTestDetails (HMSOverheadListLabTestLine) , overheadListPharmacyDetails (HMSOverheadListPharmacyLine) , overheadListPhyDetails (HMSOverheadListPhyLine) , overheadListRadiologyDetails (HMSOverheadListRadiologyLine) , overheadListServiceDetails (HMSOverheadListServiceLine) , overheadListSupervisionDetails (HMSOverheadListSupervisionLine) , overheadListSupplyDetails (HMSOverheadListSupplyLine) , overheadListSurgeryDetails (HMSOverheadListSurgeryLine)
Fields
Property
Column
Arabic
English
Type
Foreign Table
analysisSetId
analysisSet_id
ID
branchId
branch_id
Branch ID
Branch ID
ID
code
code
الكود
Code
Text
colorCode
colorCode
كود اللون
Color Code
Color
commitedBefore
commitedBefore
تم الحفظ مسبقا
Commited Before
Boolean
companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
createTransactionId
createTransactionId
Text
creationDate
creationDate
تاريخ الإنشاء
Creation Date
DateAndTime
currentVersion
currentVersion
النسخة الحالية
Current Version
Integer
customViewName
customViewName
Text
date1
date1
تـــاريخ 1
Date 1
Date
date2
date2
تـــاريخ 2
Date 2
Date
date3
date3
تاريخ 3
Date3
Date
date4
date4
تاريخ 4
Date4
Date
date5
date5
تاريخ 5
Date5
Date
departmentId
department_id
ID
description1
description1
الوصف 1
description1
Text
description2
description2
الوصف 2
description2
Text
description3
description3
الوصف 3
description3
Text
description4
description4
الوصف 4
description4
Text
description5
description5
الوصف 5
description5
Text
draftCreated
draftCreated
تم إنشاء مسودة
Draft Created
Boolean
draftXML
draftXML
BigText
entitySystemEntryId
entitySystemEntry_id
ID
entityType
entityType
النوع
Entity Type
EntityType
firstAuthorId
firstAuthor_id
ID
generatedByLine
generatedByLine
كود سطر الإنشاء
generated By Line
Text
generatedDocsCount
generatedDocsCount
Integer
generatedFrom
generatedFromActualCode, generatedFromCode, generatedFromEntityType, generatedFromId
تم إنشاؤه من
Generated From
Genericreference
hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
id
id
ID
indexInParent
indexInParent
Integer
lastChangeVersion
lastChangeVersion
Integer
lastModifyTransactionId
LastModifyTransactionId
Text
lastUpdateDate
lastUpdateDate
تاريخ اخر تحديث
Last update Date
DateAndTime
legalEntityId
legalEntity_id
ID
lockVersion
lockVersion
Integer
medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
n1
n1
رقم 1
Number 1
Decimal
n2
n2
رقم 2
Number 2
Decimal
n3
n3
رقم 3
Number 3
Decimal
n4
n4
رقم 4
Number 4
Decimal
n5
n5
رقم 5
Number 5
Decimal
name1
name1
الاسم العربي
Name1
Text
name2
name2
الاسم الإنجليزي
Name2
Text
parentCode
parentCode
Text
patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
preventUsage
preventUsage
منع الاستعمال
Prevent Usage
Boolean
printCount
printCount
عدد مرات الطباعة
Print Count
Integer
priority
priority
الأولوية
Priority
Long
ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1
Genericreference
ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2
Genericreference
ref3
ref3ActualCode, ref3Code, ref3EntityType, ref3Id
مرجع 3
Reference 3
Genericreference
ref4
ref4ActualCode, ref4Code, ref4EntityType, ref4Id
مرجع 4
Reference 4
Genericreference
ref5
ref5ActualCode, ref5Code, ref5EntityType, ref5Id
مرجع 5
Reference 5
Genericreference
remarks
remark
ملاحظات
Description
BigText
revised
primitiveValue
تمت المراجعة
Revised
Boolean
sectorId
sector_id
ID
systemGeneratedCodePrefix
systemGeneratedCodePrefix
System Generated Code Prefix
System Generated Code Prefix
Text
updateCapabilityId
updateCapability_id
ID
usageCapabilityId
usageCapability_id
ID
validFrom
validFrom
صالح من
Valid from
Date
validTo
validTo
صالح حتي
Valid to
Date
viewCapabilityId
viewCapability_id
ID
overheadListAccommDetails ( - )
Table Name: HMSOverheadListAccommLine, Join Column: hMSOverheadList_id
Property
Column
Arabic
English
Type
Foreign Table
overheadListAccommDetails.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
overheadListAccommDetails.costPercentage
costPercentage
% التكلفة
Cost Percentage
Decimal
overheadListAccommDetails.costValue
costValue
قيمة التكلفة
Cost Value
Decimal
overheadListAccommDetails.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
overheadListAccommDetails.id
id
ID
overheadListAccommDetails.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class
Reference
overheadListAccommDetails.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class
Reference
overheadListAccommDetails.lineNumber
lineNumber
Integer
overheadListAccommDetails.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
overheadListAccommDetails.overheadItem
overheadItem_id
بند تكلفة طبية غير مباشرة
Overhead Item
Reference
overheadListAccommDetails.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission
Reference
overheadListAccommDetails.patientClass
patientClass_id
فئة المريض
Patient Classification
Reference
overheadListAccommDetails.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
overheadListAccommDetails.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1
Reference
overheadListAccommDetails.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2
Reference
overheadListAccommDetails.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3
Reference
overheadListAccommDetails.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4
Reference
overheadListAccommDetails.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5
Reference
overheadListAccommDetails.pricingData.roomClassification
roomClassification_id
تصنيف الغرفة
Room Classification
Reference
overheadListAccommDetails.priority
priority
الأولوية
Priority
Long
overheadListAccommDetails.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary
Genericreference
overheadListAccommDetails.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification
Reference
overheadListAccommDetails.validFrom
validFrom
صالح من
Valid from
Date
overheadListAccommDetails.validTo
validTo
صالح حتي
Valid to
Date
overheadListAttendantDetails ( - )
Table Name: HMSOverheadListAttendantLine, Join Column: hMSOverheadList_id
Property
Column
Arabic
English
Type
Foreign Table
overheadListAttendantDetails.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
overheadListAttendantDetails.costPercentage
costPercentage
% التكلفة
Cost Percentage
Decimal
overheadListAttendantDetails.costValue
costValue
قيمة التكلفة
Cost Value
Decimal
overheadListAttendantDetails.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
overheadListAttendantDetails.id
id
ID
overheadListAttendantDetails.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class
Reference
overheadListAttendantDetails.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class
Reference
overheadListAttendantDetails.lineNumber
lineNumber
Integer
overheadListAttendantDetails.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
overheadListAttendantDetails.overheadItem
overheadItem_id
بند تكلفة طبية غير مباشرة
Overhead Item
Reference
overheadListAttendantDetails.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission
Reference
overheadListAttendantDetails.patientClass
patientClass_id
فئة المريض
Patient Classification
Reference
overheadListAttendantDetails.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
overheadListAttendantDetails.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1
Reference
overheadListAttendantDetails.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2
Reference
overheadListAttendantDetails.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3
Reference
overheadListAttendantDetails.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4
Reference
overheadListAttendantDetails.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5
Reference
overheadListAttendantDetails.pricingData.roomClassification
roomClassification_id
تصنيف الغرفة
Room Classification
Reference
overheadListAttendantDetails.priority
priority
الأولوية
Priority
Long
overheadListAttendantDetails.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary
Genericreference
overheadListAttendantDetails.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification
Reference
overheadListAttendantDetails.validFrom
validFrom
صالح من
Valid from
Date
overheadListAttendantDetails.validTo
validTo
صالح حتي
Valid to
Date
overheadListBloodDetails ( - )
Table Name: HMSOverheadListBloodLine, Join Column: hMSOverheadList_id
Property
Column
Arabic
English
Type
Foreign Table
overheadListBloodDetails.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
overheadListBloodDetails.costPercentage
costPercentage
% التكلفة
Cost Percentage
Decimal
overheadListBloodDetails.costValue
costValue
قيمة التكلفة
Cost Value
Decimal
overheadListBloodDetails.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
overheadListBloodDetails.id
id
ID
overheadListBloodDetails.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class
Reference
overheadListBloodDetails.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class
Reference
overheadListBloodDetails.lineNumber
lineNumber
Integer
overheadListBloodDetails.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
overheadListBloodDetails.overheadItem
overheadItem_id
بند تكلفة طبية غير مباشرة
Overhead Item
Reference
overheadListBloodDetails.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission
Reference
overheadListBloodDetails.patientClass
patientClass_id
فئة المريض
Patient Classification
Reference
overheadListBloodDetails.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
overheadListBloodDetails.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1
Reference
overheadListBloodDetails.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2
Reference
overheadListBloodDetails.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3
Reference
overheadListBloodDetails.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4
Reference
overheadListBloodDetails.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5
Reference
overheadListBloodDetails.priority
priority
الأولوية
Priority
Long
overheadListBloodDetails.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary
Genericreference
overheadListBloodDetails.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification
Reference
overheadListBloodDetails.validFrom
validFrom
صالح من
Valid from
Date
overheadListBloodDetails.validTo
validTo
صالح حتي
Valid to
Date
overheadListCheckDetails ( - )
Table Name: HMSOverheadListCheckLine, Join Column: hMSOverheadList_id
Property
Column
Arabic
English
Type
Foreign Table
overheadListCheckDetails.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
overheadListCheckDetails.costPercentage
costPercentage
% التكلفة
Cost Percentage
Decimal
overheadListCheckDetails.costValue
costValue
قيمة التكلفة
Cost Value
Decimal
overheadListCheckDetails.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
overheadListCheckDetails.id
id
ID
overheadListCheckDetails.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class
Reference
overheadListCheckDetails.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class
Reference
overheadListCheckDetails.lineNumber
lineNumber
Integer
overheadListCheckDetails.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
overheadListCheckDetails.overheadItem
overheadItem_id
بند تكلفة طبية غير مباشرة
Overhead Item
Reference
overheadListCheckDetails.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission
Reference
overheadListCheckDetails.patientClass
patientClass_id
فئة المريض
Patient Classification
Reference
overheadListCheckDetails.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
overheadListCheckDetails.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1
Reference
overheadListCheckDetails.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2
Reference
overheadListCheckDetails.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3
Reference
overheadListCheckDetails.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4
Reference
overheadListCheckDetails.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5
Reference
overheadListCheckDetails.pricingData.medicalSpecialty
medicalSpecialty_id
التخصص الطبي
Medical Specialty
Reference
overheadListCheckDetails.priority
priority
الأولوية
Priority
Long
overheadListCheckDetails.procedureType
procedureType_id
نوع الإجراء
Procedure Type
Reference
overheadListCheckDetails.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary
Genericreference
overheadListCheckDetails.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification
Reference
overheadListCheckDetails.validFrom
validFrom
صالح من
Valid from
Date
overheadListCheckDetails.validTo
validTo
صالح حتي
Valid to
Date
overheadListLabTestDetails ( - )
Table Name: HMSOverheadListLabTestLine, Join Column: hMSOverheadList_id
Property
Column
Arabic
English
Type
Foreign Table
overheadListLabTestDetails.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
overheadListLabTestDetails.costPercentage
costPercentage
% التكلفة
Cost Percentage
Decimal
overheadListLabTestDetails.costValue
costValue
قيمة التكلفة
Cost Value
Decimal
overheadListLabTestDetails.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
overheadListLabTestDetails.id
id
ID
overheadListLabTestDetails.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class
Reference
overheadListLabTestDetails.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class
Reference
overheadListLabTestDetails.lineNumber
lineNumber
Integer
overheadListLabTestDetails.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
overheadListLabTestDetails.overheadItem
overheadItem_id
بند تكلفة طبية غير مباشرة
Overhead Item
Reference
overheadListLabTestDetails.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission
Reference
overheadListLabTestDetails.patientClass
patientClass_id
فئة المريض
Patient Classification
Reference
overheadListLabTestDetails.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
overheadListLabTestDetails.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1
Reference
overheadListLabTestDetails.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2
Reference
overheadListLabTestDetails.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3
Reference
overheadListLabTestDetails.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4
Reference
overheadListLabTestDetails.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5
Reference
overheadListLabTestDetails.pricingData.testType
testType_id
نوع التحليل
Laboratory Test Type
Reference
overheadListLabTestDetails.priority
priority
الأولوية
Priority
Long
overheadListLabTestDetails.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary
Genericreference
overheadListLabTestDetails.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification
Reference
overheadListLabTestDetails.validFrom
validFrom
صالح من
Valid from
Date
overheadListLabTestDetails.validTo
validTo
صالح حتي
Valid to
Date
overheadListPharmacyDetails ( - )
Table Name: HMSOverheadListPharmacyLine, Join Column: hMSOverheadList_id
Property
Column
Arabic
English
Type
Foreign Table
overheadListPharmacyDetails.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
overheadListPharmacyDetails.costPercentage
costPercentage
% التكلفة
Cost Percentage
Decimal
overheadListPharmacyDetails.costValue
costValue
قيمة التكلفة
Cost Value
Decimal
overheadListPharmacyDetails.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
overheadListPharmacyDetails.id
id
ID
overheadListPharmacyDetails.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class
Reference
overheadListPharmacyDetails.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class
Reference
overheadListPharmacyDetails.lineNumber
lineNumber
Integer
overheadListPharmacyDetails.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
overheadListPharmacyDetails.overheadItem
overheadItem_id
بند تكلفة طبية غير مباشرة
Overhead Item
Reference
overheadListPharmacyDetails.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission
Reference
overheadListPharmacyDetails.patientClass
patientClass_id
فئة المريض
Patient Classification
Reference
overheadListPharmacyDetails.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
overheadListPharmacyDetails.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1
Reference
overheadListPharmacyDetails.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2
Reference
overheadListPharmacyDetails.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3
Reference
overheadListPharmacyDetails.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4
Reference
overheadListPharmacyDetails.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5
Reference
overheadListPharmacyDetails.priority
priority
الأولوية
Priority
Long
overheadListPharmacyDetails.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary
Genericreference
overheadListPharmacyDetails.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification
Reference
overheadListPharmacyDetails.validFrom
validFrom
صالح من
Valid from
Date
overheadListPharmacyDetails.validTo
validTo
صالح حتي
Valid to
Date
overheadListPhyDetails ( - )
Table Name: HMSOverheadListPhyLine, Join Column: hMSOverheadList_id
Property
Column
Arabic
English
Type
Foreign Table
overheadListPhyDetails.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
overheadListPhyDetails.costPercentage
costPercentage
% التكلفة
Cost Percentage
Decimal
overheadListPhyDetails.costValue
costValue
قيمة التكلفة
Cost Value
Decimal
overheadListPhyDetails.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
overheadListPhyDetails.id
id
ID
overheadListPhyDetails.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class
Reference
overheadListPhyDetails.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class
Reference
overheadListPhyDetails.lineNumber
lineNumber
Integer
overheadListPhyDetails.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
overheadListPhyDetails.overheadItem
overheadItem_id
بند تكلفة طبية غير مباشرة
Overhead Item
Reference
overheadListPhyDetails.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission
Reference
overheadListPhyDetails.patientClass
patientClass_id
فئة المريض
Patient Classification
Reference
overheadListPhyDetails.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
overheadListPhyDetails.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1
Reference
overheadListPhyDetails.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2
Reference
overheadListPhyDetails.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3
Reference
overheadListPhyDetails.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4
Reference
overheadListPhyDetails.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5
Reference
overheadListPhyDetails.pricingData.phyTherapyType
phyTherapyType_id
نوع العلاج الطبيعى
Physical Therapy Type
Reference
overheadListPhyDetails.priority
priority
الأولوية
Priority
Long
overheadListPhyDetails.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary
Genericreference
overheadListPhyDetails.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification
Reference
overheadListPhyDetails.validFrom
validFrom
صالح من
Valid from
Date
overheadListPhyDetails.validTo
validTo
صالح حتي
Valid to
Date
overheadListRadiologyDetails ( - )
Table Name: HMSOverheadListRadiologyLine, Join Column: hMSOverheadList_id
Property
Column
Arabic
English
Type
Foreign Table
overheadListRadiologyDetails.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
overheadListRadiologyDetails.costPercentage
costPercentage
% التكلفة
Cost Percentage
Decimal
overheadListRadiologyDetails.costValue
costValue
قيمة التكلفة
Cost Value
Decimal
overheadListRadiologyDetails.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
overheadListRadiologyDetails.id
id
ID
overheadListRadiologyDetails.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class
Reference
overheadListRadiologyDetails.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class
Reference
overheadListRadiologyDetails.lineNumber
lineNumber
Integer
overheadListRadiologyDetails.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
overheadListRadiologyDetails.overheadItem
overheadItem_id
بند تكلفة طبية غير مباشرة
Overhead Item
Reference
overheadListRadiologyDetails.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission
Reference
overheadListRadiologyDetails.patientClass
patientClass_id
فئة المريض
Patient Classification
Reference
overheadListRadiologyDetails.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
overheadListRadiologyDetails.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1
Reference
overheadListRadiologyDetails.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2
Reference
overheadListRadiologyDetails.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3
Reference
overheadListRadiologyDetails.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4
Reference
overheadListRadiologyDetails.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5
Reference
overheadListRadiologyDetails.pricingData.radiologyType
radiologyType_id
نوع الأشعة
Radiology Type
Reference
overheadListRadiologyDetails.priority
priority
الأولوية
Priority
Long
overheadListRadiologyDetails.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary
Genericreference
overheadListRadiologyDetails.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification
Reference
overheadListRadiologyDetails.validFrom
validFrom
صالح من
Valid from
Date
overheadListRadiologyDetails.validTo
validTo
صالح حتي
Valid to
Date
overheadListServiceDetails ( - )
Table Name: HMSOverheadListServiceLine, Join Column: hMSOverheadList_id
Property
Column
Arabic
English
Type
Foreign Table
overheadListServiceDetails.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
overheadListServiceDetails.costPercentage
costPercentage
% التكلفة
Cost Percentage
Decimal
overheadListServiceDetails.costValue
costValue
قيمة التكلفة
Cost Value
Decimal
overheadListServiceDetails.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
overheadListServiceDetails.id
id
ID
overheadListServiceDetails.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class
Reference
overheadListServiceDetails.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class
Reference
overheadListServiceDetails.lineNumber
lineNumber
Integer
overheadListServiceDetails.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
overheadListServiceDetails.overheadItem
overheadItem_id
بند تكلفة طبية غير مباشرة
Overhead Item
Reference
overheadListServiceDetails.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission
Reference
overheadListServiceDetails.patientClass
patientClass_id
فئة المريض
Patient Classification
Reference
overheadListServiceDetails.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
overheadListServiceDetails.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1
Reference
overheadListServiceDetails.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2
Reference
overheadListServiceDetails.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3
Reference
overheadListServiceDetails.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4
Reference
overheadListServiceDetails.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5
Reference
overheadListServiceDetails.pricingData.medicalService
medicalService_id
الخدمة الطبية
Medical Service
Reference
overheadListServiceDetails.pricingData.medicalSpecialty
medicalSpecialty_id
التخصص الطبي
Medical Specialty
Reference
overheadListServiceDetails.priority
priority
الأولوية
Priority
Long
overheadListServiceDetails.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary
Genericreference
overheadListServiceDetails.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification
Reference
overheadListServiceDetails.validFrom
validFrom
صالح من
Valid from
Date
overheadListServiceDetails.validTo
validTo
صالح حتي
Valid to
Date
overheadListSupervisionDetails ( - )
Table Name: HMSOverheadListSupervisionLine, Join Column: hMSOverheadList_id
Property
Column
Arabic
English
Type
Foreign Table
overheadListSupervisionDetails.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
overheadListSupervisionDetails.costPercentage
costPercentage
% التكلفة
Cost Percentage
Decimal
overheadListSupervisionDetails.costValue
costValue
قيمة التكلفة
Cost Value
Decimal
overheadListSupervisionDetails.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
overheadListSupervisionDetails.id
id
ID
overheadListSupervisionDetails.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class
Reference
overheadListSupervisionDetails.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class
Reference
overheadListSupervisionDetails.lineNumber
lineNumber
Integer
overheadListSupervisionDetails.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
overheadListSupervisionDetails.overheadItem
overheadItem_id
بند تكلفة طبية غير مباشرة
Overhead Item
Reference
overheadListSupervisionDetails.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission
Reference
overheadListSupervisionDetails.patientClass
patientClass_id
فئة المريض
Patient Classification
Reference
overheadListSupervisionDetails.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
overheadListSupervisionDetails.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1
Reference
overheadListSupervisionDetails.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2
Reference
overheadListSupervisionDetails.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3
Reference
overheadListSupervisionDetails.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4
Reference
overheadListSupervisionDetails.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5
Reference
overheadListSupervisionDetails.pricingData.roomClassification
roomClassification_id
تصنيف الغرفة
Room Classification
Reference
overheadListSupervisionDetails.priority
priority
الأولوية
Priority
Long
overheadListSupervisionDetails.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary
Genericreference
overheadListSupervisionDetails.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification
Reference
overheadListSupervisionDetails.validFrom
validFrom
صالح من
Valid from
Date
overheadListSupervisionDetails.validTo
validTo
صالح حتي
Valid to
Date
overheadListSupplyDetails ( - )
Table Name: HMSOverheadListSupplyLine, Join Column: hMSOverheadList_id
Property
Column
Arabic
English
Type
Foreign Table
overheadListSupplyDetails.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
overheadListSupplyDetails.costPercentage
costPercentage
% التكلفة
Cost Percentage
Decimal
overheadListSupplyDetails.costValue
costValue
قيمة التكلفة
Cost Value
Decimal
overheadListSupplyDetails.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
overheadListSupplyDetails.id
id
ID
overheadListSupplyDetails.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class
Reference
overheadListSupplyDetails.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class
Reference
overheadListSupplyDetails.lineNumber
lineNumber
Integer
overheadListSupplyDetails.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
overheadListSupplyDetails.overheadItem
overheadItem_id
بند تكلفة طبية غير مباشرة
Overhead Item
Reference
overheadListSupplyDetails.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission
Reference
overheadListSupplyDetails.patientClass
patientClass_id
فئة المريض
Patient Classification
Reference
overheadListSupplyDetails.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
overheadListSupplyDetails.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1
Reference
overheadListSupplyDetails.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2
Reference
overheadListSupplyDetails.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3
Reference
overheadListSupplyDetails.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4
Reference
overheadListSupplyDetails.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5
Reference
overheadListSupplyDetails.priority
priority
الأولوية
Priority
Long
overheadListSupplyDetails.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary
Genericreference
overheadListSupplyDetails.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification
Reference
overheadListSupplyDetails.validFrom
validFrom
صالح من
Valid from
Date
overheadListSupplyDetails.validTo
validTo
صالح حتي
Valid to
Date
overheadListSurgeryDetails ( - )
Table Name: HMSOverheadListSurgeryLine, Join Column: hMSOverheadList_id
Property
Column
Arabic
English
Type
Foreign Table
overheadListSurgeryDetails.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent
Decimal
overheadListSurgeryDetails.costPercentage
costPercentage
% التكلفة
Cost Percentage
Decimal
overheadListSurgeryDetails.costValue
costValue
قيمة التكلفة
Cost Value
Decimal
overheadListSurgeryDetails.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category
Reference
overheadListSurgeryDetails.id
id
ID
overheadListSurgeryDetails.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class
Reference
overheadListSurgeryDetails.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class
Reference
overheadListSurgeryDetails.lineNumber
lineNumber
Integer
overheadListSurgeryDetails.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company
Reference
overheadListSurgeryDetails.overheadItem
overheadItem_id
بند تكلفة طبية غير مباشرة
Overhead Item
Reference
overheadListSurgeryDetails.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission
Reference
overheadListSurgeryDetails.patientClass
patientClass_id
فئة المريض
Patient Classification
Reference
overheadListSurgeryDetails.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent
Decimal
overheadListSurgeryDetails.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1
Reference
overheadListSurgeryDetails.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2
Reference
overheadListSurgeryDetails.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3
Reference
overheadListSurgeryDetails.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4
Reference
overheadListSurgeryDetails.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5
Reference
overheadListSurgeryDetails.pricingData.surgeryType
surgeryType_id
نوع العملية الجراحية
Surgery Type
Reference
overheadListSurgeryDetails.priority
priority
الأولوية
Priority
Long
overheadListSurgeryDetails.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary
Genericreference
overheadListSurgeryDetails.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification
Reference
overheadListSurgeryDetails.validFrom
validFrom
صالح من
Valid from
Date
overheadListSurgeryDetails.validTo
validTo
صالح حتي
Valid to
Date