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

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

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
27 26-Nov-2021 10:22 51 KB kparrott to previous
26 26-Nov-2021 10:22 50 KB jmyers to previous | to last
25 26-Nov-2021 10:22 53 KB jmyers to previous | to last
24 26-Nov-2021 10:22 53 KB jmyers to previous | to last
23 26-Nov-2021 10:22 52 KB jmyers to previous | to last
22 26-Nov-2021 10:22 50 KB jmyers to previous | to last
21 26-Nov-2021 10:22 50 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
X_INF_VARIABLE_NAME (35)
X_INF_VARIABLE_NAME (35)

Version management

Difference between version and

At line 7 changed 8 lines
| 350001 | XML Begin Tag (35) | |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 (35) | |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 (35) | | 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 As Of Date parameter|
| 350006 | Execution ID (35) | From the function's Execution ID of the run|
| 350007 | User Calc (35) | |Indicates this Rec#/Fld# will invoke a UserCalcUserCalc . You should enter the UserCalc name in the Constant Value field, e.g. BE USERCALC
| 350008 | Trial Run (35) | |
| 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| 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 As Of Date parameter|
| 350006 | Execution ID| From the function's 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
| 350008 | Trial Run | |
At line 25 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 125 changed one line
| 350801 | Govt Regist dgv_id (35) |From [P2K_CM_GOVT_REGISTRATIONS] (DGV) |
| 350801 | Govt Regist dgv_id |From [P2K_CM_GOVT_REGISTRATIONS] (DGV) |
At line 129 changed one line
| 353101 | Person eid_id (EID) | From [P2K_HR_IDENTITIES] (EID)|this field returns the eid.id, user may use this id in 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',~)
| 353101 | Person eid_id (EID) | From [P2K_HR_IDENTITIES] (EID)|this field returns the eid.id, user may use this id in 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 282 changed one line
| 353602 | Effective (PPRU) |if the Entity Detail (DED) legislation is for US, P2K_PR_US_PAY_RULES (PPRU) is retrieved for the employee’s Employment effective as of UEEF As of Date parameter|
| 353602 | Effective (PPRU) |if the Entity Detail (DED) legislation is for US, P2K_PR_US_PAY_RULES (PPRU) is retrieved for the employee's Employment effective as of UEEF As of Date parameter|
At line 509 changed 29 lines
| 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.\\If this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 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.\\If this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 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\\- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 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.\\- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen.
| 358034 | UDF (EPS) (35) | |- indicates this Rec#/Fld# contains a UDF value from P2K_HR_PERSONALS (EPS)
- user must define the UDF on IMUF screen for P2K_HR_PERSONALS and then enter the value on IEPI screen
- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field
- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358035 | UDF (DED) (35) | |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_ENTITY_DETAILS (DED)
- user must define the UDF on IMUF screen for P2K_CM_ENTITY_DETAILS and then enter the value on IDEN screen
- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field
- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358036 | UDF (DDD) (35) | |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_DEPARTMENT_DETAILS (DDD)
- user must define the UDF on IMUF screen for P2K_CM_DEPARTMENT_DETAILS and then enter the value on IDDP screen
- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field
- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358037 | UDF (DLN) (35) | |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_LOCATIONS (DLN)
- user must define the UDF on IMUF screen for P2K_CM_LOCATIONS and then enter the value on IDLN screen
- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field
- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358038 | UDF (DUD) (35) | |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_UNIT_DETAILS (DUD)
- user must define the UDF on IMUF screen for P2K_CM_UNIT_DETAILS and then enter the value on IDUN screen
- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field
- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358030 | UDF (EID) | 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.\\If this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358031 | UDF (EEM) | 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.\\If this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358032 | UDF (EASD) | 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\\- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358033 | UDF (BPN) | 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.\\- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen.
| 358034 | UDF (EPS) |- indicates this Rec#/Fld# contains a UDF value from P2K_HR_PERSONALS (EPS) |- user must define the UDF on IMUF screen for P2K_HR_PERSONALS and then enter the value on IEPI screen\\- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field\\- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358035 | UDF (DED) |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_ENTITY_DETAILS (DED) |- user must define the UDF on IMUF screen for P2K_CM_ENTITY_DETAILS and then enter the value on IDEN screen\\- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field\\- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358036 | UDF (DDD) |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_DEPARTMENT_DETAILS (DDD) |- user must define the UDF on IMUF screen for P2K_CM_DEPARTMENT_DETAILS and then enter the value on IDDP screen\\- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field\\- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358037 | UDF (DLN) |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_LOCATIONS (DLN) |- user must define the UDF on IMUF screen for P2K_CM_LOCATIONS and then enter the value on IDLN screen\\- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field\\- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358038 | UDF (DUD) (35) |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_UNIT_DETAILS (DUD) |- user must define the UDF on IMUF screen for P2K_CM_UNIT_DETAILS and then enter the value on IDUN screen\\- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field\\- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
This page (revision-27) was last changed on 26-Nov-2021 10:22 by kparrottTop