F08101PositionMasterOperations

F08101 Position Master Operations

Minor Business Rule

Object Name: N0800143

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
This NER is to allow the normal file I/O operations on the Position Master file (F08101). The user
must pass in a Operation variable to specify which operation is being performed.

Setup Notes and Prerequisites
If the NER is being run to perform an add or an update to the Position Master file, the user must
pass in a complete key (Home Business Unit, Fiscal Year, and Position ID) as well as audit information
(User ID, Workstation ID, Date Updated and Program ID).

Special Logic
It is possible to perform inquiries and deletes on partial keys. On an inquiry, the NER will search
for any record that matches the partial key and return the values of the first record found.
On a deletion, the NER will delete all records that match the partial key. WARNING: IT IS POSSIBLE TO
DELETE ALL RECORDS FROM THE FILE IF ALL THREE PARTS OF THE KEY ARE LEFT BLANK.

Technical Specification

cOperation - Required input field.
All fields from F08101 - Input/output.
cErrorCode - Output field.

The 'Operation' values are as follows:
I = Inquire on existing record (partial keys allowed)
D = Delete existing record(s) (partial keys allowed)
A = Add record to F08101.
U = Update F08101 record.

The 'Error Code' values are as follows:
0 = No errors. Operation performed successfully.
1 = Error. Key field (Home Business Unit, Fiscal Year, and or Position ID) required.
2 = Error. Audit information required.
3 = File I/O error. Operation could not be performed.
4 = Error. Invalid operation requested.

Overview of logic:
If Operation = 'I'
Find match in F08101 with full or partial key
If found,
Return information of first record found
Else
Error = 3
Endif
Endif

If Operation = 'D'
Find all records in F08101 with a matching full or partial key
If found,
Delete records
Else
Error = 3
Endif
Endif

