We are working on creating a FMLA database on access by pulling relevant tables from Time management module (S3). We have few questions to run a query. what are the transactional tables require to create a FMLA query with sufficient and relevant fields? The fields we are looking to pull out from the table are FMLA's start date and end date, time usage frame, accrual hours, exhausted FMLA or extended leave of absence.
I would appreciate if you could name the transactional tables that are most relevant and important to find the required information and create the FMLA query.
Thank you for trying to help, I really appreciate this!