IntelliTrack Package Track - Manual (Page 223)

Appendix A
Data Structures
209
Recipients
Columns
Name Type Size
RecipientID Long Integer 4
RecipientIdentifier Text 50
FirstName Text 50
LastName Text 50
RoomNumber Text 50
Address1 Text 50
Address2 Text 50
City Text 50
State Text 50
PostalCode Text 50
Country Text 50
PhoneNumber Text 15
FaxNumber Text 15
Email Text 75
LastNoticeDate Date/Time 8
NotifyByEmail Yes/No 1
OldRecipientIdentifier Text 50
RecipientIdenti-
fierChangeDate Date/Time 8
Table Indexes
Name Field
IdxRecipientIdentifer RecipientIdentifier (Ascending)
PostalCode PostalCode (Ascending)
PrimaryKey RecipientID (Ascending)
RecipientID RecipientID (Ascending)
idx_FirstName FirstName (Ascending)
idx_LastName LastName (Ascending)