| Z:\WORK\BLANK.MDB Tables (2/8/2018 1:28:14 PM) | ||
| tblCombo 3 recs | Values for combo boxes PK: +Combo;+Code | |
| Combo | T 20 | Name of combo box |
| Code | T 5 | Value returned by combo box |
| Descrip | T 50 | Long description that appears in combo |
| Sort | 6 | Sort order for combo |
| Sel | Y/N | Yes=Select this record for processing |
| Comment | T 255 | Note about this record |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | When record was last updated |
| tblContact 1 recs | Info about contacts PK: +ContactID | |
| ContactID | Long | Primary key |
| LastName | T 20 | Last name of contact |
| FirstName | T 15 | First name of contact |
| Company | T 50 | Billing name of company |
| Street | T 50 | Street address of contact |
| City | T 20 | Citry of contact |
| State | T 2 | State of contact if USA |
| Zip | T 10 | Zip/Postal code |
| HomePhone | T 14 | Home Phone number of contact |
| CellPhone | T 10 | Cell phone number of contact |
| WorkPhone | T 14 | Work phone number of contact |
| T 50 | Contact's email address | |
| Inactive | Y/N | Yes=Contact is no longer active |
| Group | T 50 | Marketing Group |
| Comment | T 255 | Note about this contact |
| Sel | Y/N | Yes=select this record for processing |
| Usr | T 8 | UserID of person who last updated this record |
| UpdDate | Date | Time record was last updated |
| tblDI 2 recs | Data Integrity queries PK: +DIQuery | |
| DIQuery | T 100 | Primary key |
| DIRecs | Long | Count of recs in query |
| Sort | 6 | Sort order of query |
| Fix | Y/N | Yes=Fix w/qFix... |
| Note | T 255 | Copyright Agee Software, Inc., 2008 |
| Comment | T 255 | Text on how to Fix problems |
| Tbl | T 20 | Table to open upon Sel |
| UpdDate | Date | When record was last updated |
| tblEval 4 recs | ||
| EvalID | Long | Primary key |
| PatientID | Long | Relates to tblPatient |
| Group | T 50 | Please select a Group |
| EvalDate | Date | Date of eval. (m/d or m/d/yyyy. DblClick for today. Num */- to add/subtract a day) |
| Complete | Y/N | Yes=Eval is complete |
| Sel | Y/N | Yes=Select this record for processing |
| Comment | T 255 | Note about this record |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | When record was last updated |
| tblReport 1 recs | Report menu PK: +ReportName | |
| ReportName | T 50 | Primary key. Access report object name |
| ReportTitle | T 50 | Title of report in combo |
| Sort | 6 | Sort order. 1.2 is between 1 and 2. |
| UpdDate | Date | When record was last updated |
| tblSetup 1 recs | ||
| SetupID | Long | Primary key |
| Company | T 50 | Name of company |
| Street | T 50 | Company street for mailing address |
| City | T 20 | City in which Company is located |
| State | T 2 | State in which Company is located |
| Zip | T 10 | Zip code for company |
| Phone | T 14 | Company phone number |
| Fax | T 14 | Company Fax number |
| Website | T 50 | Company website |
| T 50 | Company email address | |
| ImportFolder | T 50 | Folder where files are stored for import/export |
| ColorUsr | Long | Form color for normal user |
| ColorSuper | Long | Form color for super user |
| Quit | T 255 | Message for users when super issues a forced quit command |
| Ver | 6 | Latest version of front end available for download |
| Usr | T 8 | |
| tblUser 2 recs | Info about users PK: +UserID | |
| UserID | T 8 | Primary key |
| UserName | T 20 | First and last name of user |
| T 50 | EMail address of user | |
| Phone | T 14 | Phone number of user |
| Comment | T 255 | Text about this user |
| Super | Y/N | Yes=User can add/remove users |
| Limited | Y/N | Yes=User has read only access |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | Time record was last updated |
| 7 tables© 2008, Agee Software, Inc. | ||