Head Count Detail Report (XML) : Interpreting the Output

The concurrent report - Head Count Detail Report (XML) - is a quite buggy. It is also difficult to interpret give the lack of documentation. This note attempts to address both.

I used the following parameters to submit this report:

The output that I got was as follows. Issues or inputs are highlighted in yellow.

SJain1. Why does the report show 01-Apr-2012 to 30-Apr-2012, when I have run the report for 2-Apr-2012 to 1-May-2012?

A1. Looks like Custom Time Zone profile setup issue, check running some other XML report.

SJain2. What do Rev/ Non Rev mean and how is it derived?

A2. Work Structures > Job > Description > Extra Information button > Type=Job Category. Enter the Details field for Category Name and select Revenue Generating from the LOV

SJain3. Where does the application derive whether an employee is Permanent/Fixed Term/Contract? Headcount showing under “Contract” does not correspond to the number of active Contingent Workers existing in the system.

A3. It is based on the HR_PERSON_TYPE formula

SJain4. Why “29” days, when I have run the report for 30 days?

A4. Looks like Custom Time Zone profile setup issue, check running some other XML report.

SJain5. What determines whether a termination is voluntary or involuntary?

A5. It is based on the HR_MOVE_TYPE formula and HR_CWK_MOVE_TYPE formulas.

SJain6. Where is this coming from? Is it coming from the parameter “Days Prior to End Date”? If so, this is wrong. Report should display only either “31” or “29” depending on whether the hierarchy version is end dated or not. (See New Hire, Last 29 Days column, where the number “31” does not appear).

A6. Similar to Question 1 and may depend on the date parameters.

SJain7. We do have employees in BAE SYSTEMS Australia Ltd., which is the business group, but also an HR Organization. Why do these employees not show up on the report?

A7. Can you check with some other Business Groups and log a bug if the data is shown.

SJain8. What does it take to round the “%” calculated by the report down to 2 decimals?

A8. This is an Enhancement Request

Report Parameters
Business Group	Australia Business Group
Report Date From	01-APR-2012
Report Date To	30-APR-2012[SJain1]
Report Date	08-MAY-2012
Organization Hierarchy	Australia Ltd
Top Organization	Australia Ltd
Worker Type	B
Roll Up	Y
Budget	HEAD
Include Top Organization	Y
Include Assignment Type	A
Days Prior To End date	31

Organization Hierarchy					Australia Ltd						Version Number						1
Date From					01-APR-2012						Date To						30-APR-2012
Top Organization					Australia Ltd
Division	Rev / Non Rev[SJain2]	Begin ning Head/ FTE Count	Perm-anent	Contract		Fixed Term[SJain3]	NewHire/		Transfer			Offers		Vac-ant FTE	Termination/				End-ing Head/ FTE	Cha-nge	% Cha-nge
															PlacementEnd
							Last 29[SJain4]  Days	Cum-ula-tive	In	Out		Op-en	Acc- ept-ed		Volu-ntary	Invol-untary[SJain5]		Last 31[SJain6]  29 Days
AIR BU	R	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
	N	21	0	1		21	0	0	1	0		0	0	0	0	0		0	22	1	4.76190
Australia Ltd	R	0 [SJain7]	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
	N	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
COR BU	R	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
	N	54	0	1		54	0	1	1	1		0	0	0	0	0		0	55	1	1.85185[SJain8]
DEL BU	R	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
	N	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
LIS BU	R	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
	N	11	0	0		11	0	0	0	0		0	0	0	0	0		0	11	0	0
MAR  BU	R	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
	N	17	0	2		17	0	3	0	0		0	0	0	0	0		0	20	3	17.6470

---