pbare
Well Known Member
My business has asked us to provide them with a list of employees that have had a changed in PAST in 2014 and at the same time show which HMCU they were in at that particular time.
This is just a one time audit request so a custom report is not possible at this time.
I am trying to query against the HR History table (F08042) for records in 2014 with a change to PAST; then I need to find the HMCU value that corresponds to that time frame.
E1 does have a point in time process but that appears to be something that can be run for a specific date not a date range :-( And it is for Employee Master records (not the history of that change)
Would anyone know if it is possible to get the following information
Employee Number (AN8)
PAST Value (HSTD) Where DTAI = PAST
EFTO PAST
HMCU Value (HSTD) where DTAI = HMCU
EFTO HMCU - this needs to correspond the range that the PAST value is for
This is a time sensitive request so I would appreciate any help that someone can provide
Thanks
Pam
This is just a one time audit request so a custom report is not possible at this time.
I am trying to query against the HR History table (F08042) for records in 2014 with a change to PAST; then I need to find the HMCU value that corresponds to that time frame.
E1 does have a point in time process but that appears to be something that can be run for a specific date not a date range :-( And it is for Employee Master records (not the history of that change)
Would anyone know if it is possible to get the following information
Employee Number (AN8)
PAST Value (HSTD) Where DTAI = PAST
EFTO PAST
HMCU Value (HSTD) where DTAI = HMCU
EFTO HMCU - this needs to correspond the range that the PAST value is for
This is a time sensitive request so I would appreciate any help that someone can provide
Thanks
Pam