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

Version management

Difference between version and

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 386 changed one line
| 353819 | Addr Ln2 + Locality(ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address Line 2 and Locality (city) are concatenated
| 353819 | Addr Ln2 + Locality(ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address Line 2 and Locality (city) are concatenated
At line 391 changed one line
| 353824 | State+Cntry+Postal (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address State/Prov, Country and Postal Code are concatenated
| 353824 | State+Cntry+Postal (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address State/Prov, Country and Postal Code are concatenated
At line 394 changed 3 lines
| 353827 | Mail Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Mailing Address Line 2 and Locality (city) are concatenated
| 353828 | Mail City (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353829 | Mail State (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353827 | Mail Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Mailing Address Line 2 and Locality (city) are concatenated
| 353828 | Mail Locality (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353829 | Mail State Province (ECT) | From [P2K_HR_CONTACTS] (ECT)|
At line 398 changed 2 lines
| 353831 | Mail Zip Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353832 | Mail State+Cntry+Zip (ECT) | From [P2K_HR_CONTACTS] (ECT)|contact’s Mailing Address State/Prov, Country and Postal Code are concatenated
| 353831 | Mail Zip Postal (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 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 413 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 [UEEF]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 [UEEF] parameter. This 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 [UEEF] 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 460 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|P2K_BE_COVERAGES (BCG) is retrieved for this Enrollment Detail BEND.bcg_id//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 466 changed one line
| 355401 | Covg Detail id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD) effective as of the As of Date parameter|
| 355401 | Covg Detail id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD) effective as of the [UEEF] As of Date parameter|
At line 488 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 [UEEF] Interface Level parameter = '04 - BE Plans + Contacts', [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]