This page (revision-7) was last changed on 26-Nov-2021 10:22 by JEscott

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
7 26-Nov-2021 10:22 5 KB JEscott to previous
6 26-Nov-2021 10:22 5 KB JEscott to previous | to last
5 26-Nov-2021 10:22 5 KB JEscott to previous | to last
4 26-Nov-2021 10:22 5 KB JEscott to previous | to last
3 26-Nov-2021 10:22 5 KB JEscott to previous | to last
2 26-Nov-2021 10:22 3 KB JEscott to previous | to last
1 26-Nov-2021 10:22 3 KB JEscott to last

Page References

Incoming links Outgoing links
UBEF GENERIC INTERFACE
UBEF GENERIC INTERFACE

Version management

Difference between version and

At line 1 added one line
[{TableOfContents }]
At line 4 added one line
!!Required Set Up
At line 6 changed 2 lines
!Step 1 - Define Lexicons in [IMLN]The 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 1 - Define Lexicons in [IMLN]
The 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.
At line 18 changed one line
!!Report Parameters
!!Processing Information
From selection criteria, UBEF retrieves employee basic information and primary assignment information
From parameter Interface Level, the data base tables will be loaded accordingly:
*at company level: DEN / DLN / DDP / DDD / DUN / DGR / DGD / DGV
*at employee level: EID / EPS / EEM / EAS / EASD / PPRU / PPRC / ECT
*for BE only: BPT / BPN / BCG / BCGD / BCGD / BCGR / BEND / BBR / ECT
From parameter Interface Level, the following information will be written to the interface file
Lexicon [X_INTERFACE_LEVEL] values:
|01 - EEM + EASD| *(not applicable for UBEF processing)
|02 - EEM + EASD + Contacts |* (not applicable for UBEF processing)
|10 - BE Plans | *primary Assignment and BE related data base tables are loaded \\* this level will perform IDIF Record Type 'Detail Record' for each BE plan \\*i.e. write one entry per employee for each BE plan
|11 - BE + Contacts |* (not applicable for UBEF processing).
UBEF provides an audit report in Excel spreadsheet format to verify each data column that is entered in the interface file, in order to obtain this report, the UBEF function must be run a second time using the exact same parameters that was used to obtain the interface file with the following two exceptions:
# The 'Interface Code' must contain a file name that is specified with a file format of 'Comma Delimited'.
# The 'File Name' must have a file extension of .csv so that it can be viewed through an Excel spreadsheet.
----
!!Report Parameters & Filters
At line 76 added 11 lines
A spreadsheet will be provided which includes all data columns that were recorded in the interface file.
To generate this report, you must run UBEF a second time, using a 'Comma Delimited' Interface File Format, and create a file with a file extension of '.csv'.
Once the.csv file is created, you can then view this file through Excel spreadsheet and delete those data columns that are of no use.
----
![Notes|Edit:Internal.UBEF+GENERIC+INTERFACE]
[{InsertPage page='Internal.UBEF+GENERIC+INTERFACE' default='Click to create a new notes page'}]
This page (revision-7) was last changed on 26-Nov-2021 10:22 by JEscottTop