Mandatory Data Entry Fields (T142)

Making Data Entry Fields Mandatory (T142)

For Compulink Advantage Windows users

The Windows versions of Compulink's Eyecare Advantage (EYECARE.EXE) and Ophthalmology Advantage (EYEMD.EXE) dated later than 11/17/98 have the ability to make fields that the user cannot leave empty. They will be mandatory. These data-entry screens can be controlled: Patient Demographics, Account Responsible, Exam, Spectacle RX, and Contact Lens RX. This is accomplished by creating a text file with an entry for the field to be made mandatory and a message to the operator when they have left the field empty.

File names

Build an ASCII text file with the name listed below to control the associated screen(s).

File Name	Screen
PATIENT.VLD	Patient Demographics
BILL.VLD	Account Responsible
EXAM.VLD	Exam screens
FRAM_RX.VLD	Spectacle RX
LENS_RX.VLD	Contact Lens RX

Each file is built of discreet lines. Each line specifies one (1) mandatory field. The file should be placed in the \PRODUCT directory (e.g. \EYECARE or \EYEMD).

The line structure

Col 1 through 10: field name

Col 11 ->: Error message given to the operator

EXAMPLES:

(file PATIENT.VLD)

12345678901234567......

STREET You MUST enter a PO Box or Street Address

ZIP You MUST enter a ZIP code

(file FRAM_RX.VLD)

12345678901234567......

DONEDATE Please enter the Promised delivery Date

DONETIME Please enter the Promised delivery Time

(file EXAM.VLD)

12345678901234567......

DIAG_1 You MUST enter the PRIMARY Diagnosis

Be VERY careful when building these files. If you make a field mandatory, the users will NOT be able to save that screen unless they have something entered in that field.

Patient Field List

This is a list of some of the PATIENT DEMOGRAPHICS fields. Those not listed shouldn't be used to make a field mandatory.

FIELD NAME	PURPOSE	FIELD NAME	PURPOSE
BILLREL	Patient Relationship to Account Responsible	LAST	Last Name
BIRTH	Birth Date	LOCATION	Location Code
CITY	City	MI	Middle Initial
DOCTOR	Provider Code (DOC ID)	RECALL1	Primary Recall Date
DUEFOR	Primary Recall Reason	RECALL2	Secondary Recall Date
DUEFOR2	Secondary Recall Reason	REFBY	Initial Referral Source
FIN_TYPE	Primary Financial Class	SALUTE	Salutation
FIRST	First Name	SEX	Gender
HPHONE	Home Phone	STATE	State
ID1	1st Single Character ID Field	STREET	Street
ID10	10th Single Character ID Field	USER1	1st Fifteen Character User Defined Field
ID11	11th Single Character ID Field	USER2	2nd Fifteen Character User Defined Field
ID12	12th Single Character ID Field	USER3	3rd Fifteen Character User Defined Field
ID13	13th Single Character ID Field	USER4	4th 15 Character User Defined Field
ID14	14th Single Character ID Field	USER5	5th 15 Character User Defined Field
ID15	15th Single Character ID Field	WPHONE	Work Phone
ID16	16th Single Character ID Field	WPHONEX	Work Phone Extension
ID2	2nd Single Character ID Field	ZIP	Zip Code
ID3	3rd Single Character ID Field
ID4	4th Single Character ID Field
ID5	5th Single Character ID Field
ID6	6th Single Character ID Field
ID7	7th Single Character ID Field
ID8	8th Single Character ID Field
ID9	9th Single Character ID Field

Account Responsible Field List

This is a list of some of the ACCOUNT RESPONSIBLE fields. Those not listed shouldn't be used to make a field mandatory.

FIELD NAME	PURPOSE	FIELD NAME	PURPOSE
CITY	City	STREET	Street Address
FIRST	First Name	USER1	User Defined Field (Misc.)
HPHONE	Home Phone	WPHONE	Work Phone
LAST	Last Name	WPHONEX	Work Phone Extension
SALUTE	Salutation	ZIP	Postal Code
STATE	State

Spectacle RX Field List

This is a list of some of the SPECTACLE RX fields. Those not listed shouldn't be used to make a field mandatory.

