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 435 changed 27 lines
| 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)|
| 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
| 355102 | Plan_type_code (BPT) | From [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)|
| 355103 | Description (BPT) | From [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)|
| 355104 | Calc_sequence (BPT) | From [P2K_BE_BENEFIT_PLAN_TYPES] (BPT)|
| 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
| 355202 | Plan_code (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355203 | Description (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355204 | Plan_access_code (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355205 | Established_date (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355206 | Participation_rule (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355207 | Policy_number (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355208 | Calc_sequence (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355209 | Plan_remit_seq (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355210 | Track_decline (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355211 | Last_remit_date (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355212 | Remit_by_state (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355213 | Remit_by_un_grp (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355214 | Remit_date_rule (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355215 | Remit_asof_day (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355216 | Print_zero_rule (BPN) | From [P2K_BE_PLAN_DEFINITIONS](BPN)|
| 355217 | Print_all_waivers (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355218 | Not_scheduled (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355219 | Plan_end_date (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355220 | Approval_required (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355221 | Plan den_id (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355222 | Plan dcl_id (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
| 355223 | Plan brm_id (BPN) | From [P2K_BE_PLAN_DEFINITIONS] (BPN)|
At line 463 changed 32 lines
| 355302 | Coverage_code (BCG) | |
| 355303 | Covg_remit_seq (BCG) | |
| 355304 | Policy_number (BCG) | |
| 355305 | Contact_role (BCG) | |
| 355306 | Covg muc_id (BCG) | |
| 355401 | Covg Detail id (BCGD) | |
| 355402 | Effective (BCGD) | |
| 355403 | Expiry (BCGD) | |
| 355404 | Remit_basis (BCGD) | |
| 355405 | Rate_basis (BCGD) | |
| 355406 | Description (BCGD) | |
| 355407 | Covg Detail pfq_id (BCGD) | |
| 355408 | Covg Detail dcr_id (BCGD) | |
| 355501 | Covg Rate id (BCGR) | |
| 355502 | Covg_step_code (BCGR) | |
| 355503 | Description (BCGR) | |
| 355504 | Up_to_limit (BCGR) | |
| 355505 | Next_step_code (BCGR) | |
| 355506 | Flex_amount (BCGR) | |
| 355507 | Premium1_rate (BCGR) | |
| 355508 | Premium2_rate (BCGR) | |
| 355509 | EE_deduct_rate (BCGR) | |
| 355510 | ER_contrib_rate (BCGR) | |
| 355511 | Taxben_rate (BCGR) | |
| 355512 | User1_rate (BCGR) | |
| 355513 | User2_rate (BCGR) | |
| 355514 | User3_rate (BCGR) | |
| 355601 | Ben Recip id (BBR) | |
| 355602 | Start_date (BBR) | |
| 355603 | End_date (BBR) | |
| 355604 | Benefit_percent (BBR) | |
| 355605 | Bond_participation (BBR) | |
| 355302 | Coverage_code (BCG) |From [P2K_BE_COVERAGES] (BCG) |
| 355303 | Covg_remit_seq (BCG) |From [P2K_BE_COVERAGES] (BCG) |
| 355304 | Policy_number (BCG) | From [P2K_BE_COVERAGES] (BCG)|
| 355305 | Contact_role (BCG) | From [P2K_BE_COVERAGES] (BCG)|
| 355306 | Covg muc_id (BCG) | From [P2K_BE_COVERAGES] (BCG)|
| 355401 | Covg Detail id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD) effective as of the As of Date parameter|
| 355402 | Effective (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355403 | Expiry (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355404 | Remit_basis (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355405 | Rate_basis (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355406 | Description (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355407 | Covg Detail pfq_id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355408 | Covg Detail dcr_id (BCGD) | From [P2K_BE_COVERAGE_DETAILS] (BCGD)|
| 355501 | Covg Rate id (BCGR) | From [P2K_BE_ENROLLMENT_DETAILS] (BEND) for this employee for this benefit plan, it specifies the [COVERAGE_STEP_CODE] to indicate the coverage step the employee has elected for the BE plan. [P2K_BE_COVERAGE_RATES] (BCGR) is retrieved for the BEND Benefit Coverage Detail and [COVERAGE_STEP_CODE]|This field returns the [BCGR_ID], you may use this id in derivation expression to return other value that is related to [BCGR_ID]
| 355502 | Covg_step_code (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355503 | Description (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355504 | Up_to_limit (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355505 | Next_step_code (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355506 | Flex_amount (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355507 | Premium1_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355508 | Premium2_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355509 | EE_deduct_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355510 | ER_contrib_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355511 | Taxben_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355512 | User1_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355513 | User2_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 355514 | User3_rate (BCGR) | From [P2K_BE_COVERAGE_RATES] (BCGR)|
| 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]
| 355602 | Start_date (BBR) | From [P2K_BE_BENEFIT_RECIPIENTS] (BBR)|
| 355603 | End_date (BBR) | From [P2K_BE_BENEFIT_RECIPIENTS] (BBR)|
| 355604 | Benefit_percent (BBR) | From [P2K_BE_BENEFIT_RECIPIENTS] (BBR)|
| 355605 | Bond_participation (BBR) | From [P2K_BE_BENEFIT_RECIPIENTS] (BBR)|
At line 527 changed 19 lines
| 358001 | Internal Table Desc1 | |
| 358002 | Internal Table Desc2 | |
| 358003 | Internal Table Desc3 | |
| 358004 | Internal Table Desc4 | |
| 358005 | Internal Table Desc5 | |
| 358011 | Internal Table Amt 1 | |
| 358012 | Internal Table Amt 2 | |
| 358013 | Internal Table Amt 3 | |
| 358014 | Internal Table Amt 4 | |
| 358015 | Internal Table Amt 5 | |
| 358021 | Internal Total for Amt 1 | |
| 358022 | Internal Total for Amt 2 | |
| 358023 | Internal Total for Amt 3 | |
| 358024 | Internal Total for Amt 4 | |
| 358025 | Internal Total for Amt 5 | |
| 358030 | UDF (EID) (35) | |
| 358031 | UDF (EEM) (35) | |
| 358032 | UDF (EASD) (35) | |
| 358033 | UDF (BPN) (35) | |
| 358001 | Internal Table Desc1 | |A temporary internal PL/SQL table is defined for the Generic Interface Program. This PL/SQL table holds up to 5 columns information. Each column has a description and an amount. Each amount can be totaled. Depending on each business requirement, the program will load information into this PL/SQL table for internal purpose, e.g. [UPROEF] uses this table to hold up to 52 Pay Periods in Desc1 column and the associated hours in Amount 1 column and earnings in Amount 2 column for each pay period. This PL/SQL table is not used for [UEEF]. This variable name returns the internal PL/SQL Table Column 1 description
| 358002 | Internal Table Desc2 | |Same as Internal Table Desc 1. This variable name returns Column 2 description
| 358003 | Internal Table Desc3 | |Same as Internal Table Desc 1. This variable name returns Column 3 description
| 358004 | Internal Table Desc4 | |Same as Internal Table Desc 1. This variable name returns Column 4 description
| 358005 | Internal Table Desc5 | |Same as Internal Table Desc 1. This variable name returns Column 5 description
| 358011 | Internal Table Amt 1 | |Same as Internal Table Desc 1. This variable name returns Column 1 Amount
| 358012 | Internal Table Amt 2 | |Same as Internal Table Desc 1. This variable name returns Column 2 Amount
| 358013 | Internal Table Amt 3 | |Same as Internal Table Desc 1. This variable name returns Column 3 Amount
| 358014 | Internal Table Amt 4 | |Same as Internal Table Desc 1. This variable name returns Column 4 Amount
| 358015 | Internal Table Amt 5 | |Same as Internal Table Desc 1. This variable name returns Column 5 Amount
| 358021 | Internal Total for Amt 1 | |Same as Internal Table Desc 1. This variable name returns Column 1 Total Amount
| 358022 | Internal Total for Amt 2 | |Same as Internal Table Desc 1. This variable name returns Column 2 Total Amount
| 358023 | Internal Total for Amt 3 | |Same as Internal Table Desc 1. This variable name returns Column 3 Total Amount
| 358024 | Internal Total for Amt 4 | |Same as Internal Table Desc 1. This variable name returns Column 4 Total Amount
| 358025 | Internal Total for Amt 5 | |Same as Internal Table Desc 1. This variable name returns Column 5 Total Amount
| 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
| 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
| 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
| 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
This page (revision-27) was last changed on 26-Nov-2021 10:22 by kparrottTop