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 241 changed 222 lines
| 353509 | Group Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353510 | Location Work In (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353511 | Location Paydest (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353512 | Authorization Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353513 | Tax Jurisdiction (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353514 | Work Calendar (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353515 | Work Rule (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353516 | Supervised By (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353517 | Replaced By (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353518 | Job Profile (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353519 | Range Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353520 | Scale Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353521 | Step Code (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353522 | Fte (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353523 | Assignment Title (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353524 | Hours Per Day (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353525 | Hours Per Week (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353526 | Hours Per Pay (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353527 | Wage Rate (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353528 | Rate Basis (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353529 | Use Fte Wages (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353530 | Out Of Range (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353531 | Scale Overridden (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353532 | Periods Elected (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353533 | Pay Starting Date (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353534 | Contract Days (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353535 | Contract Limit (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353536 | Job Seniority Date (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353537 | Service Rating (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353538 | Responsibility Level (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353539 | Work Type (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353540 | WC Class (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353541 | Phone Number (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353542 | Phone Extension (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353543 | Email Address (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353544 | Leave Date (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353545 | Leave Reason (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353546 | Leave Return Date (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353547 | Trigger Retro (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353548 | Provide Public Sve (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353549 | Provide Internal Sve (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 353550 | Supervisory (EASD) | From P2K_HR_ASSIGNMENT_DETAILS (EASD)|
| 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 UEEF As of Date parameter|
| 353602 | Effective (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353603 | Expiry (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353604 | Change Code (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353605 | Ufed Filing Status (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353606 | Ufed Num Exemptions (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353607 | Ufed Ann Exemption (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353608 | Ufed Add Exemption (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353609 | Ufed Add Tax Per Prd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353610 | Ufed Tax Amount (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353611 | Ufed Tax Percent (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353612 | Ufed Tax Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353613 | Ufed Suppl Tax Mthd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353614 | Ufed Fica Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353615 | Ufed Medicare Mthd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353616 | Ufed Futa Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353617 | Ufed Eic Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353618 | Ust Reciprocation (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353619 | Ust Filing Status (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353620 | Ust Num Exemption 1 (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353621 | Ust Num Exemption 2 (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353622 | Ust Ann Exemption (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353623 | Ust Add Exemption (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353624 | Ust Add Tax Per Prd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353625 | Ust Add Tax Res (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353626 | Ust Add Tax Work (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353627 | Ust Tax Amount (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353628 | Ust Tax Percent (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353629 | Ust Tax Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353630 | Ust Suppl Tax Mthd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353631 | Ust Alt Tax 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 WC Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353637 | Uloc Reciprocation (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353638 | Uloc Filing Status (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353639 | Uloc Num Exemptions (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353640 | Uloc Ann Exemption (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353641 | Uloc Exempt Percent (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353642 | Uloc Add Tax Per Prd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353643 | Uloc Add Tax Work (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353644 | Uloc Add Tax Res (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353645 | Uloc Tax Amount (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353646 | Uloc Tax Percent 1 (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353647 | Uloc Tax Percent 2 (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353648 | Uloc County Tax Mthd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353649 | Uloc City Tax Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353650 | Uloc School Tax Mthd (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353651 | Uloc School Tax Amt (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353652 | Uloc School Tax % (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353653 | Uloc Head Tax Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353654 | Uloc Head Tax Amount (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 353655 | Ust Eic Method (PPRU) | From P2K_PR_US_PAY_RULES (PPRU)|
| 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 UEEF As of Date parameter|
| 353702 | Expiry (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353703 | Change Code (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353704 | Cfed Td1 Amount (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353705 | Cfed Ann Tax Credit (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353706 | Cfed Ann Tax Deduct (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353707 | Cfed Ann Area Deduct (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353708 | Cfed Tax Amount (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353709 | Cfed Tax Percent (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353710 | Cfed Add Tax Per Prd (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353711 | Cfed Filing Status (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353712 | Cfed Tax 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)|
| 353715 | Cfed Labour Fund (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 WC Method (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353727 | Fed Tax Claim Type (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353728 | Fed Tax Claim Code (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353729 | Prov Tax Claim Type (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 353730 | Prov Tax Claim Code (PPRC) | From P2K_PR_CDN_PAY_RULES (PPRC)|
| 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 UEEF Interface Level parameter = '02 - EEM + EASD + Contacts', P2K_HR_CONTACTS (ECT) is retrieved for the employee's Identity (EID). If 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)
| 353802 | First_name (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353803 | Middle_name (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353804 | Last_name (ECT) | From P2K_HR_CONTACTS (ECT)|
| 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''
| 353808 | Gender (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353809 | Relation (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353810 | S.S.N. (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353811 | Birth_date (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353812 | Language_code (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353813 | Salutation (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353814 | Rank (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353815 | Employer (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353816 | Contact_title (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353817 | Address_line_1 (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353818 | Address_line_2 (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353819 | Addr Ln2 + City (ECT) | From P2K_HR_CONTACTS (ECT)|Contact’s Address Line 2 and Locality (city) are concatenated
| 353820 | City (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353821 | State Code (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353822 | Country Code (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353823 | Zip Code (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353824 | State+Cntry+Zip (ECT) | From P2K_HR_CONTACTS (ECT)|Contact’s Address State/Prov, Country and Postal Code are concatenated
| 353825 | Mail_address_line_1 (ECT) |From P2K_HR_CONTACTS (ECT) |if Mailing address does not exist, the primary address will be used
| 353826 | Mail_address_line_2 (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 City (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353829 | Mail State (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353830 | Mail Country Code (ECT) | From P2K_HR_CONTACTS (ECT)|
| 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
| 353833 | Phone_number (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353834 | Phone_extension (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353835 | Alt_phone_number (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353836 | Alt_phone_extn (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353837 | Cellular_number (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353838 | Fax_number (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353839 | Email_address (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353840 | Security_level (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353841 | Private_item (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353842 | Web_address (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353843 | Govt_code_origin (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353844 | Contacts eid_id (ECT) | From P2K_HR_CONTACTS (ECT)|
| 353845 | Contacts mus_id (ECT) | From P2K_HR_CONTACTS (ECT)|
| 355001 | Enrollment id (BEN) |P2K_BE_ENROLLMENTS (BEN) |If 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. 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 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
| 355003 | Effective (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355004 | Expiry (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355005 | Unofficial (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355006 | Enrollment_status (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355007 | Participation_rule (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355008 | Coverage_step_code (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355009 | Description (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355010 | Elig_start_date (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355011 | Elig_end_date (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355012 | Prem_start_date (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355013 | Prem_end_date (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355014 | Plan_reg_number (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355015 | Evidence_of_ins (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355016 | Percentage (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355020 | Freq pfq_id (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355021 | Change reason dcr_id (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355022 | Covg bcg_id (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355023 | Orig bend_id (BEND) | From P2K_BE_ENROLLMENT_DETAILS (BEND)|
| 355101 | Plan Type id (BPT) | From P2K_BE_ENROLLMENTS (BEN), it links to the P2K_BE_PLAN_DEFINITION (BPN) which links to P2K_BE_BENEFIT_PLAN_TYPE (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
| 355102 | Plan_type_code (BPT) | From P2K_BE_BENEFIT_PLAN_TYPE (BPT)|
| 355103 | Description (BPT) | From P2K_BE_BENEFIT_PLAN_TYPE (BPT)|
| 355104 | Calc_sequence (BPT) | From P2K_BE_BENEFIT_PLAN_TYPE (BPT)|
| 355201 | Plan Defn id (BPN) | From P2K_BE_ENROLLMENTS (BEN), it links to the P2K_BE_PLAN_DEFINITION (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
| 355202 | Plan_code (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355203 | Description (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355204 | Plan_access_code (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355205 | Established_date (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355206 | Participation_rule (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355207 | Policy_number (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355208 | Calc_sequence (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355209 | Plan_remit_seq (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355210 | Track_decline (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355211 | Last_remit_date (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355212 | Remit_by_state (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355213 | Remit_by_un_grp (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355214 | Remit_date_rule (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355215 | Remit_asof_day (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355216 | Print_zero_rule (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355217 | Print_all_waivers (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355218 | Not_scheduled (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355219 | Plan_end_date (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355220 | Approval_required (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355221 | Plan den_id (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355222 | Plan dcl_id (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 355223 | Plan brm_id (BPN) | From P2K_BE_PLAN_DEFINITION (BPN)|
| 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
| 353509 | Group Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353510 | Location Work In (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353511 | Location Paydest (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353512 | Authorization Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353513 | Tax Jurisdiction (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353514 | Work Calendar (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353515 | Work Rule (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353516 | Supervised By (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353517 | Replaced By (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353518 | Job Profile (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353519 | Range Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353520 | Scale Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353521 | Step Code (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353522 | Fte (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353523 | Assignment Title (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353524 | Hours Per Day (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353525 | Hours Per Week (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353526 | Hours Per Pay (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353527 | Wage Rate (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353528 | Rate Basis (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353529 | Use Fte Wages (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353530 | Out Of Range (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353531 | Scale Overridden (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353532 | Periods Elected (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353533 | Pay Starting Date (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353534 | Contract Days (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353535 | Contract Limit (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353536 | Job Seniority Date (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353537 | Service Rating (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353538 | Responsibility Level (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353539 | Work Type (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353540 | WC Class (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353541 | Phone Number (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353542 | Phone Extension (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353543 | Email Address (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353544 | Leave Date (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353545 | Leave Reason (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353546 | Leave Return Date (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353547 | Trigger Retro (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353548 | Provide Public Sve (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353549 | Provide Internal Sve (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 353550 | Supervisory (EASD) | From [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|
| 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)|
| 353603 | Expiry (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353604 | Change Code (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353605 | Ufed Filing Status (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353606 | Ufed Num Exemptions (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353607 | Ufed Ann Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353608 | Ufed Add Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353609 | Ufed Add Tax Per Prd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353610 | Ufed Tax Amount (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353611 | Ufed Tax Percent (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353612 | Ufed Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353613 | Ufed Suppl Tax Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353614 | Ufed Fica Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353615 | Ufed Medicare Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353616 | Ufed Futa Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353617 | Ufed Eic Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353618 | Ust Reciprocation (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353619 | Ust Filing Status (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353620 | Ust Num Exemption 1 (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353621 | Ust Num Exemption 2 (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353622 | Ust Ann Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353623 | Ust Add Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353624 | Ust Add Tax Per Prd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353625 | Ust Add Tax Res (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353626 | Ust Add Tax Work (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353627 | Ust Tax Amount (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353628 | Ust Tax Percent (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353629 | Ust Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353630 | Ust Suppl Tax Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353631 | Ust Alt Tax 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 WC Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353637 | Uloc Reciprocation (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353638 | Uloc Filing Status (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353639 | Uloc Num Exemptions (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353640 | Uloc Ann Exemption (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353641 | Uloc Exempt Percent (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353642 | Uloc Add Tax Per Prd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353643 | Uloc Add Tax Work (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353644 | Uloc Add Tax Res (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353645 | Uloc Tax Amount (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353646 | Uloc Tax Percent 1 (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353647 | Uloc Tax Percent 2 (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353648 | Uloc County Tax Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353649 | Uloc City Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353650 | Uloc School Tax Mthd (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353651 | Uloc School Tax Amt (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353652 | Uloc School Tax % (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353653 | Uloc Head Tax Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353654 | Uloc Head Tax Amount (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 353655 | Ust Eic Method (PPRU) | From [P2K_PR_US_PAY_RULES] (PPRU)|
| 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|
| 353702 | Expiry (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353703 | Change Code (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353704 | Cfed Td1 Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353705 | Cfed Ann Tax Credit (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353706 | Cfed Ann Tax Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353707 | Cfed Ann Area Deduct (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353708 | Cfed Tax Amount (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353709 | Cfed Tax Percent (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353710 | Cfed Add Tax Per Prd (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353711 | Cfed Filing Status (PPRC) | From[ P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353712 | Cfed Tax 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)|
| 353715 | Cfed Labour Fund (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 WC Method (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353727 | Fed Tax Claim Type (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353728 | Fed Tax Claim Code (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353729 | Prov Tax Claim Type (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 353730 | Prov Tax Claim Code (PPRC) | From [P2K_PR_CDN_PAY_RULES] (PPRC)|
| 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)
| 353802 | First_name (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353803 | Middle_name (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353804 | Last_name (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 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''
| 353808 | Gender (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353809 | Relation (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353810 | S.S.N. (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353811 | Birth_date (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353812 | Language_code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353813 | Salutation (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353814 | Rank (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353815 | Employer (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353816 | Contact_title (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353817 | Address_line_1 (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353818 | Address_line_2 (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353819 | Addr Ln2 + City (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address Line 2 and Locality (city) are concatenated
| 353820 | City (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353821 | State Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353822 | Country Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353823 | Zip Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353824 | State+Cntry+Zip (ECT) | From [P2K_HR_CONTACTS] (ECT)|Contact’s Address State/Prov, Country and Postal Code are concatenated
| 353825 | Mail_address_line_1 (ECT) |From [P2K_HR_CONTACTS] (ECT) |if Mailing address does not exist, the primary address will be used
| 353826 | Mail_address_line_2 (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 City (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353829 | Mail State (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353830 | Mail Country Code (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 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
| 353833 | Phone_number (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353834 | Phone_extension (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353835 | Alt_phone_number (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353836 | Alt_phone_extn (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353837 | Cellular_number (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353838 | Fax_number (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353839 | Email_address (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353840 | Security_level (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353841 | Private_item (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353842 | Web_address (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353843 | Govt_code_origin (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353844 | Contacts eid_id (ECT) | From [P2K_HR_CONTACTS] (ECT)|
| 353845 | Contacts mus_id (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
| 355003 | Effective (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355004 | Expiry (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355005 | Unofficial (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355006 | Enrollment_status (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355007 | Participation_rule (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355008 | Coverage_step_code (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355009 | Description (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355010 | Elig_start_date (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355011 | Elig_end_date (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355012 | Prem_start_date (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355013 | Prem_end_date (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355014 | Plan_reg_number (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355015 | Evidence_of_ins (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355016 | Percentage (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355020 | Freq pfq_id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355021 | Change reason dcr_id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355022 | Covg bcg_id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355023 | Orig bend_id (BEND) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND)|
| 355101 | Plan Type id (BPT) | From [P2K_BE_ENROLLMENTS] (BEN), it links to the [P2K_BE_PLAN_DEFINITION] (BPN) which links to [P2K_BE_BENEFIT_PLAN_TYPE] (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
| 355102 | Plan_type_code (BPT) | From [P2K_BE_BENEFIT_PLAN_TYPE] (BPT)|
| 355103 | Description (BPT) | From [P2K_BE_BENEFIT_PLAN_TYPE] (BPT)|
| 355104 | Calc_sequence (BPT) | From [P2K_BE_BENEFIT_PLAN_TYPE] (BPT)|
| 355201 | Plan Defn id (BPN) | From [P2K_BE_ENROLLMENTS] (BEN), it links to the [P2K_BE_PLAN_DEFINITION] (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
| 355202 | Plan_code (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355203 | Description (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355204 | Plan_access_code (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355205 | Established_date (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355206 | Participation_rule (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355207 | Policy_number (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355208 | Calc_sequence (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355209 | Plan_remit_seq (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355210 | Track_decline (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355211 | Last_remit_date (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355212 | Remit_by_state (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355213 | Remit_by_un_grp (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355214 | Remit_date_rule (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355215 | Remit_asof_day (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355216 | Print_zero_rule (BPN) | From [P2K_BE_PLAN_DEFINITION](BPN)|
| 355217 | Print_all_waivers (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355218 | Not_scheduled (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355219 | Plan_end_date (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355220 | Approval_required (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355221 | Plan den_id (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355222 | Plan dcl_id (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 355223 | Plan brm_id (BPN) | From [P2K_BE_PLAN_DEFINITION] (BPN)|
| 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
This page (revision-27) was last changed on 26-Nov-2021 10:22 by kparrottTop