CompPositionReqsHdctFTEHours

Compare Position to Total Requisition HeadCt FTE Hours

Minor Business Rule

Object Name: N0800235

Parent DLL: CHRM

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose

This function replaces the N0800116 adding new functionality to include comparisons of total requisition FTE and Hours to position FTE and Hours

1.2Setup Notes and Prerequisites
Home business unit for the requisition and position ID are required data inputs for this function.
1.3Special Logic

2.Technical Specifications

2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
HMCUszCostCenterHomeIYes
POSszPositionIDIYes
FYOWszFiscalYear9INoRetrieved according to HMCU if not input
REQNmnRequisitionNumberIYes
HDCTmnReqHeadcountI/OSet to total for all reqs. inF08102
EV01cHeadctErrorCodeO5 exceed max/ 2 position not found
FTEmnFullTimeEquivalentsI/OSet to total for all reqs. inF08102
EV01cFTEErrorCodeO5 exceed max/ 2 position not found
HRBcBudgetedPositionHoursI/OSet to total for all reqs. inF08102
EV01cHoursErrorCodeO5 exceed max/ 2 position not found

2.2Related Tables
Table Table Description
F08101Position Master
F08102Requisition Information

2.3Related Business Functions
Source NameFunction Name
N0800030Fiscal Year Begin & End Dates

2.4Processing

All Errors Set to 0

If Fiscal Year blank or Null
Get fiscal year according to HMCU with
Fiscal Year Begin & End Dates
End If

If No error from fiscal function

Fetch Position from F08101 - Position Master
Get values for position FTE, Hours and Headcount for
the fiscal year.

If fetch successful for position
Select all records in F08102 with Positions matching the Position
   passed in.

While records in select Fetch from F08102

Accumulate totals for FTE, Hours and Headcount for all Requisitions

at status AA or 99.
End While

Compare the three totals to the Position values
If each value FTE/Hours/Headcount is greater and blank not passed in
Set each error individually  = 5
end if

Send back totals to each value passed in.
else
No position was found
   Set all errors = 2
End If
End If

Data Structure

D0800235 - Compare Position to Total Requisition HeadCt FTE Hours

Parameter Name Data Item Data Type Req/Opt I/O/Both

szCostCenterHome HMCU char REQ INPUT

The number of the business unit in which the employee generally resides.

szPositionID POS char REQ INPUT

A code that you use for budgetary (position) control purposes. The position ID consists of:   o  Position (position code and its description)
o  Fiscal year     o  Home business unit For example, you can identify position A0-1 as Accounting Manager for fiscal year 2005-2006, for
home business unit 41. You might choose to set up positions so that the position IDs are the same as the corresponding job IDs. Within a home
business unit, positions appear in the alphanumeric sequence of their position IDs. For example, position A0-1 appears before position A0-2.

szFiscalYear9 FYOW char OPT INPUT

A four-digit number that identifies the fiscal year. You can enter a number in this field or leave the field blank to indicate the current fiscal
year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period. For
example, a fiscal year begins October 1, 2005, and ends September 30, 2006. The end of the first period is October 31, 2005. Specify the
year 2005 rather than 2006.

mnReqHeadcount HDCT MATH_NUMERIC OPT BOTH

The number of employees requested, budgeted, or approved for a position or requisition.

mnRequisitionNumber REQN MATH_NUMERIC OPT INPUT

The number that identifies the position requisition. This number must be unique. The next number program assigns this number if no other
number is provided when the requisition is initially entered.

mnFullTimeEquivalents FTE MATH_NUMERIC OPT BOTH

The full-time equivalent (FTE) amount. This figure is the portion of a full-time worker that an employee represents within the business unit.
For example, an employee who works 20 hours per week would represent .50 (1/2 FTE). This number cannot be greater than 1 for any
employee.

cBudgetedPositionHours HRB MATH_NUMERIC OPT BOTH

The number of hours that are budgeted for a position within a business unit for a period of one year. This is the total number of hours allotted
to a position for all the full-time equivalents (FTEs). If you do not enter a value in this field when you budget the position, the system enters a
default value. To determine that default value, the system searches the following sources, in the order that they are listed, and uses the value
from the first of these sources that contains a valid value: The number of FTEs multiplied by the standard number of hours per year for the
company associated with the business unit that you entered The number of FTEs multiplied by the standard number of hours per year for
Company 0 A default value that you defined in the data dictionary when you set up your system   2080

cFTEErrorCode EV01 char OPT OUTPUT

An option that specifies the type of processing for an event.

cHoursErrorCode EV01 char OPT OUTPUT

An option that specifies the type of processing for an event.

cHeadctErrorCode EV01 char OPT OUTPUT

An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCostCenterHome	HMCU	char	REQ	INPUT
The number of the business unit in which the employee generally resides.
szPositionID	POS	char	REQ	INPUT
A code that you use for budgetary (position) control purposes. The position ID consists of: o Position (position code and its description) o Fiscal year o Home business unit For example, you can identify position A0-1 as Accounting Manager for fiscal year 2005-2006, for home business unit 41. You might choose to set up positions so that the position IDs are the same as the corresponding job IDs. Within a home business unit, positions appear in the alphanumeric sequence of their position IDs. For example, position A0-1 appears before position A0-2.
szFiscalYear9	FYOW	char	OPT	INPUT
A four-digit number that identifies the fiscal year. You can enter a number in this field or leave the field blank to indicate the current fiscal year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 2005, and ends September 30, 2006. The end of the first period is October 31, 2005. Specify the year 2005 rather than 2006.
mnReqHeadcount	HDCT	MATH_NUMERIC	OPT	BOTH
The number of employees requested, budgeted, or approved for a position or requisition.
mnRequisitionNumber	REQN	MATH_NUMERIC	OPT	INPUT
The number that identifies the position requisition. This number must be unique. The next number program assigns this number if no other number is provided when the requisition is initially entered.
mnFullTimeEquivalents	FTE	MATH_NUMERIC	OPT	BOTH
The full-time equivalent (FTE) amount. This figure is the portion of a full-time worker that an employee represents within the business unit. For example, an employee who works 20 hours per week would represent .50 (1/2 FTE). This number cannot be greater than 1 for any employee.
cBudgetedPositionHours	HRB	MATH_NUMERIC	OPT	BOTH
The number of hours that are budgeted for a position within a business unit for a period of one year. This is the total number of hours allotted to a position for all the full-time equivalents (FTEs). If you do not enter a value in this field when you budget the position, the system enters a default value. To determine that default value, the system searches the following sources, in the order that they are listed, and uses the value from the first of these sources that contains a valid value: The number of FTEs multiplied by the standard number of hours per year for the company associated with the business unit that you entered The number of FTEs multiplied by the standard number of hours per year for Company 0 A default value that you defined in the data dictionary when you set up your system 2080
cFTEErrorCode	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
cHoursErrorCode	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
cHeadctErrorCode	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.