FIELD NAME	PURPOSE	FIELD NAME	PURPOSE
A	"A" Measurement	L_SEG	L. Segment
B	"B" Measurement	L_SPHERE	L. Sphere
BRIDGE	Bridge Size	L_VAF	L. Distance VA
COATING2	2nd Lens Coating	L_VAN	L. Near VA
COATING3	3rd Lens Coating	L_VERTEX	L. Vertex
DBL	"DBL" Measurement	MPD_LD	L. Monocular Distance PD
DISPENSD	Date Dispensed	MPD_LN	L. Monocular Near PD
DONEDATE	Promised Completion Date	MPD_RD	R. Monocular Distance PD
DONETIME	Promised Completion Time	MPD_RN	R. Monocular Near PD
ED	"ED" Measurement	NEAR_RX	Near RX
EYE	Eye Size	NEW	New RX
FOCLTYPE	Multi Focal Type	NOTIFIED	Date Patient Notified
FRAM_CLR	Frame Color	ORDRCMT1	1st Line of Order Comments
FRAM_MFG	Frame Manufacturer	ORDRCMT2	2nd Line of Order Comments
FRAM_STK	Frame Stock Number	PUP_FAR	Distance PD
FRAM_STY	Frame Style	PUP_NEAR	Near PD
INV_ORD	Date Frame Ordered	RX_DATE	Rx Date
INV_REC	Date Frame Received	RX_NOTE1	2nd Line of Rx Notes
LAB	Name of Lab	RX_NOTES	1st Line of Rx Notes
LABORDER	Lab's Order Number	RX_USE	RX Use
LABPHONE	Lab's Phone Number	R_ADD	R. Add
LAB_ACNT	Lab's Account #	R_AXIS	R. Axis
LAB_COST	Cost of Job from Lab	R_BC	R. Base Curve
LAB_EXP	Date Expected back from Lab	R_CYL	R. Cylinder
LAB_INV	Invoice # From Lab	R_DEC	R. Decentratioin
LAB_REC	Date Received Job from Lab	R_DECVER	R. Vertical Decentration
LAB_SNT	Date Sent to Lab	R_MISC	R. Misc. Field
LENSCOAT	1st Lens Coating	R_PH	R. PH
LENSMAT	Lens Material	R_PRISM1	R. Prism - 1st Amount
LENSTINT	Lens Tint	R_PRISM1B	R. Prism - 1st Direction
L_ADD	L. Add	R_PRISM2	R. Prism - 2nd Amount
L_AXIS	L. Axis	R_PRISM2B	R. Prism - 2nd Direction
L_BC	L. Base Curve	R_PV	R. PV
L_CYL	L. Cyl.	R_SEG	R. Segment
L_DEC	L. Decentration	R_SPHERE	R. Sphere
L_DECVER	L. Vertical Decentration	R_VAF	R. Distance VA
L_MISC	L. Misc. Field	R_VAN	R. Near VA
L_PH	L. PH	R_VERTEX	R. Vertex
L_PRISM1	L. Prism - 1st Amount	SEGWIDTH	Segment Width
L_PRISM1B	L. Prism - 1st Direction	TEMPLE	Temple Size
L_PRISM2	L. Prism - 2nd Amount	TMPL_TYP	Temple Type
L_PRISM2B	L. Prism - 2nd Direction	TRAY	Tray # where Job located
L_PV	L. PV	TRIWIDTH	Trifocal Width

Contact Lens RX Field List

This is a list of some of the CONTACT LENS fields. Those not listed shouldn't be used to make a field mandatory.

FIELD NAME	PURPOSE	FIELD NAME	PURPOSE
DISPENSD	Date Rx Dispensed	L_PRISM	L. Prism
DONEDATE	Date Job Promised	L_SERIES	L. Lens Series
DONETIME	Time Job Promised	L_STOCK	L. Stock Number
INV_ORD	Date Right Lens Ordered	L_TYPE	L. Lens Type
INV_ORD2	Date Left Lens Ordered	NOTIFIED	Date Patient Notified
INV_REC	Date Right Lens Received	ORDRCMT1	1st Line of Order Comments
INV_REC2	Date Left Lens Received	ORDRCMT2	2nd Line of Order Comments
LAB	Lab	RX_DATE	Rx Date
LABORDER	Lab Order #	RX_NOTE1	2nd Line of RX Notes
LABPHONE	Lab Phone	RX_NOTES	1st Line of RX Notes
LAB_ACNT	Lab Account #	R_2NDCRV	R. Secondary Curve
LAB_COST	Lab Cost	R_2NDWTH	R. Secondary Width
LAB_EXP	Date Job expected back from the Lab	R_ADD	R. Add
LAB_INV	Lab Invoice #	R_AXIS	R. Axis
LAB_REC	Date Job received from the Lab	R_BC	R. Base Curve
LAB_SNT	Date Job sent to the Lab	R_BLEND	R. Blend
L_2NDCRV	L. Secondary Curve	R_COLOR	R. Lens Color
L_2NDWTH	L. Secondary Width	R_CTRTHK	R. Center Thickness
L_ADD	L. Add	R_CYL	R. Cyl.
L_AXIS	L. Axis	R_DIA	R. Diameter
L_BC	L. Base Curve	R_EDGE	R. Edge
L_BLEND	L. Blend	R_MFG	R. Lens Manufacturer
L_COLOR	L. Lens Color	R_NAME	R. Lens Name
L_CTRTHK	L. Center Thickness	R_OZDIA	R. OZ Diameter
L_CYL	L. Cyl.	R_PERCRV	R. Peripheral Curve
L_DIA	L. Diameter	R_PERWTH	R. Peripheral Width
L_EDGE	L. Edge	R_POWER	R. Lens Power
L_MFG	L. Lens Manufacturer	R_PRISM	R. Prism
L_NAME	L. Lens Name	R_SERIES	R. Lens Series
L_OZDIA	L. OZ Diameter	R_STOCK	R. Stock Number
L_PERCRV	L. Peripheral Curve	R_TYPE	R. Lens Type
L_PERWTH	L. Peripheral Width	TRAY	Tray #
L_POWER	L. Lens Power

