HI the tables below are used to populate the data for the "Time Track Report".  When you state the "the data does not export in a user-friendly format" can you provide details of what you expect to export, what is not user friendly and how you are exporting the data? 

John Nichols

Sage

PR_TimeTrack
PR_Employee
PR_TimeTrackHistory
JC_Job
JC_CostCode
PR_Department
PR_EarningsCode
PR_LaborCode
PR_TaxProfile
PR_TaxState
PR_TimeTrackShift
PR_WorkersComp
PR_Options

I jcnichols. When I'm in Sage and run a TimeCard report a job, the excel export data is not easy to manipulate for analysis. When I try to create a Microsoft SQL query and select the time card tables (i.e. TimeCard masterfile, etc), no data is returned. I'd like to create a query that includes: Job #, cost code, employee name and #, date worked, department worked. Any help would be greatly appreciated! I'll try your above suggestion. 

One item to note, we don't use Sage to process payroll, but employee hours are manually entered into the system.

I jcnichols. When I'm in Sage and run a TimeCard report a job, the excel export data is not easy to manipulate for analysis. When I try to create a Microsoft SQL query and select the time card tables (i.e. TimeCard masterfile, etc), no data is returned. I'd like to create a query that includes: Job #, cost code, employee name and #, date worked, department worked. Any help would be greatly appreciated! I'll try your above suggestion. 

One item to note, we don't use Sage to process payroll, but employee hours are manually entered into the system.

HI What version of sage 100 are you using? Thx John

Sage 100 Standard 2017 V 5.40.0.0

Hi,

Legacy ODBC File Name to Framework File Name

TC0_TCParameters-> PR_TImeTrackOptions
TC1_TimecardMasterfile -> PR_TimeTrack
TC3_TimecardMastefile -> PR_TimeTrackHistory
TC6_EarningsCostCode  -> JC_CostCodeEarningsCode
TCA_EmployeeMasterfile -> PR_Employee
TCG_ShiftMasterfile   -> PR_TimeTrackShift
TCJ_JobMasterfile   -> JC_Job

Hope this helps. Via Excel MS Query create your SQL statement using the legacy ODBC file names.