This page (revision-79) was last changed on 20-Sep-2023 14:24 by Lilia Urtan

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
79 20-Sep-2023 14:24 81 KB Lilia Urtan to previous
78 05-May-2023 13:45 81 KB Lilia Urtan to previous | to last
77 21-Mar-2023 10:08 80 KB Kevin Higgs to previous | to last
76 26-Nov-2021 10:22 80 KB kparrott to previous | to last
75 26-Nov-2021 10:22 80 KB khiggs to previous | to last
74 26-Nov-2021 10:22 80 KB khiggs to previous | to last
73 26-Nov-2021 10:22 79 KB khiggs to previous | to last
72 26-Nov-2021 10:22 79 KB khiggs to previous | to last
71 26-Nov-2021 10:22 79 KB khiggs to previous | to last
70 26-Nov-2021 10:22 79 KB rmorrell to previous | to last
69 26-Nov-2021 10:22 79 KB rforbes to previous | to last
68 26-Nov-2021 10:22 78 KB jmyers to previous | to last
67 26-Nov-2021 10:22 78 KB jmyers to previous | to last
66 26-Nov-2021 10:22 78 KB jmyers to previous | to last
65 26-Nov-2021 10:22 78 KB jmyers to previous | to last
64 26-Nov-2021 10:22 78 KB jmyers to previous | to last
63 26-Nov-2021 10:22 78 KB jmyers to previous | to last
62 26-Nov-2021 10:22 78 KB jmyers to previous | to last
61 26-Nov-2021 10:22 79 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
UEEF
UEEF

Version management

Difference between version and

