HRIS is something I've never done.
So am thankful that Prasad identifies some of the issues and outlines some ways to go about it:
Yeah, I know.
(1) there should be a set of business rules that are clearly understood and consistently applied across geographies and businesses (which would lead to 'patterns in data') AND
(2) the data standards embedded in these business rules should be used to form the logic/criteria for generating the relevant reports (that capture the data patterns) AND
(3) it should be possible to express the criteria in terms of HRIS fields AND
(4) the query tool should be able to pull out the data as per the criteria
Always, easier said than done !