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 |