Exam Field List

This is a list of some of the EXAM fields. Those not listed shouldn't be used to make a field mandatory.

FIELD NAME	PURPOSE	FIELD NAME	PURPOSE
ACCDSTAT	State where Accident took place	L_PRISM2B	L. Prism - 2nd Direction
ACCIDENT	Accident Indicator	L_SPHERE	L. Subj. Sphere
B_PD_F	Distance PD	L_SPH_O	L. Sphere ( Obj. )
B_PD_N	Near PD	L_VAF	L. Distance VA ( Subj. )
B_VAF	B. Distance VA ( Subj. )	L_VAF_O	L. Distance VA ( Obj. )
B_VAF_O	Both Disance VA( Obj. )	L_VAF_U	L. Distance VA - Unaided
B_VAF_U	B. Distance VA - Unaided	L_VAN	L. Near VA ( Subj. )
B_VAN	B. Near VA ( Subj. )	L_VAN_O	L. Near VA ( Obj. )
B_VAN_O	B. Near VA ( Obj. )	L_VAN_U	L. Near VA - Unaided
B_VAN_U	B. Near VA - Unaided	MAR_STAT	Marital Status
DATE_ILL	Date of Illness	OUT_WORK	Date out of Work
DIAG_1	1st Diagnosis (Primary)	REF_CODE	Referring Dr. UPIN
DIAG_2	2nd Diagnosis	REF_FIRST	First name of Referring Dr.
DIAG_3	3rd Diagnosis	REF_LAST	Last Name of Referring Dr.
DIAG_4	4th Diagnosis	REF_LIC	Referring Dr. License #
EMERGNCY	Emergency	REF_MI	Middle Initial of Referring Dr.
EMPLSTAT	Employment Status	RET_WORK	Date able to Return to Work
EMPLYREL	Employment Relationship	RN_PRISM1	R. Near Prism - 1st Amount
EPSDT	EPSDT	RN_PRISM1B	R. Near Prism - 1st Direction
EXAMDATE	Date of Examination Record	RN_PRISM2	R. Near Prism - 2nd Amount
FAC_CITY	City of Other Facility	RN_PRISM2B	R. Near Prism - 2nd Direction
FAC_ID	Other Facility ID	R_ADD	R. Add ( Subj.)
FAC_NAME	Name of Other Facility	R_AXIS	R. Axis ( Subj. )
FAC_STAT	State of Other Facility	R_AXIS_O	R. Axis ( Obj. )
FAC_STRT	Street Address of Other Facility	R_CYL	R. Subj. Cyl.
FAC_ZIP	Zip Code of Other Facility	R_CYL_O	R. Cyl. ( Obj. )
HOSP_E	End Date of Hospitalization	R_KAXIS	R. K. Axis
HOSP_S	Start Date of Hospitalization	R_KHOR	R. K. Horizontal
INITCNSL	Initial Date of Consultation	R_KVER	R. K. Vertical
LAB_CHRG	Lab Charges	R_PD_F	R. Monocular Distance PD
LN_PRISM1	L. Near Prism - 1st Amount	R_PD_N	R. Monocular Near PD
LN_PRISM1B	L. Near Prism - 1st Direction	R_PRISM1	R. Prism - 1st Amount
LN_PRISM2	L. Near Prism - 2nd Amount	R_PRISM1B	R. Prism - 1st Direction
LN_PRISM2B	L. Near Prism - 2nd Direction	R_PRISM2	R. Prism - 2nd Amount
L_ADD	L. Add ( Subj. )	R_PRISM2B	R. Prism - 2nd Direction
L_AXIS	L. Axis ( Subj. )	R_SPHERE	R. Subj. Sphere
L_AXIS_O	L. Axis ( Obj. )	R_SPH_O	R. Sphere ( Obj. )
L_CYL	L. Subj. Cyl.	R_VAF	R. Distance VA ( Subj. )
L_CYL_O	L. Cyl. ( Obj. )	R_VAF_O	R. Distance VA ( Obj. )
L_KAXIS	L. K. Axis	R_VAF_U	R. Distance VA - Unaided
L_KHOR	L. K. Horizontal	R_VAN	R. Near VA ( Subj. )
L_KVER	L. K. Vertical	R_VAN_O	R. Near VA ( Obj. )
FIELD NAME	PURPOSE	FIELD NAME	PURPOSE
L_PD_F	L. Monocular Distance PD	R_VAN_U	R. Near VA - Unaided
L_PD_N	L. Monocular Near PD	SIMSYMPT	Similar Symptoms
L_PRISM1	L. Prism - 1st Amount	STUDSTAT	Student Status
L_PRISM1B	L. Prism - 1st Direction	TOTDIS_E	End Date of Total Disability
L_PRISM2	L. Prism - 2nd Amount	TOTDIS_S	Start Date of Total Disability

BY: SEO - 03/2002

Copyright © 2011 Compulink Business Systems. All rights reserved.
Last modified: 05/14/12.