InsertEmployeeHistoryRecord

Insert Employee History Record

Minor Business Rule

Object Name: N0800057

Parent DLL: CFND

Location: Client/Server

Language: NER

Functional Description

Purpose
This function is intended to write (insert) a new record into the HR History table (F08042). This
function will take into account the sequential field (SEQ) that makes records in the table unique. It
will insure the record being written is unique based on the sequential number.

Setup Notes and Prerequisites

Special Logic

Technical Specification

^

Data Structure

DN0800057 - Insert Employee History Record

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnEmployeeNumber	AN8	MATH_NUMERIC	OPT	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
szDataItem	DTAI	char	OPT	INPUT
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
szHistoryData	HSTD	char	OPT	INPUT
The history information that is available for the data items listed in the Description column. Depending on the date in the upper-right corner of the screen, the changes will be either all changes made, or only changes made through that date.
jdDateEffectiveOn	EFTO	JDEDATE	OPT	INPUT
A future date when all changes will take effect or the date when the changes went into effect. If you do not enter a date in this field, the system uses the current date as the effective date.
szChangeReason	TRS	char	OPT	INPUT
A code that indicates the reason for one of the following: o Changing an active employee's record o Terminating an employee o Recommending a change in salary or rate This is a user defined code (06/T). If you are reactivating an employee, the code must be numeric. The code for new hires is the default reason code.
mnNumericValueOfHistory	HSTN	MATH_NUMERIC	NONE	INPUT
This field holds the numeric value of the History Data. Its primary use is to make manipulating historical information such a Annual Salary easier in World Writer.
szUserId	USER	char	OPT	INPUT
The code that identifies a user profile.
szProgramId	PID	char	OPT	INPUT
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.
szWorkStationId	JOBN	char	OPT	INPUT
The code that identifies the work station ID that executed a particular job.
jdDateUpdated	UPMJ	JDEDATE	OPT	INPUT
The date that specifies the last update to the file record.
szFileName	FILE	char	OPT	INPUT
The number of a specific table. For example, the Account Master table name is F0901. See the Standards Manual on the programmers' menu for naming conventions.

Related Functions

None

Related Tables

None