F08336F08336BRetrievalUpdate

F08336 Single Record Retrieval/Update

Minor Business Rule

Object Name: N0800135

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this NER is to Add, update, delete or inquire on a record in
F08336 and F08336WF.

Setup Notes and Prerequisites
Set cAction Code and pass the required parameters. Valid values for cAction code
are: 'I' for inquiry, 'D' for delete, 'C' for update, 'A' for insert.

Special Logic

Technical Specifications
If Data Base Action Code = 'I', fetchsingle on joined business view, V08336JA and
returns output parameters. If fetchsingle operation fails, return '1' for error
flag.

If Data Base Action Code = 'A', insert to joined business view, V08336JA. If
insert operation fails, return '1' for error flag.

If Data Base Action Code = 'C',

• Perform update to F08336. If update operation fails, return '1' for error flag.

• Perform fetch single on F08336B. There may not be a corresponding F08336B
record.
• If F08336B exists, update F08336B. Otherwise, insert F08336B

If Data Base Action Code = 'D',

• Delete F08336 record. If delete operation fails, return '1' for error flag.
• Perform fetch single on F08336B. There may be a corresponding F08336B record.
• If F08336B exists, delete F08336B.

Data Structure

D0800135 - F08336/F08336B Single Record Retrieval/Update

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cActionCode	VC01A	char	REQ	INPUT
cAction Code valid values are : 'I' = Inquiry 'C' = Update 'D' = Delete 'A' = Insert ^
mnAddressNumber	AN8	MATH_NUMERIC	REQ	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnParticipantAddress	PAN8	MATH_NUMERIC	REQ	INPUT
The address number of the participant as defined in the Participant file table (F08901).
cDepBen	DBEN	char	OPT	BOTH
A code that indicates whether the person is a dependent or a beneficiary of the employee. Valid codes are: D The person is a dependent. B The person is a beneficiary. Blank The system automatically designates the person as a beneficiary or dependent, depending on the benefit plan type.
jdDateEffectiveRates	EFT	JDEDATE	REQ	INPUT
The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
jdDateEndingEffective	EFTE	JDEDATE	OPT	BOTH
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnPercentageBeneficiary	PERC	MATH_NUMERIC	OPT	BOTH
The percentage of any proceeds from the benefit that goes to the participant. For example, you can designate that as the primary beneficiary, the participant is to receive 90% of the proceeds from a life insurance policy. This figure must have a value between zero and 100. If you do not type a value in this field, the system inserts 100%.
szDepBenType	DBTY	char	OPT	BOTH
A user defined code (table 08/DB) used to further describe a dependent or a beneficiary.
szPlanId	PLAN	char	REQ	INPUT
An abbreviation or number that identifies a specific employee benefit. Examples are: o Employee Health Insurance o Accidental Death and Dismemberment o Health Club Expense Reimbursement o Employee Stock Appreciation Rights A benefit plan typically is associated with a deduction, benefit, or accrual. For example, a medical plan is a benefit that might also require a deduction to withhold premiums from an employee's pay.
szPlanAdditionalOption	AOPT	char	REQ	INPUT
A code that identifies any additional options available for a benefit plan that have been defined in the Plan Additional Options table (F083202). Note: Additional options must have the same provider, policy number, and enrollment and eligibility rules as the benefit plan to which they are associated.
cDepBeneRelationship	RELA	char	OPT	BOTH
A user defined code (system 08/type RL) that defines the relationship of the dependent or beneficiary to the employee.
szEnrollmentEventCode	EECD	char	OPT	BOTH
The user defined code (08/BE) that you use to denote an enrollment event such as marriage.
jdEventDate	EDTE	JDEDATE	OPT	BOTH
The date on which a work order event took place.
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.
szWorkStationId	JOBN	char	OPT	BOTH
The code that identifies the work station ID that executed a particular job.
jdDateUpdated	UPMJ	JDEDATE	OPT	BOTH
The date that specifies the last update to the file record.
mnTimeLastUpdated	UPMT	MATH_NUMERIC	OPT	BOTH
The time that specifies when the program executed the last update to this record.
cError	EV01	char	OPT	OUTPUT
cError contains a '1' if the Data Base Action requested fails. ^

Related Functions

None

Related Tables

None