| Z:\WORK\PFG.MDB Tables (7/26/2016 1:03:28 PM) | ||
| tblAccident 593 recs | ||
| EmployeeID | Long | Relates to tblEmployee |
| AccidentDate | Date | Date of accident |
| AccidentType | T 50 | Please select AccidentType |
| ExEmployeeID | Long | |
| Claimant | T 30 | Claimant LastName, FirstName |
| ClaimantSSN | T 9 | Claimant SSN |
| ClaimNo | T 15 | Claim number |
| Coverage | T 20 | Please select a Coverage |
| Cause | T 40 | Please select a Cause |
| Descrip | T 255 | Description of accident |
| Status | T 1 | Please select a Status |
| AccidentState | T 2 | State in which accident occurred |
| Reported | Date | Date accident was reported to Carrier/TPA |
| Incurred | Dbl | Dollars of damage claimed |
| Paid | Dbl | Dollars of damage paid |
| Reserve | Dbl | Dollars reserved for payment |
| Carrier | T 3 | Please select a Carrier |
| Points | Long | Number of Accident Points for this accident |
| MVR | Long | |
| Preventable | Y/N | Yes=Accident was preventable. Show on report |
| Comment | T 255 | Text about this record |
| Sel | Y/N | Yes=Select this record for processing |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | When record was last updated |
| tblApplicant 1549 recs | ||
| ApplicantID | Long | Primary key |
| ReferredBy | T 255 | Who referred this applicant |
| CurrentEmployer | T 255 | Applicant's current employer (PFG if hired) |
| LastName | T 255 | Applicant's last name |
| FirstName | T 50 | Applicant's first name |
| City | T 255 | Where applicant is living |
| State | T 2 | Where applicant is living |
| PriorCity | T 50 | Where applicant lived before |
| PriorState | T 2 | Where applicant lived before |
| Phone | T 50 | Primary phone |
| PhoneType | T 1 | Primary phone Type (C=Cell, H=Home) |
| Phone2 | T 50 | Alternate phone |
| PhoneType2 | T 4 | Alternate phone type (C=Cell, H=Home, WC=Wife Cell) |
| BirthDate | Date | Date of birth |
| YearsDriving | 6 | Years of driving before application |
| YearsVerified | T 255 | Number of verified years of driving experience |
| TalkedWithIran | T 20 | Yes=Interview with Delivery-Operations Manager |
| Interview | T 20 | Name of person conducting interview |
| RoadTest | T 20 | Y=Passed RoadTest |
| Physical | T 20 | Y=Passed Physical |
| WorkSteps | T 20 | |
| DandA | T 20 | |
| MVR | T 20 | Y=Passed motor vehicle review |
| Criminal | T 20 | Y=Passed criminal background check |
| Employment | T 20 | Y=Passed employment verification |
| Rating | T 2 | Letter grade A-F. U=Undecided |
| Hire | T 1 | Y=Yes, N=No, H=Hold, U=Undecided |
| EmployeeID | Long | Relates to tblEmployee |
| Inactive | Y/N | Yes=Inactive record |
| JobTitle | T 50 | Please select a Job Title for which this applicant applies |
| OnlineApp | T 20 | |
| OnlineProfile | T 20 | |
| OrientationDate | Date | Date of Orientation (m/d or m/d/yyyy) |
| PSP | T 20 | PSP Points |
| Region | T 5 | Please select a Region (* for all) |
| WH | T 5 | Please select a Warehouse (* for all in region) |
| Dept | T 50 | Please select a Department (* for all) |
| Comment | T 255 | Note about this record |
| Sel | Y/N | Yes=Select this record for processing |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | When record was last updated |
| tblAttendance 3801 recs | Info about driver absences PK: +ID | |
| ID | Long | Primary key |
| EmployeeID | Long | Relates to tblEmployee if employed |
| ExEmployeeID | Long | Relates to tblExEmployee if no longer employed |
| LastName | T 20 | Employee's last name |
| FirstName | T 15 | Employee's first name |
| Absence | Date | Date absence started |
| AbsenceEnd | Date | Date absence ended |
| AbsenceType | T 1 | A=Absent, T=Tardy |
| Total | 6 | CALC: Total number of days absent |
| Occurrences | 6 | CALC: Total number of absence occurrences |
| Status | T 255 | Action taken |
| Sel | Y/N | Yes=Select this record for processing |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | When record was last updated |
| tblCALog 2508 recs | CALog entries for an employee PK: +ID | |
| ID | Long | Primary key |
| EmployeeID | Long | Relates to tblEmployee |
| ExEmployeeID | Long | Relates to tblExEmployee |
| LastName | T 20 | Employee's last name |
| FirstName | T 15 | Employee's first name |
| Department | T 255 | Work department |
| LogDate | Date | Date of incident |
| CALevel | T 50 | Please select a level of action taken |
| Comment | T 255 | Note about this record |
| Sel | Y/N | Yes=Select this record for processing |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | When record was last updated |
| ByName | Y/N | NOT USED |
| CACat | T 5 | Please select category of log entry |
| tblCombo 184 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 |
| Region | T 5 | Region allowed to update this record |
| tblDI 8 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 | |
| Comment | T 255 | |
| Tbl | T 20 | |
| tblEmployee 256 recs | Info about drivers PK: +EmployeeID | |
| EmployeeID | Long | Primary key |
| LastName | T 20 | Employee's last name |
| FirstName | T 15 | Employee's first name |
| Region | T 5 | Please select a Region |
| WH | T 5 | Please select a Warehouse |
| DepartmentNo | T 5 | Please select a Department |
| JobTitle | T 50 | Please select a JobTitle |
| DriverNo | Long | Seniority. 1=Earliest hire date |
| BirthDate | Date | Employee's date of birth |
| HireDate | Date | Date employee was hired |
| PriorTTExp | Dbl | Number of years of trucking experience before HireDate |
| City | T 20 | Employee's home city |
| State | T 2 | Employee's home state |
| Status | T 20 | Current status |
| Return | Date | Date expected to return to duty status |
| Appt | Date | Date of last appointment |
| Last3dClass | Date | Last 3-D Classroom Training for driver (Expires in 3yr) |
| Last3dCommentaryDrive | Date | Last 3-D Commentary Drive for driver (Expires in 1yr) |
| Recognized | Date | Date accident free driving record was recognized (m/d or m/d/yyyy. DblClick for today. Num +/- to add/subtract a day |
| CellPhone | T 10 | Employee's cell phone number |
| HomePhone | T 10 | Employee's home phone number |
| EmergencyPhone | T 10 | Employee's emergency contact number |
| T 50 | Employee's email address | |
| DLNo | T 10 | Employee's driver license number |
| DLSt | T 2 | State that issued employee's driver license |
| CSAPoints | Long | CSA2010 points imported from CSA |
| Comment | T 255 | Note about this record |
| Sel | Y/N | Yes=Select this record for processing |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | When record was last updated |
| tblExEmployee 1563 recs | Info about ex-employees PK: +ID | |
| ID | Long | Primary key |
| LastName | T 20 | Employee's last name |
| FirstName | T 15 | Employee's first name |
| Hired | Date | Date employee was hired |
| LeftDate | Date | Date employee left company |
| Condition | T 1 | Q=Quit, T=Termed, X=Transferred |
| Cause | T 50 | Cause for departure |
| City | T 20 | City where ExEmployee was located |
| State | T 2 | State where ExEmployee was located |
| EmployeeID | Long | EmployeeID from tblEmployee |
| JobTitle | T 50 | Employee's job title |
| CellPhone | T 10 | Employee's cell phone number |
| HomePhone | T 10 | Employee's home phone number |
| EmergencyPhone | T 10 | Employee's emergency contact number |
| T 50 | Employee's email address | |
| Region | T 5 | Please select a Region (* for all) |
| WH | T 5 | Please select a Warehouse (* for all in region) |
| Dept | T 50 | Please select a Department (* for all) |
| Sel | Y/N | Yes=Select this record for processing |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | When record was last updated |
| tblOSD 3484 recs | Edit Over, Short, Damaged recs PK: +OSDID | |
| OSDID | Long | Primary key |
| OSDDate | Date | Date on which Overage/Shortage/Damage occurred |
| Route | T 5 | Route |
| Driver1 | T 30 | Please select the primary driver |
| Driver2 | T 30 | Please select the alternate driver |
| CustomerNo | T 7 | Customer Number |
| ItemNo | T 7 | Item Number |
| Qty | Long | Number of Cases |
| Each | Long | Number of individual items involved |
| Code | T 1 | Please select an OSDCode |
| ItemDescription | T 35 | Item Description |
| SlotNo | T 50 | Slot Number |
| Picker | T 30 | Please select the Order Picker |
| Region | T 5 | Please select a Region |
| WH | T 5 | Please select a Warehouse |
| Comment | T 50 | Note about this record |
| Sel | Y/N | Yes=Select this record for more processing |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | When record was last updated |
| tblReport 13 recs | Report menu PK: +ReportName | |
| ReportName | T 50 | Access name of report |
| ReportTitle | T 50 | Name of report displayed on Report form |
| Sort | 6 | Sort order in combo box |
| WH | Y/N | Yes=Must have fWH=* priveleges |
| tblSetup 1 recs | System unique info PK: +SetupID | |
| 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 from where files are imported |
| 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 | User who last updated this record |
| tblTicket 156 recs | Info about Traffic Tickets PK: +TicketID | |
| TicketID | Long | Primary key |
| EmployeeID | Long | Relates to tblEmployee |
| ExEmployeeID | Long | Relates to tblExEmployee |
| TicketDate | Date | When ticket was issued |
| Court | T 255 | Court issuing the ticket |
| Offense | T 50 | Details of the offense |
| TicketStatus | T 5 | Please select code to show the final outcome of the ticket |
| Points | Long | Number of points assigned to the ticket |
| Comment | T 255 | Note about this record |
| Sel | Y/N | Yes=Select this record for processing |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | When record was last updated |
| tblUser 19 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 |
| Region | T 5 | Please select a Region (* for all) |
| WH | T 5 | Please select a Warehouse (* for all in region) |
| Dept | T 50 | Please select a Department (* for all) |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | Time record was last updated |
| tmpCSA 149 recs | Used by CSA Import PK: +ID | |
| ID | Long | Primary key |
| EmployeeID | Long | Relates to tblEmployee |
| Risk Rank | Dbl | |
| DriverName | T 255 | |
| DriverLicense ID | T 255 | |
| Driver License State | T 255 | |
| InspectionCount | Dbl | |
| CrashCount | Dbl | |
| ViolationCount | Dbl | |
| CSA2010Points | Dbl | |
| CSA2010Points_PercentOOS | 5 | |
| CSA2010Points_PercentNONOOS | 5 | |
| Unsafe Driving | Dbl | |
| HOS Compliance | Dbl | |
| Driver Fitness | Dbl | |
| DrugsAlcohol | Dbl | |
| Vehicle Maint# | Dbl | |
| HazMat | Dbl | |
| Crash | Dbl | |
| Daylight Driver Index | 5 | |
| Sel | Y/N | |
| Usr | T 8 | |
| UpdDate | Date | |
| tmpOSD 0 recs | One time for OSD data 4/9/14 PK: +OSDID | |
| OSDID | Long | Primary key |
| OSDDate | Date | Date on which Overage/Shortage/Damage occurred |
| Route | T 5 | Route |
| Driver1 | T 30 | Please select the primary driver |
| Driver2 | T 30 | Please select the alternate driver |
| CustomerNo | T 7 | Customer Number |
| ItemNo | T 7 | Item Number |
| Qty | Long | Number of Cases |
| Each | Long | Number of individual items involved |
| Code | T 1 | Please select an OSDCode |
| ItemDescription | T 35 | Item Description |
| SlotNo | T 50 | Slot Number |
| Picker | T 30 | Please select the Order Picker |
| Comment | T 50 | Note about this record |
| Sel | Y/N | Yes=Select this record for more processing |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | When record was last updated |
| tmpOSDCode 9 recs | ||
| Combo | T 20 | |
| Code | T 5 | |
| Descrip | T 50 | |
| Sort | 6 | |
| Sel | Y/N | |
| Comment | T 255 | |
| Usr | T 8 | |
| UpdDate | Date | |
| tmpStars 1 recs | Used by Stars Import PK: +ID | |
| Sel | Y/N | Yes=Select this record for import |
| EmployeeID | Long | EmployeeID or negative number for ExEmployeeID |
| ID | Long | Primary key |
| ClaimNo | T 255 | Claim Number |
| Claimant | T 255 | Claimant Name |
| ClaimantSSN | T 255 | Claimant SSN |
| Status | T 255 | Please select Open or Final |
| Coverage | T 255 | Please select Coverage |
| Cause | T 255 | Please select Cause |
| LossDate | Date | Loss Date |
| Driver | T 255 | Driver Name - Responsible party |
| AccidentState | T 255 | State where loss occurred |
| Reported | Date | Dt Reported to Carrier/TPA |
| Incurred | Dbl | Incurred Total |
| Paid | Dbl | Paid Total |
| Reserve | Dbl | Reserve Total |
| Carrier | T 255 | Carrier/TPA |
| Descrip | T 255 | Accident Description |
| Usr | T 8 | User who last updated this record |
| Upddate | Date | When record was last updated |
| tTicket 0 recs | ||
| TicketID | Long | Primary key |
| EmployeeID | Long | Relates to tblEmployee |
| ExEmployeeID | Long | Relates to tblExEmployee |
| TicketDate | Date | When ticket was issued |
| Court | T 255 | Court issuing the ticket |
| Offense | T 50 | Details of the offense |
| TicketStatus | T 5 | Please select code to show the final outcome of the ticket |
| Points | Long | Number of points assigned to the ticket |
| Comment | T 255 | Note about this record |
| Sel | Y/N | Yes=Select this record for processing |
| Usr | T 8 | User who last updated this record |
| UpdDate | Date | When record was last updated |
| zName 187766 recs | ||
| LName | T 20 | |
| FName | T 30 | |
| id | Long | |
| 19 tables | ||