Z:\WORK\PFG.MDB Tables (7/26/2016 1:03:28 PM)

tblAccident 593 recs
EmployeeIDLongRelates to tblEmployee
AccidentDateDateDate of accident
AccidentTypeT 50Please select AccidentType
ExEmployeeIDLong
ClaimantT 30Claimant LastName, FirstName
ClaimantSSNT 9Claimant SSN
ClaimNoT 15Claim number
CoverageT 20Please select a Coverage
CauseT 40Please select a Cause
DescripT 255Description of accident
StatusT 1Please select a Status
AccidentStateT 2State in which accident occurred
ReportedDateDate accident was reported to Carrier/TPA
IncurredDblDollars of damage claimed
PaidDblDollars of damage paid
ReserveDblDollars reserved for payment
CarrierT 3Please select a Carrier
PointsLongNumber of Accident Points for this accident
MVRLong
PreventableY/NYes=Accident was preventable. Show on report
CommentT 255Text about this record
SelY/NYes=Select this record for processing
UsrT 8User who last updated this record
UpdDateDateWhen record was last updated

tblApplicant 1549 recs
ApplicantIDLongPrimary key
ReferredByT 255Who referred this applicant
CurrentEmployerT 255Applicant's current employer (PFG if hired)
LastNameT 255Applicant's last name
FirstNameT 50Applicant's first name
CityT 255Where applicant is living
StateT 2Where applicant is living
PriorCityT 50Where applicant lived before
PriorStateT 2Where applicant lived before
PhoneT 50Primary phone
PhoneTypeT 1Primary phone Type (C=Cell, H=Home)
Phone2T 50Alternate phone
PhoneType2T 4Alternate phone type (C=Cell, H=Home, WC=Wife Cell)
BirthDateDateDate of birth
YearsDriving6Years of driving before application
YearsVerifiedT 255Number of verified years of driving experience
TalkedWithIranT 20Yes=Interview with Delivery-Operations Manager
InterviewT 20Name of person conducting interview
RoadTestT 20Y=Passed RoadTest
PhysicalT 20Y=Passed Physical
WorkStepsT 20
DandAT 20
MVRT 20Y=Passed motor vehicle review
CriminalT 20Y=Passed criminal background check
EmploymentT 20Y=Passed employment verification
RatingT 2Letter grade A-F. U=Undecided
HireT 1Y=Yes, N=No, H=Hold, U=Undecided
EmployeeIDLongRelates to tblEmployee
InactiveY/NYes=Inactive record
JobTitleT 50Please select a Job Title for which this applicant applies
OnlineAppT 20
OnlineProfileT 20
OrientationDateDateDate of Orientation (m/d or m/d/yyyy)
PSPT 20PSP Points
RegionT 5Please select a Region (* for all)
WHT 5Please select a Warehouse (* for all in region)
DeptT 50Please select a Department (* for all)
CommentT 255Note about this record
SelY/NYes=Select this record for processing
UsrT 8User who last updated this record
UpdDateDateWhen record was last updated

tblAttendance 3801 recs
Info about driver absences
PK: +ID
IDLongPrimary key
EmployeeIDLongRelates to tblEmployee if employed
ExEmployeeIDLongRelates to tblExEmployee if no longer employed
LastNameT 20Employee's last name
FirstNameT 15Employee's first name
AbsenceDateDate absence started
AbsenceEndDateDate absence ended
AbsenceTypeT 1A=Absent, T=Tardy
Total6CALC: Total number of days absent
Occurrences6CALC: Total number of absence occurrences
StatusT 255Action taken
SelY/NYes=Select this record for processing
UsrT 8User who last updated this record
UpdDateDateWhen record was last updated

tblCALog 2508 recs
CALog entries for an employee
PK: +ID
IDLongPrimary key
EmployeeIDLongRelates to tblEmployee
ExEmployeeIDLongRelates to tblExEmployee
LastNameT 20Employee's last name
FirstNameT 15Employee's first name
DepartmentT 255Work department
LogDateDateDate of incident
CALevelT 50Please select a level of action taken
CommentT 255Note about this record
SelY/NYes=Select this record for processing
UsrT 8User who last updated this record
UpdDateDateWhen record was last updated
ByNameY/NNOT USED
CACatT 5Please select category of log entry

