Description: This table holds recall notices.

Field	Datatype	Default	Null Option	Comment
PracticeID	INTEGER	?	MANDATORY	FK
BatchCode	CHARACTER(6)		MANDATORY	User defined batch code.
RunNumber	INTEGER	0	MANDATORY	Next sequential run number for the batch.
NoticeNumber	INTEGER	0	MANDATORY	System generated number that identifies the recall notice.
PatientID	INTEGER	?	MANDATORY	FK
RecallDate	DATE		MANDATORY	Date of return appointment.
Trial	CHARACTER(1)		MANDATORY	Flag to indicate if the run was a trial run. Possible values are Y or N.
FormCode	CHARACTER(10)	""	OPTIONAL	User defined key.
ServiceCenterID	INTEGER	?	OPTIONAL	FK
StaffID	INTEGER	?	OPTIONAL	FK
ReasonCode	CHARACTER(6)		MANDATORY	FK
CurrentStatus	INTEGER	0	OPTIONAL	Status of recall. 0 - Pending recall. 1 - First notice sent. 2 - Second notice sent.
QCDateBasis	INTEGER	0	OPTIONAL	Date basis for determing when to trigger recall date. 1 - based on QC history. 2 - based on recall cycle.
Suppressed	CHARACTER(20)		OPTIONAL	Indicates if the recall notice should transmitted or not. Supported by Confirmation lookup type. Possible Values: (Y)es, (N)o
TimeStamp	CHARACTER(14)		OPTIONAL	System generated date/time stamp record was last written.
LastUser	INTEGER	?	OPTIONAL	User ID of user that last wrote the record.
CreateStamp	CHARACTER(14)		OPTIONAL	System generated date/time stamp record was created.
CreateUser	INTEGER	?	OPTIONAL	User ID of user that created the record.
RecallMethod	CHAR(10)	Paper	OPTIONAL	System defined. Field is supported by the lookup types:[RecallMethod]. Values are defined in the LookupCode table for the above lookup types..

Parent Tables

Parent Table Join Phrase When deleting parent record...

Patient RecallNotice.PracticeID = Patient.PracticeID and
RecallNotice.PatientID = Patient.PatientID RESTRICT if RecallNotice exists

Staff RecallNotice.PracticeID = Staff.PracticeID and
RecallNotice.StaffID = Staff.StaffID NONE if RecallNotice exists

ServiceCenter RecallNotice.ServiceCenterID = ServiceCenter.ServiceCenterID NONE if RecallNotice exists

Parent Table	Join Phrase	When deleting parent record...
Patient	RecallNotice.PracticeID = Patient.PracticeID and RecallNotice.PatientID = Patient.PatientID	RESTRICT if RecallNotice exists
Staff	RecallNotice.PracticeID = Staff.PracticeID and RecallNotice.StaffID = Staff.StaffID	NONE if RecallNotice exists
ServiceCenter	RecallNotice.ServiceCenterID = ServiceCenter.ServiceCenterID	NONE if RecallNotice exists

Child Tables

Child Table	Join Phrase	When deleting RecallNotice record...