If Operation = 'I' or Operation = 'U'
If missing key fields
Error = 1
Else
If missing audit information
Error = 2
Else
If Operation = 'A'
Add record
Else
Update Record
Endif
Endif
Endif
Else
If Operation is not a valid value
Error = 4
Endif
Endif

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cOperation	EV01	char	REQ	INPUT
An option that specifies the type of processing for an event.
szCostCenterHome	HMCU	char	OPT	BOTH
The number of the business unit in which the employee generally resides.
mnFiscalYear1	FY	MATH_NUMERIC	OPT	BOTH
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it 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, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the year 98 rather than 99.
szPositionID	POS	char	OPT	BOTH
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.
szCostCenter	MCU	char	OPT	BOTH
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szDescription001	DL01	char	OPT	BOTH
A user defined name or remark.
szDescription01002	DL02	char	OPT	BOTH
Additional text that further describes or clarifies a field in the system.
jdDateEffectiveFrom	EFTS	JDEDATE	OPT	BOTH
The date on which a requisition, a position, or activity within a position takes effect.
jdDateEffectiveThru	EFST	JDEDATE	OPT	BOTH
The date on which a requisition, a position, or an activity within a position is no longer in effect. In position activity, the default value for this field is the end of the current fiscal year so that the system can calculate projected figures.
cPositionStatus	PSTC	char	OPT	BOTH
A code that indicates the status of the position budget. The system uses the first character in the second description in the user defined code table 08/PC to process approved and closed positions. The position's budget must have an approved status before you can assign it to an employee or to an approved requisition. Positions with a closed budget status are not included when you run Create Next Year's Position Budgets (P081820).
mnAmountPositionBudget	CURB	MATH_NUMERIC	OPT	BOTH
The salary amount that is budgeted for a particular position within a business unit. This figure, which comes from the Position Master table (F08101), represents the total salary amount budgeted for all of the full-time equivalent (FTEs) within this position, for the business unit and year that you specified.
mnBudgetedFte	BFTE	MATH_NUMERIC	OPT	BOTH
The number of full-time equivalents (FTEs) that your organization has budgeted for the position. A full-time equivalent is the portion of a full-time worker that an employee represents within a business unit. For example, an employee who works 20 hours per week represents .50 (one-half) FTE. An employee cannot represent more than 1 FTE.
mnBudgetedPositionHours	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
szParentCostCenter	PMCU	char	OPT	BOTH
A code that identifies the Business Unit (MCU) that this Position reports to, such as the Supervisor's Business Unit. The Parent Position / Parent Business Unit must already exist as a Position ID/ Business Unit record in the Position Master File. For example, Bob Jones is a senior programmer in Business Unit 100 and he reports to Sally Abbot who is a junior manager in Business Unit 200. Bob Jones: Position ID = SRPRG Business Unit = 100 Parent Position ID = JRMGR Parent Business Unit = 200 Sally Abbot: Position ID = JRMGR Business Unit = 200
szParentPositionId	PPOS	char	OPT	BOTH
A code that identifies the higher level position this position reports to, such as the supervisor position ID. NOTE: The parent position/parent business unit must already exist as a position ID or business unit record in the Position Master File.
szJobCategory	JBCD	char	OPT	BOTH
A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and apply that information to the employees who are linked to that job type.
szJobStep	JBST	char	OPT	BOTH
A user defined code (07/GS) that designates a specific level within a particular job type. The system uses this code in conjunction with job type to determine pay rates by job in the Pay Rates table.
szSalaryDataLocality	SLOC	char	OPT	BOTH
A user defined code (07/SL) that defines the different salary localities within an organization. For example, you can compare salaries for employees on the East Coast with employees in the Midwest.
szCategoryCodePositio001	PX01	char	OPT	BOTH
A user defined code (08/P1) that classifies Position Master records (unique by fiscal year, business unit, and position ID) for reporting purposes. For example, you might classify positions by their field of work. In this case, position codes could be set up as follows: CLT Client Services ENG Engineering FIN Business Finance LAB Contract Labor MGR Business Management PRG Programming
szCategoryCodePositio002	PX02	char	OPT	BOTH
A user defined code (system 08, type P2) used to classify Position Master records (unique by fiscal year, business unit, and position ID) for reporting purposes. For example, you may wish to classify positions by their field of work. In this case, position codes could be set up as follows: CLT Client Services ENG Engineering FIN Business Finance LAB Contract Labor MGR Business Management PRG Programming
szCategoryCodePositio003	PX03	char	OPT	BOTH
A user defined code (system 08, type P3) used to classify Position Master records (unique by fiscal year, business unit, and position ID) for reporting purposes. For example, you may wish to classify positions by their field of work. In this case, position codes could be set up as follows: CLT Client Services ENG Engineering FIN Business Finance LAB Contract Labor MGR Business Management PRG Programming
szCategoryCodePositio004	PX04	char	OPT	BOTH
A user defined code (system 08, type P4) used to classify Position Master records (unique by fiscal year, business unit, and position ID) for reporting purposes. For example, you may wish to classify positions by their field of work. In this case, position codes could be set up as follows : CLT Client Services ENG Engineering FIN Business Finance LAB Contract Labor MGR Business Management PRG Programming
szCategoryCodePositio005	PX05	char	OPT	BOTH
A user defined code (system 08, type P5) used to classify Position Master records (unique by fiscal year, business unit, and position ID) for reporting purposes. For example, you may wish to classify positions by their field of work. In this case, position codes could be set up as follows: CLT Client Services ENG Engineering FIN Business Finance LAB Contract Labor MGR Business Management PRG Programming
szUserId	USER	char	OPT	BOTH
The code that identifies a user profile.
szProgramId	PID	char	OPT	BOTH
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
jdDateUpdated	UPMJ	JDEDATE	OPT	BOTH
The date that specifies the last update to the file record.
szWorkStationId	JOBN	char	OPT	BOTH
The code that identifies the work station ID that executed a particular job.
szPositionType	TPOS	char	OPT	BOTH
A code that identifies the type of job position an employee holds.
mnAmountSpendingAuthorizat	SPAM	MATH_NUMERIC	OPT	BOTH
The spending level authorized for this position.
jdBudgetStatusDate	PBSD	JDEDATE	OPT	BOTH
The date the current budget status became active.
cPosStat	PSST	char	OPT	BOTH
The current activity level of the position. When you attach an employee record to a vacant position, the system updates the position status with the position status code that has DEFA in it special handling doce. The system updates the position status code on the beginning date of the employee's assignment. When the position again becomes vacant, you must manually change the value in the Position Status field.
jdPositionStatusDate	PSSD	JDEDATE	OPT	BOTH
The date the current status of the position became active.
mnHeadcount	HDCT	MATH_NUMERIC	OPT	BOTH
The number of employees requested, budgeted, or approved for a position or requisition.
mnAmountEffectiveBudget	EFFB	MATH_NUMERIC	OPT	BOTH
The salary amount that is budgeted for a particular position within a business unit. This figure, which comes from the Position Master table (F08101),represents the total salary amount budgeted for all of the full-time equivalents (FTEs) within this position. The system uses the effective from and effective through dates to calculate the effective salary amount that is budgeted. If the effective through date is blank, the system uses the end date for the fiscal year to calculate the effective salary budget.
mnHoursEffectiveBudget	EFHR	MATH_NUMERIC	OPT	BOTH
The number of hours budgeted for a particular position within a business unit. The system uses the effective from and effective through dates to calculate the effective budget hours. If the effective through date is blank, the system uses the end date for the fiscal year to calculate the effective hours that are budgeted.
mnFullTimeEquivalentsEffec	FTEE	MATH_NUMERIC	OPT	BOTH
The number of full-time equivalents (FTEs) that your organization has budgeted for the position. A full-time equivalent is the portion of a full-time worker that an employee represents within a business unit. For example, an employee who works 20 hours per week represents .50 (one-half) FTE. An employee cannot represent more than 1 FTE. The system uses the effective from and effective through dates to calculate the effective budget hours. If the effective through date is blank, the system uses the end date for the fiscal year to calculate the effective budget.
cErrorCode	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.

F08101PositionMasterOperations