tblCombo 184 recs
Values for combo boxes
PK: +Combo;+Code
ComboT 20Name of combo box
CodeT 5Value returned by combo box
DescripT 50Long description that appears in combo
Sort6Sort order for combo
SelY/NYes=Select this record for processing
CommentT 255Note about this record
UsrT 8User who last updated this record
UpdDateDateWhen record was last updated
RegionT 5Region allowed to update this record

tblDI 8 recs
Data Integrity queries
PK: +DIQuery
DIQueryT 100Primary key
DIRecsLongCount of recs in query
Sort6Sort order of query
FixY/NYes=Fix w/qFix...
NoteT 255
CommentT 255
TblT 20

tblEmployee 256 recs
Info about drivers
PK: +EmployeeID
EmployeeIDLongPrimary key
LastNameT 20Employee's last name
FirstNameT 15Employee's first name
RegionT 5Please select a Region
WHT 5Please select a Warehouse
DepartmentNoT 5Please select a Department
JobTitleT 50Please select a JobTitle
DriverNoLongSeniority. 1=Earliest hire date
BirthDateDateEmployee's date of birth
HireDateDateDate employee was hired
PriorTTExpDblNumber of years of trucking experience before HireDate
CityT 20Employee's home city
StateT 2Employee's home state
StatusT 20Current status
ReturnDateDate expected to return to duty status
ApptDateDate of last appointment
Last3dClassDateLast 3-D Classroom Training for driver (Expires in 3yr)
Last3dCommentaryDriveDateLast 3-D Commentary Drive for driver (Expires in 1yr)
RecognizedDateDate accident free driving record was recognized (m/d or m/d/yyyy. DblClick for today. Num +/- to add/subtract a day
CellPhoneT 10Employee's cell phone number
HomePhoneT 10Employee's home phone number
EmergencyPhoneT 10Employee's emergency contact number
EmailT 50Employee's email address
DLNoT 10Employee's driver license number
DLStT 2State that issued employee's driver license
CSAPointsLongCSA2010 points imported from CSA
CommentT 255Note about this record
SelY/NYes=Select this record for processing
UsrT 8User who last updated this record
UpdDateDateWhen record was last updated

tblExEmployee 1563 recs
Info about ex-employees
PK: +ID
IDLongPrimary key
LastNameT 20Employee's last name
FirstNameT 15Employee's first name
HiredDateDate employee was hired
LeftDateDateDate employee left company
ConditionT 1Q=Quit, T=Termed, X=Transferred
CauseT 50Cause for departure
CityT 20City where ExEmployee was located
StateT 2State where ExEmployee was located
EmployeeIDLongEmployeeID from tblEmployee
JobTitleT 50Employee's job title
CellPhoneT 10Employee's cell phone number
HomePhoneT 10Employee's home phone number
EmergencyPhoneT 10Employee's emergency contact number
EmailT 50Employee's email address
RegionT 5Please select a Region (* for all)
WHT 5Please select a Warehouse (* for all in region)
DeptT 50Please select a Department (* for all)
SelY/NYes=Select this record for processing
UsrT 8User who last updated this record
UpdDateDateWhen record was last updated

tblOSD 3484 recs
Edit Over, Short, Damaged recs
PK: +OSDID
OSDIDLongPrimary key
OSDDateDateDate on which Overage/Shortage/Damage occurred
RouteT 5Route
Driver1T 30Please select the primary driver
Driver2T 30Please select the alternate driver
CustomerNoT 7Customer Number
ItemNoT 7Item Number
QtyLongNumber of Cases
EachLongNumber of individual items involved
CodeT 1Please select an OSDCode
ItemDescriptionT 35Item Description
SlotNoT 50Slot Number
PickerT 30Please select the Order Picker
RegionT 5Please select a Region
WHT 5Please select a Warehouse
CommentT 50Note about this record
SelY/NYes=Select this record for more processing
UsrT 8User who last updated this record
UpdDateDateWhen record was last updated

tblReport 13 recs
Report menu
PK: +ReportName
ReportNameT 50Access name of report
ReportTitleT 50Name of report displayed on Report form
Sort6Sort order in combo box
WHY/NYes=Must have fWH=* priveleges

tblSetup 1 recs
System unique info
PK: +SetupID
SetupIDLongPrimary key
CompanyT 50Name of company
StreetT 50Company street for mailing address
CityT 20City in which Company is located
StateT 2State in which Company is located
ZipT 10Zip code for company
PhoneT 14Company phone number
FaxT 14Company Fax number
WebsiteT 50Company website
EMailT 50Company email address
ImportFolderT 50Folder from where files are imported
QuitT 255Message for users when super issues a forced quit command
Ver6Latest version of front end available for download
UsrT 8User who last updated this record

tblTicket 156 recs
Info about Traffic Tickets
PK: +TicketID
TicketIDLongPrimary key
EmployeeIDLongRelates to tblEmployee
ExEmployeeIDLongRelates to tblExEmployee
TicketDateDateWhen ticket was issued
CourtT 255Court issuing the ticket
OffenseT 50Details of the offense
TicketStatusT 5Please select code to show the final outcome of the ticket
PointsLongNumber of points assigned to the ticket
CommentT 255Note about this record
SelY/NYes=Select this record for processing
UsrT 8User who last updated this record
UpdDateDateWhen record was last updated

tblUser 19 recs
Info about users
PK: +UserID
UserIDT 8Primary key
UserNameT 20First and last name of user
EMailT 50EMail address of user
PhoneT 14Phone number of user
CommentT 255Text about this user
SuperY/NYes=User can add/remove users
LimitedY/NYes=User has read only access
RegionT 5Please select a Region (* for all)
WHT 5Please select a Warehouse (* for all in region)
DeptT 50Please select a Department (* for all)
UsrT 8User who last updated this record
UpdDateDateTime record was last updated

tmpCSA 149 recs
Used by CSA Import
PK: +ID
IDLongPrimary key
EmployeeIDLongRelates to tblEmployee
Risk RankDbl
DriverNameT 255
DriverLicense IDT 255
Driver License StateT 255
InspectionCountDbl
CrashCountDbl
ViolationCountDbl
CSA2010PointsDbl
CSA2010Points_PercentOOS5
CSA2010Points_PercentNONOOS5
Unsafe DrivingDbl
HOS ComplianceDbl
Driver FitnessDbl
DrugsAlcoholDbl
Vehicle Maint#Dbl
HazMatDbl
CrashDbl
Daylight Driver Index5
SelY/N
UsrT 8
UpdDateDate

tmpOSD 0 recs
One time for OSD data 4/9/14
PK: +OSDID
OSDIDLongPrimary key
OSDDateDateDate on which Overage/Shortage/Damage occurred
RouteT 5Route
Driver1T 30Please select the primary driver
Driver2T 30Please select the alternate driver
CustomerNoT 7Customer Number
ItemNoT 7Item Number
QtyLongNumber of Cases
EachLongNumber of individual items involved
CodeT 1Please select an OSDCode
ItemDescriptionT 35Item Description
SlotNoT 50Slot Number
PickerT 30Please select the Order Picker
CommentT 50Note about this record
SelY/NYes=Select this record for more processing
UsrT 8User who last updated this record
UpdDateDateWhen record was last updated

tmpOSDCode 9 recs
ComboT 20
CodeT 5
DescripT 50
Sort6
SelY/N
CommentT 255
UsrT 8
UpdDateDate

tmpStars 1 recs
Used by Stars Import
PK: +ID
SelY/NYes=Select this record for import
EmployeeIDLongEmployeeID or negative number for ExEmployeeID
IDLongPrimary key
ClaimNoT 255Claim Number
ClaimantT 255Claimant Name
ClaimantSSNT 255Claimant SSN
StatusT 255Please select Open or Final
CoverageT 255Please select Coverage
CauseT 255Please select Cause
LossDateDateLoss Date
DriverT 255Driver Name - Responsible party
AccidentStateT 255State where loss occurred
ReportedDateDt Reported to Carrier/TPA
IncurredDblIncurred Total
PaidDblPaid Total
ReserveDblReserve Total
CarrierT 255Carrier/TPA
DescripT 255Accident Description
UsrT 8User who last updated this record
UpddateDateWhen record was last updated

tTicket 0 recs
TicketIDLongPrimary key
EmployeeIDLongRelates to tblEmployee
ExEmployeeIDLongRelates to tblExEmployee
TicketDateDateWhen ticket was issued
CourtT 255Court issuing the ticket
OffenseT 50Details of the offense
TicketStatusT 5Please select code to show the final outcome of the ticket
PointsLongNumber of points assigned to the ticket
CommentT 255Note about this record
SelY/NYes=Select this record for processing
UsrT 8User who last updated this record
UpdDateDateWhen record was last updated

zName 187766 recs
LNameT 20
FNameT 30
idLong

19 tables