RetrieveF085540URL

Retrieve ESS URLs

Minor Business Rule

Object Name: N0800302

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this Named ER is to determine the correct URL to retrieve from the F085540 table.

Technical Specification

Parameters

Data Item Data Structure DescriptionI/ORequired TableNotes
AN8AddressNumberIR
LNGPLanguage PreferenceEnteredI/OWill return value if a blank value is passed in
LNGPLanguagePreferenceUsedOWill return value used by the function
COCompanyEnteredI/OWill return value if a blank value is passed in
COCompanyUsedOWill return value used by the function
DIVCBenefitGroupEnteredI/OWill return value if a blank value is passed in
DIVCBenefitGroupUsedOWill return value used by the function
SBGRBenefitGroupCategoryI
PLANPlanID I
AOPTPlanOptionI
URLTURLTypeI
PTURLPortalURLO
DTAIErrorCodeO
EV01SuppressErrorIReturns a "1" if no matches were found

Related Tables

Table Table Description
F085540Benefit Enrollment Paln/Option URL Address

Processing

1. Retrieve information pertaining to the employee entered.

2. Search for record with a matching key (LNGP, CO, DIVC, SBGR, PLAN, AOPT, URLT).

3. If no match found and the URL Type isn't blank, search for record with all fields matching and
URL Type = Blank.

4. If no match found and the Plan Option isn't blank, search for record with all fields matching and
Plan Option = Blank.

5. If no match found and the Plan Option and URL Type are't blank, search for record with all fields
matching and Plan Option and URL Type = Blank.

6. If no match found and the Plan isn't blank, search for record with all fields matching and
Plan and Plan Option = Blank.

7. If no match found and the Plan and URL Type aren't blank, search for record with all fields
matching and Plan, Plan Option and URL Type = Blank.

8. If no match found and the Category isn't blank, search for record with all fields matching and
Category, Plan, and Plan Option = Blank.

9. If no match found and the Category and URL Type aren't blank, search for record with all fields
matching and Category, Plan, Plan Option and URL Type = Blank.

10. Repeat steps 2 through 9 where the Language = Blank.

Data Structure

D0800302A - Retrieve ESS F085540 URLs

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

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.

szLanguagePreference_Entered LNGP char OPT BOTH

A user defined code (01/LP) that specifies the language to use on forms and printed reports. Before you specify a language, a code for that
language must exist at either the system level or in your user preferences.

szLanguagePreference_Used LNGP char OPT OUTPUT

A user defined code (01/LP) that specifies the language to use on forms and printed reports. Before you specify a language, a code for that
language must exist at either the system level or in your user preferences.

szCompany_Entered CO char OPT BOTH

A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.

szCompany_Used CO char OPT OUTPUT

A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.

szBenefitGroup_Entered DIVC char OPT BOTH

The benefit group to which the employee is assigned. Benefit groups facilitate employee enrollment by categorizing benefit plans and
allowing enrollment rules for those categories. For example, assigning an employee to an executive (EXEC) benefit group automatically links the
employee to the benefits available to executives in your organization.

szBenefitGroup_Used DIVC char OPT OUTPUT

The benefit group to which the employee is assigned. Benefit groups facilitate employee enrollment by categorizing benefit plans and
allowing enrollment rules for those categories. For example, assigning an employee to an executive (EXEC) benefit group automatically links the
employee to the benefits available to executives in your organization.

szBenefitGroupCategory SBGR char OPT INPUT

The category of a benefit group. The category is used to group benefit plans according to the type and/or rule. For
example: MEDICAL Required Medical Selections   DENTAL Optional Dental Selections   LIFE Required Life Ins Selections Valid categories are set up in the Generic
Rate and Message table (F00191) for system 08/type SG. Associated text for categories is stored in the General Message Detail table
(F00192). For more information, see program P00191.

cSuppressErrorMessage EV01 char OPT INPUT

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

szErrorCode DTAI char OPT OUTPUT

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.

szPortalURLs PTURL char OPT OUTPUT

This field displays the URL or code to use when the user executes the associated function.

szPlanId PLAN char OPT 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 OPT 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.

szURLType URLT char OPT INPUT

A code that forms a part of the index keys to identify the URL that is associated with the record.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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.
szLanguagePreference_Entered	LNGP	char	OPT	BOTH
A user defined code (01/LP) that specifies the language to use on forms and printed reports. Before you specify a language, a code for that language must exist at either the system level or in your user preferences.
szLanguagePreference_Used	LNGP	char	OPT	OUTPUT
A user defined code (01/LP) that specifies the language to use on forms and printed reports. Before you specify a language, a code for that language must exist at either the system level or in your user preferences.
szCompany_Entered	CO	char	OPT	BOTH
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
szCompany_Used	CO	char	OPT	OUTPUT
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
szBenefitGroup_Entered	DIVC	char	OPT	BOTH
The benefit group to which the employee is assigned. Benefit groups facilitate employee enrollment by categorizing benefit plans and allowing enrollment rules for those categories. For example, assigning an employee to an executive (EXEC) benefit group automatically links the employee to the benefits available to executives in your organization.
szBenefitGroup_Used	DIVC	char	OPT	OUTPUT
The benefit group to which the employee is assigned. Benefit groups facilitate employee enrollment by categorizing benefit plans and allowing enrollment rules for those categories. For example, assigning an employee to an executive (EXEC) benefit group automatically links the employee to the benefits available to executives in your organization.
szBenefitGroupCategory	SBGR	char	OPT	INPUT
The category of a benefit group. The category is used to group benefit plans according to the type and/or rule. For example: MEDICAL Required Medical Selections DENTAL Optional Dental Selections LIFE Required Life Ins Selections Valid categories are set up in the Generic Rate and Message table (F00191) for system 08/type SG. Associated text for categories is stored in the General Message Detail table (F00192). For more information, see program P00191.
cSuppressErrorMessage	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
szErrorCode	DTAI	char	OPT	OUTPUT
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.
szPortalURLs	PTURL	char	OPT	OUTPUT
This field displays the URL or code to use when the user executes the associated function.
szPlanId	PLAN	char	OPT	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	OPT	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.
szURLType	URLT	char	OPT	INPUT
A code that forms a part of the index keys to identify the URL that is associated with the record.