NameDescriptionTypeAdditional information
DoctorsStatement_ID

globally unique identifier

None.

Exam_ID

globally unique identifier

None.

Patient_ID

globally unique identifier

None.

Attachment_Id

globally unique identifier

None.

AttachmentsId

integer

None.

DrFeeOnFlyId

integer

None.

IntOpthNew

boolean

None.

IntOpthEst

boolean

None.

IntOpthFee

decimal number

None.

CompOpthNew

boolean

None.

CompOpthEst

boolean

None.

CompOpthFee

decimal number

None.

OfficeVisit1New

boolean

None.

OfficeVisit1Est

boolean

None.

OfficeVisit1Fee

decimal number

None.

OfficeVisit2New

boolean

None.

OfficeVisit2Est

boolean

None.

OfficeVisit2Fee

decimal number

None.

OfficeVisit3New

boolean

None.

OfficeVisit3Est

boolean

None.

OfficeVisit3Fee

decimal number

None.

Refraction

boolean

None.

RefractionFee

decimal number

None.

OpthDilation

boolean

None.

OpthDilationFee

decimal number

None.

VisualFieldScreening

boolean

None.

VisualFieldScreeningFee

decimal number

None.

VisualFieldThreshold

boolean

None.

VisualFieldThresholdFee

decimal number

None.

ContactLensFitting

boolean

None.

ContactLensFittingFee

decimal number

None.

Frames

boolean

None.

FramesFee

decimal number

None.

Lenses

boolean

None.

LensesCode

string

None.

LensesFee

decimal number

None.

Contacts

boolean

None.

ContactsCode

string

None.

ContactsFee

decimal number

None.

Other1Code

string

None.

Other1Desc

string

None.

Other1Fee

decimal number

None.

Other2Code

string

None.

Other2Desc

string

None.

Other2Fee

decimal number

None.

Other3Code

string

None.

Other3Desc

string

None.

Other3Fee

decimal number

None.

Myopia

boolean

None.

Hyoeripia

boolean

None.

Presryopia

boolean

None.

Astigmatism

boolean

None.

TotalFees

decimal number

None.

Discount

decimal number

None.

AmountPaid

decimal number

None.

Balance

decimal number

None.

MedicalOther1Desc

string

None.

MedicalOther1Code

string

None.

MedicalOther2Desc

string

None.

MedicalOther2Code

string

None.

MedicalOther3Desc

string

None.

MedicalOther3Code

string

None.

MedicalOther4Desc

string

None.

MedicalOther4Code

string

None.

DoctorsSignature

Collection of byte

None.

CreationDate

date

None.

LastUpdateDate

date

None.

IntOpthNewStr

string

None.

IntOpthEstStr

string

None.

CompOpthNewStr

string

None.

CompOpthEstStr

string

None.

OfficeVisit1NewStr

string

None.

OfficeVisit1EstStr

string

None.

OfficeVisit2NewStr

string

None.

OfficeVisit2EstStr

string

None.

OfficeVisit3NewStr

string

None.

OfficeVisit3EstStr

string

None.

RefractionStr

string

None.

OpthDilationStr

string

None.

VisualFieldScreeningStr

string

None.

VisualFieldThresholdStr

string

None.

ContactLensFittingStr

string

None.

FramesStr

string

None.

LensesStr

string

None.

ContactsStr

string

None.

FramesText

string

None.

LensesText

string

None.

ContacsText

string

None.

Other4Desc

string

None.

Other4Fee

decimal number

None.

Other4Code

string

None.

Other5Desc

string

None.

Other5Fee

decimal number

None.

Other5Code

string

None.

Other6Desc

string

None.

Other6Fee

decimal number

None.

Other6Code

string

None.

Other7Desc

string

None.

Other7Fee

decimal number

None.

Other7Code

string

None.

Other8Desc

string

None.

Other8Fee

decimal number

None.

Other8Code

string

None.

Other9Desc

string

None.

Other9Fee

decimal number

None.

Other9Code

string

None.

Other10Desc

string

None.

Other10Fee

decimal number

None.

Other10Code

string

None.

DiagnosisFeeBox1

decimal number

None.

DiagnosisFeeBox2

decimal number

None.

DiagnosisFeeBox3

decimal number

None.

DiagnosisFeeBox4

decimal number

None.

DiagnosisFeeBox5

decimal number

None.

PaymentVia

string

None.

DoctorID

integer

None.

DiscountPercent

string

None.

Other1

boolean

None.

Other2

boolean

None.

Other3

boolean

None.

Other4

boolean

None.

Other5

boolean

None.

Other6

boolean

None.

Other7

boolean

None.

Other8

boolean

None.

Other9

boolean

None.

Other10

boolean

None.

Other1Str

string

None.

Other2Str

string

None.

Other3Str

string

None.

Other4Str

string

None.

Other5Str

string

None.

Other6Str

string

None.

Other7Str

string

None.

Other8Str

string

None.

Other9Str

string

None.

Other10Str

string

None.

DiagnosisNum1

string

None.

DiagnosisNum2

string

None.

DiagnosisNum3

string

None.

DiagnosisNum4

string

None.

DiagnosisNum5

string

None.

DiagnosisText1

string

None.

DiagnosisText2

string

None.

DiagnosisText3

string

None.

DiagnosisText4

string

None.

DiagnosisText5

string

None.

CheckNum

string

None.

Visionins

string

None.

Provider_ID

globally unique identifier

None.

Exam

ExamModel

None.