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 128 changed 3 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',~)
| 353102 | S.S.N. (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353100 | Person Code (EID) | [P2K_HR_IDENTITIES] (EID) is retrieved for the employee|This field returns the [Person code|PERSON_CODE] from [EID].
| 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',~)
| 353102 | Government Code (EID) | From [P2K_HR_IDENTITIES] (EID)|
At line 146 changed one line
| 353134 | Vetern Status (EID) | From [P2K_HR_IDENTITIES] (EID)|
| 353134 | Veteran Status (EID) | From [P2K_HR_IDENTITIES] (EID)|
At line 152 changed one line
| 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]
| 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]
At line 158 changed 2 lines
| 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)|
| 353206 | Address 2 + Locality (EPS) | From [P2K_HR_PERSONALS] (EPS)|Employee Address Line 2 and Locality (city) are concatenated
| 353207 | Locality (EPS) | From [P2K_HR_PERSONALS] (EPS)|
At line 168 changed 2 lines
| 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)|
| 353222 | Mail Ln2 + 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)|
At line 172 changed one line
| 353226 | Mail Zip (EPS) | From [P2K_HR_PERSONALS] (EPS)|
| 353226 | Mail Zip Postal (EPS) | From [P2K_HR_PERSONALS] (EPS)|
At line 206 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] of DTR
At line 211 changed 6 lines
| 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]
| 353394 | Reason issue (ROE) | From [IEEI] UDF '[ROE REASON CODE|ROE REASON CODE (UDF)]' if specified, otherwise from [IEEI] [TERMINATION_CODE] [ROE_LETTER]| When employee is terminated, the [IEEI] EMPLOYMENT specifies a Termination Reason. The '[Termination Reason|TERMINATION_CODE]' is defined on [IDTR] screen with an [ROE_LETTER]. Used by [UPROEF]
| 353395 | ROE process meth (ROE) |From [UPROEF] program internal Process method |
| 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 |
| 353394 | Reason issue (ROE) | From [UPROEF] program internal ROE Reason issue
| 353395 | ROE process meth (ROE) |From [UPROEF] program internal Process method|
At line 231 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 [UEEF] 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 253 changed one line
| 353522 | Fte (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353522 | FTE (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
At line 260 changed one line
| 353529 | Use Fte Wages (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353529 | Use FTE Wages (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
At line 271 changed one line
| 353540 | WC Class (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353540 | WCB Class (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
At line 282 changed 2 lines
| 353551 | Job Class Lex Value | 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 the As of Date parameter|
| 353602 | Effective (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 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 313 changed 5 lines
| 353632 | Ust Sui Ee Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353633 | Ust Sui Er Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353634 | Ust Sdi Ee Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353635 | Ust Sdi Er Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353636 | Ust WC Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353632 | Ust SUI EE Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353633 | Ust SUI ER Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353634 | Ust SDI EE Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353635 | Ust SDI ER Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353636 | Ust WCB Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
At line 337 changed one line
| 353701 | Effective (PPRC) | if the Entity Detail (DED) legislation is for Canada, [P2K_PR_CDN_PAY_RULES] (PPRC) is retrieved for the employee's Employment effective as of the As of Date parameter|
| 353701 | Effective (PPRC) | if the Entity Detail (DED) legislation is for Canada, [P2K_PR_CDN_PAY_RULES] (PPRC) is retrieved for the employee's Employment effective as of the [UEEF] As of Date parameter|
At line 349 changed 2 lines
| 353713 | Cfed Cpp Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353714 | Cfed Ei Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353713 | Cfed CPP Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353714 | Cfed EI Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
At line 352 changed 11 lines
| 353716 | Cprv Claim Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353717 | Cprv Num Dependents (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353718 | Cprv Ann Tax Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353719 | Cprv Tax Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353720 | Cprv Tax Percent (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353721 | Cprv Add Tax Per Prd (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353722 | Cprv Filing Status (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353723 | Cprv Tax Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353724 | Cprv Qpp Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353725 | Cprv Health Tax Mthd (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353726 | Cprv WC Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353716 | CPRV Claim Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353717 | CPRV Num Dependents (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353718 | CPRV Ann Tax Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353719 | CPRV Tax Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353720 | CPRV Tax Percent (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353721 | CPRV Add Tax Per Prd (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353722 | CPRV Filing Status (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353723 | CPRV Tax Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353724 | CPRV QPP Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353725 | CPRV Health Tax Mthd (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353726 | CPRV WCB Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
At line 367 changed 3 lines
| 353731 | Cprv Ann Tax Credit (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353732 | Cprv Ann Area Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353801 | Contacts ect_id (ECT) |From [P2K_HR_CONTACTS] (ECT) |If the Interface Level parameter = '02 - EEM + EASD + Contacts', [P2K_HR_CONTACTS] (ECT) is retrieved for the employee's Identity (EID). If the Interface Level parameter = '04 - BE Plans + Contacts', [P2K_HR_CONTACTS] (ECT) is retrieved for the employee's Benefit Recipients (BBR) of the Benefit Enrollment (BEN) of the Employments (EEM)
| 353731 | CPRV Ann Tax Credit (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353732 | CPRV Ann Area Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353801 | Contacts ect_id (ECT) |From [P2K_HR_CONTACTS] (ECT) |If the [UEEF] Interface Level parameter = '02 - EEM + EASD + Contacts', [P2K_HR_CONTACTS] (ECT) is retrieved for the employee's Identity (EID). If the [UEEF] Interface Level parameter = '04 - BE Plans + Contacts', [P2K_HR_CONTACTS] (ECT) is retrieved for the employee's Benefit Recipients (BBR) of the Benefit Enrollment (BEN) of the Employments (EEM)
At line 387 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 + Locality(ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address Line 2 and Locality (city) are concatenated
At line 392 changed one line
| 353824 | State+Cntry+Zip (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 395 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 399 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 414 changed 5 lines
| 353846 | Student_Indicator (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353847 | Student_Until (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353848 | Disabled (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 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 464 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 470 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 492 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]
This page (revision-27) was last changed on 26-Nov-2021 10:22 by kparrottTop