UBEF GENERIC INTERFACE
Back to current versionRestore this version

GENERIC BENEFIT / PAYROLL INTERFACE#

UBEF provides the capability for users to generate an interface file from employee basic information such as Personals, Employments, Prime Assignments, Entities, Locations, Jobs, Positions, Departments, Units, Groups and additional information for Benefit plans with Contacts information.

Step 1 - Define Lexicons in IMLNThe following lexicons are required for the UBEF to run, these are system provided; however#

we do advise to double check they are in your own database.

Step 2 - Define Interface Format in IDIF#

HL$BE_PENS_FILE is provided in the IDIF definitions screen as an example of a fixed format interface file.

You should use (Copy Definition) to copy into a different Interface Code and then enter your own company data.


Report Parameters#

Report Parameters
Entity Mandatory. You must enter an entity
From Date Mandatory. Enter a Pay Period Begin Date
To Date Mandatory. Enter a Pay Period End Date
Interface Code Mandatory. Enter the Interface code from the IDIF screen
Interface Level Mandatory. Specify the level for the Interface file to be produced; this must be '10'. Lexicon X_INTERFACE_LEVEL values are:
01 - EEM + EASD (not applicable for UBEF processing)
02 - EEM + EASD + Contacts (not applicable for UBEF processing)
10 - BE Plans
11 - BE + Contacts (not applicable for UBEF processing)
ER Addr Location Optional. This allows you to enter an overridden location to retrieve the employer’s address. If this is not specified, the entity's location address is used.
Sort by Active/Inactive Optional. Check this toggle to sort inactive employees first.
Sort Employees ByOptional. You should sort employees by Last Name/First Name, however, you may sort by the employee's pay destination or sort by Person code
Create File Optional. This field provides an option to create the file
Directory Name Optional. Enter a valid directory name
File NameOptional. Enter a file name or use the default file name from IDIF screen
Exception Level Optional. You should always run with the Exception level unless for tracing. In Trace Level 1, the employee header with Person Code and Employee Name are displayed with performance time, this can be used for Progress bar or to locate employee with problem. In Trace Level 2, the BE plans are displayed after employee header information

Report Filters
People List Code Optional. Please specify if People list is to be used
Person Code Optional. Enter one or more Person Codes
Location Optional. Enter one or more Location codes
Authorization Optional. Enter one or more Authorization Areas
Department Optional. Enter one or more Department Codes
Org Level TypeOptional. Enter one or more Org Level Types
Org Level Optional. Enter one or more Org Level within Org Level Types
Unit Optional. Enter one or more Unit codes
Group Optional. Enter one or more Group codes
Payroll Optional. Enter one or more Payroll Codes
Employment Status Optional. Enter one or more Employment Statuses
Termination Reason Optional. Enter one or more Termination Reasons
Plan Type Optional. This field is applicable if Interface Level = 'BE plans'
Plan Optional. This field is applicable if Interface Level = 'BE plans'