At line 3 changed one line
The UEEF screen provides the capability to generate an interface file from the employee's basic information such as Personals, Employments, Prime Assignments, plus the associated work assignment information derived from Entities, Locations, Jobs, Positions, Departments, Units, Groups etc., and additional information for Benefit plans with Contacts information.
The UEEF provides the capability to generate an interface file from the employee basic information such as Personals, Employments, prime Assignments, Entities, Locations, Jobs, Positions, Departments, Units, Groups etc and additional information for Benefit plans with Contacts information.
At line 5 changed one line
!!Setup Step 1 - Define Lexicons in [IMLN]
!!Required Set Up
!Step 1 - Define Lexicons in [IMLN]
At line 7 changed one line
*[X_INTERFACE_TYPE]\\The following Interface type from X_INTERFACE_TYPE must be used for IDIF screen:\\35 - EEM/EAS Interface
*[X_INTERFACE_TYPE]\\The following Interface type from X_INTERFACE_TYPE must be used for IDIF screen:\\35 – EEM/EAS Interface
*[X_INTERFACE_LEVEL]\\The following Interface types from X_INTERFACE_LEVEL are used on UEEF selection screen.:\\__01 - EEM + EASD__ Generate interface file with Employment (EEM) and Prime Assignment (EASD) basic information\\__02 - EEM + EASD + Contacts__ Same as 01, include EID Contact information\\__10 - BE Plans__ Same as 01, include BE Plans information\\__11 - BE + Contacts__ Same as 10, include BE Contacts information\\__12 - BE + Pay Lines__ Not supported in UEEF, used by UPNVPERS\\__13 - GAPERS/GATRS__ Not supported in UEEF, used by UBEF
At line 9 changed one line
*[X_INTERFACE_LEVEL]\\The following Interface types from X_INTERFACE_LEVEL are used on UEEF selection screen.:\\__01 - EEM + EASD__ Generate interface file with Employment ([EEM|IEEI]) and Prime Assignment ([EASD|P2K_HR_ASSIGNMENT_DETAILS]) basic information\\__02 - EEM + EASD + Contacts__ Same as 01, include EID Contact information\\__03 - EEM + EASD ALL__ extracts historical employee data (multiple records) with Employment ([EEM|IEEI]) and Prime Assignment ([EASD|P2K_HR_ASSIGNMENT_DETAILS]) basic information\\__10 - BE Plans__ Same as 01, include BE Plans information\\__11 - BE + Contacts__ Same as 10, include BE Contacts information\\__12 - BE + Pay Lines__ Not supported in UEEF, used by [UPNVPERS]\\__13 - [GAPERS|HL$GAPERS]/[GATRS|HL$GATRS]__ Not supported in UEEF, used by [UBEF].
*[X_INF_VARIABLE_NAME]\\X_INF_VARIABLE_NAME contains a list of system-defined variables that are eligible by Interface type.\\A list describing each variable and its usage for Interface type 35, can be found on the [Interface Type 35 - EEM/EAS Interface|X_INF_VARIABLE_NAME (35)] page.
At line 11 removed 56 lines
!!Setup Step 2 - Define Interface Format in [IDIF]
!Fixed File Format
The following set up instructions for a Fixed File format using the interface [HL$BE-ELIGTOTAL].\\
The interface does not need to be manually entered in IDIF, it is loaded through seed data during an install or upgrade.
The starter script SEED_IDIF_HL$BE_ELIG_TOTAL.sql is provided to load in 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.
IDIF Field Descriptions:
*The maximum length of a file size is 10000 bytes.
*The maximum length of a file size with Sort Sequence is 4000 bytes.
;Code:
*User defined Interface Code
*If IDIF layout is supplied, Interface code begins with HL$
;Interface Type:Must be 35 - EEM/EAS Interface
;File Format:Specifies one of the File Formats from look up list
;Form Type:Please select "Not Specified" from look up list, Form Type is not used for UEEF
;Description:User defined description
;File Name:Specifies the default file name, otherwise file name is entered on UEEF parameter
;File Creation Number:Not used
;Taxation Level:Please select "Not Specified" from look up list, Taxation Level is not used for UEEF
;Record Number:
*User assigned Record Number
*Each Record number generates a new line in the interface file
*The followings are suggested Record Numbers, user can set up their own numbers.\\
|Record Number|Interface File Records Generated
|0|Qualify Records
|1 - 29|Header Records
|30 - 69|Detail Records
|70 - 99|Trailer Records or Update Records
;Field Number:User assigned number
;Name:User assigned field name
;XML Tag:
*Optional, used for XML File Format only.
*If XML Tag is not specified for XML File, then the Name field is used as XML Tag
;Beginning Position:If File Format = "Fixed Format", the user must specify the Beginning position
;Ending Position:
*If File Format = "Fixed Format", the user must specify the Ending position
*These positions must be continuous without gap, otherwise an error situation will occur
*Beginning/Ending positions are not needed for xml and other file format
*The maximum length of a file size is 10000 bytes, therefore the Ending Position must not exceed 10000
*If Sort Sequence is used, the Ending Position must not exceed 4000
;Field Type:Can be 'Char', 'Number' or 'Date'
;Variable Name:Select from lexicon X_INF_VARIABLE_NAME 35nnnn, refer to lexicon list above
;Sort Sequence:Specifies the Sort Sequence for this Record #, Field #
*Used for Record # with Record Type = 'Detail Record' only
*For Record # with Record Type = 'Detail Level 1' to 'Detail Level 5', it uses the same Sort from Record Type = 'Detail Record' so that the Detail Level n records are followed after the 'Detail Record'
*e.g. if Interface File need to sort by: Department, Employee First Name, Last Name
**then for the Fld# entry that specify 'Department', enter sort sequence: 100
**for the Fld# that specify 'Employee First Name', enter sort sequence: 150
**for the Fld# that specify 'Employee Last Name', enter sort sequence: 200
**all Sort sequences must be entered on entries with the same Record Number
*Sort Sequence is not supported for XML file format because xml file may specify many different Record # to generate xml begin and end tags and the xml tags are not able to sort along with the data
*Sort Sequence is not supported if the IDIF format contains 'Employee Header' or 'Employee Summary' because the Sorting of the Detail Record cannot carry its associated Employee Header/Summary Record
;Format Mask:Applicable to Numeric and Date field
;Record Type:Must be used for this Interface Type, lexicon X_RECORD_TYPE values are:
At line 68 removed 324 lines
|00 - Not Specified |Not used for UEEF
|01 - Header Record |Generate Header records at begin of file
|10 - Employer Header |Not used for UEEF
|11 - Employer Summary |Not used for UEEF
|12 - Employer Header2 |Not used for UEEF
|13 - Employer Summary2 |Not used for UEEF
|14 - Employee Header |Generate Employee Header at the beginning of an employee (EEM) after the Qualify record
|15 - Employee Summary |Generate Employee Summary at the end of an employee (EEM)
|16 - Pay Header Begin |Not used for UEEF
|17 - Pay Header Summary |Not used for UEEF
|20 - Detail Record |Generate Employee Detail record
|21 - Detail Level 1 |Detail Level 1 to 5 hangs beneath the Employee Detail record and loops through BE plans or Contacts etc., depending on UEEF parameter Interface Level selection criteria
|22 - Detail Level 2 |Detail Level 1 to 5 hangs beneath the Employee Detail record and loops through BE plans or Contacts etc., depending on UEEF parameter Interface Level selection criteria
|23 - Detail Level 3 |Detail Level 1 to 5 hangs beneath the Employee Detail record and loops through BE plans or Contacts etc., depending on UEEF parameter Interface Level selection criteria
|24 - Detail Level 4 |Detail Level 1 to 5 hangs beneath the Employee Detail record and loops through BE plans or Contacts etc., depending on UEEF parameter Interface Level selection criteria
|25 - Detail Level 5 |Detail Level 1 to 5 hangs beneath the Employee Detail record and loops through BE plans or Contacts etc., depending on UEEF parameter Interface Level selection criteria
|30 - Detail Summary |Wraps up for Employee Detail record\\Mostly used for XML file xml end tag
|80 - Total Record |Not used for UEEF
|90 - Trailer Record |Generate Trailer records at end of file\\May contain File totals, record counts etc
|91 - Qualify Record |Should be used for Record Number 0\\The Qualify records are performed at the beginning of every Detail record to qualify employees\\User can use derivation expression to BYPASS certain criteria
|92-Update Record |Should be defined at the end of the IDIF definition\\In non-Trial mode, the UDF can be Inserted or Updated as defined in the Variable Name and Constant Value field\\User can use derivation expression to BYPASS certain criteria for update
;Record Identifier:
*Not used for UEEF
;Constant Value:
*If Variable Name = 'Constant Value', this field specifies the Constant Value to be used
*If Variable Name = 'User Calc', this field specifies the User Calc Name
*If Variable Name = 'UDF (xxx)', this field specifies the User Defined Field Name
*If Variable Name = 'Statistics Amt', this field specifies the Statistics Code
*If Variable Name = 'Element', this field specifies the Element Code
*If Variable Name = 'Total Value', this field specifies the Rec# and Field # of the Detail Records to be totaled
**e.g. Record # 50 Field 70 is to be totaled and Total option = 'Calculate Total', then the Trailer record can report the 'Total Value', Constant value should be 5070
;Print Zero Rule:
*Applicable to Numeric field only, use for Record Type = 'Detail Record'
*If amount is zero, this field indicates to include this amount in the interface file or not
**e.g. if the field is from 'Statistics Amount' and the amount is zero, the user may not want to report this amount
*If all numeric amounts are zero within one Record# and the Print Zero Rule are set to 'Do not Print zeros' for each field, then this entry will not be reported on interface file
**lexicon X_PRINT_ZERO_RULE\\00 - Not Specified\\01 - Print Zero Amounts\\02 - Don't Print Zeros
;XML Tag option:
*applicable to XML file, if Variable Name = 'XML begin Tag' or 'XML end Tag', this field option indicates if the XML Tag should be written
*lexicon X_XML_TAG_OPTION\\00 - Not Specified\\01 - Optional, omit tag if null\\02 - Mandatory, always write
;Accum Option:
*applicable to Numeric field only, use for Record Type = 'Detail Record'
*indicate if this Record #, Field # amount should be accumulated or not
**e.g. if the field is a 'Pay Number' or 'Check Number', then do not accumulate
*if field is 'Element Value' or 'PC Amount', then you may want to accumulate to avoid writing too much detail per element or per pay component
;Total Option:
*Applicable to Numeric field only, use for Record Type = Detail Record, Detail Leveln
*Indicate if this Record #, Field # amount should be totaled for Header or Trailer record
**e.g. if the field is a 'FTE' or 'Rate of Pay', then do not totaled
*If field is 'Statistics Amount' or 'User Calc Amount', then you may want to calculate the total for Trailer record
*lexicon X_TOTAL_OPTION\\00 - Not Specified\\01 - Calculate Total
;Derivation Expression:
*Specifies the derivation expression for the Variable name
*This derivation expression will apply to the result of the Variable name before format mask
*The user may use RTRIM(~) to remove trailing blanks before comparing the entire string because the data may contain blanks that are not visible at the end
*Please refer to following Derivation Expression processing
!BYPASS Capability
*On IDIF Derivation expression, you may decode the Variable Name using the ~~ character and return the word 'BYPASS' to bypass the Detail record entry that are with certain criteria.
*The 'BYPASS' criteria can be set up for Record Type = 'Qualify record', 'Detail record', and should not be used for Header and Trailer records
*If the return value of any IDIF Record Number/Field Number = 'BYPASS', then this Detail record will be bypassed and will not be written to the Interface file
**Example:
***To include only Departments start with 'P' on interface file:\\decode(rtrim(substr(~,1,1)),'P',~,'BYPASS')
***To include only Departments ends with 'C' on interface file:\\decode(substr(~,length(rtrim(~)),1),'C','BYPASS',~)
***To bypass Cost Centers that has '????' in second segments:\\decode(SUBSTR(~,5,4),'????','BYPASS',SUBSTR(~,5,4))
***To include Journal Entries with Account Numbers over 40000 in segment 5:\\decode(greatest('40000',substr(~,16,5)),'40000','BYPASS',substr(~,16,5))
It is important to note that BYPASS means that the record (at the highest level - i.e. Employee or Pay Header - will be bypassed. If you wish to just not output the record (such as when you are processing multiple detail or detail level n records, you can use the Skip Rec feature.
!SKIP REC# Capability
If, in the course of processing you determine thatyou do not want a specific record output, you can have a derivation that returns a value of *SKIPREC#* (including the asterisks). The field that you put this into (if it is a fixed position format) must be large enough to hold the ten characters that it will need. The program will continue to do all the processing for each record, but at the point where it will write the record to the file, if it finds this text in the data, the writing of the data (with the same record number in the IDIF definition) will be skipped.
Using this mechanism allows you to bypass selected records when you have multiple records at the same level, or to bypass child records, without tossing the entire employee or pay header out as would happen with the BYPASS structure.
!GOTO#nn#nnn
*When processing IDIF records of the same Record Type (e.g. Detail Record), the user may want to skip some Record # Field # based on certain criteria and resume processing of the same Record Type at a later Record# Field# onward.
*The following GOTO capabilities are available for all Record Types in Derivation Expression:\\GOTO#nn#nnn - where the 1st nn is the Record #, the 2nd nnn is the Field #.
*Since the IDIF entries are processed in chronological order, GOTO#nn#nnn must be for a Record# Field# that is after the current Record# Field#.
*If an incorrect GOTO#nn#nnn is specified, or the #nn#nnn is NOT for the same Record Type, or if it is for a previous Rec# Field#, an exception message will be issued, the GOTO statement cannot be executed after skipping the records, the user must verify the Interface File from this point onward.
*Multiple GOTO#nn#nnn can be used within the same Record Type.
*If an invalid GOTO is encountered in IDIF definition, the Trial mode parameter is set to 'Y' in order to prevent the updating of the User Defined fields from the Record Type '92-Update Record'.
*For XML File Format, the GOTO#nn#nnn can be used to skip certain XML Tags and carry on the processing.
*For Fixed File Format, if the GOTO#nn#nnn is for the current Record#, it will GOTO the specified #nn#nnn, the current Record# information will be written.
*For Fixed File Format, if the GOTO#nn#nnn is for a different Record#, it will GOTO the specified #nn#nnn of the different Record#, the current Record# information will NOT be written.
** e.g. UEEF IDIF Record# 30 Field # 45, decode Plan_Code, if it equals to 'HL GROUP LIFE', GOTO#35#10
***this will skip the entire Record# 30 and carry on from Record# 35 Field#10 for the fixed file format
[UEEF_01.JPG]
!Multiple Fields Processing
*On IDIF derivation expression, user can specify multiple variable names processing by indicating the lexicon value of the X_INF_VARIABLE_NAME inside the bracket [ ], e.g. [350001]
*Lexicon values available from IMLN for X_INF_VARIABLE_NAME are: 32nnnn, 35nnnn
*This provides the full list of INF variables interchangeably for UPPHF, UEEF as long as the Database tables are being loaded according to the Interface Level parameter of the run
The following example is an excerpt from UPPHF and the same processing logic is applicable to UEEF
__Example: Record # 50, Field # 20 Requirement for Employee Row id or Unit id:__
*If Pay Header Group User Defined Field (UDF) 'PROJECT HOURS BY PERSON' is 'Y', this means the employee is an 'ADMIN' employee, then if the Journal Entry is reporting for 'Hours', then use the Identities eid.id on the interface file field, otherwise, use the Unit dun.id on the field for all other situation
*From above IDIF set up, user should specify the Variable Name using 'UDF (DGD)' and enter the UDF name in Constant Value field, then the value of UDF will be returned and represented as ~ in the derivation expression
In derivation expression, enter:\\decode(~,'Y',decode([320803],'02',[320009],[350400]),[350400])\\where:
|[320803]|- Journal Type (DGA), 01 - Financial Journal, 02 - Statistical Journal
|[320009]|- Identity eid_id
|[350400]|- Unit dun_id (DUN)
This derivation expression means:
*decode the value of ~ from UDF
**if the value = 'Y', then
***decode the value from [320803] Journal Type
****if Journal Type = '02' Statistical Journal, then
*****return [320009] Identify eid.id
****otherwise
*****return [350400] Unit dun_id
****otherwise
*****return [350400] Unit dun_id
__Example: Record # 50, Field # 10 Requirement: Work Date or Pay Period__
*If Pay Header Group User Defined Field (UDF) 'PROJECT HOURS BY PERSON' is 'Y', this means the employee is an 'ADMIN' employee, then use the Pay Period on the interface file field, otherwise use the GL Effective date on the interface file field
*From above IDIF set up, user should specify the Variable Name using 'UDF (DGD)' and enter the UDF name in Constant Value field, then the value of UDF will be returned and represented as ~ in the derivation expression
In derivation expression, enter:\\decode(~,'Y',[320102],to_char(to_date([320756]),'DD/MM/YYYY'))\\where:
|[320102]|- Pay Period
|[320756]|- GL Eff Date (PJD)
This derivation expression means:
*decode the value of ~ from UDF
**if the value = 'Y', then
***return [320009] Identify eid.id
**otherwise
***return [350400] Unit dun_id
**otherwise
***return [350400] Unit dun_id
!P2K Internal Functions
The user has ability to call some P2K internal functions in the derivation expression under the guidance of HL consultant. The following example is for UPPHF Payroll History Interface only, and is used to demonstrate Derivation Expression only. In this example, the Element value of ‘HOURS COMP TIME’ will be returned for Variable Name ‘Pay Header pph_id’.
%%Information the IDIF screen layout is revised as above, the screen prints in this section are example of Derivation Expression only and therefore are not matched with revised layout above, please ignore the layout format.%%
[UEEF_02.JPG]
The above example can also be achieved by setting up Variable Name = ‘Element pph Value’ with the Element Code specified in the Constant Value field.
[UEEF_03.JPG]
!P2K Internal Functions with Parameters
You have ability to call some P2K internal functions in the derivation expression under the guidance of a consultant and pass the following internal parameters in order to perform some internal calculation:
|#PPH_ID#|- must be capital letters, this #PPH_ID# will be replaced by the current Pay Header’s pph.id
|#EEM_ID#|- must be capital letters, this #EEM_ID# will be replaced by the current Employment’s eem.id
|#EID_ID#|- must be capital letters, this #EID_ID# will be replaced by the current Identity’s eid.id
e.g.. the Element PC value of ‘HOURS O/T’ will be retrieved first and is represented as ~ in derivation expression
The derivation expression will return the Element value of ‘HOURS COMP TIME’ for #PPH_ID# and add to value of ~
[UEEF_04.JPG]
User may perform some internal mathematic calculation in the derivation expression to return some prorated amount.
((Value of a PC in ‘HOURS O/T’ element / Value of ‘HOURS O/T’ Element) * Benefit Element ‘HOURS COMP TIME’)
[UEEF_05.JPG]
!XML File Format
The following instructions are for building an XML format for the UEEF using the format [HL$BE-ELIG-XML.]
SEED_IDIF_HL$BE_XML_FILE.sql script is provided to load in example of a XML format interface file
You should use [Deep Copy|DEEP_COPY_FACILITY] to copy into a different Interface Code and then enter their own company data
!!Setup Step 3 - Defining UserCalcs
The file format for the UEEF can be defined to call a UserCalc function at each Record Number, each Field Number.
The Variable Name must equal 'UserCalc' and the UserCalc name must be specified in the Constant Value field.
The Field Type must be defined with Char, Number or Date, the UserCalc function on [IMUC] screen Return Value must match the values (Char, Number or Date) with the [IMUC] RET command to return the corresponding Char, Number or Date.
The data base tables available for UserCalc are:
*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
!!Setup Step 4 - Update Record Set Up
During the UEEF run, you may update certain User Defined Fields (UDF) to indicate the Interface File has been generated and mark the records as being processed. You may reference these UDFs in [IDIF] to prevent the same information from being processed again.
On [IDIF] screen, Record Type '92-Update Record' should be defined at the end of the [IDIF] definition.
The Variable Name should contain the UDF (xxx) that is to be updated or inserted, e.g.'358043 - UDF (ECT) (35)'.
The Constant Value field should contain the name of the UDF, e.g 'UEEF by BEN'.
%%information Please note that it will be up shifted.%%
If this UDF name does not exist on the [IMUF] screen, UEEF will create the UDF with this name on [IMUF] screen for the data base table to be updated.
The Derivation Expression field should contain the expression that is evaluated to the value to be updated for the UDF.
The following Derivation Expression features can be used to derive the value to be updated:
* multiple fields processing, DECODE, BYPASS, string manipulation,concatenation, function calls etc
When UEEF is run in non-trial mode, Record Type '92-Update Record' will be processed at the appropriate levels to check if the UDF should be updated for the associated data base tables.
From above example:
*Rec#200 Field#10 indicates to update 'UDF (ECT)', this will be processed at the end of each qualified Contact
*Rec#200 Field#15 indicates to update 'UDF (BPN)', this will be processed at the end of each qualified Benefit Plan
*Rec#200 Field#20 indicates to update 'UDF (BEN)', this will be processed at the end of each qualified employee [IBEN] Benefit plan
*Rec#200 Field#30 indicates to update 'UDF (BEND)', this will be processed at the end of each qualified employee [IBEN] Benefit plan
* Rec#200 Field#40 indicates to update 'UDF (EPS)', this will be processed at the end of each qualified employee
Using the Returned Value of the Derivation Expression, UEEF finds if the UDF already exists.
If the UDF exists and the new value is different than the existed UDF value, it will be updated. If the UDF does not exist, it will be inserted.
List of UDF supported in UEEF from [X_INF_VARIABLE_NAME] are:
*358030 - UDF (EID) (35)
*358031 - UDF (EEM) (35)
*358032 - UDF (EASD) (35)
*358033 - UDF (EASD) (35)
*358034 - UDF (EPS) (35)
*358035 - UDF (DED) (35)
*358036 - UDF (DDD) (35)
*358037 - UDF (DLN) (35)
*358038 - UDF (DUD) (35)
*358039 - UDF (DGD) (35)
*358043 - UDF (ECT) (35)
*358044 - UDF (BEN) (35)
*358045 - UDF (BEND) (35)
After UDFs are updated or inserted in UEEF, the number of records updated for each data base table will be displayed on the UEEF report.
%%information Note that the 'Number of UDF Updated' represents the number of times the tables are being touched, these may not necessarily be the exact number of UDF for that table. (e.g. UDF (EEM) may be touched two times if an employee has two contacts to update the same EEM but with a different value.)%%
----
!!Processing Information
!Employee Generic Interface Processing
Based on the selection criteria, UEEF retrieves employee basic information and primary assignment information
From the UEEF 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
Based on the value selected in the parameter 'Interface Level', the following information will be written to the interface file
||Interface Level Value||Usage
| EEM + EASD|Primary assignment and related data base tables are loaded. This level will perform [IDIF] Record Type 'Detail Record' for each primary assignment information, i.e. write one entry per employee
| EEM + EASD + Contacts|Primary assignment and related data base tables are loaded. This level will perform [IDIF] Record Type 'Detail Record' for each primary assignment information, i.e. write one entry per employee. Then the Contacts information for this employee will be loaded and perform [IDIF] Record Type 'Detail Level 1 to 5' for each Contact information, i.e. generate all contact entries for this employee
| EEM + EASD ALL|Historical employee data from Primary assignment and related data base tables are loaded. This level will perform [IDIF] Record Type 'Detail Record' for each primary assignment record information, i.e. write multiple entries per employee
| 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
| BE + Contacts|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. Then the Contacts information for this BE plan will be loaded and perform [IDIF] Record Type 'Detail Level 1 to 5' for each Contact information, i.e. generate all contact entries for this BE plan.
| BE + Pay Lines|Not supported in UEEF, used by UPNVPERS
| GAPERS/GATRS|Not supported in UEEF, used by UBEF
!Update Records
When UEEF is run in non-trial mode, Record Type '92-Update Record' will be processed at the appropriate levels to check if the User Defined Fields (UDF) are to be updated for the associated Data Base Tables
-----
!!UEEF to Extract Changes Only
The Generic Employee Interface (UEEF) may be used as a data extraction process that selects only the changed data. Quite often third party vendors will not accept all records being transmitted with each transfer. The UEEF will filter extracted data based on a specified list of tables that have changed after a given date.
!Turn on Change Logging
In order for the extracted data to be filtered by changes a system administrator must first turn on 'Logging' on the tables they wish to pick up changes for. This is done in [IMTD] and [IMCD].
Setting up logging on tables and columns should only be done by an administrator since this can have an impact on performance.
Please refer to the Detailed Change Auditing document for instructions on how to configure this
!Process UEEF with Changes Only
Review the above section for detailed information on how to set up the interface file format for the UEEF function. Once the interface file format has been set up and the logging has been turned on, you are now able to run UEEF to extract changes only data.
In order for UEEF to extract changes only two new parameters have been added:
#Changed Since:
#Changed Tables:
If you need to run an exception level 9 for additional trace, you need to supply a person code. If you do not do so, there will be a warning message in the report indicating that due to the volume of trace messages, the exception level is internally reset to 1 and that if you need to run with level 9, to enter an employee to be traced.
----
!!Report Parameters
||Report Parameters||
|Entity|Mandatory, LOV Available\\You must enter one entity
|As Of Date|Mandatory,Date, LOV Available\\This date is used to retrieve employee information where a date is needed
|Sort By Active EEs|Check this toggle to sort inactive employees first
|Sort People By|Optional,[Person Sort|X_PERSON_SORT] lexicon available\\You should sort employees by Last Name/First Name, however you may sort by employee's pay destination or sort by Person code.
|ER Address Location|Optional, LOV Available\\Allows you to enter an overridden Location to retrieve the Employer Address. If this is not specified, the Entity’s location address is used.
|Changed Since|This date field is used to filter the [P2K_AM_CHANGE_LOGS] table to only show data changed since this date. When this parameter is left blank, the interface process will not be filtered by the change logs
|Changed Tables|If a table is selected, the system will only look for changes that have occurred in the specified table. More than one table may be selected at a given time. If there is no table selected and if a changed 'Since' date has been supplied, the system will not export any rows. Tables that are currently supported are: [P2K_HR_IDENTITIES], [P2K_HR_PERSONALS], [P2K_HR_EMPLOYMENTS], [P2K_HR_ASSIGNMENTS], [P2K_HR_ASSIGNMENT_DETAILS], [P2K_PR_PAYMENT_RULE_DETAILS], [P2K_PR_US_PAY_RULES]
|Trial Run|Optional toggle to indicate if the UDFs are to be updated for the UEEF run. The value of 'Y' or 'N' is always returned in this parameter field. To run in non-Trial mode (Update mode), you should define [IDIF] Record Type '92-Update Record' to update UDFs
|Interface Format Code|Enter the Interface code from [IDIF] screen. (Mandatory)
|Interface Level|Mandatory,[Interface Level|X_INTERFACE_LEVEL] lexicon available\\Specify the level for the Interface file to be produced.
|Directory Name|Enter a valid directory name
|File Name|Enter a file name or use the default file name from [IDIF] screen
|Write Append to File|Mandatory,[Write Append|X_WRITE_APPEND] lexicon available\\Provides the option to write a file or append to an existing one.
|Exception Level|You should always run with 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
|User Comments |Optional, Text \\This field holds the user-supplied comment which will appear in the header of all pages of the report. This is useful during testing phases to identify similar reports from each other.
||Report Filters||
|People List|Optional, Multiple Selection Available, LOV Available\\Please specify if People list is to be used.
|Person|Optional, Multiple Selection Available, LOV Available\\Enter one or more Person Codes.
|Location|Optional, Multiple Selection Available, LOV Available\\Enter one or more Location codes.
|Auth Area|Optional, Multiple Selection Available, LOV Available\\Enter one or more Authorization Areas.
|Department|Optional, Multiple Selection Available, LOV Available\\Enter one or more Department Codes.
|Org Level Type|Optional, Multiple Selection Available, LOV Available\\Enter one or more Org Level Types.
|Org Level|Optional, Multiple Selection Available, LOV Available\\Enter one or more Org Level within Org Level Types.
|Unit|Optional, Multiple Selection Available, LOV Available\\Enter one or more Unit codes.
|Group|Optional, Multiple Selection Available, LOV Available\\Enter one or more Group codes.
|Payroll|Optional, Multiple Selection Available, LOV Available\\Enter one or more Payroll codes.
|Employment Status|Optional, Multiple Selection Available, LOV Available\\Enter one or more Employment Statuses.
|Termination Reason|Optional, Multiple Selection Available, LOV Available\\Enter one or more Termination Reasons.
|Plan Type|Optional, Multiple Selection Available, LOV Available\\Applicable if Interface Level = 'BE plans' or 'BE + Contacts'.
|Plan|Optional, Multiple Selection Available, LOV Available\\Applicable if Interface Level = 'BE plans' or 'BE + Contacts'.
!!Available EEM/EAS Interface (35) Variables
%%zebra-table
At line 393 changed 9 lines
| 350001 | XML Begin Tag | |Indicates this Rec#/Fld# is for XML Begin tag.\\ \\You should enter the XML tag in the XML tag field. If XML tag is not specified, the field name is used as XML Tag.\\ \\You should specify XML tag option.\\ \\If XML tag option is not specified, this XML tag is an optional tag.
| 350002 | XML End Tag | |Indicates this Rec#/Fld# is for XML End tag.\\ \\Same logic as XML Begin tag.\\ \\You should match XML End tag to XML Begin tag on [IDIF] definition
| 350003 | Constant Value | | Indicates this Rec#/Fld# contains a constant.\\ \\You should enter the constant in Constant Value field.
| 350004 | System Date/Time | |The system current Date and Time stamp with following Select: SELECT to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')\\ \\You can use derivation expression SUBSTR to retrieve Date only or Time only
| 350005 | As Of Date | From the [UEEF] As Of Date parameter|
| 350006 | Execution ID | From the [UEEF] Execution ID of the run|
| 350007 | User Calc | |Indicates this Rec#/Fld# will invoke a UserCalc.\\ \\You should enter the UserCalc name in the Constant Value field, e.g. BE USERCALC\\ \\Please read [IDIF User Calc|UEEF#section-UEEF-Step3DefiningUserCalcs] section.
| 350008 | Trial Run |From the P_TRIAL (Trial Run) parameter|The value of <<Y>> or <<N>> is always returned in P_TRIAL\\ \\If NULL is entered, P_TRIAL is set to <<N>>
| 350100 | Entity den_id (DEN)) | [P2K_CM_ENTITIES] (DEN) is retrieved from employee's employment. |This field returns the [DEN_ID], you may use this id in derivation expression to return other value that is related to [DEN_ID]\\ \\e.g. To return the UDF 'COMPANY LICENCE' value from [IDEN], use derivation expression:\\ \\p2k_smgetudf ('P2K_CM_ ENTITIES', 'COMPANY LICENCE',~)
| 350001 | XML Begin Tag | |Indicates this Rec#/Fld# is for XML Begin tag.\\ \\User should enter the XML tag in the XML tag field. If XML tag is not specified, the field name is used as XML Tag.\\ \\User should specify XML tag option.\\ \\If XML tag option is not specified, this XML tag is an optional tag.
| 350002 | XML End Tag | |Indicates this Rec#/Fld# is for XML End tag.\\ \\Same logic as XML Begin tag.\\ \\User should match XML End tag to XML Begin tag on [IDIF] definition
| 350003 | Constant Value | | Indicates this Rec#/Fld# contains a constant.\\ \\User should enter the constant in Constant Value field.
| 350004 | System Date/Time (35) | |The System current Date and Time stamp with following Select: SELECT to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')\\ \\You can use derivation expression SUBSTR to retrieve Date only or Time only
| 350005 | As Of Date (35) | From the [UEEF] As Of Date parameter|
| 350006 | Execution ID (35) | From the [UEEF] Execution ID of the run|
| 350007 | User Calc (35) | |Indicates this Rec#/Fld# will invoke a UserCalc.\\ \\Users should enter the UserCalc name in the Constant Value field, e.g. BE USERCALC\\ \\Please read [IDIF User Calc|UEEF#section-UEEF-Step3DefiningUserCalcs] section below.
| 350008 | Trial Run (35) |From the P_TRIAL (Trial Run) parameter|The value of ‘Y’ or ‘N’ is always returned in P_TRIAL\\ \\If NULL is entered, P_TRIAL is set to ‘N’
| 350100 | Entity den_id (DEN) | [P2K_CM_ENTITIES] (DEN) is retrieved from employee's employment. |This field returns the [DEN_ID], you may use this id in derivation expression to return other value that is related to [DEN_ID]\\ \\e.g. to return the UDF 'COMPANY LICENCE' value from [IDEN], use derivation expression:\\ \\p2k_smgetudf('P2K_CM_ ENTITIES', 'COMPANY LICENCE',~)
At line 404 changed one line
| 350103 | G/L Company (DEN)|From [P2K_CM_ENTITIES] (DEN) GL Company id to retrieve [GL Company code|GL_COMPANY_CODE] |
| 350103 | G/L Company (DEN) (35) |From [P2K_CM_ENTITIES] (DEN) GL Company id to retrieve [GL Company code|GL_COMPANY_CODE] |
At line 413 changed one line
| 350201 | Location Code (DLN) | [P2K_CM_LOCATIONS] (DLN) is retrieved from the [location code|LOCATION_CODE] field found on IDEN (DED.DLN_ID).|If the [UEEF] parameter 'Er Addr Location' is specified, then this location is used as the Employer Address
| 350201 | Location Code (DLN) | [P2K_CM_LOCATIONS] (DLN) is retrieved from DED.DLN_ID|If [UEEF] the parameter 'Er Addr Location' is specified, then this location is used as the Employer Address
At line 432 changed one line
| 350227 | Mail State+Cntry+Postal(DLN) | From [P2K_CM_LOCATIONS] (DLN)|Location Mailing Address State/Prov, Country and Postal Code are concatenated
| 350227 | Maill State+Cntry+Postal(DLN) | From [P2K_CM_LOCATIONS] (DLN)|Location Mailing Address State/Prov, Country and Postal Code are concatenated
At line 496 changed one line
| 350601 | Payroll Code (PPA) | [P2K_PR_PAYROLLS] (PPA) is retrieved from the employee's prime assignment group details|This field returns the [Payroll code|PAYROLL_CODE] from PPA.
| 350601 | Payroll Code (PPA) | [P2K_PR_PAYROLLS] (PPA) is retrieved from the employee's prime assignment group details|This field returns the [Payroll code|PAYROLL_CODE] from PPA
At line 499 changed one line
| 350701 | Pay Calendar Code (PCL) | [P2K_PR_PAY_CALENDARS] (PCL) is retrieved from the employee's prime assignment group details [Payroll code|PAYROLL_CODE]|This field returns the [Pay Calendar code|PAY_CALENDAR_CODE] from PCL.
| 350701 | Pay Calendar Code (PCL) | [P2K_PR_PAY_CALENDARS] (PCL) is retrieved from the employee's prime assignment group details [Payroll code|PAYROLL_CODE]|This field returns the [Pay Calendar code|PAY_CALENDAR_CODE] from PCL
At line 503 changed one line
| 350800 | Govt Regist Number (DGV) |[P2K_CM_GOVT_REGISTRATIONS] (DGV) is retrieved from the employee's prime assignment group details Federal Registration. |This field returns the [Govt Regist Number|GOVT_REGIST_NUMBER] from DGV.
| 350800 | Govt Regist Number (DGV) |[P2K_CM_GOVT_REGISTRATIONS] (DGV) is retrieved from the employee's prime assignment group details Federal Registration |This field returns the [Govt Regist Number|GOVT_REGIST_NUMBER] from DGV
At line 507 changed 2 lines
| 353100 | Person Code (EID) | [P2K_HR_IDENTITIES] (EID) is retrieved for the employee.|This field returns the [Person code|PERSON_CODE].
| 353101 | Person eid_id (EID) | From [P2K_HR_IDENTITIES] (EID)|Derivation expression to return other value that is related to [EID_ID] e.g. to return the UDF 'LICENCE' value from [IEID], use derivation expression:p2k_smgetudf ('P2K_HR_IDENTITIES','LICENCE',~).
| 353100 | Person Code (EID) | [P2K_HR_IDENTITIES] (EID) is retrieved for the employee|This field returns the [Person code|PERSON_CODE].
| 353101 | Person eid_id (EID) | From [P2K_HR_IDENTITIES] (EID)|Derivation expression to return other value that is related to [EID_ID] e.g. to return the UDF 'LICENCE' value from [IEID], use derivation expression:p2k_smgetudf('P2K_HR_IDENTITIES','LICENCE',~)
At line 513 changed 4 lines
| 353106 | Last, First, Middle (EID) |From [P2K_HR_IDENTITIES] (EID) |The employee's name is returned as follows: Last name + ',' + First name + space + Middle name\\e.g. Smith, Mary Beverley
| 353107 | Last, First, Initial (EID) |From [P2K_HR_IDENTITIES] (EID)| The employee's name is returned as follows: Last name + ',' + First name + space + Middle Initial\\e.g. Smith, Mary B
| 353108 | First, Middle, Last (EID) | From [P2K_HR_IDENTITIES] (EID)|The employee's name is returned as follows: First name + space + Middle name + space + Last name\\e.g. Mary Beverley Smith
| 353109 | First, Initial, Last (EID) |From [P2K_HR_IDENTITIES] (EID) |The employee's name is returned as follows: First name + space + Middle Initial + space + Last name\\e.g. Mary B Smith
| 353106 | Last, First, Middle (EID) |From [P2K_HR_IDENTITIES] (EID) |The employee's name is returned as follows: Last name + ',' + First name + space + Middle name e.g. Smith, Mary Beverley
| 353107 | Last, First, Initial (EID) |From [P2K_HR_IDENTITIES] (EID)| The employee's name is returned as follows: Last name + ',' + First name + space + Middle Initial e.g. Smith, Mary B
| 353108 | First, Middle, Last (EID) | From [P2K_HR_IDENTITIES] (EID)|The employee's name is returned as follows: First name + space + Middle name + space + Last name e.g. Mary Beverley Smith
| 353109 | First, Initial, Last (EID) |From [P2K_HR_IDENTITIES] (EID) |The employee's name is returned as follows: First name + space + Middle Initial + space + Last name e.g. Mary B Smith
At line 525 changed one line
| 353134 | Veteran Status (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353134 | Vetern Status (EID) | From [P2K_HR_IDENTITIES] (EID)|
At line 531 changed one line
| 353200 | Personal eps_id (EPS) |[P2K_HR_PERSONALS] (EPS) is retrieved for the employee, effective as of the [UEEF] As of Date parameter. |This field returns the [EPS_ID], you may use this id in derivation expression to return other value that is related to [EPS_ID].
| 353200 | Personal eps_id (EPS) |[P2K_HR_PERSONALS] (EPS) is retrieved for the employee effective as of the As of Date parameter |This field returns the [EPS_ID], you may use this id in derivation expression to return other value that is related to [EPS_ID]
At line 537 changed 3 lines
| 353206 | Addr Ln2 + Locality (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Address Line 2 and Locality (city) are concatenated.
| 353207 | Locality (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353210 | State Prov Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353206 | Address 2 + City (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Address Line 2 and Locality (city) are concatenated
| 353207 | City (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353210 | State Code (EPS) | From [P2K_HR_PERSONALS] (EPS)|
At line 542 changed one line
| 353213 | State+Cntry+Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Address State/Prov, Country and Postal Code are concatenated.
| 353213 | State+Cntry+Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Address State/Prov, Country and Postal Code are concatenated
At line 545 changed one line
| 353220 | Mail Address 1 (EPS) | From [P2K_HR_PERSONALS] (EPS)|If Mailing address does not exist, the Primary address will be used.
| 353220 | Mail Address 1 (EPS) | From [P2K_HR_PERSONALS] (EPS)|if Mailing address does not exist, the primary address will be used
At line 547 changed 2 lines
| 353222 | Mail Adr 2 + Locality (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Mailing Address Line 2 and Locality (city) are concatenated
| 353223 | Mail Locality (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353222 | Mail Adr 2 + City (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Mailing Address Line 2 and Locality (city) are concatenated
| 353223 | Mail City (EPS) | From [P2K_HR_PERSONALS] (EPS)|
At line 552 changed one line
| 353227 | Mail State+Cntry+Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Mailing Address State/Prov, Country and Postal Code are concatenated.
| 353227 | Mail State+Cntry+Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Mailing Address State/Prov, Country and Postal Code are concatenated
At line 568 changed one line
| 353300 | Employment eem_id (EEM) | [P2K_HR_EMPLOYMENTS] (EEM) is retrieved for the employee|This field returns the [EEM_ID], you may use this id in derivation expression to return other value that is related to [EEM_ID].
| 353300 | Employment eem_id (EEM) | [P2K_HR_EMPLOYMENTS] (EEM) is retrieved for the employee|This field returns the [EEM_ID], you may use this id in derivation expression to return other value that is related to [EEM_ID]
At line 585 changed one line
| 353380 | Term Description (DTR) | [P2K_CM_TERMINATION_REASONS] (DTR) is retrieved from the employee's Employment|This field returns the [Termination description|DESCRIPTION].
| 353380 | Term Description (DTR) | [P2K_CM_TERMINATION_REASONS] (DTR) is retrieved from the employee's Employment|This field returns the [Termination description|DESCRIPTION]
At line 590 changed 4 lines
| 353390 | Pay Frequency (ROE) | From [UPROEF] program internal Pay Frequency| For [UPROEF] only, please read Web ROE doc for detail
| 353391 | First day worked (ROE) |From [UPROEF] program internal First day worked|
| 353392 | Last day paid (ROE) | From [UPROEF] program internal Last day paid|
| 353393 | Final period end (ROE) |From [UPROEF] program internal Final period end |
| 353390 | Pay Frequency (ROE) | From [IPCL]'s [PAY_FREQUENCY] first character or [IPCL] UDF '[ROE PAY FREQUENCY (UDF)]'| Used by [UPROEF]
| 353391 | First day worked (ROE) | From [IEEI] UDF '[Override ROE 1st Work Date|OVD ROE 1st WORK DATE (UDF)]' if specified, otherwise from EEM [FIRST_WORK_DATE]. If employee has issued ROE before (i.e. [IEEI] UDF [Prev ROE Upto|PREV ROE UPTO (UDF)] is not null), then the First Day Worked is retrieved from the earliest pay line start_date of the first Regular Pay Header that is with pay period after '[Prev ROE Upto|PREV ROE UPTO (UDF)]' pay period|Used by [UPROEF]
| 353392 | Last day paid (ROE) | From [IEEI] UDF '[OVD ROE Last Work Date|OVD ROE LAST WORK DATE (UDF)]' if specified, otherwise from EEM [last work date|LAST_WORK_DATE]|Used by [UPROEF]
| 353393 | Final period end (ROE) |From Last pay period end date being paid |Used by [UPROEF]
At line 600 changed one line
| 353400 | Assignment eas_id (EAS) | [P2K_HR_ASSIGNMENTS] (EAS) is retrieved for the employee's Primary assignment| This field returns the [EAS_ID], you may use this id in derivation expression to return other value that is related to [EAS_ID]
| 353400 | Assignment eas_id (EAS) | [P2K_HR_ASSIGNMENTS] (EAS) is retrieved for the employee's Primary Assignment| This field returns the [EAS_ID], you may use this id in derivation expression to return other value that is related to [EAS_ID]
At line 610 changed one line
| 353500 | Assignment easd_id (EASD) | [P2K_HR_ASSIGNMENT_DETAILS] (EASD) is retrieved for the employee's Primary assignment effective as of the As of Date parameter|This field returns the easd.id, you may use this id in derivation expression to return other value that is related to [EASD_ID].
| 353500 | Assignment easd_id (EASD) | [P2K_HR_ASSIGNMENT_DETAILS] (EASD) is retrieved for the employee's Primary Assignment effective as of the As of Date parameter|This field returns the easd.id, you may use this id in derivation expression to return other value that is related to [EASD_ID]
At line 752 changed 3 lines
| 353805 | Last, First, Middle (ECT) | From [P2K_HR_CONTACTS] (ECT)|The contact's name is returned as follows: Last name + ',' + First name + space + Middle name\\e.g. Smith, Mary Beverley
| 353806 | Last, First, Initial (ECT) |From [P2K_HR_CONTACTS] (ECT) |The contact's name is returned as follows: Last name + ',' + First name + space + Middle Initial\\e.g. Smith, Mary B
| 353807 | First, Middle, Last (ECT) | From [P2K_HR_CONTACTS] (ECT)|The contact's name is returned as follows: First name + space + Middle name + space + Last name\\e.g. Mary Beverley Smith
| 353805 | Last, First, Middle (ECT) | From [P2K_HR_CONTACTS] (ECT)|The contact's name is returned as follows: Last name + ',' + First name + space + Middle name e.g. Smith, Mary Beverley
| 353806 | Last, First, Initial (ECT) |From [P2K_HR_CONTACTS] (ECT) |The contact's name is returned as follows: Last name + ',' + First name + space + Middle Initial e.g. Smith, Mary B
| 353807 | First, Middle, Last (ECT) | From [P2K_HR_CONTACTS] (ECT)|The contact's name is returned as follows: First name + space + Middle name + space + Last name e.g. Mary Beverley Smith
At line 766 changed one line
| 353819 | Addr Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact's Address Line 2 and Locality (city) are concatenated.
| 353819 | Addr Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address Line 2 and Locality (city) are concatenated
At line 771 changed 2 lines
| 353824 | State+Cntry+Zip (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact's Address State/Prov, Country and Postal Code are concatenated.
| 353825 | Mail_address_line_1 (ECT) |From [P2K_HR_CONTACTS] (ECT) |If Mailing address does not exist, the primary address will be used.
| 353824 | State+Cntry+Zip (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address State/Prov, Country and Postal Code are concatenated
| 353825 | Mail_address_line_1 (ECT) |From [P2K_HR_CONTACTS] (ECT) |if Mailing address does not exist, the primary address will be used
At line 774 changed one line
| 353827 | Mail Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact's Mailing Address Line 2 and Locality (city) are concatenated
| 353827 | Mail Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Mailing Address Line 2 and Locality (city) are concatenated
At line 779 changed one line
| 353832 | Mail State+Cntry+Zip (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact's Mailing Address State/Prov, Country and Postal Code are concatenated
| 353832 | Mail State+Cntry+Zip (ECT) | From [P2K_HR_CONTACTS] (ECT)|contact’s Mailing Address State/Prov, Country and Postal Code are concatenated
At line 793 changed 2 lines
| 355001 | Enrollment id (BEN) |[P2K_BE_ENROLLMENTS] (BEN) |If the Interface Level parameter = '03 - BE Plans' or '04 - BE Plans + Contacts', [P2K_BE_ENROLLMENTS] (BEN)is retrieved for the user specified Benefit Plan codes and Benefit Plan types of the report's parameter. Tthis field returns the [BEN_ID], you may use this id in derivation expression to return other value that is related to [BEN_ID].
| 355002 | Enroll Detail id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for BEN effective as of the As of Date parameter|This field returns the [BEND_ID], you may use this id in derivation expression to return other value that is related to [BEND_ID].
| 355001 | Enrollment id (BEN) |[P2K_BE_ENROLLMENTS] (BEN) |If the Interface Level parameter = '03 - BE Plans' or '04 - BE Plans + Contacts', [P2K_BE_ENROLLMENTS] (BEN)is retrieved for the user specified Benefit Plan codes and Benefit Plan types of the report's parameter. Tthis field returns the [BEN_ID], you may use this id in derivation expression to return other value that is related to [BEN_ID]
| 355002 | Enroll Detail id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for BEN effective as of the As of Date parameter|This field returns the [BEND_ID], you may use this id in derivation expression to return other value that is related to [BEND_ID]
At line 813 changed one line
| 355101 | Plan Type id (BPT) | From [P2K_BE_ENROLLMENTS] (BEN), it links to the [P2K_BE_PLAN_DEFINITIONS] (BPN) which links to [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)| This field returns the [BPT_ID], you may use this id in derivation expression to return other value that is related to [BPT_ID].
| 355101 | Plan Type id (BPT) | From [P2K_BE_ENROLLMENTS] (BEN), it links to the [P2K_BE_PLAN_DEFINITIONS] (BPN) which links to [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)| This field returns the [BPT_ID], you may use this id in derivation expression to return other value that is related to [BPT_ID]
At line 817 changed one line
| 355201 | Plan Defn id (BPN) | From [P2K_BE_ENROLLMENTS] (BEN), it links to the [P2K_BE_PLAN_DEFINITIONS] (BPN)|This field returns the [BPN_ID], you may use this id in derivation expression to return other value that is related to [BPN_ID].
| 355201 | Plan Defn id (BPN) | From [P2K_BE_ENROLLMENTS] (BEN), it links to the [P2K_BE_PLAN_DEFINITIONS] (BPN)|This field returns the [BPN_ID], you may use this id in derivation expression to return other value that is related to [BPN_ID]
At line 840 changed one line
| 355301 | Coverage id (BCG) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for this employee for this benefit plan, it links to the [P2K_BE_COVERAGES] (BCG) to indicate the coverage the employee has elected for the BE plan|This field returns the [BCG_ID], you may use this id in derivation expression to return other value that is related to [BCG_ID].
| 355301 | Coverage id (BCG) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for this employee for this benefit plan, it links to the [P2K_BE_COVERAGES] (BCG) to indicate the coverage the employee has elected for the BE plan|This field returns the [BCG_ID], you may use this id in derivation expression to return other value that is related to [BCG_ID]
At line 854 changed one line
| 355501 | Covg Rate id (BCGR) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for this employee for this benefit plan, it specifies the [COVERAGE_STEP_CODE] to indicate the coverage step the employee has elected for the BE plan. [P2K_BE_COVERAGE_RATES] (BCGR) is retrieved for the BEND Benefit Coverage Detail and [COVERAGE_STEP_CODE].|This field returns the [BCGR_ID], you may use this id in derivation expression to return other value that is related to [BCGR_ID].
| 355501 | Covg Rate id (BCGR) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for this employee for this benefit plan, it specifies the [COVERAGE_STEP_CODE] to indicate the coverage step the employee has elected for the BE plan. [P2K_BE_COVERAGE_RATES] (BCGR) is retrieved for the BEND Benefit Coverage Detail and [COVERAGE_STEP_CODE]|This field returns the [BCGR_ID], you may use this id in derivation expression to return other value that is related to [BCGR_ID]
At line 868 changed one line
| 355601 | Ben Recip id (BBR) |From [P2K_BE_BENEFIT_RECIPIENTS] (BBR) |If the Interface Level parameter = '04 - BE Plans + Contacts', the function (ie [UEEF]) will retrieve the Benefit Recipients [P2K_BE_BENEFIT_RECIPIENTS] (BBR) for the Benefit Enrollment (BEN) in order to retrieve the Benefit Contacts (ECT) information that links to Benefit Recipients. This field returns the [BBR_ID], you may use this id in derivation expression to return other value that is related to [BBR_ID].
| 355601 | Ben Recip id (BBR) |From [P2K_BE_BENEFIT_RECIPIENTS] (BBR) |If the Interface Level parameter = '04 - BE Plans + Contacts', the function (ie [UEEF]) will retrieve the Benefit Recipients [P2K_BE_BENEFIT_RECIPIENTS] (BBR) for the Benefit Enrollment (BEN) in order to retrieve the Benefit Contacts (ECT) information that links to Benefit Recipients. This field returns the [BBR_ID], you may use this id in derivation expression to return other value that is related to [BBR_ID]
At line 905 changed 4 lines
| 358001 | Internal Table Desc1 | |A temporary internal PL/SQL table is defined for the Generic Interface program. This PL/SQL table holds information for up to five columns. Each column has a description and an amount and each amount can be totaled. Depending on each business requirement, the program will load information into this PL/SQL table for internal purpose. (e.g. [UPROEF] uses this table to hold up to 52 Pay Periods in Desc1 column and the associated hours in Amount 1 column and earnings in Amount 2 column for each pay period.) This PL/SQL table is not used for [UEEF]. This variable name returns the internal PL/SQL Table Column 1 description.
| 358002 | Internal Table Desc2 | |Same as Internal Table Desc 1. This variable name returns Column 2 description.
| 358003 | Internal Table Desc3 | |Same as Internal Table Desc 1. This variable name returns Column 3 description.
| 358004 | Internal Table Desc4 | |Same as Internal Table Desc 1. This variable name returns Column 4 description..
| 358001 | Internal Table Desc1 | |A temporary internal PL/SQL table is defined for the Generic Interface Program. This PL/SQL table holds up to 5 columns information. Each column has a description and an amount. Each amount can be totaled. Depending on each business requirement, the program will load information into this PL/SQL table for internal purpose, e.g. [UPROEF] uses this table to hold up to 52 Pay Periods in Desc1 column and the associated hours in Amount 1 column and earnings in Amount 2 column for each pay period. This PL/SQL table is not used for [UEEF]. This variable name returns the internal PL/SQL Table Column 1 description
| 358002 | Internal Table Desc2 | |Same as Internal Table Desc 1. This variable name returns Column 2 description
| 358003 | Internal Table Desc3 | |Same as Internal Table Desc 1. This variable name returns Column 3 description
| 358004 | Internal Table Desc4 | |Same as Internal Table Desc 1. This variable name returns Column 4 description
At line 910 changed one line
| 358011 | Internal Table Amt 1 | |Same as Internal Table Desc 1. This variable name returns Column 1 Amount.
| 358011 | Internal Table Amt 1 | |Same as Internal Table Desc 1. This variable name returns Column 1 Amount
At line 912 changed 3 lines
| 358013 | Internal Table Amt 3 | |Same as Internal Table Desc 1. This variable name returns Column 3 Amount.
| 358014 | Internal Table Amt 4 | |Same as Internal Table Desc 1. This variable name returns Column 4 Amount.
| 358015 | Internal Table Amt 5 | |Same as Internal Table Desc 1. This variable name returns Column 5 Amount.
| 358013 | Internal Table Amt 3 | |Same as Internal Table Desc 1. This variable name returns Column 3 Amount
| 358014 | Internal Table Amt 4 | |Same as Internal Table Desc 1. This variable name returns Column 4 Amount
| 358015 | Internal Table Amt 5 | |Same as Internal Table Desc 1. This variable name returns Column 5 Amount
At line 917 changed 7 lines
| 358023 | Internal Total for Amt 3 | |Same as Internal Table Desc 1. This variable name returns Column 3 Total Amount.
| 358024 | Internal Total for Amt 4 | |Same as Internal Table Desc 1. This variable name returns Column 4 Total Amount.
| 358025 | Internal Total for Amt 5 | |Same as Internal Table Desc 1. This variable name returns Column 5 Total Amount.
| 358030 | UDF (EID) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_IDENTITIES] (EID)|You must define the UDF on [IMUF] screen for [P2K_HR_IDENTITIES] and then enter the value on [IEID] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field.
| 358031 | UDF (EEM) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_EMPLOYMENTS] (EEM)|You must define the UDF on [IMUF] screen for [P2K_HR_EMPLOYMENTS] and then enter the value on [IEEI] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field.
| 358032 | UDF (EASD) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|You must define the UDF on [IMUF] screen for [P2K_HR_ASSIGNMENT_DETAILS] and then enter the value on [IEAS] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field.
| 358033 | UDF (BPN) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_BE_PLAN_DEFINITIONS] (BPN)|You must define the UDF on [IMUF] screen for [P2K_BE_PLAN_DEFINITIONS] and then enter the value on [IBPN] screen section. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field.
| 358023 | Internal Total for Amt 3 | |Same as Internal Table Desc 1. This variable name returns Column 3 Total Amount
| 358024 | Internal Total for Amt 4 | |Same as Internal Table Desc 1. This variable name returns Column 4 Total Amount
| 358025 | Internal Total for Amt 5 | |Same as Internal Table Desc 1. This variable name returns Column 5 Total Amount
| 358030 | UDF (EID) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_IDENTITIES] (EID)|User must define the UDF on [IMUF] screen for [P2K_HR_IDENTITIES] and then enter the value on [IEID] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field
| 358031 | UDF (EEM) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_EMPLOYMENTS] (EEM)|User must define the UDF on [IMUF] screen for [P2K_HR_EMPLOYMENTS] and then enter the value on [IEEI] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field
| 358032 | UDF (EASD) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|User must define the UDF on [IMUF] screen for [P2K_HR_ASSIGNMENT_DETAILS] and then enter the value on [IEAS] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field
| 358033 | UDF (BPN) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_BE_PLAN_DEFINITIONS] (BPN)|User must define the UDF on [IMUF] screen for [P2K_BE_PLAN_DEFINITIONS] and then enter the value on [IBPN] screen section. On [IDIF] screen, user must enter the [IMUF] UDF name in the Constant Value field
At line 930 changed 6 lines
| 358040 | Element (PPH) | Indicates this Rec#/Fld# contains an Element value for the current pay header that is loaded in program|On [IDIF] screen, you should enter the Element name in the Constant Value field. This is not supported in [UBEF] because pay header is not loaded for Employee Interface.
| 358041 | Internal Element |Indicates this Rec#/Fld# contains an internal Element value that is loaded in program |On [IDIF] screen, you should enter the Element name in the Constant Value field. This is not supported in [UBEF] because Element value is not loaded for Employee Interface. A temporary internal PL/SQL table is defined for the program. The index of this PL/SQL table is made up from Rec#/Fld#, e.g. Rec#50 Fld# 60 index is 5060. The program must internally load values into this PL/SQL table by Rec#/Fld#. Then this field returns the value stored in this PL/SQL table by Rec#/Fld#. Depending on each business requirement, the program will load information into this PL/SQL table for internal purpose.
| 358042 | Statistic Amt (IEST) | Indicates this Rec#/Fld# contains a Statistics value from [P2K_HR_STATISTICS] (EST)|You must define the Statistics Code on [IDSC] screen for [P2K_CM_STATISTIC_COMPONENTS] and then enter the value on [IEST] screen. On [IDIF] screen, you must enter the [IDSC] Statistics Code in the Constant Value field
| 358043 | UDF (ECT) | |
| 358044 | UDF (BEN) | |
| 358045 | UDF (BEND) | |
| 358040 | Element (PPH) | Indicates this Rec#/Fld# contains an Element value for the current pay header that is loaded in program|On [IDIF] screen, you should enter the Element name in the Constant Value field. This is not supported in [UBEF] because pay header is not loaded for Employee Interface
| 358041 | Internal Element |Indicates this Rec#/Fld# contains an internal Element value that is loaded in program |On [IDIF] screen, you should enter the Element name in the Constant Value field. This is not supported in [UBEF] because Element value is not loaded for Employee Interface. A temporary internal PL/SQL table is defined for the Program. The index of this PL/SQL table is made up from Rec#/Fld#, e.g. Rec#50 Fld# 60 index is 5060. The program must internally load values into this PL/SQL table by Rec#/Fld#. Then this field returns the value stored in this PL/SQL table by Rec#/Fld#. Depending on each business requirement, the program will load information into this PL/SQL table for internal purpose.
| 358042 | Statistic Amt (IEST) (35) | Indicates this Rec#/Fld# contains a Statistics value from [P2K_HR_STATISTICS] (EST)|User must define the Statistics Code on [IDSC] screen for [P2K_CM_STATISTIC_COMPONENTS] and then enter the value on [IEST] screen. On [IDIF] screen, you must enter the [IDSC] Statistics Code in the Constant Value field
| 358043 | UDF (ECT) (35) | |
| 358044 | UDF (BEN) (35) | |
| 358045 | UDF (BEND) (35) | |
At line 937 changed 5 lines
| 358061 | UDF(EEM)+Internal Element | Same as 358051 above. 358051 field returns the Element value, 358061 field returns the UDF(EEM) value.| This is not supported in [UBEF] because Element value is not loaded for Employee Interface.
| 359000 | Record Count | Contains Record Count for Record Type = 'Detail Record'and 'Detail Level n' records|This Record Count is available for Header and Trailer record.
| 359001 | Total Record Count | Contains Record Count for all records in the interface file excluding the Header and Trailer Record.|This Record Count is available for Header and Trailer record.
| 359002 | Total Employer Count | |Not Supported
| 359003 | Total Value (35) | |You should specify the Rec# and Field # to be totaled in [IDIF] Constant Value field (e.g. If Rec # 50 Field # 70 specifies the hours for each employee and need to be totaled for the Trailer record, then for Trailer record entry, you should specify 'Total Value' with Constant Value = 5070.) This Total Value is available for Header and Trailer records.
| 358061 | UDF(EEM)+Internal Element | Same as 358051 above. 358051 field returns the Element value, 358061 field returns the UDF(EEM) value| This is not supported in [UBEF] because Element value is not loaded for Employee Interface.
| 359000 | Record Count (35) | Contains Record Count for Record Type = 'Detail Record'and 'Detail Level n' records|This Record Count is available for Header and Trailer record
| 359001 | Total Record Count (35) | Contains Record Count for all records in the interface file excluding the Header and Trailer Record|This Record Count is available for Header and Trailer record
| 359002 | Total Employer Count (35) | |Not Supported
| 359003 | Total Value (35) | |User should specify the Rec# and Field # to be totaled in [IDIF] Constant Value field e.g. if Rec # 50 Field # 70 specifies the hours for each employee and need to be totaled for the Trailer record, then for Trailer record entry, you should specify 'Total Value' with Constant Value = 5070. This Total Value is available for Header and Trailer records
At line 948 removed one line
| 359010 | Employee Count (35) |Contains Total Count of unique employees in the file across Detail Record Types 'Detail Record', 'Detail Level 1', 'Detail Level 2', 'Detail Level 3', 'Detail Level 4' and 'Detail Level 5'. Available for Header and Trailer records| If an employee appears in a 'Detail Record' at Rec# 30 and can also be found in 3 additional Detail Record Types in Rec# 40,50 and 60 the employee record will only be counted as 1. If the employee is being bypassed by the BYPASS derivation or the *SKIPREC#* derivation, this record entry will not be used in the Employee Count.|
At line 573 added 82 lines
!Step 2 - Define Interface Format in [IDIF]
Fixed File Format
The following set up instructions for a Fixed File format using the interface [HL$BE-ELIGTOTAL]
The interface does not need to be manually entered in IDIF it is loaded through seed data during an install or upgrade.
You should use (Copy Definition) to copy into a different Interface code and then enter your own company data.
XML File Format
The following instructions are for building an XML format for the UEEF using the format [HL$BE-ELIG-XML.]
!Step 3 - Defining UserCalcs
The file format for the UEEF can be defined to call a UserCalc function at each Record Number, each Field Number.
The Variable Name must equal 'UserCalc' and the UserCalc name must be specified in the Constant Value field.
The Field Type must be defined with Char, Number or Date, the UserCalc function on [IMUC] screen Return Value must match the values (Char, Number or Date) with the [IMUC] RET command to return the corresponding Char, Number or Date.
The data base tables available for UserCalc are:
*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
!Step 4 - Update Record Set Up
During the UEEF run, you may update certain User Defined Fields (UDF) to indicate the Interface File has been generated and mark the records as being processed. You may reference these UDFs in [IDIF] to prevent the same information from being processed again.
On [IDIF] screen, Record Type '92-Update Record' should be defined at the end of the [IDIF] definition.
The Variable Name should contain the UDF (xxx) that is to be Updated or Inserted, e.g.'358043 - UDF (ECT) (35)'.
The Constant Value field should contain the Name of the UDF, e.g 'UEEF by BEN'. Please note that it will be up shifted.
If this UDF name does not exist on the [IMUF] screen, UEEF will create the UDF with this name on [IMUF] screen for the Data Base Table to be updated.
The Derivation Expression field should contain the expression that is evaluated to the value to be updated for the UDF.
The following Derivation Expression features can be used to derive the value to be updated:
* multiple fields processing, DECODE, BYPASS, String manipulation,concatenation, function calls etc
When UEEF is run in non-trial mode, Record Type '92-Update Record' will be processed at the appropriate levels to check if the UDF should be updated for the associated Data Base tables.
From above example:
*Rec#200 Field#10 indicates to update 'UDF (ECT)', this will be processed at the end of each qualified Contact
* Rec#200 Field#15 indicates to update 'UDF (BPN)', this will be processed at the end of each qualified Benefit Plan
* Rec#200 Field#20 indicates to update 'UDF (BEN)', this will be processed at the end of each qualified employee [IBEN] Benefit plan
* Rec#200 Field#30 indicates to update 'UDF (BEND)', this will be processed at the end of each qualified employee [IBEN] Benefit plan
* Rec#200 Field#40 indicates to update 'UDF (EPS)', this will be processed at the end of each qualified employee
Using the Returned Value of the Derivation Expression, UEEF finds if the UDF already exists.
If the UDF exists and the new value is different than the existed UDF value, it will be updated; if the UDF does not exist, it will be inserted.
List of UDF supported in UEEF from [X_INF_VARIABLE_NAME] are:
*358030 - UDF (EID) (35)
*358031 - UDF (EEM) (35)
*358032 - UDF (EASD) (35)
*358033 - UDF (EASD) (35)
*358034 - UDF (EPS) (35)
*358035 - UDF (DED) (35)
*358036 - UDF (DDD) (35)
*358037 - UDF (DLN) (35)
*358038 - UDF (DUD) (35)
*358039 - UDF (DGD) (35)
*358043- UDF (ECT) (35)
*358044- UDF (BEN) (35)
*358045- UDF (BEND) (35)
After UDFs are updated or inserted in UEEF, the Number of Records Updated for each Data Base Table will be displayed on the UEEF report.
Note that these Number of UDF Updated represents the number of times the tables are being touched, these may not necessarily be the exact number of UDF for that Table, e.g. UDF (EEM) may be touched 2 times if an employee has 2 Contacts to update the same
EEM but with a different Value
At line 656 added 74 lines
!!Processing Information
Based on the selection criteria, UEEF retrieves employee basic information and primary assignment information
From the UEEF 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
Based on the value selected in the parameter 'Interface Level', the following information will be written to the interface file
||Interface Level Value||Usage
| EEM + EASD|Primary assignment and related data base tables are loaded. This level will perform [IDIF] Record Type 'Detail Record' for each primary assignment information, i.e. write one entry per employee
| EEM + EASD + Contacts|Primary assignment and related data base tables are loaded. This level will perform [IDIF] Record Type 'Detail Record' for each primary assignment information, i.e. write one entry per employee. Then the Contacts information for this employee will be loaded and perform [IDIF] Record Type 'Detail Level 1 to 5' for each Contact information, i.e. generate all contact entries for this employee
| 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
| BE + Contacts|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. Then the Contacts information for this BE plan will be loaded and perform [IDIF] Record Type 'Detail Level 1 to 5' for each Contact information, i.e. generate all contact entries for this BE plan.
| BE + Pay Lines|Not supported in UEEF, used by UPNVPERS
| GAPERS/GATRS|Not supported in UEEF, used by UBEF
;Update Records
When UEEF is run in non-trial mode, Record Type '92-Update Record' will be processed at the appropriate levels to check if the User Defined Fields (UDF) are to be updated for the associated Data Base Tables
-----
!!UEEF to Extract Changes Only
The Generic Employee Interface (UEEF) may be used as a data extraction process that selects only the changed data. Quite often third party vendors will not accept all records being transmitted with each transfer. The UEEF will filter extracted data based on a specified list of tables that have changed after a given date.
!Turn on Change Logging
In order for the extracted data to be filtered by changes a system administrator must first turn on 'Logging' on the tables they wish to pick up changes for. This is done in [IMTD] and [IMCD].
Setting up logging on tables and columns should only be done by an administrator since this can have an impact on performance.
Please refer to the Detailed Change Auditing document for instructions on how to configure this
!Process UEEF with Changes Only
Review the above section for detailed information on how to set up the interface file format for the UEEF function. Once the interface file format has been set up and the logging has been turned on, you are now able to run UEEF to extract changes only data.
In order for UEEF to extract changes only two new parameters have been added:
#Changed Since:
#Changed Tables:
If you need to run an exception level 9 for additional trace, you need to supply a person code. If you do not do so, there will be a warning message in the report indicating that due to the volume of trace messages, the exception level is internally reset to 1 and that if you need to run with level 9, to enter an employee to be traced.
----
!!Report Parameters
||Report Parameters||
|Entity|Must enter one entity. (Mandatory)
|As Of Date|This date is used to retrieve employee information where a date is needed
|Sort By Active EEs|Check this toggle to sort inactive employees first
|Sort People By|You should sort employees by Last Name/First Name, however you may sort by employee's pay destination or sort by Person code. Lexicon [X_PERSON_SORT] values
|ER Address Location|Allows you to enter an overridden Location to retrieve the Employer Address.(Optional)
|Changed Since|This date field is used to filter the [P2K_AM_CHANGE_LOGS] table to only show data changed since this date. When this parameter is left blank, the interface process will not be filtered by the change logs
|Changed Tables|If a table is selected, the system will only look for changes that have occurred in the specified table. More than one table may be selected at a given time. If there is no table selected and if a changed 'Since' date has been supplied, the system will not export any rows. Tables that are currently supported are: [P2K_HR_IDENTITIES], [P2K_HR_PERSONALS], [P2K_HR_EMPLOYMENTS], [P2K_HR_ASSIGNMENTS], [P2K_HR_ASSIGNMENT_DETAILS], [P2K_PR_PAYMENT_RULE_DETAILS], [P2K_PR_US_PAY_RULES]
|Trial Run|Optional toggle to indicate if the UDFs are to be updated for the UEEF run. The value of 'Y' or 'N' is always returned in this parameter field. To run in non-Trial mode (Update mode), you should define [IDIF] Record Type '92-Update Record' to update UDFs
|Interface Format Code|Enter the Interface code from [IDIF] screen. (Mandatory)
|Interface Level|Specify the level for the Interface file to be produced. (Mandatory) Lexicon [X_INTERFACE_LEVEL]
|Directory Name|Enter a valid directory name
|File Name|Enter a file name or use the default file name from [IDIF] screen
|Write Append to File|Provides the option to write a file or append to an existing one.
|Exception Level|You should always run with 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|Please specify if People list is to be used. (Optional)
|Person|Enter one or more Person Codes. (Optional)
|Location|Enter one or more Location codes. (Optional)
|Auth Area|Enter one or more Authorization Areas. (Optional)
|Department|Enter one or more Department Codes. (Optional)
|Org Level Type|Enter one or more Org Level Types. (Optional)
|Org Level|Enter one or more Org Level within Org Level Types. (Optional)
|Unit|Enter one or more Unit codes. (Optional)
|Group|Enter one or more Group codes. (Optional)
|Payroll|Enter one or more Payroll codes. (Optional)
|Employment Status|Enter one or more Employment Statuses. (Optional)
|Termination Reason|Enter one or more Termination Reasons. (Optional)
|Plan Type|Applicable if Interface Level = 'BE plans' or 'BE + Contacts'. (Optional)
|Plan|Applicable if Interface Level = 'BE plans' or 'BE + Contacts'. (Optional)
----
This page (revision-79) was last changed on 20-Sep-2023 14:24 by Lilia UrtanTop