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 3 lines
| 350001 | XML Begin Tag (35) | |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 (35) | |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 (35) | | Indicates this Rec#/Fld# contains a constant \\ You should enter the constant in Constant Value field
| 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
At line 11 changed 3 lines
| 350005 | As Of Date (35) | From [UBEF] As Of Date parameter|
| 350006 | Execution ID (35) | From [UBEF] 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
| 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
At line 22 changed one line
| 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',~)
| 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 26 changed one line
| 350110 | Effective (DED) | From [P2K_CM_ENTITY_DETAILS] (DED) effective as of [UEEF] As of Date parameter|
| 350110 | Effective (DED) | From [P2K_CM_ENTITY_DETAILS] (DED) effective as of the As of Date parameter|
At line 34 changed one line
| 350201 | Location Code (DLN) | [P2K_CM_LOCATIONS] (DLN) is retrieved from DED.DLN_ID|If [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 the parameter 'Er Addr Location' is specified, then this location is used as the Employer Address
At line 63 changed one line
| 350300 | Department ddp_id (DDP) | [P2K_CM_DEPARTMENTS] (DDP) is retrieved from employee's prime assignment|This field returns the ddp.id, user may use this id in derivation expression to return other value that is related to ddp.id
| 350300 | Department ddp_id (DDP) | [P2K_CM_DEPARTMENTS] (DDP) is retrieved from employee's prime assignment|This field returns the [DDP_ID], user may use this id in derivation expression to return other value that is related to [DDP_ID]
At line 67 changed one line
| 350310 | Effective (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD) effective as of UEEF As of Date parameter|
| 350310 | Effective (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD) effective as of the As of Date parameter|
At line 80 changed one line
| 350400 | Unit dun_id (DUN) |[P2K_CM_UNITS] (DUN) is retrieved from employee's prime assignment|This field returns the dun.id, you may use this id in derivation expression to return other value that is related to dun.id
| 350400 | Unit dun_id (DUN) |[P2K_CM_UNITS] (DUN) is retrieved from employee's prime assignment|This field returns the [DUN_ID], you may use this id in derivation expression to return other value that is related to [DUN_ID]
At line 83 changed one line
| 350410 | Effective (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD) effective as of [UEEF] As of Date parameter|
| 350410 | Effective (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD) effective as of the As of Date parameter|
At line 93 changed one line
| 350500 | Group dgr_id (DGR) | [P2K_CM_GROUPS] (DGR) is retrieved from the employee's prime assignment dgr_id| This field returns the dgr.id, you may use this id in derivation expression to return other value that is related to dgr.id
| 350500 | Group dgr_id (DGR) | [P2K_CM_GROUPS] (DGR) is retrieved from the employee's prime assignment [DGR_ID]| This field returns the [DGR_ID], you may use this id in derivation expression to return other value that is related to [DGR_ID]
At line 129 changed 2 lines
| 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',~)''
| 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 135 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 153 changed one line
| 353200 | Personal eps_id (EPS) |[P2K_HR_PERSONALS] (EPS) is retrieved for the employee effective as of 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 190 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 222 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 232 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 374 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 415 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 435 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 439 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 462 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 490 changed one line
| 355601 | Ben Recip id (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]
This page (revision-27) was last changed on 26-Nov-2021 10:22 by kparrottTop