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 9 changed 2 lines
*[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
*[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 12 changed one line
*[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.
*[X_INF_VARIABLE_NAME]\\X_INF_VARIABLE_NAME contains a list of system-defined variables that are eligible by Interface type.\\
At line 14 added 2 lines
Below is a list describing each variable and its usage for Interface type 35:
At line 16 changed 4 lines
| 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
| 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 (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
At line 22 changed 3 lines
| 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',~)
| 350007 | User Calc (35) | |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 (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 27 changed one line
| 350103 | G/L Company (DEN) (35) |From [P2K_CM_ENTITIES] (DEN) GL Company id to retrieve [GL Company code|GL_COMPANY_CODE] |
| 350103 | G/L Company (DEN)|From [P2K_CM_ENTITIES] (DEN) GL Company id to retrieve [GL Company code|GL_COMPANY_CODE] |
At line 36 changed one line
| 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
| 350201 | Location Code (DLN) | [P2K_CM_LOCATIONS] (DLN) is retrieved from DED.DLN_ID|If the [UEEF] parameter 'Er Addr Location' is specified, then this location is used as the Employer Address
At line 55 changed one line
| 350227 | Maill State+Cntry+Postal(DLN) | From [P2K_CM_LOCATIONS] (DLN)|Location Mailing Address State/Prov, Country and Postal Code are concatenated
| 350227 | Mail State+Cntry+Postal(DLN) | From [P2K_CM_LOCATIONS] (DLN)|Location Mailing Address State/Prov, Country and Postal Code are concatenated
This page (revision-79) was last changed on 20-Sep-2023 14:24 by Lilia UrtanTop