EmployeeSupervisorApprovelTable

Employee/Supervisor Approval Table Server

Minor Business Rule

Object Name: N0500340

Parent DLL: CFND

Location: Client/Server

Language: NER

Functional Description
The purpose of this business function is to add change delete and fetch records from f05842.

Technical Specifications
AddUpdateDeleteFlag can be set to A- Add, C- Update, D- Delete, F- Fetch
mnKeyValueSerialNumber is used for only one index if it is not greater then zero then the other index is used

Parameters
Data ItemRequiredI/ODescription
EV01YIcAddUpdateDeleteFlag
AN8NmnAddressNumber
ANPANmnSupervisor
LVELNnLevelInRelationToEmployee
APPTYNszApprovalType9
ANABNmnRespondingSupervisor
APPSTNcApprovalStatus
UPMJNjdDateUpdated
PIDNszProgramId
STCI NmnInstanceId
SERKNmnKeyValueSerialNumber
STCTYNszStatusChangeType
EV01NcError

Related Tables
Table Table Description
F05842Employee/Supervisor Approval History

Processing

If BF cAddUpdateDeleteFlag is equal to "F" Fetch record
If BF mnKeyValueSerialNumber is greater than "1" then use the secondary index otherwise use the primary index to fetch the record from F05842

If no record exists set cError = 1

Get Audit Information for adding and updating records

If BF cAddUpdateDeleteFlag is equal to "A" add a record

If file I/O fails set cError = 1

If BF cAddUpdateDeleteFlag is equal to "C" update a record
If BF mnKeyValueSerialNumber is greater than "1" then use the secondary index otherwise use the primary index to update the record in F05842

If no record exists set cError = 1

If BF cAddUpdateDeleteFlag is equal to "D" delete the record
If BF mnKeyValueSerialNumber is greater than "1" then use the secondary index otherwise use the primary index to Delete the record in F05842

If delete fails set cError = 1

Data Structure

D0500340 - Employee/Supervisor Approval Table Server DSTR

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cAddUpdateDeleteFlag	EV01	char	REQ	INPUT
A - Add, C - Update, D - Delete, F- Fetch
mnAddressNumber	AN8	MATH_NUMERIC	OPT	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnSupervisor	ANPA	MATH_NUMERIC	OPT	NONE
The address book number of the supervisor.
nLevelInRelationToEmployee	LVEL	integer	OPT	NONE
The number of organizational levels between an employee and a higher level supervisor. An employee's direct supervisor would be a level 1 relationship.
szApprovalType9	APPTY	char	OPT	NONE
A user defined code (05/AP) that specifies the type of change that requires an approval. For example, the approval type code required to approve a compensation change is COMP.
mnRespondingSupervisor	ANAB	MATH_NUMERIC	OPT	NONE
The supervisor responding to a request.
cApprovalStatus	APPST	char	OPT	NONE
A code that indicates whether an employee status change has been approved. Valid values are: Blank Pending 1 Approved 2 Rejected
jdDateUpdated	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
szProgramId	PID	char	OPT	NONE
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.
mnInstanceId	STCI	MATH_NUMERIC	OPT	NONE
The code that creates unique status change records. You use this code in conjunction with the Status Change Type field (STCTY).
mnKeyValueSerialNumber	SERK	MATH_NUMERIC	OPT	NONE
A key identification number used internally to identify a composite key structure. The actual key items must be stored in another file and given this serial number. This is to avoid repeating a very large key structure with repeating data items.
cError	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szStatusChangeType	STCTY	char	OPT	NONE
A code that specifies the type of status change. The status change type is validated against UDC 08/S4. An example of a status change type is PROMO for Promotion. To define a new type of status change, you must first add the change type to the UDC table.

Related Functions

None

Related Tables

None